SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash   Excel template (XLSX)
$25.00

SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
Flevy is the marketplace for business best practices.
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen.

SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash – Excel XLSX

Excel (XLSX)

$25.00
Thirty-six months of MRR built from new and churned revenue, with unit economics from the same inputs - the example reaches $144,914 MRR, 7.5x LTV/CAC and a 6.7-month CAC payback.
Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

  1. MRR built month by month from new and churned revenue as separate lines, so a churn change compounds through the curve instead of just changing an end number.
  2. Lifetime value computed from ARPU, gross margin and churn - the real definition - so it responds correctly when the margin moves.
  3. Eighteen plain-English integrity tests inside the file, all passing and all live, including that ending MRR can never go negative.

SAAS EXCEL DESCRIPTION

SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash is an Excel template (XLSX) available for immediate download upon purchase.

The common failure in a SaaS spreadsheet is that the growth projection and the unit economics are two separate pieces of arithmetic that never meet. Someone types a growth rate into an MRR curve, then types an LTV and a CAC into a box underneath, and nothing forces the two to be consistent. This model builds both from one set of assumptions, so a change to churn moves the MRR curve and the lifetime value and the payback period at the same time, in the directions they actually move.

The example that ships in the file starts at $50,000 of MRR, adds 5% of the month's starting MRR in new business and loses 2% to churn, with ARPU of $50, a 75% gross margin, CAC of $250, sales and marketing at 30% of revenue, $80,000 of fixed monthly operating cost and $200,000 of opening cash.

On those numbers: lifetime value $1,875, LTV to CAC 7.5x, CAC payback 6.7 months, ending MRR in month 36 of $144,914, and a run-rate revenue of $1,738,967.

Three things this model does that comparable SaaS templates do not.

First, the MRR schedule is a real build, not a growth rate applied to a total. Every month shows starting MRR, new MRR, churned MRR and ending MRR as four separate lines, and each month starts exactly where the previous one ended. That structure is what lets you see the compounding effect of a churn change rather than just a different end number – and it is what an investor will ask to see.

Second, lifetime value is computed the way the metric is actually defined – ARPU times gross margin divided by monthly churn – rather than as revenue times an assumed retention in months. The distinction matters: the version in this file falls correctly when the gross margin falls, which the shortcut version does not.

Third, the cash line is driven by the P&L rather than by a separate guess. Revenue is the month's ending MRR, cost of sales follows from the gross margin, operating costs are sales and marketing as a share of revenue plus the fixed block, EBITDA falls out, and the cash balance is opening cash plus cumulative cash flow. One chain, no parallel arithmetic.

What is inside. Seven sheets. ReadMe with a colour key and a sheet guide. Assumptions – starting MRR, monthly new and churn rates, ARPU, gross margin, CAC, sales and marketing as a share of revenue, fixed operating cost, months to model and opening cash. MRR Schedule – 36 months of starting, new, churned and ending MRR. P&L – revenue, cost of sales, gross profit, sales and marketing, fixed costs, total operating expenses and EBITDA for every month. Cash Flow – monthly net cash flow, the cumulative total and the running cash balance. Metrics – LTV, LTV/CAC, CAC payback in months, ending MRR and run-rate revenue. Checks – eighteen pass/fail tests.

How you know the numbers are right. The Checks sheet runs eighteen tests inside the workbook and all eighteen pass in the shipped file. In plain English: that ending MRR is starting plus new less churned in every month, that each month opens where the last one closed, that new and churned MRR are the stated rates on the month's starting balance, that revenue in the P&L is the month's ending MRR, that EBITDA is gross profit less total operating expenses, that the cash balance is opening cash plus the cumulative flow, that LTV is ARPU times gross margin over churn, that the LTV to CAC ratio divides correctly, that CAC payback is acquisition cost over monthly gross profit per customer, that churn stays below 100% so the series does not invert, and that ending MRR is never negative in any month.

Separately, every output was re-derived in an independent script using different arithmetic. That verification covered this model together with three others in the same family – 691 comparisons in all, no disagreements.

What this model does not do. It works at the MRR level with a single blended ARPU and a single churn rate. There are no cohorts, no tiers or plans with separate pricing, no expansion or contraction MRR as distinct lines, no headcount plan, and no balance sheet – the cash view is a running balance, not a three-statement model. If you need cohort retention curves or a plan-by-plan build, that is a different and much larger file. If you need a clean, auditable 36-month MRR and cash picture with unit economics that move with it, this is built for that and shows its work.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in SaaS, Integrated Financial Model Excel: SaaS Financial Model: MRR Build, LTV/CAC, 36-Month Cash Excel (XLSX) Spreadsheet, Paweł Dudek, Balancewright


$25.00
Thirty-six months of MRR built from new and churned revenue, with unit economics from the same inputs - the example reaches $144,914 MRR, 7.5x LTV/CAC and a 6.7-month CAC payback.
Add to Cart
  

ABOUT THE AUTHOR

Author image
Additional documents from author: 33

Balancewright is Paweł Dudek. The catalogue covers project finance, fund and waterfall structures, corporate three-statement forecasting, working capital, valuation and FP&A -- built as working models rather than formatted templates.

Every model is formula-driven end to end. No locked cells, no passwords, no macros and no external links, so any calculation can be inspected, adapted and ... [read more]

Ask the Author a Question

You must be logged in to contact the author.

Click here to log in Click here register

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided business templates to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab





Read Customer Testimonials

 
"As an Independent Management Consultant, I find Flevy to add great value as a source of best practices, templates and information on new trends. Flevy has matured and the quality and quantity of the library is excellent. Lastly the price charged is reasonable, creating a win-win value for "

– Jim Schoen, Principal at FRC Group
 
"I have used FlevyPro for several business applications. It is a great complement to working with expensive consultants. The quality and effectiveness of the tools are of the highest standards."

– Moritz Bernhoerster, Global Sourcing Director at Fortune 500
 
"Flevy.com has proven to be an invaluable resource library to our Independent Management Consultancy, supporting and enabling us to better serve our enterprise clients.

The value derived from our [FlevyPro] subscription in terms of the business it has helped to gain far exceeds the investment made, making a subscription a no-brainer for any growing consultancy – or in-house strategy team."

– Dean Carlton, Chief Transformation Officer, Global Village Transformations Pty Ltd.
 
"FlevyPro provides business frameworks from many of the global giants in management consulting that allow you to provide best in class solutions for your clients."

– David Harris, Managing Director at Futures Strategy
 
"Last Sunday morning, I was diligently working on an important presentation for a client and found myself in need of additional content and suitable templates for various types of graphics. Flevy.com proved to be a treasure trove for both content and design at a reasonable price, considering the time I "

– M. E., Chief Commercial Officer, International Logistics Service Provider
 
"If you are looking for great resources to save time with your business presentations, Flevy is truly a value-added resource. Flevy has done all the work for you and we will continue to utilize Flevy as a source to extract up-to-date information and data for our virtual and onsite presentations!"

– Debbi Saffo, President at The NiKhar Group
 
"I have found Flevy to be an amazing resource and library of useful presentations for lean sigma, change management and so many other topics. This has reduced the time I need to spend on preparing for my performance consultation. The library is easily accessible and updates are regularly provided. A wealth of great information."

– Cynthia Howard RN, PhD, Executive Coach at Ei Leadership
 
"Flevy is our 'go to' resource for management material, at an affordable cost. The Flevy library is comprehensive and the content deep, and typically provides a great foundation for us to further develop and tailor our own service offer."

– Chris McCann, Founder at Resilient.World



Customers Also Like These Documents

Explore Templates on Related Management Topics



Your Recently Viewed Documents
Download our FREE Digital Transformation Templates

Download our free compilation of 50+ Digital Transformation slides and templates. DX concepts covered include Digital Leadership, Digital Maturity, Digital Value Chain, Customer Experience, Customer Journey, RPA, etc.