Name: Managing Successful Programmes 5th Edition Foundation: In-House
Price: 1995 GBP
Availability: InStock

Birmingham

Lancaster

London

Manchester

<h2 data-mce-fragment="1" style="color: rgb(var(--color-foreground)); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color-foreground));">Summary</h2><p data-mce-fragment="1" style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This qualification is designed for those new to running or looking to run, licensed retail premises.</p><p data-mce-fragment="1" style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">Covers the areas of management responsibility that are essential to run a licensed retail business successfully. These include stock control, employment law, financial management, marketing and merchandising, staff recruitment &amp; training.</p><p data-mce-fragment="1" style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><strong data-mce-fragment="1" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The ALHO Award in Licensed Hospitality Operations is a three-day course or 30 guided learning hours.</strong></p><p data-mce-fragment="1" style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><strong data-mce-fragment="1" fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong data-mce-fragment="1" style="color: rgba(18, 18, 18, 0.75); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">This course can also be delivered online.</strong><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgba(18, 18, 18, 0.75);">What does the Award in Licensed Hospitality Operations course comprise of?</p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);">The qualification consists of 12 sections:</p><p style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><br fr-original-style="" style="box-sizing: border-box;"></p><ul style="color: rgba(18, 18, 18, 0.75); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><li fr-original-style="" style="box-sizing: border-box;">Cash security and stock control</li><li fr-original-style="" style="box-sizing: border-box;">Catering</li><li fr-original-style="" style="box-sizing: border-box;">Customer service</li><li fr-original-style="" style="box-sizing: border-box;">Employment law</li><li fr-original-style="" style="box-sizing: border-box;">Financial management</li><li fr-original-style="" style="box-sizing: border-box;">Gaming and machine income</li><li fr-original-style="" style="box-sizing: border-box;">Health and safety at work</li><li fr-original-style="" style="box-sizing: border-box;">Recruitment, induction, and management of staff</li><li fr-original-style="" style="box-sizing: border-box;">Marketing and merchandising</li><li fr-original-style="" style="box-sizing: border-box;">Product knowledge &amp; preparation for service</li><li fr-original-style="" style="box-sizing: border-box;">Key legislation for retailing responsibly and trading within the law</li><li fr-original-style="" style="box-sizing: border-box;">Crime prevention.</li></ul><p data-mce-fragment="1" style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><strong data-mce-fragment="1" fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong data-mce-fragment="1" style="color: rgba(18, 18, 18, 0.75); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p data-mce-fragment="1" style="color: rgba(18, 18, 18, 0.75); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgba(18, 18, 18, 0.75);"><strong data-mce-fragment="1" fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

Knight Training (UK) Ltd

Retail Management

Alcohol Licensing

Bar Professional

Do you want to get some training in the hospitality sector?
We are waiting here for you in Knight Training, come to get your Award in Licensed Hospitality Operations now and train with us! 
This qualification is designed for those new to running or looking to run, licensed retail premises.
Don't waste any more time and give us a call on 0330 999 3199 to find more about it!

ALHO – Award in Licensed Hospitality Operations

General Admission

<div>
</div>
<section>
<div>
<h2>About this training course</h2>
<p>This 5-day intensive training course is designed to improve the skills of those involved in the financial and contractual auditing of upstream Oil &amp; Gas Exploration and Production activities. The objective of this course is to enhance your understanding of the various audit principles and practices being applied in this industry today and to equip you with the knowledge and tools to deal with complex audit cases. The course concentrates on aspects of auditing unique to the E&amp;P business.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>After the completion of this training course, participants will be able to:</p>
<ul>
<li>Apply a structured methodology for conducting oil industry internal, production sharing and joint venture audits</li>
<li>Implement the benefits of a multi-discipline team audit approach</li>
<li>Adopt a model of best practice for conducting audits</li>
<li>Analyse, interpret and decide complex cases using the contracts and documents, the principles and auditor's judgement</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This training course is suitable and will greatly benefit the following specific groups:</p>
<ul>
<li>Personnel with an Internal audit background who are totally new to the discipline of Joint Venture (JV) or Production Sharing Contract (PSC) audit</li>
<li>Experienced audit practitioners who wish to update their auditing techniques</li>
<li>Personnel from Finance or any discipline who intend to take part in <strong><em>internal or joint venture audits</em></strong></li>
<li>Personnel with a background in statutory audit in the accountancy profession who require an insight into the internal and joint venture audit areas</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Intermediate</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization.</span></p>
<p><em><span>Course Duration: 5 days in total (35 hours).</span></em></p>
<p><strong><span>Training Schedule</span></strong></p>
<p><span>0830 - Registration </span><span>0900 - Start of training </span><span>1030 - Morning Break </span><span>1045 - Training recommences </span><span>1230 - Lunch Break </span><span>1330 - Training recommences </span><span>1515 - Evening break </span><span>1530 - Training recommences </span><span>1700 - End of Training</span></p>
<p><span>The maximum number of participants allowed for this training course is 25.</span></p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries.</p>
<p>She has a Degree in Economics &amp; Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat<em>.</em></p>
<p><strong>Courses Delivered Internationally:</strong></p>
<ul>
<li>E&amp;P Accounting, Auditing in the Oil &amp; Gas Industry</li>
<li>Cost Control &amp; Budgeting</li>
<li>Introduction to the Oil &amp; Gas Industry</li>
<li>Petroleum Project Economics</li>
<li>Contracts Strategy</li>
<li>International O&amp;G Exploitation Contracts</li>
</ul>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Auditing in the Exploration & Production (E&P) Industry Level 2

Team of 10, pp

Normal Fee, pp

<div>
</div>
<section>
<div>
<h2>About this training course</h2>
<p>The aim of this exclusive 5-days training course is to raise an intermediate level to your knowledge and understanding of international E&amp;P finance and accounting. This is achieved by in-depth examination of international practices and current developments across a broad range of relevant topics. You are encouraged to challenge existing methods as a basis for reviewing procedures and introducing improvements in your own work place.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>After the completion of this training course, participants will be able to:</p>
<ul>
<li>Enhance your comprehension of accounting and reporting issues unique to the E&amp;P industry with emphasis on the application of International Financial Reporting Standards (IFRS)</li>
<li>Improve your understanding of the accounting and reporting of Sales Revenue, Farm In/Farm Out, and Carried Interest</li>
<li>Enhance your knowledge of Production Sharing Contracts and Joint Venture Accounting issues including Unitisation &amp; Redetermination</li>
<li>Advance your knowledge of the Corporate Budget and Planning process including a review of Key Performance Indicators and Company Strategy</li>
<li>Raise your awareness of the E&amp;P business activity for which we are accounting and reporting</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>We recommend that, to derive maximum benefit from this course, you should first attend our predecessor Level 1 course. Otherwise, this course is suitable for <strong><em>personnel with a good foundation knowledge in exploration and production accounting.</em></strong></p>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Intermediate</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization.</span></p>
<p><em><span>Course Duration: 5 days in total (35 hours).</span></em></p>
<p><strong><span>Training Schedule</span></strong></p>
<p><span>0830 - Registration </span><span>0900 - Start of training </span><span>1030 - Morning Break </span><span>1045 - Training recommences </span><span>1230 - Lunch Break </span><span>1330 - Training recommences </span><span>1515 - Evening break </span><span>1530 - Training recommences </span><span>1700 - End of Training</span></p>
<p><span>The maximum number of participants allowed for this training course is 25.</span></p>
<p><span>This course is also available through our Virtual Instructor Led Training (VILT) format.</span></p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries.</p>
<p>She has a Degree in Economics &amp; Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat<em>.</em></p>
<p><strong>Courses Delivered Internationally:</strong></p>
<ul>
<li>E&amp;P Accounting, Auditing in the Oil &amp; Gas Industry</li>
<li>Cost Control &amp; Budgeting</li>
<li>Introduction to the Oil &amp; Gas Industry</li>
<li>Petroleum Project Economics</li>
<li>Contracts Strategy</li>
<li>International O&amp;G Exploitation Contracts</li>
</ul>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

Exploration & Production (E&P) Accounting Level 2

<h2>Management of Risk (M_o_R®) Foundation: In-House Training</h2>
<p>This M_o_R® Foundation course prepares learners to demonstrate knowledge and comprehension of the four elements of the M_o_R framework: Principles, Approach, Processes, Embedding and Reviewing and how these elements support corporate governance. The M_o_R Foundation Course is also a prerequisite for the M_o_R Practitioner qualification.</p><h3>What you will Learn</h3>
<p>At the end of the M_o_R Foundation course, participants will gain competencies in and be able to:</p>
<ul>
<li>Describe the key characteristics of risk and the benefits of risk management</li>
<li>List the eight M_o_R Principles</li>
<li>List and describe the use of the key M_o_R Approach documents</li>
<li>Create Probability and Impact scales</li>
<li>Define and distinguish between risks and issues</li>
<li>Create a Risk Register</li>
<li>Create a Stakeholder map</li>
<li>Identify the key roles in risk management</li>
<li>Use the key techniques and describe specialisms in risk management</li>
<li>Undertake the M_o_R Foundation examination</li>
</ul><section>
                    <h3>Introduction</h3><ul><li>Introduction to the M_o_R course</li><li>What is a risk?</li><li>What is risk management?</li><li>Why is risk management so important?</li><li>Basic risk definitions</li><li>The development of knowledge about risk management</li><li>Corporate governance and internal control</li><li>Where and when should risk management be applied?</li></ul><h3>M_o_R Principles</h3><ul><li>The purpose of M_o_R principles</li><li>Aligns with objectives</li><li>Fits the context</li><li>Engages stakeholders</li><li>Provides clear guidance</li><li>Informs decision-making</li><li>Facilitates continual improvement</li><li>Creates a supportive culture</li><li>Achieves measurable value</li><li>Risk management maturity models</li></ul><h3>M_o_R Approach</h3><ul><li>Relationship between the documents</li><li>Risk management policy</li><li>Risk management process guide</li><li>Risk management strategy</li><li>Risk register</li><li>Issue register</li><li>Risk response plan</li><li>Risk improvement plan</li><li>Risk communications plan</li></ul><h3>M_o_R Process</h3><ul><li>Common process barriers</li><li>Identify  contexts</li><li>Identify  the risks</li><li>Assess  estimate</li><li>Assess  evaluate</li><li>Plan</li><li>Implement</li><li>Communication throughout the process</li></ul><h3>M_o_R Perspectives</h3><ul><li>Strategic perspective</li><li>Program perspective</li><li>Project perspective</li><li>Operational perspective</li></ul><h3>Risk Specialisms</h3><ul><li>Business continuity management</li><li>Incident and crisis management</li><li>Health and Safety management</li><li>Financial risk management</li><li>Environmental risk management</li><li>Reputational risk management</li><li>Contract risk management</li></ul>


                </section>

IIL Europe Ltd

Management of Risk (M_o_R) Foundation: In-House Training

<div>
</div>
<section>
<div>
<h2><strong>About this Virtual Instructor Led Training (VILT)</strong></h2>
<p><span>This 3 half-day Virtual Instructor Led Training (VILT) course highlights the impact of the introduction of renewable energy, digital technologies and new operational flexibility solutions in the electricity trading market. These advancements facilitate unique opportunities and challenges for cross border trading of electricity.</span></p>
<p><span>Most countries in Asia, have designed their own portfolio of climate actions with an accelerated penetration of renewable energy (or by importing renewable energy into their local grids). These changes are taking place at unprecedented speed and add further complexity to the operation of electricity trading markets, while presenting new opportunities.</span></p>
<p><span>The Asian market, can tap into its vast potential of solar, wind and geothermal energy sources. A global, unified vision is emerging to support each of countries' energy needs and decarbonization goals.</span></p>
<p><span>This VILT course will highlight priorities of each country to achieve its energy goals. The main operational flexibilities of each type of renewable resource are discussed in detail. The course also discusses the main components of Power Purchase Agreements and advancements in digitalization and how digital technologies can influence the energy market and cross border electricity trading.</span></p>
<p><strong><span>Key Takeaways:</span></strong></p>
<ol>
<li><span>New Energy Market Design</span></li>
<li><span>Cross Border Trading</span></li>
<li><span>PPAs Mechanisms and Examples of PPAs</span></li>
<li><span>The Increased Penetration of Renewable Resources in the Power Systems and How It Stimulates Cross Border Trading</span></li>
<li><span>How Digital Innovation Drives Energy Markets and Cross Border Trading</span></li>
</ol>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p><span>Upon completion of this VILT course, participants will be able to:</span></p>
<ul>
<li><span>Be familiar with the global vision of One Sun, One World, One Grid</span></li>
<li><span>Understand the major trends reshaping the energy markets</span></li>
<li><span>Learn how innovative digital technologies change the energy markets</span></li>
<li><span>Understand why sustainable energy markets require a tighter coordination between transmission and distribution system operators</span></li>
<li><span>Engage with each other to design the energy market of the future</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p><span>This VILT course will benefit <strong>policy makers and regulators from energy agencies, transmission companies and utilities as well as power system engineers and power system operators from control centre and ISO</strong>.</span></p>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>The VILT will be delivered online in 3 half-day sessions comprising 4 hours per day, including time for lectures, discussion, quizzes and short classroom exercises.</span></p>
<p>Course Duration: 3 half-day sessions, 4 hours per session (12 hours in total).</p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader <span>is a Utility Executive with extensive global experience in power system operation and planning, energy markets, enterprise risk and regulatory oversight. She consults on energy markets integrating renewable resources from planning to operation. She led complex projects in operations and conducted long term planning studies to support planning and operational reliability standards. Specializing in Smart Grids, Operational flexibilities, Renewable generation, Reliability, Financial Engineering, Energy Markets and Power System Integration, she was recently engaged by the Inter-American Development Bank/MHI in Guyana. She was the Operations Expert in the regulatory assessment in Oman. She is a registered member of the Professional Engineers of Ontario, Canada. She is also a contributing member to the IEEE Standards Association, WG Blockchain P2418.5.</span></p>
<p><span>With over 25 years with Ontario Power Generation (Revenue $1.2 Billion CAD, I/S 16 GW), she served as Canadian representative in CIGRE, committee member in NSERC (Natural Sciences and Engineering Research Council of Canada), and Senior Member IEEE and Elsevier since the 90ties. Our key expert chaired international conferences, lectured on several continents, published a book on Reliability and Security of Nuclear Power Plants, contributed to IEEE and PMAPS and published in the Ontario Journal for Public Policy, Canada. She delivered seminars organized by the Power Engineering Society, IEEE plus seminars to power companies worldwide, including Oman, Thailand, Saudi Arabia, Malaysia, Indonesia, Portugal, South Africa, Japan, Romania, and Guyana.</span></p>
<p><span>Our Key expert delivered over 60 specialized seminars to executives and engineers from Canada, Europe, South and North America, Middle East, South East Asia and Japan. Few examples are:</span></p>
<ul>
<li><span>Modern Power System in Digital Utilities - The Energy Commission, Malaysia and utilities in the Middle East, GCCIA, June 2020</span></li>
<li><span>Assessment of OETC Control Centre, Oman, December 2019</span></li>
<li><span>Demand Side management, Load Forecasting in a Smart Grid, Oman, 2019</span></li>
<li><span>Renewable Resources in a Smart Grid (Malaysia, Thailand, Indonesia, GCCIA, Saudi Arabia)</span></li>
<li><span>The Modern Power System: Impact of the Power Electronics on the Power System</span></li>
<li><span>The Digital Utility, AI and Blockchain</span></li>
<li><span>Smart Grid and Reliability of Distribution Systems, Cyme, Montreal, Canada</span></li>
<li><span>Economic Dispatch in the context of an Energy Market (TNB, Sarawak Energy, Malaysia)</span></li>
<li><span>Energy Markets, Risk Assessment and Financial Management, PES, IEEE: Chicago, San Francisco, New York, Portugal, South Africa, Japan. Provided training at CEO and CRO level.</span></li>
<li><span>Enterprise Risk methodology, EDP, Portugal</span></li>
<li><span>Energy Markets: Saudi Electricity Company, Tenaga National Berhad, Malaysia</span></li>
<li><span>Reliability Centre Maintenance (South East Asia, Saudi Electricity Company, KSA)</span></li>
<li><span>EUSN, ENERGY &amp; UTILITIES SECTOR NETWORK, Government of Canada, 2016</span></li>
<li><span>Connected+, IOT, Toronto, Canada September 2016 and 2015</span></li>
<li><span>Smart Grid, Smart Home HomeConnect, Toronto, Canada November 2014</span></li>
<li><span>Wind Power: a Cautionary Tale, Ontario Centre for Public Policy, 2010</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br />
Request for further information about post training coaching support and fees applicable for this.</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

Cross Border Electricity Trading in Asia - Renewable Energy, Digital Technologies and New Operational Flexibility Solutions

Harpenden

<p>What do engineers and project managers need to know of finance? 'Nothing - leave it to the accountants!'</p><p>No, no, no! Engineers must be conversant with the terminology and statements that accountants use. Technical expertise in projects, service delivery, production or other areas can only really be harnessed if the managers understand the accounting and reporting that drives businesses.</p><p>This course gives the necessary understanding to project, production and technical managers. It develops their skills in understanding financial and management accounting.</p><p>Accountants may not always like it but a major part of their work is to be the 'servants of business' and to gather, compile and present your figures. So you must understand the figures - they belong to you, your processes or projects. There are many reasons for maintaining accurate accounts. This course focuses on the strategic issues (those over-used words) - what figures reveal about the drivers of business and what they reveal about the day-to-day issues that accountants bother you with. The course will enhance your understanding of finance and of the accounting issues which affect your projects, production and technical areas of business.</p>This course will help you:<ul><li>Understand the business world in figures - make sense of what the accountants are telling you</li><li>Appreciate what drives business - and how this affects your role in your part of the business</li><li>Relate your activities to the success of the business - through figures</li><li>Gain the skills to advance in management - financial awareness is a 'must have' if you are to progress in your career</li></ul><section>
                    <h3>1 What do accountants do?</h3><ul><li>The finance function, types of accountant, financial v management accounting and the treasury function</li><li>Understanding the role of the finance function and how the information you provide may be used</li></ul> <h3>2 The basic financial statements</h3><ul><li>Balance sheets and income statements (P&amp;L accounts)</li><li>What they are, what they contain and above all what they can reveal - how to read them</li><li>The accounting process - from transactions to financial statements</li><li>What underpins the statements - accounting systems and internal controls</li></ul> <h3>3 Why be in business - from a financial perspective</h3><ul><li>The driving forces behind financial information</li><li>Performance measures - profitability, asset utilisation, sales and throughput, managing capital expenditure</li></ul> <h3>4 Accounting rules - accounting standards</h3><ul><li>Accounting concepts and the accounting rules: accruals, 'going concern' - substance over form and other 'desirable qualities'</li><li>Accruals - why the timing of a transaction is so important to the finance function</li><li>Depreciation and amortisation - the concepts and practice</li><li>Accounting standards - the role of International Financial Reporting Standards</li></ul> <h3>5 Cash</h3><ul><li>The importance of cash flow - working capital management</li><li>Cash flow statements - monitoring overall cash flows</li><li>Raising cash - levels of borrowing, gearing</li><li>Spending cash - an outline of capital expenditure appraisal</li></ul> <h3>6 Budgeting</h3><ul><li>Why budget? - good and bad practice</li><li>Determining why budgets play a key role and should not be simply an annual ritual</li><li>Justifying your budgets - the link between the strategic plan and day-to-day budgeting - alignment of company culture</li><li>Budgets as motivators - the importance of the right culture</li><li>Techniques to improve budgeting - whether day-to-day or capital budgeting</li></ul> <h3>7 Costing</h3><ul><li>The type and detail of costing very much depends on your business - eg, manufacturing piston rings is quite different from the construction of a power plant</li><li>Issues with overhead allocation</li><li>Accounting for R&amp;D</li></ul> <h3>8 Reading financial statements</h3><ul><li>Annual financial statements - why they are produced, what's in them and what you should look for</li><li>Learning what a set of accounts reveals about a company's current situation, profitability and future prospects</li></ul> <h3>9 Performance measurement - analytical reviews and ratio analysis</h3><ul><li>ROI/ROCE</li><li>Profitability, margins and cost control</li><li>Sales - asset turnover</li><li>Efficiency (asset / stock turnover, debtor / creditor days)</li><li>'City' measures</li><li>Investment (interest / dividend cover, earnings per share, dividend yield)</li></ul> 


                </section>

The In House Training Company

Accounting & Finance

Business Accounting

Corporate Finance Level 1

Finance For Non Finance Managers

Financial Accounting

Practical Accounting

Finance for project managers and engineers (In-House)

<h2>Developing the Business Case: In-House Training</h2>
 <p>Business analysts must be able to create business case documents that highlight project benefits, costs, and risks. The business case is based on the real business need to be solved. These become parts of proposals, feasibility studies, and other decision support documents. This course teaches the purpose, structure, and content of a business case. It presents the basic techniques for determining financial ROI, non-tangible benefits, and the probability of meeting expectations.</p><h3>What you will Learn</h3>
 <p>At the end of this program, you will be able to:</p>
 <ul>
 <li>Perform feasibility studies</li>
 <li>Justify the business investment to solve the business problem</li>
 <li>Prepare an effective business case document</li>
 <li>Plan and implement a business case approval process</li>
 </ul><section>
                    <h3>Foundation Concepts</h3> <ul> <li>The role of the BA</li> <li>An introduction to the <em>BABOK® Guide</em></li> <li>The business analyst and the product / project life cycle (PLC)</li> <li>The business case deliverable</li> </ul> <h3>Introducing the Business Case Process</h3> <ul> <li>The BA and strategy analysis</li> <li>The BA and the business case process (BCP)</li> <li>The BA during the business case process (BCP)</li> <li>The BA after the business case process (BCP)</li> <li>Importance of defining solution performance metrics</li> </ul> <h3>Defining the Business Need</h3> <ul> <li>Overview of defining the business need</li> <li>Business needs: problem / opportunity statement</li> <li>Product vision</li> <li>Objectives and constraints</li> </ul> <h3>Exploring Business Case Solutions</h3> <ul> <li>Overview of exploring solutions</li> <li>Solution identification for feasibility</li> <li>Solution definition for analysis</li> <li>Assessing project risks</li> </ul> <h3>Justifying the Business Case</h3> <ul> <li>Overview of justifying the business case</li> <li>Qualitative justification</li> <li>Quantitative justification</li> </ul> <h3>Approving the Business Case</h3> <ul> <li>Overview of business case approval</li> <li>Developing recommendations</li> <li>Preparing the decision package - documents</li> <li>Preparing the decision package - presentations</li> </ul>


                </section>

Developing the Business Case: In-House Training

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>One of the main challenges for today's managers is effectively leading and successfully communicating vision that inspires employees to perform. Good leadership engages people and employees who feel both engaged and enabled contribute to higher levels of growth and productivity. They will remain longer with the organisation, perform better and ultimately deliver better service to your customers.</p>
<p>This popular 3 full-day course will equip you with key skills that you can utilise to maximise your staff's performance in line with the company's objectives.</p>
<p>This interactive course will also empower you with strategic approaches to overcome the people challenges that you may encounter while enabling you to optimise your business strategies successfully.</p>
<figure></figure>
<p>An ILM Recognised programme.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p><strong>What are the benefits that you will gain from attending this course?</strong> * Enhance your personal effectiveness and decision-making * Learn how to boost your influencing capability * Inspire enthusiasm, motivation and commitment * Communicate effectively across a multi-cultural team * Nurture your relationships and strengthen your team * Develop an empowering partnership team culture</p>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p><strong>Who should attend this course?</strong> Anyone involved in leading a business unit or a project team can attend. It covers relationships with host governments, contractors, suppliers and local communities which constitute critical alliances for the development of a project. <strong>This course is essential for team leaders, supervisors or managers from the following functions:</strong></p>
<ul>
<li>Project management engineers from various technical disciplines</li>
<li>Ad-hoc or special project team leaders in legal, technical &amp; financial disciplines</li>
<li>Country managers or business development officers of contractors</li>
<li>JV management executives or officers</li>
<li>Government officials or industry liaison officers</li>
<li>Procurement or contracts executives or officers</li>
</ul>
<p> </p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your course leader is the author of Spirit IntelligenceTM and specialises in executive leadership facilitation and management development. He gained a first class honours degree in chemical engineering from Edinburgh University in Scotland and has undertaken postgraduate studies in psychology at Macquarie University in Sydney, Australia. Your course leader's corporate career spanned 14 years in Oil and Gas with BP, Amoco and AGL. Since 1993, he has worked across five continents with more than 170 clients including Rothschild, QBE, AT&amp;T, Intel, Towers Perrin, Thomas Cook, Fujitsu, Nortel, Frank Russell, Electrolux, Arab Bank, Cable and Wireless, GSK, Merck, Sharpe and Dome, World Vision, Ericsson, IBM, Placer Dome Gold, Jim Beam, Ernst &amp; Young and Commonwealth Bank of Australia. He focuses on what he calls tapping The Hidden Advantage to unleash the power of the whole person - the power of the body and mind, the passion of the emotions and the enthusiasm, motivation, commitment, initiative, creativity, resilience and persistence of the spirit in business.</p>
<p>He is very experienced internationally in both skills enhancement and the strategic facilitation of tough and intractable client challenges. His approach is pragmatic. He provides his clients with a powerful range of practical tools and approaches to enable management to tap The Hidden Advantage latent in their staff and achieve optimum performance and results. A powerful and compelling speaker, he combines humour, energy and passion. He draws on a wealth of personal experience and thorough research.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

Leadership & Team Dynamics in Oil & Gas

<div>
</div>
<section>
<div>
<h2><strong>About this Course</strong></h2>
<p>Batteries are going to play an increasingly important role in the energy grid. An increasing number of developers are looking to add battery storage systems (BESS) into their existing projects. However future cash flows are highly uncertain and they are often unsure exactly how battery technology can be monetised. A strong revenue model requires stacking of different revenue sources.</p>
<p>As the share of variable renewable sources in electricity systems further increase, battery systems are expected to play a growing role by providing frequency control and operational reserves as well as for wholesale arbitrage, while helping reduce grid integration costs. The more volatile electricity prices are, the greater the earning potential of batteries trading electricity on various electricity markets.</p>
<p>BESS can generate revenue streams in several different ways; through a frequency response contract with the TSO, by providing grid services in other ways or by arbitrage through buying cheap power and selling power for a higher price in a liquid wholesale market.</p>
<p>Because batteries are efficient, the round trip efficiency is also high. They can spread arbitrage trading much better than other storage types and in many cases, other asset classes.</p>
<p>For companies that combine a battery with other tasks, for example to store power from their own panels, or to avoid a costly heavy power connection, the investment is less risky than for those that purely focus on arbitrage trading. It is uncertain whether electricity prices will fluctuate more violently in the coming years, or whether the peaks will actually level off.</p>
<p>During this highly interactive training, the trainer will provide you with the latest insights and best practices on how to obtain the maximum economic beneï¬ts when participating with BESS in the electricity market.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p><span>By the end of this course, the participants will be able to:</span></p>
<ul>
<li><span>Discover the different BESS battery technologies and their impact on the grid</span></li>
<li><span>Understand the role of storage in providing flexibility to the power system</span></li>
<li><span>Examine the potential revenue streams from BESS models</span></li>
<li><span>Learn how profit can generated with BESS trading strategies</span></li>
<li><span>Determine how to optimize the value from BESS projects</span></li>
<li><span>Find out how to combine BESS with renewable PPAs</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p><span>Professionals and executives from Power Utilities, Energy Companies, Financial &amp; Investment Banks, Renewable Power Project Developers, Transmission System Operators and Energy Industry Regulators will find this training course useful.</span></p>
<ul>
<li><span>Electricity Marketing and Traders</span></li>
<li><span>New Venture or Business Development Executives</span></li>
<li><span>Corporate Finance and Treasury Executives</span></li>
<li><span>Audit and Risk Management Executives</span></li>
<li><span>Power or Utility Market Research Analysts</span></li>
<li><span>Investment Managers for Renewable Power Projects</span></li>
<li><span>Origination Professionals</span></li>
<li><span>Regulation, Compliance and Documentation Officers</span></li>
<li><span>Lawyers and Accountants</span></li>
<li><span>Power Transmission and Distributions Engineers</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p><span>Our key expert is a skilled and accomplished professional with over 25 years' of extensive senior management / board level experience in the energy markets worldwide. Next to advising energy companies, banks, consultants and regulators regarding PPAs, our key expert has also conducted several highly successful training courses about Power Purchase Agreements, Power Project Finance, IPPs, and Project Risk Management to over 1,000 high level participants from Asia, Africa, Europe and Middle East.</span></p>
<p><span>He was a member of the expert commission of the Dutch Government for 2 offshore wind parks, Hollandse Kust (zuid) Wind Farm Zone Sites 3 and 4 that advised on which of the 5 applicants did provide the best security and solutions associated with the electricity and green certificate prices, the construction and</span> <span>operational risks of the project.</span></p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

Battery Energy Storage Systems (BESS) in Electricity Markets and Trading

<h2>Managing Successful Programmes (MSP®) 5th Edition Foundation: In-House Training</h2>
<p>Managing Successful Programmes (MSP®) is a globally-recognized framework for best practice programme management. MSP certification provides guidance for programme managers, business change managers and the next step for project managers to develop their knowledge and skills to be able to positively respond to the challenges for managing programmes and larger, more strategic or multiple projects. MSP 5th edition emphasizes flexibility, adaptability, and responsiveness by adopting an incremental approach to the programme lifecycle and thus enabling organizational agility.</p>
<p>AXELOS offers two levels of MSP Examination: MSP Foundation and MSP Practitioner. The MSP Foundation Examination is intended to assess whether the candidate can demonstrate sufficient recall and understanding of the MSP programme management framework. The MSP Foundation qualification is a prerequisite for the MSP Practitioner Examination, which assesses the ability to apply understanding of the MSP programme management framework in context.</p>
<p>The MSP® 5th Edition Foundation course is a training based on the exam specification for MSP Foundation certification and is aligned with the Managing Successful Programmes (5th Edition) guide from AXELOS.</p><h3>What you will Learn</h3>
<p>At the end of this course, participants will be able to:</p>
<ul>
<li>Understand key concepts relating to programmes and MSP</li>
<li>Understand how the MSP principles underpin the MSP framework</li>
<li>Understand the MSP themes and how they are applied throughout the programme</li>
<li>Understand the MSP processes and how they are carried out throughout the programme</li>
</ul><section>
                    <h3>Key Concepts of MSP</h3><ul><li>Programmes</li><li>Three Lenses of MSP</li><li>Principles</li><li>Themes and Governance</li></ul><h3>Organization</h3><ul><li>Organization Theme</li><li>Organization Structure</li><li>Individual Roles</li><li>Stakeholder Management</li></ul><h3>Design</h3><ul><li>Design Theme</li><li>Benefits</li><li>Risk Identification and Prioritization</li><li>Target Operating Model</li><li>Documents and Key Roles</li></ul><h3>Justification</h3><ul><li>Justification Theme</li><li>Business Case</li><li>Financial Planning</li><li>Documents and Key Roles</li></ul><h3>Structure</h3><ul><li>Structure Theme</li><li>Delivery Planning</li><li>Dependencies</li><li>Benefits Realization Plan</li><li>Resourcing</li><li>Documents and Key Roles</li></ul><h3>Knowledge</h3><ul><li>Knowledge Theme</li><li>Knowledge Management</li><li>Information Management</li><li>Document and Key Roles</li></ul><h3>Assurance</h3><ul><li>Assurance Theme</li><li>Assurance at Multiple Levels</li><li>Assurance Planning</li><li>Document and Key Roles</li></ul><h3>Decisions</h3><ul><li>Decisions Theme</li><li>Issue Resolution</li><li>Risk Response</li><li>Data Gathering and Reporting</li><li>Options and Analysis</li><li>Document and Key Roles</li></ul><h3>MSP Processes</h3><ul><li>Identify the Programmeâ¯â¯â¯</li><li>Design the Outcomes</li><li>Plan Progressive Delivery</li><li>Deliver the Capabilities</li><li>Embed the Outcomes</li><li>Evaluate New Information</li><li>Close the Programme</li></ul>


                </section>

Managing Successful Programmes 5th Edition Foundation: In-House

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(35, 35, 51);">This course is taught using a set of principles and methodologies developed by us to give participants a system they can always refer to any time they get stuck trying to interpret financial information.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">We have developed a 4-box model for teaching accounting which makes the process of breaking down any transaction natural for the nonaccountant. The system works without the need to learn any double-entry accounting, participants apply the system and instinctively know what to do.&nbsp;</span><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">This is followed up with another 4-box model we developed to completely break down financial analysis and ratios into the most fundamental metrics required of every role in an organization. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">Our approach is to teach financial analysis by making each participant aware of how their role and actions directly impact the company&#39;s bottom line.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">Participants will also be able to interpret the financial statement in a natural way using a third model (the 5 Box Balance Sheet) to analyze business performance effectively.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">This instructor-led course includes:&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&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;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;4 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;1 Capstone Project&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Access to our community of life-long learners.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Downloadable Certificate you can link to your LinkedIn Page</strong>&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">We look forward to seeing you in Class!!!</span></p>

dbrownconsulting

Financial Intelligence

Finance Fundamentals

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

Finance for Non-Finance Managers

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Analyst</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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:</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <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></p>



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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual



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


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


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


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


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


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


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


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


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


Discounting Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns


Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates


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


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

Property Investment

Financial Analysis

Microsoft Excel

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

Real Estate Investment School (Investment Cash Flow Modelling)

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

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



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

Let’s Do Business Group

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

Finance for Non-Financial Entrepreneurs - North Essex

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong>:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advanced project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <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></p>



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


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


Who will benefit from this course?
Real Estate professionals from a mid to senior level with exposure to Real Estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis
Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level


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


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


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

Real Estate Finance

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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).</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course will provide you with a solid foundation for understanding and analysing real estate cash flows.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong>:</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Morning</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Financial Mathematics</span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Price, Value and Worth</span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Afternoon</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discounted Cash Flow Models</span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Model Interpretation and Analysis</span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Quizzes | Q&amp;A</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <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></p>



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


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


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


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


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


Quizzes | Q&A


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


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

Risk Management

Investment

Financial Risk Management

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

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



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


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


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


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


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


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


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


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


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


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


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


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

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

Reading

Nottingham

Dickson Training Ltd

First Line Management Course

Classroom Course

Online Course

Southend-On-Sea

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

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



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

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

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

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A real estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">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.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This is an excellent starter/refresher course, whether you&rsquo;re a recent graduate or a mid/senior professional.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One:</strong></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conventional Valuations</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Cash Flow Models (Single-Let)</strong></strong></p><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;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;What If&rdquo;&nbsp;</em></em>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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Additional topics:</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Other Excel tips and tricks, including navigation and presentation:</strong></strong></p><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;"><br fr-original-style="" style="box-sizing: border-box;"></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <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></p>



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

170 Courses in Manchester

ALHO – Award in Licensed Hospitality Operations

By Knight Training (UK) Ltd

Auditing in the Exploration & Production (E&P) Industry Level 2

By EnergyEdge - Training for a Sustainable Energy Future

Exploration & Production (E&P) Accounting Level 2

By EnergyEdge - Training for a Sustainable Energy Future

Management of Risk (M_o_R) Foundation: In-House Training

By IIL Europe Ltd

Cross Border Electricity Trading in Asia - Renewable Energy, Digital Technologies and New Operational Flexibility Solutions

By EnergyEdge - Training for a Sustainable Energy Future

Finance for project managers and engineers (In-House)

By The In House Training Company

Developing the Business Case: In-House Training

By IIL Europe Ltd

Leadership & Team Dynamics in Oil & Gas

By EnergyEdge - Training for a Sustainable Energy Future

Battery Energy Storage Systems (BESS) in Electricity Markets and Trading

By EnergyEdge - Training for a Sustainable Energy Future

Managing Successful Programmes 5th Edition Foundation: In-House

By IIL Europe Ltd

Search By Location