Certificate in Real Estate Financial Modelling

by Cambridge Finance Claim Listing

This is an exclusive programme offered by Cambridge Finance and in line with the Royal Institution of Chartered Surveyors (RICS) financial modelling competency.

£3790

Contact the Institutes

Fill this form

Advertisement

Cambridge Finance Logo

img Duration

5 Days

Course Details

This is an exclusive programme offered by Cambridge Finance and in line with the Royal Institution of Chartered Surveyors (RICS) financial modelling competency.

Cambridge Finance is the only real estate financial modelling training company regulated by RICS. We are their exclusive partners in their real estate finance and investment content development.

 

Learning Outcomes:

  • Construct fully automated multi-tenant property cash flows from scratch.
  • Audit third-party cash flows.
  • Understand how cash flow inputs and outputs are interlinked.
  • Develop and produce sensitivity and scenario analysis.
  • Give investment recommendation based on quantitative methods.

 

Course Content:

  • Best practice in financial models
  • Simple tips to help you become an efficient financial modeller.
  • How to avoid errors and present your models in a persuasive way
  • Implicit investment valuation methods
  • Term & Reversion
  • Layer / Hardcore
  • Property yields
  • Defining term and reversionary yields
  • Calculating the equivalent yield
  • Build your cash flow from scratch
  • Inputs: passing rent, estimated rental value, initial and exit yields, market growth, review cycles and most
  • importantly, target returns
  • Outputs: internal rate of return, net present value and worth
  • Annual and quarterly discounted cash flows: modelling purchase price, passing rent, rent reviews, exit rent and exit price
  • Analyse the results
  • IRR, NPV and Worth
  • Data tables & sensitivity analysis
  • Risk visualisation (charts)
  • Case study
  • Single-tenant office building in the UK
  • Day 2:
  • Course Content
  • Multi tenant properties
  • Modelling tenancy schedules and rents forecast
  • Rent reviews, upward-only, break options, lease expiry
  • Modelling hypothetical second leases
  • Void period, rent free and estimated rental values
  • Time-varying rental growth
  • Net Operating Income Forecast
  • Modelling capital expenditure for refurbishment and operating costs (letting fees, void costs, empty rates)
  • Investment decision
  • When to accept the project and make investment recommendation
  • Case Study
  • Multi-tenant office building in the UK
  • Day 3:
  • Course Content
  • Capital Structure, sources of debt funds & lending criteria
  • Capital structures: debt & equity
  • Explanation of different debt & equity structures
  • Sources of debt fund & lending criteria
  • Debt Covenants & calculations
  • Operational Covenants: asset maintenance, disclosure requirements, insurance and credit line
  • Financial Covenants: interest cover ratio, debt service coverage, loan to value, debt yield
  • Senior debt repayment modelling
  • Interest Only
  • Constant Amortisation
  • Fully-Amortising Constant Payment
  • Partially-Amortising Constant Payment
  • Rolled-Up (Capitalised) Interest
  • Day 4:
  • Course Content
  • Pro-forma cash flow development modelling
  • Site Purchase
  • Gross Development Value (GDV) versus Net Development Value (NDV)
  • Development Timeline Modelling:  Phases and Duration
  • Development Costs Modelling: Hard Costs and Soft Costs
  • S-Curve
  • Straight-Line
  • Known Costs
  • Mezzanine finance
  • Modelling mezzanine structures
  • Mezzanine interest and fees
  • Debt Prioritisation
  • Modelling cash flow waterfall
  • Coupon and capital repayment schedule
  • Analysis
  • Maximum loan amount based on financial covenants
  • Credit Analysis
  • Stress test
  • Capital adequacy calculations
  • Case study:
  • Office development lending 
  • Day 5:
  • Course Content
  • Real Estate Risk
  • Sensitivity Analysis 
  • Data Tables
  • Scenario Analysis
  • Automatic scenario modelling
  • Simulation Analysis
  • Monte Carlo analysis 
  • Case Study:
  • Learn how to add a real life tenancy schedule and debt facilities into the models. Analyse any investment-grade commercial property transactions in the European markets.
  • London Branch

    120 Regent Street, London

Check out more Financial Modeling courses in UK

City Training UK Logo

Financial Modelling

Using best practice modelling rules and Excel shortcuts, based on real historical financial statements, participants will learn how to forecast and put together a fully integrated financial model. This training will give them the basic modelling fundamentals to continue working on their in-house m...

by City Training UK [Claim Listing ]
  • Price
  • Start Date
  • Duration
BPP Professional Education Logo

Financial Modelling - Advanced (& Introduction to VBA)

This two-day course is designed for those looking to expand their financial modelling skills. Numerous hands-on practical Excel exercises are used to demonstrate different functionality in a modelling context.

by BPP Professional Education [Claim Listing ]
Berkeleyme School of Management and Sciences Logo

Certificate in Advanced Financial Modeling and Valuation

Hands-on practical training course to help you learn exactly what is required to do in your daily work. Up-skill your knowledge to be a Financial Analyst. Practical assignments, illustration spreadsheets, excel shortcuts- all included and can be downloaded at your end for self-practice.

by Berkeleyme School of Management and Sciences [Claim Listing ]
Capital City Training & Consulting Logo

Financial Modelling Course

This programme will train you how to build robust forecast models for companies. You will progressively build an integrated balance sheet, profit and loss, and cash flow forecasting model.

by Capital City Training & Consulting [Claim Listing ]
Financial Fluency Logo

Financial Modelling

We offer courses in financial spreadsheet modeling for both finance professionals. If you are looking for an introduction to financial modeling, a practical guide, a refresher or to enhance your existing understanding then we have the right course for you.

by Financial Fluency [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy