Name: Electricity Pricing and Marginal Cost Analysis - Virtual Instructor Led Training (VILT)
Price: 1399 GBP
Availability: InStock

<div>
</div>
<section>
<div>
<p></p>
<h2><strong>About this Training Course </strong></h2>
<p>This 5 full-day training course looks at the setup of economic analysis cases, including the estimation of recoverable reserves, production profiles, commodity prices, and project costs - CAPEX, OPEX, taxes, royalties, transportation, depreciation, before-tax (BTAX) cash-flow, after-tax (ATAX) cash-flow and international fiscal regimes (production sharing agreement and concessionary system). The course begins from the basic required parameters of inflation, interest and time value of money. These concepts are then transformed into profitability indicators. Last but not the least, the profitability indicators are then used to make investment decisions.</p>
<p>The emphasis of this course is to bridge the gap between theoretical concepts and their practical limitations. The participants will be able to appreciate the amount of information that they never thought of. Another emphasis of this course is also on the use of Excel's financial functions. This understanding is very critical when it comes to building economic cash-flow models. Over the years, we have seen that participants really struggle with using the Excel functions correctly and this leads to mistakes that can be easily avoided.</p>
<p>In each session, multiple choice problems are provided to participants to reinforce their understanding of the concepts covered in the course. Many quick or tips not widely known, are also shared with the participants. The concepts covered in this course are not restricted to downstream, upstream or petrochemical projects. These concepts can be used to evaluate any type of investment under consideration. <strong>Participants will require access to computers/laptops with Excel to solve problems during the course.</strong></p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>Upon completion of this course, participants will be able to fully understand the gas market dynamics and Investment Evaluation. They will be able to:</p>
<ul>
<li>Learn how to reduce exposure and mitigate risks in projects by handling uncertainty</li>
<li>Clarify concepts such as time value of money, cash-flow models, capital budgeting, IRR, NPV, income producing investments</li>
<li>Maximise the return on investments through good decision-making processes based on the commercial viability of projects</li>
<li>Improve their decision process, investment and opportunity analysis</li>
<li>Acquire the hands-on experience in building their own economic evaluation models and solving case study-based examples</li>
</ul>
<p> </p>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>The following oil &amp; gas company personnel will benefit from the knowledge shared in this course:</p>
<ul>
<li>Facilities and Planning engineers</li>
<li>Project and procurement personnel</li>
<li>Oil &amp; gas engineers</li>
<li>Geologists</li>
<li>Financial Analysts</li>
<li>Commercial managers</li>
<li>Economists</li>
<li>Government officials</li>
<li>Business advisors</li>
<li>Asset managers</li>
<li>E&amp;P managers</li>
<li>Product and business development personnel</li>
</ul>
<p> </p>
</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> </p>
<p> </p>
</div>
</div>
</div>
<div>
<div>

Organisational Impact

</div>
<div id="collapseFour">
<div>
<p> </p>
<p> </p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader is a globally recognised subject matter expert in petroleum/project economics and international gas market analysis. <strong>He is a recipient of the 2021 Society of Petroleum Engineers (SPE) International Management Award</strong>, an award that recognises individuals who make significant technical and professional contributions to the petroleum engineering profession and to the worldwide oil and gas industry.</p>
<p>He has 40 years of diversified experience in petroleum engineering, reservoir engineering, project economics and decision analysis. He had been involved in evaluating multi-billion-dollar oil and gas field development, NGL, LNG, GTL, Aluminum smelter, refinery, petrochemical, power and production sharing projects. He has worked with major oil companies such as Saudi Aramco, ZADCO, Qatar Petroleum and companies in USA. He is a registered professional Engineer in the state of Colorado, USA.</p>
<p>He is the author of six books:</p>
<ol>
<li>Petroleum Engineering Handbook for the Practicing Engineer, Vol. I and Vol. II, published by PennWell Books, Tulsa, Oklahoma, USA.</li>
<li>Project Economics and Decision Analysis, Vol. I and Vol. II, published by PennWell Books, Tulsa, Oklahoma, USA. These books are used as textbooks in universities worldwide to teach petroleum economics to undergraduates and graduate students.</li>
<li>Tip &amp; Tricks in Excel based Financial Modeling, Vol. 1 &amp; 2, published by Business Expert Press, New York, USA.</li>
</ol>
<p>He has also authored several papers in the Oil &amp; Gas Journal, The Log Analyst, World Oil, SPE Journals, and Oil &amp; Gas Financial Journal. He has delivered lectures in more than 25 countries around the globe. He has always received excellent feedback, as an expert presenter, from the participants of his courses.</p>
</div>
</div>
</div>
<div>
<div>

Daily daily_agenda 

</div>
<div id="collapseSix">
<div>
<p> </p>
<p> </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

Project Economics, Risk and Decision Analysis for Oil & Gas

Team of 10, pp

Normal Fee, pp

<h4>Overview</h4>
						<hr />
						<div></div>
							<p>
							</p><p>In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models.</p>

<p>Objectives</p>

<ul>
	<li>
	<p>Harness Excel's tools within a best practice framework</p>
	</li>
	<li>
	<p>Add flexibility to their models through the use of switches and flexible lookups</p>
	</li>
	<li>
	<p>Work efficiently with large data volumes</p>
	</li>
	<li>
	<p>Model debt effectively</p>
	</li>
	<li>
	<p>Approach modelling for tax, debt, pensions and disposals with confidence</p>
	</li>
	<li>
	<p>Build flexible charts and sensitivity analysis to aid the presentation of results</p>
	</li>
	<li>
	<p>Learn and apply Excel tools useful in financial forecasting</p>
	</li>
	<li>
	<p>Understand and design the layout of a flexible model</p>
	</li>
	<li>
	<p>Forecast financial statements of a public or private company</p>
	</li>
	<li>
	<p>Apply scenario analysis to the forecasted financial statements and prepare charts for data presentation</p>
	</li>
</ul>
<p>
							
							</p><div>
						
					</div>

GBA Corporate

Financial Modelling for Budgeting and Forecasting in Excel

Online

On Site

<h4>Overview</h4>
						<hr />
						<div></div>
							<p>
							</p><p>The development of effective and realistic business/financial models is a critical tool in today's value-driven organization. As shareholders are increasingly concerned with the value of their investments, organizations are continually driven to ensure the optimum use of resources. Using Excel®, the Business &amp; Financial Modelling process provides an effective tool with which the potential outcomes of various strategic and tactical initiatives can be projected.</p>

<p>This comprehensive five-day programme takes you through the modelling process from start to finish. It provides practical examples and applications of modelling for both strategic and tactical executives.</p>
<p>
							
							</p><div>
						
					</div>

Business and Financial Modelling

<h4>Overview</h4>
						<hr />
						<div></div>
							<p>
							</p><p>Business modelling requires analysts to produce the quantitative models that top management uses to support their decision-making, but top management must also understand the strengths and weaknesses of the models if they are to use them effectively to support their decisions and robustly navigate the strategic negotiation landscape.</p>

<p>This is particularly important for PPP projects where long-term commitments are made now based on bankability, value for money and risk allocation. During the course, participants will gain knowledge and skills on the frameworks, tools, and methodologies necessary to build quantitative models for financial decision-making in order to improve the financial viability and bankability of PPP projects. Participants will master modelling frameworks on capital budgeting, risk measurement, regression analysis and Monte Carlo Simulation among others.</p>
<p>
							
							</p><div>
						
					</div>

Financial Modelling and Analysis in Project Financing

<h4>Overview</h4>
						<hr />
						<div></div>
							<p>
							</p><p>This is particularly important for PPP projects where long-term commitments are made now based on bankability, value for money and risk allocation. During the course, participants will gain knowledge and skills on the frameworks, tools, and methodologies necessary to build quantitative models for financial decision-making in order to improve the financial viability and bankability of PPP projects. Participants will master modelling frameworks on capital budgeting, risk measurement, regression analysis and Monte Carlo Simulation among others.</p>
<p>
							
							</p><div>
						
					</div>

PPP PROJECT FINANCIAL MODELLING

London

<h2>Better Business Cases™ Foundation and Practitioner: In-House Training</h2>
<p>Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives.</p>
<p>The goal of the combined foundation and practitioner course is to develop a candidate's ability to deliver a comprehensive business case through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this course, a candidate will be able to start applying the model to a real business case development project.</p>
<p>The outline presented in the course overview will be addressed in the first 2 days, with the Foundation exam conducted on the morning of Day 3. Then the topics will be revisited at a deeper level, for 2 more days, with the Practitioner exam conducted on the afternoon of Day 5.</p><h3>What you will Learn</h3>
<p>At the end of this program, you will be able to:</p>
<ul>
<li>Develop the lifecycle of a business case and establish the relationships between the five cases</li>
<li>Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario.</li>
</ul><section>
                    <h3>Overview of Better Business Cases</h3><ul><li>Alignment with the strategic planning process</li><li>Importance of the Business Case using the Five Case Model</li><li>Overview of the Five Case Model</li><li>Purpose of the key stages in the development of a spending proposal</li><li>Purpose of a Business Justification Case</li><li>Business Case Development Process</li><li>Purpose of project / programme assurance and assurance reviews</li><li>Responsibility for producing the Business Case</li></ul><h3>Determining the Strategic Context and Undertaking the Strategic Assessment</h3><ul><li>Scoping the Scheme and Preparing the Strategic Outline Case</li><li>Planning the Scheme and Preparing the Outline Business Case</li><li>Procuring the Solution and Preparing the Full Business Case</li><li>Implementation and monitoring</li><li>Evaluation and feedback</li></ul><h3>Making the Case for Change</h3><ul><li>Agree on the strategic context</li><li>Determine spending objectives, existing arrangements, and business needs</li><li>Determine potential business scope and key service requirements</li><li>Determine benefits, risks, constraints, and dependencies</li></ul><h3>Exploring the Preferred Way Forward</h3><ul><li>Agree on critical success factors</li><li>Determine long list options and SWOT analysis</li><li>Recommend a preferred way forward</li></ul><h3>Determining Potential Value for Money</h3><ul><li>Revisit the short list</li><li>Prepare the economic appraisal for short-listed options</li><li>Undertake benefits appraisal</li><li>Undertake risk appraisal</li><li>Select preferred option and undertake sensitivity analysis</li></ul><h3>Preparing for the Potential Deal</h3><ul><li>Determine the procurement strategy</li><li>Determine service streams and required outputs</li><li>Outline potential risk apportionment</li><li>Outline potential payment mechanisms</li><li>Ascertain contractual issues and accountancy treatment</li></ul><h3>Ascertaining Affordability and Funding Requirement</h3><ul><li>Prepare the financial model</li><li>Prepare the financial appraisals</li></ul><h3>Planning for Successful Delivery</h3><ul><li>Plan programme / project management</li><li>Plan change and contract management</li><li>Plan benefits realization</li><li>Plan risk management</li><li>Plan programme / project assurance and post-project evaluation</li></ul><h3>Procuring the Value for Money Solution</h3><ul><li>Revisit the case for change</li><li>Revisit the OBC options</li><li>Detail procurement process and evaluation of best and final offers (BAFOs)</li></ul><h3>Contracting for the Deal</h3><ul><li>Set out the negotiated deal and contractual arrangements</li><li>Set out the financial implications of the deal</li></ul><h3>Ensuring Successful Delivery</h3><ul><li>Finalize project management arrangements and plans</li><li>Finalize change management arrangements and plans</li><li>Finalize benefits realization arrangements and plans</li><li>Finalize risk management arrangements and plans</li><li>Finalize contract management arrangements and plans</li><li>Finalize post-project evaluation arrangements and plans</li></ul>


                </section>

IIL Europe Ltd

Better Business Cases Foundation & Practitioner: In-House

General Admission

<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

<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

<h2>Better Business Cases™ Practitioner: In-House Training: In-House Training</h2>
 <p>Better Business Cases™ is based on the Five Case Model - which is the UK government's best practice approach to structuring spending proposals and making effective business decisions. Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives.</p>
 <p>The goal of the practitioner course is to develop a candidate's ability to deliver a comprehensive business case, through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this Practitioner course, a candidate will be able to start applying the model to a real business case development project.</p><h3>What You Will Learn</h3>
 <p>At the end of this program, you will be able to:</p>
 <ul>
 <li>Develop the lifecycle of a business case and to establish the relationships between the five cases</li>
 <li>Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario</li>
 </ul><section>
                    <h3>Overview of Better Business Cases</h3> <ul> <li>Alignment with the strategic planning process</li> <li>Importance of the Business Case using the Five Case Model</li> <li>Overview of the Five Case Model</li> <li>Purpose of the key stages in the development of a spending proposal</li> <li>Purpose of a Business Justification Case</li> <li>Business Case Development Process</li> <li>Purpose of project / programme assurance and assurance reviews</li> <li>Responsibility for producing the Business Case</li> </ul> <h3>Determining the Strategic Context and Undertaking the Strategic Assessment</h3> <ul> <li>Scoping the Scheme and Preparing the Strategic Outline Case</li> <li>Planning the Scheme and Preparing the Outline Business Case</li> <li>Procuring the Solution and Preparing the Full Business Case</li> <li>Implementation and monitoring</li> <li>Evaluation and feedback</li> </ul> <h3>Making the Case for Change</h3> <ul> <li>Agree on the strategic context</li> <li>Determine spending objectives, existing arrangements, and business needs</li> <li>Determine potential business scope and key service requirements</li> <li>Determine benefits, risks, constraint, and dependencies</li> </ul> <h3>Exploring the Preferred Way Forward</h3> <ul> <li>Agree on critical success factors</li> <li>Determine long list options and SWOT analysis</li> <li>Recommend a preferred way forward</li> </ul> <h3>Determining Potential Value for Money</h3> <ul> <li>Revisit the short list</li> <li>Prepare the economic appraisal for short-listed options</li> <li>Undertake benefits appraisal</li> <li>Undertake risk appraisal</li> <li>Select preferred option and undertake sensitivity analysis</li> </ul> <h3>Preparing for the Potential Deal</h3> <ul> <li>Determine the procurement strategy</li> <li>Determine service streams and required outputs</li> <li>Outline potential risk apportionment</li> <li>Outline potential payment mechanisms</li> <li>Ascertain contractual issues and accountancy treatment</li> </ul> <h3>Ascertaining Affordability and Funding Requirement</h3> <ul> <li>Prepare the financial model</li> <li>Prepare the financial appraisals</li> </ul> <h3>Planning for Successful Delivery</h3> <ul> <li>Plan programme / project management</li> <li>Plan change and contract management</li> <li>Plan benefits realization</li> <li>Plan risk management</li> <li>Plan programme / project assurance and post project evaluation</li> </ul> <h3>Procuring the Value for Money Solution</h3> <ul> <li>Revisit the case for change</li> <li>Revisit the OBC options</li> <li>Detail procurement process and evaluation of best and final offers (BAFOs)</li> </ul> <h3>Contracting for the Deal</h3> <ul> <li>Set out the negotiated deal and contractual arrangements</li> <li>Set out the financial implications of the deal</li> </ul> <h3>Ensuring Successful Delivery</h3> <ul> <li>Finalize project management arrangements and plans</li> <li>Finalize change management arrangements and plans</li> <li>Finalize benefits realization arrangements and plans</li> <li>Finalize risk management arrangements and plans</li> <li>Finalize contract management arrangements and plans</li> <li>Finalize post-project evaluation arrangements and plans</li> </ul>


                </section>

Better Business Cases Practitioner: In-House Training

<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 Virtual Instructor Led Training (VILT)</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;">Forward pricing and valuation in electricity generation is a 4 half day intensive, technical hands-on course in which attendees receive comprehensive instruction on the theory and practice of making price forecasts and assessing risk in the electricity generating industry. After a discussion of electricity markets around the world, the course moves to programming and model structuring, where attendees follow the lead of the instructor in building various analyzes of forward pricing and and valuation issues.</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/electricity-pricing-and-marginal-cost-analysis-virtual-instructor-led-training-vilt/#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;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Learn practical tools to analyse a host of issues in electricity analysis including efficient tools to work with supply and demand data; creating flexible scenario and sensitivity analysis to evaluate power prices and marginal costs; effectively presenting short-term and long-term supply and curves; development of hydro analysis; Monte Carlo simulation and other issues.</li><li fr-original-style="" style="box-sizing: border-box;">Create demand and supply models of electricity pricing that incorporates changes in fuel prices, new capacity, demand profiles, maintenance outages to measure hourly marginal cost and total generation cost.</li><li fr-original-style="" style="box-sizing: border-box;">Study the structure of market designs around the world and simulate pricing strategies through evaluation of the California crisis and simulation exercises.</li><li fr-original-style="" style="box-sizing: border-box;">Understand the relationship between capacity pricing, reliability, loss of load probability and reserve margins through extending the short-run supply and demand analysis and modelling outage cost with different capacity configurations.</li><li fr-original-style="" style="box-sizing: border-box;">Model the economic value of different types of renewable resources in alternative markets&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">including storage hydro, run-of-river hydro, wind and solar.</strong></li><li fr-original-style="" style="box-sizing: border-box;">Develop efficient ways to quickly compute the levelised electricity cost of different technologies using carrying charge factors and alternative financial models and use levelised cost analysis to develop screening models of optimal resources.</li><li fr-original-style="" style="box-sizing: border-box;">Evaluate long-run marginal cost of electricity cost through simulating the value of different generating resources given load curves and simulate the effects of different capital costs, heat rates and fuel prices on the long-run marginal cost.</li><li fr-original-style="" style="box-sizing: border-box;">Compute the effects of start-up costs, heat rate curves, and transmission constraints on the value of alternative plants and the price of electricity.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/electricity-pricing-and-marginal-cost-analysis-virtual-instructor-led-training-vilt/#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;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Energy industry professionals &ndash; This could include roles like energy traders, pricing analysts, forecasters, risk managers at energy companies, utilities, independent power producers, etc. They need to understand electricity pricing and how to optimize revenues.</li><li fr-original-style="" style="box-sizing: border-box;">Energy market regulators &ndash; Pricing regulators at entities like FERC, state utility commissions, ISO/RTOs. They need to understand cost analysis and pricing models to set fair rates.</li><li fr-original-style="" style="box-sizing: border-box;">Energy procurement managers &ndash; At large C&amp;I customers, municipalities, coops. They are tasked with buying electricity for their organizations at the lowest cost so need pricing analysis skills.</li><li fr-original-style="" style="box-sizing: border-box;">Energy investment analysts &ndash; At banks, investment firms, hedge funds. They need electricity pricing models for valuation of energy investments and assets.</li><li fr-original-style="" style="box-sizing: border-box;">Energy policy analysts &ndash; At government agencies, think tanks, advocacy groups. They provide advice and analysis on energy policy issues like rate design.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/electricity-pricing-and-marginal-cost-analysis-virtual-instructor-led-training-vilt/#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/electricity-pricing-and-marginal-cost-analysis-virtual-instructor-led-training-vilt/#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);">TRAINING METHODS</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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The VILT will be delivered online in 4 sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day</strong>, including time for lectures, discussion, quizzes and short classroom exercises.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course.</p></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/electricity-pricing-and-marginal-cost-analysis-virtual-instructor-led-training-vilt/#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;">Our key course expert 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&rsquo;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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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 fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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<br fr-original-style="" style="box-sizing: border-box;">valuation and analytical mistakes made in finance. This book uses many case studies from Harvard<br fr-original-style="" style="box-sizing: border-box;">Business School that were thought to represent effective business strategies and later turned into valuation nightmares.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Over the course of his career our key course expert has been involved in formulating<br fr-original-style="" style="box-sizing: border-box;">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 fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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><a data-toggle="collapse" href="https://petroedgeasia.net/training/electricity-pricing-and-marginal-cost-analysis-virtual-instructor-led-training-vilt/#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></section>

Develop a deep understanding of electricity pricing and marginal cost analysis with EnergyEdge's virtual instructor-led training course. Enroll now for a rewarding learning journey!

Electricity Pricing and Marginal Cost Analysis - Virtual Instructor Led Training (VILT)

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual



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


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


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


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


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


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


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


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


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


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


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


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


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

Property Investment

Financial Analysis

Microsoft Excel

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

Real Estate Investment School (Investment Cash Flow Modelling)

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong>:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advanced project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



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


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


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


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


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


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

Real Estate Finance

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this step-by-step Advanced Financial Modeling Using Excel training course. This Advanced Financial Modeling Using Excel course for Consistent Profits has been specially designed to help learners gain a good command of Advanced Financial Modeling Using Excel, providing them with a solid foundation of knowledge to understand relevant professionals' job roles.</p><p>Through this Advanced Financial Modeling Using Excel course, you will gain a theoretical understanding of Advanced Financial Modeling Using Excel and others relevant subjects that will increase your employability in this field, help you stand out from the competition, and boost your earning potential in no time.</p><p>Not only that, but this Advanced Financial Modeling Using Excel training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. </p><p>This course is fully CPD-accredited and broken down into several manageable modules, making it ideal for aspiring professionals.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful people to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to a computer or digital device with internet connectivity.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Advanced Financial Modeling Using Excel </strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Welcome to the Course! Get the Overview of What You'll Learn</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Planning your Financial Model</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Building a Model Template</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Projecting the Income Statement</td><td><span>🕐 00:13:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Projecting the Balance Sheet</td><td><span>🕐 00:17:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Projecting Cash Flows</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Advanced Financial Modeling</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>BONUS LESSON: Top 5 Excel Features for Financial Modellers</td><td><span>🕐 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Resources</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Resources - Advanced Financial Modeling Using Excel</td><td><span>🕐 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Mock Exam</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam - Advanced Financial Modeling Using Excel</td><td><span>🕐 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Final Exam</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam - Advanced Financial Modeling Using Excel</td><td><span>🕐 00:20:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Skill Up

Explore intricate financial models with our Advanced Financial Modeling using Excel course. Enhance analytical skills and elevate financial decision-making. Enroll now!

Advanced Financial Modeling Using Excel

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

<p>Financial Modeling Techniques bundle teaches you everything on the topic thoroughly from scratch so you can achieve a certificate for free to showcase your achievement in professional life.</p><p>This Financial Modeling Techniques bundle is a comprehensive, instructor-guided, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.</p><p>The training materials of this Financial Modeling Techniques bundle are available online for you to learn at your own pace and fast-track your career with ease.</p><p><strong>This bundle includes the following courses:</strong></p><ul><li><strong>Course 01:</strong> Financial Modeling: Financial Modeling for Startups</li><li><strong>Course 02:</strong> Accounting and Finance</li><li><strong>Course 03:</strong> Entrepreneurship</li><li><strong>Course 04:</strong> Business development</li></ul><p><strong>Key Features</strong></p><ul><li>Accredited by CPD</li><li>Instant e-certificate</li><li>Fully online, interactive Financial Modeling Techniques course with audio voiceover</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Enrol now in this</strong><strong> course to excel!</strong></p><p><strong>How You will be Benefited from Financial Modeling Techniques Bundle</strong></p><p>All through this self-paced training, you will get engaging learning materials and acquire the necessary knowledge to work with various concepts to gain a competitive advantage in the employment market.</p><p><strong>Accreditation</strong></p><p>All of our courses included in this Financial Modeling Techniques bundle are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your Financial Modeling Techniques course, you will immediately be sent digital certificates for the bundle courses.</p><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>Anyone with a knack for learning new skills can take this Financial Modeling Techniques bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no formal requirements for this bundle courses to be enrolled.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This Financial Modeling Techniques bundle of courses will help you to uplift your career.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.</p> </div>

                        </div>

Training Express

Financial Modeling Techniques Course

<p>Financial Modeling Essentials course teaches you everything on the topic thoroughly from scratch so you can achieve a certificate for free to showcase your achievement in professional life.</p><p>This course is a comprehensive course designed to provide a detailed understanding of the nature of the related sector and your key roles within it.</p><p>The Financial Modeling Essentials training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.</p><p><strong>Key Features </strong></p><ul><li>CPD Accredited Financial Modeling Essentials course</li><li>Instant e-certificate</li><li>Fully online, interactive Financial Modeling Essentials course with audio voiceover</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Free Gifts</strong></p><ul><li>Life Coaching Course</li></ul><p><strong>Enrol now in this</strong><strong> Financial Modeling Essentials course to excel! </strong></p><p>In this in-depth Financial Modeling Essentials training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge &amp; skills.</p><p>The curriculum of the Financial Modeling Essentials course has been designed by experts with years of experience behind them which is extremely dynamic and well-paced to help you understand the subject matter with ease.</p><p><strong>Course Curriculum</strong></p><ul><li>Module 01: Basic Financial Calculations</li><li>Module 02: Overview of Financial Markets, Financial Assets, and Market Participants</li><li>Module 03: Financial Statement Modelling</li><li>Module 04: Types of Financial Models</li><li>Module 05: Sensitivity Analysis</li><li>Module 06: Sales and Revenue Model</li><li>Module 07: Cost of Goods Sold and Inventory Model</li><li>Module 08: Valuation Methods</li></ul><p><strong>Accreditation</strong></p><p>This Financial Modeling Essentials is CPD Certification Service (CPD UK) Accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.</p><p><strong>Disclaimer:</strong> The CPD approved course is owned by E-Learning Solutions Ltd and is distributed under license.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your Financial Modeling Essentials course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99).</p><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>Anyone with a knack for learning new skills can take this Financial Modeling Essentials course.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>No prior degree or experience is required to enrol in this Financial Modeling Essentials course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Finance Manager</li><li>Financial Advisor</li><li>Financial Analyst</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.</p> </div>

                        </div>

Financial Modeling Essentials Course

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Financial Modeling for Business Analysts and Consultants</strong> bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong>33 </strong>course mega bundle that will exceed your expectations within your budget.</p> <p>The<strong> Financial Modeling for Business Analysts and Consultants</strong> related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong>StudyHub </strong>proposes a preparatory bundle. This comprehensive <strong> Financial Modeling for Business Analysts and Consultants</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Financial Modeling for Business Analysts and Consultants Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses - </strong></p> <ul> <li>Course 1: Financial Advisor</li><li>Course 2: Financial Management</li><li>Course 3: Financial Accounting</li><li>Course 4: Financial Analysis</li><li>Course 5: Financial Analysis : Finance Reports</li><li>Course 6: Financial Modelling Course</li><li>Course 7: Financial Controller Training</li><li>Course 8: Making Budget &amp; Forecast</li><li>Course 9: Raise Money and Valuation for Business</li><li>Course 10: Corporate Finance: Profitability in a Financial Downturn</li><li>Course 11: Financial Modeling Using Excel</li><li>Course 12: Stock Trading &amp; Investing</li><li>Course 13: Stock Market Investing for Beginners</li><li>Course 14: Stock Market Chart Patterns for Day Trading</li><li>Course 15: Cryptocurrency: Wallets, Investing &amp; Trading</li><li>Course 16: Forex Trading Diploma</li><li>Course 17: Tax Accounting</li><li>Course 18: Introduction to VAT</li><li>Course 19: Anti-Money Laundering (AML) Training</li><li>Course 20: Debt Management</li><li>Course 21: Key Account Management Course</li><li>Course 22: Cost Control Process and Management</li><li>Course 23: Diploma in Data Analysis Fundamentals</li><li>Course 24: Fundamentals of Business Analysis</li><li>Course 25: Business Intelligence Analyst Course</li><li>Course 26: Finance and Cash management for Hospitality</li><li>Course 27: Changes in Accounting: Latest Trends Encountered by CFOs</li><li>Course 28: Learn to Read, Analyse and Understand Annual Reports</li><li>Course 29: Bookkeeper Training Course</li><li>Course 30: Business Law</li></ul> <p><strong>3 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p> <ul> <li>Course 1:Career Development Plan Fundamentals</li><li>Course 2:CV Writing and Job Searching</li><li>Course 3:Interview Skills: Ace the Interview</li></ul> <p><strong>Learning Outcome</strong></p> <p><strong>This tailor-made </strong><strong>Financial Modeling for Business Analysts and Consultants</strong><strong> bundle will allow you to-</strong></p> <ul> <li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge</li><li>Acquire some hard and soft skills in this area</li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software</li><li>Keep records of your work and make a report</li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field</li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Financial Modeling for Business Analysts and Consultants Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p> <p><strong>Certification</strong></p> <p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                             <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Financial Modeling for Business Analysts and Consultants bundle! This bundle is also ideal for professionals looking for career advancement.</p> 
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>To participate in this course, all you need is -</p> <ul> <li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Financial Modeling for Business Analysts and Consultants</li></ul> 
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.</p> 
                        </div>

Studyhub UK

Finance Cert & Exam Prep

Coaching & Consulting Business

Certification in Business Accounting & Taxation (CBAT)

Financial Analyst

Corporate Finance Level 1

Financial Modeling for Business Analysts and Consultants

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Financial Management and Financial Modeling</strong> bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong>33</strong> course mega bundle that will exceed your expectations within your budget.</p><p>The<strong> Financial Management and Financial Modeling</strong> related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong>StudyHub </strong>proposes a preparatory bundle. This comprehensive <strong> Financial Management and Financial Modeling</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p><p><strong>This Financial Management and Financial Modeling Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses - </strong></p><ul><li>Course 01:Financial Consultant Training</li><li>Course 02:Making Budget &amp; Forecast</li><li>Course 03:Business Model Canvas for Business Plan</li><li>Course 04:Dealing With Uncertainity: Make Budgets and Forecasts</li><li>Course 05:Financial Modeling Using Excel</li><li>Course 06:Debt Management - Online Course</li><li>Course 07:Forensic accounting</li><li>Course 08:Pension UK</li><li>Course 09:GDPR</li><li>Course 10:Excel Pivot Tables for Data Reporting</li><li>Course 11:Personal Productivity Course</li><li>Course 12:Time Management Training - Online Course</li><li>Course 13:Sage 50 Accounts</li><li>Course 14:Financial Statements Fraud Detection Training</li><li>Course 15:Anti-Money Laundering (AML) Training</li><li>Course 16:Document Control</li><li>Course 17:Corporate &amp; Strategic Communication Skills for Managers</li><li>Course 18:Excel Vlookup, Xlookup, Match and Index</li><li>Course 19:Financial Reporting</li><li>Course 20:Learn to Read, Analyse and Understand Annual Reports</li><li>Course 21:Accounting Basics</li><li>Course 22:Bookkeeper Training Course</li><li>Course 23:Xero Accounting and Bookkeeping Online</li><li>Course 24:Quickbooks Online</li><li>Course 25:Financial Management</li><li>Course 26:Commercial Law</li><li>Course 27:UK Tax Accounting</li><li>Course 28:Cost Control &amp; Project Scheduling</li><li>Course 29:Dynamic Excel Gantt Chart and Timelines</li><li>Course 30:Understanding Financial Statements and Analysis</li></ul><p><strong>3 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p><ul><li>Course 01: Career Development Plan Fundamentals</li><li>Course 02: CV Writing and Job Searching</li><li>Course 03: Interview Skills: Ace the Interview</li></ul><p><strong>Learning Outcome</strong></p><p><strong>This tailor-made </strong><strong>Financial Management and Financial Modeling</strong><strong> bundle will allow you to-</strong></p><ul><li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge</li><li>Acquire some hard and soft skills in this area</li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software</li><li>Keep records of your work and make a report</li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field</li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Financial Management and Financial Modeling Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p><p><strong>Certification</strong></p><p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Financial Management and Financial Modeling bundle! This bundle is also ideal for professionals looking for career advancement.</p><p><strong>Please Note</strong>: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses.</p>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>To participate in this course, all you need is -</p><ul><li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Financial Management and Financial Modeling</li></ul>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.</p>
                        </div>

Accounting & Finance

Finance For Non Finance Managers

Trainers Course

Financial Management, Forensic Accounting and Financial Modeling

<h3><strong>Overview</strong></h3>
This comprehensive course on Financial Modeling Using Excel will deepen your understanding on this topic.

After successful completion of this course you can acquire the required skills in this sector. This Financial Modeling Using Excel comes with accredited certification which will enhance your CV and make you worthy in the job market.

So enrol in this course today to fast track your career ladder.
<h3><strong>How will I get my certificate?</strong></h3>
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
<h3><strong>Who is this course for?</strong></h3>
There is no experience or previous qualifications required for enrolment on this <strong>Financial Modeling Using Excel</strong>. It is available to all students, of all academic backgrounds.
<h3><strong>Requirements</strong></h3>
Our <strong>Financial Modeling Using Excel</strong> is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.

There is no time limit for completing this course, it can be studied in your own time at your own pace.
<h3><strong>Career path</strong></h3>
Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc. <h3>Course Curriculum</h3><div><p>2 sections • 9 lectures • 01:31:00 total length</p></div><div><div><div><div><div><div><div><p>•Welcome to the Course! Get the Overview of What You'll Learn: 00:04:00</p></div><div><div><p>•Planning your Financial Model: 00:09:00</p></div><div><div><p>•Building a Model Template: 00:12:00</p></div><div><div><p>•Projecting the Income Statement: 00:13:00</p></div><div><div><p>•Projecting the Balance Sheet: 00:17:00</p></div><div><div><p>•Projecting Cash Flows: 00:14:00</p></div><div><div><p>•Advanced Financial Modeling: 00:14:00</p></div><div><div><p>•BONUS LESSON: Top 5 Excel Features for Financial Modellers: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Financial Modeling Using Excel: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

10 Courses in Nottingham

Project Economics, Risk and Decision Analysis for Oil & Gas

By EnergyEdge - Training for a Sustainable Energy Future

Financial Modelling for Budgeting and Forecasting in Excel

By GBA Corporate

Business and Financial Modelling

By GBA Corporate

Financial Modelling and Analysis in Project Financing

By GBA Corporate

PPP PROJECT FINANCIAL MODELLING

By GBA Corporate

Better Business Cases Foundation & Practitioner: In-House

By IIL Europe Ltd

Power BI® - Business Data Analytics

By EnergyEdge - Training for a Sustainable Energy Future

Geothermal Project Finance Analysis and Modelling

By EnergyEdge - Training for a Sustainable Energy Future

Better Business Cases Practitioner: In-House Training

By IIL Europe Ltd

Electricity Pricing and Marginal Cost Analysis - Virtual Instructor Led Training (VILT)

By EnergyEdge - Training for a Sustainable Energy Future

Search By Location