Updated almost 2 years ago on . Most recent reply
MF Analysis questions using Steve Berges' analysis tool
Hey, all! I'm trying to get myself set up with some analysis tools for MF investments, and I really like the "Value Play" model that Berges has in his "Complete Guide to Buying and Selling Apartments". I understand where he is getting most of his numbers from, except for the bottom area of his model, starting with "Net CFs from Investment - 1 Yr exit" (and everything below). If somebody could help me understand how he's calculating these numbers, I'd love it! Spreadsheets don't paste well here, but here is what I'm looking for:
| Net CFs From Investment 1yr exit | |||
| Net CFs From Investment 3yr exit | |||
| Net CFs From Investment 5yr exit | |||
| Exit Price | Gain on Sale | Cap Rate | IRR |
| Estimated Exit Price/Gain on Sale - 1 Yr | Annualized IRR - 1 Yr | ||
| Estimated Exit Price/Gain on Sale - 3 Yr | Annualized IRR - 3 Yr | ||
| Estimated Exit Price/Gain on Sale - 5 Yr | Annualized IRR - 5 Yr |
Thanks!
-joe



