I am trying to model a MF development deal with stabilization at month 41 and exit at month 48. At present it seems that I have to use a 5 Year analysis to get the Ai1 model to calculate properly but then it takes yr6 NOI and caps that for an exit at EOY 5. I’m sure there is something I am missing. How do I correct this so that the reversion valuation is yr5 and exit is EOY 4?
Thank you IMMENSELY for creating this beautiful model. It really is a work of analytical art.
Would you mind shooting me your model. You can send it to [email protected]. I’ll take a look and provide a response. More than likely it’s just a matter of manually overriding the ‘Stabilization Date’ (cell M17 of the Summary tab) but I want to make sure there’s not more to it.
