B2B SaaS finance, runway & cap table models
MRR waterfalls, runway and burn, cap table dilution, sales capacity and SaaS health scorecards — the models founders and FP&A teams maintain between board meetings.
Who these models are built for
SaaS finance is unforgiving about arithmetic. ARR is a snapshot while cash is a flow; a valuation cap is not a valuation; net dollar retention can look healthy while gross retention quietly declines. These five models cover the metrics that appear in diligence, with the formulas exposed on the page and in the workbook so nothing is taken on faith.
- Seed to Series B founders
- FP&A analysts and finance leads
- VC platform and portfolio operations teams
- Fractional CFOs serving software companies
- Operators preparing a data room for the next round
MRR / ARR subscription waterfall model
New, expansion, contraction and churn resolved month by month into NDR, GRR, quick ratio and ARR growth — with a cohort retention tab and a board-ready dashboard.
mrr-arr-waterfall.xlsx · Monthly Waterfall Engine · Cohort Retention Curves · Executive Dashboard
Startup runway & burn rate calculator
Project cash month by month with compounding revenue growth, find your zero-cash date, and get the month by which you must open the next round.
runway-and-burn-model.xlsx · Executive Runway Summary · 24-Month Cash Waterfall · Departmental Headcount Plan
Cap table, SAFE conversion & dilution model
Model valuation caps, discounts and Series A conversion exactly as investors will, then see founder ownership and dilution before you sign the term sheet.
cap-table-and-safes.xlsx · Shareholder Ledger · SAFE Conversion Model · Post-Series A Dilution
Sales capacity & quota attainment model
Turn an ARR target into a hiring plan: ramp-adjusted AE capacity, pipeline coverage and the SDR headcount required to feed it.
sales-capacity-model.xlsx · AE Ramp-up Matrix · Pipeline Funnel Ratios · Revenue Capacity Output
SaaS quick ratio & Rule of 40 evaluator
Score six diligence-grade SaaS metrics — quick ratio, Rule of 40, magic number, CAC payback, NDR and GRR — against the thresholds investors actually apply.
saas-health-dashboard.xlsx · Quarterly Metric Ingestion · Benchmark Comparison · Investor Deck Charts
The six numbers a SaaS diligence process will test
- ARR, reconciled to the billing system. A snapshot at a point in time, not a sum of revenue. Contract billing timing does not change it, which is exactly why it is used.
- Net dollar retention — with gross retention beside it. NDR above 110% means the base compounds. GRR tells you whether you kept what you already had. Report both or the story is incomplete.
- Quick ratio. (New + expansion) ÷ (churn + contraction). Below 2x, growth is being consumed by churn and more sales capacity will not fix it.
- Magic number and CAC payback. Net new ARR per dollar of prior-quarter S&M spend, and the months of gross profit required to repay acquisition cost. Both are cash questions.
- Rule of 40. Growth percentage plus free cash flow margin. Use financial-statement revenue, not ARR, or the number cannot be tied back in diligence.
- Runway and burn multiple. Net burn against net new ARR. Under 1.5x is efficient. Start the next raise with nine to twelve months of runway, not six.
SaaS, venture finance and corporate banking sit at the top of the display advertising stack, and the audience arrives with budget authority — the highest-value combination available to a tool site.