Excel workbook
Business Valuation & Cash Flow Forecaster: Five-Year Three-Statement Model With a DCF in Excel
Enter last year and a few drivers; get linked statements that balance, a DCF value, and a grid showing how much the answer moves with your assumptions.
$49 one time · example and blank copies · download link by email
Who it is for
Owners weighing a purchase or sale, or planning a budget, and bookkeepers building a simple model for a client.
Why it is different
- Cash is the result of the cash flow statement, not a plug, so the balance check is a real test.
- No circular references; interest is on the opening balance.
- A filled example and a blank copy with working formulas.
What is inside
- Assumptions. Year 0 actuals and the drivers for years 1 to 5: growth, margins, working-capital days, capex, tax, debt.
- IS, BS and CF. Three linked statements with a balance check that must be zero.
- DCF. Free cash flow, discounting, terminal value, enterprise and equity value, and an exit-multiple cross-check.
- Sensitivity. Enterprise value across discount rates and growth rates.
- Checks. Balance, negative cash and discount-rate tests.
A look inside
Example data, real formulas
Get it
Business Valuation & Three-Statement Cash Flow Forecaster
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. A model is only as good as its inputs, and small changes in the discount rate or growth move the value a lot. Not investment, tax, valuation or accounting advice. For a purchase, sale or loan, ask a qualified professional. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others