in Real Estate
In partnership with:
Real estate markets are rapidly changing with financing and investment decisions growing in complexity.
The banking sector is also facing a new wave of regulations that is changing the way real estate investors access funding. Mezzanine debt, REITs, and equity capital markets have become an increasing source of funds in real estate deals.
The real estate market is now highly competitive and companies often rely on well-trained workers capable of making investment decision in an environment of complexity. For investors, intermediaries and other real estate players to remain successful, building experience in an exceedingly specialized market has become a must. With this course, you will receive an excellent training that allows you to learn thoroughly the new trends and techniques in the field of real estate finance.
Practice the valuation of revenue generating properties by applying sound asset pricing methods and using Excel to perform pro-forma analysis
Learn how to design mortgages that meet the needs of different investors
Understand the implications of leverage in real estate
Understand the implications of different capital structures in real estate assets
Model sophisticated real estate “waterfall” spreadsheets with Excel for a variety of different capital structures and scenarios
in Real Estate
This lecture will review the basic real estate investment model, which is a necessary step towards the understanding of a more sophisticated analysis of real estate investment decisions which includes multiple layers of debt and equity.
Real estate market has a strong effect on the whole economy and vice versa. As residential property is one of the main assets of households, consumption and saving decisions are strongly influenced by house prices. In the corporate sector, property prices influences demand for new investments, and ultimately has an effect on the construction industry and its suppliers. Finally, residential and commercial real estates are serving as the main collateral type for bank loans. Participants will get a deeper understanding on the relation of the real estate and different sectors.
This lecture introduces the basic concepts and methodology useful for dealing with real estate debt from the investor’s perspective. We will use Excel to compute mortgage payments and balances for a variety of loan types, compute mortgage yields to evaluate mortgages, and model the implications of refinancing and prepayment decisions.
This lecture moves beyond debt to consider sophisticated capital structures with multiple layers of debt and equity. We will extend the setting used in the previous module to construct “water falls” Excel spreadsheets to model a variety of situations.
This lecture relies on a case study that gives students exposure to both the quantitative and qualitative aspects of investing in commercial real estate through a private equity structure. After discussing the case students should be able to:
- Understand the mechanics of private equity
- Create a pro-forma analysis of expected cash flows to outside investors and the private equity firm, and
- Learn to model uncertainty in commercial real estate transactions
This lecture relies on a case study that allows students to understand the impact of distressed mortgage debt on commercial real estate investment projects. Emphasis will be put on the financing aspects of a distressed commercial mortgage debt “workout” between the borrower and the lender.