Two-Day Programme
Delegate places are limited due to the practical nature of the course. Laptops are provided.
Case Overview
- Real estate modelling – objective and overview of methods
- Market overview
- Basic modelling rules and standards
- Modelling theory
- Real estate modelling problems
- Timing
- Yield and finance theory
Case Outline
- Inputs and assumptions
- Project and construction
- Costs
- Loans and leverage
- Desired outputs
- Risk factors
- Initial accounting statements
Income and Revenue
- Breakdown of revenue
- Developing income and revenues schedules
Forecasts
- Construction and other costs
- Required workings
- Modelling techniques and methods
- Avoiding modelling errors
Loans and Depreciation
- Depreciation methods
- Building up depreciation schedules
- Amortisation methods
- Types of loans
- Loans payments and capital outstanding
Initial Results
- Cash flow
- Measures of yield
- Cost of capital
- NPV and IRR
- Debt coverage and covenants
Modelling Risk
- Identification of key variables
- Sensitivity
- Understanding the behaviour of variables
- Adjusted returns
Analysis and Reporting
- Analysing results
- Reporting methods
- Different audiences
- Output presentation