FORWARD-THINKING.  INNOVATIVE.  EXCELLENCE.

•••

Founded in 2015, Bayrock Financial Modelling specialises in providing premium Excel-based commercial real estate financial modelling education and transaction consultancy services. Learn more.

Our corporate training licenses and self-study modelling programs provide its users with the comprehensive financial modelling skills, knowledge and processes needed to successfully appraise transactions and complete real estate modelling tests. In addition, through our transaction consultancy services, we are committed in maximising investor returns for our new and long-term clientele, by utilising the financial, technical and transaction expertise of our professional team.

Click the links below to find more about our products and services.

HOME-STUDY EXCEL FINANCIAL MODELLING PROGRAMS

•••

Bayrock Financial Modelling offers two CPD certified self-study real estate financial modelling programs, covering all skill levels. Mastering The Modelling Test is designed to aid prospective financial analyst and professionals to pass the recruitment modelling test. Our flagship program, “Investment Grade Real Estate Modelling” focuses on the core skills and processes needed when creating and analysing complex investment appraisals. This program is essential for any investment professional within the real estate industry.

The programs follow a step-by-step guide, explaining how to build a real estate model one cell at a time for a specific transaction scenario. The self-study programs allow users to complete the course flexibly based around work and their private lives and at their own pace. The programs do not require classroom course attendance and provide the most cost-effective method of learning real estate modelling.

Further information can be found below, as well as, clicking the “more information” buttons.

•••

INVESTMENT GRADE REAL ESTATE MODELLING - INTERMEDIATE PROGRAM

£850

Aimed at real estate investment professionals, this self-study course will provide the best practice techniques and advanced skills of constructing flexible investment grade financial models, that assess the financial credibility, risks and returns of commercial real estate investments. Real estate concepts covered in the program include and are not limited to:

COMPLEX INVESTMENT SCENARIO

MULTI-LEVEL DEBT FINANCING

EQUITY WATERFALL STRUCTURE

SCENARIO ANALYSIS

20hrs CPD CERTIFICATION

MONTE CARLO SIMULATION

IRR PARTIONINING

DEVELOPMENT MODELLING

EXCEL SHORTCUTS

MASTERING THE MODELLING TEST - BEGINNER PROGRAM

£550

The Mastering the Modelling Test training program is meticulously designed to teach and guide users through a logical step-by-step process of how to create flexible real estate financial models in a modelling test scenario. Real estate concepts covered in the program include and are not limited to:

REAL ESTATE THEORY

MODELLING TEST SCENARIO

BASIC MULTI-LET CASH FLOWS

12hrs CPD CERTIFICATION

SIMPLE DEBT FINANCING

SENSITIVITY TABLES

EXCEL SHORTCUTS

CORPORATE LIFETIME MODELLING TRAINING LICENSES

•••

For many of our clients, the overall cost of classroom-based modelling training outstretches their training budgets. Additionally, the courses rigid structure reduces the transferability of the material across a company/team platform.

Bayrock Financial Modelling is proud to offer an alternative and more cost-effective training method to classroom-based education. Our lifetime license agreement grants our client’s access to a bespoke self-study modelling program, that can be transferred across a company/team platform. The license allows the training program to be available to all current and future staff members for an infinite time period.

By heavily reducing training overheads and eliminating the need for expensive classroom courses, the license provides the best return on investment for real estate modelling training. The license grants access to;

1. Lifetime access to a bespoke PDF modelling guidebook and corresponding Excel Workbook

2. Modelling Test to aSSess current and future employee modelling competencies

3. One-on-one feedback meetings for predetermined number of current employees

TRANSACTION CONSULTANCY SERVICES

•••

Bayrock Financial Modelling’s affiliate company, Bayrock Capital, prides itself on its teams financial and transactional expertise to perform acquisition due diligence analysis, transaction underwriting, equity/debt raising and model audits. The team has extensive hands-on experience and expertise across the asset class and risk spectrums, with a combined deal volume of over €3.5 billion.

Bayrock Capital is proud to have worked with global sophisticated Investors, Banks, High-Net-Worth Individuals, Merchant Investment Banks, Private Equity houses, Agents and Investment Managers. Bayrock Capital’s investment advisory services include and are not limited to;

Transaction Due Diligence and Underwriting

Transaction Valuation and Investment Committee Reporting

Equity/Debt Raising and Sourcing

Excel DCF Model Creation

Bespoke Excel DCF Templates for Initial Deal Analysis

Excel DCF Audits, Updates and Management

CLIENTS

•••

Bayrock Real Estate is proud to have worked with global Commercial Real Estate Investment Managers, Banks, Agents, Developers and Universities. Clients that have used our consultancy services or our real estate modelling training programs to train staff include;