Purchase Ticket

DEFAULT ( Unlimited tickets)
$2699.00
$ 0
0.00
$ 0.00
Please Login to buy ticket!
Real Estate Modelling and Analysis

The course equips you with a comprehension on the various concepts and practices in the real estate sector. Our courses also offers in-depth knowledge of the financial protocols relevant to the real estate market. Consequently, the participants will be equipped with the know-how to formulated advanced and effective real estate financial models independently.

 

Overview

The course will explain the key concepts and metrics involved in the cash flow of real estate. The course is designed to ensure that the participants get thorough insights on whether to own or rent a real estate possession and make practical decision regarding financing and investing in the real estate field. Furthermore, the course also highlights the role of private equity in commercial real estate. 

Who should attend

Anyone who wants to enhance their expertise in. Real Estate modeling and analysis should attend this course, which includes:

  • Middle to senior managers from different industries 
  • All professionals who want to deal or currently deal with financial modeling in their company
  • Consultants, advisors, and other professionals who wish to improve their modeling skills
 

Methodology 

The non-theoretical methodology includes interactive discussions, case studies, interactive games, and assignments to understand the concepts and their applicability.

Trainer

We carefully choose all our trainers with rich and vast experience in the financial sector. The course will be conducted by an experienced training consultant having more than 20 years of industry experience with some of the world’s leading financial institutions, specializing in corporate finance, investment banking, corporate fundraising, company valuation, and asset valuation.

  • Understanding the structure of the real estate segment

  • Reviewing the access points and performance of the real estate market

  • Significance of accounting in the real estate sector

  • Studying the ‘Develop and Hold’ business model

  • Reviewing the ‘Develop and Land Lease/Sell Pads Site’ model

  • Implications of the ‘Develop/Lease-up, and Sell’ model

  • Reviewing the net operating income modeling of residential, commercial, hostels, mix development etc

  • Process of cash flow before debt service modeling

  • Phases in interest expense modeling, metric acquisition modeling, and metric disposition modeling

  • Setting up the transaction and operating assumptions; projecting the construction period

  • Building the pro forma and making return calculations

  • How to make an investment decision based on your conditions and model output

  • How to create a work breakdown structure

  • Setting reasonable deadlines for milestones

  • How to link each of the milestones with the available resources

  • How to calculate the cap rates and net operating income (NOI)

  • Undertaking sensitivity analysis and valuation matrix

  • Reviewing depth service, before tax and after-tax cash flow

  • Assessing the advanced revenue and expense modeling

  • Implications of standard financial covenants and their application to cash flow

  • Importance of various structures, such as amortization

  • Reviewing mezzanine and participation loans

  • Strategic understanding of loan-to- value (LTV) and loan-to-cost (LTC)

  • Significance of debt service coverage ratio (DSCR) and debt yield

  • Studying loan constant: Positive vs. negative leverage

  • Discussing the equity waterfall model

  • Significance of the equity waterfall mechanics

  • How to build a waterfall structure

  • Studying gross profit ratio (GPR), general vacancy, and credit loss

  • Implications of percentage rent and storage income

  • Significance of tenant improvement allowances and leasing commissions

  • Reviewing advanced cash flow modeling

  • How to do sensitivity analysis on suburb property values

  • Assessing the differences between sensitivity and scenario analyses

  • Perform sensitivity and scenario

    analyses

  • Undertaking DCF analysis and cash-on- cash return

  • How to undertake yield-based valuation

  • Reviewing the private equity valuation approach

  • Implications of the hotel and land valuation

  • How to formulate capital reserves
  • Determining the loan proceeds, loan payoff, and total levered cash flows
  • Analyzing levered and unlevered equity multiples
  • Assessing the principal real estate investment analysis metrics
  • Significance of internal rate of return (IRR) and Excel workout
  • Review of capitalization rate, cash-on- cash rate, equity multiple, and Excel workout
  • How to calculate property value per square feet
  • Reviewing the investment analysis investment metrics

Tags

Course Event
  • Date : 18-20 December 2024
  • Time : 9:00 am - 5:00 pm (Asia/Kuala_Lumpur)
  • Venue : Kuala Lumpur
Download Brochure

    Contact for more info.






    Related Public Training

    Real Estate Modelling and Analysis
    Business Model Innovation
    Bangkok

    Business Model Innovation

    The course equips you with a comprehension on

    Real Estate Modelling and Analysis
    Liquidity Risk Management Risk Management
    Singapore

    Effective Liquidity Risk Management

    This interactive workshop course is apt for participants

    Real Estate Modelling and Analysis
    Financial Modeling
    Ho Chi Minh

    Financial Modeling in Excel

    The objective of this program is to provide

    etn/real-estate-modelling-and-analysis-2