Introduction to Real Estate in Excel

This course equips real estate finance professionals with advanced data analytics techniques to enhance Excel-based discounted cash flow (DCF) models for commercial real estate. Participants will learn how to leverage Python and generative AI to generate robust inputs and deliver deeper insights to enhance real estate investment decision-making.

A one-day course to provide a general overview of the structure of the Real Estate sector. This course is designed to equip Real Estate Services and support personnel in the principles of Real Estate Investment strategy and Analysis. By the end of the course, delegates should be very familiar with the needs of Real Estate sector and the basics of Real Estate economics.

On this course, you will learn how to set up, navigate and effectively use Excel spreadsheets. The course is designed to introduce the basics of Excel. It will acquaint students with multiple Excel shortcuts to allow them to learn or enhance the Excel skills necessary to their jobs. The training is delivered on-demand in an online learning platform, allowing delegates to take the four modules that the course is broken down into in their own time.

Financial Mathematics possesses a pivotal role in Real Estate Investment and Management therefore understanding the Fundamentals of Cash Flow Calculations can assist Investors and Analysts in producing informed decisions and help manage risk effectively in the Real Estate market. Within corporate finance, financial mathematics provides the framework for quantifying the costs and benefits of a project or investment, allowing those involved to decide whether it’s worthwhile the investment. Therea are four basic concepts of Financial Mathematics, Compound Growth, Present Value, Net Present Value, Internal Rate of Return. This course goes right back to the start and will equip you with the tools required to grow, discount and value income. Streams from property.

We will instruct you in the art of precision, neatness, working efficiently, analytical thinking and employing industry best practices. The course is structured to emulate a typical Real Estate Financial Modelling test, requiring unlevered and levered analysis of an office redevelopment opportunity. If you are gearing up for an interview that includes a timed Financial Modelling test, our course will equip you with the skills necessary to outperform other candidates.

A course introducing the fund management process. specifically applicable to real estate funds. The course revises the real market and the opportunities available before comparing the risks and reward of investment in the underlying asset with investment in shares of a real estate fund (aka indirect real estate investment).

This on-demand course equips you with the skills to model sophisticated capital structures and evaluate investment performance across both project and partnership levels. Through hands-on, practical instruction, you’ll learn to build complex financial models that incorporate senior and mezzanine debt, preferred returns, distribution waterfalls, promote structures, and advanced risk analysis tools such as Monte Carlo simulations and scenario testing.

This two day course provides hands-on training on Excel and provides delegates a step-by-step guide and completed financial modelling spreadsheets. Includes a further two month’s support after completion.

This two day course provides training on financial modelling spreadsheets tailored for a developer. It covers the different risk and return characteristics applicable to investment property that necessitates an alternative type of cash flow model.

Get upskilled and recognised by the greatest Real Estate Educational Institutions in the world with the Bayfield Training, University of Cambridge Real Estate Financial Modelling Certificate. This eight-week online course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleague’s reassurance of your expertise.

This two day course is 100% hands on in Excel and is categorised as Advanced-Financial modelling. The Real Estate Investor course follows on from the Real Estate Analyst course widening the application financial modelling and commercial considerations to new sectors, geographies and project types. Delegates are provided with a step-by-step guide (manual) and completed financial modelling spreadsheets. Two months’ post course support is also provided.

One-day course. A 100% hands on in Excel. Pre-requisite, Real Estate Investor or advance excel knowledge. This financial modelling course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models. Delegates will work with examples of localised models and case studies, Monte Carlo analysis, cash flows related to P&L and balance sheet, portfolio analysis and aspects of real estate performance metrics. Course material is created, designed and updated by Bayfield. Bayfield provides delegates a manual and completed financial modelling spreadsheets. Two-months post course support also provided after the course.

Learn how to build a Retail Property cash flow model. As a modelling course it is almost entirely Excel based. The course starts by analysing the variables that influence shopping centre investment returns. Delegates will calculate Key Performance Indicators (KPIs) that can be shown to influence the financial model from Tenancy through to Risk. The KPIs are studied, calculated and ranked using a portfolio of 10 real shopping centres. The first day will also revise the Excel techniques and Financial Mathematics required to build the case study. By the end of the course delegates should be able to build their own shopping centre investment cash flows and analyse the results.

This three day strategy course provides step-by-step guides and financial model spreadsheets and will use games to enhance the learning experience. A hypothetical shopping centre game is also included so that delegates can create their own product mix. Completed exercises can be accessed and downloaded from the Learning Management System. The lecturers are experts in the field and a networking dinner is included for both delegates and experts.

On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR). This course will provide you with a solid foundation for understanding and analysing real estate cash flows.

Learn how to analyse and interpret real estate portfolio analysis from the asset to the portfolio level. This course is designed to equip participants with the knowledge and skills necessary to measure, analyse and interpret real estate performance. Through a blend of theoretical concepts and hands-on exercises, participants will gain practical insights into performance measurement, portfolio construction, and attribution analysis, all within the framework of the MSCI Portfolio Analysis Service methodology.