• 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

Doha

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