Online Certificate inReal Estate Finance and Investments (CREFI)
100% ONLINE
Active learning · Multidevice Access · English
- 5 Modules to reach a deep understanding of real estate finance and investments
- 40 hours
- Get a big picture of the latest modelling techniques in the real estate industry
- ESCP is at the forefront of Real Estate Education & Research
Presential Training
Madrid - 2 & 3 of April
+ On-line 40 hours in depth Course (optional)
+ On-line 40 hours in depth Course (optional)


Programme Details
Certificate Video
Learn more about the Online Certificate in Real Estate Finance and Investments (CREFI)
Certificate in
Real Estate Finance and Investments (CREFI)
OVERVIEW
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..
With this course, your teams will receive an excellent training that will allow them to learn thoroughly the new trends and techniques in the field of real estate finance and investments.& 6 ECTS
- A variety of interactive content, activities and videos are provided throughout each module. A good command of English and Excel is required.
Price & Inscriptions:
2.200€ Iberinmo Subscribers
2.600€ All other profesionals
ABOUT THE INSTRUCTOR
Jaime Luque
This course is taught by Dr. Jaime Luque, who is a Full Professor of Real Estate at ESCP Business School (#4 business school in Europe in 2024 according to the Financial Times) and holds the Real Estate Tech Innovation Chair-sponsored by the Government of the Principality of Monaco. Professor Luque has taught for decades courses on real estate finance and economics in MBA, MSc, and BBA programmes both in the United States and Europe. Professor Luque is also the recipient of the 2017 Ideas Worth Teaching Award by The Aspen Institute Business and Society Program in the United States for his educational innovations to address affordable housing development. His book Affordable Housing Development provides insights and practical demonstration of important financial tools often necessary to the financial feasibility of affordable housing projects, including TIF and LIHTC.

COURSE OBJECTIVES
- 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
- Run financial feasibility analysis for a real estate development
- Assess the impact of financial and fiscal subsidies to the financial feasibility of an affordable housing development
- Understand the real estate sector by looking at the economic forces that drive real estate business cycles.
- Modify the developer's capital structure to make housing development affordable
CURRICULUM
Real estate markets are 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 completely online programme, you will receive excellent training in real estate finance, investments, and economics. The self-learning methodology will allow you to make progress at your own pace from anywhere in the world to complete 40 hours of diverse interactive content, activities, and videos throughout each of the five modules. All topics are foundational and taught from an international perspective.
Real Estate Valuation
OVERVIEW
- 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.
Real Estate Equity Investments & Capital Structure
OVERVIEW
- 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.
Debt: Mortgage Types, Prepayment, and Refinancing
OVERVIEW
- 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.
Financial Aspects of Affordable Housing Development
OVERVIEW
- This module covers the financial feasibility analysis of affordable housing development and the implications of using fiscal subsidies such as the Low Income Housing Tax Credits (LIHTC) and the Tax Incremental Financing (TIF).
Real Estate Economics & Business Cycles
OVERVIEW
- This module is complementary to the core CREFI modules 1, 2, and 3. It is intended to provide the student with a wider perspective on the real estate sector by looking at the economic forces that drive real estate business cycles. Topics include mortgage debt cycles, real estate induced economic recessions, mortgage markets and wealth inequality, and the financial engineering of Mortgage Backed Securities.
AUDIENCE
- Professionals with no previous studies in real estate who want to enhance their knowledge in the fields of real estate finance, investments, and economics
- 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
- Individuals with undergraduate degrees who want to prepare for more intense programmes such as a Master of Science in Real Estate, a Master of Science in Finance, or a Master in Management
- Young graduates who want to signal real estate expertise in their resumes
- 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
ADDITIONAL BENEFITS
Subscribe to CREFI and become an active member of the ESCP community, attend the Real Estate Association’s events in Madrid, Paris, and London, and gain access to a large network of real estate professionals worldwide.
Testimonials from our Participants
Success Stories

Claudia Russo
Italy
“There is a misconception that working in real estate means selling apartments at an agency. By broadening this common yet limited definition, Real Estate becomes a complex and deep sector with very technical jargon and principles. The CREFI enables students to grasp the specific concepts of the financial side of investments in Real Estate as well as the methods used to value them. It is important to not only be able to follow a pro-forma analysis but also to be able to understand a waterfall spreadsheet and to interpret what a yield is. .”

Rafael Chadelat
France
This certificate allowed me to obtain interviews with prestigious companies and secure my current internship with UIR which has a high volume of acquisitions. I am proud to be part of the ever-growing ESCP Real Estate alumni network.”

Sophia Goppinger
Germany
“This programme gave me the necessary theoretical foundation to further dive into this vertical. I learnt about real estate investment models including operating cash flow, diversification, the US investable capital markets to get an overview and even more. Participating in this course was the best decision that I´ve ever taken because otherwise, I would not be where I am today.”

Ravij Chhabra
India
“The course is very practical: you learn, you implement it and you are ready for the world, which is super appealing. Furthermore, it is so comprehensive that you get to learn everything you need to know about this business (in terms of knowledge and skills), not only about real estate but also about investment banking.”







Why ESCP Business School
is the best option for your Company

Established in 1819,
ESCP Business School is the world's first business school. The School has chosen to teach responsible leadership, open to the world and based on European multiculturalism. Six campuses in Berlin, London, Madrid, Paris, Turin and Warsaw are the stepping stones that allow students to experience this European approach to management.
Several generations of entrepreneurs and managers were thus trained in the firm belief that the business world may feed society in a positive way.
This conviction and ESCP’s values - excellence, singularity, creativity and plurality - daily guide our mission and build its pedagogical vision.

- ESCP is at the forefront of Real Estate Education & Research
- Ranked among the world´s best Business Schools
- Our expertise in Real Estate includes Real Estate Technology & Innovation, Real Estate Big Data & Analytics, Smart Cities & Urban Design, Housing Affordability, Real Estate Finance & Investments, Real Estate Management, Real Estate Development, Real Estate Law
- Our practical approach and flexibility ensures a cutting-edge learning experience

Berlin

London

Madrid

Paris

Turin

Warsaw