# Startup Valuation Model Build a startup forecast, estimate a fair valuation, and see how a funding round could play out for investors and founders. - Canonical: https://finamodel.com/templates/startup-valuation - Excel download: https://finamodel.com/templates/startup-valuation.xlsx - Category: Startups - Model type: Valuation - Difficulty: Intermediate - Audiences: Investors & analysts, Founders & operators, Venture capital investors, Startup founders, Angel investors, Early-stage analysts, Founders raising a round, Angel and VC investors, Corporate development teams - Tags: startup valuation, venture capital, cap table, moic irr, dcf, pitch deck, moic, irr ## Overview This startup valuation model turns a business plan into a practical discussion about price, ownership, and potential returns. Forecast revenue, hiring, costs, cash runway, and future funding needs before considering what the company could be worth. It is useful for founders preparing a raise and for investors reviewing an opportunity. Simple scenario planning shows how growth, margins, dilution, and exit assumptions can change the outcome. ## What's included - Round and exit terms: pre-money, raise, future dilution, exit year, exit revenue and EBITDA multiples, exit net debt - Valuation inputs: WACC, cost of equity, terminal growth, net debt today, headline method - Revenue engine: opening customers, ARPU and expansion, new logos and growth, churn, services and other streams - Headcount: opening FTEs by department, a per-year hire schedule, salaries, benefits load - Cost and cash: COGS by stream, marketing and other G&A, tax rate, starting cash, two funding rounds - Scenario toggle: Base, Bull, Bear flexing growth, churn, hire pace, exit multiples and dilution via CHOOSE - Revenue sheet: three-stream 60-month forecast with MRR, ARR, and LTV/CAC - Headcount sheet: department FTE build and monthly payroll - P&L sheet: monthly income statement from revenue to net income - Cash and Runway sheet: monthly cash roll, two funding rounds, burn, and runway months - Annual Financials sheet: FY1 to FY5 roll-up plus year-end metrics - Valuation sheet: exit-multiple equity value discounted to today, plus a DCF cross-check - Returns sheet: post-money, entry ownership, dilution, exit proceeds, MOIC and IRR - Dashboard with post-money, implied fair value, premium or discount, ownership, exit equity, MOIC, IRR, an annual path, and a P&L bridge - Valuation inputs: WACC, cost of equity, terminal growth, net debt today, headline method (multiple, DCF, or average) - Revenue engine: opening customers, ARPU and ARPU expansion, new logos and logo growth, churn, services and other streams - Headcount: opening FTEs by department, an explicit per-year hire schedule, salaries by department, benefits load - Cost and cash: COGS by stream, marketing % of revenue, other G&A, tax rate, starting cash, two funding rounds - Scenario toggle: Base/Bull/Bear (Scenario_Index) flexing growth, churn, hire pace, exit multiples and dilution via CHOOSE - Headcount sheet: department FTE build on the hire schedule and monthly payroll - P&L sheet: monthly income statement from revenue through COGS, opex, EBITDA, tax, to net income - Cash_and_Runway sheet: monthly cash roll, two funding rounds, net burn, and runway months - Annual_Financials sheet: FY1-FY5 roll-up of the monthly statements plus year-end metrics - Valuation sheet: exit-multiple equity value discounted to today, with a DCF cross-check - Returns sheet: post-money, entry ownership, dilution to exit, exit proceeds, gross MOIC and IRR - Dashboard with post-money, implied fair value, premium/discount, ownership, exit equity, MOIC, IRR, an annual revenue/EBITDA path, and a P&L bridge - 60-month operating forecast: revenue engine, five-department headcount build, P&L and a cash / runway roll - Swappable revenue engine - recurring (SaaS / ARR), take-rate (marketplace) or unit-volume (DTC / hardware) - Annual roll-up of the monthly statements with year-end metrics - Multiple-based implied fair value (exit metric x multiple, discounted to today) with a DCF intrinsic cross-check - Returns waterfall: round terms to post-money, entry ownership, dilution, exit proceeds, MOIC and IRR - Scenario toggle (Bull / Base / Bear via CHOOSE) and a Checks sheet of cross-statement validations ## Startup Valuation Model: How the Template Prices a Round and Estimates Returns This startup valuation model links a pitch-deck forecast to entry price, ownership, and investor returns. It builds a monthly operating engine, then anchors value on a forward exit multiple with a DCF cross-check. Use the template to see which drivers move the deal and where the forecast is most sensitive. ### Operating forecast: how the monthly engine works The forecast runs monthly over sixty months across three revenue streams. Subscription revenue is the core: new logos compound at a growth rate, ARPU compounds through expansion, and churn reduces the customer base each month, so ending customers become the basis for recurring revenue. - Services and other revenue sit alongside, and the model reports MRR and ARR plus SaaS unit economics including LTV and CAC. Costs follow a five-department headcount build rather than a percentage of revenue, driven by a hire schedule and salaries. - That produces a genuine J-curve into profitability rather than a locked margin, and it means you can see how staffing choices interact with revenue timing. ### Scenario switching and the assumptions anchor All inputs sit on an Assumptions sheet and are controlled by a scenario toggle. Scenario values are stored as three-tuples, one each for a bull, base, and bear case, and the selected index drives the model through a CHOOSE function, so switching scenarios re-anchors every dependent calculation in one step. - The inputs cover traction, hiring, salaries, round terms, and exit multiples. The cloning interface uses a single configuration block to re-anchor every blue input for a new company, while the structural sheets below remain identical, which is what keeps valuation, returns, and dashboard outputs consistent across versions. - Named ranges are registered dynamically, so you can extend assumptions without rebuilding the links. ### Calculation flow from forecast to fair value The monthly engine feeds an income statement where revenue flows through COGS to gross profit, then operating expenses with operating-leverage compression, to EBITDA, then tax with net operating loss awareness, to net income. A monthly cash roll adds net income and two funding rounds to reach ending cash, net burn, and runway months. - Annual financials roll those monthly statements into five fiscal years with year-end metrics. Valuation then applies the exit multiple to a revenue, EBITDA, or average metric, subtracts exit net debt, and discounts the result to today at cost of equity; a DCF discounts unlevered cash flow at WACC with a Gordon terminal. - Returns convert round terms into entry ownership, then show exit ownership after dilution. ### Outputs, checks, and how to use the model The dashboard surfaces headline KPI cards: post-money, implied fair value, the premium or discount to entry, ownership, exit equity, MOIC, and IRR, alongside an annual revenue and EBITDA path and a P&L bridge. - The Checks sheet validates cross-sheet ties including statement tie-outs, round arithmetic, ownership bounds, positive exit equity, terminal growth below WACC, and positive DCF enterprise value. - Use the model to compare an asking price with implied fair value, to see how dilution and exit assumptions drive investor returns, and to test which drivers matter most. - Be aware of documented simplifications: there is no capex or D&A line and no working-capital mechanic. ## Priced off multiples, cross-checked with a DCF Early-stage deals are priced off forward revenue and EBITDA multiples, not intrinsic DCF, because a DCF on a pre-profit company is almost all terminal value. The headline implied fair value comes from exit metric times exit multiple discounted to today at the cost of equity, and the DCF runs alongside as a conservative cross-check that is flagged as such. ## A returns waterfall, not just a valuation The Returns sheet turns the valuation into what a new investor earns: post-money equals pre-money plus raise, entry ownership equals raise over post-money, that stake dilutes to exit, exit proceeds equal exit ownership times exit equity, and gross MOIC and IRR fall out, with the premium or discount paid versus implied fair value reported next to them. ## Designed for one-edit responsiveness Every driver is a named-range cell and a single Scenario_Index toggles Base, Bull, and Bear through CHOOSE. Edit one input or flip the case and the revenue engine, headcount, P&L, cash, annual roll-up, valuation, returns, and dashboard all recompute. No formula rewrites are needed to test a growth, churn, pricing, or dilution scenario. ## Workbook structure ### Cover Workbook overview, sheet legend, units, and tab-colour key. - Title and scope framing - Sheet-by-sheet purpose summary - Units and tab-colour legend ### Dashboard Headline valuation, returns, and operating path. - Post-money, implied fair value, premium or discount - Ownership, exit equity, MOIC, IRR - Annual revenue and EBITDA path - Revenue-to-net-income P&L bridge ### Assumptions Every driver in one sheet with a Base, Bull, Bear toggle. - Scenario index and round and exit terms - Revenue engine, churn, and ARPU expansion - Hire schedule, salaries, and benefits - Cost stack, tax, starting cash, and funding rounds - WACC, cost of equity, terminal growth, net debt ### Revenue Three-stream monthly forecast. - Subscription customers, ARPU, and churn - Services and other revenue streams - MRR and ARR - LTV and CAC unit economics ### Headcount Department FTE build and payroll. - Opening FTEs by department - Per-year hire schedule by department - Salaries and benefits - Monthly payroll ### P_and_L Monthly income statement. - Revenue from the Revenue sheet - COGS by stream and gross profit - Payroll, marketing, and other G&A - EBITDA, tax, and net income with margins ### Cash_and_Runway Cash roll and runway. - Opening cash and monthly net income - Two funding-round inflows - Ending cash and net burn - Runway months and cash-out check ### Annual_Financials Yearly roll-up FY1 to FY5. - Annual income statement - Annual cash flow - Year-end key metrics: ARR, customers, FTEs, LTV/CAC ### Valuation Exit multiple with a DCF cross-check. - Exit-year revenue and EBITDA - Exit equity from metric times multiple less net debt - Discounted to today at the cost of equity - Intrinsic DCF: unlevered FCF, terminal value, equity value - Headline implied fair value ### Returns New-investor entry, dilution, and exit. - Pre-money, raise, and post-money - Entry ownership and dilution to exit - Exit proceeds - Gross MOIC and IRR - Premium or discount versus fair value ### Checks Cross-sheet validation suite. - Statement tie-outs and cash roll - Round arithmetic and ownership bounds - Exit equity and terminal growth below WACC - Positive DCF and headline fair value ## Features - **Priced off multiples, cross-checked with a DCF:** Early-stage deals are priced off forward revenue and EBITDA multiples, not intrinsic DCF - a DCF on a pre-profit company is almost all terminal value. The headline implied fair value comes from exit metric times exit multiple discounted to today at the cost of equity, while the DCF runs alongside as a conservative sanity check and is flagged as such. - **A real returns waterfall, not just a valuation:** The Returns sheet turns the valuation into what a new investor actually earns: post-money equals pre-money plus raise, entry ownership equals raise over post-money, that stake dilutes to exit, exit proceeds equal exit ownership times exit equity, and gross MOIC and IRR fall out - with the premium or discount paid versus implied fair value reported alongside. - **Headcount-driven operating leverage:** Opex is an audited headcount build (departments times a hire schedule times salaries), not a flat percentage of revenue, so the model produces a genuine J-curve into profitability instead of a locked margin. A Base/Bull/Bear toggle flexes growth, churn, hire pace, exit multiples and dilution in a single click. - **Valuation that matches how deals are priced:** Early-stage deals are priced off forward-revenue multiples, not intrinsic DCF, so the headline implied fair value is exit metric x exit multiple discounted to today, with the DCF running alongside as a conservative sanity check. - **A real J-curve, not a locked margin:** Opex is an audited headcount build (departments x hire schedule x salary), not a flat percentage of revenue, so the model produces a genuine path into profitability instead of a fixed margin. - **Round terms straight to investor returns:** Post-money = pre + raise; entry ownership = raise / post-money; exit ownership = entry x (1 - future dilution); proceeds, MOIC and IRR fall out, alongside entry valuation versus implied fair value. ## Use cases - **Price a round:** Set the operating drivers, the round terms, and an exit multiple, and read post-money, implied fair value, and the premium or discount the round is being priced at versus intrinsic value. - **Size investor returns:** Read entry ownership, dilution to exit, exit proceeds, gross MOIC and IRR for the new money, and test how a larger raise or more future dilution changes the outcome. - **Scenario and sensitivity:** Flip Base/Bull/Bear to flex growth, churn, exit multiple and dilution together, and watch valuation, MOIC, IRR, and the path to EBITDA breakeven move in step. - **Pricing a round:** Compare the round's post-money against the model's implied fair value to see whether the entry price sits at a premium or a discount. - **Investor return analysis:** Run MOIC and IRR on a single exit under Bull, Base and Bear scenarios to size the return for backing the company at this round. - **Founder fundraising prep:** Tie the operating forecast, runway and ownership math together so the raise, the use of funds and the dilution story are internally consistent. ## Frequently asked questions ### What is a startup valuation model? A startup valuation model values a single early-stage company and the returns a new investor makes backing it at a round. It forecasts a 60-month operating plan, derives an exit equity value from an exit multiple, discounts it to today for an implied fair value with a DCF cross-check, and walks the round terms to entry ownership, dilution, exit proceeds, gross MOIC, and IRR. ### Why a multiple, not a DCF, as the primary anchor? Early-stage companies are priced off forward revenue or EBITDA multiples because a DCF on a pre-profit business is almost entirely terminal value and swings with small WACC and growth changes. The model leads with exit metric times exit multiple discounted to the cost of equity, and runs the DCF alongside as a conservative cross-check rather than the headline. ### How are MOIC and IRR calculated? Post-money equals pre-money plus the raise, and entry ownership equals the raise divided by post-money. That stake dilutes by the assumed future dilution to an exit ownership, exit proceeds equal exit ownership times exit equity, gross MOIC equals proceeds over the raise, and IRR equals MOIC to the power of one over the holding years, less one. ### What does the scenario toggle change? A single Scenario_Index cell (1 Bull, 2 Base, 3 Bear) drives CHOOSE formulas across the assumption set, flexing logo growth, ARPU expansion, churn, hire pace, exit multiples, and future dilution at once. Every downstream sheet, valuation, and returns figure recomputes so the whole case moves coherently. ### Can I use it for a marketplace or non-SaaS startup? Yes. The revenue engine is mode-agnostic, with stream-one revenue equal to accounts times revenue per account times transactions times a take rate, so the same template covers a SaaS recurring model, a marketplace take-rate model, or a unit-volume DTC model by re-anchoring the input block. For a non-SaaS deck, right-size the headcount build so opex matches the business. ## Related templates - [Startup Financial Model](https://finamodel.com/templates/startup-financial-model) - [Venture Capital Fund Model](https://finamodel.com/templates/venture-capital-model) - [DCF Model](https://finamodel.com/templates/dcf-model) - [Pre-Seed Startup Financial Projection Model](https://finamodel.com/templates/pre-seed-pitch-model)