Skip to content
×
PRO Members Get
Full Access
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime.
Level up your investing with Pro
Explore exclusive tools and resources to start, grow, or optimize your portfolio.
10+ investment analysis calculators
$1,000+/yr savings on landlord software
Lawyer-reviewed lease forms (annual only)
Unlimited access to the Forums

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
Followed Discussions Followed Categories Followed People Followed Locations
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 almost 2 years 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...