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.
- How governments are handling their own real-estate stock?
- How much real estate is needed for the state sector?
- How the state sector interacts with the private sector?
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.
The Parliament of Hungary issued a program to renew Kossuth Lajos square (the square surrounding the Parliament building) in 2011. As the project went on, its scope has continuously increased, including buildings of the executive as well as the legislative branch, and even private buildings. Is it a good idea to “group” developments based on their actual location rather than their ownership?
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
The case study based presentation is focusing on the application and implementation of complex directions of debt and equity structures in case of restructuring, turn-around and other intensive processes. How can lenders and sponsors minimazing losses or maximizing return-on-equity where the underlying business cases are suffering big losses or gaining extra upside benefit comparing to default case? We are discussing the business rationale of recapitalization, refinancing and earn-out structures, parallel with reorganization and restructuring techniques. There are two planned case studies: a) a "chapter 11" case when borrower and lender are thrown back on each other, b) a property development case, where development expenses and rental/sales prices are booming.
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.