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.
Real Estate Deal Analysis & Advice
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 6 years ago on . Most recent reply

User Stats

100
Posts
56
Votes
Nicholas Cook
  • Real Estate Broker
  • Portland, OR
56
Votes |
100
Posts

Proforma Advice for Multifamily Equity Investment

Nicholas Cook
  • Real Estate Broker
  • Portland, OR
Posted

Hello!

I am working on a pro forma for a new construction project for 55 multifamily units.

Our plan is to bring in an equity partner that will ideally be interested in a long term investment. With that said, we want to be able to demonstrate options in our pitch deck.

My question is are:

1. The first 18 months is going to be construction and lease-up to stabilization. Do I setup year 1 and year 2 to reflect the lack of income/reduced cash flows? This would push the full schedule (12 months) of cash flows to year 3. I assume so, but wanted to confirm.

2. We plan to hold this project long term, but are open to refinancing and return capital in year 5.  Normally I forecast a sale in the pro forma, but I am not sure where to place this. Would year 7 make sense? Given that we don't plan to sell I am not totally clear on how to represent to an investor their return of capital and then future cash flows for an unknown period. 

My goal is to provide a clear NPV and IRR.

Perhaps I am over thinking it. Any input would be greatly appreciated.

Thank you! 

  • Nicholas Cook
business profile image
Sleep Sound Property Management, Inc.
4.5 stars
510 Reviews

Most Popular Reply

User Stats

115
Posts
58
Votes
Hunter Locke
  • Real Estate Investor
  • York, PA
58
Votes |
115
Posts
Hunter Locke
  • Real Estate Investor
  • York, PA
Replied

@Nicholas Cook - For this I recommend Frank Gallinelli's software. I've used the Pro version to do some very complex and creative forecasts and I can't say enough good things about it. It will easily handle question 1 - yes. 

For #2, if it's a long term hold, I'd just put the model out to 20 years (the max in RealData's software) and the investor presentations will show returns by year, including IRR. If memory serves there's a report that shows NPV, but obviously you can get that number out one way or another since it's the cornerstone for the other metrics.

If you want some help with it or want to discuss further, happy to chat, feel free to DM or email me.

Loading replies...