Name: GDPR : Data Protection, Rights and Breaches
Price: 12 GBP
Availability: InStock

Boost your expert development and explore the strategies of effective human resources management with this endowing body certificate course.This HR Management course covers critical topics and fundamental practices and procedures, including strategic leadership, human capital, organisational culture and induction, training and development. You will also gain in-depth knowledge of the employment cycle, recruitment and selection processes through instructor-led practical exercises for real-world performance.&nbsp;This management training program is ideal for human resources experts who already have experience in this field and wish to take their careers to the next level. There are no entry requirements for this course, and on completion, learners will be able to apply their practical skills to effectively direct and manage employees within an organisation.Learning Objectives<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand the fundamentals required to work in this dynamic sector</li><li fr-original-style="" style="box-sizing: border-box;">Determine the value of human resources and their management within organisations</li><li fr-original-style="" style="box-sizing: border-box;">Succeed in an HR management or business-related role</li><li fr-original-style="" style="box-sizing: border-box;">Recognise the importance of good employee relations</li><li fr-original-style="" style="box-sizing: border-box;">Develop an awareness of HR Management disciplines in working practice</li><li fr-original-style="" style="box-sizing: border-box;">Examine the general value and benefit of providing the workforce with the highest quality training on a regular basis</li><li fr-original-style="" style="box-sizing: border-box;">Plan and implement strategic solutions and drive HR improvements to your workplace immediately</li><li fr-original-style="" style="box-sizing: border-box;">Explore expert strategies for measuring the effectiveness of employee training</li><li fr-original-style="" style="box-sizing: border-box;">Gain the opportunity to demonstrate your strengths in a number of ways</li></ul>Who is this Course for?This endorsed HR Management Course is ideal for those who have prior experience and practical knowledge in this field and would like to build on their skills to work their way up to a senior-level role. Those who are new to HR and want to expand their knowledge of fundamental principles and procedures will also find this course beneficial. This course is a complete introduction to the fundamentals of HR management and will benefit newcomers in this industry who are looking to add new skills to their CV.Entry Requirement<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">This course is available to all learners, of all academic backgrounds.</li><li fr-original-style="" style="box-sizing: border-box;">Learners should be aged 16 or over to undertake the lesson.</li><li fr-original-style="" style="box-sizing: border-box;">Good understanding of English language, numeracy and ICT are required to attend this course.</li></ul>Career pathThis acknowledged course is a stepping stone for HR expert to prepare for senior-level roles, and is also suited to those who are pursuing a career as an:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Human Resources Manager</li><li fr-original-style="" style="box-sizing: border-box;">Head of Talent</li><li fr-original-style="" style="box-sizing: border-box;">HR Director</li><li fr-original-style="" style="box-sizing: border-box;">HR Executive</li><li fr-original-style="" style="box-sizing: border-box;">HR Officer</li></ul>Certificate of AchievementEndorsed Certificate of Achievement from the Quality Licence SchemeOnce the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only &pound;99.00. Please note that overseas students may be charged an additional &pound;10 for postage.CPD Certificate of Achievement from JanetsUpon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of &pound;9.99 and PDF Certificate at &pound;4.99.EndorsementThis course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.Method of AssessmentTo successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement.To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support.Course Contents<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to Human Resources&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Employee Recruitment and Selection Procedure&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Employee Training and Development Process&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Performance Appraisal Management&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Employee Relations&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Motivation and Counselling&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Ensuring Health and safety at the Workplace&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Employee Termination&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Employer Records and Statistics&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Essential UK Employment Law</li></ul>

Janets

HR Management

HR (Human Resources)

HR Administrator

HR Manager

Discover the fundamentals of Basic Bookkeeping: From essential principles to practical techniques, learn how to manage finances effectively. Explore key concepts, tools, and strategies for maintaining accurate records and fostering financial stability in your business or personal finances.

General Admission

Welcome to Transaction Monitoring Masterclass: Detect Fraud &amp; Protect Your Business. In this course, you&#39;ll learn: <ol style="color: rgb(209, 213, 219); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(209, 213, 219);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Introduction to Transaction Monitoring:<ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Overview of transaction monitoring and its significance in modern business.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understanding the impact of fraud on businesses and the economy.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Case studies illustrating the consequences of inadequate transaction monitoring.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Regulatory Framework and Risk-Based Approach:<ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Examination of global regulatory frameworks governing transaction monitoring.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Introduction to risk-based approaches for effective compliance.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Best practices in aligning transaction monitoring strategies with regulatory requirements.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Transaction Monitoring Systems and False Positives Reduction:<ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">In-depth exploration of transaction monitoring systems and technologies.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Strategies to enhance the efficiency of monitoring systems.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Techniques for reducing false positives and optimizing alert investigations.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Red Flags and SAR (Suspicious Activity Reports):<ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Identification of red flags indicating potential fraudulent activities.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Hands-on exercises to recognize and analyze suspicious transactions.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Comprehensive guidance on preparing and filing Suspicious Activity Reports (SARs).</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Terrorism Financing, Name Screening, and Record-Keeping:<ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Analysis of the role of transaction monitoring in detecting terrorism financing.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Best practices for name screening to prevent transactions with high-risk entities.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Importance of meticulous record-keeping for regulatory compliance and investigations.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Future of Transaction Monitoring:<ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Exploration of emerging technologies in transaction monitoring.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Predictive analytics and artificial intelligence in fraud detection.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Adapting to evolving regulatory landscapes and emerging threats.</li></ul></li></ol>

John Academy

Master the art of safeguarding your business with our Transaction Monitoring Masterclass. Detect and prevent fraud effectively through in-depth exploration of regulatory frameworks, risk-based approaches, advanced monitoring systems, and the future of transaction security. Join us to acquire essential skills, reduce false positives, and stay ahead in the ever-evolving landscape of financial security. Protect your business with confidence. 

Transaction Monitoring Masterclass: Detect Fraud & Protect Your Business

Are you an aspiring professional who wants to build a career in the Travel And Tourism industry? Get a comprehensive understanding of how to give travel advice to clients and how to plan financially viable tour packages. Moreover, get insights into what factors affects the tourism industry. So, after ending this course, you will be equipped with the knowledge to provide the best travel advice and plan the most suitable tour packages for your own industry.This premium QLS endorsed Travel Agent and Consultant Training course comes with intensive study modules, dedicated tutor assistance, customer support, flexible learning opportunity and a globally recognised certification all-together. Thus, successful completion of our Travel Agent and Consultant Training course will give you limitless opportunities anywhere and everywhere, since the value of QLS endorsed courses are quite high, to say the least!!What's more, the quality of our first-class Travel Agents and Consultant Training course is uncompromising for both you and us. You will be taught the richest of materials from this exquisite Travel Agent and Consultant Training course, enabling you to open up a vast world of opportunities for you to grasp and gain success from. For the price point, this course is actually an absolute steal! It's an investment you absolutely do not want to miss out on!So, why delay any longer? Benefit your career progression by joining us today and distinguish yourself as, unquestionably, the most skilled one as travel agent and consultant in your workplace!Why Learn with us: We, as one of the leading e-learning service providers across the globe, strive to provide all our learners with the best e-learning experience possible that can make a real difference in their career progression.Our Service for the Travel Agent and Consultant Training Includes:<ul><li>Intensive Study Notes</li><li>Tutor Support</li><li>Customer Support</li><li>Assignment Help</li><li>QLS Endorsed Certificate</li><li>24/7 Learning Portal Access</li><li>Widely Compatible Study Materials</li></ul>Course Curriculum of Travel Agent and Consultant Training<ul><li>Module 01: Introduction to Travel and Tourism</li><li>Module 02: Tourism Products and Services</li><li>Module 03: Tour Operating and Travel Retailing</li><li>Module 04: Marketing in Travel and Tourism</li><li>Module 05: Developing Communication Skills</li><li>Module 06: Customer Service and Satisfaction</li><li>Module 07: Customer Relationship Management (CRM)</li><li>Module 08: Human Resource Management in Travel Industry</li><li>Module 09: Crisis and Visitor Attraction Management</li><li>Module 10: Transport Management Procedure</li><li>Module 11: Sustainable Tourism</li><li>Module 12: Public Awareness Campaigns</li><li>Module 13: Brexit and its Impact on Tourism Industry</li></ul>Assessment &amp; CertificationLearners must submit a comprehensive summarised assignment on all the units that will be assessed by our expert tutor if all the learning outcomes are met as per the standard set by QLS. After the quality check, learner will be provided with the Travel Agent and Consultant Training certificate.Endorsed Certificate of Achievement from the Quality Licence SchemeAn endorsed certificate will be issued to learners at the end of the course as recognition of course completion. Provided that learner completes all the assessment of a course can claim for certificate.Endorsement:QLS endorsed this certified Travel Agent and Consultant Training course as a highly qualified, non-regulated provision and training programme. There will be a trainer to answer all your questions including your progression routes into further higher education.<h2>
 
 <div>CPD</div>
 </h2>

 <div id="cpd">
 <div>
 <div>
 <div>
 10 CPD hours / points
 </div>
 <div>
 Accredited by CPD Quality Standards
 </div>
 </div>
 </div>
 </div><h2>
 
 <div>Who is this course for?</div>
 </h2>

 <div id="who_is_this_course_for">
 Our course is open for everyone. This Travel Agent and Consultant Training is ideal for those who aspire to gain in-depth knowledge &amp; efficient skill to embark into the relevant sector as a promising potential.
 </div><h2>
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 There are no formal requirements needed for this Travel Agent and Consultant Training course. So learners do not require any prior qualifications to enrol in this course.
 </div><h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 Level 5 Diploma in Travel Agent and Consultant Training qualification relates to the following job opportunities:<ol><li>Travel Consultant - £23,000 - £27,000</li><li>Reservations Supervisor/Tour Operator:£26,000 - £31,000</li><li>Travel Consultant -£23,000 - £27,000</li><li>Customer Service Representative - £21,500 - £23,000</li><li>Travel agency manager - £20,000 to £40,000</li></ol>
 </div>

Kingston Open College

NVQ Assessor

Certificate in Further Education & Training (Cert Ed)

Travel Agent

Certificate in Education & Training (CET)

Trainers Course

Vocational Training Charitable Trust (VTCT)

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Level 5 Diploma in Travel Agent and Consultant Training  - QLS Endorsed

Overview
2 day course on single name CDS, index CDS and index CDS options and how to use them to express views and hedge risks in credit markets

Who the course is for
Consultants
Analysts
Managers
C-Level executives
People in need of knowledge to develop a blockchain strategy
People working with blockchain projects
Regulators

Course Content
To learn more about the day by day course content please request a brochure
To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Finex Learning

Risk Management

Financial Derivatives

Finance

Financial Risk Management

Credit

Credit Default Swaps

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forStudents should have a fundamental understanding of financial principles and business operations. An understanding of cloud computing is helpful but isn't necessary.OverviewAfter completing this course, students will be able to: Describe the core capabilities of Dynamics 365 finance and operations apps Describe the capabilities and functionality of Dynamics 365 Finance Describe the capabilities and functionality of Dynamics 365 Supply Chain Management Describe the capabilities and functionality of Dynamics 365 Commerce Describe the capabilities and functionality of Dynamics 365 Human Resources Describe the capabilities and functionality of Dynamics 365 Project Operations (ERP)This course will provide you with a broad introduction to the finance and operations capabilities of Dynamics 365. You will become familiar with the concept of enterprise resource management (ERP), as well as each of the finance and operations apps, including Dynamics 365 Supply Chain Management, Dynamics 365 Finance, Dynamics 365 Commerce , Dynamics 365 Human Resources, and the ERP capabilities of Dynamics 365 Project Operations. This course will include lecture as well as hands-on-labs. </div><div id="course-pills-2"><h4>Module 1: Explore the core capabilities of Dynamics 365 finance and operations apps</h4><ul><li>Get introduced to the finance and operations apps</li><li>Create reports and integrate finance and operations apps</li></ul><h4>Module 2: Learn the fundamentals of Dynamics 365 Finance</h4><ul><li>Explore Dynamics 365 Finance core capabilities</li><li>Explore general ledger</li><li>Explore accounts payable and accounts receivable</li><li>Explore expense management, fixed asset management, and budgeting</li></ul><h4>Module 3: Learn the fundamentals of Dynamics 365 Supply Chain Management</h4><ul><li>Identify general capabilities of Dynamics 365 Supply Chain Management</li><li>Explore warehouse and inventory capabilities</li><li>Explore manufacturing strategies in Dynamics 365 Supply Chain Management</li></ul><h4>Module 4: Learn the fundamentals of Dynamics 365 Commerce</h4><ul><li>Explore Dynamics 365 Commerce capabilities</li><li>Explore Microsoft Dynamics 365 B2B e-commerce, Store Commerce and Clienteling</li></ul><h4>Module 5: Learn the fundamentals of Dynamics 365 Human Resources</h4><ul><li>Explore Dynamics 365 Human Resources core capabilities</li><li>Explore personnel management capabilities in Dynamics 365 Human Resources</li></ul><h4>Module 6: Learn the fundamentals of Dynamics 365 Project Operations</h4><ul><li>Identify project life cycle management capabilities in Dynamics 365 Project Operations</li><li>Explore the project planning and execution capabilities of 365 Project Operations</li></ul></div>

Nexus Human

Microsoft 365

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-303

Microsoft AZ-700

Microsoft Dynamics

MB-920T00 Microsoft Dynamics 365 Fundamentals (ERP)

London

<h2 fr-original-style="" style="box-sizing: border-box;">Sage Line 50 Accounting / Bookkeeping Training - Fast Track</h2>
If you&#39;re looking to gain competency in the world&#39;s most popular bookkeeping software, the Sage 50 Computerised Accounting course will teach everything you need to know, while helping you gain a recognised qualification. This Course is designed to provide individuals from beginner to advanced knowledge of bookkeeping and Sage 50 accounts. It is intended for individuals who aim to improve career prospects and to be able to better financial management and control of business. This course covers Level 1-3 of Sage 50 Bookkeeping/Accounting Training.
Every business, no matter how large or small, is required by law to &#39;keep books&#39;. Therefore, Bookkeepers play a vital role within organisations; ensuring records of individual financial transactions are accurate, orderly, up to date and comprehensive.
If you are organised and methodical, like working through documents and enjoy seeing a set of figures add up properly, then bookkeeping is the career for you.<h3 fr-original-style="" style="box-sizing: border-box;">What qualification will I gain?</h3>
You have the choice to gain certification from one of the following awarding bodies.
CERTIFICATION FROM SAGE (UK)
As Osborne Training is a Sage (UK) Approved training provider, you could gain the following qualifications provided that you book and register for exams and pass the exams successfully:
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Sage 50c Computerised Accounting Course (Level 1)</li>
<li fr-original-style="" style="box-sizing: border-box;">Sage 50c Computerised Accounting Course (Level 2)</li>
<li fr-original-style="" style="box-sizing: border-box;">Sage 50c Computerised Accounting Course (Level 3)</li>
</ul><section fr-original-style="" style="box-sizing: border-box;">
 <h3 fr-original-style="" style="box-sizing: border-box;">Level 1</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Working with Sage 50 Accounts Program Basics.</li><li fr-original-style="" style="box-sizing: border-box;">Creating Account names, Numbers &amp; Bank Payments</li><li fr-original-style="" style="box-sizing: border-box;">Financials</li><li fr-original-style="" style="box-sizing: border-box;">Bank Reconciliations</li><li fr-original-style="" style="box-sizing: border-box;">Generating Customers Invoices</li><li fr-original-style="" style="box-sizing: border-box;">Monitoring Customer Activity</li><li fr-original-style="" style="box-sizing: border-box;">Generating Product Invoices &amp; Credit Notes</li><li fr-original-style="" style="box-sizing: border-box;">Compiling &amp; Sending Customer Statements</li><li fr-original-style="" style="box-sizing: border-box;">Creating Customer Receipts &amp; Purchase Invoices</li><li fr-original-style="" style="box-sizing: border-box;">Supplier Payments</li><li fr-original-style="" style="box-sizing: border-box;">Managing Recurring Entries</li><li fr-original-style="" style="box-sizing: border-box;">Generating Reports &amp; Information</li><li fr-original-style="" style="box-sizing: border-box;">The Active Set-Up Wizard</li><li fr-original-style="" style="box-sizing: border-box;">VAT Changes.</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Level 2</h2><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An overview of the Sage program</li><li fr-original-style="" style="box-sizing: border-box;">Entering opening balances, preparing and printing a trial balance</li><li fr-original-style="" style="box-sizing: border-box;">Creating customer records</li><li fr-original-style="" style="box-sizing: border-box;">Creating supplier records</li><li fr-original-style="" style="box-sizing: border-box;">Setting up opening assets, liabilities and capital balances,</li><li fr-original-style="" style="box-sizing: border-box;">Producing routine reports</li><li fr-original-style="" style="box-sizing: border-box;">Checking data,</li><li fr-original-style="" style="box-sizing: border-box;">Entering supplier invoices</li><li fr-original-style="" style="box-sizing: border-box;">Posting error corrections, amending records</li><li fr-original-style="" style="box-sizing: border-box;">Invoicing, generating customer letters, entering new products, checking communication history</li><li fr-original-style="" style="box-sizing: border-box;">Banking and payments, producing statements, petty cash</li><li fr-original-style="" style="box-sizing: border-box;">Audit trails, correcting basic entry errors, reconciling debtors and creditors</li><li fr-original-style="" style="box-sizing: border-box;">Creating sales credit notes,</li><li fr-original-style="" style="box-sizing: border-box;">Processing purchase credit notes</li><li fr-original-style="" style="box-sizing: border-box;">Preparing journals</li><li fr-original-style="" style="box-sizing: border-box;">Verifying Audit Trail</li><li fr-original-style="" style="box-sizing: border-box;">Purchase orders, processing sales orders</li><li fr-original-style="" style="box-sizing: border-box;">Processing Trial Balance</li><li fr-original-style="" style="box-sizing: border-box;">Creating Backups</li><li fr-original-style="" style="box-sizing: border-box;">Restoring data</li><li fr-original-style="" style="box-sizing: border-box;">Writing-off bad debts</li></ul><h3 fr-original-style="" style="box-sizing: border-box;">Level 3</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Creating a Chart of Accounts to Suit Company Requirements</li><li fr-original-style="" style="box-sizing: border-box;">Sole Trader Accounts preparation</li><li fr-original-style="" style="box-sizing: border-box;">The Trial Balance preparation</li><li fr-original-style="" style="box-sizing: border-box;">Errors in the Trial Balance</li><li fr-original-style="" style="box-sizing: border-box;">Disputed Items</li><li fr-original-style="" style="box-sizing: border-box;">Use of the Journal</li><li fr-original-style="" style="box-sizing: border-box;">Prepare and Process Month End Routine</li><li fr-original-style="" style="box-sizing: border-box;">Contra Entries</li><li fr-original-style="" style="box-sizing: border-box;">The Government Gateway and VAT Returns</li><li fr-original-style="" style="box-sizing: border-box;">Bad Debts and Provision for Doubtful Debts</li><li fr-original-style="" style="box-sizing: border-box;">Prepare and Produce Final Accounts</li><li fr-original-style="" style="box-sizing: border-box;">Management Information Reports</li><li fr-original-style="" style="box-sizing: border-box;">Making Decisions with Reports Using Sage</li><li fr-original-style="" style="box-sizing: border-box;">The Fixed Asset Register and Depreciation</li><li fr-original-style="" style="box-sizing: border-box;">Accruals and Prepayments</li><li fr-original-style="" style="box-sizing: border-box;">Cash Flow and Forecast Reports</li><li fr-original-style="" style="box-sizing: border-box;">Advanced Credit Control</li></ul>


 </section>

Osborne Training

Sage Line 50 Accounting / Bookkeeping Training - Fast Track

Are you ready to embark on an enlightening journey of wisdom with the Business Development bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Business Development, Leadership &amp; Business Studies.Delve into eight immersive CPD Accredited courses, each a standalone course:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Course 01: Business Development Fundementals: Lean Strategies for Business</li><li fr-original-style="" style="box-sizing: border-box;">Course 02: Strategic Business Management - Online Diploma Course</li><li fr-original-style="" style="box-sizing: border-box;">Course 03: Business Law 2021</li><li fr-original-style="" style="box-sizing: border-box;">Course 04: Business Studies</li><li fr-original-style="" style="box-sizing: border-box;">Course 05: Business Analysis Course Level 5</li><li fr-original-style="" style="box-sizing: border-box;">Course 06: Leadership and Management Course</li><li fr-original-style="" style="box-sizing: border-box;">Course 07: Accounting and Finance</li><li fr-original-style="" style="box-sizing: border-box;">Course 08: Risk Assessment &amp; Management Diploma</li></ul>Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Business Development, Leadership &amp; Business Studies bundle illuminate your path to wisdom.The Business Development, Leadership &amp; Business Studies bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace.In the framework of the Business Development, Leadership &amp; Business Studies package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Business Development bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement!So, don&#39;t wait further and join the Business Development, Leadership &amp; Business Studies community today and let your voyage of discovery begin!Learning Outcomes:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Attain a holistic understanding in the designated areas of study with the Business Development bundle.</li><li fr-original-style="" style="box-sizing: border-box;">Establish robust bases across each course nestled within the Business Development bundle.</li><li fr-original-style="" style="box-sizing: border-box;">Decipher intricate concepts through the articulate content of the Business Development bundle.</li><li fr-original-style="" style="box-sizing: border-box;">Amplify your prowess in interpreting, scrutinising, and implementing theories.</li><li fr-original-style="" style="box-sizing: border-box;">Procure the capacity to engage with the course material on an intellectual and profound level.</li><li fr-original-style="" style="box-sizing: border-box;">Become proficient in the art of problem-solving across various disciplines.</li></ul>Stepping into the Business Development bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge.The Business Development bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Business Development bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world.The Business Development bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Business Development bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Business Development journey and let knowledge guide you towards a brighter future.<h2 fr-original-style="" style="box-sizing: border-box;">
 
 <div fr-original-style="" style="box-sizing: border-box;">CPD</div>
 </h2>

 <div id="cpd" fr-original-style="" style="box-sizing: border-box;">
 <div fr-original-style="" style="box-sizing: border-box;">
 <div fr-original-style="" style="box-sizing: border-box;">
 <div fr-original-style="" style="box-sizing: border-box;">
 80 CPD hours / points
 </div>
 <div fr-original-style="" style="box-sizing: border-box;">
 Accredited by CPD Quality Standards
 </div>
 </div>
 </div>
 </div><h2 fr-original-style="" style="box-sizing: border-box;">
 
 <div fr-original-style="" style="box-sizing: border-box;">Who is this course for?</div>
 </h2>

 <div id="who_is_this_course_for" fr-original-style="" style="box-sizing: border-box;">
 <ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Individuals keen on deepening their firm understanding in the respective fields.</li><li fr-original-style="" style="box-sizing: border-box;">Students pursuing higher education looking for comprehensive theory modules.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals seeking to refresh or enhance their knowledge.</li><li fr-original-style="" style="box-sizing: border-box;">Anyone with a thirst for knowledge and a passion for continuous learning.</li></ul>
 </div><h2 fr-original-style="" style="box-sizing: border-box;">
 
 <div fr-original-style="" style="box-sizing: border-box;">Career path</div>
 </h2>

 <div id="career_path" fr-original-style="" style="box-sizing: border-box;">
 Armed with the Business Development bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it&#39;s academic research, consultancy, or programme management, the Business Development bundle lays a solid groundwork.
 </div><h2 fr-original-style="" style="box-sizing: border-box;">
 
 <div fr-original-style="" style="box-sizing: border-box;">Certificates</div>
 </h2>

 <div id="optional_extras" fr-original-style="" style="box-sizing: border-box;">
 <h4 fr-original-style="" style="box-sizing: border-box;">CPD Certificate Of Completion</h4>
 
 Digital certificate -
 Included
 
 <div fr-original-style="" style="box-sizing: border-box;">8 Digital Certificates Are Included With This Bundle</div>
 <h4 fr-original-style="" style="box-sizing: border-box;">CPD Quality Standard Hardcopy Certificate (FREE UK Delivery)</h4>
 
 Hard copy certificate -
 &pound;9.99
 
 <div fr-original-style="" style="box-sizing: border-box;">Hard copy Transcript - &pound;9.99</div>

 </div>

NextGen Learning

Learning & Development

Business Leadership

Business Studies

Professional Development

Corporate Learning & Development

Continuous Professional Development (CPD)

Business Development, Leadership & Business Studies - 8 Courses Bundle

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course

<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<section fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">Course OverviewLearn the Latest Skills | Accredited by CPD | Recognised Certificate | MCQ Based Exam &amp; Tutor Support | Interactive Video Training&nbsp;A career in hairdressing may be the appropriate choice for you if you have imagination, flair, attention to detail, and a desire to provide exceptional customer service. You will study various essential hairdressing skills and methods, such as health and safety, client counselling, and communication.&nbsp;This training course is jam-packed with hairstyling tips and tricks, as well as the principles of head shapes and the required tools. It introduces pupils to various hair-cutting methods using a multimedia approach. It also discusses braiding and style techniques and explains how to use aesthetic shapes to enhance a client&rsquo;s attributes.What Will You Learn?<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Principles and practice of hairdressing</li><li fr-original-style="" style="box-sizing: border-box;">Shampoo, condition and treat the hair and scalp</li><li fr-original-style="" style="box-sizing: border-box;">Style, set and finish the hair</li><li fr-original-style="" style="box-sizing: border-box;">Plait, braid and twist hair</li><li fr-original-style="" style="box-sizing: border-box;">Learn about hair type, face shape and style concepts</li></ul>What classes are included in this package?<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Earn a digital Certificate upon successful completion accredited by UK and internationally recognised accredited qualification</li><li fr-original-style="" style="box-sizing: border-box;">There are no set schedules, so you can work at your own pace.</li><li fr-original-style="" style="box-sizing: border-box;">Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week.</li><li fr-original-style="" style="box-sizing: border-box;">On weekdays, you&rsquo;ll have access to a full-time tutor.</li><li fr-original-style="" style="box-sizing: border-box;">Learn in a user-friendly, cutting-edge online learning environment.</li><li fr-original-style="" style="box-sizing: border-box;">High-quality e-learning study materials</li><li fr-original-style="" style="box-sizing: border-box;">Benefit from instant feedback through mock exams and multiple-choice assessments</li></ul>Who Should Take This Course?Hairdressing and Barbering is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It&rsquo;s also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. &nbsp;&nbsp;Career PathTraining offered by Hairdressing And Barbering could potentially benefit a range of roles, but would particularly enhance careers in:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Hairdresser</li><li fr-original-style="" style="box-sizing: border-box;">Hair Stylist</li><li fr-original-style="" style="box-sizing: border-box;">Salon Owner</li><li fr-original-style="" style="box-sizing: border-box;">Makeup Artist</li><li fr-original-style="" style="box-sizing: border-box;">Salon Manager</li><li fr-original-style="" style="box-sizing: border-box;">Colourist</li></ul>Course DesignThe course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.You are taught through a combination of<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Video lessons</li><li fr-original-style="" style="box-sizing: border-box;">Online study materials</li><li fr-original-style="" style="box-sizing: border-box;">Mock exams</li><li fr-original-style="" style="box-sizing: border-box;">Multiple-choice assessments</li><li fr-original-style="" style="box-sizing: border-box;">Assignment</li></ul>Certificate of AchievementAfter the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for &pound;9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for &pound;15.99, which will reach your doorsteps by post.Retake feeIf you do not pass the exam first time, you can purchase the Retake Exam for &pound;1.99 and try again.Course ContentsIntroduction<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Tools&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Social aspect of the business part one&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Social aspect of the business part two&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to interact with the clients&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Negotiating and dealing with the financial aspect of the business&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Dealing with you coworkers the problem that you might face&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li></ul>Technical skills<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consultation&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">After the consultation&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Clipper work 1&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Clipper work 2&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Clipper work 3&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Clipper work 4&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Scissor work&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Scissor work 2&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Beard work 1&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Beard work 2&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Conclusion and end of the course</li></ul></div></div></div></div></div></div></div></section></div></div></div>

Barbering

Hair

Hairdressing

Hair Stylist

Hairdressing and Barbering

Data Protection

GDPR

Data Protection Officer

Certified in Data Protection (CDP)

Graduate Diploma in Law (GDL)

GDPR : Data Protection, Rights and Breaches

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

dbrownconsulting

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

Advanced Financial Modeler Certificate Course - Oil & Gas

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

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

DG Legal

Navigating The UK Sanctions Compliance As A Law Firm Course

General Delegate

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

Retainer Delegate

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

Operations Management

Certified Facility Manager (CFM)

Construction Design & Management (CDM)

Commercial & Contract Management Certification Program (CCM)

Facility Management

Operations Manager

Certified Data Center Facilities Operations Manager (CDFOM)

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

Financial Modelling & Analysis

Financial Modelling

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

Advanced Financial Modeler Certificate Course

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

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



Brightcore Consultancy

Mental Health

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

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

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



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


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


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


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


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


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


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


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


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


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


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

Bayfield Training

Real Estate Finance

Microsoft Excel

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

Real Estate Financial Modelling School

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



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


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


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


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


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


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


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

Property & Real Estate Photography

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

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



A real estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.
This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector. The training aims to give delegates a grasp of MS Excel and its usage in real estate cash flow modelling. You will be able to set up a financial modelling cash flow from a blank spreadsheet by using the most common shortcuts, formulas and functions. We will also cover the use of pivot tables to clean and organise your data.
This is an excellent starter/refresher course, whether you’re a recent graduate or a mid/senior professional.


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


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


Day One:


Conventional Valuations
Term & Reversion
Layer Method
Over Rented
Equivalent Yield


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


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


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


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

Financial Analysis

Financial Management

This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector.

An Introduction to Real Estate in Excel (Financial Modelling)

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



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


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


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


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


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


Quizzes | Q&A


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


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

Property Investment

Investment

Investment Management

On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. 

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

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





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


Pre-requisite:
Completion of the Real Estate Analyst Course


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


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


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


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


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


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

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

5070 Courses delivered Online

HR Management

By Janets

Transaction Monitoring Masterclass: Detect Fraud & Protect Your Business

By John Academy

Level 5 Diploma in Travel Agent and Consultant Training - QLS Endorsed

By Kingston Open College

Credit Default Swaps

By Finex Learning

MB-920T00 Microsoft Dynamics 365 Fundamentals (ERP)

By Nexus Human

Sage Line 50 Accounting / Bookkeeping Training - Fast Track

By Osborne Training

Business Development, Leadership & Business Studies - 8 Courses Bundle

By NextGen Learning

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course

By NextGen Learning

Hairdressing and Barbering

By Janets

GDPR : Data Protection, Rights and Breaches

By NextGen Learning