Name: Microsoft Project Introduction/Intermediate - In-company
Price: 750 GBP
Availability: InStock

Letchworth

Stevenage

These remote training sessions are flexible to enable you to pick and choose the features within FreeAgent that you would like to focus on, and ensure you maximise your training. These sessions can cover FreeAgent Accounting or Payroll - let us know your requirements. Request a date, and we&#39;ll suggest some options so you can pick a time to suit you.&nbsp; If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.

Back Office Software Support Ltd T/A Boss

Remote training session for FreeAgent Accounting and Payroll software.

FreeAgent Training Session (1 Hour)

1 Hour Xero Training Session

These remote training sessions are flexible to enable you to pick and choose the features within Sage that you would like to focus on, and ensure you maximise your training. These sessions can cover Sage Accounting or Payroll - let us know your requirements. Request a date, and we&#39;ll suggest some options so you can pick a time to suit you.&nbsp; If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.

Sage Payroll

Remote training session for Sage Accounting and Payroll software.

Sage Training Session (1 Hour)

In order to really do something with care, you have to put some passion to it. This cannot be more true when it comes to customer service. The more it is genuine, the more it is powerful and this is what I love to transmit. With more than 13 years of experience in customer service and all the required accreditations/qualifications, I am using my expertise and vision I have for customer service to make make the best long-term impact on your customer experience and clientele satisfaction. If you want to improve your or your employees&#39; customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on telephone etiquettes, communication and behaviours.Delivered both on-site and online, this course has been specifically tailored to cover key topics&nbsp;crucial to customer success and to improve customer service abilities. Topics covered:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Basics of customer relationship</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Customer care &ndash;from a powerful mindset to a perfect attitude</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Showing genuine care to generate trust</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Identify, anticipate and fulfil your customer needs</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Managing and exceeding your customer expectations</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The keys to success to effective complaints handling</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understanding your clients&rsquo; perspective better</li></ul>Length: 3 hours Feel free to reach out if you want to know more or enquire my course!

Beyond Satisfaction - Customer service Training

Customer Experience

Customer Care

Customer Service

Know Your Customer (KYC)

Customer Relations

Customer Success (CS)

Customer Journey

Customer Relationship Management

Hospitality Management

Hospitality & Tourism

Dealing With Difficult Customers

Customer Experience Management

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on telephone etiquettes, communication and behaviours.

All you need to know about telephone etiquettes, communication and behaviours

In order to really do something with care, you have to put some passion to it. This cannot be more true when it comes to customer service. The more it is genuine, the more it is powerful and this is what I love to transmit. With more than 13 years of experience in customer service and all the required accreditations/qualifications, I am using my expertise and vision I have for customer service to make make the best long-term impact on your customer experience and clientele satisfaction. If you want to improve your or your employees&#39; customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on delivering the best customer care.Delivered both on-site and online, this course has been specifically tailored to cover key topics&nbsp;crucial to customer success and to improve customer service abilities. Topics covered:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Basics of customer relationship</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Customer care &ndash;from a powerful mindset to a perfect attitude</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Showing genuine care to generate trust</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Identify, anticipate and fulfil your customer needs</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Managing and exceeding your customer expectations</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The keys to success to effective complaints handling</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understanding your clients&rsquo; perspective better</li></ul>Length: 3 hours Feel free to reach out if you want to know more or enquire my course!

Hospitality & Catering

Hospitality

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on delivering the best customer care.

Delivering the best customer care when dealing with clients


These remote training sessions are flexible to enable you to pick and choose the features within QuickBooks that you would like to focus on, and ensure you maximise your training. These sessions can cover QuickBooks Accounting or Payroll - let us know your requirements. Request a date, and we&#39;ll suggest some options so you can pick a time to suit you.&nbsp; If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.

QuickBooks

Remote training session for QuickBooks Accounting and Payroll software.

QuickBooks Training Session (1 Hour)

These remote training sessions are flexible to enable you to pick and choose the features within Xero that you would like to focus on, and ensure you maximise your training. These sessions can cover Xero Accounting or Payroll - let us know your requirements. Request a date, and we&#39;ll suggest some options so you can pick a time to suit you.&nbsp; If you would prefer in-person training, or sessions longer than one hour, contact us for a chat.

Remote training session for Xero Accounting and Payroll software.

Xero Training Session (1 Hour)

Board members face a huge amount of information and review before the board meeting. &nbsp;Here is step-by-step process for mastering your board meeting prep challenge.

Ralph Ward

Board members face a huge amount of information and review before the board meeting.  Here is step-by-step process for mastering your board meeting prep challenge.

Board Meeting Prep - Tips and Tools

Harpenden

This is not a single course but a set of menu options from which you can 'pick and mix' to create a draft programme yourself, as a discussion document which we can then fine-tune with you. For a day's training course, simply consider your objectives, select six hours' worth of modules and let us do the fine-tuning so that you get the best possible training result.Consider your objectives carefully for maximum benefit from the course. Is the training for new or experienced credit control staff? Are there specific issues to be addressed within your particular sector (eg, housing, education, utilities, etc)? Do your staff need to know more about the legal issues? Or would a practical demonstration of effective telephone tactics be more useful to them?<section>
 <h3>Menu</h3>Rather than a generic course outline, the expert trainer has prepared a training 'menu' from which you can select those topics of most relevance to your organisation. We can then work with you to tailor a programme that will meet your specific objectives. 					<ul><li>Advanced credit control skills for supervisors - 1â2 day</li><li>Basic legal overview: do's and don'ts of debt recovery - 2 hours</li><li>Body language in the credit and debt sphere - 1â2 day</li><li>County Court suing and enforcement - 1â2 day</li><li>Credit checking and assessment - 1 hour</li><li>Customer visits and 'face to face' debt recovery skills - 1â2 day</li><li>Data Protection Act explained - 1â2 day</li><li>Dealing with 'Caring Agencies' and third parties - 1 hour</li><li>Debt counselling skills - 2 hours</li><li>Elementary credit control skills for new staff - 1â2 day</li><li>Granting credit and collecting debt in Europe - 1â2 day</li><li>Identifying debtors by 'type' to handle them accurately - 1 hour</li><li>Insolvency: Understanding bankruptcy / receivership / administration / winding-up / liquidation / CVAs and IVAs - 2 hours</li><li>Late Payment of Commercial Debts Interest Act explained - 2 hours</li><li>Liaison with sales and other departments for maximum credit effectiveness - 1 hour</li><li>Suing in Scottish Courts (Small Claims and Summary Cause) - 1â2 day</li><li>Telephone techniques for successful debt collection - 11â2 hours</li><li>Terms and conditions of business with regard to credit and debt - 2 hours</li><li>Tracing 'gone away' debtors (both corporate and individual) - 11â2 hours</li><li>What to do if you/your organisation are sued - 1â2 day</li></ul>Other topics you might wish to consider could include:<ul><li>Assessment of new customers as debtor risks</li><li>Attachment of Earnings Orders</li><li>Bailiffs and how to make them work for you</li><li>Benefit overpayments and how to recover them</li><li>Cash flow problems (business)</li><li>Charging Orders over property/assets</li><li>Credit policy: how to write one</li><li>Council and Local Authority debt recovery</li><li>Consumer Credit Act debt issues</li><li>Using debt collection agencies</li><li>Director's or personal guarantees</li><li>Domestic debt collection by telephone</li><li>Exports (world-wide) and payment for</li><li>Emergency debt recovery measures</li><li>Education Sector debt recovery</li><li>Forms used in credit control</li><li>Factoring of sales invoices</li><li>Finance Sector debt recovery needs</li><li>Third Party Debt Orders (Enforcement)</li><li>Government departments (collection from)</li><li>Harassment (what it is - and what it is not)</li><li>Health sector debt recovery skills</li><li>Hardship (members of the public)</li><li>Insolvency and the Insolvency Act</li><li>In-house collection agency (how to set up)</li><li>Instalments: getting offers which are kept</li><li>Judgment (explanation of types)</li><li>Keeping customers while collecting the debt</li><li>Late payment penalties and sanctions</li><li>Letter writing for debt recovery</li><li>Major companies as debtors</li><li>Members of the public as debtors</li><li>Monitoring of major debtors and risks</li><li>Negotiation skills for debt recovery</li><li>Old debts and how to collect them</li><li>Out of hours telephone calls and visits</li><li>Office of Fair Trading and collections</li><li>Oral Examination (Enforcement)</li><li>Pro-active telephone collection</li><li>Parents of young debtors</li><li>Partnerships as debtors</li><li>Positive language in debt recovery</li><li>Pre-litigation checking skills</li><li>Power listening skills</li><li>Questions to solicit information</li><li>Retention of title and 'Romalpa' clauses</li><li>Sale of Goods Act explained</li><li>Salesmen and debt recovery</li><li>Sheriffs to enforce your judgment</li><li>Students as debtors</li><li>Statutory demands for payment</li><li>Small companies (collection from)</li><li>Sundry debts (collection of)</li><li>Terms and Conditions of Contract</li><li>Tracing 'gone away' debtors</li><li>The telephone bureau and credit control</li><li>Taking away reasons not to pay</li><li>Train the trainer skills</li><li>Utility collection needs</li><li>Visits for collection and recovery</li><li>Warrant of execution (enforcement)</li></ul>			 


 </section>

The In House Training Company

Finance Cert & Exam Prep

Credit Control

Counselling Skills

Debt Management

Finance For Non Finance Managers

Credit Controller

Credit control training 'menu' (In-House)

An insightful, enjoyable and experiential programme to help you analyse data and information and make a balanced decision based upon sound commercial reasoning. It will enable you to identify options, make decisions and take actions based on a thorough analysis combined with instinct and intuition to make a positive effect on profitability.This programme will help you:<ul><li>Identify ways to analyse data and sort relevant from irrelevant information</li><li>Develop analytical and numerate thinking, and consider the financial implications of a decision</li><li>Make decisions based on sound commercial reasoning - a mix of intuition and analysis</li><li>Select from a range of tools to analyse a situation and apply these effectively</li><li>Understand how costs and profits are calculated</li><li>Use tried-and-tested techniques to manage and control your budgets</li><li>Appreciate the fundamentals of financial analysis</li><li>Focus on the bottom line</li><li>Identify the basics of capital investment appraisal for your business</li><li>Evaluate results and seek opportunities for improvement to your business</li></ul><section>
 <h3>1 The commercial environment</h3><ul><li>What do shareholders and investors want?</li><li>What do managers want?</li><li>Profit v non-profit organisations</li><li>Investor expectations</li></ul> <h3>2 Financial and non-financial information</h3><ul><li>Risk and reward considerations</li><li>Drivers of commercial decisions</li></ul> <h3>3 Running a business</h3><ul><li>A practical exercise to bring financial statements to life</li><li>Different stakeholder interests in a business</li><li>The impact and consequences of decisions on financial statements</li></ul> <h3>4 Where do I make a difference to the organisation?</h3><ul><li>How can I contribute to an improved business performance?</li><li>Key performance indicators - measuring the right things</li><li>A 'balanced scorecard' approach - it's not all about money!</li></ul> <h3>5 A 'balanced scorecard' approach</h3><ul><li>Analysing and reviewing my contribution to the business direction</li><li>What is the current focus of my commercial decisions?</li><li>Developing the business in the right way - getting the balance right!</li><li>Where should/could it be in the future?</li><li>Do my decisions support the overall vision and strategy?</li></ul> <h3>6 Making commercial decisions</h3><ul><li>Left-brain and right-brain thinking</li><li>Convergent and divergent thinking</li><li>Analysis and instinct</li><li>Interactive case study exercise - emotional and rational decisions</li><li>Reflection - what is my style of making decisions</li></ul> <h3>7 Let's consider the customer!</h3><ul><li>Identifying target markets</li><li>Differentiating propositions and products</li><li>Customer service considerations</li><li>Marketing considerations and initiatives</li><li>Pricing strategies and considerations</li></ul> <h3>8 Strategic analysis</h3><ul><li>The external environment</li><li>The internal environment</li><li>LEPEST analysis</li><li>SWOT analysis</li><li>Forecasting</li><li>Group activity - analysing markets and the competition</li><li>How do these improve your decisions?</li></ul> <h3>9 Comparing performance</h3><ul><li>Analysing key financial ratios</li><li>Ways to compare performance and results</li><li>Break-even analysis</li></ul> <h3>10 Profit and loss accounts and budgeting</h3><ul><li>Managing income and expenditure</li><li>The budgeting process</li><li>How does this link to the profit and loss account?</li><li>Managing and controlling a cost centre/budget</li><li>The role of the finance department</li><li>Different ways of budgeting</li><li>Incremental budgeting</li><li>Zero-based budgeting</li></ul> <h3>11 Understanding the balance sheet</h3><ul><li>Purpose of balance sheets</li><li>Understanding and navigating the content</li><li>What does a balance sheet tell you?</li><li>How do you affect your balance sheet?</li><li>Links to the profit and loss account</li><li>A practical team exercise that brings financial statements to life</li></ul> <h3>12 Business decisions exercise</h3><ul><li>How does this improve your decisions?</li><li>A practical exercise to apply new knowledge and bring commercial thinking to to life</li><li>The impact and consequences of decisions on financial statements</li></ul> <h3>13 Working capital</h3><ul><li>Why is this important?</li><li>The importance of keeping cash flowing</li><li>Business decisions that affect cash</li><li>Calculating profit</li></ul> <h3>14 Capital investment appraisal</h3><ul><li>Capex v Opex</li><li>Payback</li><li>Return on investment</li><li>The future value of money</li><li>The concept of hurdle rate</li></ul> <h3>15 Lessons learned and action planning</h3><ul><li>So what?</li><li>Recap and consolidation of learning</li><li>The decisions that I need to consider</li><li>Actions to achieve my plan</li></ul> 


 </section>

Financial Modelling & Analysis

Business Analysis

Business Accounting

Corporate Finance Level 1

Practical Accounting

Commercial instinct (In-House)

Price&pound;750 inc VATFinance optionsIn Company training - &pound;750 for groups of up to 8 delegates.Discounts for Nonprofits/Charities...&nbsp;Study methodOn-siteDuration2 days, Full-timeQualificationNo formal qualificationCertificatesCertificate of completion - FreeAdditional infoTutor is available to students <hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;">Course ObjectivesAt the end of this course you will be able to:<ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;">Identify the components of the Microsoft Project environment</li><li fr-original-style="" style="box-sizing: border-box;">Create a new project plan</li><li fr-original-style="" style="box-sizing: border-box;">Create the project schedule</li><li fr-original-style="" style="box-sizing: border-box;">Use different views to analyse the project plan</li><li fr-original-style="" style="box-sizing: border-box;">Create, allocate and manage resources in a project plan</li><li fr-original-style="" style="box-sizing: border-box;">Finalise a project plan</li><li fr-original-style="" style="box-sizing: border-box;">Track progress</li><li fr-original-style="" style="box-sizing: border-box;">View and report project plan information</li></ul>&#39; 1 year email support serviceCustomer Feedback<ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;">Very good course. Learnt a lot. Looking forward to the next level.</li><li fr-original-style="" style="box-sizing: border-box;">Alexandra - CIAL</li></ul>1 year email support serviceTake a closer look at the&nbsp;consistent excellent feedback from our growing corporate clients&nbsp;visiting our site&nbsp;ms-officetraining co ukWith more than 20 years experience, we deliver courses on all levels of the Desktop version of&nbsp;Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering&nbsp;public, one to one, tailored and bespoke courses.<ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;">Our competitive rates&nbsp;start from &pound;550.00 per day of training</li></ul>Tailored training courses:You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.<hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><section style="color: rgb(15, 21, 26); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;">Description</h2>Introduction to Microsoft Project<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Recap on project management concepts</li><li fr-original-style="" style="box-sizing: border-box;">Project environment overview</li><li fr-original-style="" style="box-sizing: border-box;">The 3 databases: Tasks, Resources and Assignments</li><li fr-original-style="" style="box-sizing: border-box;">Different ways of displaying the Project Plan</li><li fr-original-style="" style="box-sizing: border-box;">Access Help</li></ul>Creating a Project Plan<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Create a New Project Plan</li><li fr-original-style="" style="box-sizing: border-box;">Project Information</li><li fr-original-style="" style="box-sizing: border-box;">Create and apply the project calendar</li><li fr-original-style="" style="box-sizing: border-box;">Defining recurring exceptions to the calendar</li><li fr-original-style="" style="box-sizing: border-box;">Defining the calendar&#39;s work weeks</li><li fr-original-style="" style="box-sizing: border-box;">Create the Summary tasks</li><li fr-original-style="" style="box-sizing: border-box;">Create the Work Breakdown Structure</li></ul>Task creation and scheduling<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Exploring the Entry Table and its fields</li><li fr-original-style="" style="box-sizing: border-box;">Task editing and the Task Information window</li><li fr-original-style="" style="box-sizing: border-box;">Task Durations</li><li fr-original-style="" style="box-sizing: border-box;">Defining Milestones</li><li fr-original-style="" style="box-sizing: border-box;">Manual Scheduling vs Automatic Scheduling</li><li fr-original-style="" style="box-sizing: border-box;">Changing the Task&#39;s Calendar</li><li fr-original-style="" style="box-sizing: border-box;">Create a split in a Task</li><li fr-original-style="" style="box-sizing: border-box;">Create Task Relationships</li><li fr-original-style="" style="box-sizing: border-box;">Adding Lag or Lead to a Relationship</li><li fr-original-style="" style="box-sizing: border-box;">Identifying the Critical Path</li><li fr-original-style="" style="box-sizing: border-box;">Adding Constraints and Deadlines to Tasks</li><li fr-original-style="" style="box-sizing: border-box;">Create Recurring Activities</li><li fr-original-style="" style="box-sizing: border-box;">Adding Notes and links to Tasks</li></ul>Managing Resources<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Exploring the Entry Table and its fields</li><li fr-original-style="" style="box-sizing: border-box;">Resource editing and the Resource Information window</li><li fr-original-style="" style="box-sizing: border-box;">Resource Types</li><li fr-original-style="" style="box-sizing: border-box;">Fixed Costs vs Variable Costs</li><li fr-original-style="" style="box-sizing: border-box;">Adding Resource Costs</li><li fr-original-style="" style="box-sizing: border-box;">Defining when costs accrue</li><li fr-original-style="" style="box-sizing: border-box;">Changing the Resource Calendar and Availability</li><li fr-original-style="" style="box-sizing: border-box;">Project calendar vs Resource and Task Calendar</li><li fr-original-style="" style="box-sizing: border-box;">Assigning Resources to Tasks</li><li fr-original-style="" style="box-sizing: border-box;">Effort Driven Scheduling</li><li fr-original-style="" style="box-sizing: border-box;">Resolving Resource Overallocation</li></ul>Tracking the Project Progress<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Setting a Project Baseline</li><li fr-original-style="" style="box-sizing: border-box;">Entering Actuals</li><li fr-original-style="" style="box-sizing: border-box;">Different ways of viewing the Progress</li><li fr-original-style="" style="box-sizing: border-box;">Checking if the Project is on track</li></ul>Viewing and Reporting Project Detail<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Adding Tasks to the Timeline and sharing it</li><li fr-original-style="" style="box-sizing: border-box;">Modifying the Timescale and Zoom level</li><li fr-original-style="" style="box-sizing: border-box;">Formatting the Gantt View</li><li fr-original-style="" style="box-sizing: border-box;">Filtering and Grouping Tasks</li><li fr-original-style="" style="box-sizing: border-box;">Print and Troubleshoot the Gantt View</li><li fr-original-style="" style="box-sizing: border-box;">Using built-in Reports in Microsoft Project</li></ul></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;">Who is this course for?</h2>This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. </section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;">Requirements</h2>General knowledge of the Windows OS</section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;"> </h2><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;">Career path</h2>Microsoft Office know-how can instantly increase your job prospects as well as your salary.80 percent of job openings require spreadsheet and word-processing software skills</section>

Microsoft Office Training

Microsoft Project Introduction/Intermediate - In-company

General admission

This course is taught using a set of principles and methodologies developed by us to give participants a system they can always refer to any time they get stuck trying to interpret financial information.&nbsp;We have developed a 4-box model for teaching accounting which makes the process of breaking down any transaction natural for the nonaccountant. The system works without the need to learn any double-entry accounting, participants apply the system and instinctively know what to do.&nbsp;This is followed up with another 4-box model we developed to completely break down financial analysis and ratios into the most fundamental metrics required of every role in an organization. &nbsp;Our approach is to teach financial analysis by making each participant aware of how their role and actions directly impact the company&#39;s bottom line.&nbsp;Participants will also be able to interpret the financial statement in a natural way using a third model (the 5 Box Balance Sheet) to analyze business performance effectively.&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;4 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

Financial Intelligence

Finance Fundamentals

Elevate your role as a non-finance manager by learning to interpret financial information and analysis and learn how your actions directly impact the company's bottom line. 

Finance for Non-Finance Managers

General Admission



The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.
With a strong emphasis on practical application, you will gain a profound understanding of the complexities involved in analysing investment cash flows and interpreting their implications for effective decision-making.
Upon completion of the course, you will have the expertise to confidently model investment cash flows to a proficient level, empowering you to make informed financial decisions and drive positive outcomes for your investments.


The Investment focused school combines three of our courses:
Real Estate Analyst
Real Estate Modelling Masterclass
Understanding Key Principles of Real Estate Financial Modelling


On this course you will…
Construct Investment Financial Models starting from foundational principles
Learn how to value an appraise property investments.
Gain a comprehensive understanding of modelling tenancy schedules, including lease structures, rental income projections, lease expiry analysis, and lease renewal
Develop proficiency in creating robust models.
Understand how the application and use structure finance products in Real Estate
Learn advanced modelling techniques to analyse underlying asset risk
Appreciate the importance of data in investment cash flow modelling.
Gain a deep comprehension of the interrelationship between the metrics used in investment cash flow modelling


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 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


Day Four
Understanding Key Principles of Real Estate Financial Modelling
Real Estate Financial Modelling Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rare of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity


Price, Value & Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Discounting 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


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 Investment 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

Financial Modelling

Property Investment

Financial Analysis

Microsoft Excel

Professional Development

The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.

Real Estate Investment School (Investment Cash Flow Modelling)

In this course, you&rsquo;ll gain a basic understanding of finance and accounting concepts to drive the success of your business.This course aims to demystify the accounting language over three hours so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.Date: Wednesday 25th September 2024Time: 9:30am - 12:30pmLocation: OnlineFor: Businesses based in North Essex (Braintree, Chelmsford, Colchester, Maldon, and Tendring)Cost: FreeMore about the courseEven if you plan to hire an accountant, you still need to understand accounting information to make better, more informed decisions about your business. This webinar will give you the tools necessary to have a better understanding of what the professionals are saying down the line, so you can run your business better.What it covers:Part 1<ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Historical business finance measurement</li><li fr-original-style="" style="box-sizing: border-box;">The main performance measure - Profit &amp; Loss</li><li fr-original-style="" style="box-sizing: border-box;">The main valuation measure - Balance Sheet</li><li fr-original-style="" style="box-sizing: border-box;"> The importance of cash management and working capital</li></ul>Part 2<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">How to apply this knowledge to business planning and targeting</li><li fr-original-style="" style="box-sizing: border-box;">Using the above measurement tools to help plan and forecast business performance, particularly Profit &amp; Loss and Cashflow and the key differences between them</li><li fr-original-style="" style="box-sizing: border-box;">Break even</li><li fr-original-style="" style="box-sizing: border-box;">Pricing methods</li></ul>Who it is for:The course is aimed at a whole range of businesses from start-up founders to local business owners to corporates, and is geared to anyone without a finance or accounting background. Your business must be based in or shortly relocating to North Essex (either Braintree, Chelmsford, Colchester, Maldon, or Tendring).Who should attend:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Entrepreneurs</li><li fr-original-style="" style="box-sizing: border-box;">Micro business owners</li><li fr-original-style="" style="box-sizing: border-box;">Small business owners</li><li fr-original-style="" style="box-sizing: border-box;">Middle managers</li><li fr-original-style="" style="box-sizing: border-box;">Consultants</li><li fr-original-style="" style="box-sizing: border-box;">Coaches</li><li fr-original-style="" style="box-sizing: border-box;">E-commerce businesses</li><li fr-original-style="" style="box-sizing: border-box;">Digital marketers</li><li fr-original-style="" style="box-sizing: border-box;">Service based business owners</li></ul>Skills gained:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand basic financial documents used in business</li><li fr-original-style="" style="box-sizing: border-box;">Interpret the information in these documents, and use it to manage day-to-day business activity</li><li fr-original-style="" style="box-sizing: border-box;">Be more effective in their role</li></ul>About the host:Jim Fletcher ACMA GCMAJim is a business manager with Let&#39;s Do Business Group and a dedicated business coach with 40 years&rsquo; commercial leadership experience. Drawing on his long career in the manufacturing and engineering sector, Jim provides tailored coaching, consultancy, non-executive directorship and project management services, across a full range of management, finance, sales &amp; marketing and operations functions.<hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;">This programme is delivered by the North Essex Economic Board (NEEB) in partnership with Let&#39;s Do Business Group.Let&#39;s Do Business Group is undertaking this project jointly with the&nbsp;<a href="https://neeb.org.uk/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://neeb.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">North Essex Economic Board (NEEB)</a>. The Board is a partnership of local authorities in the area: Braintree, Maldon, and Tendring district councils, Colchester Borough Council, Chelmsford City Council and Essex County Council.This project is funded by the UK Government through the UK Shared Prosperity Fund.The UK Shared Prosperity Fund is a central pillar of the UK government&#39;s Levelling Up agenda and provides &pound;2.6 billion of funding for local investment by March 2025. The Fund aims to improve pride in place and increase life chances across the UK investing in communities and place, supporting local business, and people and skills. For more information, visit&nbsp;<a href="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus</a>Please click here to see our&nbsp;<a href="https://backingessexbusiness.co.uk/privacy-policy" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://backingessexbusiness.co.uk/privacy-policy" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Privacy Policy</a>. Please note that your details may be shared with the North Essex Economic Board who are funding this project.

In this course, you’ll gain a basic understanding of finance and accounting concepts to drive the success of your business.
This course aims to demystify the accounting language over three hours so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.
Date: Wednesday 25th September 2024
Time: 9:30am - 12:30pm
Location: Online
For: Businesses based in North Essex (Braintree, Chelmsford, Colchester, Maldon, and Tendring)
Cost: Free
More about the course
Even if you plan to hire an accountant, you still need to understand accounting information to make better, more informed decisions about your business. This webinar will give you the tools necessary to have a better understanding of what the professionals are saying down the line, so you can run your business better.
What it covers:
Part 1
Historical business finance measurement
The main performance measure - Profit & Loss
The main valuation measure - Balance Sheet
The importance of cash management and working capital
Part 2
How to apply this knowledge to business planning and targeting
Using the above measurement tools to help plan and forecast business performance, particularly Profit & Loss and Cashflow and the key differences between them
Break even
Pricing methods
Who it is for:
The course is aimed at a whole range of businesses from start-up founders to local business owners to corporates, and is geared to anyone without a finance or accounting background. Your business must be based in or shortly relocating to North Essex (either Braintree, Chelmsford, Colchester, Maldon, or Tendring).
Who should attend:
Entrepreneurs
Micro business owners
Small business owners
Middle managers
Consultants
Coaches
E-commerce businesses
Digital marketers
Service based business owners
Skills gained:
Understand basic financial documents used in business
Interpret the information in these documents, and use it to manage day-to-day business activity
Be more effective in their role
About the host:
Jim Fletcher ACMA GCMA
Jim is a business manager with Let's Do Business Group and a dedicated business coach with 40 years’ commercial leadership experience. Drawing on his long career in the manufacturing and engineering sector, Jim provides tailored coaching, consultancy, non-executive directorship and project management services, across a full range of management, finance, sales & marketing and operations functions.



This programme is delivered by the North Essex Economic Board (NEEB) in partnership with Let's Do Business Group.
Let's Do Business Group is undertaking this project jointly with the North Essex Economic Board (NEEB). The Board is a partnership of local authorities in the area: Braintree, Maldon, and Tendring district councils, Colchester Borough Council, Chelmsford City Council and Essex County Council.
This project is funded by the UK Government through the UK Shared Prosperity Fund.
The UK Shared Prosperity Fund is a central pillar of the UK government's Levelling Up agenda and provides £2.6 billion of funding for local investment by March 2025. The Fund aims to improve pride in place and increase life chances across the UK investing in communities and place, supporting local business, and people and skills. For more information, visit https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus
Please click here to see our Privacy Policy. Please note that your details may be shared with the North Essex Economic Board who are funding this project.

Let’s Do Business Group

This course aims to demystify the accounting language so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.

Finance for Non-Financial Entrepreneurs - North Essex

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

Continuous Professional Development (CPD)

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

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"> </h2>This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models. On this course you will...<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</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 professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul> Course Outline:<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;">Advanced 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 Modelling Masterclass 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>



This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.


On this course you will...
Understand how the application and use of Structured Finance products in Real Estate
Learn how to introduce several tranches of debt in a development project
Understand how to model different parties to a project
Create Joint Venture structures between Developers, Lenders and Equity Partners
Learn advanced modelling techniques to analyse underlying asset risk
Understand how underlying asset risk impacts return to all parties to a project


Who will benefit from this course?
Real Estate professionals from a mid to senior 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, portfolio analysis, and risk analysis
Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level


Course Outline:
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advanced 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 Modelling Masterclass 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

Real Estate Finance

Investment Management

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

<div id="course-pills-1">Duration1 Days6 CPD hoursThis course is intended forTo ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.OverviewUpon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.</div><div id="course-pills-2"><h4>Working with Multiple Worksheets and Workbooks </h4><ul><li>Working with Named Ranges</li><li>Link Cells Across Worksheets and Workbooks </li><li>Use 3D References to Calculate Across Worksheets</li><li>Consolidate Data</li></ul><h4>Use Formula Auditing and Error Checking</h4><ul><li>Reveal Formulas</li><li>Trace Cell Precedents and Dependents </li><li>Locate Errors in Formulas </li><li>Watch and Evaluate Formulas </li></ul><h4>Reviewing and Protecting Workbooks </h4><ul><li>Control Data Entry via Data Validation</li><li>Protect Workbook Access</li><li>Protect Worksheets and Cell Content </li><li>Add and Edit Comments</li><li>Prepare a Workbook for Distribution </li><li>Modify Excel's Default Settings</li></ul><h4>Using Macros to Automate Workbook Functionality</h4><ul><li>Create Macros via Recording </li><li>Run Macros via Buttons and Shortcuts</li><li>Assign Macros to the Quick Access Toolbar and Ribbon </li><li>Assign Macros to Objects </li><li>View Macro Code</li></ul><h4>Forecasting and Analysis Data</h4><ul><li>Use Conditional Formatting to Highlight, Sort and Filter Key Data</li><li>Advanced Conditional Formatting using Formulas</li><li>Create Sparklines to Visualise Data</li><li>Add Trendlines to Charts to Visualise and Forecast Trends</li><li>Use Data Tables and Scenarios to Project Potential Outcomes </li><li>Use Goal Seek to Calculate Outcomes</li><li>Forecast Data Trends Using Solver</li></ul></div>

Nexus Human

Office Skills & Productivity

Excel Analytics

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools



Bayfield Training and the University of Cambridge Department of Land Economy
This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise.
If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you.
This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.
 Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment.


On this course you will:
Become a competent model builder, building Real Estate Financial Models from scratch
Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia
Learn how to use Real Estate Financial Models to make informed investment decisions
Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill
This course is suitable for:
Chartered Surveyors
Asset Managers
Financial Controllers
Financial Analysts
Investment Managers
Property Managers
Real Estate Students/Recent Graduates
Course Outline:
Module 1 - Economic Context
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Why Real Estate Asset Modelling is important
Understanding the occupier, asset and development markets and the relevant modelling approaches for each
Real Estate Sub-Sector Key Performance Indicators
Introduction to conventional valuations and financial mathematics
Understanding and minimising errors in Financial Models


Module 2 - Cash Flow Fundamentals
Constructing a financial model from first principles.
Understanding all the components of a basic cash flow model
Understand why Corporate Finance Models and Real Estate Models are different
Financial Model Design
Making the link between valuations, income mathematics and discounted cash flows
Internal Rate of Return, Net Present Value,Worth and other metrics
Features and techniques to aid fast model building


Module 3 - Developing the Cash Flow
Adapting financial models for different periodicities and building rent functions for different rent behaviour.
Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc.
Developing the concept of a Rent Function in Excel
Logic mathematics and Logic functions
Projecting rent to adapt to different lease contracts and growth patterns
Alternative solutions to Logic functions
Comparative analysis of lease structures in different jurisdictions and adapting financial models


Module 4 - Real Estate Data
Understanding the different sources of data, constructing basic time series models and recognising basic patterns.
Key Property market indicators
Characteristics and application of key input metrics for Real Estate Appraisals
Understanding the eight components of Real Estate Price Dynamics
Awareness of the different sources of data
Reading and using general property market reports
Constructing basic time series models and recognising basic patterns


Module 5 - Development Appraisals
Constructing a development appraisal from first principles and understanding development return metrics.
Understanding the key components of a development project
Understanding the difference between development and investment appraisals
Residual Appraisals and Profit Calculations
Cost orientated cash flows and phased sales
Cumulative construction cost patterns: incidental, fixed, loaded and S-curve
Development return metrics and Modified IRRs


Module 6 - Multi-let Cash Flows
Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions.
Multi-let and portfolio model design principles
Building complex date functions and date series
The three multi-let rent projection techniques
Perpendicular Rent Functions
Incorporate advanced rent adjustments into the Rent Function
Incorporate sector and period varying rental growth rates
Simplifying OPEX and CAPEX projections
Discounting techniques on complex and volatile cash flows


Module 7 - Project Finance
Constructing a flexible Real Estate Debt Finance model.
Revision of the Mathematics of amortisation and debt finance
Basic senior debt models and geared net cash flow
LTV, IRR and Interest Rate Dynamics
Flexible term, repayment options and deferred interest
Loan covenant tests
Understanding different tranches of debt
Understanding how complex debt structures impact the returns to different parties


Module 8 - Model Interpretation and Risk Analysis
Learn how to read, analyse and report on real estate financial models.
Understand how to read models and develop an investment narrative
Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards
Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins
Learn how to construct varied project scenarios in a systematic way
Introduction to Monte Carlo Analysis and VBA
Optimising sale dates and other parameters
Create well written, attractive and persuasive reports


Included in the Course
Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge
64 CPD Hours
1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee
Course Files
Q&A Webinars and Guest Speaker Webinars
Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers


2024 Cohort Dates Include:
3rd June to 29th July
5th August to 25th September 2024
30th September to 25th November


For more information, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)

Southend-On-Sea

In this 2-day course, you&rsquo;ll gain a basic understanding of finance and accounting concepts to drive the success of your business.This workshop aims to demystify the accounting language so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.Dates: Tuesday 1st &amp; Wednesday 2nd October 2024Time: 9:30am - 4:30pmLocation: Launchpad Southend, Airport Business Park, Launchpad, Rochford SS4 1YHCost: FreeFor: Businesses based in or shortly moving to Southend-On-SeaEven if you plan to hire an accountant, you still need to understand accounting information to make better, more informed decisions about your business. This course will give you the tools necessary to have a better understanding of what the professionals are saying down the line, so you can run your business better.You&rsquo;ll learn about double-entry bookkeeping, trial balances, profit and loss statements, and other must-have accounting topics, and in further sessions, you&rsquo;ll learn how to apply these techniques to manage your business better, which will give you confidence and control when making financial decisions.**The course will be run in person over two days, in 7 hour sessions (with 1 hour lunch breaks) on 1st October &amp; 2nd October.&nbsp;Please note: lunch is not provided however, there is a refreshments area for drinks and snacks**<h3 fr-original-style="" style="box-sizing: border-box;">What it covers:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Double-entry bookkeeping</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Preparation of profit and loss accounts, balance sheets, and cash-flow statements</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Analysis of accounting reports</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Controlling cash</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Sources of funding</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Business planning, budgets, cash flow forecasting, and variance analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Break-even analysis</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Capital appraisal</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Product costing</li></ul><h3 fr-original-style="" style="box-sizing: border-box;">Who should attend:</h3>The course is aimed at a whole range of businesses from start-up founders to local business owners to corporates and is geared to anyone without a finance or accounting background. Your business must be based in or shortly relocating to Southend-On-Sea.<h3 fr-original-style="" style="box-sizing: border-box;">Who should attend:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Entrepreneurs</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Micro business owners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Small business owners</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Middle managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Consultants</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Coaches</li><li value="7" fr-original-style="" style="box-sizing: border-box;">E-commerce businesses</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Digital marketers</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Service based business owners</li></ul><h3 fr-original-style="" style="box-sizing: border-box;">Skills gained:</h3>The full value from this course is only be gained by full participation in both days. After completing the course, delegates will be able to:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand basic financial documents used in business</li><li fr-original-style="" style="box-sizing: border-box;">Interpret the information in these documents, and use it to manage day-to-day business activity</li><li fr-original-style="" style="box-sizing: border-box;">Be more effective in their role</li></ul>About the host:Jim Fletcher ACMA GCMAJim is a dedicated business coach with 40 years&rsquo; commercial leadership experience. Drawing on his long career in the manufacturing and engineering sector, Jim provides tailored coaching, consultancy, non-executive directorship and project management services, across a full range of management, finance, sales &amp; marketing and operations functions.<hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;">This workshop is organised by Let&#39;s Do Business Group on behalf of Southend-On-Sea City Council and is funded by the UK Government through the <a href="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" data-airgap-id="106" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">UK Shared Prosperity Fund</a>.The UK Shared Prosperity Fund is a central pillar of the UK government&#39;s Levelling Up agenda and provides &pound;2.6 billion of funding for local investment by March 2025. The Fund aims to improve pride in place and increase life chances across the UK investing in communities and place, supporting local business, and people and skills.View our&nbsp;<a href="https://backingessexbusiness.co.uk/privacy-policy" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://backingessexbusiness.co.uk/privacy-policy" data-airgap-id="107" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">privacy policy</a>

In this course, you’ll gain a basic understanding of finance and accounting concepts to drive the success of your business.
This workshop aims to demystify the accounting language so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.
Dates: Tuesday 1st October 2024
Time: 9:30am - 12:30pm
Location: Online (ZOOM)
Cost: Free
For: Businesses based in or shortly moving to Southend-On-Sea
Even if you plan to hire an accountant, you still need to understand accounting information to make better, more informed decisions about your business. This course will give you the tools necessary to have a better understanding of what the professionals are saying down the line, so you can run your business better.
You’ll learn about double-entry bookkeeping, trial balances, profit and loss statements, and other must-have accounting topics, and in further sessions, you’ll learn how to apply these techniques to manage your business better, which will give you confidence and control when making financial decisions.
What it covers:
Double-entry bookkeeping
Preparation of profit and loss accounts, balance sheets, and cash-flow statements
Analysis of accounting reports
Controlling cash
Sources of funding
Business planning, budgets, cash flow forecasting, and variance analysis
Break-even analysis
Capital appraisal
Product costing
Who should attend:
The course is aimed at a whole range of businesses from start-up founders to local business owners to corporates and is geared to anyone without a finance or accounting background. Your business must be based in or shortly relocating to Southend-On-Sea.
Who should attend:
Entrepreneurs
Micro business owners
Small business owners
Middle managers
Consultants
Coaches
E-commerce businesses
Digital marketers
Service based business owners
Skills gained:
The full value from this course is only be gained by full participation in both days. After completing the course, delegates will be able to:
Understand basic financial documents used in business
Interpret the information in these documents, and use it to manage day-to-day business activity
Be more effective in their role
About the host:
Jim Fletcher ACMA GCMA
Jim is a dedicated business coach with 40 years’ commercial leadership experience. Drawing on his long career in the manufacturing and engineering sector, Jim provides tailored coaching, consultancy, non-executive directorship and project management services, across a full range of management, finance, sales & marketing and operations functions.



This workshop is organised by Let's Do Business Group on behalf of Southend-On-Sea City Council and is funded by the UK Government through the UK Shared Prosperity Fund.
The UK Shared Prosperity Fund is a central pillar of the UK government's Levelling Up agenda and provides £2.6 billion of funding for local investment by March 2025. The Fund aims to improve pride in place and increase life chances across the UK investing in communities and place, supporting local business, and people and skills.
View our privacy policy

In this 3-hour course, you’ll gain a basic understanding of finance and accounting concepts to drive the success of your business.

Finance for Non-Financial Entrepreneurs - Southend-On-Sea

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

Risk Management

Investment

Financial Risk 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)

Are you looking to enter the dynamic world of real estate?Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics.At the end of the course, you&#39;ll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector. On this course, you will&hellip;<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Become familiar with the players, structure, general terminology and overall needs of Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">Learn what is Real Estate and why it is different from other asset classes</li><li fr-original-style="" style="box-sizing: border-box;">Get to grips with the overall size and structure of the UK Real Estate Market</li><li fr-original-style="" style="box-sizing: border-box;">Learn and analyse the links between the different parts of the property market</li><li fr-original-style="" style="box-sizing: border-box;">Understand who works in the Real Estate Market, their qualifications and their job descriptions</li><li fr-original-style="" style="box-sizing: border-box;">Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc&hellip;</li><li fr-original-style="" style="box-sizing: border-box;">Learn how to read a real estate market report</li><li fr-original-style="" style="box-sizing: border-box;">Understand how current affairs, politics and economics affects Real Estate Investment</li><li fr-original-style="" style="box-sizing: border-box;">Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector</li></ul> Who will benefit from this course:<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Graduates or undergraduates studying economics, finance.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals working in Marketing or Accounting teams within Real Estate firms.</li><li fr-original-style="" style="box-sizing: border-box;">APC students.</li><li fr-original-style="" style="box-sizing: border-box;">Anyone interested in Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">School leavers/A-Level Students looking to gain an understanding of Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">Non cognate students who wish to transfer into Real Estate/Finance careers.</li></ul> Course OutlineModule 1: What is and why buy Real Estate?<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The property Market</li><li fr-original-style="" style="box-sizing: border-box;">The Size and Structure of the UK property market</li><li fr-original-style="" style="box-sizing: border-box;">The impact of Real Estate in the Economy</li></ul> Module 2: The Real Estate Market System<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The Space Market</li><li fr-original-style="" style="box-sizing: border-box;">The Asset Market</li><li fr-original-style="" style="box-sizing: border-box;">The Development Market</li></ul> Module 3: How to value Real Estate<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">An Introduction to Financial Mathematics</li><li fr-original-style="" style="box-sizing: border-box;">The difference between Price, Value and Worth</li><li fr-original-style="" style="box-sizing: border-box;">Property Yield</li><li fr-original-style="" style="box-sizing: border-box;">Conventional Valuation Methods</li></ul> Module 4: How to read a Real Estate Market Report<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Property Market Indicators: Stock Indicators</li><li fr-original-style="" style="box-sizing: border-box;">Property Market Indicators: Investment Indicators</li></ul> Module 5: Who works in Real Estate?<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The build Environment by Cobalt Recruitment</li><li fr-original-style="" style="box-sizing: border-box;">Rea; Estate Agents</li><li fr-original-style="" style="box-sizing: border-box;">Examples of Real Estate Market Agents CVs</li><li fr-original-style="" style="box-sizing: border-box;">Real Estate Network</li></ul> Included in the Course<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate</li><li fr-original-style="" style="box-sizing: border-box;">12 Months Access to the Course</li><li fr-original-style="" style="box-sizing: border-box;">Course Files</li><li fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li 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 Introduction to Real Estate, 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>

Are you looking to enter the dynamic world of real estate?

Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics.

At the end of the course, you'll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector.



On this course, you will…

Become familiar with the players, structure, general terminology and overall needs of Real Estate.
Learn what is Real Estate and why it is different from other asset classes
Get to grips with the overall size and structure of the UK Real Estate Market
Learn and analyse the links between the different parts of the property market
Understand who works in the Real Estate Market, their qualifications and their job descriptions
Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc…
Learn how to read a real estate market report
Understand how current affairs, politics and economics affects Real Estate Investment
Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector


Who will benefit from this course:

Graduates or undergraduates studying economics, finance.
Professionals working in Marketing or Accounting teams within Real Estate firms.
APC students.
Anyone interested in Real Estate.
School leavers/A-Level Students looking to gain an understanding of Real Estate.
Non cognate students who wish to transfer into Real Estate/Finance careers.


Course Outline

Module 1: What is and why buy Real Estate?

The property Market
The Size and Structure of the UK property market
The impact of Real Estate in the Economy


Module 2: The Real Estate Market System

The Space Market
The Asset Market
The Development Market


Module 3: How to value Real Estate

An Introduction to Financial Mathematics
The difference between Price, Value and Worth
Property Yield
Conventional Valuation Methods


Module 4: How to read a Real Estate Market Report

Property Market Indicators: Stock Indicators
Property Market Indicators: Investment Indicators


Module 5: Who works in Real Estate?

The build Environment by Cobalt Recruitment
Rea; Estate Agents
Examples of Real Estate Market Agents CVs
Real Estate Network


155 Courses in Coventry

FreeAgent Training Session (1 Hour)

By Back Office Software Support Ltd T/A Boss

Sage Training Session (1 Hour)

By Back Office Software Support Ltd T/A Boss

All you need to know about telephone etiquettes, communication and behaviours

By Beyond Satisfaction - Customer service Training

Delivering the best customer care when dealing with clients

By Beyond Satisfaction - Customer service Training

QuickBooks Training Session (1 Hour)

By Back Office Software Support Ltd T/A Boss

Xero Training Session (1 Hour)

By Back Office Software Support Ltd T/A Boss

Board Meeting Prep - Tips and Tools

By Ralph Ward

Credit control training 'menu' (In-House)

By The In House Training Company

Commercial instinct (In-House)

By The In House Training Company

Microsoft Project Introduction/Intermediate - In-company

By Microsoft Office Training

Search By Location