Question:
Working on a deal now.
Discount Rate: 7%
Unlevered IRR: 10%
Levered IRR 19%
Does this make sense logically, shouldn't Discount Rate and Unlevered IRR be pretty much the same?
| +24 | Thoughts on institutional RE investment advisory roles — between the LP and GP? | 5 | 8h |
| +20 | New to real estate - how to start? | 5 | 2d |
| +18 | Early career advice. | 9 | 2d |
| +17 | Data Center Debt Placement - Opportunity for traditional CRE debt brokers | 4 | 4d |
| +16 | Best WLB in RE Originations? | 9 | 15h |
| +16 | Untrended YoC - Construction Escalation Included? | 9 | 8h |
| +16 | LIHTC Developer Comp | 3 | 3d |
| +4 | Analyst Comp | 11 | 3d |
| +3 | MORGAN STANLEY REAL ESTATE INVESTING OFFCYCLE | 2 | 4d |
| +1 | Harrison Street | 3 | 6h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
IRR is the discount rate that make NPV of all future cash flows equal 0. IRR does not necessarily equal to or as same as discount rate. I rarely see discount rate on a real estate deal, mostly just unlevered and levered IRR.
If your fund has a hard target and limited funds (say its the last one or two investments in that fund) NPV is used using a discount rate equal to the required rate of return.
wtf? you're a "2nd year analyst" and you're asking this question??
Exactly. I had to know this shit to land my first internship back in the day.
I don't think you understand my point.
When I do an IRR sumcheck on my ULIRR cash flow there is a spread between the discount rate.
Logically the two should match, but for the life of me I cant see an issue in my model. Is there any reason a variance between the two would occur?
I'm assuming you're calculating your IRR off the cash flows.
How are you calculating your discount rate of 7%? Why are you calculating a discount rate?
There is no logical reason, this is just a user input error. Try running a =NPV calc on both of them using each rate and see which one gives you a NPV of zero.
(-: thanks all set
Qui quis aut voluptas vel. Voluptates dolores eveniet nihil similique. Maiores veritatis dolores suscipit similique. Quos unde velit iste velit assumenda consequatur.
Voluptate placeat harum soluta corporis rerum reprehenderit voluptas. Est magni et iusto. Inventore vero dolores et quis. Tempore est non minus. Voluptas qui impedit sequi aut. Deleniti eaque quis molestias.
Et vel est voluptatem reiciendis occaecati et numquam. Fugit similique ut neque necessitatibus. Quis illo voluptas vel harum praesentium et. Eos vel et velit qui id praesentium.
Est nemo consectetur sed tempora omnis. Aut quaerat et ut voluptatibus exercitationem totam dolores aspernatur.
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...