SaaS Financial Model: Build Your Revenue Forecast

Every SaaS founder eventually needs a financial model — whether it’s for an investor pitch, a board meeting, or simply to understand where the business is headed. But most financial models are either too simplistic (a single growth percentage applied to everything) or too complex (200-tab spreadsheets that nobody maintains). The sweet spot is a model grounded in real subscription metrics that’s detailed enough to be useful and simple enough to update monthly.

What Goes in a SaaS Financial Model?

A SaaS financial model is a projection of your business’s future revenue, costs, and cash position based on assumptions about growth, retention, and spending. Unlike traditional business models that focus on units sold, a SaaS model is built around recurring revenue mechanics:

• Revenue model — MRR, ARR, new subscriptions, expansion, and churn
• Customer model — acquisition rate, retention curves, and cohort behavior
• Cost structure — COGS, sales and marketing, R&D, and G&A
• Cash flow projection — burn rate, runway, and break-even timeline
• Key metrics output — LTV, CAC, payback period, gross margin, and net revenue retention

The goal isn’t to predict the future perfectly. It’s to build a framework that lets you test assumptions and understand how changes in one variable cascade through the rest of the business.

The Key Inputs: Start with What You Know

Your financial model is only as good as its inputs. Start with the metrics you can pull directly from your Stripe data:

Monthly Recurring Revenue (MRR)

Your current MRR is the foundation. This is the starting point for every projection in the model. If you’re pulling this from Stripe, make sure you’re calculating it correctly — including only active subscriptions and normalizing annual plans to their monthly equivalent. Revenue forecasting depends entirely on having an accurate MRR baseline.

Monthly Churn Rate

Churn is the single most impactful variable in a SaaS financial model. A 3% monthly churn rate means you lose roughly 30% of your customers every year. A 5% rate means you lose nearly half. Small changes in churn create massive differences in projected ARR over 12–24 months. Pull your actual churn rate from Stripe data rather than guessing.

New MRR Growth Rate

How much new MRR are you adding each month from new customers? This is separate from expansion revenue. Track both the absolute dollar amount and the growth rate of new MRR to understand whether your acquisition engine is accelerating or decelerating.

Expansion Revenue Rate

What percentage of existing customers upgrade, add seats, or increase usage each month? For many SaaS businesses, expansion revenue is what makes the model work. A strong net revenue retention rate can offset significant gross churn.

Building Your Revenue Projection

With those inputs, you can build a month-by-month MRR projection. The core formula for each month is:

Next Month MRR = Current MRR + New MRR + Expansion MRR − Churned MRR − Contraction MRR

Build this out for 12–24 months. For each month, calculate:

• Beginning MRR — carried forward from the previous month
• New MRR — based on your new customer acquisition assumptions
• Expansion MRR — based on your expansion revenue rate applied to beginning MRR
• Churned MRR — your churn rate applied to beginning MRR
• Ending MRR — the sum of all components

To convert to ARR, simply multiply each month’s ending MRR by 12. This gives investors and board members the annualized view they typically expect.

Adding Scenario Analysis

A single projection is a guess. Three projections are a strategy. Build at least three scenarios:

• Base case — your most likely outcome, using current growth and churn rates
• Optimistic case — what happens if you improve churn by 1% and increase new MRR by 20%
• Pessimistic case — what happens if churn increases and growth slows

Scenario planningisn’t about predicting which outcome will happen. It’s about understanding the range of possibilities and preparing for each. The gap between your optimistic and pessimistic cases tells you how much uncertainty exists in your business.

The Cost Side: COGS and Operating Expenses

Revenue is only half the model. You also need to project costs:

Cost of Goods Sold (COGS)

For SaaS, COGS typically includes hosting and infrastructure, payment processing fees (Stripe takes 2.9% + 30 cents), customer support salaries, and any third-party services that scale with customers. Target 70–85% gross margins.

Sales and Marketing

Model this as a percentage of revenue or a fixed budget. Include ad spend, sales salaries and commissions, marketing tools, and content production. Tie this to your new customer acquisition assumptions — if you plan to add more customers, you need to spend more on acquisition.

Research and Development

Engineering salaries, tools, and infrastructure for building the product. For early-stage companies, this is often the largest expense category.

General and Administrative

Rent, legal, accounting, insurance, and other overhead. These costs tend to grow in steps rather than linearly.

Making Your Model Investor-Ready

Investors look for specific things in a SaaS financial model:

• Bottom-up construction — projections built from unit economics (customers, ARPU, churn) rather than top-down guesses
• Clearly stated assumptions — every input should be visible and adjustable
• Historical data backing — your assumptions should be grounded in actual performance
• Sensitivity analysis — show what happens when key variables change
• Path to profitability — even if it’s 3 years out, show when unit economics drive the business to cash flow positive

The biggest mistake founders make is building a model disconnected from reality. If your model projects 5% monthly growth but you’ve been growing at 2%, investors will notice. Start with your actual metrics and build from there.

Keeping Your Model Updated

A financial model that’s updated once a year is almost useless. The best operators update their models monthly with actual results:

• Replace projected months with actuals as they come in
• Compare projected vs. actual to calibrate your assumptions
• Adjust forward-looking assumptions based on recent trends
• Track forecast accuracy over time to improve your modeling

This is where having automated Stripe reporting makes a real difference. Instead of manually exporting data and rebuilding spreadsheets, StripeReport pulls your MRR, churn, expansion revenue, and revenue forecasts directly from your Stripe account. You get the inputs your model needs without the manual work.

Key Takeaways

A good SaaS financial model doesn’t need to be complex. It needs to be grounded in real metrics — MRR, churn rate, expansion revenue, and acquisition costs — and structured so you can test different scenarios. Build your model bottom-up from unit economics, maintain at least three scenarios, and update monthly with actual data from Stripe. Whether you’re raising your next round or just trying to plan headcount for Q3, a well-maintained financial model is the tool that turns guesswork into strategy.