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 are 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 decisions 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 excellent training that allows you to learn thoroughly the new trends and techniques in the field of real estate finance and investments.
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
Learn about different policies and fiscal instruments for developers used worldwide to make housing more affordable
Model sophisticated real estate “waterfall” spreadsheets with Excel for a variety of different capital structures and scenarios
Learn about Trends in PropTech and potential business opportunities in the real estate sector
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
Join an exclusive guided tour to the newly opened Hungarian Money Museum. The guests will be welcomed with an exciting display of interactive games and visual demonstrations, all centered around the world of money. The museum houses 58 impressive installations and almost 2,000 works of art. By playing at the Money Museum, you can learn how to handle money, a lesson for us all. You can not only inspect different currencies and discover the detail on the paper with the help of a super magnifier but also print your own with your portrait on it!
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.
At the end of this last day, Professor Jaime Luque will provide an overview of the trends in new real estate technologies, followed by an open discussion about potential business opportunities in the real estate sector.