5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
  • 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
Originally published: 03/03/2018 08:51
Last version published: 19/07/2018 16:56
Publication number: ELQ-78257-7
View all versions & Certificate
certified

5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics

A straight forward approach to build financial projections for a SaaS startup business.

caccac paybackcash flow projectionsdiscounted cash flowfinancial modelpricing tiersrun ratesaasstartupvaluation

Description
**Executive summary added.

There are up to 4 pricing tiers. The months that a given revenue stream starts is dynamic. You can also change the monthly compounding growth rates by year, monthly churn by year, revenue per account by year, and add the option for one-time revenue upon setup.

The cost assumptions are done in a categorized way. COGS (cost of goods sold) is defined as a % of revenue. Executive, Salesmen, and Customer Service salaries are changeable by year. You also have slots for R&D and Administrative groups as well as taxes.

All of these assumptions aggregate into a clean monthly P&L summary that shows starting subscribers, added subscribers, lost subscribers, and ending subscribers for each monthly period. This is then translated into MRR (gained, lost, ending) per each pricing tier.

Because we have categorized expenses in a specific way, it is easier to identify the customer acquisition cost (CaC) as well as the months it takes to pay back the cost to acquire a customer (usually 6 to 8 months would be standard there, but this all depends on your assumptions.

All of the monthly P&L data flows dynamically to the annual P&L summary. You will also be able to input any financing assumptions and see the resulting net cash flow from all activity as well as a running balance of cash.

There is a discounted cash flow analysis as well as a valuation table based on the run rate (annual revenues).

Visuals have been included to show all kinds of high level and more in-depth SaaS specific metrics.

This business tool includes
1 Excel SaaS Template and 1 tutorial video

Acquire business license for $45.00

Add to cart

Add to bookmarks

Discuss

Further information

Build a forecast of the user growth and revenues based on a set of dynamic revenue and cost assumptions.

A business model that has multiple pricing tiers of paying subscribers that grow over time.

A non SaaS business or a model with more than 4 pricing tiers.

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More tools from Jason Varner

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on 5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics?

The user community and author are here to help. Go ahead!

please wait...