Free tool · SaaS
SaaS financial model template: 12 months from your MRR growth
Type last year’s revenue, your monthly growth, gross margin, operating costs, cash and payment terms. Get a 12-month SaaS financial model — profit and loss, balance sheet and cash flow month by month — a 13-week cash forecast, and an Excel file whose formulas recalculate when you change the growth rate. No signup, no email.
Computed by this tool for Northbridge Analytics, our example SaaS company. Type your numbers below to get yours.
Updated
Build your report
1Your industry: SaaS / subscription Change
2Your numbers
Prefilled with the figures of Northbridge Analytics, the example SaaS company in our sample report. Replace each number with yours. Reset to the example
How it is calculated
- Twelve months, starting on the 1st of next month, from the cash you have today. Sales run at the pace of the last 12 months; for SaaS they grow by your monthly rate, for hospitality they follow your seasonal swing with the peak in July.
- Profit and loss. Cost of sales = revenue × (100% − gross margin). Operating costs stay at the monthly figure you typed. Operating profit = gross profit − operating costs.
- Balance sheet. Receivables = a month’s sales × days customers take to pay ÷ 30. Supplier payables = a month’s cost of sales × days you take to pay ÷ 30. Stock = a month’s cost of sales × stock days ÷ 30. Retainage = the share held back on the last six months of bills. Equity grows by each month’s operating profit.
- Cash-flow statement. Operating profit, less the increase in receivables, retainage and stock, plus the increase in supplier payables. Cash at the end of each month is the balance-sheet cash.
- 13-week forecast. The first three months of the cash-flow statement, spread over weekdays: customer receipts and supplier payments evenly, operating costs 40% on the first weekday of the month and 30% each on the 15th and the last weekday (payroll). Week 13 ends on the last day of month three, on the same balance.
- Not in your inputs, so not in the report: loans, equipment purchases, depreciation, income tax and owner draws. Add them in the Excel file.
Every figure is whole dollars, rounded once, and every total adds up the rounded lines — so the balance sheet balances to the dollar, the cash flow ends on the balance-sheet cash and week 13 ends on month three’s cash. The page checks all three under the report.
What this SaaS model projects
Revenue from your growth rate. The model finds the monthly revenue that, growing at your rate, adds up to last year’s revenue over its trailing twelve months — then grows it month by month for the next twelve. For a subscription business that is your MRR path: type a different rate and every month moves.
Margin and burn. The gross margin covers hosting, support and payment fees. Operating costs — product, sales and marketing, general and admin — stay at the monthly figure you typed, so the profit and loss shows when growth starts to cover them, and the cash line shows the burn until it does. For the months of cash that leaves, use the cash runway calculator.
Working capital. Customers who pay invoices on terms tie up receivables; card subscribers pay at once, so a low number of days customers take to pay fits them. Supplier payables follow your cost of sales.
What it leaves out
One growth rate drives revenue, so the model does not split new, expansion and churned MRR, and it carries no headcount plan, customer acquisition cost or deferred revenue from annual prepayments. Each of those can be added as rows in the Excel file, where every statement already follows the Inputs sheet. The SaaS sample report shows the monthly report built from a subscription company’s books.
Questions
How does the growth rate drive the model?
Revenue grows by the monthly rate you type, compounding, from the month whose trailing twelve months add up to last year's revenue. Cost of sales, receivables and payables follow revenue; operating costs stay at the monthly figure you typed, so the model shows when growth covers them.
Is this a complete SaaS financial model?
It is a 12-month driver model: one growth rate drives revenue, and the profit and loss, balance sheet, cash flow and 13 weeks follow. It does not split new, expansion and churned MRR, and it has no headcount plan, CAC or deferred revenue; add those as rows in the Excel file.
How do I see a different growth rate?
Change the growth rate on the Inputs sheet of the Excel file: every month of the profit and loss, the balance sheet, the cash flow and the 13 weeks recalculates. On this page, type the new rate and build the report again.
Is this my company's real financial report?
No. It is an estimate built from the numbers you type, with the rules listed under How it is calculated. Your real statements come from your books: connect your accounting system and Ataski's Financial Analyst builds them from your ledger every month.
Do you save the numbers I type?
No. There is no signup and no email field. The numbers are sent to our server only to build the page and the Excel file; they are not written to a database or a log, and they never appear in a web address. We count that a report was built and for which industry, never the figures.