The B2B SaaS Financial Model Template

Most financial model templates are built for a US company raising a US round. The growth benchmarks are wrong for this region, the employer on-costs do not exist, and the revenue drivers assume a self-serve motion that almost no SEA B2B SaaS company actually runs.

This one is built for you. Seven tabs, 24 months, every number traced back to a single assumptions sheet.

What is in the file

Assumptions. Every input in the workbook lives here. Blue text is yours to change, yellow fill marks the assumptions that move everything else, black is a formula you should not touch. Nothing else in the file requires typing.

Revenue. MRR is built from leads, not from a growth rate. Three sales motions run in parallel, inbound, outbound, and partner or reseller, each with its own lead volume, growth rate and conversion. They roll into one customer base, and the customer base drives MRR. Zero out any motion you do not run.

Expenses. Organised by initiative, not by accounting category. Instead of a row called "Marketing" there is a row called what you are actually doing, with two columns you must fill in: the outcome you expect, and the number you expect it to hit. If you cannot fill those in, you are not ready to spend the money.

Headcount. Annual salary in your local currency, employer on-cost, start month, and a ramp column. The on-cost cell carries a comment with rough statutory employer rates for Malaysia, Singapore, the Philippines, Indonesia and Thailand, verify them against your own entity, they move.

Runway. Three scenarios side by side: base, conservative (20 percent slower, 10 percent costlier) and optimistic (25 percent faster). Each produces months of cash remaining and the month by which you need to start raising. The default raise trigger is nine months, because a SEA seed round takes four to six months from first meeting to cash in the bank.

Unit economics. CAC, LTV, LTV:CAC and CAC payback, checked against benchmarks at month 12 with a written verdict rather than a number you have to interpret.

Investor summary. The one page you actually send. Everything on it is pulled from the tabs behind it, with a USD column for funds that report in dollars.

Three things this model does that most templates do not

CAC includes salaries. Campaign spend plus the fully loaded cost of everyone in Sales and Marketing. A CAC that counts only ad spend is the single most common way a founder flatters this sheet, and the first thing an experienced investor recalculates.

LTV is capped. An uncapped lifetime of one divided by monthly churn gives a customer at 1.5 percent monthly churn a 66-month life and an LTV that no one believes. The model caps lifetime at 36 months by default. Change it if your investors accept longer, but change it knowingly.

LTV uses gross profit, not revenue. Building LTV on revenue overstates every ratio downstream. This one nets your gross margin first.

How to use it in an hour

1. Open the Assumptions tab. Fill in your currency, your cash, your customers today and your current MRR. Ten minutes.
2. Replace the three lead and conversion blocks with your own observed numbers. Not benchmarks, your numbers, from your CRM. This is the step people skip and it is the step that determines whether the model is worth anything.
3. Delete the EXAMPLE rows on Expenses and Headcount and put in your real plan. Twenty minutes.
4. Read the Runway tab. If the conservative case runs out of cash before your next milestone, you have found the reason to build the model.
5. Read the month 12 verdicts on Unit Economics. If LTV:CAC is below benchmark, fix efficiency before you fix growth.

The worked example

The file ships populated with a seed-stage SEA B2B SaaS company so nothing looks empty when you open it: 12 customers, 42,000 MRR, 900,000 cash, an ACV of 42,000 a year.

That example runs out of money. Base case gives 14 months of cash and says start raising by month 5. The conservative case gives 10 months and says start raising now. Month 12 LTV:CAC comes in at 2.7 against a benchmark of 3.0, and the sheet says so in plain words.

That is deliberate. A template where the example passes every test teaches you nothing about what failing looks like.

What it will not do

It will not update itself. A model three months stale is worse than no model, because it gives you false confidence. Set a monthly cadence to drop your actuals in, or move the whole thing onto something that syncs from your books and stops being a spreadsheet problem.