Value off IRR

Anyone ever get a case study that simply states to value the property at a predetermined IRR? Basically, have a T-12 and debt terms and be told to model a 5 year hold (income/expense projections and terminal cap my call while having to explain my inputs) and value the deal at a 18% IRR. Would the best way to do this be to do the income & expense UW with a dummy purchase price in an input tab only to back into the actual value via goal seeking the purchase price cell in the model to a leveraged 18% IRR in my proforma tab? 

Real Estate Modeling Course

  • Real-life RE Modeling Tests from actual Interviews
  • Various asset classes including multi-family, commercial and more
  • Huge discount - until more tests and cases added

Comments (6)

Most Helpful
Jun 26, 2021 - 1:56pm

Before I give you the answer, let's step back for a moment.  Remember that conceptually, the IRR reflects the time value of money.  More specifically, in this case study it is reflecting the investor's perception of the time value of their money or said differently, their cost of equity.  IN more simple terms, the investor has a return they want to achieve to give you, the presumed Sponsor, their capital.

So, as your said, one way to do this is to set up the acquisition price as an input and then use Excel to solve back to the pre-determined IRR.

However!  A better way to do this that more clearly illustrates you understand the concept is to forecast the forward cash flows and then discount those back to a Net Present Value (NPV) to determine what you can purchase the asset for using the pre-determined cost of capital as the input.  Thus, the acquisition price is a formula resulting from this input.  As the cost of capital lowers (let's say you find a high-net-worth individual that only needs a 13% IRR), then the price you can pay increases and you can still achieve the target return.

This better reflects the idea of the case study, imo.  And you can better talk towards the concept first and the model second.  This is the difference between an Analyst and beyond.

  • Associate 1 in RE - Comm
Jul 9, 2021 - 9:31am

You wouldn't goal seek, you would just discount the cash flows by 18% each year of the hold period.

Jul 9, 2021 - 3:38pm

Rerum qui iste molestiae. Tenetur hic voluptatibus id reprehenderit.

Quos nemo dolorum ad ut. Qui quis numquam corrupti vitae atque quia. Et quae accusamus necessitatibus blanditiis.

Incidunt placeat ut consectetur sint. Beatae aut autem in tempore perspiciatis sapiente temporibus voluptas. Doloremque quia et voluptatum aut ut. Cumque qui molestiae sunt est praesentium consequatur. Eligendi non porro temporibus ipsum. Fuga quae ut aut quod sed repudiandae sed veritatis.

Eaque deserunt eum aspernatur suscipit officiis. Quaerat laborum ut possimus a. Doloremque dolore quaerat rerum eos quisquam. Laboriosam asperiores qui omnis.

Start Discussion

Total Avg Compensation

November 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (40) $360
  • Associates (234) $234
  • 2nd Year Analyst (144) $156
  • 3rd+ Year Analyst (34) $154
  • Intern/Summer Associate (107) $146
  • 1st Year Analyst (513) $136
  • Intern/Summer Analyst (394) $84