# 13. Return on Investment

Subtitles Enabled

# Sign up for a free trial to access more free content.

Overview

Valuing a company is all well and good but what we ultimately want to know is our return on investment. In this lesson, I calculate the NPV and IRR for a buyer of MarkerCo, given a certain asking price.

Summary

Return on Investment

- Our valuation analysis will help us evaluate a potential bid for MarkerCo
- However, to calculate any return, we first need the price!
- Regardless of our valuation of the company, the price needs to be attractive for a good return

NPV and IRR

- Net Present Value (NPV) is very easy to calculate given our prior work
- Simply subtract the purchase price from Equity Value
- Internal Rate of Return (IRR) is more difficult
- First, we calculate our Year 0 value, which is cash & cash equivalents less purchase price
- Our remaining annual cashflows are the unlevered free cashflows from Year 1 to Year 5
- Don't forget to add in the terminal value as well!

Transcript

Now that we have a valuation for our company, a would-be investor would want to know what return he will get on his investment for buying a stake or all of MarkerCo.

The easiest return to model is if the investor purchases all of MarkerCo. So, in this, our first course in valuation, we'll assume that the would-be investor wants to buy all of MarkerCo's shares. The return on investment is dependent on two things. How much the investor thinks that MarkerCo is worth, and the price he pays for the company. When we approach MarkerCo's CEO, he tells us that the business could be bought for 240 million dollars. And so further up the page, I've entered this value as the asking price of the business. To calculate the MPV on this transaction is very easy as we already have the discounted cash flow calculations completed. So we simply subtract 240 million from our valuation to get the MPV.

So I'll select our implied equity value.

And then enter the asking price. And this gives me a net present value of 83.5 million. Next, let's calculate the IRoR. The internal rate of return or IRoR, is a little more difficult as we need to extract the cash flows from the model. At the end of 2015 or day zero, we need to pay 240 million, but we also have the existing cash on the Balance Sheet on day zero of 69 million which we can use. So in 2015, I have the cash figure and I subtract the asking price of the business. For the remaining years, I simply pull the free cash flows that I calculated previously including the terminal value. So I'll scroll up.

And select the relevant cash flows which will be the annual unlevered free cashflow and the terminal value. And I'll copy across for the remaining cells.

I can now calculate my IRoR by writing equals IRoR and selecting the cash flows.

This tells me that buying the company for 240 million under my best case scenario gives me an IRoR of 20%.

Let's now check what our IRoR would be if we used the pessimistic scenario. So scrolling up.

I select pessimistic and when I get to PgDn, I can see that this effects my IRoR so that it now equals to only 8%. With control zed, I'll flip this back to base.

As you can probably guess, I often run a sensitivity on our IRoR based on say exit multiple and perhaps selling price.

Contents

03:35

05:21

05:14

04:42

03:52

05:29

03:03

04:25

06:05

03:14

06:23

03:44

05:00

#### Exercise 4

My Notes

You can take notes as you view lessons.

Sign in or start a free trial to avail of this feature.