Investor-grade financial model · Readiness report
A complete, tied-out five-year financial model and a page-by-page walkthrough of how to defend it — prepared on a fictional company so you can see exactly what you'll hold when you drop in your own numbers.
Four movements: we mirror your situation, analyze it tab by tab, show you the transformation, then hand you the action plan and the words to use.
Educational analysis and a spreadsheet template — not investment, legal, financial, or tax advice, and not a valuation opinion or an offer of securities. All figures are illustrative outputs of a deterministic model driven by the assumptions shown; change an assumption and every figure changes. Consult qualified professionals before making any financing or investment decision.
Six words from a partner at the fund you most want on your cap table.
You have a deck. You have a story that got you the meeting. You have a Google Sheet with a revenue tab and a cell that says "runway." What you do not have — yet — is a model: an integrated set of statements where the income statement flows into the balance sheet flows into the cash flow, where the metrics are computed from the same build, and where the balance check reads 0.00 so an analyst can't unravel it in ninety seconds.
That gap is the most common, most fixable reason a promising round stalls. It is not that your business is weak — the numbers below describe a company any seed investor would take a second meeting with. It is that the artifact you're being graded on doesn't exist in defensible form. This report shows you exactly what that artifact looks like, on a fictional company (Cadence Robotics, Inc. (FICTIONAL EXAMPLE)) whose profile was chosen to rhyme with yours — so that when you drop your own numbers into the cockpit, you already know what every page will say.
The sample company is deliberately a hardware-touched vertical SaaS, so its 74% gross margin carries hosting, support and device-side costs. That margin is a single cockpit driver, not baked into the structure — if you're pure software, you raise it (say to 85–90%) and every downstream figure recomputes. The three-statement build, ARR bridge, SaaS metrics and valuation tabs are identical for any recurring-revenue model; only the drivers change.
Because the fear is specific and the deadline is real. The rest of this report is built to make the fear go away in the order it shows up: first prove the model ties, then prove the metrics agree, then hand you the words to defend it live.
Read the next page first. It mirrors your situation back to you in five numbers — the same five an investor forms an opinion on before you finish your intro.
This is what a partner sees before you say a word. For Cadence Robotics, Inc. (FICTIONAL EXAMPLE), the engine computes:
Those are strong numbers — and that's the point. The business isn't the problem. The problem is that until this model exists, you can't prove any of them without contradiction. An NRR you claim in the deck but can't reconcile to the P&L is worth less than an NRR of 118% that falls out of a model that ties.
| Starting logos, Y1 new-logo count, ARPA, churn | → | Ending ARR of $1.8M in 2026, rising to $28.7M by 2030 |
| Monthly gross churn + expansion inputs | → | NRR settles at 118.5%, GRR at 88.6% |
| Blended CAC ÷ gross-profit per account | → | CAC payback of 4.9 months |
Every number on this page is a computed output of the model — see the tab it comes from later in the report. Change an assumption in the cockpit and each of these recomputes.
If you read nothing else before the meeting, read this. Every figure is a computed engine output.
| Dimension | 2026 | 2030 | Read |
|---|---|---|---|
| Ending ARR | $1.8M | $28.7M | 15.9× over the horizon |
| Recognized revenue | $992K | $15.8M | Driver-based, mid-year add convention |
| Net revenue retention | 118% | 118% | Above 100% — base grows itself |
| Gross revenue retention | 89% | 89% | The sticky floor |
| CAC payback (months) | 6.2 | 4.9 | Well under ~12mo |
| LTV : CAC | 16.1× | 20.4× | Above the 3× bar |
| Rule of 40 | 265 | 98 | Growth-carried early |
| Balance check (A − L − E) | 0.00 | 0.00 | Ties in all 5 years |
Screenshot it. It's the summary an investor forms in their head — now it's on paper, computed, and consistent with every statement behind it.
All figures are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE). Not a forecast or a recommendation.
Each of these has killed a raise. Each is fixed by structure, not by better numbers.
You don't need to become a CFO before the meeting. You need a model that removes each of these five failure modes, and a script for each question. That's the whole report.
Four movements, in the order your anxiety shows up.
A revenue projection you're calling a model, a balance sheet you can't make tie, metrics on a separate tab, and a partner meeting in days.
A tied-out five-year model you understand line by line, metrics that fall out of it, and a script for every question a partner asks.
Everything past this page is computed by the ModelKit engine from the Cadence Robotics, Inc. (FICTIONAL EXAMPLE) assumptions. When you buy the workbook, you replace those assumptions with yours and every page regenerates.
One tab of drivers. Every other tab is a formula off these. This is the only place you type numbers.
Investors don't argue with your outputs — they argue with your drivers. If your growth, retention and burn all trace back to a short list of assumptions you can each defend, the conversation moves from "is this made up?" to "is this rate right?" — a far better conversation to be having.
These are the drivers for Cadence Robotics, Inc. (FICTIONAL EXAMPLE). When you buy the kit, this is the one tab you edit; the nine tabs recompute from it.
The model assumes primary capital comes in during 2027 and 2029 — $14.0M then $30.0M. Those raises are inputs, not conclusions; they let the cash line stay positive so you can see what runway your plan actually requires. Your real rounds are set by your investors, not by this tab.
| A short list of drivers (this page + the last) | → | Every figure in the 9 tabs that follow |
| Change any one driver | → | All downstream statements & metrics recompute — nothing hard-coded |
| Starting cash $3.2M vs paid-in $3.8M | → | Opening retained-earnings deficit of $-600K — by the accounting identity, cash you've raised but no longer hold is prior losses (not a plug) |
A typed forecast ("we'll grow 2.4×") is a single number an investor can only accept or reject. A driver-based forecast decomposes that same growth into pieces you can each defend:
The rest of this report walks each of these from driver to output, so when a partner asks "where does this number come from?", the answer is always another number they can see, not "trust me."
A cockpit turns "defend your forecast" — an impossible ask — into "defend eight assumptions" — a Tuesday.
Assumptions shown are the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE) inputs. Your workbook ships with these as editable defaults; you overwrite them.
The one diagram that turns "a spreadsheet" into "a model." Follow a number from driver to output.
The difference between a projection and a model is flow: a change in one driver propagates through every statement. Understanding this flow is what lets you answer "what happens if…" without rebuilding anything — and it's what an investor is really testing when they ask how your model is built.
| Change one cockpit driver | → | Tabs 2→3→4→5/6→7→8 all recompute in order |
| The recompute finishes | → | Balance check still 0.00 — the wiring guarantees it |
Where your top line actually comes from: logos in, logos out, price per logo.
"Walk me through your revenue" is the first analytical question in most first calls. If you can point to a customer roll-forward — beginning + new − churned = ending — instead of a single growth rate, you've already answered the follow-up before it's asked.
| Revenue build — driver-based | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Beginning customers | 14 | 55 | 114 | 201 | 333 |
| + New customers | 46 | 71 | 110 | 171 | 265 |
| − Churned customers | 5.1 | 12.4 | 23.0 | 39.0 | 63.4 |
| Ending customers | 55 | 114 | 201 | 333 | 534 |
| ARPA (monthly) | $2,400 | $2,544 | $2,697 | $2,858 | $3,030 |
| Recognized revenue | $992K | $2.6M | $5.1M | $9.1M | $15.8M |
Recognized revenue is average customers × ARPA × 12, with new logos added mid-year (they earn half a year of revenue in the year they land). That mid-year convention is why Year-1 revenue of $992K is lower than 60 logos × ARPA would suggest — the model is conservative on the timing, which is exactly the direction you want to be conservative in front of an investor.
In 2026 the company starts with 14 logos, adds 46, and loses 5.1 to churn, ending at 55. New-logo adds grow 55%/year — so 46 becomes 71 the next year — which is what turns $992K of Year-1 revenue into $15.8M by 2030.
Logo churn of 1.2%/month compounds to roughly 13% of the base per year on an annualized basis. That is an input — you set it from your cohort data and can show the retention curve behind it. It is not a residual the model backed into.
Founders often quote a headline "we grow X%" and then can't say whether that's more logos, higher price, or less churn. This table forces the answer, so you're never caught not knowing which lever is doing the work.
| Starting logos (14) + Y1 new (46) | → | 2026 ending customers: 55 |
| New-logo growth 55%/yr | → | 2030 recognized revenue: $15.8M |
| ARPA $2,400/mo, +6%/yr | → | Exit ARPA: $3,030/mo |
ARPA starts at $2,400/month and grows 6%/year from price and expansion, reaching $3,030/month by 2030. Small ARPA growth is deceptively powerful: on a growing base it contributes materially to the $15.8M exit-year revenue without adding a single logo.
All revenue figures are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE). Mid-year add convention and monthly-compounded churn are stated so the method is auditable.
Beginning + new + expansion − churn = ending. The single most-requested SaaS exhibit.
The ARR bridge is the exhibit a growth investor asks for by name. It separates the four forces on your recurring revenue so they can see whether you're growing on new logos, expansion, or just outrunning churn — and whether that mix is healthy.
| ARR bridge (the roll-forward investors ask for) | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Beginning ARR | $403K | $1.8M | $4.3M | $8.7M | $16.1M |
| + New ARR | $1.3M | $2.2M | $3.6M | $5.9M | $9.6M |
| + Expansion ARR | $120K | $538K | $1.3M | $2.6M | $4.8M |
| − Churned ARR | $46K | $205K | $489K | $984K | $1.8M |
| Ending ARR | $1.8M | $4.3M | $8.7M | $16.1M | $28.7M |
The bridge closes in every year — beginning plus new plus expansion minus churn lands exactly on ending — which is one of the 217 automated checks. A bridge that doesn't close is the fastest way to signal a hand-built spreadsheet.
By 2030, expansion ARR of $4.8M more than offsets churned ARR of $1.8M on the base — which is the mechanical reason net revenue retention comes out above 100%. New ARR of $9.6M then stacks on top. That ordering — retain the base, expand it, then add new — is the story investors want to hear, and here it's a table, not a claim.
Churned ARR is computed from a 1.0%/month gross revenue-churn input compounded over the year, and expansion from a 2.2%/month input on the retained base. Because both are drivers, your gross retention (GRR) and net retention (NRR) can never contradict this bridge — they're computed from the same two numbers.
| Gross $ churn 1.0%/mo | → | 2030 churned ARR: $1.8M; GRR 88.6% |
| Expansion 2.2%/mo | → | 2030 expansion ARR: $4.8M; NRR 118.5% |
| The two above, combined | → | Bridge closes to ending ARR $28.7M — verified |
ARR bridge figures are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE). The bridge-closure check is one of the 217 automated assertions.
Revenue → gross profit → operating lines → the bottom line. Every line is arithmetic off the tabs before it.
Your P&L is where an investor checks whether your growth is affordable. The question behind every operating line is "what does it cost you to grow at this rate, and is that cost coming down as you scale?" This statement answers it in one view.
| Income statement | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Revenue | $992K | $2.6M | $5.1M | $9.1M | $15.8M |
| Cost of revenue (COGS) | $-258K | $-668K | $-1.3M | $-2.4M | $-4.1M |
| Gross profit | $734K | $1.9M | $3.8M | $6.8M | $11.7M |
| Gross margin | 74% | 74% | 74% | 74% | 74% |
| Sales & marketing | $-506K | $-781K | $-1.2M | $-1.9M | $-2.9M |
| Research & development | $-1.1M | $-1.1M | $-1.9M | $-3.5M | $-6.0M |
| General & administrative | $-520K | $-520K | $-813K | $-1.5M | $-2.5M |
| EBITDA | $-1.4M | $-499K | $-194K | $-52K | $236K |
| Depreciation | $-8K | $-29K | $-69K | $-142K | $-268K |
| EBIT | $-1.4M | $-527K | $-263K | $-195K | $-32K |
| Tax | -$0 | -$0 | -$0 | -$0 | -$0 |
| Net income | $-1.4M | $-527K | $-263K | $-195K | $-32K |
Gross margin holds at 74% — appropriate for a hardware-touched vertical SaaS. Sales & marketing is not a percentage guess; it is $11,000 of fully-loaded CAC × the new logos from Tab 2, so the P&L and the CAC metric can never disagree. R&D and G&A carry floors ($1.1M and $520K) because a team exists before the revenue does.
The company runs a planned loss while it invests: net income of $-1.4M in 2026 narrows to $-32K by 2030 as revenue scales past the R&D and G&A floors. EBITDA crosses from $-1.4M to $236K over the horizon. This is the shape an investor wants pre-profit: losses that shrink as a share of revenue, driven by operating leverage, not by cutting growth.
Because R&D and G&A have dollar floors while revenue compounds, their percentage of revenue falls every year. That falling percentage is the entire pre-profit SaaS thesis — you're buying growth now so the fixed base gets cheaper per dollar of revenue later — and here it's legible on three rows instead of asserted in a sentence.
| Gross margin 74%, CAC $11,000 | → | 2026 EBITDA $-1.4M → 2030 EBITDA $236K |
| R&D floor $1.1M, G&A floor $520K | → | Losses shrink from $-1.4M to $-32K |
| S&M = CAC × new logos (from Tab 2) | → | P&L S&M line reconciles exactly to the CAC metric on Tab 7 |
Income-statement figures are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE). Arithmetic (GP = rev − COGS; EBIT = EBITDA − dep; NI = EBIT − tax) is checked in every year.
The one test every investor runs first. Assets = liabilities + equity, or the model is broken.
This is the page that saves or sinks you. An analyst's first move is to check that assets equal liabilities plus equity. If there's a plug, you're done — not because your business is bad, but because you can't be trusted with the numbers. Here, the balance-check row reads 0.00 in every year.
| Balance sheet | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Cash | $2.4M | $16.4M | $17.1M | $48.7M | $51.8M |
| Accounts receivable | $141K | $366K | $724K | $1.3M | $2.2M |
| PP&E, net | $32K | $106K | $240K | $464K | $826K |
| Total assets | $2.6M | $16.9M | $18.1M | $50.5M | $54.9M |
| Accounts payable | $222K | $286K | $491K | $857K | $1.4M |
| Deferred revenue | $541K | $1.3M | $2.6M | $4.8M | $8.6M |
| Total liabilities | $763K | $1.6M | $3.1M | $5.7M | $10.1M |
| Paid-in capital | $3.8M | $17.8M | $17.8M | $47.8M | $47.8M |
| Retained earnings | $-2.0M | $-2.5M | $-2.8M | $-3.0M | $-3.0M |
| Total equity | $1.8M | $15.3M | $15.0M | $44.8M | $44.8M |
| Liabilities + equity | $2.6M | $16.9M | $18.1M | $50.5M | $54.9M |
| Balance check (A − L − E) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
The most common way a founder's balance sheet "ties" is a hidden cash plug — a formula that forces cash to whatever makes the sheet balance, quietly hiding an error. This model does the opposite:
Because every line has an independent source, the fact that assets still equal liabilities plus equity is evidence the whole model is consistent — not an assumption baked in. That is precisely the signal an investor is looking for.
| Starting cash $3.2M | → | 2026 cash $2.4M; opening RE deficit $-600K |
| DSO 52d / DPO 34d | → | 2030 AR $2.2M, AP $1.4M |
| Deferred rev 30% of ARR | → | 2030 deferred revenue $8.6M — a source of cash |
Deferred revenue rises to $8.6M by 2030 because 30% of ARR is annual prepay — customers paying you a year ahead. That's a genuine, defensible source of cash and a sign of pricing power; investors like to see it. Meanwhile DSO of 52 days means $2.2M sits in receivables at exit — cash you've earned but not collected, which the cash-flow statement accounts for honestly.
When the associate opens your model and the balance-check row reads 0.00, the meeting stops being an audit and starts being a conversation. You've bought yourself the benefit of the doubt on every other number.
Balance-sheet figures are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE). Total assets = cash + AR + PP&E and total liabilities = AP + deferred are checked as separate assertions.
The statement that answers the only question that can end your company: when do you run out?
Runway is the question behind the raise. An investor wants to see that you know your burn to the month and that this round buys a clear milestone. A cash-flow statement wired to the balance sheet turns "how much runway do you have?" from a nervous estimate into a number you point to.
| Cash flow (indirect) | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Net income | $-1.4M | $-527K | $-263K | $-195K | $-32K |
| + Depreciation | $8K | $29K | $69K | $142K | $268K |
| ± Change in AR | $-141K | $-225K | $-358K | $-579K | $-942K |
| ± Change in AP | $222K | $64K | $205K | $365K | $589K |
| ± Change in deferred rev | $541K | $750K | $1.3M | $2.2M | $3.8M |
| Cash from operations | $-770K | $91K | $961K | $2.0M | $3.7M |
| Capex | $-40K | $-103K | $-203K | $-366K | $-630K |
| Cash from investing | $-40K | $-103K | $-203K | $-366K | $-630K |
| Equity raised | $0 | $14.0M | $0 | $30.0M | $0 |
| Cash from financing | $0 | $14.0M | $0 | $30.0M | $0 |
| Net change in cash | $-810K | $14.0M | $757K | $31.6M | $3.0M |
| Ending cash | $2.4M | $16.4M | $17.1M | $48.7M | $51.8M |
This is the indirect method: start at net income, add back non-cash depreciation, adjust for working-capital movements (AR, AP, deferred revenue), then layer investing (capex) and financing (equity). Ending cash here equals the cash line on the balance sheet in every year — a continuity check, and another of the 217 assertions.
At the 2030 exit, cash-from-operations plus investing is positive — the business is cash-flow positive on operations, so runway is not the binding constraint. Ending cash reaches $51.8M after the planned raises of $14.0M and $30.0M. The point isn't the specific number — it's that runway is derived from the cash line, so it can't quietly disagree with the rest of the model.
Deferred revenue swings $3.8M of cash in 2030 — annual prepay financing your growth. AR growth uses $942K of cash as sales scale. These aren't rounding: they're the difference between a model that looks profitable and one that's actually solvent, and investors know to look for them.
| Raises $14.0M & $30.0M | → | Ending cash $51.8M at 2030 |
| Net income + working-capital swings | → | 2030 cash from ops $3.7M |
| Exit-year operating + investing cash | → | Cash-flow positive — runway not the constraint |
Cash-flow figures are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE). Ending cash = balance-sheet cash and beginning + net change = ending are checked every year.
The scorecard an investor already has in their head. Yours had better match — and agree with your statements.
Every one of these metrics has a standard definition an investor knows cold. The danger isn't a bad metric — it's a metric you compute differently than they do, or one that contradicts your P&L. Here, all of them fall out of the same build, so they physically can't disagree with the statements or each other.
| SaaS metrics — computed from the same build | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Ending ARR | $1.8M | $4.3M | $8.7M | $16.1M | $28.7M |
| ARR growth | 347.1% | 138.7% | 101.2% | 86.2% | 78.2% |
| Net revenue retention (NRR) | 118% | 118% | 118% | 118% | 118% |
| Gross revenue retention (GRR) | 89% | 89% | 89% | 89% | 89% |
| Blended CAC | $11,000 | $11,000 | $11,000 | $11,000 | $11,000 |
| CAC payback (months) | 6.2 | 5.8 | 5.5 | 5.2 | 4.9 |
| LTV : CAC | 16.1× | 17.1× | 18.1× | 19.2× | 20.4× |
| Magic number | 2.77 | 4.94 | 5.58 | 6.17 | 6.71 |
| Burn multiple | 0.58 | <0.01 | 0.00 | 0.00 | 0.00 |
| Net burn (annual) | $810K | $12K | $0 | $0 | $0 |
| Free cash flow | $-810K | $-12K | $757K | $1.6M | $3.0M |
| Rule of 40 (growth + FCF margin) | 265 | 138 | 116 | 104 | 98 |
Ending ARR grows from $1.8M to $28.7M. Every other row is derived from the statements you've already seen — which is why they reconcile by construction.
Burn multiple is shown to two decimals. A year that still shows a positive net burn but rounds to <0.01 is burning very little per dollar of new ARR — not literally zero — which is why the burn-multiple and net-burn rows stay consistent.
Net revenue retention (NRR) = (beginning ARR + expansion − churn) ÷ beginning ARR = 118.5%. Above 100% means your existing customers are worth more each year even before you add a single logo — the single most valuable property a SaaS business can have.
Gross revenue retention (GRR) = (beginning ARR − churn) ÷ beginning ARR = 88.6%. GRR strips out expansion, so it's the honest floor on how sticky you are. GRR is always ≤ NRR (checked as an assertion); the gap between them is the expansion you're earning.
| Expansion 2.2%/mo, churn 1.0%/mo | → | NRR 118.5%, GRR 88.6% |
| Definitional link to the ARR bridge (Tab 3) | → | Retention metrics reconcile to the bridge exactly |
Blended CAC = S&M ÷ net-new logos = $11,000 at exit. Because S&M is the same line on the income statement, this can't secretly disagree with the P&L.
CAC payback = CAC ÷ (ARPA × gross margin) = 4.9 months at exit — the number of months of gross profit per customer needed to earn the acquisition cost back. Under ~12 months is widely considered efficient; 4.9 is strong.
LTV : CAC = 20.4× at exit, where LTV = (ARPA × gross margin) ÷ monthly gross churn. The classic benchmark is ≥ 3×; this model sits well above it because churn is low and margin is healthy.
| CAC $11,000, ARPA $3,030/mo, GM 74% | → | CAC payback 4.9 months |
| Same S&M line as the income statement | → | Blended CAC reconciles to the P&L exactly |
Magic number = net-new ARR ÷ prior-year S&M = 6.71 at exit. Above ~0.75 says every S&M dollar is buying more than its share of new ARR — you should be spending more, not less.
Burn multiple = net burn ÷ net-new ARR = 0.00 at exit (the business isn't burning at exit, so the multiple is 0). It's the Bessemer/Craft-style "how much cash to add a dollar of ARR" — the cleanest single read on efficiency.
Rule of 40 = ARR growth % + FCF margin % = 98 at exit. Above 40 is the bar for a healthy growth-stage SaaS; early on, growth carries it (139 + -0 = 138 in 2027).
| Net-new ARR ÷ prior S&M | → | Magic number 6.71 |
| Net burn ÷ net-new ARR | → | Burn multiple 0.00 |
| ARR growth % + FCF margin % | → | Rule of 40 = 98 at exit |
You will not be the founder who computes NRR one way in the deck and another way in the model. Every number here is defined the way the investor defines it, computed from the statements they can see. That consistency is the credibility.
All metrics are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE); each definition is a standard public SaaS definition and is spot-checked against its formula in the test suite.
The bars investors carry in their heads — from public frameworks, not invented data.
A metric only means something against a bar. Knowing the standard thresholds — and where your model lands relative to them — lets you frame your own numbers before an investor frames them for you.
| Metric | Common public benchmark* | This model (exit) | Read |
|---|---|---|---|
| Net revenue retention | ~110%+ is strong for SMB/mid-market SaaS | 118.5% | Above the bar |
| Gross revenue retention | ~85–90%+ typical for healthy retention | 88.6% | In range |
| CAC payback | < ~12 months considered efficient | 4.9mo | Efficient |
| LTV : CAC | ≥ 3× is the classic rule of thumb | 20.4× | Above |
| Magic number | > ~0.75 → lean into spend | 6.71 | Lean in |
| Rule of 40 | ≥ 40 for a healthy growth-stage SaaS | 98 | Above |
*Benchmarks are widely-cited public rules of thumb (SaaS-metrics literature, YC/NVCA and Bessemer/Craft public frameworks), not proprietary datasets and not a claim about any specific cohort. "This model" figures are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE). Benchmarks vary by segment, stage and market; treat them as orientation, not targets.
Zoom from the P&L to a single logo — the level a sharp investor drills to.
Aggregate metrics can hide a broken unit. Investors test whether a single customer is profitable, and how fast. If your per-customer economics work, scale is just a growth question; if they don't, scale makes it worse.
| Per-customer economics (exit year) | Value |
|---|---|
| ARPA | $3,030/mo |
| Gross profit per customer (ARPA × GM) | $2,242/mo |
| Fully-loaded CAC | $11,000 |
| Months to recover CAC (payback) | 4.9 |
| Implied customer lifetime (1 ÷ monthly churn) | 100 mo |
| Lifetime gross profit ÷ CAC (LTV:CAC) | 20.4× |
A single Cadence Robotics, Inc. (FICTIONAL EXAMPLE) customer generates $2,242/month of gross profit and costs $11,000 to acquire — earned back in 4.9 months, then profitable for the rest of a ~100-month expected life. That's the engine of the whole model; everything above is this unit, multiplied and rolled forward.
| ARPA $3,030/mo × GM 74% | → | Gross profit $2,242/customer/mo |
| Gross $ churn 1.0%/mo | → | Implied lifetime ~100 months |
How to show you understand valuation without pretending your DCF sets your price.
The mistake is walking in with a single valuation number your DCF produced. The move is walking in fluent in how value is triangulated — a DCF next to a comparable-multiples band — so when a partner talks valuation, you speak their language instead of defending a number you invented.
| Valuation — method illustration | Value |
|---|---|
| Discount rate (WACC, illustrative) | 35% |
| Terminal growth (g) | 3% |
| PV of explicit-period FCF | $863K |
| Terminal value (undiscounted) | $9.8M |
| PV of terminal value | $2.2M |
| Enterprise value — DCF | $3.0M |
| Exit ARR | $28.7M |
| EV — comps 4× ARR (low) | $115.0M |
| EV — comps 10× ARR (high) | $287.4M |
Read the band, not the endpoints. The 4–10× forward-ARR band spans the whole cycle: 10× reflects a frothy, peak-multiple market, 4× a compressed one. Since the 2022–2023 reset, most growth-stage SaaS has priced toward the low end of that band, so a realistic mark for a company like this sits closer to $115M — with quality of growth (NRR, CAC payback, net burn) deciding where inside the band you land. Treat the top of the range as a ceiling from a hotter market, not a target, and confirm the live multiple against current comps at the time you raise. This is a method demonstration, not a valuation opinion.
A single DCF figure invites the question "what if your discount rate is wrong?" Here's the honest answer on this page instead of buried in a guide: the whole grid, computed by the same engine. Swing the WACC from 25% to 45% and terminal growth from 2% to 4%, and the DCF still lands between $1.6M and $6.3M — an order of magnitude below the comps band. That's the lesson, not a defect: an early-stage DCF is terminal-value dominated and can't reach where rounds actually price.
| DCF enterprise value (WACC ↓ · terminal growth →) | g = 2% | g = 3% | g = 4% |
|---|---|---|---|
| WACC 25% | $5.8M | $6.0M | $6.3M |
| WACC 30% | $4.1M | $4.2M | $4.4M |
| WACC 35% (base case) | $3.0M | $3.0M | $3.1M |
| WACC 40% | $2.2M | $2.2M | $2.3M |
| WACC 45% | $1.6M | $1.7M | $1.7M |
Every cell is a live output of the same engine, re-running the DCF at that WACC / terminal-growth pair on the Cadence Robotics, Inc. (FICTIONAL EXAMPLE) assumptions. Even the most generous corner ($6.3M) sits far below the $115.0M–$287.4M comps band — which is exactly why investors anchor early rounds on comps, not the DCF.
DCF at a 35% early-stage WACC and 3% terminal growth is shown to demonstrate the METHOD, not to assert a value. Early-stage DCF outputs are dominated by the terminal value and are extremely sensitive to inputs — investors anchor pre-Series-B rounds on comparable multiples and round norms, not a founder's DCF. Both are illustrative.
The DCF lands at $3.0M enterprise value; the comparable-multiples band (4×–10× exit ARR of $28.7M) lands at $115.0M–$287.4M. That's a huge gap — and it's the whole point.
An early-stage DCF is dominated by its terminal value and is wildly sensitive to the discount rate and growth assumptions; at a 35% WACC, the near-term losses barely register and the answer is essentially "whatever you assume happens after year five." That's exactly why investors don't price pre-Series-B rounds on a founder's DCF — they anchor on comps and round norms. Showing both, and knowing which one the room actually uses, is what makes you sound like an operator instead of a spreadsheet.
| Exit ARR $28.7M × 4–10× band | → | Comps EV $115.0M–$287.4M |
| FCF path + 35% WACC, 3% g | → | DCF EV $3.0M — terminal-value dominated |
| The gap between the two methods | → | The lesson: DCF is fragile early; comps + norms set the round |
Valuation figures are illustrative engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE), demonstrating method only. Not a valuation opinion, not investment advice.
"What if you miss?" is a question, not an attack. Walk in with the answer already modeled.
The founder who's already run the downside case is the founder investors trust with capital. Because everything is driver-based, you don't build a new model for each scenario — you change one number in the cockpit and every tab, statement and metric recomputes. Here are the three levers that move the outcome most.
| Lever (cockpit driver) | Base case | What moves if you change it |
|---|---|---|
| New-logo growth | 55%/yr | Exit ARR ($28.7M), revenue, and every efficiency metric scale with it |
| Gross $ churn | 1.0%/mo | NRR (118.5%), GRR (88.6%), LTV, and runway |
| Gross margin | 74% | Gross profit, CAC payback (4.9mo), EBITDA, and the whole cash path |
The stress case in ModelKit's test suite proves this works: with margin cut to 55%, logo churn quadrupled, and expansion near zero, the model still ties in every year — the structure holds even when the story turns ugly. That's the confidence you want walking into a downside question.
| Change new-logo growth in the cockpit | → | New exit ARR, revenue path, and efficiency metrics — instantly |
| Change churn or margin in the cockpit | → | New NRR/GRR/runway — statements re-tie automatically |
| Any scenario you build | → | Balance check stays 0.00 — the structure never breaks |
The goal is to look prepared, not scared. Lead with the base case as your plan. Introduce the conservative case as "and here's what we'd still deliver if we're wrong on growth" — proving the round is sound even off-plan. Keep the downside in your back pocket for the "what could kill you?" question, where a specific, modeled answer beats a vague reassurance every time.
You now have the whole analysis — every statement, every metric, every scenario. The next movement, Desire, shows what changes when you walk into your next investor conversation holding this instead of a spreadsheet you're hoping no one opens.
Scenario mechanics are properties of the engine, demonstrated on the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE). The stress case (55% margin, 4%/mo churn) is one of the three assumption sets in the 217-assertion test suite.
Same company, same numbers. The only thing that changed is the artifact in your hands.
Not "a spreadsheet." The feeling of walking into the room you were dreading and realizing you're the most prepared person in it.
Good is not a fancier model. Good is a model an analyst can't break and you can't be caught out on. Concretely, for a company like Cadence Robotics, Inc. (FICTIONAL EXAMPLE), "good" is:
A CFO can hand you a perfect model, but if you can't defend it live, it fails the moment you're asked a question. The walkthrough (page 54) exists so the answers are yours, not borrowed.
Most first analytical calls turn on a 90-second window: the associate opens your model, checks that it balances, spot-checks one metric against the statements, and forms a view of whether you can be trusted with capital. Everything before was story; this is the first test of substance.
All figures reference the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE) model built in this report.
For each thing an investor tests, here's what changes when you hold this model.
| What they test | Before | After |
|---|---|---|
| Does it tie? Balance sheet (p.20) | A plug you can't explain; the fear an analyst finds it | A − L − E = 0.00 in every year, from independent sources |
| Revenue story Revenue build (p.10) | A single growth rate typed into a cell | Logos × ARPA roll-forward → $15.8M exit revenue |
| Recurring-revenue quality ARR bridge & metrics (p.14/28) | "NRR ~130%" asserted, unverifiable | NRR 118.5% / GRR 88.6%, reconciled to the ARR bridge |
| GTM efficiency SaaS metrics (p.28) | "Our CAC is good" with no payback math | CAC payback 4.9mo, LTV:CAC 20.4×, from the P&L S&M line |
| What they test | Before | After |
|---|---|---|
| Capital efficiency SaaS metrics (p.28) | No burn-multiple or Rule-of-40 answer | Burn multiple 0.00, Rule of 40 = 98 |
| Runway Cash flow (p.24) | A single cell you're not sure about | Derived from the cash line; ending cash $51.8M |
| Valuation fluency Valuation (p.34) | A DCF number you'd defend and lose | Comps band + DCF as method; you let the room price it |
| Downside Sensitivity (p.38) | "What if you miss?" → a shrug | Modeled conservative & downside cases that still tie |
Every "before" is a moment of exposure; every "after" is a number you can point to. The transformation isn't better performance — it's the same performance, finally provable.
The model you build once doesn't expire after the partner meeting. It becomes the operating instrument you run the company on:
You stop being a founder who dreads the finance conversation and become one who reaches for the model to answer operating questions. That shift is worth far more than the price of the workbook — it changes how you run.
Illustrative of how a tied-out model is used; figures reference the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE).
Trace the arc this report is designed to produce. You arrived because a partner asked for a model you didn't have, and the deadline was days away. By the balance-sheet page you saw the one fear — the plug — disappear. By the metrics page you saw your claimed numbers become computed ones. By the sensitivity page you saw yourself answer the "what if you miss?" question you'd been avoiding.
That's the product. Not a spreadsheet — the difference between walking in hoping and walking in in command of your own numbers. The next two sections make that concrete: the roadmap from where you are to a funded round, and the exact words for every question you'll be asked.
After the meeting, the partner writes you up for their team. Here's the memo a tied-out model earns.
You're not really pitching the partner — you're arming them to pitch their partners. The clearer and more consistent your numbers, the easier that internal memo is to write, and the more likely it gets written favorably.
Illustrative of the memo a defensible model supports; not a real memo. Figures are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE).
The path, keyed to the model's own milestones. Dollars paired with proof.
Investors don't fund a number; they fund a plan to reach a number. Pairing each raise with the ARR milestone it buys turns your ask from "give us money" into "fund this milestone, here's the model that gets us there."
The strongest ask never leads with a valuation. It leads with a milestone and the capital to reach it: "We're raising to get from $1.8M to $4.3M ARR; here's the model that shows what that takes and what it produces." The valuation follows from the traction, and you've kept the conversation on the ground the model actually supports.
| Round frame | What the model supports |
|---|---|
| The milestone | $1.8M → $4.3M ARR |
| Retention proof | NRR 118.5% / GRR 88.6% |
| Efficiency proof | CAC payback 4.9mo |
| Capital efficiency | Burn multiple 0.00 |
| Your raise plan (cockpit financing rows) | → | Each raise paired with the ARR milestone it funds |
| Your metrics (from the build) | → | Proof points that make the milestone credible |
With the roadmap on the table, the meeting's center of gravity shifts. Instead of the partner probing whether your numbers are real, they start pattern-matching your milestones against companies they've funded — which is the conversation you want, because it's the one that ends in a term sheet.
Roadmap milestones are the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE) model's own outputs. Your milestones will be your model's outputs when you enter your numbers.
The model that wins the meeting is the same one that clears diligence — if you keep it current.
A soft yes turns into a term sheet, and then a diligence team opens your data room. The founders who close fast are the ones whose model didn't need a scramble — the tied-out model from the pitch is already the diligence model.
| Diligence item | What the reviewer checks | You're ready if… |
|---|---|---|
| Model integrity | Does A = L + E every period? | Balance check reads 0.00 (verified) |
| Metric reconciliation | Do deck metrics match the model? | NRR 118.5% etc. computed from the build |
| Actuals vs. plan | Does Year-1 tie to your books? | You reconciled the cockpit to actuals |
| Assumption support | Cohorts behind churn; capacity behind logos | Each driver has a source doc |
| Scenarios | Have you modeled the downside? | Base / conservative / downside saved |
Because the model is driver-based and tied out, "data-room ready" isn't a second project — it's the same workbook, kept current. That's the compounding payoff of building it right once.
The eight questions that decide most rounds — and the answer to each, in your words. This is the workbook's ninth tab — the "defend your assumptions" sheet — worked in full.
A model you can't defend is worse than no model. This is where the numbers become yours: for each thing an investor pushes on, a defense grounded in a driver you can point to. Rehearse these until they're reflex.
It isn't typed — new logos grow 55%/yr off a 46-logo Year-1 base you tie to rep capacity and pipeline. Show the driver, not the output.
NRR settles at 118.5% and GRR at 88.6% — driven by 1.0%/mo gross churn and 2.2%/mo expansion, both inputs you back with cohort data.
Blended CAC of $11,000 pays back in 4.9 months of gross profit; the magic number (6.71) and burn multiple (0.00) come from the same S&M line — they can't contradict the P&L.
Because it's hardware-touched SaaS — hosting, support and device-side costs. It's a driver: if yours is pure software, raise it and watch every downstream number improve.
Ending cash and runway are the balance-sheet cash line, not a separate guess. The business is cash-flow positive at exit, so runway isn't the binding constraint.
"Comparable growth-stage SaaS trades at 4–10× forward ARR; here's my ARR path and metrics against those comps." Let the room price it — never lead with a DCF number.
Change one driver in the cockpit — growth, churn, margin — and the whole model re-runs and still ties. Here's the conservative case and here's the downside; both keep the round sound.
Assets minus liabilities-plus-equity is 0.00 in every year. A model that doesn't balance is the fastest way to lose a diligence call — and this one is verified by 217 automated checks.
Notice the shape of every answer: it points to a driver or a computed line, never to "trust me." That's the entire trick — you're never defending a conclusion, only an assumption an investor can debate on the merits.
Defenses reference the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE) model's own drivers and outputs. When you enter your numbers, each answer updates to your figures.
Reading the defenses isn't enough — you want them automatic, so a hard question produces a calm number instead of a flinch. Two exercises before the meeting:
You have the model, the transformation, and the defenses. The final movement is logistics: exactly what to do in the next 72 hours, 30 days and 90 days, and the scripts to bring into the room.
Educational analysis and a spreadsheet template — not investment, legal, financial, or tax advice, and not a valuation opinion or an offer of securities. All figures are illustrative outputs of a deterministic model driven by the assumptions shown; change an assumption and every figure changes. Consult qualified professionals before making any financing or investment decision.
Ordered by deadline. The first list is what saves this week.
Enter your drivers and confirm the balance check is 0.00. That alone converts "a spreadsheet I'm hoping no one opens" into "a model that ties" — the difference the meeting turns on.
| Check | Target | Where |
|---|---|---|
| Balance check = 0.00 all years | 0.00 | Balance sheet |
| ARR bridge closes | ✓ | ARR bridge |
| NRR reconciles to bridge | 118% | Metrics |
| CAC = P&L S&M ÷ new logos | $11,000 | Metrics ↔ IS |
| Runway from the cash line | CF+ | Cash flow |
| Three scenarios saved | 3 | Cockpit copies |
| 60-sec walkthrough rehearsed | ✓ | You |
If every row is checked, you're more prepared than most founders who've raised twice. Walk in.
Word-for-word openers. Adapt to your numbers; keep the structure — number first, source second.
You're not being tested on whether your business is perfect. You're being tested on whether you know your own numbers cold. These scripts prove you do.
Scripts reference the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE) model. Replace the figures with your own after you enter your drivers.
So you compute each the way the investor does — no off-by-a-definition surprises. Keep this open in the meeting.
| Metric | Formula (as used here) | Exit value |
|---|---|---|
| Ending ARR | Beginning + New + Expansion − Churn | $28.7M |
| NRR | (Beginning ARR + Expansion − Churn) ÷ Beginning ARR | 118.5% |
| GRR | (Beginning ARR − Churn) ÷ Beginning ARR | 88.6% |
| Blended CAC | Sales & marketing ÷ net-new logos | $11,000 |
| CAC payback | CAC ÷ (ARPA × gross margin) | 4.9mo |
| LTV : CAC | [(ARPA × GM) ÷ monthly gross churn] ÷ CAC | 20.4× |
| Magic number | Net-new ARR ÷ prior-year S&M | 6.71 |
| Burn multiple | Net burn ÷ net-new ARR | 0.00 |
| Rule of 40 | ARR growth % + FCF margin % | 98 |
| Runway | Ending cash ÷ monthly net burn (exit rate) | CF+ |
These are standard public SaaS-metric definitions; each is spot-checked against its formula in the engine's test suite. Exit values are engine outputs for the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE).
Every one of these is avoidable — and every one has cost a founder a round.
All six share a root: an output that isn't traceable to an input. Fix that — make every number flow from a driver — and the mistakes disappear together.
A one-page brief so a professional can review your model fast — and so you get honest, in-scope advice.
ModelKit is an educational template, not a substitute for your accountant or counsel. Hand them this sheet with your completed workbook.
An integrated, driver-based five-year model that ties out, computes standard SaaS metrics from the statements, and illustrates valuation method. A defensible artifact to present and to operate on.
Investment, legal, financial, accounting or tax advice; a valuation opinion; or an offer of securities. It doesn't set your valuation or replace your professionals.
Educational analysis and a spreadsheet template — not investment, legal, financial, or tax advice, and not a valuation opinion or an offer of securities. All figures are illustrative outputs of a deterministic model driven by the assumptions shown; change an assumption and every figure changes. Consult qualified professionals before making any financing or investment decision.
The model doesn't retire after the round — it becomes how you report. Four slides straight from the tabs.
A board that sees the same numbers as your investors, month over month, trusts you more. Pulling the deck from the model means your board reporting can never contradict your fundraising story — the consistency compounds.
Because each slide reads from a tab, updating the board deck is updating the cockpit — a monthly habit, not a monthly project. That's the operating dividend of building the model once, correctly.
Illustrative board structure; figures reference the fictional Cadence Robotics, Inc. (FICTIONAL EXAMPLE).
You've seen the whole model. Here's how to be holding your own version by tomorrow.
The natural next step is the workbook: the same nine wired tabs you've just read, unlocked, so you drop your drivers into the cockpit and every page in this report regenerates on your numbers. If you'd like a second pair of eyes on the spreadsheet mechanics — how to wire your numbers in and make your balance sheet tie — the review-call tier adds a 45-minute working session (mechanics only; not round strategy, valuation, or investment advice).
The model is most valuable before the meeting, not after. The cost of the workbook is trivial against a stalled raise — and the calculator on the site estimates the credibility gap at stake for your own ARR.
ModelKit is built on public, checkable frameworks rather than a name you'd have to take on faith: standard three-statement mechanics, public SaaS-metric definitions, Damodaran-style DCF, YC/NVCA materials, and SEC/EDGAR & standard exchange-filing conventions. No client data and no resold source files went into it. Instead of asking you to trust a résumé, everything you'd use to judge it is open before you pay — this full 68-page worked sample, the raw computed JSON, and a runnable engine test that enforces 217 checks, including the balance identity (A − L − E = 0) in every year. If the math holds up under your own diligence, it holds up regardless of whose name is on it.
Educational analysis and a spreadsheet template — not investment, legal, financial, or tax advice, and not a valuation opinion or an offer of securities. All figures are illustrative outputs of a deterministic model driven by the assumptions shown; change an assumption and every figure changes. Consult qualified professionals before making any financing or investment decision.