
Originally published: 16/02/2018 14:23
Publication number: ELQ-25857-1
View all versions & Certificate
Publication number: ELQ-25857-1
View all versions & Certificate

Customer Lifetime Value Excel Template
This Excel template helps you to calculate the revenue you receive from a customer over their lifetime.
Reviews
4.6 / 5 (24 votes)- 75%
- 17%
- 4%
- -
- 4%
Write a review
- Excellent modelExcellent model
People using this Best Practice also downloaded
More Best Practices from Ben Murray
Ultimate SaaS Model Package
The Ultimate SaaS Pack includes 23 SaaS templates and one infographic. One downoad, 23 SaaS templates.331Discussadd_shopping_cart$5.00by Ben Murray
SaaS Excel Financial Plan Template
A SaaS financial plan that allows you to create your own financial forecast. Suitable for startups and SMB's.1,457Discussadd_shopping_cartfreeby Ben Murray
SaaS Churn Excel Model Template
This is a ready-to-use Churn template to help record the churn and retention rates for your SaaS business.262Discussadd_shopping_cartfreeby Ben Murray
How to Price Discounts in Multi-year SaaS Contracts
This is a ready-to-use Multi-year Pricing Discount Excel template for your SaaS business accounts.130Discussadd_shopping_cartfreeby Ben Murray
Maximum Company Size in SaaS
Calculate the potential maximum size of your SaaS business based on churn, ARR/MRR, and customer acquisition rate.336Discussadd_shopping_cartfreeby Ben Murray
Customer Acquisition Costs (CAC) Explained
In this short video, learn how to calculate and apply the Customer Acquisition Cost (CAC) formula.148Discussfreeby Ben Murray
SaaS Metrics Excel Cheat Sheet
This SaaS Metics Cheat Sheet contains all the formulas you need when building your first SaaS metrics dashboard or model1,604Discussadd_shopping_cartfreeby Ben Murray
SaaS Revenue Forecast Excel Template
This simple, easy to use excel tool will allow you to calculate accurate revenue forecasts for your SaaS business2,704Discussadd_shopping_cartfreeby Ben Murray
Capital Expenditure Forecast Excel Model Template
Simple Excel Model Template to calculate and forecast the capital expenditure of your SaaS business.3,156Discussadd_shopping_cartfreeby Ben Murray
SaaS Revenue Waterfall Excel Chart Template
A SaaS Excel Model to help you forecast revenue waterfall in simple, automated charts.3,098Discussadd_shopping_cartfreeby Ben Murray
Sales Team Headcount Forecast Excel Template
This Excel spreadsheet template will help you forecast your sales team headcount while scaling bookings.1,683Discussadd_shopping_cartfreeby Ben Murray
Sales Efficiency Metric for SaaS Excel Template
A forgotten sales efficiency metric Excel Template for SaaS businesses, along with instructions on how to use it.481Discussadd_shopping_cartfreeby Ben Murray
Any questions on Customer Lifetime Value Excel Template?
The user community and author are here to help. Go ahead!