SaaS Business Plan Financial Template in Excel: MRR, Churn, and LTV Calculations Built In

In a normal business plan, you track one-time sales. In a SaaS model, you track subscriptions. Customers pay every month. That means your income can grow — or shrink — based entirely on who stays. Who walks away.

So why does that matter for your spreadsheet? Because a basic income statement can't handle it. You need formulas that grow MRR forward, subtract churned customers, and add new ones. That's why SaaS models live inside Excel. For more on building this kind of model from scratch. Check out our guide on pre-income software company business plan templates.

Every solid SaaS financial model Excel template tracks four core numbers. First is MRR — your monthly recurring income. Second is churn — the customers you lose. Third is LTV — how much a customer is worth over their lifetime with you. Fourth is CAC — what you spend to get a new customer.

Gilion explains that growing MRR is a clear sign your product is gaining fans. Here's what matters: these four numbers are connected. Change one and the others shift too. That's the magic — and the danger — of a SaaS model. Miss the connection between churn and LTV, and your whole predict falls apart.

Each month, your model starts with last month's MRR. Then it adds new MRR from new sign-ups, subtracts churned MRR from cancellations. Adds expansion MRR from upsells. The result is your new MRR total. Simple in theory —. The formulas need to be wired correctly or the whole thing breaks.

Here's a real example of how this plays out. Say a startup has $500,000 in MRR at the start of a quarter. Vena shares this case: that quarter, the company loses $30,000 in MRR but gains $40,000 from upsells. Net income churn = (($30,000 - $40,000) ÷ $500,000) × 100 = -2%. That's negative churn.

It means the business is growing even while losing some customers. Not many founders realize that's possible until they see it in their model.

One of the biggest mistakes founders make is confusing logo churn with income churn. Logo churn counts how many customers left. Income churn tracks how much money left. Are those the same thing? Almost never.

Vena points out that a 2% customer loss rate doesn't tell you if those were small or large accounts. Losing one big account hurts far more than losing five tiny ones. Your SaaS financial model Excel template should track both — in separate rows — so you never confuse the two.

Churn directly affects LTV. Higher churn means customers stick around for less time. Less time means less total income per customer. Your model should recalculate LTV on its own when you update your churn rate — if it doesn't. You'll be working with stale numbers every time something changes.

The formula is simple: LTV = Average MRR per customer ÷ Monthly churn rate. If your average customer pays $200 per month and your monthly churn is 2%. Your LTV is $10,000. Change churn to 4% and LTV drops to $5,000 — cut in half. Gilion notes that a high LTV signals customers find real value in your product.

Plan to stay.

The easiest way to build scenarios is with an input tab. Put your key assumptions there — monthly churn rate, new customer growth rate, average selling price. Then use a drop-down or toggle to switch between your three sets of inputs. Need help making that tab credible?

Our guide on how to build a believable income assumption input tab walks through it step by step.

Each scenario should change at least three things: your monthly churn rate. Your new MRR growth rate, and your CAC. The VC Corner shows a powerful example: drop your price from $200 to $150 per month. Watch CAC stay flat while your payback period jumps from 7 to 10 months.

That's exactly the kind of insight backers want to see —. The kind of thing you'd miss without a proper scenario model.

Scenario models show backers you've done your homework. They show you know what could go wrong. That you have a plan for each possible future. That's a very different message than handing someone a single optimistic predict. Hoping for the best.

In 2026, Younium reports that top SaaS finance leaders are pushing for real-time predicting. Sustainable growth planning. Backers expect this level of rigor now. A single-scenario model looks naive. Three scenarios look backer-ready.

A healthy LTV:CAC ratio is at least 3:1. That means for every $1 you spend to get a customer. You earn $3 back over time. HubiFi calls this ratio a powerful signal of how well your customer investment pays off.

Here's a simple benchmark table to use when reading your model outputs:

• Seed stage: 2:1 is acceptable. You're still learning — but aim for 3:1 fast.
• Series A: 3:1 is the floor. Backers expect it without exception.
• Growth stage: 4:1 or higher shows a growable machine.

If your ratio falls below 2:1, your model is telling you to stop spending on growth. Fix retention first. No amount of new customer spend fixes a leaky bucket.

Build your LTV:CAC ratio into a dashboard in your Excel file. Make it update live as you change inputs. When the ratio drops below 3:1, highlight the cell red. That's your warning signal — and it should be impossible to miss.

This turns your SaaS financial model Excel template from a reporting tool into a decision tool. Test a new pricing plan. A new ad spend level, a new churn target — and see instantly if the ratio stays healthy. How fast can you get that answer right now with your current setup?

If it takes more than a minute, your model needs a dashboard.

A founder built a B2B project management tool. At launch, she had 50 customers at $200 per month each — $10,000 in MRR. She built a SaaS financial model Excel template with three tabs: inputs, monthly MRR build. A backer dashboard.

Her base case assumed 10 new customers per month and a 3% monthly churn rate. The bear case used 5 new customers and 6% churn. The bull case used 20 new customers and 1.5% churn. In the base case, her MRR hit $50,000 in month 18. In the bear case, she barely reached $25,000.

The gap was massive — and that gap is exactly what she showed backers.

Her LTV at 3% monthly churn came out to $6,667 per customer. Her CAC was $1,500. That put her LTV:CAC ratio at 4.4:1 — strong for a seed-stage company. HubiFi notes that top-performing SaaS companies with ARR between $1M. $30M saw 62.1% growth rates in 2023.

Her model showed she could hit that range in two years under her base case.

But the model also flagged a risk. Her payback period was 7.5 months. Raise CAC by 20% and it stretched to 10 months. That's the kind of sensitivity backers always ask about —. She had the answer ready before they could finish the question.

Note: This is a composite example created for illustrative purposes. It does not represent a single real person or company.

1. Pre-income founder: Start with your pricing tiers and target customer count. Build your MRR predict first. Don't worry about churn yet — set it to 3% and revisit after launch. Download a free template from The VC Corner to get a ready-made structure.
2. Post-income operator: Pull your real MRR data first. Calculate your actual monthly churn rate. Then plug those numbers into your model and run all three scenarios. Your focus should be the LTV:CAC ratio and payback period — those are what backers will drill into.
3. Backer diligence prep: Build a clean dashboard tab. Show MRR growth, net income churn, LTV:CAC, and ARR. Make sure all three scenarios are visible. Younium's 2026 predictions confirm that backers now expect real-time, data-driven forecasts — not static spreadsheets. Also explore Google Sheets alternatives for SaaS financial modeling if your team needs to work together live on the file.

Your Excel file is only half the job. The other half is explaining what the numbers actually mean. Your business plan narrative should walk through your MRR growth curve, your churn assumptions. Your LTV payback period in plain words — not just formulas on a screen.

Why does that matter? Because backers read the words and the numbers. If your narrative doesn't match your model, trust breaks down fast. For more on connecting the two. See our related article on how to turn your model outputs into business plan narrative. Also check out our list of free startup financial model templates ranked for seed-stage founders.

The truth is, the CFO role has shifted. Younium notes that as of 2026. Financial leadership is seen as planned — not just a support function. Even as a founder, you need to think like a CFO when you present your model. Numbers without words don't win funding. Words without numbers don't either.