SaaS Finance Templates
Every template here is two things: a live calculator you can use in the browser, and an Excel file with working formulas you can download. No email, no signup. Change the blue input cells and everything recalculates.
Fundraising and ownership
Fundraising (how much to raise) template
Raise size from burn, hires, growth and a runway target, with dilution, use of funds and the numbers for your financial slide.
Open calculator → Excel (.xlsx)Cap table template
Founders, option pool and each priced round, with ownership after every round.
Open calculator → Excel (.xlsx)Equity dilution template
Raise, pre-money and pool top-up per round, and what you keep after Seed, A and B.
Open calculator → Excel (.xlsx)SaaS valuation template
Low, mid and high valuation from ARR, growth, NRR and Rule of 40, plus pre- and post-money.
Open calculator → Excel (.xlsx)Liquidation preference waterfall template
Who gets what at a given exit price: 1x or 2x, participating, capped and senior terms.
Open calculator → Excel (.xlsx)Down round and anti-dilution template
Broad-based, narrow-based and full ratchet conversion prices after a down round.
Open calculator → Excel (.xlsx)R&D tax credit worksheet
Alternative simplified credit, Section 280C election and the payroll tax offset, from four years of qualified research expenses.
Open calculator → Excel (.xlsx)Data room checklist and readiness score
78-item due diligence checklist by folder and stage with owner and status columns, a live readiness score and a folder structure.
Open calculator → Excel (.xlsx)Delaware franchise tax worksheet
Authorized Shares vs Assumed Par Value Capital method, side by side.
Open calculator → Excel (.xlsx)Cash, budget and planning
SaaS budget and rolling forecast template
12-month budget from revenue drivers, headcount and opex, then budget vs actual and a rolling forecast as months close.
Open calculator → Excel (.xlsx)13-week cash flow forecast template
Weekly receipts and payments for the next quarter, with payroll weeks, a minimum cash line and a rolling re-forecast as weeks close.
Open calculator → Excel (.xlsx)Burn rate and runway template
Gross and net burn, months of runway and the cash-out month with revenue growth.
Open calculator → Excel (.xlsx)Hiring plan template with fully loaded employee cost
24-month hiring plan by role, state and start month, fully loaded cost per head from 2026 US employer taxes, and the runway one more hire costs.
Open calculator → Excel (.xlsx)Employee cost (payroll) template
Salary plus 2026 US employer taxes and benefits, EOR abroad and payroll software fees.
Open calculator → Excel (.xlsx)Scenario planning template
Base, upside and downside cases for revenue, burn and runway.
Open calculator → Excel (.xlsx)Break-even template
The revenue and customer count at which a SaaS covers its fixed costs.
Open calculator → Excel (.xlsx)SaaS P&L (income statement) template
Monthly SaaS P&L with subscription, usage and services revenue, SaaS COGS, opex by department and KPI rows.
Open calculator → Excel (.xlsx)3-year financial projections template
Pro forma income statement, cash flow and key SaaS metrics for three years from revenue, headcount and cost drivers.
Open calculator → Excel (.xlsx)P&L and net income template
Revenue to gross profit, operating income and net income, with margins.
Open calculator → Excel (.xlsx)Cash flow forecast template (12 months)
Monthly direct-method cash forecast: collections with a DSO lag, annual invoices, payroll, bills on terms, financing, minimum cash and cash vs P&L.
Open calculator → Excel (.xlsx)Month-end close checklist
35 close tasks by business day, from bank recs and the deferred revenue roll-forward to flux analysis and the reporting pack.
Open checklist → Excel (.xlsx)Year-end close checklist
54 close tasks in 10 areas, from deferred revenue to 409A and Section 174A tracking, with owner and due columns.
Open checklist → Excel (.xlsx)Startup tax calendar 2027
Every 2027 federal and Delaware deadline for a calendar-year C-corp, as a calendar you can import.
Open checklist → Calendar (.ics)Revenue and growth
Investor update and board report template
Monthly KPI sheet with derived MRR growth, NRR, GRR, runway and burn multiple, plus the update email text.
Open calculator → Excel (.xlsx)MRR and revenue forecast template
New, expansion and churned MRR month by month, with ending MRR and ARR.
Open calculator → Excel (.xlsx)ARR waterfall (ARR bridge) template
Beginning to ending ARR through new, expansion, contraction and churn.
Open calculator → Excel (.xlsx)Sales capacity and quota plan template
AE quota, attainment, ramp and hire dates turned into monthly bookings capacity.
Open calculator → Excel (.xlsx)Sales commission plan template
Base, OTE and quota to commission rate, accelerators, payout at 50 to 150% of quota, and cash payback per rep.
Open calculator → Excel (.xlsx)Trial-to-paid funnel template
Visitors to trials to paying customers, new MRR, blended CAC and payback.
Open calculator → Excel (.xlsx)CAGR template
Compound annual growth rate between any two values over any number of years.
Open calculator → Excel (.xlsx)Unit economics and metrics
SaaS unit economics template
LTV, CAC, LTV:CAC and CAC payback from ARPA, margin and churn.
Open calculator → Excel (.xlsx)LTV and LTV:CAC template
Customer lifetime value and the LTV:CAC ratio with a health verdict.
Open calculator → Excel (.xlsx)CAC payback template
Months of gross profit it takes to earn back what a customer cost to acquire.
Open calculator → Excel (.xlsx)Churn cost template
Churn split by voluntary and failed payments, 12-month cost, a 1-point cut with a valuation estimate, and a recovery scenario.
Open calculator → Excel (.xlsx)Rule of 40 template
Growth plus margin score, with Rule of 50 and Rule of X.
Open calculator → Excel (.xlsx)SaaS magic number template
Net new ARR per dollar of sales and marketing spend.
Open calculator → Excel (.xlsx)Price increase and pricing model template
Break-even churn for a price rise, 12-month MRR and NRR effect, and seat vs usage vs hybrid revenue and margin.
Open calculator → Excel (.xlsx)AI cost and margin template
Token costs per customer, AI COGS and gross margin before and after AI.
Open calculator → Excel (.xlsx)Looking for a full financial model?
These templates each answer one question. A full 36-month SaaS model ties them together: revenue drivers, headcount, expenses, cash and the three statements. See what a SaaS financial model template should contain, or build one in Adlega from your own drivers.
Outgrow the spreadsheet
Adlega turns these one-off templates into one live model for your SaaS: projections, scenarios and an AI CFO that explains every number.