Real Estate Financial Modelling School (In-Person)

Bayfield Training – Real Estate Financial Modelling School (In-Person)

Date: Monday, 8 December 2025
Time: 10:00 AM – 4:30 PM GMT
Location: Imparando, Commercial Road, London, United Kingdom
Fees: £5,649.54

Master Real Estate Financial Modelling in Just 5 Days

Unlock the full potential of Excel-based financial modelling with the Real Estate Financial Modelling School by Bayfield Training. This CPD-accredited intensive training is designed to help real estate professionals develop robust, dynamic models from scratch. Covering investment analysis, development projects, financing structures, and risk assessment, this hands-on course offers a comprehensive journey from beginner to advanced modelling techniques.

Course Overview:

This in-depth training combines three of Bayfield’s most popular courses into one seamless program:

• 📊 Real Estate Analyst
• 🏢 Real Estate Investor
• 💼 Real Estate Modelling Masterclass

Whether you’re an analyst, asset manager, or real estate professional looking to build or refine your modelling skills, this program equips you with tools and techniques used by top-tier firms worldwide.

What You Will Learn:

• ✔ Build property cash flows from scratch in Excel
• ✔ Model single-let and multi-let commercial assets
• ✔ Perform DCF valuations, IRR/NPV analysis, and sensitivity tests
• ✔ Develop investment and development cash flows
• ✔ Model lease terms, rent reviews, voids, cap rates, and operating expenses
• ✔ Understand senior and mezzanine debt structures
• ✔ Perform Monte Carlo simulations and scenario analysis
• ✔ Implement risk-adjusted return analysis and promote structures

Who Should Attend?

• 📈 Junior to senior real estate analysts
• 🏗 Property managers and developers
• 💼 Professionals building or reviewing real estate cash flow models
• 🧠 Financial advisors and investment analysts in property sectors

Course Breakdown – Daily Structure:

Day 1: Real Estate Analyst I

• Intro to Excel modelling and cash flow basics
• IRR, NPV, equivalent yield, scenario functions
• Rent functions, sensitivity analysis, borrowing structures

Day 2: Real Estate Analyst II

• Multi-let cash flows and rent schedule modelling
• Lease expiry, break clauses, rental growth variations
• Advanced IRR methods including XIRR and MIRR

Day 3: Real Estate Investor I

• International lease structures and income stream variations
• Sector-specific rental modelling (office, retail, industrial)
• Advanced rent logic and senior debt modelling

Day 4: Real Estate Investor II

• Development appraisal fundamentals
• Residual models, phased sales, and project cash flows
• NPV, profit multiples, and development finance

Day 5: Real Estate Modelling Masterclass

• Mezzanine debt, JV structures, promote calculations
• Full risk modelling: sensitivity, scenarios, Monte Carlo
• Advanced return analysis and financial structuring

What’s Included:

• 📄 CPD-Accredited Certificate & LinkedIn Proficiency Badge
• 📘 Hard Copy Course Manual
• 💾 Downloadable Excel Files & Templates
• 🌐 Access to Online Learning Platform (bonus resources)
• 📬 Two months post-course Q&A support (1-year support available)

Delivery Options:

This training is available:

• 🧑‍🏫 In-person (classroom at Imparando, London)
• 💻 Online (live virtual classroom)
• 🏢 In-house (custom training for your company/team)

Register or Enquire

Ready to enhance your modelling skills and gain a competitive edge? Don’t miss this immersive financial training experience.

📧 Contact us at:
[email protected]

Learn more or book your place now at www.bayfieldtraining.com