A Simple Monthly Cash Flow Template. The model contains the following Excel sheets:
- Contents Page
- Assumptions Page — This page lists the main drivers of growth in costs and revenue. It considers factors affecting monthly income, such as one-off charges, recurring fees, and employee salaries.
- Cash Flow Model — The cash flow model details factors affecting costs and revenue in each month of the year over 60 months.
- Summary and Returns — This page summarises the findings of the cash flow model. It presents your total revenue, cash flow, and return on investments.
- Graphs — Like the Summary and Returns page, the Graphs section of the model is designed to help you understand and visualise your business data.
The formulas used to create this spreadsheet model include IF (conditional statements), SUMIFs, relative and absolute referencing, and IRR and DATE functions.