Simple Cash Flow Model Excel Template
Originally published: 27/06/2017 08:32
Last version published: 10/05/2021 20:26
Publication number: ELQ-25943-5
View all versions & Certificate
certified

Simple Cash Flow Model Excel Template

A Simple Cash Flow Model template with a free video tutorial

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

Jacek Polewski offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

The objective of this plan is to explain drivers behind your business, user/revenue growth and your overall cash flows. The simply of the layout should allow you to expand it further and add more details (if required).

Fund Raising, Planning


4.7 / 5 (67 votes)

please wait...