$45.00 USD
- This excel template uses the most recent net operating income (EBITDA can be used as well) to drive the start of the growth and discounting.
- Assumes a terminal growth rate (meaning we are assuming cash flow will be consistent and grow forever into the future.
- Uses a discount rate to discount the value of future cash flows.
- Sums up the total value of all the discounted values into perpetuity (the values get to a point where it takes 1,000 years to add a penny of value.
- Shows a comparison with up to 4 discount rates.
- Visual chart included to demonstrate the valuation relative to the discount rate applied.
This model is something that can also be used with respect to a SaaS model when trying to determine LTV/CAC because of its unique ability to grow and discount cash flow from customers relative to the cost to acquire that customer.
More Valuation Templates:
- Exit Readiness Scorecard Model
- LBO Model with T12
- General Leveraged Buyout Model (LBO) (upgraded version added)
- Small Business Valuation Sensitivity
- Business Valuation Using EBITDA Multiple
- WACC Calculator
- DCF Analysis (monthly)
- DCF Analysis with Sensitivity Tables and IRR
- Interest Rate Swap
- IRR Targeting Template