عربي
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: 10 July 2017 - 14 July 2017
Course ID: ADDS068/2017
Duration: 5 Days
Fee US $: 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