Simple Cash Flow Model Excel Template

A Simple Cash Flow Model template with a free video tutorial

by Jacek Polewski
Financial Modelling and Data Analysis ConsultantFollow 87

67 reviews3,985 views|1 comment|Bookmark download for free

Description
This Simple Cash Flow Excel Model Template can be used by an early-stage company for financial planning or/and fundraising.

The detailed cash flow model starts with the user projections on the top followed by simple revenue calculations (e.g. multiplying the number of users x monthly revenues assumptions, then by cost calculations (direct/variable and fixed salaries and general opex) and finally by CAPEX.

The numbers are then aggregated into an annual view and the summary is used to generate simple equity returns to estimate the potential feasibility of the project of a business venture.

The model also contains simple graphs to aid visualisation and the presentation of the output.

The workbook consists of:
- Table of Contents with links to individual sheets
Assumptions / Inputs Page — A list of main drivers of growth in costs and revenue. It takes into account factors that can affect monthly income, such as one-off charges, recurring fees, and the cost of employee salaries.
- Cash Flow Model — Monthly calculations of costs and revenue over a 60-month period.
- Summary and Returns — A summary of the findings of the cash flow model. It clearly presents your total revenue, cash flow, and return on investments.
Graphs — Visualises the main output and metrics of the cash flow model.

- Jacek Polewski

This Best Practice includes
1 Excel File