Our SaaS financial model template is built specifically for Software as a Service (SaaS) businesses, with pre-built assumptions and formulas to help you accurately forecast revenue, expenses, profits, cash flow and more. It includes your pro forma financial statements over 5 years, as well as a wide range of SaaS financial metrics, such as Monthly Recurring Revenue (MRR), Customer Acquisition Cost (CAC) and Lifetime Value (CLV) and more.

The spreadsheet includes over 10 different tabs divided in 3 different sections:

The outputs

These are the 4 most important tabs where you will find your pro forma financial statements, metrics, valuation, reports and  various charts. There’s nothing for you to do here, it’s automatically built based on the assumptions of your model.

• Dashboard: a snapshot of your financial statements and metrics. In here, you will find charts and reports you can use for your pitch deck. You will also find here the Use of Funds charts you can use to assess how much funding you need, and where you will spend your money on
• Metrics: in here, we calculate a number of metrics we show in Dashboard, especially how we get to Customer Acquisition Costs (CAC) and Customer Lifetime Value (CLV or LTV)
• Financial statements: this is where you can find your 3 pro forma financial statements over 5 years (and 60 months): Profit-and-loss (Income statement), Balance Sheet and Cash Flow Statement
• Valuation: here you can find the Venture Capital valuation report. We calculate a theoretical valuation for your business based on futureprojections and investors’ IRR

Assumptions

These are the 2 sheets where you can change all assumptions that drive your financial projections.

• Settings: this is the main tab of the template where you can change assumptions that will flow through the rest of the model: users, conversions, expenses, CapEx and financing
• Hiring plan: this is where you can add the roles and respective teams as well as their salaries. Here you can add, for each employee, their starting dates, salaries, bonuses, etc.

Calculations

These are the sheets where the magic happens: this is where we actually forecast your revenues and expenses based on your assumptions.

• Acquisition: here, we forecast the number of new customers you acquire (or in other words, the number of conversions) from leads, whether you acquire them via outbound or inbound growth
• Revenue: in this sheet you will find an exhaustive SaaS revenue model where we forecast MRR from up to 4 subscription tiers, both with monthly and/or annual billing
• Expenses: we calculate all your expenses, COGS and operating expenses
• Capex & D&A: here you will find your capital expenditures as well as related depreciation & amortization expenses (D&A)
• Deferred revenue: in this sheet, we calculate deferred (or ‘unearned’) revenue which has an impact on your financial statements if you choose to have annual billing