Strategies, fund structures, metrics and valuation for institutional real estate.

• The four quadrants of real estate investment
• Core, core-plus, value-add and opportunistic strategies
• IRR, equity multiple, NOI and yields
• REITs: structures, FFO, AFFO and NAV
• Macro, sector and ESG risk
• Real-world PERE case study

The capital stack, from senior loans to mezzanine, for investment and development.

• Debt instruments and repayment structures
• Development finance and S-curve drawdowns
• LTV, DSCR, ICR and debt yield
• Loan and security documentation
• Basel III, SFDR and Shariah finance

Build a development appraisal model from scratch.

• Modelling best practice
• Profit on Cost feasibility
• GDV, NDV and residual land value
• Hard, soft and finance costs
• Section 106 and affordable housing
• Goal Seek and Solver

Dynamic development cash flows with debt, JV and return analysis.

• Pro-forma cash flows and timelines
• Sources and uses of capital
• Equity-first waterfalls, PIK, senior and mezzanine
• JV promotes and hurdle rates
• Leveraged returns: XIRR and XNPV

Model tenancies, lease events and investment returns.

• Tenancy schedules and rent forecasts
• Reviews, breaks, expiries and voids
• ERV and rental growth
• OPEX and CAPEX
• IRR, NPV, ROE and equity multiple

Build a full real estate leveraged buy-out model.

• Capital structures and lending criteria
• Interest-only, amortising and PIK debt
• Covenants, breaches and cash sweeps
• Revolving facilities
• IRR, NPV and MOIC

One integrated model from acquisition to exit.

• Hold, refinance or sell options
• Lead-in, construction and lease-up phases
• Debt and equity requirements
• JV profit shares and tiered IRR returns
• Sensitivity and scenario analysis

Practical AI for everyday real estate work. No technical background needed.

• How AI differs from traditional software
• ChatGPT, Claude, Gemini, Copilot and image tools
• Market research and price prediction
• Marketing and listings
• Lease and contract review
• 30/60/90-day adoption plan

Faster, sharper market intelligence with AI.

• Prompt engineering for real estate
• Trend, sentiment and competitor analysis
• Local market research reports
• Extracting data from documents
• Client-ready presentation

Automate Excel models with AI-generated VBA.

• When to use VBA, Python or JavaScript
• Generating macros with ChatGPT
• Automated IRR/NPV sensitivity tool
• Scenario switch buttons
• Keeping AI code reliable

Use Python and AI to handle data beyond Excel’s limits.

• When to move beyond Excel
• Writing scripts with ChatGPT
• Cleaning data from Excel models
• Rent, NOI and IRR analytics
• Exporting results back to Excel

Project day: build your own AI-powered modelling tool.

• VBA, Python or JavaScript: choosing
• IRR, NPV, DSCR and cap rate calculators
• Scenario generators
• Data extraction tools
• A simple real estate chatbot

Build a web-based IRR calculator with JavaScript and AI.

• JavaScript vs. VBA and Python
• Inputs: price, rent and expenses
• Outputs: cash flow, IRR, ROI, cap rate
• Extending the tool
• Present your finished app

Build a practical AI adoption roadmap for your business.

• Highest-value use cases
• What to automate, what to keep human
• Research, underwriting and reporting workflows
• KPIs for AI
• 30/60/90-day roadmap

Administering closed-ended funds across their lifecycle.

• The fund lifecycle
• Capital management
• Investor relations
• Drawdowns, distributions and capital statements
• Financial reporting
• Exits and liquidation

Clearer investor reporting between Private Banking and IR.

• Investor-friendly reporting
• Reducing LP data requests
• Saving GP time
• Industry-standard statement formats

Capital strategies aligned with client communication.

• Aligning fund managers, IR and private banking
• Forecasting drawdowns
• Distribution waterfalls and IRR
• Equalisation at later closes

Fairness between early and late fund investors.

• Why and how equalisation works
• Interest-based vs. NAV-based methods
• Impact on accounting and reporting
• Hands-on calculations
• LPA and side letter clauses

The technical mechanics of carry, from waterfalls to clawback.

• Preferred return and GP catch-up
• Waterfall models and clawback
• Scenario testing
• LP and GP perspectives

LPA essentials for GP back-office staff.

• Key, operational and financial clauses
• GP and LP roles
• Back-office responsibilities
• Compliance with LPA terms

Build, track and stress-test asset business plans.

• Plans from scratch
• Rent, vacancy, capex, exit yield and debt
• Plan vs. actual variance
• Rolling forecasts
• Mark-to-market repricing

Roll asset plans into one portfolio view.

• Consolidated NOI and IRR
• WAULT, occupancy and DSCR
• Performance attribution
• Vintage and sector breakdowns
• Fund waterfall and carry
• Reporting dashboards

Quantify and present the risks that matter.

• Key value drivers
• Data tables and scenarios
• Monte Carlo simulation
• Covenant breach points
• Presenting risk to IC and investors

Financial confidence for managers in non-finance roles.

• Reading financial statements
• Budgeting and forecasting
• Liquidity and cash flow
• Key financial ratios

Prepare, read and apply cash flow statements.

• Operating, investing and financing activities
• Direct and indirect methods
• Analysis and interpretation
• Applying the insights

Clear communication across teams and seniority levels.

• Communication preferences
• Adapting your style
• Active listening and feedback
• Persuading varied audiences

Professional poise for administrative teams.

• Appearance and behaviour
• Meeting, phone and email etiquette
• Cross-cultural awareness
• Event and visitor management

Work smarter, with less stress.

• Managing energy
• Stress triggers and resilience
• Prioritisation and time-blocking
• Sustainable productivity

Build a personal brand that opens doors.

• Personal branding
• Your unique value proposition
• Networking
• Self-promotion