Call Now+234 803 304 5484, +234 906 000 2299

Send Message[email protected]

Location: Lagos - Nigeria

Start Date: 10 Feb, 2025

End Date: 12 Feb, 2025

WiFiFree WiFi available

₦350,000

Event Details

On this course, participants will…

  • Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
  • Build annual and quarterly discounted cash flows
  • Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
  • Analyse risk using sensitivity tables and charts
  • Employ best practice and find solutions to common modelling problems

 

CONTENT

  • Term & Reversion and Layer Method Valuation (Intro to Excel)
  • Equivalent Yield (Solver, Scenario and Goal Seek functions)
  • Single-Let Discounted Cash Flow
  • Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
  • Analysis and use of date series
  • Internal Rate of Return (IRR) and Net Present Value (NPV)
  • Comparing Value, Price and Worth
  • Adding borrowing and analysing geared returns
  • Introducing Rent Reviews and other ‘events’ into cash flows
  • The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
  • Sensitivity analysis
  • The ‘Rent Function’ and Multi-let cash flows
  • The ‘date problem’ and assumptions in property asset cash flows
  • Reducing the rent function, intermediate calculations and modelling theory
  • Modelling lease expiries, break clauses, voids, and upward only covenants
  • Incorporating time-varying rental growth rates
  • Analysing multi-let cash flows to see if the leases are sufficiently diversified
  • Further IRR analysis (XIRR, MIRR)

 

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.

Venue

Alpha Partners Professional Training Conference Centre. 200, Muritala Mohammed Way (3rd Floor), Yaba Lagos.

Other Dates

Start Date End Date
19 May, 2025 21 May, 2025
Start Date End Date
07 Aug, 2025 09 Aug, 2025
Start Date End Date
06 Nov, 2024 08 Nov, 2024
Start Date End Date
10 Feb, 2025 12 Feb, 2025