Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Real Estate Private Equity Modelling in Excel
On going

By: Alpha Partners  

Ghana

18 - 22 Nov, 2024  5 days

Follow Event

  

USD 6,000

Venue: SunLodge Hotel, Off Achimota - Circle Road behind the Shell Filling Station at No. 76, 4th Road (Saxel Estates) Tesano – Accra, Ghana.

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.

Content

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

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
  • Deconstructing and using a Return-on-Investment Capital (ROIC) tree.

Training Methodology

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.

SunLodge Hotel, Off Achimota - Circle Road behind the Shell Filling Station at No. 76, 4th Road (Saxel Estates) Tesano – Accra, Ghana. Nov 18 - 22 Nov, 2024
USD 6,000.00(The Workshop fee is $6000 (Six Thousand US Dollars) only per participant to cover workshop literature and materials, executive bag, tea/coffee, lunch, photograph and certificate.)
(Convert Currency)

Chris Onwuasigwe, FCA – 08033045484 08033045484

5% discount for 3-6 participants and 10% discount for 7 and above number of participants from the same organization.
A distinguished team of facilitators who are eminently qualified professionals has been assembled to lead discussions in course of the workshop.

Related Courses

Effective Minute Taking Course Effective Minute Taking Course

5 days, 25 - 29 Nov, 2024 

2024-11-25 12:11:00 2024-11-25 12:11:00
Ghana

Alpha Partners

This course is designed for aspiring and experienced sales professionals who want to develop the core competencies necessary for successful selling. It covers essential concepts and ...

Fraud Risk Management Techniques for Internal Auditors Fraud Risk Management Techniques for Internal Auditors

5 days, 02 - 06 Dec, 2024 

2024-12-02 12:12:00 2024-12-02 12:12:00
Ghana

Alpha Partners

In this course participants will learn the specifics of fraud and fraud risk management. They will understand the most common types of fraud such as manipulation of assets, financial statement ...

Effective Livestock Extension Methods Effective Livestock Extension Methods

5 days, 16 - 20 Dec, 2024 

2024-12-16 12:12:00 2024-12-16 12:12:00
Ghana

Alpha Partners

The course aims at improving the capability of officers involved in extension delivery to the farmers, so that proven and relevant livestock technologies will be easily adopted by livestock farmers. ...

Employee Relations and the Law Employee Relations and the Law

5 days, 25 - 29 Nov, 2024 

2024-11-25 12:11:00 2024-11-25 12:11:00
Ghana

Alpha Partners

By the end of the course, you'll be able to: Describe the key stages in union recognition. Understand the role of the social partners and social dimension of the AU, as well as AU ...