Name: Supply Chain Management, Procurement & Logistics Management
Price: 12 GBP
Availability: InStock

NextGen Learning

Office Skills & Productivity

Secretarial & PA

Office Skills

Professional Skills Course (PSC)

Office Administration

Trainers Course

Admin, Secretarial & PA

General Admission

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThe course is designed for individuals who want to gain in-depth knowledge and practice in the discipline of Business Analysis (Business Analysts, Requirements Engineers, Product manager, Product Owner, Chief Product Owner, Service Manager, Service Owner, Project manager, Consultants)OverviewStudents should be able to demonstrate knowledge and understanding and application of Business Analysis principles and techniques. Key areas are: The breath of the role of a Business Analyst The processes and techniques of strategy analysis Investigation of an organization's business systems Techniques used within stakeholder analysis and the need for analyzing perspectives Conceptual modelling and business activity models Business improvements through gap analysis The Business case within the business change lifecycleThe Business Analyst role analyzes, understands and manages the requirements in a customer-supplier relationship and ensures that the right products are delivered.The course provides in-depth knowledge and practice in Business Analysis</div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Let?s Get to Know Each Other</li><li>Course Overview</li><li>Course Learning Objectives</li><li>Course Structure</li><li>Course Agenda</li><li>Introduction to Business Analysis Practice</li><li>Exam Details</li><li>Business Analysis Certification Scheme</li></ul><h4>Rationale for Business Analysis</h4><ul><li>The role of the BA throughout the stages of the Business change lifecycle</li><li>The scope of the BA role within the context of the range of analysis activities</li><li>Three areas of competencies</li></ul><h4>Understanding the Strategic Context</h4><ul><li>Techniques in practice:</li><li>MOST</li><li>Resource audit</li><li>PESTLE</li><li>Porter's Five Forces</li><li>SWOT analysis</li><li>CSF, KPI and Performance target</li><li>Balanced Business Score Card</li></ul><h4>Understanding the Current Situation</h4><ul><li>Identification of stakeholder categories</li><li>Identification of relevant investigation techniques</li><li>The rationale for taking a holistic view</li><li>Rich pictures, Mind Maps and Fishbone diagrams</li></ul><h4>Stakeholder Analysis and Management</h4><ul><li>Power/interest and level of interest</li><li>Appropriate stakeholder management strategy</li><li>Stakeholder perspectives and CATWOE technique</li></ul><h4>Analysing and Modelling Business Activities</h4><ul><li>Conceptual models of a business situation</li><li>Five types of high level activity</li><li>Planning activities</li><li>Enabling activities</li><li>Doing activities</li><li>Monitoring and control activities</li><li>Three types of business events</li><li>The consensus business activity model</li></ul><h4>Identifying Potential Solutions</h4><ul><li>Different categories of business rules</li><li>Gap analysis (through conceptual business activity model and as-is business situation)</li><li>Components of a new business model</li></ul><h4>Building the Business Case</h4><ul><li>Rationale for the development of a business case</li><li>Contents of a business case</li><li>Identification of tangible/intangible costs and benefits, risks and impacts</li><li>Rationale for the financial case and appraisal techniques</li><li>Business case review in the business change lifecycle</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans Business Analysis - Practice training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Business Analysis - Practice course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.</div>

Nexus Human

Business Analyst

Agile Business Analyst

Business Analysis

Business Case Development

Business & Management

Business Data Analysis

Business Analysis - Practice

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThis is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience.OverviewThis course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures TriggersA company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database.</div><div id="course-pills-2"><h4>Advanced Query Techniques </h4><ul><li>Join inner outer (Left, Right, Full) </li><li>Subqueries </li><li>Simple </li><li>Correlated </li><li>Using the Exists Operator </li><li>Tips for Developing Complex Queries </li><li>Performing Set Operations </li><li>Aggregating Results Using Group by </li><li>Creating Temporary Tables</li></ul><h4>Manipulating Table Data Using SQL's Data Manipulation Language (DML)</h4><ul><li>Inserting Data into Tables </li><li>Updating Existing Data </li><li>Deleting Records </li><li>Truncating Tables </li><li>Implementing Data Integrity with Transactions </li><li>Beginning Explicit Transactions </li><li>Committing Transactions </li><li>Rolling Back Transactions</li></ul><h4>User-Defined Functions</h4><ul><li>Definition and Benefits of Use </li><li>CREATE FUNCTION</li><li>Syntax </li><li>RETURN Clause and the RETURNS Statement </li><li>Scalar vs. Table Functions </li><li>Comparison with Stored Procedures </li><li>Returning Scalar Values and Tables ALTER and DROP FUNCTION</li></ul><h4>Stored Procedures</h4><ul><li>Definition and Benefits of Use </li><li>CREATE PROCEDURE</li><li>Syntax </li><li>Variables and Parameters </li><li>Control of Program Flow </li><li>ALTER and DROP PROCEDURE</li><li>Implementation Differences </li></ul><h4>Triggers </h4><ul><li>Definition and Benefits of Use </li><li>Alternatives (e.g., Constraints) </li><li>CREATE TRIGGER</li><li>Syntax </li><li>Trigger Types </li><li>'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables </li><li>Event Handling and Trigger Execution </li><li>ALTER and DROP TRIGGER</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.</div>

AWS Certified Database

Manager Training

Train the Trainer (TTT)

Teaching & Training

Advanced SQL Programming (TTSQL005)

Course Gate

Online Course Creation

Xero

Certification in Cash & Voucher Assistant (CVA)

Bookkeeping

Accounting & Bookkeeping

Assistant Accountant

Practical Accounting

Xero Bookkeeper Training

<h2 style="color: var(--text-heading); box-sizing: border-box;" id="isPasted" fr-original-style="color: var(--text-heading);">This course at a glance</h2><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Accredited by CPDQE</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Navigate probate real estate investing.</li><li fr-original-style="" style="box-sizing: border-box;">Engage effectively with sellers.</li><li fr-original-style="" style="box-sizing: border-box;">Execute mailing campaigns.</li><li fr-original-style="" style="box-sizing: border-box;">Understand courthouse archives and case files.</li><li fr-original-style="" style="box-sizing: border-box;">Manage financing options.</li></ul><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);">Investing in real estate can be both lucrative and complex. Yet, the arena of probate real estate offers unique opportunities, often overlooked by many. This course aims to equip you with the necessary skills and mindset to excel in real estate investing, specifically in probate properties.Structured meticulously, the course spans across various vital areas. Start with understanding the landscape of probate real estate and how to acquire crucial data from courthouse archives. Learn how to construct mailing lists, execute mailing campaigns, and subsequently engage in effective dialogues with sellers. Next, the course shifts the lens towards deal sourcing and financial structuring, where you will grasp the essentials of deal analysis and understand how to finance your investment.However, it&rsquo;s not just about the mechanics; the psychology of successful real estate investing is woven into the course fabric. From supercharging your motivation to overcoming fear and obstacles, the course aims to mold you into a rounded individual capable of making well-informed decisions under various circumstances.In summary, this course is a goldmine for anyone eager to delve into real estate investing, especially in probate properties. Whether you are a novice investor or a seasoned professional, this course provides actionable insights and a robust psychological foundation. Turn the key to unlock the vault of real estate opportunities. Enroll today!</div></div></div></div></div></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Accredited by</h3>This course is CPDQE&nbsp;accredited, which serves as an impactful mechanism for skill enhancement.&nbsp;Continuing Professional Development (CPD) stands as a crucial, widely acknowledged method that aids individuals, organisations, and entire industries in staying current with their skills and knowledge.CPD not only facilitates the elevation of global standards and benchmarks, aligning with the growing forces of globalisation and consumer expectations but also transforms learning into a deliberate and proactive process. It motivates professionals to uphold a consistently high level of performance and demonstrates their unwavering commitment to a specific job role or profession.Course Curriculum<ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Probate Course Promo Video</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Courthouse-Archives-Probate-Case-Files</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Intro-to-Probate-REI-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Getting-Mailing-List-From-Courthouse-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Getting-Leads-from-the-courthouse-Part-2-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Getting-Leads-from-the-Courthouse-Part-3</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Making-and-Sending-Your-Mailings-Part-1-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Making-and-Sending-Your-Mailings-Part-2-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Making-and-Sending-Your-Mailings-Part-3-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Talking-to-Probate-Sellers-Part-1-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Talking-to-Sellers-Part-2-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Talking-to-Sellers-Part-3-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Talking-to-Sellers-Part-10-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Analyzing-Probate-Deals-Part-1-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Analyzing-Deals-Part-2-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">How-to-Finance-Probate-Deals-Part-1-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">How-to-Finance-Probate-Deals-Part-2-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Marketing-to-Wholesale-Buyers-Part-1-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Marketing-to-Wholesale-Buyers-Part-2-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Rehabbing-and-Listing-the-Property-Part-1-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Rehabbing-and-Listing-the-Property-Part-2-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Course-Summary-Part-1-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Course-Summary-Part-2-Final-Cut</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Probate-Real-Estate-Bonus</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Super Real Estate Investing Super Promo</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Intro 1</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Intro 2</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Hard Money Lending</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">How to Buy Houses Super cheap</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Direct Marketing Tips and Tricks</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Financing Deals</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Hard money lending 1</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Understanding Hard Money</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Exit Strategies</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Secrets to Wholesaling</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Secrets of Rehabbing</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">The Confusing Subject of Tax Lien Certificates and Deeds</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">The Ultimate Endgame</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">REI Tips and Tricks</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Even More Ways to Make Money in REI</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">How to Leverage REI experience to sell products</li></ul>

LearnDrive UK

Real Estate Investing

Real Estate Marketing

Unlock the potential of real estate investing with our comprehensive course. Master probate deals, financing, and marketing while boosting your mindset. Start your journey now!






























Real Estate Investing 

Harpenden

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service.It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way.It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level.The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away.<section>
 <h3>1 Getting Started</h3><ul><li>The Power BI ecosystem</li><li>Opening Power BI Desktop</li><li>Power BI's four views</li><li>Introduction to Dashboards</li></ul> <h3>2 Importing Files</h3><ul><li>Importing data sources</li><li>Importing an Excel file</li><li>Importing a CSV file</li><li>Importing a database</li><li>Connect to an SQL Server Database</li><li>Import vs. Direct Query</li><li>Importing from the web</li><li>Importing a folder of files</li><li>Managing file connections</li></ul> <h3>3 Shape Data in the Query Editor</h3><ul><li>The process of shaping data</li><li>Managing data types</li><li>Keeping and removing rows</li><li>Add a custom column</li><li>Appending tables together</li><li>Hiding queries in reports</li><li>Fixing error issues</li><li>Basic maths operations</li></ul> <h3>4 The Data Model</h3><ul><li>Table relationships</li><li>Relationship properties</li></ul> <h3>5 Merge Queries</h3><ul><li>Table join kinds</li><li>Merging tables</li></ul> <h3>6 Inserting Dashboard Visuals</h3><ul><li>Things to keep in mind</li><li>Inserting maps</li><li>Formatting Maps</li><li>Inserting charts</li><li>Formatting Charts</li><li>Inserting a tree map</li><li>Inserting a table, matrix, and card</li><li>Controlling number formats</li><li>About report themes</li><li>Highlighting key points</li><li>Filter reports with slicers</li><li>Sync slicers across dashboards</li><li>Custom web visuals</li></ul> <h3>7 Publish and share Reports</h3><ul><li>Publishing to Power BI service</li><li>Editing online reports</li><li>Pinning visuals to a dashboard</li><li>What is Q&amp;A?</li><li>Sharing dashboards</li><li>Exporting reports to PowerPoint</li><li>Exporting reports as PDF files</li></ul> <h3>8 The Power Query Editor</h3><ul><li>Fill data up and down</li><li>Split column by delimiter</li><li>Add a conditional column</li><li>More custom columns</li><li>Merging columns</li></ul> <h3>9 The M Functions</h3><ul><li>Inserting text functions</li><li>Insert an IF function</li><li>Create a query group</li></ul> <h3>10 Pivoting Tables</h3><ul><li>Pivot a table</li><li>Pivot and append tables</li><li>Pivot but don't aggregate</li><li>Unpivot tables</li><li>Append mismatched headers</li></ul> <h3>11 Data Modelling Expanded</h3><ul><li>Understanding relationships</li><li>Mark a date table</li></ul> <h3>12 DAX New Columns</h3><ul><li>New columns and measures</li><li>New column calculations</li><li>Insert a SWITCH function</li></ul> <h3>13 Introduction to DAX Measures</h3><ul><li>Common measure functions</li><li>Insert a SUM function</li><li>Insert a COUNTROWS function</li><li>Insert a DISTINCTCOUNT function</li><li>Insert a DIVIDE function</li><li>DAX rules</li></ul> <h3>14 The CALCULATE Measure</h3><ul><li>The syntax of CALCULATE</li><li>Insert a CALCULATE function</li><li>Control field summarisation</li><li>Things of note</li></ul> <h3>15 The SUMX measure</h3><ul><li>X iterator functions</li><li>Anatomy of SUMX</li><li>Insert a SUMX function</li><li>When to use X functions</li></ul> <h3>16 Time Intelligence Measures</h3><ul><li>Importance of a calendar table</li><li>Insert a TOTALYTD function</li><li>Change financial year end date</li><li>Comparing historical data</li><li>Insert a DATEADD function</li></ul> <h3>17 Hierarchies and Groups</h3><ul><li>Mine data using hierarchies</li><li>Compare data in groups</li></ul> 


 </section>

The In House Training Company

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Microsoft Power Platform

Microsoft BI

Power BI - introduction (2 day) (In-House)

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThere is no specific prerequisite for the CDRPÂ© course. However, participants who have at least three years' experience in a data centre and/or IT infrastructures will be best suited.OverviewAfter completion of the course, the participant will be able to: 1. Understand the different standards and methodologies for risk management and assessment 2. Establish the required project team for risk management 3. Perform the risk assessment, identifying current threats, vulnerabilities and the potential impact based on customised threat catalogues 4. Report on the current risk level of the data centre both quantitative and qualitative 5. Anticipate and minimise potential financial impacts 6. Understand the options for handling risk 7. Continuously monitor and review the status of risk present in the data centre 8. Reduce the frequency and magnitude of incidents 9. Detect and respond to events when they occur 10. Meet regulatory and compliance requirements 11. Support certification processes such as ISO/IEC 27001 12. Support overall corporate and IT governance</div><div id="course-pills-2"><h4>Introduction to Risk Management</h4><ul><li>Risk management concepts</li><li>Senior management and risk</li><li>Enterprise Risk Management (ERM)</li><li>Benefits of risk management</li></ul><h4>Data Centre Risk and Impact</h4><ul><li>Risk in facility, power, cooling, fire suppression, infrastructure and IT services</li><li>Impact of data centre downtime</li><li>Main causes of downtime</li><li>Cost factors in downtime</li></ul><h4>Standards, Guidelines and Methodologies</h4><ul><li>ISO/IEC 27001:2013, ISO/IEC 27005:2011, ISO/IEC 27002:2013</li><li>NIST SP 800-30</li><li>ISO/IEC 31000:2009</li><li>SS507:2008</li><li>ANSI/TIA-942</li><li>Other methodologies (CRAMM, EBIOS, OCTAVE, etc.)</li></ul><h4>Risk Management Definitions</h4><ul><li>Asset</li><li>Availability/Confidentiality/Integrity</li><li>Control</li><li>Information processing facility</li><li>Information security</li><li>Policy</li><li>Risk</li><li>Risk analysis/Risk assessment/Risk evaluation/</li><li>Risk treatment</li><li>Threat/Vulnerability</li><li>Types of risk</li></ul><h4>Risk Assessment Software</h4><ul><li>The need for software</li><li>Automation</li><li>Considerations</li></ul><h4>Risk Management Process</h4><ul><li>The risk management process</li><li>Establishing the context</li><li>Identification</li><li>Analysis</li><li>Evaluation</li><li>Treatment</li><li>Communication and consultation</li><li>Monitoring and review</li></ul><h4>Project Approach</h4><ul><li>Project management principles</li><li>Project management methods</li><li>Scope</li><li>Time</li><li>Cost</li><li>Cost estimate methods</li></ul><h4>Context Establishment</h4><ul><li>General considerations</li><li>Risk evaluation, impact and acceptance criteria</li><li>Severity rating of impact</li><li>Occurrence rating of probability</li><li>Scope and boundaries</li><li>Scope constraints</li><li>Roles &amp; responsibilities</li><li>Training, awareness and competence</li></ul><h4>Risk Assessment - Identification</h4><ul><li>The risk assessment process</li><li>Identification of assets</li><li>Identification of threats</li><li>Identification of existing controls</li><li>Identification of vulnerabilities</li><li>Identification of consequences</li><li>Hands-on exercise: Identification of assets, threats, existing controls, vulnerabilities and consequences</li></ul><h4>Risk Assessment - Analysis and Evaluation</h4><ul><li>Risk estimation</li><li>Risk estimation methodologies</li><li>Assessment of consequences</li><li>Assessment of incident likelihood</li><li>Level of risk estimation</li><li>Risk evaluation</li><li>Hands-on exercise: Assessment of consequences,</li><li>probability and estimating level of risk</li></ul><h4>Risk Treatment</h4><ul><li>The risk treatment process steps</li><li>Risk Treatment Plan (RTP)</li><li>Risk modification</li><li>Risk retention</li><li>Risk avoidance</li><li>Risk sharing</li><li>Constraints in risk modification</li><li>Control categories</li><li>Control examples</li><li>Cost-benefit analysis</li><li>Control implementation</li><li>Residual risk</li></ul><h4>Communication</h4><ul><li>Effective communication of risk management activities</li><li>Benefits and concerns of communication</li></ul><h4>Risk Monitoring and Review</h4><ul><li>Ongoing monitoring and review</li><li>Criteria for review</li></ul><h4>Risk scenarios</h4><ul><li>Risk assessment approach</li><li>Data centre site selection</li><li>Data centre facility</li><li>Cloud computing</li><li>UPS scenarios</li><li>Force majeure</li><li>Organisational shortcomings</li><li>Human failure</li><li>Technical failure</li><li>Deliberate acts</li></ul><h4>Exam: Certified Data Centre Risk Professional</h4><ul><li>Actual course outline may vary depending on offering center. Contact your sales representative for more information.</li></ul></div>

Certificate in Information Security Management Principles (CISMP)

Certificate of Business Continuity Programme (CBCI)

Project Risk Management

Risk Assessment

Certified in Data Protection (CDP)

Certified Cyber Professional (CCP)

Certified Data Centre Risk Professional (CDRP)

Want a new direction for your career? Think Accountancy, according to statistics, the average salary for Accountants is &pound;50,000, it is the sector where the employability rate is higher than any other sector. Whether you&#39;re a school leaver, already employed or simply looking for a career change a career in accountancy could be a real option for you.
What is AAT?
The AAT is an internationally recognised accounting qualification and over 100,000 people are currently benefiting from gaining an AAT qualification and full AAT membership. Gaining the qualification will help you support yourself throughout your accountancy career.
 
AAT Accounting Courses Overview:
First of all, the AAT qualification consists of four&nbsp;progressive qualification levels (1, 2, 3 &amp; 4) which will cover the key areas of Financial Accounting, Management Accounting, Taxation, Audit and Report Writing. Although you can start from Level 1, you may start from Level 2 if you have basic math and numeracy skills. In order to complete the full AAT Accounting qualification and gain full membership of the AAT, you will need to complete Level 3 and Level 4. Level 2 is recommended as an entry-level if you have no experience or knowledge of accounting and bookkeeping. The AAT qualification for accounting is broken down into three levels:
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">AAT Level 2&nbsp;Foundation Certificate in&nbsp; Accounting (5 Papers/Subjects)</li>
<li fr-original-style="" style="box-sizing: border-box;">AAT Level 3&nbsp;Advanced Diploma&nbsp;in&nbsp; Accounting (6 Papers/Subjects)</li>
<li fr-original-style="" style="box-sizing: border-box;">Finally&nbsp;AAT Level 4&nbsp;Professional Diploma&nbsp;in&nbsp; Accounting (6 Papers/Subjects)</li>
</ul>
Hence, the AAT Accounting Qualification gives you practical, internationally recognised finance and accountancy skills that can open doors for you in many industries across the world.
Finally, AAT offers a range of benefits for student members (including study support, career advice to help find the perfect job and exclusive discounts), as well as a route to progress into chartered accountancy. Moreover, if you choose to further your studies with any&nbsp;of the leading chartered accountancy professional bodies like ACCA, CIMA, CIPFA etc. your AAT qualification could make&nbsp;you eligible for generous exemptions.A Certificate of Attendance.
A newly qualified AAT member can expect to earn an average of &pound;21,600. Moreover, the AAT member will have been earning throughout their training and will have avoided student debt. Accounting technicians work at all levels of finance and accounting, depending on the level of their career. Some accounting technicians work as accounts clerks, others go on to become managing directors or finance directors of well-known companies. Some go to work as a self-employed accountant as AAT allows the student to become Accredited.

Osborne Training

Accounting courses

<div style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);">This module will cover the importance of cashflow and sound business planning; types of trade finance, government backed preferential interest loans bank overdrafts; bank loans &amp; bank factoring facilities; bank Customer Foreign Currency CFC accounts, Eurocurrency accounts and other private sector loan facilities.</div><form action="https://tfsa.schoolofexport.org/course_outline.aspx?id=74" method="get" style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"> </form>

Business Works

Corporate Finance Level 1

Banking & Finance

Project Finance

Finance For Non Finance Managers

Corporate Finance

Finance Fundamentals

Financing an Export Plan

Procurement & Supply

Logistics Management

Supply Chain Management

Supply chain management (SCM)

Diploma in Management Studies (DMS)

Certified Supply Chain Professional (CSCP)

Supply Chain Management, Procurement & Logistics Management

This course will teach participants the fundamentals of Oil and Gas modeling following best practices. It will break down the important concepts into modules allowing you to implement them in the Oil and Gas industry.&nbsp;We use the case study method which allows you to see varied perspectives and to gain deeper knowledge of the concepts. You will have lifetime access to our videos covering the core mechanics of the Oil and gas industry and you will be expected to think critically as you work through the case studies individually and in your assigned groups.&nbsp;This course requires an above-average understanding of Excel, Finance, Basic Financial Modeling, and working knowledge of the mechanics of basic corporate models. &nbsp;This instructor-led course includes:&nbsp;&bull; &nbsp; &nbsp;2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin&nbsp;&bull; &nbsp; &nbsp;6 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break.&nbsp;&bull; &nbsp; &nbsp;Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session.&nbsp;&bull; &nbsp; &nbsp;1 Capstone Project&nbsp;&bull; Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos.&nbsp;&bull; &nbsp; &nbsp;Access to our community of life-long learners.&nbsp;&bull; &nbsp; &nbsp;Downloadable Certificate you can link to your LinkedIn page&nbsp;We look forward to seeing you in Class!!!

dbrownconsulting

Learn the fundamentals of Oil and Gas modeling following best practices. This course will break down the important concepts of modeling allowing you to implement them in the Oil and Gas industry. 

Advanced Financial Modeler Certificate Course - Oil & Gas

Financial Modeling and Analysis are highly respected skills in the business world and are hugely sought after in the job marketplace.Financial Modelling is a powerful communication tool to clearly and effectively tell the story of a company to management and stakeholders. It is a critical decision-making tool used by management to make accurate and informed financial decisions about a company or project.It is multidisciplinary, requiring expertise in Accounting, Finance, Financial Analysis, Valuation, and Microsoft Excel.This course has been developed to cover the entire body of knowledge issued by the Financial Modeling Institute for Level One; Advanced Financial Modeler Designation.This course is certified by the CFA Society Nigeria with 40 PL Credits and CPD UK with 40 CPD Credits.&nbsp;In this course, you will learn 3 Statement Modeling from Scratch to Mastery using a real Company&#39;s Audited Financial Statement. &nbsp;The course includes&nbsp;&bull; &nbsp; &nbsp;2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions (with over 200+ step-by-step videos).&nbsp;&bull; &nbsp; &nbsp;1 Technical Session to confirm your connectivity and solve any technical issues you may have).&nbsp;&bull; &nbsp; &nbsp;10 intensive instructor-led live virtual sessions. Each session is 2 hours&nbsp;&bull; &nbsp; &nbsp;9 compulsory intersession assignments you will need to complete and submit on www.OfficeTrainingHub.com&nbsp;&bull; &nbsp; &nbsp;Intermittent tests and quizzes to gauge your assimilation.&nbsp;&bull; &nbsp; &nbsp;1 Capstone Project

Financial Modelling & Analysis

Financial Modelling

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.

Advanced Financial Modeler Certificate Course

Are you doing sanction checks in your law firm?In the intricate landscape of legal practice, understanding and adhering to the UK&#39;s sanctions regime is not just a recommendation; it is mandatory and it is imperative. This course aims to set clear expectations and offer practical support to firms, guiding them away from the pitfalls of breaching the UK&#39;s sanctions regime.<h2 fr-original-style="" style="box-sizing: border-box;">Who is this for?</h2>This 90 minute course is for all legal firms, irrespective of the services you provide. Whether you are navigating the sanctions regime independently or operating under a license from the Office of Financial Sanctions Implementation (OFSI), this course is for you. &nbsp;The course will cover:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What are sanctions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What do you need to know about the sanctions for your firm</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How is it different to the AML regime?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What controls to put in place?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">If the firm offers services to sanction areas &ndash; what controls?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">My client has been sanctioned &ndash; what do I do?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Reporting obligations</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using screening tools</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Licensing</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How does this impact Legal Professional Privilege?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sanction Risk Assessment</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Red flags factors</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enforcement actions</li></ul><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2>Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.<p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note a recording of the course will&nbsp;not&nbsp;be made available.<h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Speaker</h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/helen-torresi/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Helen Torresi, Consultant, DG Legal</a></h3>Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.Helen&rsquo;s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

Are you doing sanction checks in your law firm?
In the intricate landscape of legal practice, understanding and adhering to the UK's sanctions regime is not just a recommendation; it is mandatory and it is imperative. This course aims to set clear expectations and offer practical support to firms, guiding them away from the pitfalls of breaching the UK's sanctions regime.
Who is this for?
This 90 minute course is for all legal firms, irrespective of the services you provide. Whether you are navigating the sanctions regime independently or operating under a license from the Office of Financial Sanctions Implementation (OFSI), this course is for you. 
The course will cover:
What are sanctions
What do you need to know about the sanctions for your firm
How is it different to the AML regime?
What controls to put in place?
If the firm offers services to sanction areas – what controls?
My client has been sanctioned – what do I do?
Reporting obligations
Using screening tools
Licensing
How does this impact Legal Professional Privilege?
Sanction Risk Assessment
Red flags factors
Enforcement actions
Resources
Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.
Please note a recording of the course will not be made available.
Speaker
Helen Torresi, Consultant, DG Legal
Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.
Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

DG Legal

Navigating The UK Sanctions Compliance As A Law Firm Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

Retainer Delegate

<div id="course-pills-1">Duration3 Days18 CPD hoursThis course is intended forThe primary audience for this course is someone who works, or has ambition to work, in a leadership role in data center operations such as a data center facilities manager, data center operations manager, who has the responsibility to achieve and improve the high-availability and manageability of the data center operations.OverviewAfter completion of the course the participant will be able to: Perform the needs analysis translating business requirements to data center services Set-up and manage the data center operations team Implement and monitor safety- and security practices Identify a suitable maintenance program for the data center facility and its equipment Select the appropriate policies and procedures required for data center operations Monitor the data center availability, capacity and capability Manage and implement basic data center projects Set-up and implement an environmental sustainability program Select an appropriate back-up site to support organizational resilience Identify and respond to risk in the data center Manage and support the document life cycle Create a basic budget proposal Select and manage vendors and measure their performance Manage data center assetsManaging the facilities of today?s high-end and high-availability data centers is an extremely demanding and complex task which is often underestimated. There is often very little appreciation and understanding of the complexities of managing today's mission-critical data centers where downtime is not an option, especially since many of the data centers are operating at, or near, their design limits. Operations management at the facilities layer makes all the difference. Even a data center designed to the highest redundancy level as per the ANSI/TIA-942 standard could still experience many unscheduled downtime events due to poor planning, operations, maintenance and management processes.</div><div id="course-pills-2"><h4>Service Level Management</h4><ul><li>Service Level Management</li><li>Needs analysis</li><li>Capability assessment</li><li>Service portfolio</li><li>Service catalogue</li><li>Service Level Agreements (SLAs)</li><li>Availability measurement</li><li>Data points in SLA</li><li>Service reporting</li><li>Complaint procedure</li><li>Customer satisfaction measurement</li><li>Service Improvement Process (SIP)</li><li>SLA content</li></ul><h4>The Data Center Organization</h4><ul><li>Operational issues</li><li>Organization chart</li><li>Roles and responsibilities</li><li>Skills matrix</li><li>Contingency / backup roles</li><li>Shift management</li><li>Performance management</li><li>Career development</li><li>Training and assessment</li><li>Job rotation</li><li>Succession planning</li><li>Disciplinary program</li></ul><h4>Managing Safety &amp; Statutory Requirements</h4><ul><li>Safety policies and regulations</li><li>Occupational Health and Safety (OH&amp;S)</li><li>Safety awareness training</li><li>Permit to Work (PTW)</li><li>Lock-out / Tag-out</li><li>Personal Protective Equipment (PPE)</li><li>Testing and tagging of equipment</li><li>Emergency preparedness and response</li><li>Reporting of safety issues</li><li>Reviews / internal audit / external audit</li></ul><h4>Managing Physical Security</h4><ul><li>Security policies and procedures</li><li>Security standards and guidelines</li><li>Security staff</li><li>Security awareness</li><li>Security incident management</li><li>Disciplinary program</li><li>Reviews, internal and external audits</li></ul><h4>Facilities Management</h4><ul><li>Maintenance policies and procedures</li><li>Various maintenance programs</li><li>Outsourcing of maintenance activities</li><li>Maintenance contract options</li><li>Warranty</li><li>Maintenance schedule</li><li>Service situations</li><li>Spart part management</li><li>Contamination control</li></ul><h4>Data Center Operations</h4><ul><li>Policies and procedures for data center operations</li><li>Service operations and the daily data center operations</li></ul><h4>Monitoring / Reporting / Control</h4><ul><li>Monitoring requirements</li><li>Escalation procedures</li><li>Reporting</li><li>Trend analysis</li><li>Reviews</li></ul><h4>Project Management</h4><ul><li>Project management</li><li>Project organization</li><li>Project manager</li><li>Project phases</li></ul><h4>Environment Sustainability</h4><ul><li>The importance of sustainability</li><li>Sustainability policies </li><li>Environmental management </li><li>Power efficiency indicators -</li><li>Waste management -</li><li>Water management</li><li>ICT utilisation management </li><li>Environmental performance measurements</li><li>Renewable energy factor (REF)</li></ul><h4>Organizational Resilience</h4><ul><li>Business continuity</li><li>Data center facility options</li><li>Business Impact Analysis</li><li>Type of facility</li><li>Human resources</li><li>Facility, equipment and consumables</li></ul><h4>Governance, Risk and Compliance</h4><ul><li>Management commitment</li><li>Coordination, collaboration and integration</li><li>Compliance</li><li>Risk management</li><li>Document management</li><li>Financial management</li><li>Vendor management</li><li>Asset management</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans Certified Data Center Facilities Operations Manager (CDFOM) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Certified Data Center Facilities Operations Manager (CDFOM) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.</div>

Operations Management

Certified Facility Manager (CFM)

Construction Design & Management (CDM)

Commercial & Contract Management Certification Program (CCM)

Facility Management

Operations Manager

Certified Data Center Facilities Operations Manager (CDFOM)

Real Estate Financial Modelling School (5 days)The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance &amp; Risk.The school combines three of our courses:<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analyst</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investor</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Modelling Masterclass</li></ul> All of the courses are interlinked to give you a full understanding of the subject using Excel. On this course you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Implement cash flows in excel throughout the whole week.</li><li value="2" fr-original-style="" style="box-sizing: border-box;">In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.</li><li value="3" fr-original-style="" style="box-sizing: border-box;">On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.</li></ul> Who will benefit from this school?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Property industry modellers who would like to be fully proficient in building complex financial models</li></ul> Course OutlineDay OneReal Estate Analyst IKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul> Day TwoReal Estate Analyst IIKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul> Day ThreeReal Estate Investor I<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Further senior debt covenants</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance Rent Function techniques to manage feature rich lease structures</li></ul> Day FourReal Estate Investor II<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Introduction to development appraisals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Residual models, site and profit calculations</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Development cash flows versus Investment cash flows</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introduction to straight line versus S-curve costing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Phased asset sales in development appraisals</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Discounting development cash flows</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Complimentary return metrics for development appraisals</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Introduction to development finance</li></ul> Day FiveReal Estate Modelling Masterclass<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Financial Modelling School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



Real Estate Financial Modelling School (5 days)
The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.
This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.
The school combines three of our courses:
Real Estate Analyst
Real Estate Investor
Real Estate Modelling Masterclass


All of the courses are interlinked to give you a full understanding of the subject using Excel.


On this course you will…
Implement cash flows in excel throughout the whole week.
In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.
On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.
Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.


Who will benefit from this school?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


Course Outline
Day One
Real Estate Analyst I
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Real Estate Analyst II
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Day Three
Real Estate Investor I
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Four
Real Estate Investor II
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


Day Five
Real Estate Modelling Masterclass
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advance project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Financial Modelling School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Real Estate Finance

Microsoft Excel

Professional Development

Continuous Professional Development (CPD)

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education&rsquo;s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process. It also has an incredible average delegate rating of 4.97 out of 5 for overall quality, with 100% of former delegates recommending the course (please see our many fantastic testimonials&nbsp;<a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_self" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">here</a>).The highly acclaimed Senior Mental Health Lead Training and Certificate is an extensive and authoritative training course that ensures schools/colleges have the most comprehensive, effective and financially viable whole-school/college approach to mental health and wellbeing in place. Since September 2021, this course has been fully funded by the DfE for eligible schools&nbsp;and colleges. Schools and Colleges that are ineligible for the grant are, of course, more than welcome to enrol on the course but will need to self-fund their place.Working with an&nbsp;expert trainer and a highly experienced Senior Mental Health Lead, who has&nbsp;trained Senior Mental Health Leads in over 1000 schools and colleges nationwide, you will be introduced to the DfE&rsquo;s requirements for the role of the DSMHL, and learn proven, long-term, evidence-based strategies to create, lead and promote a dynamic, bespoke mental health and wellbeing approach for your setting.<ul style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><li fr-original-style="" style="box-sizing: border-box;">Our course consists of three days of live instructor-led training as well as an additional 1-2-1 review and coaching session, and costs&nbsp;&pound;520+VAT per delegate.&nbsp;(For schools and colleges who have already completed the training with us and now wish to train further colleagues, we offer a&nbsp;subsidised rate for additional delegates of &pound;390+VAT&nbsp;- please just email us if this is an offer you would like to take up.)</li><li fr-original-style="" style="box-sizing: border-box;">Places are limited to a maximum of 15 delegates per course to ensure high quality, bespoke training.</li><li fr-original-style="" style="box-sizing: border-box;">An overview of the course structure can be found&nbsp;<a href="https://www.brightcoreconsultancy.com/_files/ugd/5bc70a_c7b3efd99188442fa7d20449bb8fd0ec.pdf" target="_blank" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">here.</a></li></ul>Our Course is suitable for those who are new to the role of Senior Mental Health Lead or those who are looking to take on this role in the near future, and is designed to meet the DfE&rsquo;s&nbsp;<a href="https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/995681/Learning_outcomes_for_senior_mental_health_leads_in_schools_and_colleges.pdf" target="_blank" rel="noreferrer noopener" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">Learning Outcomes for Senior Mental Health Leads</a>&nbsp;by developing and supporting their knowledge and understanding of how to design, implement and sustain an effective whole school/college approach in accordance with the eight key principles as set out by Public Health England.<a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;" fr-original-class="wysiwyg_bold_link_cls">View all testimonials </a>

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education’s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process. It also has an incredible average delegate rating of 4.97 out of 5 for overall quality, with 100% of former delegates recommending the course (please see our many fantastic testimonials here).
The highly acclaimed Senior Mental Health Lead Training and Certificate is an extensive and authoritative training course that ensures schools/colleges have the most comprehensive, effective and financially viable whole-school/college approach to mental health and wellbeing in place. Since September 2021, this course has been fully funded by the DfE for eligible schools and colleges. Schools and Colleges that are ineligible for the grant are, of course, more than welcome to enrol on the course but will need to self-fund their place.
Working with an expert trainer and a highly experienced Senior Mental Health Lead, who has trained Senior Mental Health Leads in over 1000 schools and colleges nationwide, you will be introduced to the DfE’s requirements for the role of the DSMHL, and learn proven, long-term, evidence-based strategies to create, lead and promote a dynamic, bespoke mental health and wellbeing approach for your setting.
Our course consists of three days of live instructor-led training as well as an additional 1-2-1 review and coaching session, and costs £520+VAT per delegate. (For schools and colleges who have already completed the training with us and now wish to train further colleagues, we offer a subsidised rate for additional delegates of £390+VAT - please just email us if this is an offer you would like to take up.)
Places are limited to a maximum of 15 delegates per course to ensure high quality, bespoke training.
An overview of the course structure can be found here.
The DfE funding Code for this course is: SMHL018
Our Course is suitable for those who are new to the role of Senior Mental Health Lead or those who are looking to take on this role in the near future, and is designed to meet the DfE’s Learning Outcomes for Senior Mental Health Leads by developing and supporting their knowledge and understanding of how to design, implement and sustain an effective whole school/college approach in accordance with the eight key principles as set out by Public Health England.
View all testimonials



Brightcore Consultancy

Mental Health

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education’s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process.

Designated Senior Mental Health Lead Course (Three full days plus 1-2-1 session)

Real Estate AnalystThe Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results. On this course, you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul> Day OneKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul> Day TwoKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


Day One
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Property & Real Estate Photography

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

A real estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.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. We will also cover the use of pivot tables to clean and organise your data.This is an excellent starter/refresher course, whether you&rsquo;re a recent graduate or a mid/senior professional. On this course, you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn spreadsheet modelling best practice</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Look over excel tips for general day to day use in MS Excel</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Recognise spreadsheet navigation and presentation tricks</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand financial mathematics &amp; conventional valuations</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Identify real estate cash flow model single-let common functions and formulas</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Graduate Real Estate professionals</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">APC candidates</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Mid-Senior professionals looking for a refresher on core model building skills and best practice</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Any professionals looking to learn how to build a real estate focused model from scratch.</li></ul> Day One: Conventional Valuations<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Layer Method</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Over Rented</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield</li></ul> Real Estate Cash Flow Models (Single-Let)<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Annual Discounted Cash Flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">&ldquo;What If&rdquo;&nbsp;Analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Quarterly Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flows with Rent Review</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Multiple Rent Reviews</li><li value="6" fr-original-style="" style="box-sizing: border-box;">NPV, IRR, Equity Multiple, Cash on Cash</li></ul> Additional topics:<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">IF, SUMIF &amp; Switches&rsquo;</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Sensitivity Analysis: Data Table &amp; Changing Calculation Options</li></ul> Other Excel tips and tricks, including navigation and presentation:<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Functions and formulas included: General formatting, data entry, manipulation and creating formulas, Copy/Paste and general navigation with shortcuts, Solver (used to calculate equivalent yield), Scenarios, Customise spreadsheet, Navigation Shortcuts, SUM, TODAY, PV, IRR, EDATE, EOMONTH, DAY, MONTH, YEAR, NPV, YEARFRAC</li></ul><div fr-original-style="" style="box-sizing: border-box;"> </div>Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A Bayfield Training Certification &amp; 7.5 CPD Hours</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Course Files</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the An Introduction to Real Estate in Excel such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



A real estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.
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. We will also cover the use of pivot tables to clean and organise your data.
This is an excellent starter/refresher course, whether you’re a recent graduate or a mid/senior professional.


On this course, you will…
Learn spreadsheet modelling best practice
Look over excel tips for general day to day use in MS Excel
Recognise spreadsheet navigation and presentation tricks
Understand financial mathematics & conventional valuations
Identify real estate cash flow model single-let common functions and formulas


Who will benefit from this course?
Graduate Real Estate professionals
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
APC candidates
Mid-Senior professionals looking for a refresher on core model building skills and best practice
Any professionals looking to learn how to build a real estate focused model from scratch.


Day One:


Conventional Valuations
Term & Reversion
Layer Method
Over Rented
Equivalent Yield


Real Estate Cash Flow Models (Single-Let)
Annual Discounted Cash Flows
“What If” Analysis
Quarterly Discounted Cash Flow
Cash Flows with Rent Review
Multiple Rent Reviews
NPV, IRR, Equity Multiple, Cash on Cash


Additional topics:
IF, SUMIF & Switches’
Sensitivity Analysis: Data Table & Changing Calculation Options


Other Excel tips and tricks, including navigation and presentation:
Functions and formulas included: General formatting, data entry, manipulation and creating formulas, Copy/Paste and general navigation with shortcuts, Solver (used to calculate equivalent yield), Scenarios, Customise spreadsheet, Navigation Shortcuts, SUM, TODAY, PV, IRR, EDATE, EOMONTH, DAY, MONTH, YEAR, NPV, YEARFRAC
Included in the Course
A Bayfield Training Certification & 7.5 CPD Hours
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the An Introduction to Real Estate in Excel such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Financial Analysis

Financial Management

Financial Risk Management

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.

An Introduction to Real Estate in Excel (Financial Modelling)

Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.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. On this course you will...<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study the financial concepts of compounding, discounting and in-perpetuity</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider the importance of the timing and uncertainty of both fixed and growing income streams</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast different property yield metrics</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Compare and contrast time and money-weighted measures of return</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about valuation principles</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast value and worth</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discuss the importance and sourcing of inputs and outputs</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Professional Real Estate Transaction Managers</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Asset Managers</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Portfolio Managers</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Recent graduates with exposure to real estate financial modelling</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">New employees with exposure to real estate financial modelling</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.</li></ul> Course Outline:MorningReal Estate Financial Mathematics<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Time Value of Money</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Net Present Value (NPV)</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Internal Rate of Return (IRR)</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What Discount Rate?</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certainty of a cash flow</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Liquidity</li></ul>Price, Value and Worth<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Comparing Price, Value and Worth</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Conventional Valuation Methods</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Term and Reversion, Layer Method</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Property Yields and Capitalisation Method</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Exit calculations across Europe</li></ul> AfternoonDiscounted Cash Flow Models<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Investment Appraisal Models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash flow inputs: Rents, Yields, Growth Rates, Target Returns</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash-on-Cash and Equity Multiple</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discount Rates &amp; Exit Cap Rate</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operating Assumptions</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Adding borrowing and analysing geared returns</li></ul>Model Interpretation and Analysis<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sensitivity analysis and scenario analysis</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth and inflation</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performance measures</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contemporary issues for analysis (such as the rise in interest rates)</li></ul> Quizzes | Q&amp;A Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate &amp; 7.5 CPD Hours</li><li value="2" style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Understanding Key Principles of Real Estate Financial Modelling such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.
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.


On this course you will...
Study the financial concepts of compounding, discounting and in-perpetuity
Consider the importance of the timing and uncertainty of both fixed and growing income streams
Contrast different property yield metrics
Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility
Compare and contrast time and money-weighted measures of return
Learn about valuation principles
Contrast value and worth
Discuss the importance and sourcing of inputs and outputs


Who will benefit from this course?
Professional Real Estate Transaction Managers
Asset Managers
Portfolio Managers
Recent graduates with exposure to real estate financial modelling
New employees with exposure to real estate financial modelling
People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.


Course Outline:
Morning
Real Estate Financial Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rate of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity
Price, Value and Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Afternoon
Discounted Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns
Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates)


Quizzes | Q&A


Included in the Course
A Bayfield Training Certificate & 7.5 CPD Hours
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Understanding Key Principles of Real Estate Financial Modelling such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Property Investment

Risk Management

Investment

Investment Management

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. 

Understanding Key Principles of Real Estate Modelling (Advanced Theoretical Course)

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types. This course is designed to provide participants with an in-depth understanding of development cash flow modelling, including the representation of risks associated with costs, methods of development financing, and considerations of investment assets.Apart from modelling office sectors, the course includes modelling of commercial residential development and retail investment assets. The course also expands the geographical investment universe to include modelling of real estate cash flows in a pan-European context, accounting for different indexation rules and methods.Overall, the Real Estate Investor course provides participants with advanced skills and knowledge required to successfully undertake real estate investment projects in a global context. Pre-requisite:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Completion of the Real Estate Analyst Course</li></ul> On this course you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Revise operational models of real estate assets and stress for core income</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Apply modelling techniques to an expanded range of real estate sectors and geographies</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider both investment and development cash flows</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the sources and use of funds</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about typical debt covenants and how to incorporate them</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn how to optimise debt structures</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate professionals at any level with exposure to real estate financial models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, debt structures and return metrics</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Analysts and Modellers who are making the transition from corporate finance to real estate investment and development</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analysts and Investors</li></ul> Course OutlineDay One<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts/premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Further senior debt covenants</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Advance Rent Function techniques to manage feature rich lease structures</li></ul> Day Two<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to development appraisals</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Residual models, site and profit calculations</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Development cash flows versus Investment cash flows</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to straight line versus S-curve costing</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Phased asset sales in development appraisals</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discounting development cash flows</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Complimentary return metrics for development appraisals</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to development finance</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Investor such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>





The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types. This course is designed to provide participants with an in-depth understanding of development cash flow modelling, including the representation of risks associated with costs, methods of development financing, and considerations of investment assets.
Apart from modelling office sectors, the course includes modelling of commercial residential development and retail investment assets. The course also expands the geographical investment universe to include modelling of real estate cash flows in a pan-European context, accounting for different indexation rules and methods.
Overall, the Real Estate Investor course provides participants with advanced skills and knowledge required to successfully undertake real estate investment projects in a global context.


Pre-requisite:
Completion of the Real Estate Analyst Course


On this course you will…
Revise operational models of real estate assets and stress for core income
Apply modelling techniques to an expanded range of real estate sectors and geographies
Consider both investment and development cash flows
Understand the sources and use of funds
Learn about typical debt covenants and how to incorporate them
Learn how to optimise debt structures


Who will benefit from this course?
Real Estate professionals at any level with exposure to real estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, debt structures and return metrics
Analysts and Modellers who are making the transition from corporate finance to real estate investment and development
Real Estate Analysts and Investors


Course Outline
Day One
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts/premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Two
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Investor such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

5070 Courses delivered Online

Admin, Secretarial & PA

By NextGen Learning

Business Analysis - Practice

By Nexus Human

Advanced SQL Programming (TTSQL005)

By Nexus Human

Xero Bookkeeper Training

By Course Gate

Real Estate Investing

By LearnDrive UK

Power BI - introduction (2 day) (In-House)

By The In House Training Company

Certified Data Centre Risk Professional (CDRP)

By Nexus Human

Accounting courses

By Osborne Training

Financing an Export Plan

By Business Works

Supply Chain Management, Procurement & Logistics Management

By NextGen Learning