DIFFICULTY LEVEL: Intermediate
CPD HOURS: 9.0


DIFFICULTY LEVEL: Intermediate
CPD HOURS: 9.0
Debt and financing are central to commercial real estate investment and development. Understanding how loan structures work - and how to model them accurately - is essential for analysing risk, evaluating returns, and making informed investment decisions.
This course provides a practical introduction to real estate debt modelling and financing analysis using Excel and real-world commercial property examples.
You’ll learn how to interpret term sheets, understand different loan structures, model debt drawdowns and repayments, calculate financing costs, and analyse key lender covenants including Loan to Value (LTV), Interest Cover Ratio (ICR), and Debt Service Cover Ratio (DSCR).
The course also explores refinancing, hedging structures, leveraged cash flow modelling, and debt-related return analysis, helping you understand how financing impacts investment performance across both investment and development transactions.
Whether you work in acquisitions, investment, development, valuation, or lending, this course provides practical debt modelling skills used across the commercial real estate industry.
By the end of this course, you’ll be able to:
Understand the fundamentals of commercial real estate debt and financing structures
Interpret loan term sheets and understand key financing terminology
Model different types of real estate loans and debt facilities in Excel
Build leveraged cash flow models for investment and development projects
Calculate debt drawdowns, repayments, and financing costs
Model interest calculations, arrangement fees, exit fees, and rolled-up costs
Understand and model refinancing scenarios within real estate cash flows
Analyse debt covenants including LTV, ICR, and DSCR
Understand the role of hedging structures including swaps, caps, and floating rate debt
Evaluate leveraged returns and the impact of financing on investment performance
Apply Excel modelling techniques and error-checking methods used in debt analysis
Improve your understanding of commercial real estate finance and underwriting principles
This course is designed for professionals looking to strengthen their understanding of commercial real estate debt, financing structures, and leveraged financial modelling.
It is particularly valuable for:
Real estate analysts and financial modellers
Investment and acquisitions professionals
Development and underwriting professionals
Debt advisory and lending professionals
Surveyors and valuation professionals working with leveraged cash flows
Anyone involved in commercial real estate finance or investment analysis
A basic understanding of Excel and real estate financial modelling is recommended. No prior debt knowledge is required.
Real estate debt modelling involves analysing how loan facilities, financing costs, repayments, and lender covenants impact investment and development cash flows.
Yes. The course teaches you how to build leveraged investment and development cash flow models in Excel using practical real estate financing examples.
Yes. The course includes modelling and analysis of key debt covenants including Loan to Value (LTV), Interest Cover Ratio (ICR), and Debt Service Cover Ratio (DSCR).
Yes. The course explores refinancing assumptions, refinance drawdowns, repayment structures, and how refinancing impacts cash flow analysis.
Yes. The course includes an introduction to hedging structures including swaps, caps, floating rate debt, and related financing considerations.
This course is best suited to professionals with a basic understanding of Excel and real estate financial modelling who want to improve their debt and financing analysis skills.