Search courses 👉
Corporate Training for Teams

Real Estate Private Equity Modelling in Excel - In-house

Bayfield Training, Nationwide
Length
2 days
Next course start
Enquire for more course dates, delivery options, location and price. See details
Course delivery
In Company
Length
2 days
Next course start
Enquire for more course dates, delivery options, location and price. See details
Course delivery
In Company
Leave your details so the provider can get in touch

Course description

Bayfield Training

Learn how to structure and model Real Estate Private Equity Funds. The course models the link between individual project appraisals taught on our Real Estate Financial Modelling School and the entity that purchases them. The individual property and tenant variables are combined from their NOI and incorporated into a three-statement operating model. You will also learn how to design an incentive scheme, model the distribution of dividends and value the fund. A variety of scenarios are then modelled such as Leveraged Buy-Outs (LBOs) and Venture Capital Contributions. Finally, you will test the key drivers of the underlying assets on overall returns.

On this course you will:

  • Build a Real Estate Private Equity Fund model
  • Understand Private Equity market structure and strategies
  • Understand the basics of Fund Valuation and related metrics
  • Review accounting principles as applied to Real Estate Funds
  • Model dividend policy and distributions under various scenarios
  • Analyse risk using metrics, tables and charts
  • Use risk analysis techniques to further define fund structures

Included in the Course

  • A Bayfield Training Certificate
  • Course Manual (In-Person Course Delegates receive a Hard Copy, Virtual Course Delegates receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee)
  • Course Files
  • Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
  • Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee

Upcoming start dates

1 start date available

Enquire for more course dates, delivery options, location and price.

  • In Company
  • United Kingdom
  • English

Suitability - Who should attend?

Who is this course for?

  • Private Equity Fund Managers
  • Investment consultants and Financial advisers working with Fund Managers
  • Finance professionals supporting institutional Investors
  • Private Bankers and Family office representatives
  • Real Estate professionals looking to expand their knowledge in corporate finance
  • Recent Graduates interested in learning how to model private equity deals

Prerequisite:

Real Estate Analyst

Training Course Content

Day One

Understanding a Private Equity Fund Model

  • Layout and key elements of a PE Model
  • Private equity market and strategies
  • Understanding the deal structure and interested parties
  • Understanding the capital structure
  • Review of the key debt instruments
  • Review of the key equity instruments (special case of Management Buyout)

Fund valuation methods

  • The multiples approach to valuation
  • Discounted Cash Flow (DCF), modelling and core concepts
  • Private Equity performance metrics
  • Pre-money vs Post-money valuation
  • Special Cases

Review of accounting principles

  • Balance Sheet: Real Estate Valuations and Debt
  • Profit & Loss: Capital Allowances
  • Cash Flow statement: Escrow Accounts and Distributions

Day Two

Modelling Fund Dynamics, Drivers and Forecasting

  • Forecast of revenue and cost drivers
  • Indirect costs and historical ratios in the working capital schedule
  • Amortization/Depreciation schedule and capital expenditures
  • Debt schedule and the cash available to service the debt
  • Modelling dividend distributions
  • Shareholder’s equity schedule and completing the income statement
  • Modelling and Analysing Risk

Performance Analysis

  • Benchmarking returns within Real Estate and across industries
  • Analyse leverage and coverage ratios
  • Calculating Equity Returns Using EBITDA or Net Income

Why choose Bayfield Training

Over 25 years in business

Original Content, Unique Delivery

+90% courses review rating from past delegates

Customer Outreach Award 2019

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Request info

Contact form

Fill out your details to find out more about Real Estate Private Equity Modelling in Excel - In-house.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Bayfield Training
Bayfield Training c/o
FORA, 20 Station Road
CB1 2JD Cambridge Cambridgeshire

Bayfield Training - Real Estate Executive Education 

Bayfield Training is a prominent global supplier of investment grade Real Estate executive education. Having begun 25 years ago as pioneers in the field of Real Estate Financial Modelling, today Bayfield has a huge extended network of experts, specialists and...

Read more and show all courses with this provider

Ads