Excel templateFree · about 45 min to fill in
3-year financial forecast
An income statement and a cash flow plan, both calculated from a single page of assumptions.
The file is in French.
Get the template for freeWhat the template contains
- An Assumptions tab: revenue, growth, gross margin, headcount, expenses, capital expenditure, working capital, fundraising
- Calculated income statement: gross margin, EBITDA, profit before tax, net profit
- Cash flow plan with the change in working capital and an automatic alert if cash turns negative
- Number of months of cash left while EBITDA is negative
- Every formula is visible and editable
An investor does not believe a 3-year revenue figure as such: they check whether the assumptions that lead to it are consistent with one another. This template therefore separates the assumptions (what you decide) from the calculations (what follows from them).
The pre-filled values are examples. Tax is simplified (no loss carry-forward): have your forecast checked by your accountant.
Read also
Finance7 min read
Pre-money, post-money, dilution: the practical guide
Three concepts, two formulas and a worked example to know exactly what you are giving up.
Read the article