0% found this document useful (0 votes)

379 views35 pages

Early Stage Financial Model

The document outlines an early stage SaaS financial model with revenue and cost structures for different customer sizes ranging from Medium to Behemoth. It includes metrics like monthly recurring revenue, annual contract value, sales commissions, implementation revenue, operational costs, and renewal commissions. Sample numbers are provided for best, moderate, and worst case scenarios. The model also tracks new and churned customers, active customers, and projected revenue and costs over time.

Uploaded by

tiah

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

379 views35 pages

Early Stage Financial Model

Uploaded by

tiah

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

You are on page 1/ 35

Early Stage SaaS Financial Model

Medium Large

Revenue Structure Revenue Structure

1 1=MRR | 2=ARR 1 1=MRR | 2=ARR

Licenses/Customer metric being tracked Licenses/Customer metric being tracked

1 Best Case 200 1 Best Case
2 Moderate Case 100 2 Moderate Case
3 Worst Case 50 3 Worst Case

ACV ACV
1 Best Case 100,000 1 Best Case
2 Moderate Case 85,000 2 Moderate Case
3 Worst Case 70,000 3 Worst Case

Sales Commission (% of ACV) Sales Commission (% of ACV)

1 Best Case 9% 1 Best Case
2 Moderate Case 15% 2 Moderate Case
3 Worst Case 25% 3 Worst Case

Implementation Revenue Implementation Revenue

1 Best Case 5,000 1 Best Case
2 Moderate Case 5,000 2 Moderate Case
3 Worst Case - 3 Worst Case

Operational Costs (% of ACV) Operational Costs (% of ACV)

1 Best Case 7% 1 Best Case
2 Moderate Case 12% 2 Moderate Case
3 Worst Case 15% 3 Worst Case

Renewal Commission (% of ACV) Renewal Commission (% of ACV)

1 Best Case 5% 1 Best Case
2 Moderate Case 10% 2 Moderate Case
3 Worst Case 15% 3 Worst Case

Created by TexasMarker
Instructions on TexasMarker.io
Make this your own, nothing in the workbook is protected or locked!
Huge Behemoth

Revenue Structure Revenue Structur

1 1=MRR | 2=ARR

etric being tracked Licenses/Customer metric being tracked Licenses/Custom

750 1 Best Case 3,000
500 2 Moderate Case 2,000
250 3 Worst Case 1,000

ACV ACV
140,000 1 Best Case 180,000
120,000 2 Moderate Case 160,000
110,000 3 Worst Case 140,000

Sales Commission (% of ACV) Sales Commissio

9% 1 Best Case 9%
15% 2 Moderate Case 15%
25% 3 Worst Case 25%

Implementation Revenue Implementation

5,000 1 Best Case 10,000
5,000 2 Moderate Case 5,000
- 3 Worst Case -

Operational Costs (% of ACV) Operational Cost

7% 1 Best Case 7%
12% 2 Moderate Case 12%
15% 3 Worst Case 15%

Renewal Commission (% of ACV) Renewal Commis

5% 1 Best Case 5%
10% 2 Moderate Case 10%
15% 3 Worst Case 15%
Behemoth

Revenue Structure
1 1=MRR | 2=ARR

Licenses/Customer metric being tracked

1 Best Case 15,000
2 Moderate Case 10,000
3 Worst Case 5,000

ACV
1 Best Case 600,000
2 Moderate Case 300,000
3 Worst Case 200,000

Sales Commission (% of ACV)

1 Best Case 9%
2 Moderate Case 15%
3 Worst Case 25%

Implementation Revenue
1 Best Case 10,000
2 Moderate Case 5,000
3 Worst Case -

Operational Costs (% of ACV)

1 Best Case 7%
2 Moderate Case 12%
3 Worst Case 15%

Renewal Commission (% of ACV)

1 Best Case 5%
2 Moderate Case 10%
3 Worst Case 15%
Early Stage SaaS Financial Model

Customer Acqusition

Jun-15 Jul-15 Aug-15 Sep-15

New Medium Customers - - - -
New Large Customers - - - -
New Huge Customers - - - -
New Behemoth Customers - - - -

Customer Start (use name)

Medium - - - -
Large - - - -
Huge - - - -
Behemoth - - - -

Churn (use nunmber churned)

Medium - -
Large - -
Huge - -
Behemoth - -

Active Customers Jun-15 Jul-15 Aug-15 Sep-15

Medium Customers - - - -
Large Customers - - - -
Huge Customers - - - -
Behemoth Customers - - - -

Total Active Customers - - - -

Customer Drivers

Medium Customers
1 Licenses/Customer metric being tracke 200
1 ACV 100,000
1 Sales Commission (% of ACV) 9.0%
1 Implementation Revenue 5,000
1 Operational Costs (% of ACV) 7%
1 Renewal Commission (% of ACV) 5%
Year 1 Unit Economics
ACV 100,000
MRR 8,333
Implementation Revenue 5,000
Commission to Rep 9,000
Operations Costs 7,000
Year 1 Net Revenue 89,000

Year 2 Unit Economics

ACV 100,000
MRR 8,333
Renewal Commission 5,000
Operations Costs 7,000
Year 2 Net Revenue 88,000

Large Customers

Huge Customers

Behemoth Customers

Revenue and Costs

Jun-15 Jul-15 Aug-15 Sep-15

Revenue from Software

Medium Customers - - - -
Large Customers - - - -
Huge Customers - - - -
Behemoth Customers - - - -

Revenue from Implementation

Medium Customers - - - -
Large Customers - - - -
Huge Customers - - - -
Behemoth Customers - - - -

Commission to Rep
Medium Customers - - - -
Large Customers - - - -
Huge Customers - - - -
Behemoth Customers - - - -

Operational Costs
Medium Customers - - - -
Large Customers - - - -
Huge Customers - - - -
Behemoth Customers - - - -

Total Licenses/Customer metric being tracked

Medium Customers - - - -
Large Customers - - - -
Huge Customers - - - -
Behemoth Customers - - - -

Renewals and Upsells

renewal (months) Jun-15 Jul-15 Aug-15 Sep-15

Cohort 1 2 3 4
Renewing Cohort 12 0 0 0 0
Contracts Renewed
Medium Customers - - - -
Renewing Cohort Size - - - -
Churn - - - -
Renewals - - - -
Large Customers - - - -
Huge Customers - - - -
Behemoth Customers - - - -

Renewal Commission
Medium Customers - - - -
Large Customers - - - -
Huge Customers - - - -
Behemoth Customers - - - -