JV Modeling
Hi Folks,
I just received contradictory information from 2 sources and I thought you all would be best to clear it up.
Do you include the equity contribution(cash outflow) in a waterfall model in year 1 or year 0?
Hi Folks,
I just received contradictory information from 2 sources and I thought you all would be best to clear it up.
Do you include the equity contribution(cash outflow) in a waterfall model in year 1 or year 0?
+48 | Being asked to stay behind and train my replacement | 14 | 3d | |
+45 | New Comp Database - Google Form (Now with Data Validation) | 24 | 8h | |
+30 | What does REPE actually do? | 12 | 1d | |
+28 | Leave brokerage to be GP | 2 | 54m | |
+24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 11h | |
+24 | Public Homebuilders | 9 | 1d | |
+22 | REPE/Development GPA | 15 | 1d | |
+17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 3d | |
+16 | UC Berkeley MRED vs Columbia MSRED? | 2 | 5d | |
+15 | Hospitality Finance - Perks? | 3 | 6d |
Career Resources
zero
Year zero. 100% correct.
zero
JV modeling question (Originally Posted: 03/03/2015)
The refm jv tutorial teaches JV modeling by taking the distributions and using "Investor Injections, Investor Accruals, Tier 1 Annual Distribution, Tier 2 Annual Distribution" lines. The cf difference between hurdles lie in the "Investor Accruals"
In my experience, there is a way of doing JV modeling using the NPV function and a FV factor. I personally prefer the FV factor method as there are less formulas. Does everyone know what I'm referring to? What method do you prefer and why?
I'd be shocked if you heard anyone from a RE AM/PE background use the phrase "investor accruals." That smacks of accounting to me.
"They are making this much"
Why would you be shocked? Are you not in RE PE, and you're just making an uneducated assumption? Accruals are the most important element of waterfall calculations.
=FV(NOMINAL(RATE,12)/12,MONTH,,NPV(NOMINAL(RATE,12)/12,CF1:CFX)+-EQUITY BASIS)
Agree, do you normally use this formula for waterfalls..trying to get the sense of who uses this compared to the "investor accruals between hurdles" method. Also trying to get sense of sophistication of this method vs. others and which shops uses which.
i only use them for lookback calc on non-condo deals (deals with a residual, where the IRR is made up almost entirely of that last CF). otherwise i use the accrual / equity balance / equity repayment method. but every shop has different jv models. interested to hear other responses as well
We only use the accrual method. The formulas I use / have seen for calculating accruals are the following:
1) Beginning Equity Balance * [ (1+hurdle rate)^(1 / # of Periods) -1 ]
2) (Beginning Equity Balance * hurdle rate) / # of Periods
If we were to take a preferred return of 12.0% compounded monthly:
Example #1 returns after:
1 month: accrual return of 0.95% 1 year: accrual return of 12.00%
Example #2 returns after:
1 month: accrual return of 1.00% 1 year: accrual return of 12.68%
Maxime cum iste magni aspernatur eligendi culpa. Fugit dignissimos libero voluptatem ex. Maxime facere quod qui consectetur sapiente laudantium a. Omnis ea repudiandae iste alias totam repellendus. Dignissimos minima natus sint dolorem quae. Laboriosam ad asperiores tempore autem.
Assumenda distinctio tempore voluptatem sequi exercitationem voluptas. Soluta quasi et accusamus et harum non. Voluptatem aspernatur placeat quia. Voluptatem nesciunt deleniti corrupti placeat voluptas odio eum.
Quasi rerum vel accusamus rerum. Itaque fugiat blanditiis ipsum dignissimos. Ex iusto odio et perferendis quo. Doloribus molestiae cumque ea. Quod ipsam reiciendis hic dolorum voluptas nihil velit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...