عربي
Providing Quality and
Professional Training Since 1984

Our Training Courses

Back
REGISTER_NOW Add to my calendar SEND_COURSE_TO_FRIEND Print this Course

Real Estate Valuation and Investment

Date: 5 November 2017 - 9 November 2017
Course ID: ADDS150/2017
Duration: 5 Days
Fee US $ + VAT: 3200 US$
Venue: Kuala Lumpur / Malaysia
Category: Real Estate Development

Introduction:

The Real Estate Valuation, Finance and Cash flow Course aims to equip the delegates with knowledge and tools to develop a financial model through a case study approach. This will involve forecasting financial statements and deriving business value using advanced Excel tools.

Objectives:

Key Benefits

• Build financial models through stepwise projection of income statement, balance sheet and cash flows.

• Learn to apply advanced Excel tools - Data Tables, Goal Seek, Nested Ifs, Correlation & Regression, VLOOKUP, HLOOKUP, Time Value of Money, NPV and IRR.

• Develop key schedules including debt/interest, depreciation, working capital and equity.

• Master DCF Valuation and Trading Comps Valuation (P/E, P/B, EV/EBITDA, etc.)

• Learn sensitivity analysis and margin of safety principle.

• Learn to apply Montecarlo Simulation

Daily Outlines:

Contents:



• Overview of Financial Modeling



• Advanced Excel tools used in Financial Modeling including Data Tables, Goal Seek, Nested Ifs, Correlation & Regression, VLOOKUP, HLOOKUP, Index, Offset, Time Value of Money Applications, NPV & IRR



• FAST standards for financial modeling



• Structuring input sheet and structuring time sheet using timing flags



• Modeling for assumptions & inputs



• Business Structure & revenue modeling



• Modeling for & projecting operating expenses



• Projecting key schedules including debt/interest, depreciation, working capital and equity



• Stepwise projection of income statement, balance sheet and cash flows



• Ratio analysis and common size analysis



• Beta computation using regression models



• Computing cost of equity using CAPM and WACC



• Estimating Terminal Value, DCF Valuation



• Trading Comps Valuation (P/E, P/B, EV/EBITDA, etc.)



• Scenario analysis



• Introduction to macros



• Summarization & presentation of the final model



• Form controls for scenario analysis



• Monte Carlo simulation & its application in revenue forecasting



• Real estate development



• PLANNING and organizing real estate development



• Real estate development strategies



• Learn strategies and tools to manage the real estate portfolio efficiently



• Real estate market research techniques



• Real estate pricing strategies



• Learn the importance of real estate performance evaluation



• Technological and globalization in the field of real estate

Back
REGISTER_NOW Add to my calendar SEND_COURSE_TO_FRIEND Print this Course