SaaS & Subscription Profit Pack — Free Spreadsheets for MRR, Churn, Unit Economics & Revenue Forecasting

The problem

Your MRR is growing — but churn is eroding it silently, your unit economics are guesswork, and your ARR forecast is built on assumptions nobody has stress-tested

🚫

Churn feels like a small percentage — until you calculate how much revenue it's destroying compounded over 12 months

A 3% monthly churn rate sounds manageable until you do the math: 3% monthly is a 31% annual churn rate. That means nearly one in three customers you acquire this year will be gone by next year, and you need to replace them before you see any net growth. Most SaaS founders know their monthly churn percentage but have never calculated the annual revenue figure it represents — or what their MRR would look like today if churn had been just 1% lower for the past six months. The Churn Impact Calculator puts that number on the page: dollars lost this month, dollars lost this year, LTV destroyed per churned customer, and the exact number of new customers you need to acquire monthly just to break even on churn before growing a single dollar. That number usually lands as a punch in the gut — and it should.

📈

LTV:CAC of 3× is the benchmark — but most founders don't know their actual LTV, CAC, or whether their payback period is funded by their current runway

The standard SaaS unit economics benchmark is LTV:CAC ≥ 3 with a payback period under 12 months. Most founders can recite the benchmark but can't calculate their own number without a spreadsheet. LTV depends on average revenue per account, gross margin, and average customer lifetime — three figures that most teams know separately but have never combined into a single model. CAC depends on total acquisition spend (including SDR salaries, tooling, and ad spend) divided by customers acquired — not just ad spend divided by conversions. The difference between "ad cost per acquisition" and "fully loaded CAC" is often a 2–3× gap that makes a 5:1 LTV:CAC ratio look like 2:1 when the full cost of sales and marketing is counted. The SaaS Unit Economics calculator forces every cost onto the page and gives you the real ratio — by channel, so you know which acquisition bets are actually profitable to scale.

⚙

Pricing by gut feel leaves 30–50% of revenue on the table — and the tier that looks like your primary offering is usually not where the real margin lives

Most SaaS pricing decisions are made once, at launch, based on what competitors charge — and then never revisited with data. The average SaaS company that has run a pricing experiment finds that a 10–20% price increase on their mid or top tier produces less than 5% customer pushback and 15–20% improvement in blended ARPU. The pricing tier mix matters as much as the price itself: if 80% of your customers are on the lowest tier and enterprise customers are 5% of accounts but 40% of revenue, that's a growth signal your current acquisition funnel may be ignoring. The SaaS Pricing Tier Modeler lets you compare three to four pricing scenarios — different price points, different tier mixes, different annual discount structures — and shows you the blended ARPU, ARR, and upfront cash implications of each before you make any changes in production.

What's inside

Six templates that turn your recurring revenue metrics into a clear financial picture — churn, unit economics, pricing, retention, and forecast in one place

Each template is a CSV file that opens in Google Sheets, Excel, Numbers, or any spreadsheet app. Pre-built structure, clear column labels, and benchmark guidance included.

01

MRR / ARR Revenue Tracker

Monthly recurring revenue tracking across up to four pricing tiers: configurable plan names and prices, subscriber count by tier and month, gross MRR per tier, a separate MRR movement table (new MRR, expansion MRR, contraction MRR, churned MRR, net new MRR, cumulative MRR by month), and ARR run rate updated each month. The MRR movement section is the part most founders skip — and it's the most important. Gross MRR tells you what you have; net new MRR tells you what you earned. A business with $50K MRR and $5K net new MRR is growing. A business with $50K MRR and −$1K net new MRR is contracting even though the top line looks flat. Tracking MRR movement by component every month is how you catch a churn acceleration before it becomes a crisis and identify whether growth is being driven by new customer acquisition or by expansion revenue from your existing base — two very different signals that require very different responses.

Pairs with SaaS MRR Calculator & Subscription Revenue Forecast

02

Churn Impact Calculator

Quantify the full cost of your monthly churn rate and the exact customer acquisition volume needed to break even on it: current MRR input, monthly churn rate, average revenue per account, average customer lifetime (months), customer acquisition cost, and a full churn impact analysis — customers lost per month, MRR lost per month, revenue lost this year, LTV lost per churned customer, LTV:CAC ratio, new customers needed monthly just to replace churned MRR, and months to recover lost ARR at current acquisition pace. A scenario comparison table shows MRR impact at churn rates from 1% to 10% so you can see the ARR difference between where you are and where a 1% churn improvement would put you. A monthly churn log tracks churn by month with a cumulative MRR lost column. The final section — churn reduction levers — maps five common interventions (onboarding improvement, in-app engagement nudges, annual plan incentives, proactive success check-ins, exit survey and win-back flow) to estimated churn reduction percentages and monthly MRR saved at your current scale.

Pairs with Churn Revenue Impact Calculator & CAC/LTV Calculator

03

SaaS Pricing Tier Modeler

Model the revenue impact of your pricing structure across up to four tiers before touching your billing configuration: plan names and prices, annual pricing and discount percentage, a conversion model that takes your monthly qualified lead count and applies tier-specific conversion rates to calculate new customers per month and MRR from new customers per tier, blended ARPU, annual plan impact (annual customers, upfront cash collected, estimated churn reduction from annual lock-in), and a pricing scenario comparison table with five pre-built scenarios — current pricing, 10% price increase, 20% price increase, enterprise-led upsell strategy, and freemium entry with lower starter — each showing estimated MRR and ARR so you can evaluate trade-offs before committing. A monthly revenue mix tracker logs Starter, Growth, Pro, and Enterprise MRR each month and calculates the enterprise percentage of total MRR, which is the single metric that most cleanly signals whether your go-to-market motion is moving upmarket. Healthy SaaS at growth stage targets 30–50% of MRR from the highest pricing tier.

Pairs with SaaS MRR Calculator & Profit Margin Calculator

04

Cohort Retention Tracker

Track customer and revenue retention by acquisition cohort from Month 1 through Month 12: cohort month, customers acquired, retention percentage at each monthly interval (the classic cohort retention grid), and a separate revenue retention section that tracks net revenue retained by cohort — which can exceed 100% when expansion revenue from upgrades and seat adds outpaces churn from the same cohort. Includes Net Revenue Retention (NRR) and Gross Revenue Retention (GRR) by cohort, with a benchmarks table showing world-class, good, acceptable, warning, and crisis thresholds for Month 1, Month 3, and Month 12 retention and NRR/GRR. NRR above 100% means your existing customer base grows without any new customer acquisition — every percentage point above 100% is compounding ARR from customers who are already paying you. This is the metric that separates SaaS businesses that can grow efficiently at scale from those that are permanently dependent on aggressive top-of-funnel acquisition to offset a leaky base.

Pairs with Churn Revenue Impact Calculator & Customer LTV Calculator

05

SaaS Unit Economics Calculator

Full CAC, LTV, LTV:CAC, and payback period by acquisition channel and by pricing tier: acquisition cost input by channel (Paid Search, Paid Social, Content/SEO, Outbound Sales, Referral/Affiliate, Events and Partnerships) — monthly spend, trials started, trials converted, customers acquired, and CAC per channel — with a blended CAC summary. Plan-level unit economics: monthly price, gross margin percentage, average customer lifetime, LTV calculated from all three inputs, LTV:CAC ratio per plan, CAC payback period in months, and monthly gross profit per customer. A LTV:CAC benchmark table interprets ratios from below 1 to above 5 with the appropriate action for each range. A payback period benchmark table maps months to business implications — from exceptional (under 6 months) to dangerous (over 24 months). A monthly log tracks new customers, total CAC spent, blended LTV, LTV:CAC, payback period, and gross margin percentage each month so you can watch unit economics improve or degrade as you scale acquisition channels and pricing changes flow through the customer base.

Pairs with CAC/LTV Calculator & Customer LTV Calculator

06

Subscription Revenue Forecast

12-month rolling MRR growth forecast based on your actual acquisition and churn assumptions: baseline inputs (starting MRR, new customer acquisitions per month, ARPU, monthly expansion MRR, monthly gross churn rate, monthly contraction rate), a month-by-month forecast table tracking starting MRR, new MRR, expansion MRR, churned MRR, contraction MRR, net new MRR, ending MRR, cumulative ARR run rate, and month-over-month growth percentage. A scenario modeling section compares four scenarios — conservative (high churn), base case, optimistic, and bull case — showing 12-month ending MRR and ARR side by side so you can see how sensitive your annual outcome is to a 1–2% churn improvement and whether your base case assumptions are realistic against your benchmark. An ARR milestone tracker records your target and actual dates for each ARR milestone from $10K to $10M so you know at a glance whether you're ahead or behind the trajectory. The forecast forces a discipline most founders skip: separating new MRR from expansion MRR from churned MRR makes it immediately clear whether growth is being driven by acquisition, by upsells, or by both — and which lever to prioritize next.

Pairs with SaaS MRR Calculator & Business Cash Flow Calculator

How to use it

Start with your current MRR and churn — then build the unit economics — then run the 12-month forecast

1

Fill the MRR Tracker and Churn Calculator with your last 6 months of real data before touching the forecast

Pull your subscriber counts by plan tier and MRR movement data from your billing platform (Stripe, Chargebee, Paddle, or your internal dashboard). Fill the MRR Tracker for the last six months. Then open the Churn Impact Calculator, enter your current MRR, average churn rate over that period, and your ARPA. The output — MRR lost this month, revenue destroyed this year, new customers needed just to replace churn — resets your baseline assumption about whether you're actually growing. Most founders discover they are acquiring fast enough to grow top-line MRR but not fast enough to offset what they're losing to churn simultaneously. The churn reduction levers section then shows which interventions have the best expected ROI at your current MRR scale and churn rate.

2

Calculate your real fully loaded CAC and LTV by channel — then check whether your current acquisition mix is profitable to scale

Open the SaaS Unit Economics calculator and fill in your acquisition spend by channel for last month — including the fully loaded cost of any sales team members, SDRs, or agencies attributed to each channel, not just direct ad spend. Enter trials and conversions per channel to get CAC. Then enter plan-level LTV inputs: price, gross margin percentage, and average customer lifetime in months. The LTV:CAC ratio and payback period outputs will show you which channels are profitable to scale (LTV:CAC above 3, payback under 12 months) and which ones are consuming cash faster than they're generating it. If every channel is below 3:1, that's a pricing problem, a margin problem, or a retention problem — all three of which show up in other templates in this pack.

3

Run the 12-month forecast using your real MRR, churn rate, and acquisition pace — then stress-test it against the scenario table

Open the Subscription Revenue Forecast and enter your current MRR, last month's new customer count, ARPA, and expansion MRR from upgrades. Set the monthly churn rate to your actual 6-month average — not your target or your best month. The 12-month MRR projection and ARR run rate table shows exactly where you land at current trajectory. Then run the scenario comparison: conservative (add 2% to your churn rate), base case (your real inputs), optimistic (subtract 1.5% from churn), and bull case (subtract 2%). The gap between the conservative and optimistic scenarios at Month 12 is your single biggest lever: churn reduction delivers compounding returns, while new customer acquisition is linear. That gap should inform your next quarter's engineering and customer success priorities as much as your sales targets do.

SaaS & Subscription Profit Pack

Download all 6 templates — free, no email required

CSV files that work in Google Sheets, Excel, Numbers, or LibreOffice. Open, fill in your numbers, and finally see the real unit economics behind your recurring revenue — churn impact, LTV:CAC, cohort retention, pricing mix, and 12-month ARR trajectory.

📈 MRR / ARR Revenue Tracker CSV — MRR by plan tier, MRR movement (new/expansion/churn/contraction), ARR run rate 🚫 Churn Impact Calculator CSV — MRR lost, revenue destroyed per year, customers needed to break even, churn levers 💵 SaaS Pricing Tier Modeler CSV — 4-tier pricing model, blended ARPU, scenario comparison, revenue mix tracker 📋 Cohort Retention Tracker CSV — monthly cohort grid, NRR, GRR, revenue retention by cohort, benchmarks ⚙ SaaS Unit Economics Calculator CSV — CAC by channel, LTV by plan, LTV:CAC ratio, payback period, gross margin 🎯 Subscription Revenue Forecast CSV — 12-month MRR projection, scenario comparison, ARR milestone tracker

Got the templates? Now get a second set of eyes.

Book a free 15-minute SaaS unit economics audit using your actual MRR and churn data

Fill in the MRR Tracker and Churn Impact Calculator with your real numbers, then bring it to a 15-minute call. We'll run through your unit economics, flag whether your churn rate is eating your acquisition gains, check whether your LTV:CAC supports scaling paid acquisition, and tell you the one change most likely to improve your ARR trajectory this quarter — no pitch, just the math.

Name Email What type of subscription business are you running? What's the biggest metric problem you're trying to solve?

✓ No cost, no obligation ✓ Bring your actual MRR and churn data ✓ We run the math, you keep the worksheets

Stay sharp

New SaaS templates, retention benchmarks, and unit economics guides — monthly

We ship new calculators, spreadsheets, and founder guides every month. Join the list and get them before anyone else. No spam, unsubscribe anytime.

Related resources

More tools for SaaS founders and subscription businesses

Free calculators built for the same decisions these templates track — run your numbers live, then log results in the spreadsheets.

Business & Marketing Calculators

SaaS MRR Calculator, Churn Revenue Impact Calculator, Customer LTV Calculator, and CAC/LTV Calculator — the live calculators that feed directly into the SaaS & Subscription Profit Pack templates. Run your numbers here, then log them in the MRR Tracker and Unit Economics spreadsheets for monthly tracking.

Open calculators

Freelancer & Agency Profit Pack

If you're a solo founder or small agency running a productized service alongside your SaaS — or transitioning from service revenue to recurring revenue — the Freelancer & Agency Profit Pack's revenue dashboard and retainer tracking templates are the natural complement to the MRR Tracker and unit economics sheets in this pack.

View pack

Creator & E-Commerce Calculators

If your SaaS has a product-led growth motion or a digital product layer — templates, courses, presets sold alongside the subscription — the Creator & E-Commerce Calculators handle the one-time revenue side: pricing, margins, platform fees, and ROAS. Use them alongside the SaaS templates to track all revenue streams in one system.

Open calculators

Use these with the pack

SaaS and recurring revenue calculators that pair with these templates

Run your numbers live in the calculator, then log the results in the spreadsheets.

View all business & marketing calculators

From the team at CareerKit Digital

More recurring revenue in your business starts with more income from your career

CareerKit Digital builds job-search and career-acceleration tools — resume templates, interview prep kits, LinkedIn profile optimizers, and income negotiation guides — so you can increase what you earn and bring more capital to fund product development, runway extension, and paid acquisition, whether you're building your SaaS on nights and weekends or scaling a subscription business full-time.

Browse CareerKit Digital on Etsy