Skip to content
×
PRO
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
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. 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 11 months ago,

User Stats

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

MF Analysis questions using Steve Berges' analysis tool

Joe Bourguignon
Pro Member
  • 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...