SaaS Valuation Model

SaaS Financial Model

The SaaS Valuation Model provides a simple way to derive the financial forecast for a Software as a Service (SaaS) internet company. The Financial Model calculates DCF Value, IRR, Breakeven, ARPU, Customer Lifetime Value and many more important key metrics to SaaS Businesses.

  • SaaS Income Statement Projections
    SaaS Income Statement Projections

The financial model template provides the following:

  • Executive Summary with key charts, key metrics and key assumptions. Simply change the assumptions on the right and see immediately the effect on Subscribers, Revenues, Cash Flow, etc. on the left and their impact on key SaaS specific financial metrics
  • Monthly and Yearly financial projections for 5 years
  • The Model allows to calculate the impact of three differently priced subscription packages (Basic, Standard and Premium) and the impact of discounts given for 1 year, 6 months or 3 months prepayment plans
  • Key Metrics
    • Number of Subscribers
    • Average Revenue Per Users (ARPU)
    • Customer Lifetime Value (CLV)
    • Monthly Recurring Revenues (MRR)
    • Enterprise Value and Equity Value based on DCF Valuation
    • Project IRR
    • Required Funding
    • Month when EBITDA breakeven is achieved
    • Month when Payback of investment is achieved (based on Free Cash Flows)
  • Revenue Streams
    • Subscription revenues
  • Costs Assumptions include
  • Acquisition costs per subscribers
    • Employee costs
    • Webhosting and all other costs
  • Financial Statements (Monthly and Yearly) – Income Statement, Balance Sheet, Cash Flow Statement
  • Valuation of the SaaS Business via the Discounted Free Cash Flow (DCF) Analysis
  • Calculation of the Project IRR via Calculation of Free Cash Flow to Firm (FCFF)
  • Payback period (FCFF) and required months till EBITDA breakeven
  • Debt schedule which models two layers of financial debt (junior and senior debt) – if needed
  • Amortization schedule for software development costs
  • Fixed asset depreciation schedule
  • Forecast of all relevant financial ratios
  • Calculation of required funding amount
  • Print-friendly layout including charts and graphs

The Executive Summary page gives the investor a comprehensive overview of the business plan of your SaaS business backed up by a solid financial model. We hope you like our financial model template in order to save your valuable time and have a solid basis for decision making.

See also the article how to build a SaaS financial model.

The model is available in two versions:

  • DEMO Version with only the input cells editable and formulas hidden
  • FULL VERSION with all cells editable and all formulas visible

Also the author offers to review and discuss the financial model for the specific case of the user during a 1/2 hour Skype call.

Filetype: .xlsx (Microsoft Excel 2008 for Mac)

Add to wish list
Purchase Excluding 0.08% tax

Below the Executive Summary Page

  • Changing the key assumptions on the right allows you to immediately see the effect on the financials of your SaaS business on the left
  • Financial Ratios are immediately updated for your convenience

SAAS__6_ES

Add to wish list
Purchase Excluding 0.08% tax
Users who purchased SaaS Valuation Model, also purchased:
Website / App Financial Model (Recurring Revenue Services)
happy laptop
Add to wish list
Purchase Excluding 0.08% tax
SaaS Financial Model (5 – Year) Up to 4 Pricing Tiers
saas2
Add to wish list
Purchase Excluding 0.08% tax
Financial Model for Mobile App
Financial model for mobile apps
Add to wish list
Purchase Excluding 0.08% tax
Industry , ,
Summary The SaaS Valuation Model provides a simple way to derive the financial forecast for a Software as a Service (SaaS) internet company. The Financial Model calculates the DCF Value, IRR, Breakeven, ARPU, Customer Lifetime Value and many more important key metrics to SaaS Businesses.
Screenshots / Pictures
Use Cases , , , , , , , , ,

Reviews

You must log in and be a buyer of this download to submit a review.