Name: PRINCE2 Agile Foundation: In-House Training
Price: 1995 GBP
Availability: InStock

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>This 5 full-day course provides detailed description of all combustion equipment and systems used in pulverized coal boilers and circulating fluidized bed (CFB) boilers including pulverized coal burning systems, coal feeder, pulverizer and classifier, pulverized coal burners, furnace and fans. This course provides also a comprehensive explanation of all boiler combustion control systems including pulverizer control system, combustion control, control of coal and air flow into the boiler, furnace pressure control, oxygen trim control, nitrogen oxides (NOx) and sulfur oxides (SOx) control, control of ammonia injection, flue gas dew point control, purge control, flame monitoring and tripping system as well as their tuning methods. All boiler control systems are covered as well in this course including drum level feedwater control, main steam and reheat steam temperature control, boiler limits and runback, sliding or variable pressure control, heat rate optimization with sliding pressure control, boiler-turbine coordinated control, etc.</p>
<p>The course provides also detailed explanation of Boiler NFPA 85 Code (Boiler and Combustion Systems Hazards Codes) and American National Standard Institute/Instrument Society of America Code (ANSI/ISA-77-44-01-2007 Code). The burner management systems (BMS) and examples of boiler permissive starting logic and protective tripping logic will be explained thoroughly. The various methods used to calculate the boiler efficiency are covered in detail in this course including the direct and indirect methods. All the factors which affect the efficiency and emissions of pulverized coal boiler and CFB boiler will be explained thoroughly.</p>
<p>The course covers also all the methods used to improve the efficiency of pulverized coal boilers and CFB boilers including improvement to their combustion efficiency and control systems performance.</p>
<p></p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<ul>
<li><strong><span>Boiler Combustion Equipment and Systems:</span></strong><span> Gain an in-depth understanding of all boiler combustion equipment and systems including pulverized coal burning systems, coal feeder, pulverizer and classifier, pulverized coal burners, furnace and fans</span></li>
<li><strong><span>Boiler Combustion Control Systems:</span></strong><span> Gain a thorough understanding of all boiler combustion control systems for pulverized coal boilers, and CFB boilers including pulverizer control system, combustion control, control of coal and air flow into the boiler, furnace pressure control, oxygen trim control, nitrogen oxides (NOx) and sulfur oxides (SOx) control, control of ammonia injection, flue gas dew point control, purge control, flame monitoring and tripping system</span></li>
<li><strong><span>Boiler Conventional Control Systems:</span></strong><span> Gain an in-depth understanding of all boiler conventional control systems including drum level feedwater control, main steam and reheat steam temperature control, boiler limits and runback, sliding or variable pressure control, heat rate optimization with sliding pressure control, and boiler-turbine coordinated control</span></li>
<li><strong><span>Boiler NFPA 85 Code (Boiler and Combustion Systems Hazards Codes) and American National Standard Institute/Instrument Society of America Code (ANSI/ISA-77-44-01-2007 Code):</span></strong><span> Learn about NFPA 85 code and ANSI/ISA-77-44-01-2007 code</span></li>
<li><strong><span>Burner Management System and Boiler Permissive Starting Logic and Protective Tripping Logic:</span></strong><span> Gain an in-depth understanding of burner management system and boiler permissive starting logic and protective tripping logic</span></li>
<li><strong><span>Boiler Efficiency Calculations:</span><span> Learn how to calculate the boiler efficiency using the direct and indirect methods</span></strong></li>
<li><strong><span>Factors Affecting the Efficiency and Emissions of Boilers: </span></strong><span>Understand all the factors which affect the boiler efficiency and emissions</span></li>
<li><strong><span>Methods Used to Improve the Efficiency of Boilers:</span></strong><span> Learn about all the methods used to improve the efficiency of pulverized coal boilers, and CFB boilers including improvement to their combustion efficiency and control systems performance</span></li>
<li><strong><span>Boiler Instrument and Piping Diagrams:</span></strong><span> Gain an in-depth understanding of all boiler instrument and piping diagrams</span></li>
<li><strong><span>CFB and Pulverized Coal Boilers Equipment and Systems:</span></strong><span> Learn about various types of equipment and systems used in CFB and pulverized coal boilers including economizers, steam drum, superheaters, air preheaters, ammonia injection systems, etc.</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<ul>
<li><span>Engineers of all disciplines</span></li>
<li><span>Managers</span></li>
<li><span>Technicians</span></li>
<li><span>Maintenance personnel</span></li>
<li><span>Other technical individuals</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all 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 to their own organization.</span></p>
<p><span>Each delegate will receive a copy of the following materials written by the instructor:</span></p>
<ul>
<li><span>Excerpt of the relevant chapters from the 'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2012 (800 pages)</span></li>
<li><span>Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by</span> <span>McGraw-Hill in 2012 (800 pages)</span></li>
<li><span>COMBUSTION ENGINEERING FOR COAL FIRED POWER PLANTS MANUAL (includes practical information about combustion engineering for coal fired power plants - 550 pages)</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him;</p>
<ul>
<li>Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011.</li>
<li>Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003.</li>
<li>Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012.</li>
<li>Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999).</li>
<li>Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999).</li>
</ul>
<p>Furthermore, he has received the following awards:</p>
<ul>
<li>The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016</li>
<li>The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996).</li>
<li>The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East).</li>
<li>Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983).</li>
</ul>
<p>Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada.</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>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Combustion Engineering for Coal Fired Power Plants

Team of 10, pp

Normal Fee, pp

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>Identifying and correcting the root cause of failures in boilers and steam power plant equipment is essential to help reduce the chance of future problems. A comprehensive assessment is the most effective method of determining the root cause of a failure. For example, a tube failure in a boiler is usually a symptom of other problems. To fully understand the root cause of the failure, one must investigate all aspects of boiler operation leading to the failure in addition to evaluating the failure itself. When a boiler tube failure occurs, the root cause of the failure must be identified and eliminated.</p>
<p>This 5 full-day course starts by providing an in-depth understanding of root cause analysis methodology. This includes how to identify the problem, contain and analyze the problem, define the root cause of the problem, define and implement the actions required to eliminate the root cause, and validate that the corrective actions prevented recurrence of the problem. Many practical examples on how to apply root cause analysis for various industrial problems are discussed in detail.</p>
<p>The course then provides an in-depth explanation of all failure mechanisms that occur in steam power plants including corrosion, erosion, creep, cavitation, under-deposit attacks, stress corrosion cracking, hydrogen embrittlement, flow accelerated corrosion, etc. This course also provides a thorough explanation of all the failure mechanisms that occur in boilers and steam power plant equipment including steam turbines, condensers, feedwater heaters, etc. The symptoms of the failures, possible causes, components typically affected and solutions are also provided in this course. This includes boiler waterside, fireside and general boiler failure mechanisms as well as all the causes and prevention of all steam turbine failures, condensers, and feedwater heaters. The course also includes detailed study of many case histories of failures in boilers, steam turbines, condensers and feedwater heaters.</p>
<p></p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<ul>
<li><strong><span>Electrical Equipment Testing and Maintenance: </span></strong><span>Gain a thorough understanding of all the testing and maintenance required for all key electrical equipment including transformers, inverters, rectifiers, switchgear and circuit breakers, relays and protective devices, cables and accessories, motors, variable frequency drives, uninterruptible power systems, generators, fuses, and industrial batteries</span></li>
<li><strong><span>Root Cause Analysis Methodology:</span></strong><span> Understand root cause analysis methodology including: identification of the problem, defining the problem, understanding the problem, identification of the root cause of the problem, providing corrective action, and monitoring the system.</span></li>
<li><strong><span>Applying the Root Cause Analysis Method to Industrial Problems:</span></strong><span> Learn by studying many practical examples how to apply the root cause analysis method to various industrial problems.</span></li>
<li><strong><span>Damage Mechanisms in Boilers and Steam Power Plant Equipment: </span></strong><span>Gain a thorough understanding of all the damage mechanisms that occur in boilers and all steam power plant equipment including turbines, condensers and feedwater heaters. These mechanisms include corrosion, erosion, flow accelerated corrosion, stress corrosion cracking, creep, under-deposit attack, cavitation, hydrogen embrittlement, etc.</span></li>
<li><strong><span>Symptoms of Failures in Boilers and Steam Power Plant Equipment, Possible Causes, Components Typically Affected, and Solutions:</span></strong><span> Learn about all the symptoms of failures in boilers and steam power plant equipment including steam turbines, condensers, and feedwater heaters, their possible causes, components typically affected and proven solutions.</span></li>
<li><strong><span>Case Histories of Failures in Boilers, Steam Turbines, Condensers, and Feedwater Heaters:</span></strong><span> Learn by studying many case histories how failures occur in boilers, steam turbines, condensers, and feedwater heaters and the corrective actions taken to deal with them</span></li>
</ul>
<p> </p>
<p> </p>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<ul>
<li><span>Engineers of all disciplines</span></li>
<li><span>Managers</span></li>
<li><span>Technicians</span></li>
<li><span>Maintenance personnel</span></li>
<li><span>Other technical individuals (this seminar is suitable for individuals who do not have an electrical background)</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all 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 to their own organization.</span></p>
<p><span>Each delegate will receive a copy of the following materials written by the instructor:</span></p>
<ul>
<li><span>Excerpt of the relevant chapters from the 'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2011 (800 pages)</span></li>
<li><span>Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by McGraw-Hill in 2012 (800 pages)</span></li>
<li><span>ROOT CAUSE ANALYSIS FOR BOILERS AND STEAM CYCLE FAILURES MANUAL (includes practical information and case histories - 500 pages)</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories.</p>
<p>While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment.</p>
<p>Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations.</p>
<p>In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures.</p>
<p>He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him;</p>
<ul>
<li>Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011.</li>
<li>Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003.</li>
<li>Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012.</li>
<li>Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999).</li>
<li>Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999).</li>
</ul>
<p>Furthermore, he has received the following awards:</p>
<ul>
<li>The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016</li>
<li>The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996).</li>
<li>The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East).</li>
<li>Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983).</li>
</ul>
<p>Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada.</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>

Root Cause Analysis for Boilers and Steam Cycle Failures

Redhill

<h3><b>Microsoft Active Directory course description</b></h3>
      <p> A thorough understanding of this system is essential for
anyone managing enterprise MS networks. Essential
theory is complimented with a high level of hands on
practice allowing delegates to observe the
idiosyncrasies of Active Directory and Group Policy at
first hand. Delegates learn the fundamental theory of
AD and progress onto building a multi-domain network
in the classroom. The course includes troubleshooting
methods, and essential maintenance procedures. This
course is designed to teach you the skills needed for
day to day management of these technologies.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	 <li>Install AD on multiple PCs.</li>
																				<li>Use the tools to create and manage objects.</li>
                    <li>Create appropriate group policies to restrict
selected user's desktops and network access.</li>
                    <li>Install DNS to support Active Directory without
loosing Internet Connectivity. </li>
                    <li>Maintain and troubleshoot AD problems</li>
                     <li>Backup Active Directory.</li>
                  </ul>
        <h5><b>Microsoft Active Directory course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff working with AD based networks.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Supporting Windows server.
                    </p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Microsoft Active Directory course contents</b></h3>
      <ul>
				<li>Introduction to Active Directory </li><p>
Network authentication methods, Active Directory defined, AD naming conventions, network management with AD, AD structures: Domains, Organisational Units, Forests &amp; Trees, Sites, The Global Catalogue. Windows 2003 new features, installing AD.
<br /><span>Hands on</span> Installing an AD network.

</p><li>Windows overview </li><p>
Management methods Server management tools, installing the additional tools, Terminal Server: Administration mode, Administrator accounts in AD, Local Security Policy.
<br /><span>Hands on</span> Install the management tools, Management using Terminal Services.

</p><li>Creating &amp; Managing Objects (a quick look) </li><p>
AD management tools, AD users and computers, Creating &amp; managing OUs, User Accounts and groups, controlling access to AD objects, moving objects, Publishing resources, locating objects in AD, delegating authority.
<br /><span>Hands on</span> Creating a control OU structure and delegating authority.

</p><li>Introduction to Group Policies </li><p>
What are Group Policies? Where Group Policy data is stored, security, Group Policy flow.
<br /><span>Hands on</span> Implementing Group Policies

</p><li>Working with Group Policies </li><p>
Local security templates, administrative templates, scripts, folder redirection, software deployment.
<br /><span>Hands on</span> Scripts, redirecting the start menu, creating a secure, robust desktop environment.

</p><li>Implementing DNS </li><p>
DNS basics, troubleshooting, implementing DNS zones.
<br /><span>Hands on</span> Building a unified DNS solution.

</p><li>Maintaining and managing the AD database </li><p>
AD support tools, database internal structure, replication, replication tools, Single Operations Masters, tools for maintenance, maintenance techniques, Backing up AD, Directory Services restore mode, NTDSUtil, Authoritative &amp; non-authoritative restoration, rebuilding.
<br /><span>Hands on</span> NTDSUtil.
</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Microsoft Active Directory

General Admission

<h3><b>OTT TV for engineers course description</b></h3>
      <p>This course covers OTT TV by primarily looking at the
delivery of video streams using HTTP adaptive
streaming. Both MPEG DASH and HLS are
investigated. Hands on sessions involve using
Wireshark to analyse streams as well as crafting
segmented content.

</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
       <li>Explain what OTT TV is, and how it works.</li>
 <li>Describe the OTT TV architecture.</li>
 <li>Use Wireshark to analyse and troubleshoot OTT</li>
 <li>video streams.</li>
 <li>Explain how HTTP adaptive streaming works.</li>
 <li>Evaluate and compare MPEG DASH and HLS.</li>
 <li>Use tools to create OTT TV adaptive streams.</li>
                  </ul>
       
        <h5>
        <b> OTT TV for engineers course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working in the broadcast industry.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>TCP/IP foundation for engineers.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b> OTT TV for engineers course contents</b></h3>
      <ul>
  
<li>What is OTT TV?</li><p>
Brodeo providers vs ISPs. Progressive downloads
versus streaming. Why not UDP and RTP for
delivery? Adaptive bit rate streaming. Standards.
<br /><span>Hands on:</span> Base network setup. Using WireShark
for HTTP streams.
		  </p><li>HTTP protocol stack</li><p>
IP, TCP, IPv6. HTTP. HTTP 1.0, HTTP 1.1,
HTTP 2.0, HTTP header fields. HTML 5.
<br /><span>Hands on:</span> Analysing HTTP.
</p><li>Adaptive bitrate streaming principles</li><p>
Chunks, fragments, segments. Manifest files.
Encoding, resolution, bitrates. Addressing,
relative and absolute URLs, redirection. When
does the client switch streams? Switch points.
<br /><span>Hands on:</span> Walk through of client behaviours on
a stream.
</p><li>OTT TV streaming architecture</li><p>
Server components, distribution components,
client software. CDN, caching, multiple servers.
<br /><span>Hands on:</span> Analysing CDN and Internet delivery.
</p><li>TCP and HTTP streaming interactions</li><p>
TCP ACK, TCP connections, unicast only. TCP
flow control, TCP and performance.
		  <br /><span>Hands on:</span> TCP window sizes.
				
</p><li>MPEG DASH</li><p>
Stakeholders, DASH architecture and model,
codec agnostic, XML, Media Presentation
Description, Media Presentation, segment
formats.
<br /><span>Hands on:</span> MPEG DASH analysis.
		  
		  
</p><li>HTTP Live Streaming and others</li><p>
Stakeholders. Media segments, media playlists,
master playlists. Adobe HTTP dynamic
streaming, Microsoft smooth streaming.
<br /><span>Hands on:</span> Analysing HLS.
</p><li>Tools</li><p>
mp4dash, mp4fragment, libdash. Apple
developer tools for HLS.
<br /><span>Hands on:</span> Creating segmented content.
</p><li>Security</li><p>
HTTPS, encryption, content protection.
<br /><span>Hands on:</span> Encryption analysis.
</p><li>Summary</li><p>
Choosing a streaming method. Impact of live
versus VoD. Web sockets.		  

</p>
      </ul>

OTT TV for engineers

London

<h2>Effecting Business Process Improvement: In-House Training</h2>
 <p>Business analysts facilitate the solution of business problems. The solutions are put into practice as changes to the way people perform in their organizations and the tools they use. The business analyst is a change agent who must understand the basic principles of quality management. This course covers the key role that business analysts play in organizational change management.</p><h3>What you will Learn</h3>
 <p>You will learn how to:</p>
 <ul>
 <li>Define and document a business process</li>
 <li>Work with various business modeling techniques</li>
 <li>Perform an enterprise analysis in preparation for determining requirements</li>
 <li>Analyze business processes to discern problems</li>
 </ul><section>
                    <h3>Foundation Concepts</h3> <ul> <li>Overview of business analysis and process improvement</li> <li>Defining the business process</li> <li>Introducing the proactive business analyst</li> <li>Focusing on business process improvement for business analysts</li> </ul> <h3>Launching a Successful Business Process Improvement Project</h3> <ul> <li>Overview of the launch phase</li> <li>Understanding and creating organizational strategy</li> <li>Selecting the target process</li> <li>Aligning the business process improvement project's goals and objectives with organizational strategy</li> </ul> <h3>Defining the Current Process</h3> <ul> <li>Overview of current process phase</li> <li>Documenting the business process</li> <li>Business modeling options: work-flow models</li> <li>Business modeling options: Unified Modeling Language (UML) model adaptations for business processes</li> </ul> <h3>Analyzing the Current Process</h3> <ul> <li>Process analysis overview</li> <li>Evaluation: establishing the control group</li> <li>Opportunity techniques: multi-discipline problem-solving</li> <li>Opportunity techniques: matrices</li> </ul> <h3>Building and Sustaining a Recommended Process</h3> <ul> <li>Overview of the recommended process and beyond</li> <li>Impact analysis</li> <li>Recommended process</li> <li>Transition to the business case</li> <li>Return to proactive state</li> </ul>


                </section>

IIL Europe Ltd

Effecting Business Process Improvement: In-House Training

<p id="isPasted"><strong><span>Course Overview:</span></strong></p><p><span>The "Promoting Best Practice in Asthma and Anaphylaxis Management Training" course is designed to provide healthcare professionals, educators, and individuals responsible for patient care with comprehensive knowledge and practical skills in the effective management of asthma and anaphylaxis. This course focuses on promoting evidence-based practices, proper emergency response protocols, prevention strategies, and patient education to ensure optimal outcomes for individuals with asthma and those at risk of anaphylaxis.</span></p><p><span><br /></span></p><p><span><strong>Course Duration:</strong></span></p><p><span>1 day (9 Hours)</span></p><p><span><br /></span></p><p id="isPasted"><strong><span>Course Content:</span></strong></p><p><span>1. Introduction</span></p><p><span>2. Recognition and Response</span></p><p><span>3. Best Practices</span></p><p><span>4. Action Plans and Medication</span></p><p><span>5. Emergency Management</span></p><p><span>6. Education and Assessment</span></p><p><span><br /></span></p><p><span><strong>Course Objectives:</strong></span></p><p><span>1. Understand Asthma and Anaphylaxis Basics: Grasp the fundamentals of asthma and anaphylaxis, including pathophysiology, triggers, risk factors, and the importance of early intervention.</span></p><p><span>2. Recognise Signs and Symptoms: Identify the clinical manifestations and symptom progression of asthma and anaphylaxis, enabling swift and accurate assessment.</span></p><p><span>3. Implement Evidence-Based Best Practices: Apply the latest guidelines and evidence-based practices for asthma and anaphylaxis management, including prevention strategies, pharmacological interventions, and emergency procedures.</span></p><p><span>4. Create Asthma Action Plans: Develop individualized asthma action plans to empower patients in self-management and prevent exacerbations.</span></p><p><span>5. Administer Medications: Gain proficiency in administering inhalers, nebulizers, epinephrine auto-injectors, and other relevant medications, ensuring proper technique and patient education.</span></p><p><span>6. Respond to Emergencies: Acquire the skills to respond effectively to acute asthma and anaphylaxis emergencies, including proper use of equipment like peak flow meters and spacers.</span></p><p><span>7. Promote Education and Communication: Develop effective communication strategies for educating patients, caregivers, and the public about asthma and anaphylaxis management, triggers, and emergency responses.</span></p><p><span><br /></span></p><p><span><strong>Course Assessment:</strong></span></p><p><span>Participant proficiency will be assessed through:</span></p><ul><li>Quizzes and assignments measuring theoretical understanding.</li><li>Practical assessments of inhaler technique training and emergency response protocols.</li><li>Participation in case discussions and scenario-based exercises.</li><li>A final assessment covering all aspects of asthma and anaphylaxis management.</li></ul><div><span><strong><span><br /></span></strong></span></div><div><span id="isPasted"><strong><span>Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.</span></strong></span></div>

Guardian Angels Training

Gain comprehensive knowledge and practical skills in asthma and anaphylaxis management with our evidence-based training course. Ideal for healthcare professionals, educators, and patient care providers. Optimise patient outcomes with effective emergency response protocols, prevention strategies, and patient education.

Promoting Best Practice in Asthma and Anaphylaxis Training (Train the Trainer)

<h3><b>GPON and FTTx networks training course description</b></h3>
      <p>  Designed to benefit those requiring an in depth
knowledge of the principles and applications of Ten
Gigabit and Gigabit Passive Optical Networking and
Fibre to the X in NG Networks applications and their
associated equipment, its flexibility and function within
a modern transmission network.<br />
Using an effective mix of 'hands on' equipment
instruction and correlation to theory based learning the
delegate will gain a complete understanding of the
equipment and the tasks to be undertaken in a real life
situation.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
  <li>Compare PON/FTTx systems.</li>
																				<li>Explain network elements and designs.</li>
                    <li>Support applications and network interfaces.</li>
                    <li>List circuit provisioning and bandwidth requirements.</li>
                    <li>Understand upstream &amp; downstream issues.</li>
                     <li>Describe headend &amp; network elements/OLT-ONT.</li>
                     <li>Perform network testing with OTDR test sets.</li>
				</ul>
        <h5>
        <b>GPON and FTTx networks training course details</b></h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
           <p>Anyone working with GPON and FTTx.</p>
              
							<li><b>Prerequisites:</b></li>
							
                 <p>Introduction to data communications and networking.</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
               
              
						</ul>
					</div>
				</div>
     <h3><b>GPON and FTTx training course contents</b></h3>
      <ul>
				<li>FTTN, FTTC, FTTH </li><p>
SMF, MMF, Fibre safety and properties (dispersion/attenuation), Fibre reel cables and types, Fibre installation and air blown fibre, Transmitters and receivers - power budget/laser classes. Fibre to the home (FTTH), FTTC (Fibre to the Cabinet), FTTN (Fibre to the node) , FTTD (Fibre to the desk), FFTH topologies and wavelengths, Active or passive optical network.

</p><li>WDM equipment and GPON OSP design </li><p>
Wavelength considerations, WDM/DWDM/CWDM, EDFA optical amplification, AWG (Arrayed Waveguide Grating) splitters , Couplers (splitters) and losses, Optical splitters 1x2, 1x4, 1x8, 1x16, 1x32, 1x64, 2x64.

</p><li>PON variants </li><p>
Gigabit passive optical network (GPON), Gigabit Ethernet passive optical network (GEPON), Time division PON (TDM-PON), Wave Division Multiplexing PON (WDM-PON), 1Gbps, 10Gbps, 40Ggps, 100Gbps FSAN (Full Service Access Network) NGA (Next Generation Access), Strategies for TDM-PON to WDM-PON migration, Architecture of NG-PON (hybrid WDM/TDM PON), Additional services than triple play.

</p><li>GEPON design </li><p>
GPON OSP centralized and distributed design, GPON PON splitters x4 x8 x32, Fibre splice trays /cassette trays &amp; enclosures, GPON field testing and installation verification, GPON physical layer testing, Optical time domain reflectometer (OTDR), Optical power source &amp; meter, Optical return loss (ORL), APON/BPON/GPON/EPON comparisons.

</p><li>GPON ITU-T G.984.1 </li><p>
Reference model, terminology &amp; architecture, Access network system management functions. ONT &amp; OLT functional block examples. FTTx scenarios, 4 switching arrangements for external access network backup.

</p><li>GPON ITU-T G.984.2 </li><p>
Physical layer, Enhancement band, Bit rate and wavelengths, FEC and RAMAN.

</p><li>GPON ITU-T G.984.3 </li><p>
Frame structure, GPON encapsulation method (GEM), GTC adaptation and framing sublayer protocol stack, Status reporting &amp; traffic monitoring DBA (SR-DBA &amp; TM-DBA), Transmission container (T-CONT) types, Downstream &amp; upstream multiplexing, GEM port identifier, Media access control and ONU registration, Extended bandwidth assignment model scheduling architecture, PLOAM &amp; alarm messages, Downstream &amp; Upstream FEC, Process order in a GTC transmit flow.

</p><li>GPON ITU-T G.984.4 and G.988 ONT management and control interface (OMCI) </li><p>
Management interface, Reference model, Typical ONT with SCTE 55-1 or SCTE 55-2 compliancy.

</p><li>GPON ITU-T G.984.5 enhancement band </li><p>
Band options, GPON NGA, Wavelength allocation.

</p><li>GPON ITU-T G.984.6 optical reach extension (G.984.re) </li><p>
Reach extension (RE), OA-based and OEO-based reach extenders, Protection, Reach extender with OTDR blocking filters (BF) and bypass (BYP) filters.

</p><li>GPON ITU-T G.984.7 long reach </li><p>
Quiet Window.

</p><li>10-GPON ITU-T G.987.1 (XG-PON) </li><p>
Scenarios, reference access network architecture, XG-PON with G-PON through WDM1r, G-PON and XG-PON wavelength allocation, G-PON and XG-PON co-existence with video overlay option, RE migration scenarios.

</p><li>G.989 40Gbps XG-PON2 </li><p>
Functional reference architecture, NG-PON2 system coexistence with legacy systems, Definitions of legacy compatibility terminology.

</p><li>GPON issues and standards </li><p>
GPON components GPON OLT / GPON ONT, GPON management, Operational support systems (OSS), Network management systems (NMS), OMCI (ONT Management control interface), RG (Residential gateway), Data and prioritised voice channel product, GPON broadband-forum standards, Broadband-forum , TR-069 and TR-156, HPNA (home phone network alliance), Powerline carrier (PLC), GPON DLNI G.hn or G.9960, MOCA, FTTH council certification standard for network certification. Fibre-connected home badge, Ethernet in the first mile (EFM), GPON frame synchronization to network timing, Direct clock synchronization interface (BITS), Multiservice access platform (MSAP), Software planning tool, Superconnected cities / voucher scheme.

</p><li>Hands on practical assignments </li><p>
Single and multimode fibre recognition, Fibre Cleaning methods, Checking cleaning with an optical microscope, Optical light source and optical power meter referencing, PON splitter and fibre drum testing with an optical power meter, 6km classroom passive optical network testing with an OTDR at 1310/1550nm, Using decibels (dB's) and decibel milliwats (dBm's), Designing networks up to 20km long using vendor specifications (power budget), Fault finding with a visible fault locator.
</p>
      </ul>

GPON and FTTx networks

<h3><b>Web development training course description</b></h3>
      <p>This three-day course helps build a foundation in the
development of Web applications. This is not a HTML
course but covers the technologies needed to develop
web applications. Technologies covered include:
ASP.NET, XML, AJAX and HTTP error codes.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  
                       <li>Program Web applications.</li>
				  	                <li>Work with data and services.</li>
                       <li>Troubleshoot and debug Web applications.</li>
                      	<li>Work with client side scripting.</li>
                       <li>Configure and deploy web applications.</li>
                  </ul>
        <h5>
        <b>Web development training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone looking for an introduction to web development.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Web development training course contents</b></h3>
      <ul>
				<li><span>Programming web applications</span></li><p>
</p><li>Customise the layout and appearance of a web page </li><p>
CSS; tables; embedding images; page layout for navigation.

</p><li>Understand ASP.NET intrinsic objects </li><p>
Request; Server; Application; Session; Response; HttpContext.

</p><li>Understand state information in web applications </li><p>
Understand how state is stored based on application design and hardware; understand different types such as session state, view state, control state and application state.

</p><li>Understand events and control page flow </li><p>
Application and page life cycle events; page events; control events; application events; session events; cross-page posting; Response.Redirect; Server.Transfer; IsPostBack; setting AutoEventWireup.

</p><li>Understand controls </li><p>
Understanding various types of controls, including user, server, web and validation controls; know which is the appropriate type of control for a scenario.

</p><li>Understand configuration files </li><p>
Understanding the usage of web.config and machine.config, and the settings that can be made.

	</p><li><span>Working with data and services </span></li><p>
</p><li>Read and write XML data </li><p>
Understanding XML, XML validation Does not include: Web services; XPath syntax; XmlDocument; XPathNavigator; XPathNodeIterator; XPathDocument; XmlReader; XmlWriter; XmlDataDocument; XmlNamespaceManager.

</p><li>Distinguish between DataSet &amp; DataReader objects </li><p>
The ability to choose the proper data object to use based on application requirements/design.

</p><li>Call a service from a web page </li><p>
Creating a basic WCF service or web service so that it can be consumed; App_WebReferences; configuration.

</p><li>Understand DataSource controls </li><p>
LinqDataSource: ObjectDataSource; XmlDataSource; SqlDataSource.

</p><li>Bind controls to data by using data binding syntax </li><p>
Ensure that data is updated and displayed in data-aware controls.

</p><li>Manage data connections and databases </li><p>
Database connections; connection objects; connection pools; transaction objects.

	</p><li><span>Troubleshooting and debugging web applications</span> </li><p>
</p><li>Debug a web application </li><p>
Use in conjunction with custom error pages to display appropriate error information to the appropriate user; implement tracing of a web application, Trace.axd, Trace=True on @Page directive.

</p><li>Handle web application errors </li><p>
HTTP error codes.

</p><li><span>Working with client-side scripting </span></li><p>
</p><li>Understand client-side scripting </li><p>
Purpose of client-side scripting; various client-side scripting languages. LE/370 and Intrinsic Functions.

</p><li>Understand AJAX concepts </li><p>
ASP.NET AJAX implementation; working with client-side libraries, EnablePartialRendering, Triggers, ChildrenAsTriggers, Scripts, Services, UpdateProgress, Timer, ScriptManagerProxy, extender controls.

	</p><li><span>Configuring and deploying web applications </span></li><p>
</p><li>Configure authentication and authorisation </li><p>
Forms authentication, Windows authentication; authorisation; file authorisation; impersonation Does not include: Windows Cardspace authentication, Passport (Windows Live ID) authentication, Custom authentication.

</p><li>Configure projects, solutions and reference assemblies </li><p>
Local assemblies; shared assemblies (GAC); web application projects; solutions; configuration files; AppSettings.

</p><li>Publish web applications </li><p>
Choosing the appropriate method to deploy an application based on existing or intended environment; updatable vs. not updateable; MSI deployment; Internet Information Server (IIS) installation and configuration.

</p><li>Understand application pools </li><p>
Purpose of application pools; effect of application pools on web applications.</p>
			
      </ul>

Web development fundamentals

<h2>The Agile Project Manager</h2>
 <p>Change isn't coming, it's already here. The project environment is becoming more volatile, uncertain, complex, and ambiguous. Project management and project managers must transform and evolve in order to keep up with these changes.</p>
 <p>Agile has been a disruptor in the field of project management, having over 20 years of successes and benefits to organizations that have adopted their frameworks. The Agile frameworks have proven themselves to be more adept in dealing with this uncertainty. But Agile isn't just about following a different way of working.</p>
 <p>What do you need to learn, do, and become in order to continue in the current and future environment? It is a powerful combination of knowledge, competencies, and mindset.</p>
 <p>In an increasingly complicated project environment, this course provides participants with the knowledge needed to not only survive but thrive.</p><h3>What you will Learn</h3>
 <p>At the end of this program, you will be able to:</p>
 <ul>
 <li>Evaluate the changing project environment and the needed knowledge, skills, and behaviors</li>
 <li>Demonstrate innovative project manager competencies of leading change, servant leadership, and focus on value</li>
 <li>Utilize Lean and Agile principles to maximize value and improve project performance</li>
 <li>Construct a hybrid Agile model that is unique to your project</li>
 <li>Assess your role in Business Agility as an Agile Project Manager</li>
 </ul><section>
                    <h3>Getting Started</h3> <ul> <li>Introductions</li> <li>Workshop orientation</li> <li>Expectations</li> </ul> <h3>Foundations</h3> <ul> <li>Recap: What is Agile?</li> <li>A changed project environment</li> <li>The future project manager</li> </ul> <h3>Agile Project Management Competencies</h3> <ul> <li>Focusing on value</li> <li>Championing change</li> <li>Servant leadership</li> <li>Coaching / mentorship</li> <li>Facilitation</li> </ul> <h3>Lean and Agile Principles</h3> <ul> <li>Optimizing flow</li> <li>Making things small</li> <li>Continuous planning</li> <li>Just-In-Time requirements</li> <li>Visualizing work</li> </ul> <h3>Hybrid Agile Considerations</h3> <ul> <li>Considering a Hybrid Approach</li> <li>Examining Strengths and Weaknesses of Each Approach</li> <li>Selecting Waterfall / Agile Roles, Practices, and Techniques</li> <li>Reviewing Three Hybrid Scenarios</li> <li>Constructing the Hybrid Project</li> </ul> <h3>Implementing Agile</h3> <ul> <li>Pitfalls and Concerns</li> <li>Agile in the Organization</li> <li>Business Agility</li> </ul>


                </section>

The Agile Project Manager: In-House Training

<h2>PRINCE2 Agile® Foundation: In-House Training</h2>
<p>PRINCE2 Agile® provides structure, governance, and control when working with agile concepts, methods, and techniques. It is a solution combining the flexibility and responsiveness of Agile with the clearly defined framework of PRINCE2. PRINCE2 Agile® framework covers a wide range of agile concepts, including SCRUM, Kanban, and Lean Startup. The PRINCE2 Agile® Foundation certificate is designed to help professionals deliver agile projects by tailoring PRINCE2® management controls with a broad toolset of agile delivery techniques and frameworks.</p>
<p>PRINCE2 Agile® is an extension module tailored for forward-thinking organizations and individuals already benefiting from PRINCE2®. It provides further guidance on how to apply agile methods to the world's most recognized project management method. The purpose of the Practitioner qualification is to demonstrate that you can apply and tailor PRINCE2 Agile® in a scenario situation.</p><h3>What you will Learn</h3><ul><li>Understand the key aspects of PRINCE2®</li><li>Understand basic concepts behind common agile ways of working</li><li>Demonstrate the purpose of combining PRINCE2® with agile</li><li>Be able to fix and flex the aspects of a project in an agile context</li><li>Apply the PRINCE2® principles and tailor the themes, processes, and management products to a project in an agile context</li><li>Incorporate the areas that can support a PRINCE2 Agile® implementation</li><li>To prepare Participants for the PRINCE2 Agile® Foundation exam</li></ul><h3>Benefits</h3><ul><li>Agile methods allow organizations to realize the benefits of products and potentially an earlier return on investment while products are being developed and improved.</li><li>Improved communication through the use of common terminology across PRINCE2® and agile disciplines.</li><li>Develop a clear definition of how agile can govern a project's delivery, while PRINCE2® governs projects as a whole.</li><li>Seamless integration: PRINCE2 Agile® will complementPMBOK® GuideandAPM Body of Knowledge®just as PRINCE2® does currently. It will also be of interest for Program Managers with MSP® who need to understand how projects relate to the delivery mechanism.</li><li>The most up-to-date and relevant view of Agile project management methodologies, PRINCE2 Agile® references the 'flow-based' working featured in Kanban in addition to other agile concepts not covered in other qualifications.</li></ul><section>
                    <h3>Introduction - Getting Started</h3>
<h4>Part 1</h4>
<ul>
<li>An overview of PRINCE2</li>
<li>Agile Overview</li>
<li>Blending PRINCE2 and Agile</li>
<li>What to fix and what to flex</li>
</ul>
<h4>Part 2</h4>
<ul>
<li>Agile behaviors ad the PRINCE2 Principles</li>
<li>Agile and the PRINCE2 Themes</li>
</ul>
<h4>Part 3</h4>
<ul>
<li>Focus areas</li>
<li>Agile and the PRINCE2 Processes</li>
<li>Examination preparation</li>
<li>Examination.</li>
</ul>
<p>Summary - What did we learn, and how can we implement this in our work environment?</p>


                </section>

PRINCE2 Agile Foundation: In-House Training

<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;">This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.</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;"><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 delegates will...</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Learn how to build senior debt models with geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Explore and assess the influence of complex debt structures on returns.<br fr-original-style="" style="box-sizing: border-box;">&bull; Develop advanced mezzanine debt models affecting project cash flows.<br fr-original-style="" style="box-sizing: border-box;">&bull; Model joint venture structures for optimised partnerships.<br fr-original-style="" style="box-sizing: border-box;">&bull; Calculate promote and profit share structures in Real Estate transactions.<br fr-original-style="" style="box-sizing: border-box;">&bull; Construct sophisticated project cash flow models with mezzanine debts.</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;"><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><br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Professionals who have had exposure to Real Estate financial models<br fr-original-style="" style="box-sizing: border-box;">&bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis<br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Developers<br fr-original-style="" style="box-sizing: border-box;">&bull; Financial Analysts<br fr-original-style="" style="box-sizing: border-box;">&bull; Investment Managers<br fr-original-style="" style="box-sizing: border-box;">&bull; Banking and Finance Professionals in Real Estate</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;"><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><br fr-original-style="" style="box-sizing: border-box;">&bull; Mathematics of amortisation and debt finance.<br fr-original-style="" style="box-sizing: border-box;">&bull; Basic senior debt models and geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.<br fr-original-style="" style="box-sizing: border-box;">&bull; Mezzanine debt modelling.<br fr-original-style="" style="box-sizing: border-box;">&bull; Joint Venture structures between developers and lender/equity partners.<br fr-original-style="" style="box-sizing: border-box;">&bull; Promote and profit share structure calculations.<br fr-original-style="" style="box-sizing: border-box;">&bull; Advanced project cash flows with mezzanine debt.</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 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;"><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</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><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 Finance 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 Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.
This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.

On this course delegates will...
• Learn how to build senior debt models with geared net cash flow.
• Explore and assess the influence of complex debt structures on returns.
• Develop advanced mezzanine debt models affecting project cash flows.
• Model joint venture structures for optimised partnerships.
• Calculate promote and profit share structures in Real Estate transactions.
• Construct sophisticated project cash flow models with mezzanine debts.

Who will benefit from this course?
• Real Estate Professionals who have had exposure to Real Estate financial models
• Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis
• Real Estate Developers
• Financial Analysts
• Investment Managers
• Banking and Finance Professionals in Real Estate

Course Outline
• Mathematics of amortisation and debt finance.
• Basic senior debt models and geared net cash flow.
• Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.
• Mezzanine debt modelling.
• Joint Venture structures between developers and lender/equity partners.
• Promote and profit share structure calculations.
• Advanced project cash flows with mezzanine debt.


Included in the Course
A Bayfield Training Certificate
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 Finance 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

Real Estate Finance

Financial Modelling

Financial Analysis

Professional Development

Continuous Professional Development (CPD)

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.

Real Estate Finance (Debt Financing)

Swansea

ONLINE STUDY + ONE DAY ZOOM SESSION
NO CLASSROOM ATTENDANCE REQUIRED


Awarding Body: Dual Accreditation - Open College Network (OCN Credit4Learning) & The CPD Certification Service (21 CPD Points)
 
Award Level: UK - Level Three (Advanced) + 21 CPD Points
Ireland Level Five (Advanced) + 21 CPD Points
 
Minimum Age: 18 (16 with parental consent)
 
Entry requirements: None. English Level 2 desirable
 
Training Locations: Study online + virtual classroom.
 
Practical Training: Includes FREE Practise@Home Phlebotomy Training Kit worth £79.99
This comprehensive 76 piece practical training kit includes mini-arm trainer, sharps container and all medical grade supplies needed as well as a step-by-step 30 minute training video.



PART 1 (THEORY) - STUDY AT HOME ONLINE :
Complete your theory training online in the comfort of your own home or at work. Stop/start when it suits you and complete the online modules at your own pace. Can be completed on multiple devices such as laptop, smart-phone, desktop computer, kindle, tablet etc.
 
PART 2 (PRACTICAL SESSIONS) - JOIN US FOR A COMPREHENSIVE ONE DAY ZOOM SESSION:
Full instructions will be provided. We will send you a completely free Practise@Home Phlebotomy Training Kit, including a mini-arm trainer, for you to keep. You will follow your tutor's on-screen instructions during your Zoom virtual classroom sessions as you learn and develop your phlebotomy skills. The procedures and practices taught online are exactly the same as you would learn in the classroom. At any time before or after your course you can watch our 30 minute step-by-step video to refresh your knowledge and continue to use your training kit to practice your skills.
 
(THIS COURSE AWARDS THE SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR CLASSROOM AND HYBRID COURSE VERSIONS)


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


COURSE ITINERARY

 
A dually-accredited hybrid modular venepuncture course awarding an
OCN Accredited Level Three Certificate (3 credits) & 21 CPD Points


Nationally Recognised Qualification


Part 1 - online (eLearning) Part 2 - Virtual Classroom (1 Day Zoom)


PRE-COURSE
Home study pack - download and complete before the virtual classroom sessions

PART 1 - ONLINE
M01: Course Overview
M02: History, Definitions and Roles
M03: Work-flow cycles
M04: Professionalism
M05: Health & Safety
M06: Blood Collection Systems
M07: Anatomy & Physiology
M08: Blood Composition
M09: Using the equipment
M10: Performing the venepuncture - see Classroom Part 2
M11: Lab Tests and Bottle Types
M12: Analytical Errors
M13: Informal Quiz – answers
M14: Award – accredited certificates, value, application and overview. Job Opportunities.


PART 2 - VIRTUAL CLASSROOM (ONE DAY ZOOM SESSION)
M01: Introduction: Welcome, Introductions and Overview.
M10: Performing the venepuncture (theory overview)
P01: Practical Session 1 – Equipment familiarisation - "Tools of the Trade"
P02A: Practical Session 2A – Unpacking your training kit
P02B: Practical Session 2B - A look at the mini-arm trainer and associated equipment
P03: Practical Session 3 – Using the tourniquet and identifying a vein
P04: Practical Session 4 – Handling and assembling the equipment. Familiarisation and procedures including initial skill-set development
P05: Practical Session 5 - Further skill-set development and consolidation. Discussing needle types including winged infusion sets (butterfly needles)
P06A: Practical Session 6A – Performing the venepuncture on the mini-arm trainer. Palpating the vein, performing the venepuncture. Sample handling and labelling.
P06B: Practical Session 6B – Consolidating pre- and post-venepuncture procedures.
 
Additional support material can be downloaded as you progress through the course online.





ZOOM SESSION

VIRTUAL CLASSROOM (ZOOM) SESSIONS 
Our Virtual Classroom training course consists of online study (Part 1 - theory) and Virtual Classroom Zoom sessions (Part 2 - practical skill-set development)
You must complete your Part 1 online study before joining us for your Zoom session(s).
Once you have enrolled on this course you will be sent a free Practise@Home Training Kit, This is yours to keep and can be reused any many time as you wish after you have completed the course.
Your Booking Confirmation will include your Zoom log-in details.



Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

Learn how to take blood ... train as a Phlebotomist

    Nationally Recognised Qualification

    No previous experience or qualifications needed

    OCN Accredited - Level 3 (advanced)

    CPD Accredited (The CPD Certification Service)

    Covers all steps up to live blood draw

    Practise on artificial arm and fake blood!

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Introduction to Phlebotomy Course (GPT003VC) - 1 DAY Virtual Classroom



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

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

Property & Real Estate Photography

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is intended for both novice and experienced SharePoint users who wish to make full use of SharePoint Online.</p>Overview<p>#NAME?</p><p>This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ?what not to do? as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - An Introduction to SharePoint Online</h3> <ul> <li>Introducing Office 365 and SharePoint</li> <li>Getting started with Office 365</li> <li>The cloud revolution</li> <li>Login to Office 365</li> <li>What is Office 365</li> <li>Using the app launcher</li> <li>What is SharePoint</li> <li>Office 365 settings</li> <li>Introducing Office 365 Groups</li> <li>Delve</li> <li>Ownership and Access</li> <li>OneDrive</li> </ul> <h3>2 - Creating Sites</h3> <ul> <li>Planning your sites</li> <li>Create new subsites</li> <li>The Office 365 tenant</li> <li>Site templates</li> <li>Web addresses</li> <li>Apply a them</li> <li>Site collections</li> <li>Building your navigation</li> <li>Create a new site</li> <li>Delete subsites</li> <li>Team site navigation</li> <li>User interface: classic vs modern</li> <li>Site contents: classic vs modern</li> <li>Where does classic come from?</li> </ul> <h3>3 - Creating and Managing Web Pages</h3> <ul> <li>The types of pages found in SharePoint</li> <li>Classic SharePoint pages</li> <li>Modern SharePoint pages</li> <li>How to use classic team site pages</li> <li>Create news and site pages</li> <li>Review features of publishing sites</li> <li>Web parts</li> <li>Save, publish, share and delete pages</li> <li>Communication sites</li> </ul> <h3>4 - Working with Apps</h3> <ul> <li>An introduction to apps</li> <li>Co-authoring</li> <li>Marketplace apps</li> <li>Check In ? Out</li> <li>Adding apps to a site</li> <li>Edit and view file properties</li> <li>Create and manage columns</li> <li>Quick edit view</li> <li>Public and personal views</li> <li>File commands</li> <li>Managing app settings</li> <li>Copy link and Share</li> <li>Content approval</li> <li>Folders</li> <li>Major and minor versioning</li> <li>The recycle bin</li> <li>Document sets</li> <li>Alerts</li> <li>Working with files in a library</li> <li>OneDrive sync</li> <li>Create, Upload and edit files</li> <li>Working with classic lists</li> </ul> <h3>5 - Building processes with Flow and PowerApps</h3> <ul> <li>What are business processes?</li> <li>Design and publish a Flow</li> <li>Classic tools for designing processes</li> <li>Getting started with PowerApps in SharePoint</li> <li>Design and test a classic workflow</li> <li>Enhance data capture with PowerApps</li> <li>Getting started with Flow in SharePoint</li> <li>Test a Flow and PowerApps enriched list</li> </ul> <h3>6 - Customizing Security</h3> <ul> <li>Office 365 Group access</li> <li>Share a file</li> <li>Updating Office 365 Group Security</li> <li>Remove a user</li> <li>Managing access to SharePoint</li> <li>Customizing SharePoint security</li> <li>New sites private vs public</li> <li>Create permission levels and groups</li> <li>Setup access requests</li> <li>Security inheritance</li> <li>Share a site</li> <li>Security best practices</li> </ul> <h3>7 - Working with Search</h3> <ul> <li>Delve</li> <li>Search tips</li> <li>An introduction to SharePoint search</li> <li>Accessing classic search</li> <li>Search in folders, libraries and sites</li> <li>Promoted results</li> <li>Search results</li> </ul> <h3>8 - Enterprise Content Management</h3> <ul> <li>Managed metadata service</li> <li>Information management policies</li> <li>An introduction to content types</li> <li>The records center</li> <li>Create and manage content type</li> <li>In-place records management</li> <li>Deploy content types</li> <li>The content organizer</li> <li>Using content types in apps</li> <li>Durable links</li> <li>The content type hub</li> </ul></div>

Nexus Human

Online Course Creation

Microsoft Power Apps

Microsoft Sharepoint

Power Apps

Microsoft Power Platform

SharePoint

55215 SharePoint Online Power User

Tom Reynolds

Product Management

Agile

Agile PM

Productivity

Kanban

Agile Coach

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September

Standard

Early Bird

<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

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)

Reading

Nottingham

Dickson Training Ltd

ILM Level 3 Award in Leadership and Management

Online Course

Classroom Course

<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

157 Courses in Glasgow

Combustion Engineering for Coal Fired Power Plants

By EnergyEdge - Training for a Sustainable Energy Future

Root Cause Analysis for Boilers and Steam Cycle Failures

By EnergyEdge - Training for a Sustainable Energy Future

Microsoft Active Directory

By Systems & Network Training

OTT TV for engineers

By Systems & Network Training

Effecting Business Process Improvement: In-House Training

By IIL Europe Ltd

Promoting Best Practice in Asthma and Anaphylaxis Training (Train the Trainer)

By Guardian Angels Training

GPON and FTTx networks

By Systems & Network Training

Web development fundamentals

By Systems & Network Training

The Agile Project Manager: In-House Training

By IIL Europe Ltd

PRINCE2 Agile Foundation: In-House Training

By IIL Europe Ltd

Search By Location