This is a business valuation guide where you easily can get an instant valuation of your company for free. Try it yourself, you will get the value on the screen in less than five minutes.
During quite some time, the site has contained a small business valuation and an advanced business appraisal. These two valuation methods have been great for people with little experience of business valuation. We have long striven to explain the underlying methods in these two formulas more extensively for those who want to perform own valuation [...]
Almost done… But first we need to make the exit assumptions. We use the same EBITDA multiple as when we bought it 6.7 times EBITDA (see input below). Output The LBO valuation is done. Below are the results for our example company: Understanding the results We paid 7 million in equity on the entry date [...]
In this step we shall try to make forecasts of growth and profitability. Steps Go to the tab Scenario in the excel spread sheet The first red circle is around the text “active case 1″. This option determines which scenario to use. 1 is normal case and 2 is the downside case Make assumptions of [...]
In this step you shall enter historic financials of sales and EBITDA margins. Deal inputs Steps Enter sales, EBITDA and taxes Step 3 >>
If you have not yet downloaded the LBO model, it is time to do so, here is the link: LBO model template. Deal inputs Steps USES: Enter the acquisition price, in this example we were offered to but this company for 17.5 million which implied a 6.7 EV/EBITDA multiple INPUT: What leverage will your acquisition [...]
With this sensitivity analysis you can see how the valuation changes with different assumptions and changes in input. This is our sensitivity analysis: Comments To perform a sensitivity analysis like this, you should copy the exact value of your WACC, EBITDA %, Perpetuity Growth and annual sales growth in the middle of each row and [...]
The DCF valuation is almost done, you have made all the inputs required and the enterprise value is already calculated. Now we will try to describe the results and make sensitivity analysis. Below are the results in our valuation example: Comments In the results above you can see the enterprise value of the business and [...]
The terminal value has the largest impact on the valuation and it is extremely important that this input is correct performed. Most values are already given as can be seen below: Steps Perpetuity growth rate is the rate at which the economy is expected to grow, this is normally 2.5% or 3% Make sure the [...]
Next step is to calculate the present value of the generated cash flows in the projection period. Steps Make sure the WACC is correct according to step 6 The Discount Period is set according to the mid year method and could be leaved as is since the cash flow is evenly generated through the year [...]
This section is for you who have access to a database such as Bloomberg or Reuters. If you do not have such access, you can type in: Debt to Total Capitalization: 30% Equity to Total Capitalization: 70% This is the most common assumption when determining capital structure in a business valuation model. However, the below [...]