Name: Assessment Based Training - Python Programming & Analytics for the Oil & Gas Sector - Maximising Value from Data Assets
Price: 2799 GBP
Availability: InStock

Redhill

<h3><b>MySQL for developers training course description</b></h3>
        <p>  This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.</li>
<li>Use advanced features of the MySQL Client.</li>
<li>Use advanced data types.</li>
<li>Manage the structure of databases and tables.</li>
<li>Manage and using indexes.</li>
<li>Write complex SQL query statements.</li>
<li>Use advanced SQL expressions.</li>
<li>Use advanced SQL functions.</li>
<li>Perform advanced Insert, Update, Delete, Replace and Truncate Operations.</li>
<li>Use user variable syntax and properties.</li>
<li>Import and export data from within MySQL.</li>
<li>Import and export data from the command line.</li>
<li>Perform complex joins to access multiple tables.</li>
<li>Perform complex subqueries.</li>
<li>Create, manage and us views.</li>
<li>Use prepared statements.</li>
<li>Create and use stored routines.</li>
<li>Create and use triggers.</li>
<li>Obtain database metadata.</li>
<li>Optimize queries.</li>
<li>Work with the main storage engines.</li>
<li>Debug MySQL applications.</li>

                  </ul>
        <h5>
        <b>MySQL for developers training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>MySQL foundation </p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL for developers training course contents</b></h3>
      <ul>
        <li>Introduction </li><p>
Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions.

</p><li>Client/server concepts </li><p>
MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options
<br /><span>Hands on</span> Using client/server

</p><li>The MySQL client program </li><p>
Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities.
<br /><span>Hands on</span> Using the MySQL client program

</p><li>Data types </li><p>
Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options.
<br /><span>Hands on</span> Using data types 

</p><li>Identifiers </li><p>
Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names
<br /><span>Hands on</span> Using identifiers

</p><li>Databases </li><p>
Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command
<br /><span>Hands on</span> Using databases

</p><li>Tables and indexes </li><p>
Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata.
<br /><span>Hands on</span> Creating, altering and dropping tables/indexes

</p><li>Querying for data </li><p>
The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause.
<br /><span>Hands on</span> Querying for data

</p><li>SQL Expressions and functions </li><p>
Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions.
<br /><span>Hands on</span> Using expressions and functions

</p><li>Updating data </li><p>
Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements.
Exercise: Inserting, updating, replacing and deleting data

</p><li>Connectors 	</li><p>
MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached.

</p><li>Obtaining database metadata </li><p>
What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage.
<br /><span>Hands on</span> Obtaining database metadata

</p><li>Debugging 	</li><p>
Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility.
<br /><span>Hands on</span> Debugging

</p><li>Joins </li><p>
Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another.
<br /><span>Hands on</span> Coding joins

</p><li>Subqueries 	</li><p>
Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes.
<br /><span>Hands on</span> Coding subqueries

</p><li>Views </li><p>
Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views.
<br /><span>Hands on</span> Using views

</p><li>Import and Export </li><p>
Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options.
<br /><span>Hands on</span> Importing and exporting

</p><li>User variables and prepared statements </li><p>
Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors.
<br /><span>Hands on</span> Using variables and prepared statements

</p><li>Introduction to stored routines </li><p>
Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security.
<br /><span>Hands on</span> Writing simple stored routines

</p><li>Stored routines - program logic </li><p>
The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Stored routines - exception handlers and cursors </li><p>
Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Procedures with parameters </li><p>
Creating procedures with parameters, Calling Procedures With Parameters.
<br /><span>Hands on</span> Writing stored routines with parameters

</p><li>Functions 	</li><p>
What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses.
<br /><span>Hands on</span> Writing functions

</p><li>Triggers </li><p>
Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges.
<br /><span>Hands on</span> Writing triggers

</p><li>Basic optimizations </li><p>
Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization.
<br /><span>Hands on</span> Making use of basic optimizations

</p><li>More about indexes </li><p>
Indexes and joins
<br /><span>Hands on</span> Investigating indexes and joins
				</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

MySQL for developers

General Admission

<div>
</div>
<section>
<div>
<h2><strong>About this training course</strong></h2>
<p>This 5 full-day course provides a comprehensive understanding of all the commissioning and start-up activities of circulating fluidized bed (CFB) boiler coal power plants. The Commissioning Management System of CFB boiler coal power plants is covered in detail in this course. This includes all the commissioning procedures and documents, purpose of commissioning, responsibilities, system description, organization, working parties, test teams, documentation, testing and commissioning schedules, test reports, safety, plant certification, and plant completion report.</p>
<p>The course provides also a thorough understanding of all the commissioning requirements for CFB boiler and auxiliaries, turbines and auxiliaries, generator and auxiliaries, electrical equipment, switchgear equipment, switchgear, and transformers. All the stages of the commissioning procedure are covered in-depth in this course. This includes preparation - planning various activities, pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures and instructions for every component in a coal power plant, instrumentation, trial run of the equipment, safety and precautions, commissioning of CFB boiler coal power plant systems, Safety Rules Clearance Certificates, procedure for the control and handling of defects, Commissioning Reports.</p>
<p>This course is a MUST for anyone who is involved in the pre-commissioning or commissioning of any CFB boiler coal power plant equipment because it provides detailed pre-commissioning checks and detailed tests and commissioning procedures and instructions for every component in a CFB boiler coal power plant.</p>
<p>In addition, the course provides in-depth coverage of all preparation, planning activities, commissioning schedules, trial run of each CFB boiler coal power plant equipment, safety and precautions, Safety Rules Clearance Certificates, Procedures for handling defects, and Commissioning Reports.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<ul>
<li><strong><span>Pre-Commissioning Checks and Tests, Detailed Tests and Commissioning Procedures and Instructions for Every Equipment in CFB Boiler Coal Power Plants:</span></strong><span> Gain a thorough understanding of all pre-commissioning checks and tests, and all commissioning procedures and instructions for every equipment in CFB boiler coal power plants</span></li>
<li><strong><span>Commissioning Management System of CFB Boiler Coal Power Plants:</span></strong><span> Discover the benefits of the Commissioning Management System of CFB boiler coal power plants including all commissioning procedures and documents, purpose of commissioning, responsibilities, system description, organization, working parties, test teams, documentation, testing and commissioning schedules, test reports, safety, plant certification, and plant completion report</span></li>
<li><strong><span>Commissioning Procedures and Instructions for CFB Boiler and Auxiliaries in Coal Power Plants:</span></strong><span> Learn about the commissioning procedures and instructions for CFB boiler and auxiliaries including all commissioning activities, typical commissioning schedule, hydraulic test and wet preservation, air and gas tightness test, trial run of equipment, electronic precipitators, fuel oil system, preparation for first light up, alkali boil - out, acid cleaning and passivation, thermal flow test of economizer, water walls, and superheater, valves, steam boiling, and safety valve setting</span></li>
<li><strong><span>Commissioning Procedures and Instructions for Turbine and Auxiliaries:</span></strong><span> Gain a thorough understanding of all the commissioning procedures and instructions for turbine and auxiliaries including acid cleaning of oil pipelines, lubrication and governing system (oil flushing and hydraulic testing), jacking oil system, governing system, regenerative system, barring gear, vacuum tightness test, first rolling of turbine and data logging</span></li>
<li><strong><span>Commissioning Procedures and Instructions for Generator and Auxiliaries:</span></strong><span> Discover all the commissioning procedures and instructions for generator and auxiliaries including generator, seal oil system, hydrogen gas system, stator water system, rolling and payment of generator</span></li>
<li><strong><span>Commissioning Procedures and Instructions for Electrical Equipment: </span></strong><span>Learn about all the commissioning procedures and instructions for electrical equipment including switchyard equipment, switchgear, transformers, and motors</span></li>
<li><strong><span>CFB Boiler Coal Power Plant Equipment and Systems:</span></strong><span> Learn about various CFB boiler coal power plant equipment and systems including: CFB boilers, superheaters, reheaters, steam turbines, governing systems, deaerators, feedwater heaters, coal-handling equipment, transformers, generators and auxiliaries</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>

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>'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>CFB BOILER COAL POWER PLANT COMMISSIONING MANUAL (includes practical information about all pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures and instructions for every component and system in CFB boiler coal power plants - 400 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

Commissioning and Start-Up Activities of Coal Power Plants

Team of 10, pp

Normal Fee, pp

<div>
</div>
<section>
<div>
<h2><strong>About this Virtual Instructor Led Training (VILT)</strong><em> </em></h2>
<p>This 4 half-day Virtual Instructor Led Training (VILT) course will address a variety of contract and loan structuring issues associated with geothermal energy projects as well as comparison with solar, wind and battery storage. The course is designed to investigate how various project finance techniques and contract structures can be used to achieve a competitive power prices while maintaining a satisfactory equity return. Distinctive project finance features of power facilities that depend on geothermal, wind, hydro or solar resources will be evaluated with financial models.</p>
<p>The course will cover economic analysis of exploration and development of geothermal facilities and how to incorporate probability of failure and success into an IRR framework. Subsequent sessions will address the theory underlying liquidated damages for delay, and performance as well as design of other incentives that is inherent in different contract structures. Nuanced project finance issues associated with structuring debt for renewable projects will be discussed including under what conditions the DSCR drives debt capacity and when the debt to capital ratio is instrumental.</p>
<p>The course will be taught with a combination of theoretical discussions, term sheet review and focused financial models.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<ul>
<li>Evaluation of the economic risks that arise from uncertainty associated with drilling exploration wells and development wells for geothermal projects.</li>
<li>Analyse the theoretical issues with computing LCOE for geothermal projects compared to other renewable and non-renewable resources and the importance of cost of capital for renewable projects;</li>
<li>Understand differences in contract structures for renewable projects and dispatchable projects and how a single price structure can distort incentives for efficient construction and operation;</li>
<li>Understand components of financing that influence the bid price required to meet a required rate of return on equity and can result in relatively low prices with reasonable returns.</li>
<li>Understand the importance of debt sizing constraints and what strategies are relevant when the debt to capital constraint applies relative to when the debt service coverage ratio drives the debt size;</li>
<li>Understand how to compute P50, P90 and P99 for different projects driven by resource risk;</li>
<li>Understand the difference between mean reverting resource variation and estimation mistakes that do not correct as the basis for 1-year P90 and 10-year P90.</li>
<li>Understand under what conditions debt sculpting can affect returns and how synthetic sculpting can be used to increase returns when the DSCR constraint applies.</li>
<li>Understand the theory of credit spreads, variable rate debt and interest rates in different currencies and compute the implied probability of default that in inherent in credit spreads.</li>
<li>Understand how to evaluate the costs to equity investors and the benefits to lenders for various credit enhancements including DSRA accounts, cash flow sweeps and covenants.</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>The VILT will be delivered online in 4 sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day, including time for lectures, discussion, quizzes and short classroom exercises.</p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader provides financial and economic consulting services to a variety of clients, he teaches professional development courses in an assortment of modelling topics (project finance, M&amp;A, and energy). He is passionate about teaching in Africa, South America, Asia and Europe. Many of the unique analytical concepts and modelling techniques he has developed have arisen from discussion with participants in his courses. He has taught customized courses for MIT's Sloan Business School, Bank Paribas, Shell Oil, Society General, General Electric, HSBC, GDF Suez, Citibank, CIMB, Lind Lakers, Saudi Aramco and many other energy and industrial clients. His consulting activities include developing complex project finance, corporate and simulation models, providing expert testimony on financial and economic issues before energy regulatory agencies, and advisory services to support merger and acquisition projects.</p>
<p>Our key course expert has written a textbook titled Corporate and Project Finance Modelling, Theory and Practice published by Wiley Finance. The book introduces unique modelling techniques that address many complex issues that are not typically used by even the most experienced financial analysts. For example, it describes how to build user-defined functions to solve circular logic without cumbersome copy and paste macros; how to write function that derives the ratio of EV/EBITDA accounting for asset life, historical growth, taxes, return on investment, and cost of capital; and how to efficiently solve many project finance issues related to debt structuring. He is in the process of writing a second book that describes a series of valuation and analytical mistakes made in finance. This book uses many case studies from Harvard Business School that were thought to represent effective business strategies and later turned into valuation nightmares.</p>
<p>Over the course of his career our key course expert has been involved in formulating significant government policy related to electricity deregulation; he has prepared models and analyses for many clients around the world; he has evaluated energy purchasing decisions for many corporations; and, he has provided advice on corporate strategy. His projects include development of a biomass plant, analysis and advisory work for purchase of electricity generation, distribution and transmission assets by the City of Chicago, formulation of rate policy for major metro systems and street lighting networks, advocacy testimony on behalf of low income consumers, risk analysis for toll roads, and evaluation of solar and wind projects. He has constructed many advisory analyses for project finance and merger and acquisition transactions.</p>
<p>Lastly, our key course expert was formerly Vice President at the First National Bank of Chicago where he directed analysis of energy loans and also created financial modelling techniques used in advisory projects. He received an MBA specializing in econometrics (with honours) from the University of Chicago and a BSc in Finance from the University of Illinois (with highest university honours).</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 about post training coaching support and fees applicable for this.</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

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

Geothermal Project Finance Analysis and Modelling

London

<p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Modify the PowerPoint environment</li><li>Using Master View in order to customise a design template</li><li>Add and customize SmartArt graphics</li><li>Add animations and change its effect options</li><li>Add action buttons to control the flow of the presentation</li><li>Use various options to customise slide shows</li><li>Use different PowerPoint file types to distribute presentations</li></ul> <p>' 1 year email support service</p> <p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p><em><strong>Customer Feedback</strong></em></p> <ul> <li> <p><strong>Very clearly explained</strong></p> </li><li> <p><strong>Good pace.</strong></p> </li><li>Lucy Tailor - ACER</li></ul> <p>'</p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Customising the PowerPoint Environment</strong></p> <ul> <li>Customise the User Interface</li><li>Set PowerPoint Options</li></ul> <p><strong>Customising Design Templates</strong></p> <ul> <li>Modify Slide Masters and Slide Layouts</li><li>Add Headers and Footers</li><li>Modify the Notes Master and the Handout Master</li></ul> <p><strong>Adding SmartArt to a Presentation</strong></p> <ul> <li>Create SmartArt</li><li>Modify SmartArt</li></ul> <p><strong>Working with Media</strong></p> <ul> <li>Add Audio to a Presentation</li><li>Add Video to a Presentation</li></ul> <p><strong>Working with Animations</strong></p> <ul> <li>Entrance, Emphasis and Exit Animations</li><li>Animate Charts by Category and Series</li><li>Customise Animations and Transitions</li></ul> <p><strong>Collaborating on a Presentation</strong></p> <ul> <li>Review a Presentation</li><li>Store and Share Presentations on the Web</li></ul> <p><strong>Customising a Slide Show</strong></p> <ul> <li>Annotate a Presentation</li><li>Set Up a Slide Show</li><li>Create a Custom Slide Show</li><li>Add Hyperlinks</li><li>Add Action Buttons</li><li>Record a Presentation</li></ul> <p><strong>Securing and Distributing a Presentation</strong></p> <ul> <li>Secure a Presentation</li><li>Create a Video or a CD</li><li>Distribute the Presentation in different File Formats</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Preferably, delegates should have attended the Powerpoint Introduction course.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p> <p>80 percent of job openings require spreadsheet and word-processing software skills</p> 
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Office Training

Microsoft Powerpoint Advanced - In-company (now with live online classes)

Thetford

<header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><article fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This half day course is designed for new treasurers, general trustees and management committee members or staff who work in smaller organisations to understand the basics of how to manage the finances within a voluntary or community organisation. It covers all the essential issues ranging from drawing up a budget to ensuring that the organisation has sound financial procedures.</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;">Areas covered</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Components of good financial management</li><li fr-original-style="" style="box-sizing: border-box;">How to draw up a budget and monitor this throughout the year</li><li fr-original-style="" style="box-sizing: border-box;">How to develop and monitor a cash flow forecast</li><li fr-original-style="" style="box-sizing: border-box;">Full cost recovery</li><li fr-original-style="" style="box-sizing: border-box;">Building up reserves</li><li fr-original-style="" style="box-sizing: border-box;">Producing the annual accounts</li><li fr-original-style="" style="box-sizing: border-box;">Developing simple but effective financial procedures</li><li fr-original-style="" style="box-sizing: border-box;">Typical financial issues that occur in VCS organisations..</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course could be run as part of a training programme or could be run in house.</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;">In-house courses&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is designed to be flexible so that it can accommodate the specific needs of a particular organisation or agency. For example, the course could be designed around the planning of a particular event or series of events. The course could be extended in length to a whole day if necessary.</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;">Objectives</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">To help participants understand their financial responsibilities as treasurers, trustees or management committee members</li><li fr-original-style="" style="box-sizing: border-box;">To introduce a number of good practices in managing finances which can be done simply and without too much paperwork</li><li fr-original-style="" style="box-sizing: border-box;">To ensure participants understand how to draw up a simple budget and cash flow forecast</li><li fr-original-style="" style="box-sizing: border-box;">To ensure participants understand a few of the technical issues of managing finance such as &ldquo;restricted&rdquo; and &ldquo;unrestricted&rdquo; funding, &ldquo;revenue&rdquo; and &ldquo;capital&rdquo; income and expenditure..</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Target Audience</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">People working or volunteering in the voluntary and community sector, including trustees or management committee members and those working in statutory agencies who work closely with VCS groups or community projects. The course can be adapted to suit particular needs.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Cost</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">From &pound;150 + travel costs</p></article></div></header></header><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><br fr-original-style="" style="box-sizing: border-box;"></div>

SAVO CIC

Budgeting

This half day course is designed for new treasurers, general trustees and management committee members or staff who work in smaller organisations to understand the basics of how to manage the finances within a voluntary or community organisation. It covers all the essential issues ranging from drawing up a budget to ensuring that the organisation has sound financial procedures.

Managing Your Finances

<div fr-original-style="" style="box-sizing: border-box;">
</div>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Training Course</strong></h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In our pursuit to discover oil &amp; gas in deeper horizons, wells are often drilled in a HPHT environment. To be considered a HPHT well, the downhole conditions will have pressures in excess of 10,000 psi (69 MPa) and 300&Acirc;&deg; F (150&Acirc;&deg; C). To drill these usually expensive wells successfully, the planning and execution phase has to be of an exceptionally high standard. Therefore, both operator and drilling/service contractor staff must be seamlessly aligned and work as a coherent team to reach and then harness the well objectives. This is particularly important when speciality services such as Managed Pressure Drilling (MPD) are being applied with crews and/or supervisors who are not intricately familiar with complicated well control incidents. As we seek to prevent costly non-productive time, attention will also be paid to enabling technologies like expandable solid tubulars, mud coolers and specialty mud.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The 3 full-day course will explain the key characteristics and challenges of HPHT Planning and Well Control. This includes:</p>
<ol fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Differences between HPHT and standard (conventional) wells and what this entails for well design.</li>
<li fr-original-style="" style="box-sizing: border-box;">The challenges unique to HPHT and the impact of Pore Pressure Prediction (PPP).</li>
<li fr-original-style="" style="box-sizing: border-box;">Static and Dynamic Equivalent Mud Density and the factors that influence the ultimate Bottom Hole Pressure (BHP).</li>
<li fr-original-style="" style="box-sizing: border-box;">Control practices such as &#39;fingerprinting&#39; to identify what&#39;s happening downhole.</li>
<li fr-original-style="" style="box-sizing: border-box;">HPHT shut-in procedures and practices.</li>
<li fr-original-style="" style="box-sizing: border-box;">Specific HPHT equipment and drilling tool requirements and advantages of Managed Pressure Drilling (MPD).</li>
<li fr-original-style="" style="box-sizing: border-box;">Well control on/off bottom, bull-heading and dealing with kick-loss situations.</li>
<li fr-original-style="" style="box-sizing: border-box;">Mud management, tolerance on mud properties and challenges in cementing.</li>
<li fr-original-style="" style="box-sizing: border-box;">Case history on emergency control.</li>
<li fr-original-style="" style="box-sizing: border-box;">Drills, team effort, checklists, human factor and &#39;getting everybody on board&#39;.</li>
</ol>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div id="accordion" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Training Objectives 

</div>
<div id="collapseOne" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of this course, participants will be able to:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Recognize the main differences in planning/design between HPHT and standard (conventional) wells as well as the challenges that will have to be faced.</li>
<li fr-original-style="" style="box-sizing: border-box;">Explain drilling and tripping operational challenges and practices as well as how to manage these effectively.</li>
<li fr-original-style="" style="box-sizing: border-box;">Identify wellbore breathing (a.k.a. ballooning) and how to safely deal with this within the narrow window for mud density selection.</li>
<li fr-original-style="" style="box-sizing: border-box;">Apply practices of consistent fingerprinting and how to develop procedures for this to benefit the rig team.</li>
<li fr-original-style="" style="box-sizing: border-box;">Measure and understand bottom hole pressure and the effect of influencing factors such as temperature, rotation and flow rate.</li>
<li fr-original-style="" style="box-sizing: border-box;">Understand the critical mud properties to alleviate barite sag, general mud density control techniques and specify the essentials in cementing.</li>
<li fr-original-style="" style="box-sizing: border-box;">Manage losses and low fracture gradients with well bore strengthening methods.</li>
<li fr-original-style="" style="box-sizing: border-box;">Execute sound HPHT shut-in procedures.</li>
<li fr-original-style="" style="box-sizing: border-box;">Understand how MPD can assist in the safe and efficient drilling and hole cleaning of HPHT wells.</li>
<li fr-original-style="" style="box-sizing: border-box;">Understand the use of MPD Influx Management Envelopes.</li>
<li fr-original-style="" style="box-sizing: border-box;">Identify critical Early Kick Detection Systems (EKDS) and HPHT well control equipment.</li>
<li fr-original-style="" style="box-sizing: border-box;">Execute safe secondary well control practices in a H2S environment, bull-heading, on and off bottom and handling of gas at surface, using MGS and hydrate mitigation measures.</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Target Audience 

</div>
<div id="collapseTwo" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is intended for:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Office-based staff engaged in HPHT well planning and day-to-day operations</li>
<li fr-original-style="" style="box-sizing: border-box;">Field-based rig staff working as front-line supervisors - from Assistant Drillers to Senior Toolpushers</li>
<li fr-original-style="" style="box-sizing: border-box;">Field-based rig staff working for service companies supporting the execution of HPHT wells (MPD, mud and mudlogging services etc.)</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Trainer

</div>
<div id="collapseFive" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert course leader has over 45 years of experience in the Oil &amp; Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil &amp; gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of &#39;doing-the-basics&#39; are still reaped today when standing in front of a class.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company&#39;s learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come.</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &#39;One to One&#39; 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 fr-original-style="" style="box-sizing: border-box;">
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Accreditions And Affliations

</div>
<div id="collapseSeven" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
               </div>
</div>
</div>
</div>
</section>

HPHT Planning and Well Control

<div fr-original-style="" style="box-sizing: border-box;">
</div>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Training Course</strong><em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em></h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 3 full-day training course will introduce participants to the Microsoft Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The first two days focus on learning the key concepts and practising these using clean, simple datasets.&nbsp;The third day provides participants with the opportunity to apply what they&#39;ve learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn&#39;t be able to do what they need to do.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an introductory course and although it does not assume any prior experience with Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>, participants will gain much more from the course if they have at least used Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;a little prior to attending. Participants who have taught themselves Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.</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;"><em fr-original-style="" style="box-sizing: border-box;">Microsoft&reg;&nbsp;PowerBI&reg; is a&nbsp;trademark&nbsp;of Microsoft Corporation in the United States and/or other countries.</em></strong></p>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div id="accordion" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Training Objectives 

</div>
<div id="collapseOne" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Upon completion of this training course, participants will be able to:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Confidently use the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;solution, including Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;Desktop, PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com and the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;Gateway</li>
<li fr-original-style="" style="box-sizing: border-box;">Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis</li>
<li fr-original-style="" style="box-sizing: border-box;">Combine data sources together and gain an introductory understanding of the M language</li>
<li fr-original-style="" style="box-sizing: border-box;">Write formulas using the DAX language for generating custom columns, measures and tables</li>
<li fr-original-style="" style="box-sizing: border-box;">Design reports and dashboards using a wide range of both built-in and custom visuals</li>
<li fr-original-style="" style="box-sizing: border-box;">Publish reports and dashboards to PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com</li>
<li fr-original-style="" style="box-sizing: border-box;">Share reports and dashboards with others using PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com</li>
<li fr-original-style="" style="box-sizing: border-box;">Customize reports and dashboards so that different user groups automatically see their own personalized views</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Target Audience 

</div>
<div id="collapseTwo" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training course is intended for:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Financial Analysts</li>
<li fr-original-style="" style="box-sizing: border-box;">Accountants</li>
<li fr-original-style="" style="box-sizing: border-box;">Budgeting and planning specialists</li>
<li fr-original-style="" style="box-sizing: border-box;">Treasury</li>
<li fr-original-style="" style="box-sizing: border-box;">Risk Managers</li>
<li fr-original-style="" style="box-sizing: border-box;">Strategic Planners</li>
</ul>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an introductory course and although it does not assume any prior experience with Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>, participants will gain much more from the course if they have at least used Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;a little prior to attending. Participants who have taught themselves Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Course Level 

</div>
<div id="collapsecl" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Trainer

</div>
<div id="collapseFive" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert course leader has a Masters (Applied Finance &amp; Investment), B.Comm (Accounting &amp; Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years&#39; experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">He has trained delegates from a wide variety of Oil &amp; Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing.</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;">Highlights from his oil and gas experience include:</strong></p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil &amp; gas assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Auditing and further development of life of project models for Chevron&#39;s Strategic Planning Division analysing their North West Shelf assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Development of business plan and budgeting models for multinational oil &amp; gas assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Development of cash flow and taxation models for a variety of oil gas companies.</li>
<li fr-original-style="" style="box-sizing: border-box;">Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment.</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &#39;One to One&#39; 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 fr-original-style="" style="box-sizing: border-box;">
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Accreditions And Affliations

</div>
<div id="collapseSeven" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
               </div>
</div>
</div>
</div>
</section>

Power BI® - Business Data Analytics

Kuala Lumpur

<section id="isPasted" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(62, 57, 52); box-sizing: border-box;" fr-original-style=" color: rgb(62, 57, 52);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Training Course</strong></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Nearly half of the world&rsquo;s petroleum regimes involve some form of production sharing between Contractors and their Host Country. This 3 full-day course examines the operational, fiscal and legal aspects of the different types of Production Sharing Contracts (PSC) in use around the world.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Fiscal System of the PSC is analysed using discounted cash-flow model to illustrate the impact on investment criteria such as net present value, internal rate of return and pay-out from changes in factors such as cost recovery, profit sharing, royalty and income tax.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In addition to the provisions within the four-corners of the PSC, the agreements related to the various stages of petroleum operations such as Bidding, Exploration, Development, Production and Decommissioning are examined. They include joint venture operations, drilling and well services and agreements for the sale of crude oil and natural gas. Discussions of these agreements will be illustrated with the use of detailed Checklists.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The final session covers emerging issues that will impact the future of PSC operations such as International Dispute Resolution, transfer of Late Life Assets, Global Climate Change, and International and Bilateral Investment Treaties and Trade Sanctions.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course can also be offered through Virtual Instructor Led Training (VILT) format.</p></section><section fr-original-style="" style="box-sizing: border-box;"><a data-toggle="collapse" href="https://petroedgeasia.net/training/production-sharing-contracts-psc-related-agreements/#collapseOne" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINING OBJECTIVES</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By attending this Training Course, the participants will will be able to:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Understand</strong>&nbsp;the types of PSCs used by host governments to promote the exploration and development of their petroleum resources.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Discuss and apply</strong>&nbsp;economic decision-making criteria that is relevant to petroleum development.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Understand</strong>&nbsp;the various types of commercial agreements related to petroleum operations under a PSC.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Develop</strong>&nbsp;a strategy for negotiating the terms and conditions of the PSC and related agreements.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Effectively participate</strong>&nbsp;in operational decisions concerning emerging issues that affect PSC operations.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Specific focus is given to:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">The structure of a PSC in terms of Commercial, Technical, Legal and Administrative provisions</li><li fr-original-style="" style="box-sizing: border-box;">The interrelationship between contract provisions and economic decisions</li><li fr-original-style="" style="box-sizing: border-box;">Explanation and analysis of key provisions in service, construction and sales contracts that are used in implementing a PSC</li><li fr-original-style="" style="box-sizing: border-box;">Key risk management decisions that are addressed in the context of these PSC related contracts</li><li fr-original-style="" style="box-sizing: border-box;">Emerging issues that will impact the management of operations under a PSC.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After attending this course, participants will be better equipped to participate in the management of petroleum operations that are conducted under the umbrella of a Production Sharing Contract, whether as operator, national oil company, or host government.</p></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/production-sharing-contracts-psc-related-agreements/#collapseTwo" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TARGET AUDIENCE</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will benefit:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Commercial managers</strong>&nbsp;in the oil and gas sector looking to improve their contract negotiation skills and overall commercial performance</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Contract managers</strong>&nbsp;for operators or national oil companies</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Policy makers and regulators</strong>&nbsp;in the petroleum sector</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Legal practitioners</strong>&nbsp;looking to specialise in petroleum agreements</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Insurance and risk managers</strong>&nbsp;looking to reduce the legal and contracts risks for their companies</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/production-sharing-contracts-psc-related-agreements/#collapsecl" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">COURSE LEVEL</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Intermediate</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/production-sharing-contracts-psc-related-agreements/#collapseFive" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINER</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert course leader previously served as General Counsel for a petroleum and mineral appraisal and consulting firm based in Colorado. He supports clients in business transactions and finance, particularly in the energy industry, and helps clients navigate international business opportunities. He provides consulting services to foreign government entities working in the petroleum and power sectors. He also supports domestic clients with mineral rights and business law matters. He is licensed to practice law in the State of Wyoming and the State of Colorado, as well as the Federal District of Wyoming.</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;">His previous engagement includes:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Petroleum Regulator Organizational Strategy and Management in Bosnia</strong>&nbsp;</em> &ndash; Legal and regulatory specialist responsible for providing organizational strategy and management advisory assistance to government entities responsible for petroleum management and regulation, reviewing bid round documents, concession agreements and legislation affective petroleum management, and providing other legal, regulatory and policy support to the government. 2019-2020.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Onshore/Offshore Petroleum Regulatory Development in Romania</strong></em> &ndash; International legal and regulatory specialist responsible for reviewing petroleum data management and technical oversight practices, providing input on fiscal analysis and terms, development of offshore regulatory framework, and providing technical trainings on leading practices in petroleum legal, regulatory, fiscal, and policy issues.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">International Petroleum Contracts and Legal Analysis in Albania</strong>&nbsp;</em>&ndash; International oil and Gas specialist role providing legal and policy advice to Albania&rsquo;s petroleum regulator, designed and presented a two-day course on production sharing contracts, supported capacity building initiatives and improved petroleum policy development in Albania, supported legal and regulatory aspects of the petroleum tender and bidding process. 2018-2020.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Natural Gas Legal and Regulatory Development in Honduras</strong></em> &ndash; Natural Gas legal expert responsible for supporting Honduras&rsquo;national electrical utility with natural Gas and LNG legal, regulatory and policy advice, reviewed natural Gas legal and regulatory frameworks from surrounding jurisdictions and prepared a report and presentation to discuss specific challenges related to natural Gas development and utilization in Honduras.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Shale Gas Legal and Regulatory Analysis in Western Cape Province, South Africa</strong></em> &ndash; Legal and regulatory specialist responsible for reviewing provincial and municipal approaches to shale Gas regulation for a proposed onshore shale Gas project in the Karoo Basin, worked on behalf of provincial government to improve government collaboration and coordination for large scale industrial development and assisted with development of municipal-level regulatory practices.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Gas-to-Power Generation Policy Development in Nigeria</strong>&nbsp;</em>&ndash; Natural Gas legal and regulatory specialist responsible for reviewing Gas-to-power market arrangements, government natural Gas policies and governance/financial structures to identify areas for improvement to national meet power generation goals. 2017-2018 Client: U.S. Department of State &ndash; Energy Governance and Capacity Initiative.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Sri Lanka Petroleum Legal and Regulatory Support</strong>&nbsp;</em>&ndash; Legal and regulatory expert charged with reviewing and developing key areas of national petroleum regulatory policy, review of contracts and building capacity within the Ministry of Petroleum Resources Development and Petroleum Resources Development Secretariat.</p></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/production-sharing-contracts-psc-related-agreements/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">POST TRAINING COACHING SUPPORT (OPTIONAL)</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &ldquo;One to One&rdquo; 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 fr-original-style="" style="box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Request%20for%20further%20information%20regarding%20post%20training%20coaching%20support" target="_blank" rel="noopener" style="color: rgb(0, 123, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 123, 255);">Request for further information about post training coaching support</a>&nbsp;and fees applicable for this.</p></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/production-sharing-contracts-psc-related-agreements/#collapseSeven" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">ACCREDITIONS AND AFFLIATIONS</a></section><p style="color: rgb(255, 255, 255); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"> </p>

Legal

Economics

Gain a deep understanding of Production Sharing Contracts (PSC) and related agreements through our expert-led course. Enroll now and excel in your field with EnergyEdge.

Production Sharing Contracts (PSC) & Related Agreements

<header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><article fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This half day course is designed for new treasurers, general trustees and management committee members or staff who work in smaller organisations to understand the basics of how to manage the finances within a voluntary or community organisation. It covers all the essential issues ranging from drawing up a budget to ensuring that the organisation has sound financial procedures.</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;">Areas covered</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Components of good financial management</li><li fr-original-style="" style="box-sizing: border-box;">How to draw up a budget and monitor this throughout the year</li><li fr-original-style="" style="box-sizing: border-box;">How to develop and monitor a cash flow forecast</li><li fr-original-style="" style="box-sizing: border-box;">Full cost recovery</li><li fr-original-style="" style="box-sizing: border-box;">Building up reserves</li><li fr-original-style="" style="box-sizing: border-box;">Producing the annual accounts</li><li fr-original-style="" style="box-sizing: border-box;">Developing simple but effective financial procedures</li><li fr-original-style="" style="box-sizing: border-box;">Typical financial issues that occur in VCS organisations.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course could be run as part of a training programme or could be run in house.</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;">In-house courses</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is designed to be flexible so that it can accommodate the specific needs of a particular organisation or agency. The course could be run, for example, for a trustee board or management committee so that they understand how finances should be managed.</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;">Objectives</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">To help participants understand their financial responsibilities as treasurers, trustees or management committee members</li><li fr-original-style="" style="box-sizing: border-box;">To introduce a number of good practices in managing finances which can be done simply and without too much paperwork</li><li fr-original-style="" style="box-sizing: border-box;">To ensure participants understand how to draw up a simple budget and cash flow forecast</li><li fr-original-style="" style="box-sizing: border-box;">To ensure participants understand a few of the technical issues of managing finance such as &ldquo;restricted&rdquo; and &ldquo;unrestricted&rdquo; funding, &ldquo;revenue&rdquo; and &ldquo;capital&rdquo; income and expenditure.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Target Audience</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">People working or volunteering in the voluntary and community sector, including trustees or management committee members and those working in statutory agencies who work closely with VCS groups or community projects. The course can be adapted to suit particular needs.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Cost</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">From &pound;150 + travel costs.</p></article></div></header></header></header></header></header></header></header></header></header></header></header></header></header></header></header></header></header></header><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><br fr-original-style="" style="box-sizing: border-box;"></div>

Finance

Finance Made Easy

<section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><h2 style="color: rgb(62, 57, 52); box-sizing: border-box;" fr-original-style=" color: rgb(62, 57, 52);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Classroom Training</strong></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In the upcoming digital era, Python stands out as the language of the future for effective AI and data analytics implementation, particularly in the Oil and Gas sector. Its widespread adoption is attributed to extensive libraries, versatility, and a thriving community of developers consistently pushing the boundaries of the field. This training course will tailor a transformative learning experience for professionals in oil and gas.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Commencing with overview in the computer programming, participants delve into programming fundamentals and set up their Python coding environment. Participants will be able to explore flow control tools and functions, unlocking the full potential of Python. Furthermore, participants will gain expertise in various programming paradigms, with a particular focus on Object-Oriented Programming (OOP), a crucial foundation for building sophisticated applications.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants will navigate through file handling, internal modules, and external libraries like NumPy, Pandas, and Matplotlib, providing proficiency in data manipulation and visualization tailored for the challenges of real-life projects. Through a hands-on Data Analytics Project, participants will apply their skills to a real-world dataset, derive insights, and present findings.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This comprehensive workshop equips professionals with the tools for effective automation and data analytics in the Oil and Gas sector. Participants will experience a robust understanding of Python&rsquo;s applications, ready to drive impactful and data-driven initiatives in their professional journey.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will be delivered face-to-face over 5-day sessions, comprising of 8 hours per day, 1 hour lunch and 2 breaks of 15 minutes per day. Course Duration: 8 hours in total, 40 CPD points. Maximum number of participants: 30</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download your brochure</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Please Send me the Brochure for Assessment Based Training – Python Programming & Analytics for the Oil & Gas Sector – Maximising Value from Data Assets" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Email me the brochure</a></p></section><section style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseOne" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TRAINING OBJECTIVES</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Acquire a comprehensive understanding of Python syntax, including variables, data types, and fundamental programming constructs.</li><li fr-original-style="" style="box-sizing: border-box;">Apply Python programming skills to analyze industry-specific datasets, extracting meaningful insights that can inform decision-making and operational efficiency.</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate the ability to automate routine tasks and streamline workflows within the Oil and Gas sector using Python.</li><li fr-original-style="" style="box-sizing: border-box;">Develop practical solutions and strategies using Python programming for challenges commonly faced in the industry, fostering hands-on experience and problem-solving capabilities.</li><li fr-original-style="" style="box-sizing: border-box;">Gain insights into emerging trends in digital technology within the industry and how Python can be leveraged for continuous adaptation and innovation.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseTwo" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TARGET AUDIENCE</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">All Engineers and Technologists from diverse fields who are interested in utilizing Python programming and data analytics techniques to explore and address challenges within their respective domains.</li><li fr-original-style="" style="box-sizing: border-box;">Data Analysts and Scientists who working with data generated by sensors, monitoring equipment, and other sources within the industry.</li><li fr-original-style="" style="box-sizing: border-box;">IT and Automation Specialists who responsible for designing and implementing IT solutions and automation systems as well as who involve in developing and maintaining software application in the Oil and Gas sector.</li><li fr-original-style="" style="box-sizing: border-box;">Executives and Managers seeking a strategic understanding of how Python and data analytics can impact decision-making and operational efficiency in the industry.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals who interest in applying Python programming and data analytics techniques to study and solve challenges in the Oil and Gas field.</li><li fr-original-style="" style="box-sizing: border-box;">Individuals from related industries or backgrounds who are transitioning into roles within the Oil and Gas sector and wish to acquire relevant Python skills.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals from diverse backgrounds who recognize the growing importance of data analytics in the Oil and Gas sector and wish to enhance their skill set.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapsecl" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE LEVEL</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Basic</li><li fr-original-style="" style="box-sizing: border-box;">Intermediate</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseThree" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TRAINING METHODS</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The trainer will employ the &lsquo;learning by doing&rsquo; method by emphasizing practical application. Participants will be introduced to the concepts and theories using techniques that they can easily relate to. The learning experience is then reinforced by implementing the subject through real-life examples. The trainer will provide quizzes and tests for self-assessment and ensuring participants can measure their understanding and apply the knowledge effectively. This hands-on approach not only enhances comprehension but also empowers participants to confidently apply the learned skills in their professional endeavors.</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;">Preparation ahead of the Class:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants are required to download the&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python 3.x</strong>&nbsp;version software onto their laptops.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The instructions are provided below:</p><ol fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Download&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Anaconda</strong>&nbsp;by visiting the Anaconda website (https://www.anaconda.com/products/distribution).</li><li fr-original-style="" style="box-sizing: border-box;">Click on the &ldquo;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Download</strong>&rdquo; button for the version that suits your operating system (Windows, macOS, Linux).</li><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Select the&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python 3.x</strong>&nbsp;version (e.g., Python 3.8) during the installation process.</li><li fr-original-style="" style="box-sizing: border-box;">Install Anaconda follow the instructions to run the installer. Install Just Me (Recommended).</li></ol></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseFive" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TRAINER</strong></a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert trainer is a seasoned multidisciplinary engineer with a 15-year professional journey, driven by an unwavering commitment to innovation and excellence. Armed with a Ph.D. in offshore engineering, he draws extensive insights from diverse industry sectors, notably oil and gas, where he served as a subsea pipeline engineer. His hands-on experience encompasses the entire spectrum, from design and manufacturing to installation and operations of offshore oil and gas facilities.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Previously at Rosen Group, your expert trainer developed digital tools for offshore structural assessments and risk-based inspection. He led research at the ARC Offshore Floating Facilities Hub on enhancing riser design and monitoring using Python and data analytics. He performed design verification for INPEX, Chevron, and Apache on subsea pipelines, risers, umbilicals, and LNG facilities, and was a deputy project manager on verifying the Ichthys gas pipeline. He conducted risk-based inspection and auditing of the Ichthys LNG plant for DNV GL. He also worked as a structural engineer at Advanced Building Engineers designing steel structures, buildings, and other components. Meanwhile, at the University of Western Australia (UWA), your expert trainer developed AI and data solutions for the oil &amp; gas industry focused on condition monitoring and probabilistic assessments and led research on offshore facilities by creating tools for analysis and machine learning.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">His academic pursuit culminated in a thesis that underscores his proficiency in employing data science and machine learning, primarily through Python. His research focused on optimising asset integrity management for offshore oil and gas assets, showcasing a seamless integration of engineering and cutting-edge technology. In 2023, he fully unleash AI-driven solutions across diverse sectors. Currently, he actively contributes to mineral resource exploration and assists oil and gas operators in the effective implementation of new AI and digital technologies.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">His dedication to knowledge dissemination is evident through his role as a global educator. Over the past five years, he has conducted Python programming lectures at universities and industries, reaching over 1000 novices. His unwavering commitment to lifelong learning, coupled with a growth mindset have positions him as a transformative trainer in the realms of applied AI, data science, and engineering in oil and gas sector</p><section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download your brochure</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Please Send me the Brochure for Assessment Based Training – Python Programming & Analytics for the Oil & Gas Sector – Maximising Value from Data Assets" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Email me the brochure</a></p></section></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/assessment-based-training-python-programming-analytics-for-the-oil-gas-sector-maximising-value-from-data-assets/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">POST TRAINING COACHING SUPPORT (OPTIONAL)</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &ldquo;One to One&rdquo; 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 fr-original-style="" style="box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Request%20for%20further%20information%20regarding%20post%20training%20coaching%20support" target="_blank" style="color: rgb(0, 123, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 123, 255);">Request for further information post training support</a>&nbsp;and fees applicable.</p></div></section>

Machine Learning (ML)

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.

Assessment Based Training - Python Programming & Analytics for the Oil & Gas Sector - Maximising Value from Data Assets

<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

154 Courses in Leicester

MySQL for developers

By Systems & Network Training

Commissioning and Start-Up Activities of Coal Power Plants

By EnergyEdge - Training for a Sustainable Energy Future

Geothermal Project Finance Analysis and Modelling

By EnergyEdge - Training for a Sustainable Energy Future

Microsoft Powerpoint Advanced - In-company (now with live online classes)

By Microsoft Office Training

Managing Your Finances

By SAVO CIC

HPHT Planning and Well Control

By EnergyEdge - Training for a Sustainable Energy Future

Power BI® - Business Data Analytics

By EnergyEdge - Training for a Sustainable Energy Future

Production Sharing Contracts (PSC) & Related Agreements

By EnergyEdge - Training for a Sustainable Energy Future

Finance Made Easy

By SAVO CIC

Assessment Based Training - Python Programming & Analytics for the Oil & Gas Sector - Maximising Value from Data Assets

By EnergyEdge - Training for a Sustainable Energy Future

Search By Location