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
×
Take Your Forum Experience
to the Next Level
Create a free account and join over 3 million investors sharing
their journeys and helping each other succeed.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
Already a member?  Login here
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 about 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! 

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...