Bespoke Real Estate & Financial Modelling Training for Your Team

Case studies and models reflect the assets you actually work on, whether that’s offices and retail, purpose-built student accommodation, logistics or data centres.

We assess your delegates’ skills before we write the outline, so nobody sits through what they already know or gets left behind.

Each programme is built around a clear learning objective agreed with you at the start, such as “speak confidently with valuers and agents” or “build and audit our own development appraisals”.

Run the course on consecutive days or spread sessions across several weeks to fit around deal flow and reporting deadlines.

Training a group in-house is typically better value than sending people to public courses one at a time.

The whole team learns the same methods and terminology, making models easier to review, hand over and challenge.

Bespoke courses

A tailored course for an individual or team, built by combining and adapting modules from our established programmes, such as Real Estate Analyst, Real Estate Developer and Understanding Key Principles of Financial Modelling, and adding sector-specific content where you need it.

Customised learning programmes

Structured learning pathways that run across your organisation, from graduate and analyst intake through to management. We map concepts to how your business operates, so skills build year on year and new joiners are trained to a consistent standard.

Discovery call

We talk through your team, the work they do and what you want them to be able to do after the training.

Skills baseline

We establish your delegates’ current level in Excel, real estate and financial modelling so the course starts in the right place.

Tailored outline

You receive a day-by-day outline to review. We adjust topics, depth and timings until it fits, and flag optional modules.

Delivery

Practical, hands-on sessions at your offices or live online, with time for questions about your own deals and models.

Post-course support

Two months of support after the course, so delegates can get help applying what they’ve learned to live work.

Real estate fundamentals

• Real estate as an asset class and how the market works
• Key terms: yields, cap rates, ERV, net effective rent
• Valuation methods and Red Book standards
• Leasing, incentives, breaks and covenant strength
• Excel foundations for property professionals

Financial modelling

• Building clear, auditable cash flow models
• Single-let and multi-let DCFs
• IRR, NPV, XIRR, MIRR and equity multiple
• Lease events, voids, breaks and rent reviews
• Sensitivity and scenario analysis

Investment & valuation

• Investment appraisal and underwriting
• Value, price and worth
• Geared returns and the impact of debt
• Exit yields and exit calculations across markets
• Underwriting vs revised DCF

Development

• Development appraisals and Net Development Value
• Construction costs, S-curves and phasing
• Sales, marketing and disposal costs
• Development finance structures
• Scenario switching and residual land value

Finance, debt & private equity

• Senior and mezzanine debt modelling
• Debt service and covenant tests
• Joint venture waterfalls and promote structures
• Private equity returns analysis
• Corporate finance modelling

Funds, portfolios & performance

• Real estate fund structures and management
• Portfolio construction and strategy
• Performance measurement and attribution
• Total return and benchmarking
• Portfolio reporting frameworks

Sector specialisms

• Hotel investment and operating performance
• Retail and shopping centre investment
• Purpose-built student accommodation (PBSA)
• Data centres and operational assets
• Living sectors and alternatives

Can’t see what you need?

This is just a selection of what we cover. If your team needs a topic, asset class or modelling approach that isn’t listed here, ask us. We regularly write new content for bespoke clients and will tell you honestly whether we can help.

Every course

What’s included

• Printed course manuals
• Course presentations and Excel model files to keep
• Two months of post-course support
• CPD accredited certificate for every delegate
• Financial Modelling Proficiency Badge
• Access to online learning resources

Your way

Flexible delivery

• In-person at your offices in the UK or internationally
• Live online for distributed or international teams
• Consecutive or spread out: run all days together or split sessions across several weeks
• Small, focused groups so the trainer can work through delegates’ own questions

Real Estate Fundamentals

Real estate fundamentals for senior executives

The objective

Senior executives who had joined the business from outside the property sector needed to discuss commercial real estate confidently, as an informed client, with valuers, agents and internal teams.

What we built

A one-day introduction to the UK property market covering how the occupier, investment, development and land markets interact; key terms such as yield, cap rate and ERV; the three approaches to valuation and Red Book standards; how lease terms, incentives and break options affect value; and how investments are evaluated, including gearing and portfolio considerations.

PBSA Financial Modelling

Student accommodation modelling for a family office investor

The objective

Equip the team to model purpose-built student accommodation (PBSA) on its own terms, as an operational asset with academic-year cycles, rather than forcing it into a standard commercial template.

What we built

A programme moving from income-producing cash flow foundations to PBSA rent roll analytics (occupancy lag, rent collection and academic-year cycles), accrual vs cash accounting, equity-focused value metrics beyond IRR, PBSA development appraisals, debt covenant modelling and consistent portfolio reporting across teams.

Investment Modelling

Investment modelling for a European asset manager

The objective

Give an investment team a common, rigorous approach to building, interpreting and challenging property cash flow models across European markets.

What we built

We combined our Real Estate Analyst and Key Principles of Financial Modelling courses and added the client’s priority topics: debt and return waterfalls with promote hurdles, exit calculations across Europe, underwriting vs revised DCF, and a property basics session on yields, purchaser’s costs and transaction anatomy. Spacing the days out let delegates apply each session to live work before the next.

Investment & Development

Investment and development modelling for a data centre operator

The objective

Build the team’s ability to appraise both standing investments and new development projects, with a clear understanding of how returns and discount rates vary between regions.

What we built

Day one covered investment cash flow modelling from valuation basics to multi-let DCFs and advanced IRR analysis (XIRR, MIRR). Day two focused on development appraisal: Net Development Value, phased sales, S-curve construction costs, scenario switching and development finance structures, plus a session on building up discount rates for different regions, comparing Europe with Japan.

The course had an excellent combination of theory and practice, which is what most working professionals need. Within a limited timeframe, we were able to cover so many, diverse range of topics.

I really enjoyed the course from Bayfield and learnt loads. My confidence with Excel and Cash Flow Modelling has significantly increased during the 4 days of the course. The trainer was a great instructor whose patience was really appreciated by everyone in the course.

The trainer was very knowledgeable and was able to take sections out of order to demonstrate certain learnings. Easy to listen to and understand.

A great mixture of theory and practical learning, delivered in an interesting and interactive way.

Jacob Noble

Bespoke & in-house training enquiries

Email[email protected]Telephone+44 (0) 1223 517 850Make an enquiry