DESCRIPTION
These spreadsheets will help you with small or medium business valuation. There are all sorts of tools included in here that give methodology and reasoning along with calculations to come up with a range of values that can be applied to a business. These methods are all quantitative in nature and can be driven by actual financial statement data that is pulled out or from a financial model that is forecasting future expected cash flows of a given business.
Note, these are just to be used as rules of thumb and act more as a back-of-the-envelope style template that is more useful internally rather than externally. It can be useful for business acquirers that want to quickly evaluate a new business or someone that is trying to understand what their own business may be worth.
In general, the valuation methodologies available with these documents center around two things: 1) Applying a multiple to annual EBITDA, SDE, or revenue 2) Forecasting future cash flows and discounting them back to the present value.
There is not a single end-all business valuation methodology that is correct. Many approaches are used out in the real world and no matter what method is used, the result is always going to be some sort of average or midpoint estimation that is derived from a range of low to high valuations.
With these sheets, an instruction video is included (link is in each file) and they are all fully editable and unlocked so you can drop your own data into the input cells and the output values will automatically update.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form.
THERE ARE 10 PRODUCTS IN THIS BUNDLE:
|
|
There are four main quantitative ways to value a business. This model has logic for all four. It walks you through how to calculate each as well as shows up to 6 potential... [read more]
Individual Price: $45.00
|
|
|
Interest rate swaps may seem scary, but both large and small entities do them all the time. It can be used as a hedge or as a bet about future interest rates. Many banks offer... [read more]
Individual Price: $45.00
|
|
|
This template is designed for valuation. It uses DCF Analysis but without a terminal value. Oftentimes you will see a 3/5/10 year model with a terminal value at the exit period.... [read more]
Individual Price: $45.00
|
|
|
This is not looking at the present value of future cash flows in order to come up with the value of a given business. Instead, it is looking at historical EBITDA per year... [read more]
Individual Price: $45.00
|
|
|
People hate math, and you have to do a little of it to convert your discount rates to monthly periods properly.
This is a general use monthly DCF (discounted cash... [read more]
Individual Price: $45.00
|
|
|
One of the oldest and most reliable way to value something is coming up with the present value of all future cash flows that the item will produce.
DCF Analysis templates are... [read more]
Individual Price: $45.00
|
|
|
Tracking IRR by way of using the 'XIRR' function in Excel can be tricky when you are looking at multiple cash flow streams with different start dates. You can't just drag the... [read more]
Individual Price: $45.00
|
|
|
Create up to a 15-year financial projection for any business acquisition that uses debt and equity. The assumptions are not industry-specific, but rather top-down for revenues,... [read more]
Individual Price: $45.00
|
|
|
Earning royalty licensing income is a great form of passive income. This template lets the user forecast sales counts and amounts for up to a 50-year period. The final output is... [read more]
Individual Price: $45.00
|
|
|
This is a simple finance calculator for one of the more widely used figures in investment analysis. It has implications for valuing any business via DCF Analysis methodology.... [read more]
Individual Price: $45.00
|
