• 00601137646003
  • info@iahrd.com
  • Home
  • courses
  • All about Real Estate Cashflow and Finance Modelling

All about Real Estate Cashflow and Finance Modelling

All about Real Estate Cashflow and Finance Modelling

ACCOUNTING, FINANCE AND BANKING


All about Real Estate Cash flow and Finance Modelling

Introduction:

This course is introduced to you by the International Academy of Human Resources Development (IAHRD). Our courses are specially designed to meet your needs, explained to you by experts with a long experience in the field. Using financial models and having good knowledge in them has become a must due to the lack of planning that most businesses suffer from. This lack of planning has dramatic consequences and bad decisions that were and still made.This course provides a systematic guide to constructing financial models for real estate development and investment in Excel. Delegates first learn the skills and techniques they will need for real estate modelling. Then, using the construction of an office tower as the working project, delegates build successively a ‘construct and sell’ and ‘buy and let’ model.

 

Objectives:

After attending this course, participants will be able to:

  1. Understand the basic terms needed to complete the course.
  2. Develop a real estate financial model for construction and investment using Microsoft Excel.
  3. Grasp the benefits of real estate cash flow and finance modelling.
  4. Audit Excel real estate financial models.
  5. Use real estate asset valuation techniques.

 

Content:

Module 1:

    1. Introduction to real estate and cash flow.
    2. Basic terms to understand.
    3. Why to care about real estate cash flow and finance modelling?

Module 2:

    1. Loan to value (LTV).
    2. Loan to cost (LTC).
    3. Net operating income (NOI).
    4. Cap rate and amortization period.

Module 3:

    1. Introduction to excel.
    2. Using Excel for modelling
    3. Equity valuation
    4. Fundamentals of real estate models.

Module 4:

    1. Building your own models for development projects.
    2. Real estate development modelling issues
    3. Real estate investment modelling issues

Module 5:

    1. Systematic Building a Construct and Sell (CS) model
    2. Systematic Building a Discounted Cash Flow (DCF) model
    3. Another alternative to Excel real estate models (Argus and Estate Master).

Module 6:

    1. Return on sales.
    2. Return on costs.
    3. Sensitivity analysis.
    4. Case study.
    5. Recommendations.

Who Should Attend?

  1. Bankers.
  2.  
  3. Directors and Business Development Executives.
  4. Interested candidates.

 

Istanbul

# Price ($) From
d-m-Y
To Action
1 3,250 24-02-2019 28-02-2019 Enquire
Course Code:265
2 3,250 21-04-2019 25-04-2019 Enquire
Course Code:266
3 3,250 23-06-2019 27-06-2019 Enquire
Course Code:267
4 3,250 25-08-2019 29-08-2019 Enquire
Course Code:268
5 3,250 20-10-2019 24-10-2019 Enquire
Course Code:269
6 3,250 22-12-2019 26-12-2019 Enquire
Course Code:270

Kuala Lumpur

# Price ($) From
d-m-Y
To Action
1 2,950 18-02-2019 22-02-2019 Enquire
Course Code:523
2 2,950 15-04-2019 19-04-2019 Enquire
Course Code:524
3 2,950 17-06-2019 21-06-2019 Enquire
Course Code:525
4 2,950 12-08-2019 16-08-2019 Enquire
Course Code:526
5 2,950 14-10-2019 18-10-2019 Enquire
Course Code:527
6 2,950 16-12-2019 20-12-2019 Enquire
Course Code:528

London

# Price ($) From
d-m-Y
To Action
1 4,500 11-02-2019 15-02-2019 Enquire
Course Code:787
2 4,500 08-04-2019 12-04-2019 Enquire
Course Code:788
3 4,500 10-06-2019 14-06-2019 Enquire
Course Code:789
4 4,500 05-08-2019 09-08-2019 Enquire
Course Code:790
5 4,500 07-10-2019 11-10-2019 Enquire
Course Code:791
6 4,500 09-12-2019 13-12-2019 Enquire
Course Code:792

Amsterdam

# Price ($) From
d-m-Y
To Action
1 4,500 25-02-2019 01-03-2019 Enquire
Course Code:922
2 4,500 24-06-2019 28-06-2019 Enquire
Course Code:923
3 4,500 21-10-2019 25-10-2019 Enquire
Course Code:924

Athens

# Price ($) From
d-m-Y
To Action
1 4,500 18-02-2019 22-02-2019 Enquire
Course Code:1054
2 4,500 17-06-2019 21-06-2019 Enquire
Course Code:1055
3 4,500 14-10-2019 18-10-2019 Enquire
Course Code:1056

Barcelona

# Price ($) From
d-m-Y
To Action
1 4,500 11-02-2019 15-02-2019 Enquire
Course Code:1186
2 4,500 10-06-2019 14-06-2019 Enquire
Course Code:1187
3 4,500 07-10-2019 11-10-2019 Enquire
Course Code:1188

Copenhagen

# Price ($) From
d-m-Y
To Action
1 4,500 04-02-2019 08-02-2019 Enquire
Course Code:1318
2 4,500 03-06-2019 07-06-2019 Enquire
Course Code:1319
3 4,500 30-09-2019 04-10-2019 Enquire
Course Code:1320

Frankfurt

# Price ($) From
d-m-Y
To Action
1 4,500 28-01-2019 01-02-2019 Enquire
Course Code:1450
2 4,500 27-05-2019 31-05-2019 Enquire
Course Code:1451
3 4,500 23-09-2019 27-09-2019 Enquire
Course Code:1452

Madrid

# Price ($) From
d-m-Y
To Action
1 4,500 21-01-2019 25-01-2019 Enquire
Course Code:1582
2 4,500 20-05-2019 24-05-2019 Enquire
Course Code:1583
3 4,500 16-09-2019 20-09-2019 Enquire
Course Code:1584

Milan

# Price ($) From
d-m-Y
To Action
1 4,500 14-01-2019 18-01-2019 Enquire
Course Code:1714
2 4,500 13-05-2019 17-05-2019 Enquire
Course Code:1715
3 4,500 09-09-2019 13-09-2019 Enquire
Course Code:1716

Munich

# Price ($) From
d-m-Y
To Action
1 4,500 07-01-2019 11-01-2019 Enquire
Course Code:1846
2 4,500 06-05-2019 10-05-2019 Enquire
Course Code:1847
3 4,500 02-09-2019 06-09-2019 Enquire
Course Code:1848

Paris

# Price ($) From
d-m-Y
To Action
1 4,500 29-04-2019 03-05-2019 Enquire
Course Code:1978
2 4,500 26-08-2019 30-08-2019 Enquire
Course Code:1979
3 4,500 30-12-2019 03-01-2020 Enquire
Course Code:1980

Stockholm

# Price ($) From
d-m-Y
To Action
1 4,500 29-04-2019 03-05-2019 Enquire
Course Code:2110
2 4,500 26-08-2019 30-08-2019 Enquire
Course Code:2111
3 4,500 23-12-2019 27-12-2019 Enquire
Course Code:2112

Vienna

# Price ($) From
d-m-Y
To Action
1 4,500 22-04-2019 26-04-2019 Enquire
Course Code:2242
2 4,500 19-08-2019 23-08-2019 Enquire
Course Code:2243
3 4,500 16-12-2019 20-12-2019 Enquire
Course Code:2244

Zurich

# Price ($) From
d-m-Y
To Action
1 4,500 15-04-2019 19-04-2019 Enquire
Course Code:2374
2 4,500 12-08-2019 16-08-2019 Enquire
Course Code:2375
3 4,500 09-12-2019 13-12-2019 Enquire
Course Code:2376