Construct a robust real estate geared cashflow model from scratch which incorporates debt structures, from senior loans to junior and mezzanine structures.
This course is aimed at financial analysts working for banks, real estate consultancies and property consultancies seeking a best practice approach to building robust real estate debt models.
Delegates will learn to construct a discounted cash flow model for senior debt and mezzanine finance for the investment and lending decisions. Delegates will also learn credit fundamentals which will enhance their property lending analysis and underwriting processes.
Who should attend this course:
The Real Estate Debt Structures and Financial Modelling courses are suitable for those willing to develop their debt origination modelling skills. This is a course aimed at the more experienced professionals and modellers who would like to improve their debt finance understanding and modelling expertise to the next level and comply with credit underwriting criteria.
Details
Duration: 5 sessions (9am-1pm) Online/ 2.5 Days Face to Face
Location: Online/Face to Face London
CPD Hours: 18
Level: Intermediate to Advanced
Course fee: £1695 + VAT (Payment Plan available)/ (Face To Face £2070+ VAT)
Next Dates:
| Location | Duration | Date | Time |
|---|---|---|---|
| Virtual Classroom | 5 Half-Days | 14 & 17-20 May 2021 | 9am to 1pm |
| Virtual Classroom | 5 Half-Days | 9 & 12-15 July 2021 | 9am to 1pm |
| London - Face To Face | 2.5 Days | 8-10 September 2021 | 9.30am to 4.30pm |
| Virtual Classroom | 5 Half-Days | 8 & 11-14 October 2021 | 9am to 1pm |
| London - Face To Face | 2.5 Days | 17-19 November 2021 | |
| Virtual Classroom | 5 Half-Days | 10 & 13-16 December 2021 | 9am to 1pm |
Sessions 1 – 2
Sources of Funds & Lending Criteria
Insurance companies and pension funds
High street and corporate banks
Debt funds and public markets
Mezzanine finance houses
Senior Debt Financial Modelling
Debt Modelling
Constant AmortisationDebt Covenants & Calculations
Operational Covenants: asset maintenance, disclosure requirements, insurance and credit line
Financial Covenants:
- Interest Coverage Ratio (ICR)
- Debt Service Coverage Ratio (DSCR)
- Loan to Value (LTV)
- Debt Yield
Session 3
Development finance (I)
Equity-first modelling
Modelling mezzanine structures
Mezzanine interest and fees
Joint-venture agreements with promote structures
Debt Prioritisation
Modelling cash flow waterfall
Coupon and capital repayment schedule and prioritisation
Maximum loan amount
Credit Analysis
Stress test
Capital adequacy calculations