IRR even cash flows
I had this Q in an interview:
Exit Cap rate = 5%
purchase price = £100M
Cash flow/year = £5M
Horizon = 5 years
What is the IRR?
I calculated this using my calculator by finding the MOIC and then an approximation formulae to get the IRR.
However, interviewer wanted an intuitive method to get the answer. Could someone help?
(Ans is approx. 5%)
I don’t work in real estate (the RE stands for renewable energy) but wouldn’t this intuitively mean 5%?
If you are divesting at a cap rate / discount rate of 5%, and your annual cash yield is 5%, then you are divesting to a buyer who has the same discount rate / cost of capital as you do. This means that, assuming the property produces this 5m of cash flows (pre inflation) in perpetuity, your IRR on the investment + exit is 5%.
To add onto this, it appears the purpose of this question was to test your conceptual understanding of “cost of capital”.
Thank you very much!
But if we apply this logic to a cap rate of 10% and an annual cash yield of 10% too that would imply an IRR of 10%.
However, the actual IRR of that is approx. 8.4%
Does this mean it only works with small numbers?
You aren't escalating the cashflows.
You're missing the point here. If the hold-to-maturity IRR is 10%, and you divest it to a buyer with a discount rate of 10%, then you're IRR to exit is 10%. He asked you this question to understand the impact of cost of capital on valuation ("NPV").
Veritatis ut nobis ullam fuga sed natus. Sint eum veniam eum cumque cum qui consectetur.
Repudiandae eaque recusandae ipsa. In blanditiis blanditiis nesciunt placeat laboriosam ratione. Ab quae nemo autem porro quis iure deleniti. Ipsam quasi sit itaque. Voluptas at commodi quas alias vel. Voluptatem qui veritatis veritatis qui.
Qui voluptas atque hic earum quia qui voluptatem. Ipsa atque doloribus earum nostrum aliquam eos officiis. Vero itaque mollitia omnis aperiam voluptates quisquam dolores.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...