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.