Hello! and welcome. You have arrived at the valuation spreadsheet bundle. These financial models are designed to help you come up with a value for future operations or current business operations.
- LBO Model - Leveraged buyout model with robust acquisition, operating, and exit inputs.
- Business Valuation - Uses a weighted EBITDA multiple for 1-5 years + net assets.
- 4-Method Valuation - Sensitivity for SDE, EBITDA, Revenue, DCF business valuation.
- WACC Calculator - Step-by-step guide with formulas for all components of the WACC calc.
- Interest Rate Swap - Value fixed and floating cash flow streams based on future rates.
- DCF Analysis (monthly periods) - Calculates NPV and IRR based on monthly cash flows.
- DCF Analysis with Sensitivity Tables - 24 NPV / IRR outputs. Sensitize discount rate, more.
- IRR-based Distributions - Plug in IRR and cash in/out per period. Shows ending balance.
- Gordon Growth Model Valuation Technique - Discount future cash flows until 0 and sum.
There are general methodologies like a monthly DCF Analysis as well as a sensitivity version that shows net present value (NPV) for up to six discount rates and four cash flow scenarios with some cool visualizations (IRR calculation included). For a business that has historical performance, there is an EBITDA multiple valuation sheet that allows for weightings of the EBITDA over the past 5 years.
Finally, there is also a spreadsheet built on the Gordon growth model, which is basically a dividend discount style of figuring out present value of future cash flows into perpetuity.
Purchasing on a mobile device? No problem. You will receive an email with a download link for the purchased files that you can access on any spreadsheet friendly device later (desktop / laptop).
Billable Hour Promotion: If you pay for 1 hour of billable work here, you can get 1 template at no charge (scales up for as many credit hours as you buy). Just email me which one(s) you want: jason@smarthelping.com
