SaaS Financial Model - ARR, Unit Economics, LTV/CAC & DCF Valuation (Excel)

Description
The SaaS Financial Model is an institutional-grade Excel model built to a rigorous value framework used by professional investors and advisors. It turns your customer, price and churn assumptions into monthly recurring revenue and ARR, tracks the unit economics that decide a subscription business (LTV, CAC, LTV to CAC and CAC payback), and flows through to three reconciled financial statements and a discounted cash flow valuation you can defend. The model reorganises the accounts into NOPLAT and invested capital, so you can measure the return on invested capital against the cost of capital and the economic profit the business creates. A one-switch scenario manager drives Base, Upside and Downside cases, and every calculation is independently verified: a live Checks dashboard reads MODEL OK with zero formula errors, the balance sheet balances every period, and cash reconciles. An executive dashboard summarises the headline metrics and charts at a glance. What you get: a protected, formula-driven Excel workbook (no macros), a scenario manager, a monthly and annual revenue build, unit economics, three linked statements, a ROIC and economic-profit engine, a DCF, a Sources and Audit tab, a live Checks dashboard, and a plain-English documentation guide. Single-seat commercial licence. Default inputs are illustrative and ready to replace with your own numbers.