Excel Fundamentals

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.

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 one-day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector. The training aims to give delegates a grasp of MS Excel and its usage in real estate cash flow modelling. You will be able to set up a financial modelling cash flow from a blank spreadsheet by using the most common shortcuts, formulas and functions. This is an excellent starter/refresher course, whether you’re a recent graduate or a mid/senior professional.

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.