Overview:
Pro Forma Models created this model to analyze the financial return of a for sale condo development project where units and parking spots are sold through the construction process. The model is developed to support up to a 3 phase construction schedule. This means that the project is built and sold through a phasing process. The model allows for an analysis period up to 5 years. The model allows for general project assumptions (unit count, parking spot count, gross developable square feet/meters, efficiency, floor area ratio, etc.) as well as unique user assumptions for the land acquisition and financing, construction phasing, construction costs, construction financing and draws, sale assumptions including velocity phasing, as well as a full return waterfall with 3 tier promote structure including a return of capital and preferred return. The model includes the ability to straight-line construction hard and soft costs or apply an s-curve, which has been proven to be a more accurate representation of construction cost outlays as they follow a sigmoidal curve.
Model Highlights:
- Dynamic pro forma financial model allowing for up to 5-year projection
- Institutional-quality waterfall model including return of capital, preferred return, and three tier promote model
- User defined acquisition, financing, development, operating, and sale assumptions
- Ability to model up to three construction and sales phases
- Dynamic debt schedule allowing for a variety of complex user assumptions
- Institutional-quality actionable reporting output to drive investment decision making
- Fully unlocked and transparent model allowing users to customize
- Support from a team of highly qualified investment and financial professionals
Key Features:
Built for anyone looking to accurately analyze a Condominium Real Estate Development. The model:
- Provides institutional-quality actionable reporting output to drive investment decision making including sources and uses, levered IRR, unlevered IRR, multiples of capital, and capital account balance tracking by year
- Calculates equity requirements and forecast a debt schedule based on a variety of user assumptions
- Waterfall with return of capital, preferred return, and three tier promote structure simplifies complex cash flow distribution between investors and sponsors as well as the developer
- Projects investment value and returns for up to 5-years in advance on an unlevered and levered basis as well as from the perspective of the investor and sponsor as well as the developer
Support:
Built by investment and finance professionals with institutional experience in private equity, real estate, investment banking, consulting, entrepreneurship, and asset management.
Personalized and responsive support is available from our team of highly qualified investment and financial professionals. Please email hello@ProFormaModels.com for support.
Our team is available for custom financial model development and consulting engagements. Please email hello@ProFormaModels.com for a quote.
Condo Development & Sales Model with 3 Tier Phasing, Waterfall, & S-Curve
- Institutional-quality Pro Forma Model developed utilizing best in class standards by a team of experienced investment and finance professionals
- Unlimited downloads and uses of the purchased model
- Lifetime access to updates and future versions of the model
- An example case study showing how to use the model
- Support from our team of experienced professionals