INVESTMENT GRADE REAL ESTATE MODELLING

Screen Shot 2016-06-16 at 02.16.17.png
Screen Shot 2016-08-01 at 23.27.54.png
Screen Shot 2016-08-01 at 23.31.35.png
Screen Shot 2016-08-01 at 23.32.43.png
Screen Shot 2016-08-01 at 23.37.24.png
Screen Shot 2016-08-01 at 23.37.36.png
Screen Shot 2016-08-01 at 23.40.48.png
Screen Shot 2016-08-02 at 03.53.27.png
Screen Shot 2016-08-01 at 23.57.57.png
Screen Shot 2016-08-02 at 00.03.51.png
Screen Shot 2016-08-02 at 00.04.50.png
Screen Shot 2016-08-02 at 00.06.25.png
Screen Shot 2016-06-16 at 02.16.17.png
Screen Shot 2016-08-01 at 23.27.54.png
Screen Shot 2016-08-01 at 23.31.35.png
Screen Shot 2016-08-01 at 23.32.43.png
Screen Shot 2016-08-01 at 23.37.24.png
Screen Shot 2016-08-01 at 23.37.36.png
Screen Shot 2016-08-01 at 23.40.48.png
Screen Shot 2016-08-02 at 03.53.27.png
Screen Shot 2016-08-01 at 23.57.57.png
Screen Shot 2016-08-02 at 00.03.51.png
Screen Shot 2016-08-02 at 00.04.50.png
Screen Shot 2016-08-02 at 00.06.25.png

INVESTMENT GRADE REAL ESTATE MODELLING

850.00

The Real Estate Investment modelling training program follows on from the beginners training program “Mastering The Modelling Test”. The investment grade educational program further broadens the application of real estate financial modelling practices. The intermediate guide focuses on the skills, processes and techniques used within the professional real estate investment industry when creating and analysing investment appraisals.

Aimed at real estate investment professionals, analysts, real estate consultants, banking professional and prospective real estate candidates, this course will provide the best practice techniques of constructing flexible investment grade financial models, that assess the financial credibility, risks and returns of property investments.

The program follows a step-by-step guide, explaining how to build a real estate model one cell at a time for a specific transaction scenario. The scenario is complex in nature and incorporates numerous tenants, commercial, retail, parking and naming rights income, re-development opportunities, complicated costing structures and thorough debt financing services.

The training program will show how to present data and construct rental, costing and debt formulaic functions in order to value and appraise property investments. Additionally, the course will also provide an introduction into performing Monte Carlo simulation, producing equity waterfalls, partitioning IRR returns and constructing development cash flow modelling. 

Add To Cart

WHO WILL BENEFIT

  • Undergraduate and postgraduate students studying real estate and finance cognitive degrees
  • Real estate investment analysts, associates and investors that use Excel on a daily basis
  • Senior real estate professionals, debt and lending professionals and investment surveyors
  • Professionals switching industries to real estate investments
  • APC candidates
  • Investment agents, research analysts, fund managers and fund accounts

PRODUCT DETAILS

  • Digital download containing;
    • PDF training guidebook
    • Corresponding password protected and unlocked Excel workbook
    • PDF and Excel PASSWORD received with the order confirmation email
  • Training program level - Intermediate/advanced
  • Training program type - Course attendance not required. Able to study from the comfort of your own home
  • Prior knowledge of Excel and finance is assumed
  • Access to Microsoft Excel and a PC is required. Compatible with Macintosh and Macintosh Excel. However, Macintosh shortcuts not included
  • Refunds not available (Terms and Conditions)

REAL ESTATE INVESTMENT MODELLING OUTLINE

The training program "Investment Grade Real Estate Modelling" will provide users a comprehensive understanding of the following;

  • Learn modelling structures, modelling techniques and real estate theory
    • Introduction to real estate
    • Introduction to Excel and best practice techniques
    • Power modelling and Excel shortcuts
    • Design and model presentation
  • Complex property investment scenario
    • Commercial, retail, parking and naming rights income streams
    • Complicated costing structures
    • Multiples lease events
    • Current and future rental business plans
  • Transaction inputs and specifications
    • Hold periods
    • Target rates, incl. risk-free rates and risk premiums
    • Rental rates
    • Growth rates
    • Investment yields, e.g. initial and exit yields
       
  • Creation and presentation of transaction business plans
    • Current and future tenant lease events
    • Prospective void and rent-free periods
    • Current and future rental rates
    • Projected property values and equivalent yield calculations
    • Void cost and CAPEX budgeting
    • Multiple lease assumptions
       
  • Modelling rent functions and multi-let cash flows for current and future business plans
    • Dates and time intervals
    • Modelling lease expires, lease renewals and upward only rent reviews
    • Incorporating void and rent-free periods
    • Rent function concept using logic functions, incl. IF and AND
    • Distribution of CAPEX, void and letting costs
  • Analysis of unlevered performance metrics
    • Profit margins
    • Cash on cash equity multiples
    • Internal Rate of Return (IRR)
    • Net Present Value (NPV)
       
  • Debt financing
    • Introduction to real estate debt financing, incl. loan to value, arrangement fees, loan repayment types (non-amortisation)
    • Construction of levered cash flows
    • Analysis of levered IRR, NPV, equity multiple and margin
    • Debt refinancing options
    • Development financing
  • Equity waterfall structures
    • Promote structures using NPV functions
    • Post promote IRR returns
    • Development managers promote
    • Sponsor carried interest
  • Scenario analysis
    • Sensitivity analysis
    • Conditional formatting
    • Monte Carlo simulation
    • IRR partitioning
    • Monthly cash flow to annual cash flow conversion
  • Development cash flow modelling
    • Introduction into development modelling
    • Cost appraisal formation and presentation
    • Development strategies - "Develop & Trade" or "Develop & Hold"
    • Development debt and refinancing loans
    • Multiple development investment projects - (i.e. two property units on one project site)
    • Development metrics (IRR, equity multiples, profit on cost, yield on cost, etc)