Real Estate Investor (Financial Modelling in Excel)

Bayfield Training

Course

Online

£ 1,750 + VAT

The best Financial Analysis courses

See all

See all

Description

  • Type

    Intensive course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    2 Days

The Real Estate Investor course follows on from the Real Estate Analyst course widening the application financial modelling and commercial considerations to new sectors, geographies and project types. The course includes an introduction to development cash flow modelling, from how to best represent the risks associated with the costs, to methods and considerations of development financing. In addition to the office sector, modelling of retail investment assets and commercial residential development are also covered. Additionally the geographical investment universe is expanded to include how to model pan-European real estate cash flows accounting for different indexation rules and methods.

Important information

Documents

  • Real Estate Investor.pdf

About this course

•Build advanced Real Estate debt models
•Consider both investment and development cash flows
•Discuss in-depth case studies: analysing real property models and identify risk and opportunities
•Learn the full spectrum risk analysis: Sensitivity analysis, scenario analysis and Monte Carlo
•Generate and analyse financial statements from cash flow models

Real Estate professionals at any level with exposure to real estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, debt structures and return metrics
Analysts and Modellers who are making the transition from corporate finance to real estate investment and development
Real Estate Analysts and Investors

Real Estate Analyst.

The CPD accreditation

We received your request and will get back to you with a response as soon as possible.
If you have any further questions, please contact us by email: R.Augustiniene@bayfieldtraining.com.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Investment
  • Financial
  • Financial Modelling
  • Cash Flow
  • Real Estate
  • Development Finance
  • Development appraisals
  • Rent function
  • Profit calculations
  • Modelling

Teachers and trainers (1)

John Piedrahita

John Piedrahita

Trainer

Course programme

Course Outline

Day One
  • Modelling international variations in real estate income streams i.e.
  • Includes indexation patterns, rent caps, discounts/premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
  • Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
  • Further senior debt covenants
  • Advance Rent Function techniques to manage feature rich lease structures
Day 2
  • Introduction to development appraisals
  • Residual models, site and profit calculations
  • Development cash flows versus Investment cash flows
  • Introduction to straight line versus S-curve costing
  • Phased asset sales in development appraisals
  • Discounting development cash flows
  • Complimentary return metrics for development appraisals
  • Introduction to development finance

See related categories

Real Estate Investor (Financial Modelling in Excel)

£ 1,750 + VAT

The best Financial Analysis courses

See all

See all