Home › Forums › Ask Us Anything! › Breaking down REPE Course
- This topic has 5 replies, 3 voices, and was last updated 4 years, 10 months ago by
roryhcompton.
- AuthorPosts
- May 23, 2019 at 9:25 am #13861
REPE enthusiast
ParticipantHi Lev,
I have a question regarding Part 2 of the Breaking Down REPE course.
Specifically, at the very end of the video titled “Forecast Entry and Exit Value” the Unlevered IRR in the cash flow section is 11% and the MoC stands at 1.6 x.
Then in the opening of the subsequent excel video “Forecast Real Estate Taxes” I believe you have already added a Returns section that is meant to link to the Unlevered IRR and Unlevered MoC in the cash flow section yet the values are completely different (i.e. Unlevered IRR of 6.6% and Unlevered MoC of 1.33x in green ) Can you please clarify the steps that you took outside the video because from that point onward I can’t get the same results as you in the model.
Much appreciated!
June 2, 2019 at 1:37 pm #13897Lev
KeymasterThanks for your watchful eye. The cash flows between the two videos “Forecast Entry and Exit Value” and “Forecast Real Estate Taxes” are the exact same. The forecast 6.6% UIRR was a holdover artifact from when I had just constructed the backend for the RE tax reassessment. When I went in to investigate your question, I checked that the model used for both videos had the same cash flows. When I refreshed, that 6.6% turned back to an 11%. I’ve carefully reviewed and revised the video to show the proper 11% return the entire time. Thanks!
Just a small note. It is good that you’re paying attention to the UIRR as we build the model, because it shouldn’t ever change unexpectedly. However, the UIRR is not meaningful until we’ve finished projecting all cash flows. I understand why you got hung up on this, but I assure you the continuity of the videos is sound and you can continue relying on the cash flows that you built.
June 19, 2019 at 6:50 am #14298REPE enthusiast
ParticipantGreat, thank you Lev!
June 12, 2020 at 8:16 pm #23097roryhcompton
ParticipantLev,
What does MoC stand for? When it was introduced during the 1st part of the course it was not explained.
June 12, 2020 at 9:44 pm #23105Lev
KeymasterSorry – MoC means Multiple on Capital (sometimes also called Multiple on Cash). It’s a really basic concept. You put in X dollars, you get out Y dollars. MoC = Y/X. So if you buy a building for $100 and sell it for $220, your MoC is a 2.2x.
June 12, 2020 at 10:14 pm #23109roryhcompton
ParticipantThank you sir.
- AuthorPosts
- The forum ‘Ask Us Anything!’ is closed to new topics and replies.