SaaS Metrics Excel Template - Learn How to Calculate and Track Actuals
Originally published: 24/05/2021 13:41
Last version published: 28/05/2021 07:27
Publication number: ELQ-20773-2
View all versions & Certificate

SaaS Metrics Excel Template - Learn How to Calculate and Track Actuals

A simple tool for any SaaS business to track their most important metrics over time. Advanced LTV calculations.

This is a two-part excel financial template. The first part is a SaaS KPI calculator. The user will enter the following inputs:
1.Total Current MRR Users
2. Total Current Monthly MRR $ Amt.
3. Monthly Cost to Service Users
4. Avg. Monthly One-Time Revenue
5. Avg. Cost of this Revenue
6. Average Users added/Mo.
7. Sales Staff Compensation/Mo.
8. Marketing Spend/Mo.
9. Retention rate
10. Discount rate (for PV of expected LTV)

and Get the following outputs:
1. Average Revenue per User
2. Gross Profit Margin
3. Gross Recurring Revenue per User
4. Gross One-time Revenue
5. Gross One-time Revenue/User
6. Average CaC
7. Present Value of Customer LTV
8. LTV to CaC Ratio
9. Total Months to Pay Back CaC

This part of the template is designed to help one to understand the key inputs that are required to calculate the more advanced ratios and metrics of a SaaS business model.

Secondly, those metrics are built into a separate tracking template so the organization can track how their actual performance is doing on a month-by-month basis across up to 60 months. This part works by letting the company enter actual data into each month of the tracker (per inputs above) and see how each months' performance compares over time. Visualizations of this actual data are displayed clearly.

This Best Practice includes
1 Excel model and 1 Tutorial Video

Acquire business license for $45.00

Add to cart

Add to bookmarks


Further information

Learn and calculate key SaaS metrics.

Any business with customers that pay a monthly fee and/or a one-time setup fee.

0.0 / 5 (0 votes)

please wait...