Tools for Sale

 

Cash Flow Forecasting Tool

  • Covers a 12-month period, on a daily basis.
  • There are 2 versions. Both are included in the purchase price.
  • A static version where the user selects the 12 month period. Ideal for budgeting / scenario analysis.
  • A rolling version whereby the user’s computer system date determines the starting month. As a new month occurs, the model rolls over to have the new month as the first month. Used for keeping track of actual cash movements.
  • An opening cash balance is entered, as well as a threshold or “comfort” level of cash is entered. In the static version, an opening month is selected.
  • The user enters inflows and outflows, with any of the following characteristics:
  • Frequency: weekly, fortnightly, monthly, quarterly, half-yearly, annually, ad hoc
  • Within the above parameters, the user can also set any combination of the following: Whether the transaction occurs for the full 12 month period.

- A nominated start date.
- A nominated end date.
- The number of times a transaction occurs.
  • A sheet takes all the above data, and presents the effects of it in a schedule.
  • Net cash movements are shown for every day.
  • The current day is highlighted in green for easy reference.
  • Ending cash balance is shown for each day. If it falls below the threshold level, it appears in bold red font.
  • Monthly and year to date cash movements are shown at the bottom of the page.
  • A page shows the above in graphical form.
  • A detailed instruction page is included.

 

Please download the attached PDF for a demonstration, and pricing. If you wish to purchase the tool, please go the “Contact Us” section of this website.

 

Remember:

  • Features of financial models I build:
    • Email support is provided for free for as long as the tool is in use, the only condition being that the client does not alter the tool.

Contact Us