NEW! Real Estate Development Financial Modeling

A financial model is the heart of any successful investment or development project. As deals reach increasing levels of complexity, they require a level of analysis that is more precise and accurate.  Evaluate the financial feasibility of a real estate development master plan project. Review, audit, and analyze financial models for inaccuracies and inefficiencies.  Optimize the model to make it run faster, implement new functionality, and make it a more powerful analytical tool.

In this course, you will:

• Incorporate infrastructure costs and differentiate among developing empty lots, building single-family houses, and constructing and selling condominiums.
• Account for variability in construction timelines for different types of properties and sensitize the master financial model for per unit and per square foot costs as the project is in planning, construction and post-construction phases.
• Quickly modify assumptions to customize the model to reflect a poor operating environment as the pace of lot sales significantly decline.
• Determine optimal funding mix of equity vs. debt based on cash flows and IRR.
• Construct a similar analysis by evaluating and analyzing the acquisition, construction and renovation of a boutique hotel.
• Perform detailed construction loan analysis that rolls into larger debt funding facility.

Note: Bring your PC laptop with Microsoft Excel installed and a CD-ROM drive. Mac applications may not be as effective.

Prerequisite:  Intermediate proficiency using Excel.

Who should attend? Analysts, portfolio managers, researchers and other finance professionals who want to learn more about real estate financial modeling.