Real Estate Debt Structures and Financial Modelling Virtual Course

  • Time

    10:00am - 3:00pm

  • End Date

    11 Apr, 2022 - 13 Apr, 2022

  • Price

    ₦175,000

Event Details

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.

 

CONTENT

  • Sources of Funds & Lending Criteria
  • Insurance companies and pension funds
  • High street and corporate banks
  • Debt funds and public markets
  • Mezzanine finance houses
  • Debt Covenants & Calculations
  • Operational Covenants: asset maintenance, disclosure requirements, insurance and credit line
  • Financial Covenants: interest cover ratio, debt service coverage, loan to value
  • Senior Debt Financial Modelling
  • Debt Modelling
  • Interest Only
  • Constant Amortisation
  • Constant Repayment
  • Rolled-Up Interest
  • Cash Sweep
  • Cash Trap
  • Revolving Facilities
  • Case study: office building debt lending in the UK (I)
  • Development finance
  • Mezzanine finance
  • Modelling mezzanine structures
  • Overview of inter-creditor agreements
  • Mezzanine interest and fees
  • Debt Prioritisation
  • Modelling cash flow waterfall
  • Coupon and capital repayment schedule and prioritisation
  • Maximum loan amount
  • Credit Analysis
  • Stress test
  • Capital adequacy calculations

 

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.

 

DATE

1ST BATCH:  11th – 13th April, 2022

2ND BATCH: 1st – 3rd Aug, 2022

3RD BATCH: 14th – 16th Nov, 2022

Other Dates

Start Date End Date
01 Aug, 2022 03 Aug, 2022
Start Date End Date
14 Nov, 2022 16 Nov, 2022
Start Date End Date
11 Apr, 2022 13 Apr, 2022

Share this course