Inside the model: all 16 linked Excel sheets
Every model generated by EasyFinancialModels is a single formula-linked Excel workbook with 16 sheets — a full three-statement model, DCF valuation and quality checks. Change any blue input on the Assumptions sheet and the entire workbook, including charts, recalculates.
A protected sample workbook downloads free from the generator, and any model up to 3 years downloads free and fully unlocked. Free 16-sheet linked Excel download for models up to 3 years (annual or quarterly, just your email). Models from 5 to 25 years are $29.98 per model download.
Watch: the model built in 5 minutes
▶ Watch the 1-minute video on YouTube
Sheet-by-sheet walkthrough
| 1. Cover | Branded cover with company, currency and model settings |
| 2. Assumptions | Every input in one place — the only hard-coded (blue) cells |
| 3. Revenue Model | Up to 3 revenue streams with growth or units × price builds |
| 4. Opex Schedule | Cost lines as % of revenue or monthly amounts, with inflation |
| 5. Capex Schedule | Primary and secondary CAPEX with maintenance capex |
| 6. Depreciation | Straight-line schedules and net book value |
| 7. Debt Schedule | Drawdown, interest, repayment, grace period and coverage |
| 8. Tax | Corporate tax with loss carryforward (NOL) |
| 9. Income Statement | Fully linked P&L from revenue to net income |
| 10. Cash Flow | Indirect-method cash flow tied to the other statements |
| 11. Balance Sheet | Balances every period — checked automatically |
| 12. DCF Valuation | WACC (manual or CAPM), Gordon-Growth terminal value, EV and IRR |
| 13. Sensitivity Analysis | Two-way WACC × growth and revenue × margin tables |
| 14. KPI Dashboard | Charts and key metrics including payback period |
| 15. Scenarios | Base, Best & Worst side by side with a live switch and variance |
| 16. Error Check | Live PASS/FAIL integrity tests before you share the file |
Why 16 sheets, and why linked
Separating the model into 16 focused sheets keeps each calculation auditable — a reviewer can open the Debt Schedule or the DCF without wading through an unrelated formula. Because every sheet is formula-linked rather than pasted as static values, changing one blue assumption cascades through revenue, costs, the three statements, the valuation and the charts at once. The Error Check sheet then runs live PASS/FAIL integrity tests — balance-sheet balance, cash-flow tie-outs and sign checks — so mistakes surface before you share the file, not after.
⚡ Generate your own model — free · Methodology · Pricing · How to build a financial model