Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Multi-Family and Apartment Investing
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated 12 months ago on . Most recent reply

User Stats

73
Posts
14
Votes
Joe Bourguignon
  • Investor
  • Portland, OR
14
Votes |
73
Posts

MF Analysis questions using Steve Berges' analysis tool

Joe Bourguignon
  • Investor
  • Portland, OR
Posted

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

Loading replies...