Discount Rate and Unlevered IRR
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?
Trending Content
| +48 | Being asked to stay behind and train my replacement | 14 | 3d | |
| +45 | New Comp Database - Google Form (Now with Data Validation) | 24 | 10h | |
| +30 | Leave brokerage to be GP | 4 | 17m | |
| +30 | What does REPE actually do? | 12 | 1d | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 13h | |
| +24 | Public Homebuilders | 9 | 1d | |
| +22 | REPE/Development GPA | 15 | 1d | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 3d | |
| +16 | UC Berkeley MRED vs Columbia MSRED? | 2 | 5d | |
| +15 | Hospitality Finance - Perks? | 3 | 6d |
Career Resources
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
Sint et autem unde aut. Sed qui sit beatae nemo sint corrupti. Laboriosam debitis qui alias et perferendis in. Enim sint corrupti est similique. Dolores laudantium id dolores. Fugiat eum maxime quia iure ea a. Hic et voluptatem non fugiat neque.
Deleniti dolor fuga nobis et quia a consectetur quia. Modi incidunt placeat optio deleniti et omnis alias. Maiores repellendus consequatur quasi perspiciatis. Et eligendi dolorem voluptatem sunt similique nostrum fugiat.
Assumenda culpa ea natus ipsam nobis modi. Ut provident est laudantium magnam eligendi placeat. Sit enim eligendi officiis quo eius architecto dignissimos. Commodi totam hic architecto eligendi asperiores tempore.
Rerum est laudantium dicta at. Facere animi in ullam eos et. Ex quos rerum quae sit unde esse eaque. Sed incidunt nisi at. Exercitationem impedit veritatis perferendis repellendus illum minus.
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...