Real Estate Valuation and Modeling Online Course

  • Time

    10:00am - 3:00pm

  • End Date

    13 Dec, 2021 - 15 Dec, 2021

  • Price


Event Details

  • Apply advanced excel tools in project feasibility modeling
  • Project financial statements for a greenfield project
  • Forecast Revenue for lease or sale type real estate project
  • Develop EPC (Engineering, Procurement, and Construction), CapEx (Capital Expenditures) and funding schedule using timing flags
  • Build a project's repayment schedule for various sources of financing
  • Analyze the financial implications for construction, sales and lease phases of real estate projects
  • Assess a project’s financial feasibility from both the lender and the investor’s perspective
  • Calculate NPV (Net Present Value), IRR (Internal Rate of Return), NOI (Return on investment), and other metrics to evaluate the financial feasibility
  • Perform scenario analysis



  • Advanced Excel Tools Used in Real Estate Modeling
  • FAST standards of Financial Modeling
  • Real Estate Modeling: An Introduction
  • Input Sheet and assumptions
  • Forecasting timing sheets and the concept of timing flags
  • Developing EPC and Capex (Capital Expenditures) schedule
  • Forecasting debt repayment and interest schedule (For different types of debt structure)
  • Interest during construction & controlling circular referencing
  • Forecasting Revenue:
    • Lease type project
    • Sale type project
    • Mixed revenue structure
  • Projecting other core schedules like Depreciation, Working Capital and Equity
  • Projecting Income Statement, Balance Sheet & Cash Flow Statements
    • Calculating project’s cost of equity, cost of capital
    • NPV (Net Present Value) and IRR (Internal Rate of Return) analysis for project and investors
    • DSCR (Debt Coverage Ratio) analysis
    • Free cash flow analysis
    • NOI (Net Operating Income) analysis
  • Cash Flow waterfall analysis for different levels of investors
  • Sensitivity analysis of the project changing key inputs



The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.


1ST BATCH:  10th – 12th May, 2021

2ND BATCH: 30th Aug– 1st Sept, 2021

3RD BATCH: 13th – 15th Dec, 2021

Other Dates

Start Date End Date
03 Dec, 2019 06 Dec, 2019
Start Date End Date
25 Jun, 2019 28 Jun, 2019
Start Date End Date
10 May, 2021 12 May, 2021
Start Date End Date
30 Aug, 2021 01 Sep, 2021
Start Date End Date
13 Dec, 2021 15 Dec, 2021

Share this course