11 Financial Modelling courses in Leeds

OVERVIEW -------------------------------------------------------------------------------- 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 & Financial Modelling process provides an effective tool with which the potential outcomes of various strategic and tactical initiatives can be projected. 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.

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

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

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

ABOUT THIS TRAINING COURSE  This 3 full-day training course will introduce participants to the Microsoft Power BI® 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® 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. The first two days focus on learning the key concepts and practising these using clean, simple datasets. The third day provides participants with the opportunity to apply what they'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't be able to do what they need to do. This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® 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. Microsoft® PowerBI® is a trademark of Microsoft Corporation in the United States and/or other countries. Training Objectives Upon completion of this training course, participants will be able to: * Confidently use the Power BI® solution, including Power BI® Desktop, PowerBI®.com and the Power BI® Gateway * Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis * Combine data sources together and gain an introductory understanding of the M language * Write formulas using the DAX language for generating custom columns, measures and tables * Design reports and dashboards using a wide range of both built-in and custom visuals * Publish reports and dashboards to PowerBI®.com * Share reports and dashboards with others using PowerBI®.com * Customize reports and dashboards so that different user groups automatically see their own personalized views Target Audience This training course is intended for: * Financial Analysts * Accountants * Budgeting and planning specialists * Treasury * Risk Managers * Strategic Planners This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® 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. Course Level * Basic or Foundation Trainer Your expert course leader has a Masters (Applied Finance & Investment), B.Comm (Accounting & Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years' 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. He has trained delegates from a wide variety of Oil & 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. Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm. 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. Highlights from his oil and gas experience include: * Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil & gas assets. * Auditing and further development of life of project models for Chevron's Strategic Planning Division analysing their North West Shelf assets. * Development of business plan and budgeting models for multinational oil & gas assets. * Development of cash flow and taxation models for a variety of oil gas companies. * Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment. POST TRAINING COACHING SUPPORT (OPTIONAL) 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. Request for further information post training support and fees applicable Accreditions And Affliations

ABOUT THIS VIRTUAL INSTRUCTOR LED TRAINING (VILT)  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. 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. The course will be taught with a combination of theoretical discussions, term sheet review and focused financial models. Training Objectives * Evaluation of the economic risks that arise from uncertainty associated with drilling exploration wells and development wells for geothermal projects. * 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; * 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; * 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. * 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; * Understand how to compute P50, P90 and P99 for different projects driven by resource risk; * 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. * Understand under what conditions debt sculpting can affect returns and how synthetic sculpting can be used to increase returns when the DSCR constraint applies. * 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. * 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. Course Level * Basic or Foundation Training Methods 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. Trainer 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&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. 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. 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. 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). POST TRAINING COACHING SUPPORT (OPTIONAL) 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. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

ABOUT THIS TRAINING COURSE 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. 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. 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. Participants will require access to computers/laptops with Excel to solve problems during the course. Training Objectives Upon completion of this course, participants will be able to fully understand the gas market dynamics and Investment Evaluation. They will be able to: * Learn how to reduce exposure and mitigate risks in projects by handling uncertainty * Clarify concepts such as time value of money, cash-flow models, capital budgeting, IRR, NPV, income producing investments * Maximise the return on investments through good decision-making processes based on the commercial viability of projects * Improve their decision process, investment and opportunity analysis * Acquire the hands-on experience in building their own economic evaluation models and solving case study-based examples   Target Audience The following oil & gas company personnel will benefit from the knowledge shared in this course: * Facilities and Planning engineers * Project and procurement personnel * Oil & gas engineers * Geologists * Financial Analysts * Commercial managers * Economists * Government officials * Business advisors * Asset managers * E&P managers * Product and business development personnel   Course Level * Basic or Foundation Training Methods     Organisational Impact     Trainer Your expert course leader is a globally recognised subject matter expert in petroleum/project economics and international gas market analysis. He is a recipient of the 2021 Society of Petroleum Engineers (SPE) International Management Award, 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. 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. He is the author of six books: 1. Petroleum Engineering Handbook for the Practicing Engineer, Vol. I and Vol. II, published by PennWell Books, Tulsa, Oklahoma, USA. 2. 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. 3. Tip & Tricks in Excel based Financial Modeling, Vol. 1 & 2, published by Business Expert Press, New York, USA. He has also authored several papers in the Oil & Gas Journal, The Log Analyst, World Oil, SPE Journals, and Oil & 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. Daily daily_agenda     POST TRAINING COACHING SUPPORT (OPTIONAL) 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. Request for further information post training support and fees applicable Accreditions And Affliations

Understanding how to plan for capacity, be able to forecast and manage budgets is a critical skill in today's leadership and management environment. This programme will not only support your understanding but will also help you to practically put the learning into practice.

Where should management effort be directed? In controlling costs and ensuring proper engineering in live projects? - yes, of course, but true cost control comes by understanding, eliminating and minimising risk prior to a business committing any funds. This course studies the stages required for practical financial and business appraisals of projects and capital expenditure. This course has two primary objectives: * To impart the knowledge and skills required to ensure as risk-free as possible expenditure of that scarce resource, cash - the investors', governments' or shareholders' money must not be squandered * To improve the quality of the appraisal process in the widest sense - demonstrating how the process of project and capital expenditure appraisal can be used to dramatically improve cost control and deliver as risk-free as possible expenditure As a result of the course, participants will be able to: * Understand the economics of appraisal * Be in control of their projects from the start * Understand the economics of their projects - and devise the most appropriate mode * Carry out sensitivity analysis and identify risk * Improve their methods of appraisal and approach * Focus on the risk areas and take out risk and control costs before they over-run The benefits of attending this course will be demonstrable from day one. Thorough appraisals and risk assessment follow through to success in project management and detailed cost control and project management. 1 INTRODUCTION * Why appraise? * Taking risk out of investment * The short- and long-term results of not appraising business expenditure 2 DEVELOPING AN APPRAISAL PROCESS * The process - overall and stage-by-stage objectives * Understand business and technical risks * Manage resources and time * Do you invest enough time and effort at this stage? * Take out the risks - control costs before you are committed to contracts and action * Checklists 3 APPRAISAL ARITHMETIC * Review of the arithmetic of appraisal * The time value of money * The effects of different interest or required rates * The effects of inflation (or deflation) in prices and costs * Understanding the economics of appraisal is essential 4 APPRAISAL MEASURES * Meaning and use of appraisal measures * Identifying the most appropriate measures for your particular business * Payback * Discounted cash flow measures - NPV and IRR * Other measures - FW, AW, Profitability Index * The meaning of the measures and their application in practice 5 COST BENEFIT ANALYSIS * The effect on decision-making of more intangible benefits * Cost benefit analysis * Ensuring costs are genuine * Measuring intangible benefits * Environmental issues * Consideration of intangible benefits in the appraisal decision-making process 6 DEVELOPING APPROPRIATE MODELS * Developing models - examples of spreadsheet models and measures for many different situations * Modelling investment opportunities - summarising outcomes * Sensitivity analysis - identifying, quantifying and taking out risk 7 DEVELOPING AN APPRAISAL PROCESS * The process - managing risk from the outset * Using the process in risk management, negotiating and project management * Take out risk by thoroughly knowing your project - developing your own process

An insightful, enjoyable and experiential programme to help you analyse data and information and make a balanced decision based upon sound commercial reasoning. It will enable you to identify options, make decisions and take actions based on a thorough analysis combined with instinct and intuition to make a positive effect on profitability. This programme will help you: * Identify ways to analyse data and sort relevant from irrelevant information * Develop analytical and numerate thinking, and consider the financial implications of a decision * Make decisions based on sound commercial reasoning - a mix of intuition and analysis * Select from a range of tools to analyse a situation and apply these effectively * Understand how costs and profits are calculated * Use tried-and-tested techniques to manage and control your budgets * Appreciate the fundamentals of financial analysis * Focus on the bottom line * Identify the basics of capital investment appraisal for your business * Evaluate results and seek opportunities for improvement to your business 1 THE COMMERCIAL ENVIRONMENT * What do shareholders and investors want? * What do managers want? * Profit v non-profit organisations * Investor expectations 2 FINANCIAL AND NON-FINANCIAL INFORMATION * Risk and reward considerations * Drivers of commercial decisions 3 RUNNING A BUSINESS * A practical exercise to bring financial statements to life * Different stakeholder interests in a business * The impact and consequences of decisions on financial statements 4 WHERE DO I MAKE A DIFFERENCE TO THE ORGANISATION? * How can I contribute to an improved business performance? * Key performance indicators - measuring the right things * A 'balanced scorecard' approach - it's not all about money! 5 A 'BALANCED SCORECARD' APPROACH * Analysing and reviewing my contribution to the business direction * What is the current focus of my commercial decisions? * Developing the business in the right way - getting the balance right! * Where should/could it be in the future? * Do my decisions support the overall vision and strategy? 6 MAKING COMMERCIAL DECISIONS * Left-brain and right-brain thinking * Convergent and divergent thinking * Analysis and instinct * Interactive case study exercise - emotional and rational decisions * Reflection - what is my style of making decisions 7 LET'S CONSIDER THE CUSTOMER! * Identifying target markets * Differentiating propositions and products * Customer service considerations * Marketing considerations and initiatives * Pricing strategies and considerations 8 STRATEGIC ANALYSIS * The external environment * The internal environment * LEPEST analysis * SWOT analysis * Forecasting * Group activity - analysing markets and the competition * How do these improve your decisions? 9 COMPARING PERFORMANCE * Analysing key financial ratios * Ways to compare performance and results * Break-even analysis 10 PROFIT AND LOSS ACCOUNTS AND BUDGETING * Managing income and expenditure * The budgeting process * How does this link to the profit and loss account? * Managing and controlling a cost centre/budget * The role of the finance department * Different ways of budgeting * Incremental budgeting * Zero-based budgeting 11 UNDERSTANDING THE BALANCE SHEET * Purpose of balance sheets * Understanding and navigating the content * What does a balance sheet tell you? * How do you affect your balance sheet? * Links to the profit and loss account * A practical team exercise that brings financial statements to life 12 BUSINESS DECISIONS EXERCISE * How does this improve your decisions? * A practical exercise to apply new knowledge and bring commercial thinking to to life * The impact and consequences of decisions on financial statements 13 WORKING CAPITAL * Why is this important? * The importance of keeping cash flowing * Business decisions that affect cash * Calculating profit 14 CAPITAL INVESTMENT APPRAISAL * Capex v Opex * Payback * Return on investment * The future value of money * The concept of hurdle rate 15 LESSONS LEARNED AND ACTION PLANNING * So what? * Recap and consolidation of learning * The decisions that I need to consider * Actions to achieve my plan