# SaaS MRR/ARR Forecast Model Example Build a SaaS subscription forecast that separates logo motion from MRR motion, exposes NRR, GRR, and CAC payback, and gives a clean operating P&L through EBITDA. - Canonical: https://finamodel.com/examples/saas-mrr-arr-model - Excel download: https://finamodel.com/templates/saas-mrr-arr.xlsx - Category: Tech & Software - Model type: Operating model - Difficulty: Intermediate - Audiences: Founders & operators, CFOs & FP&A, SaaS founders, RevOps and FP&A, Growth-stage CFOs, VC investors - Tags: saas, mrr, arr, subscription, retention, churn, cac ## Overview Forecast MRR and ARR for a multi-tier SaaS business across 36 months. The model explicitly separates logo motion (new, churn, ending) from MRR motion (new, expansion, contraction, churn) so retention and growth metrics reflect what investors actually expect to see. Three pricing tiers - Starter, Growth, Enterprise - each carry their own price, mix share, and logo churn rate. New logos compound off a base monthly intake, splitting across tiers by mix. Each tier's ending logos roll forward as the next month's opening. MRR follows the same pattern: opening MRR plus new MRR (driven by new logos x tier price), plus expansion MRR (a percentage of opening), less contraction MRR (a percentage of opening) and churned MRR (logo churn applied to opening), produces ending MRR. Outputs include total ARR (ending MRR x 12), ARR by tier, ARPU, period NRR and GRR, annualised net new ARR, and CAC payback in months. The simple P&L converts subscription revenue to gross profit at an assumed gross margin, applies S&M, R&D, and G&A as percentages of revenue, and produces EBITDA and EBITDA margin. The model is a focused subscription planner, not a full 3-statement model - link it downstream to the 3-statement template if you need balance sheet and cash flow. ## What's included - Three pricing tiers with independent price, mix, and churn - Monthly logo schedule: opening, new, churned, ending by tier - MRR build: new, expansion, contraction, churn, ending - ARR by tier, ARPU, NRR, GRR, net new ARR - Subscription P&L through EBITDA with CAC and CAC payback - Monthly logo motion: opening, new, churned, ending by tier - MRR motion: new, expansion, contraction, churn, ending - ARR by tier, total ARR, ARPU, net new ARR - NRR and GRR with consistent opening-MRR base - P&L through EBITDA with CAC and CAC payback ## SaaS MRR/ARR Forecast Model: How the Template Works This SaaS MRR/ARR forecast template supports a 36-month subscription business plan. It derives new logos from sales-capacity and retention assumptions, builds per-tier MRR, and rolls the result into revenue, headcount-driven opex, EBITDA, and cash runway. This overview explains the documented calculation flow so you can assess whether the structure fits your planning needs. ### Sales capacity starts the forecast The forecast begins with a sales-engine build rather than an imposed growth curve. - Monthly bookings come from BDR and AE headcount, a cohort-weighted ramp factor across a six-month productivity curve, and a monthly quota per AE, plus an inbound bookings stream that grows at its own rate. - Total bookings divided by blended ACV gives total new logos. - Because bookings depend on rep count, changes in hiring plans flow directly into logo acquisition, linking sales investment to customer growth. ### From logos to tier-level MRR New logos are split across Starter, Growth, and Enterprise using tier mix assumptions, with Enterprise treated as the residual so the tiers always sum to the total. - Each tier then rolls forward from opening logos, adding new logos and subtracting churned logos measured against the opening balance. - MRR applies tier pricing to those logo counts and adds expansion while subtracting contraction and churn, both calculated on opening MRR. - Ending MRR becomes opening MRR for the next month, and the sum across tiers produces total MRR and net new MRR. ### Billings, revenue, and cash Contract mix separates annual upfront and monthly business. New ARR sold is split by contract type; annual upfront billings include new annual contracts plus renewals carried forward twelve months and adjusted by trailing logo retention, while monthly billings represent the monthly portion of ending MRR. - Recognised revenue equals ending MRR on a ratable basis, and deferred revenue rolls forward as opening deferred plus annual billings minus recognised annual revenue. On the cost side, headcount pools for S&M, R&D, and G&A drive loaded monthly compensation, which together with marketing programs and other non-comp lines builds total opex. - EBITDA is gross profit less total opex, and cumulative EBITDA bridges opening cash to the closing cash balance and runway estimate. ### Retention and unit economics outputs A 36-by-36 cohort triangle tracks each acquisition vintage and decays it by blended monthly churn, producing cumulative retention at ages 12 and 24 and a trailing-twelve-month logo retention figure used in billings. The summary tabs report ARR as twelve times ending MRR, monthly and trailing-twelve-month NRR and GRR, ARPU, net new ARR, Magic Number, CAC payback, LTV by tier, and LTV/CAC. - Ten validation checks test mix, ARR identity, tier sums, revenue ties, and healthier thresholds such as LTV/CAC at or above three, helping a reviewer catch structural inconsistencies. Practical use is therefore a connected view of growth, retention, sales productivity, and cash needs, with customisation focused on sales-engine, opex, headcount, contract-mix, and expansion assumptions. - The public download contains values only, not live formulas. ## Built for subscription planning Use this model when ARR trajectory, retention, and CAC payback drive the business case - not generic top-line revenue. ## Investor-ready metrics NRR and GRR are computed period-by-period against opening MRR, the way an investor will recompute them in diligence. ## Tier-aware mechanics Self-serve, mid-market, and enterprise behave differently - pricing, churn, and mix flow through to ending ARR by tier. ## Built for subscription planning Use this model when ARR trajectory, retention, and CAC payback drive the business case - not generic top-line revenue. ## Investor-ready metrics NRR and GRR are computed period-by-period against opening MRR, the way an investor will recompute them in diligence. ## Tier-aware mechanics Self-serve, mid-market, and enterprise behave differently - pricing, churn, and mix flow through to ending ARR by tier. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Colour legend for input vs output sheets ### Assumptions Pricing per tier, new-logo growth, mix, churn, expansion, contraction, opening balances, opex ratios, and CAC. - Pricing and new-logo intake - Tier mix and per-tier churn - Expansion and contraction percentages - Opening logos and opening MRR by tier - Gross margin, S&M, R&D, G&A, CAC ### Customer Schedule Logo motion by tier with opening, new, churned, and ending balances rolled forward each month. - New-logo growth compounded monthly - Mix split into Starter / Growth / Enterprise - Churned logos applied to opening balance - Ending logos roll forward as next opening ### MRR Build MRR motion by tier - opening, new, expansion, contraction, churn, ending - plus totals and net new MRR. - New MRR from new logos x tier price - Expansion and contraction applied to opening MRR - Logo-churn rate drives churned MRR - Ending MRR rolled forward as opening - Total MRR and Net New MRR by month ### ARR Summary ARR by tier, total ARR, ARPU, NRR, GRR, annualised net new ARR, and CAC payback. - ARR by tier and total - Period NRR and GRR vs opening MRR - Net new ARR (annualised) - CAC payback months at current ARPU and gross margin ### P&L Subscription P&L from revenue through EBITDA using gross margin and S&M / R&D / G&A ratios. - Subscription revenue from MRR - Gross profit at gross-margin assumption - S&M, R&D, G&A as percentages of revenue - EBITDA and EBITDA margin ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Colour legend for input vs output sheets ### Assumptions Pricing per tier, new-logo growth, mix, churn, expansion, contraction, opening balances, opex ratios, and CAC. - Pricing and new-logo intake - Tier mix and per-tier churn - Expansion and contraction percentages - Opening logos and opening MRR by tier - Gross margin, S&M, R&D, G&A, CAC ### Customer Schedule Logo motion by tier with opening, new, churned, and ending balances rolled forward each month. - New-logo growth compounded monthly - Mix split into Starter / Growth / Enterprise - Churned logos applied to opening balance - Ending logos roll forward as next opening ### MRR Build MRR motion by tier - opening, new, expansion, contraction, churn, ending - plus totals and net new MRR. - New MRR from new logos x tier price - Expansion and contraction applied to opening MRR - Logo-churn rate drives churned MRR - Ending MRR rolled forward as opening - Total MRR and Net New MRR by month ### ARR Summary ARR by tier, total ARR, ARPU, NRR, GRR, annualised net new ARR, and CAC payback. - ARR by tier and total - Period NRR and GRR vs opening MRR - Net new ARR (annualised) - CAC payback months at current ARPU and gross margin ### P&L Subscription P&L from revenue through EBITDA using gross margin and S&M / R&D / G&A ratios. - Subscription revenue from MRR - Gross profit at gross-margin assumption - S&M, R&D, G&A as percentages of revenue - EBITDA and EBITDA margin ## Features - **Real subscription mechanics:** Expansion and contraction apply to opening MRR, not ending MRR - retention metrics that match how investors actually compute NRR and GRR. - **Tier-level logic:** Starter, Growth, and Enterprise each have their own price, mix share, churn rate, and ending balances. No single-line revenue. - **Investor-grade outputs:** ARR, NRR, GRR, magic-number-ready net new ARR, and CAC payback are exposed as named outputs you can plug into a board pack or fundraising deck. ## Use cases - **Fundraising and board reporting:** Show ARR trajectory, NRR, and CAC payback over 36 months in a structure investors can audit line by line. - **Annual operating plan:** Drive headcount, S&M, and R&D investment off subscription revenue so the operating plan ties to the bookings model. - **Retention and pricing analysis:** Sensitise tier mix, churn, and expansion to test packaging changes or churn-reduction projects. ## Frequently asked questions ### What is a SaaS MRR/ARR forecast model? It forecasts subscription revenue by tracking how customers and MRR move each month - new logos, churn, upsell, and downsell - then annualises the ending MRR to ARR. ### How is NRR calculated? NRR = (Opening MRR + Expansion - Contraction - Churn) / Opening MRR. The model computes it period-by-period against the prior-month ending balance, not as an average. ### What is the difference between GRR and NRR? GRR ignores expansion. It tells you how much of last month's MRR you kept before any upsell. NRR includes expansion, so a healthy SaaS business can have NRR above 100% even with some churn. ### Can I use this for product-led growth? Yes. Set the Starter tier price low, increase the Starter mix share, and use New-Logo MoM Growth to model funnel acceleration. Expansion MRR captures upgrade-on-usage. ### Does it include sales rep capacity? No - this template uses a blended new-logo intake and CAC. For sales-rep-driven forecasts use the Forecasting Revenue with Sales Reps model. ## Related templates - [Unit Economics Dashboard](https://finamodel.com/templates/unit-economics-model) - [Subscription Box Economics](https://finamodel.com/templates/subscription-box-model) - [Startup Cash Runway Model](https://finamodel.com/templates/runway-model) - [3 Statement Model](https://finamodel.com/templates/3-statement-model)