This is the 13th course in the 16-course Accelerator. In this case-based course, you will learn to model real estate partnership-level returns. Often referred to as waterfall modeling, the process involves forecasting the timing and amount of contributions from and distributions to the partners in a real estate partnership based on the terms of the partnership (i.e. JV) agreement.
In this course you will learn to:
- Forecast the amount and timing of contributions from each of the partners in a real estate partnership
- Model partnership distributions on a monthly and annual basis
- Use several techniques to model preferred return, return of capital, and promote interest
- Build multi-tiered waterfall models with various promote levels based on both Cash-on-Cash and IRR hurdles
- Model double promote structures (i.e. structures with more than one partnership)
- Account for sponsor fees in calculating partnership returns
CASE DESCRIPTION – PARTNERS IN FROST AND MAIN
You are a development manager for A.CRE Development Partners, a boutique real estate development firm in South Florida focused on creative office and mixed-use retail and residential projects. As one of just a handful of real estate professionals at the firm, you’re often required to wear multiple hats and take on more responsibility than many of your friends from college who work at institutional shops.
On top of sourcing land, quarterbacking planning and entitlement, and hiring consultants and general contractors, you’re also tasked with raising capital for the projects you develop. This usually means pitching prospective deals to former investors, friends, and family of the firm’s principals.
This group of early investors in a deal generally provides pursuit capital (i.e. the capital necessary to take a project from bare land to shovel-ready), while the larger equity piece necessary to secure debt financing and take a project vertical (i.e. to build) comes from institutional partners who only invest once a project is fully ready to build. One particular project you’re developing, Frost and Main, was capitalized in this fashion.
Frost and Main is a 210-unit mid-rise apartment project with 40,000 SF of ground floor retail pre-leased to a small format urban grocer. The project is currently under construction, with nearly 50% of the total project cost spent to date. Upon completion, all investors intend to stay in long term. The plan is to take out the construction loan with permanent debt upon stabilization, and then hold the investment for up to 10 years.
The equity capital in Frost and Main consists of friends and family of the firm’s principals at the GP level, with a small pension fund investing the LP equity capital. A local bank is providing a 60% LTC construction loan.
- Office; concepts apply to all property types
- While we recommend using Microsoft Excel, as that is the industry standard, this course will work with most other spreadsheet software such as Google Sheets and OpenOffice Calc
- This course was built using the Google Chrome browser, thus we recommend you use Google Chrome for optimal view experience
- This course is best taken on a desktop computer, although the platform is compatible with tablet and mobile devices
EXCEL PROFICIENCY REQUIREMENT
- The course assumes you have at least a basic proficiency working with Microsoft Excel
Real Estate Waterfall Modeling
Putting It All Together - Frost and Main