This is a financial model template for SaaS business models that help to calculate the key metrics of relevance to a SaaS company such as Lifetime Value (Value of customer lifetime sales), CaC (Customer Acquisition Costs), and the CAC Payback Period. (The Payback period of Customer acquisition costs).
There is a 60-month schedule for organizations to track their actual data as well. Visualizations were built off of this and advanced formulas will calculate the present value of the customer lifetime value as well as the LTV to CaC ratio therein.
This model comes as Excel model SaaS Ratio Planner in Excel.