Main Article Content
A program that keeps record of personal financial details and also mines the data for insightful analysis is definitely a good day-to-day companion. In this generation, such tool is inevitable in the financial dealings of any individual or company. In this study, we developed an easy but highly intuitive method of tracking financial dealings, budgeting and forecasting personal financial expenditure using Microsoft Excel®. Among others, this program can aid in implementing financial strategies designed to meet specific goals based on percentages in specific categories. From such data, mathematical models were also developed and prediction was made. With little or no modification, the Cash flow program presented in this study could be adopted for use in any type of the organisation where money or any article of business comes in and goes out in a particular cycle (typical of which is monthly). Results and method presented here proved to be effective.
Keywords: Cash flow, Microsoft Excel, budget, forecast.
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).