SaaS Pro Forma Template

Start with the Assumptions sheet and work through it section by section. Enter your current MRR (or starting MRR for a pre-revenue business), pricing tier structure, and initial customer count. The most important inputs are your new logo target per month and your gross monthly churn rate — these two numbers drive the entire revenue model. If you're pre-revenue, use your pipeline conversion data or comparable company benchmarks to set a realistic ramp. If you're early-stage with real data, pull your last three months of new logo wins and churned logos, calculate actual monthly churn rate, and use those as your base assumptions. Set your headcount plan in the operating expenses section with hire dates by role — this is where most SaaS founders underestimate cost because a full GTM team hire in months two through four shows up immediately in burn even before those hires generate pipeline.

Once the Assumptions sheet looks right, review the MRR & ARR Build sheet to verify the revenue ramp matches your narrative. Check the NRR calculation on the Customer & Cohort sheet — if it's below 100%, the model is showing that churn is eating expansion, which is the core problem most early-stage SaaS businesses face. Then move to the Unit Economics sheet and look at CAC payback period and LTV:CAC ratio. If payback is above 24 months or LTV:CAC is below 3:1, adjust your CAC assumptions or your churn rate assumptions until the model reflects a fundable unit economics profile — or accept that the current model won't pass investor scrutiny and use that as a signal to change your go-to-market strategy. The 5-Year P&L and Cash Flow sheets should be reviewed last as outputs, not as inputs.

Use the 5-Year P&L Summary and Cash Flow Projection sheets for board meetings, investor conversations, and annual planning. Investors at the seed and Series A stage focus on ARR growth rate, NRR, gross margin, and whether the Rule of 40 is achievable within the projection period. The Magic Number — new ARR divided by prior quarter S&M spend — is the efficiency metric VCs use to evaluate whether it makes sense to pour more capital into sales and marketing. For board reporting, come prepared with actual-vs-plan variance for MRR, churn rate, CAC, and burn rate — the four metrics that tell you whether you're on track. The Cash Flow sheet gives you runway calculation automatically, which you should update monthly and bring to every board meeting so there's never a surprise conversation about needing capital.

SaaS companies have predictable, recurring revenue — but projecting that revenue accurately requires a model that accounts for how subscription businesses actually grow. A simple top-line growth rate misses the mechanics: new MRR is added from new customers, existing customers expand through seat additions or tier upgrades, some customers downgrade, and some churn entirely. These four components move differently at different growth stages and respond differently to GTM investments. A pro forma built around the SaaS revenue waterfall makes these dynamics explicit, which is why investors expect to see MRR broken out by component rather than presented as a single number growing at a fixed rate.

The unit economics that define a healthy SaaS business are well-established: gross margin of 60–80% (lower for infrastructure-heavy or services-heavy businesses, higher for pure software), net revenue retention at or above 100% (meaning existing customers grow their spend faster than they churn, which is the compounding mechanism that makes SaaS so valuable), CAC payback period under 18 months for SMB-focused products and under 24 months for enterprise, and LTV:CAC ratio above 3:1. The Rule of 40 — revenue growth rate plus EBITDA margin — should approach or exceed 40% for a well-run growth-stage SaaS company. These benchmarks exist because a decade of SaaS IPOs and acquisitions has established what financial profiles produce durable, capital-efficient businesses. A pro forma gives you a structured way to project whether your current trajectory hits those benchmarks, and to model what changes — pricing, churn reduction, sales efficiency — would move the needles that matter.

The operational use of a SaaS pro forma goes beyond investor preparation. Annual planning at a SaaS company is fundamentally a resource allocation problem: how many AEs do you hire given your pipeline coverage ratio, what is the ROI of each additional engineer, and at what ARR milestone does it make sense to build a customer success team versus relying on product-led retention? A pro forma forces those questions to become quantitative. Model three hiring scenarios — aggressive, base, conservative — and compare their ARR output, cash burn, and runway implications. The scenario that produces the best balance of ARR growth and capital efficiency is your operating plan. Update the model monthly with actuals and compare against plan; the variance between planned and actual churn rate, CAC, and new logo wins tells you more about the health of a SaaS business than any other set of metrics.