We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we'll assume that you are happy to receive all cookies on the ESCP website. However, if you would like to, you can change your cookie settings at any time.


Certificate in
Real Estate Finance and Investments

With the Certificate in Real Estate Finance and Investments, students will be well prepared to confidently pursue a career in commercial lending and real estate finance.

Real estate markets are 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 Certificate, you will receive an excellent training that allows you to learn thoroughly the new trends and techniques in the field of real estate finance and investments.



Learn to use Excel to undertake pro-forma analysis and practice the different methods of valuing a revenue generating property 


Understand the different mortgage types available to investors and learn how to design them


Calculate mortgage debt with a prepayment option


Master the best ways of refinancing debt


Recognize the role of debt within the real estate industry, as well as its benefits and risks


Learn how the different capital structures of real estate assets are determined and calculated


Learn how to calculate cash flows of real estate assets with varying capital structures and scenarios using real estate "waterfall" spreadsheets on Excel


Model sophisticated real estate “waterfall” spreadsheets with Excel for a variety of different capital structures and scenarios


  • Introduction to Real Estate Valuation

Introduction to Real Estate Valuation

In this module, we will review the basic formulas and procedures for converting typical real estate future cash flows and risk patterns to present value. In doing so, we will use Excel for finding numerical solutions.

  • Commercial Mortgage Debt

Commercial Mortgage Debt

The real estate debt market is a large, deep and sophisticated source of funding that requires a rigorous modelling and quantitative analysis. In this module, we will introduce 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.

  • Real Estate Equity Investments & Capital Structure

Real Estate Equity Investments & Capital Structure

This module moves beyond debt to consider sophisticated capital structures with multiple layers of debt and equity. We will extend our benchmark model to construct “waterfalls” Excel spreadsheets to model a variety of situations, such as private equity investment. At the end of this module, students will be able to create sophisticated Excel spreadsheets and run sensitivity analyses covering the whole spectrum of real estate finance decisions.


  • Individuals with undergraduate degrees who are considering additional education in real estate finance or have an interest in exploring real estate as a professional area of interest
  • Professionals with an MBA or other master’s degree who are ready to advance or change careers
  • Master and MBA students who need an extra specialized certification as part of their curriculum

Fees - €2.000

Page Last Modified : 23/10/2020