Multi-Family and Apartment Investing
Market News & Data
General Info
Real Estate Strategies
Short-Term & Vacation Rental Discussions
presented by

Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Tax, SDIRAs & Cost Segregation
presented by

1031 Exchanges
presented by

Real Estate Classifieds
Reviews & Feedback
Updated 12 months 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