670 Educators providing Finance courses in Borehamwood

Pivot tables are really very easy to create, but very powerful. By using Excel pivot tables, one can get very interesting and valuable business intelligence from your data in very little time. This short session aims to give you the techniques to use this valuable Excel tool creatively. It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.

Overview Objective Understand why trade finance is generally low risk for credit losses - IF done properly Appreciate the range of risks involved in trade finance Understand the controls and mitigants available Be able to categorise risk according to client size and strength Appreciate the mechanisms of the working capital cycle Recognise that structured lending facilitates easier and closer control

Project Accounting and Finance Skills: In-House Training Do you manage both project schedules and budgets, but do not have insight into how actual results relate to the approved budget? Do you desire to have more clarity about the relationship between your project's performance with the accounting and financial systems in your organization? Do you need to understand financial and accounting terminology to bridge the gap between the 'world of finance' and the 'world of project management? Organizations have a need to manage-by-projects, because projects are the means to deliver on strategic goals and objectives. Therefore, the project manager must have an understanding of the financial world of investments to ensure the organization will realize expected business value. This requires a foundation in the principles of accounting and finance to comprehend how the project's contribution provides an organization with a competitive advantage. Learn what you must do to give your organization the assurance it needs that its investment in your project will realize business value. Learn what you must do to give your organization the assurance it needs to know that its investment in your project will realize business value. What You Will Learn At the end of this program, you will be able to: Explain the aspects of classical corporate accounting and finance effects on managing projects Determine how your project fits into the corporate income statement, balance sheet, and cash flow statement Analyze the financial aspects of managing projects Use earned value management as the basis for decision making throughout the project life Recognize the importance of the project manager's financial responsibilities Focus on what PMs do and should be doing, in support of accounting and finance Use financial information within a project environment to meet financial results Track and analyze the project's financial status and forecast with the goal of realizing benefits Generate work performance data to ensure a project's outcome aligns with financial metrics Foundation Concepts Accounting and Finance Terms and Concepts Accounting and Finance Essentials Financial Terms and Concepts Projects as Financial Investments Overview of 'Two Worlds' Project as Investments Accounting and Finance World: Standards, Principles and Practices Accounting and Finance Standards and Principles Accounting and Finance Practices Capital Budgeting Corporate Budgeting Accounting and Finance World: Economic Project Selection Methods Economic Project Selection Methods Economic Project Selection and the Business Case Project Management World Project Management and Financial Controls Project Management and Work Performance Data Project Management and Earned Value Management Project Management and Work Performance Reporting

Overview Consolidating a financial statement is very important and is one of the major tools to combine everything related to finance. This course is designed to deliver robust training on consolidated financial statements and prepare you in a perfect manner to directly implement at your workspace when you leave the training session  This course will provide you with all the skills required to understand accounting and financial statements in the organisation or local government. It provides complete coverage to all the areas of financial statements with in-depth knowledge of partnerships and fiduciary accounting.

About this Training Course This separately bookable 3 full-day course is not designed to skill Oil & Gas engineers to be accountants, but to give the participants the confidence and ability to communicate with accountants and finance managers and to improve their own financial decision making. For technical professionals, a high level of single subject matter expertise is no longer sufficient for superior management performance. Oil & Gas technical professionals who wish to succeed in the resources industry are required to develop skills beyond their core functional knowledge. An understanding of financial information and management, and an awareness of the economic theory that drives value creation, are an integral part of the managers required suite of skills. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Workshop A: Finance for Non-Finance for Oil & Gas Professionals Attend this industry specific course and benefit from the following: Demystify financial jargon and fully interpret financial statements Understand Balance Sheets and Profit & Loss statements of Oil & Gas companies Discover the crucial distinction between cash flow and profit Understand how to make correct investment decisions using Net present Value and Internal Rate of Return Interpret oil and gas company financial reports using ratio analysis Learn the difference between cash costs and full costing of energy products Learn how to manage working capital for increased shareholder value Workshop B: Petroleum Fiscal Regimes and Applied Finance for Oil & Gas Industry Professionals Attend this advanced Training course to enhance your financial acumen from the following: Build and compare cash flow based models of both production sharing contract projects and royalty regime projects Gain an awareness of the different valuation methods for producing properties and undeveloped acreage Learn the industry specific accounting issues that apply when interpreting oil and gas company financial statements Understand how the physical characteristics of energy assets (e.g. reserves, reservoir quality) are translated into project valuations Learn how the investment analysts value oil and gas stocks and make buy/sell recommendations Target Audience This course is specifically designed for those with a non-finance background training from the Oil & Gas sector and requires only basic mathematical ability as a pre-requisite. It is presented in a manner that reduces the jargon to basic principles and applies them to numerous real-life examples. This course has been researched and developed for Managers, Superintendents, Supervisors, Engineers, Planners, Lawyers, Marketers, Team Leaders and Project Coordinators in the technical and non-technical departments in the Oil and Gas industry. Course Level Basic or Foundation Trainer Your expert course leader has presented over 300 courses and seminars in financial management. He began his career as a graduate in the Corporate Treasury of WMC Ltd having completed a degree in Applied Mathematics and Geology at Monash University. After five years with WMC, he pursued an MBA in finance and accounting at Cornell University in New York. He later gained a PhD in energy policy from the University of Melbourne. He worked for WMC Ltd in Perth as a Senior Financial Analyst in the Minerals Division and subsequently as an Energy Analyst in the Petroleum Division. In April 1997, he established an independent consultancy business providing advice to companies such as Woodside, Shell and Japan Australia LNG (MIMI). He spent many years as a consultant and commercial manager in the North West Shelf Gas project in Western Australia. Since 2006, he has been an Adjunct Fellow at the Macquarie University Applied Finance Centre where he teaches courses in valuation, financial statement modelling, and resources industry investment analysis. His background in geology and mathematics allows him to empathise with those who seek an understanding of finance but are approaching the learning experience with a technical mind. He receives consistently high ratings for his breadth of knowledge of the subject matter. He presents in a lively interactive style using real life examples and cases. 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

Finance doesn't have to be a puzzle. And if you want to get anywhere with your career, it had better not be! Whatever your role, you have an impact on the financial wellbeing of the organisation you work for, whether you've got specific financial responsibilities or not. This thoroughly practical, fun and enjoyable one-day workshop will help unpuzzle finance for you. It's an ideal opportunity to master the terminology, get to grips with the concepts, learn how 'the finance department' works and understand the part you play. This course will help participants: Appreciate the role and importance of Finance within organisations Be able to recognise and describe some of the common items and jargon used Identify the elements of the Profit & Loss and the Balance Sheet Understand cashflow Make better decisions Manage budgets 1 Introduction Expectations Terminology Key financial principlesAccrualsConsistencyPrudenceGoing concern 2 The three main financial statements Profit & Loss accountIncomeCost of salesGross profitAdministrative expenses ('overheads')Net profit/(loss) for the financial year (the 'bottom line')P&L format Balance SheetTerminologyFixed AssetsCurrent AssetsCurrent LiabilitiesLong-term LiabilitiesCapitalB/S format Cashflow Statement Financial and management information systems 3 Budgets and forecasts Why budget? Types of budget - incremental or zero-based Budgeting for costs - fixed and variable Budgeting for income An eight point plan for budgeting for your department Case study: Small Brother Ltd Problems and solutions 4 Accruals Accruals - what and why? Prepayments 5 Open forum

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

Overview This course would be ideal for HR professionals who are looking to be more financially skilled. You will develop a deep understanding of the key financial concepts that are important in the boardroom. Learn how to break these concepts down to see what they mean for you in your role. Gain a deep understanding of the central areas of finance; how accountants think; how the numbers help you understand performance and set targets; budgeting and forecasting; and investment appraisal. 

Overview The valuation of corporates is a fundamental skill required of a wide range of finance professionals including equity analysts, strategists, corporate finance executives, fund managers, PE/VC executives, and general bankers. The recent volatility of corporate valuations, combined with the emergence of new sectors, makes understanding the theory and practice of valuation essential. This practical course is taught using inter-active sessions that comprise lectures followed by short, practical, and interactive case studies and exercises to reinforce the concepts covered in each teaching session. Emphasis is placed on delegates gaining hands-on experience with various valuation techniques.

This qualification covers complex accounting and finance topics and tasks leading to students becoming confident with a wide range of financial management skills and applications.  Course Overview This qualification covers complex accounting and finance topics and tasks leading to students becoming confident with a wide range of financial management skills and applications. Students will gain competencies in drafting financial statements for limited companies, recommending accounting systems strategies and constructing and presenting complex management accounting reports. Study the Level 4 Diploma in Professional Accounting to master complex accounting tasks and qualify for senior finance roles, as well as AAT full membership. The jobs it can lead to: • Accounts payable and expenses supervisor • Assistant financial accountant • Commercial analyst • Cost accountant • Fixed asset accountant • Indirect tax manager • Payroll manager • Payments and billing manager • Senior bookkeeper • Senior finance officer • Senior fund accountant • Senior insolvency administrator • Tax supervisor • VAT accountant Entry Requirements: Students can start with any qualification depending on existing skills and experience. For the best chance of success, we recommend that students begin their studies with a good standard of English and maths. Course Content: Applied Management Accounting (mandatory): This unit allows students to understand how the budgetary process is undertaken. Students will be able to construct budgets and then identify and report on both areas of success and on areas that should be of concern to key stakeholders. Students will also gain the skills required to critically evaluate organisational performance. Learning outcomes: • Understand and implement the organisational planning process. • Use internal processes to enhance operational control. • Use techniques to aid short-term and long-term decision making. • Analyse and report on business performance. Drafting and Interpreting Financial Statements (mandatory): This unit provides students with the skills and knowledge for drafting the financial statements of single limited companies and consolidated financial statements for groups of companies. It ensures that students will have a proficient level of knowledge and understanding of international accounting standards, which will then be applied when drafting the financial statements. Students will also have a sound appreciation of the regulatory and conceptual frameworks that underpin the preparation of limited company financial statements. Learning outcomes: • Understand the reporting frameworks that underpin financial reporting. • Draft statutory financial statements for limited companies. • Draft consolidated financial statements. • Interpret financial statements using ratio analysis. Internal Accounting Systems and Controls (mandatory): This unit teaches students to consider the role and responsibilities of the accounting function, including the needs of key stakeholders who use financial reports to make decisions. Students will review accounting systems to identify weaknesses and will make recommendations to mitigate identified weaknesses in future operations. Students will apply several analytical methods to evaluate the implications of any changes to operating procedures. Learning outcomes: • Understand the role and responsibilities of the accounting function within an organisation. • Evaluate internal control systems. • Evaluate an organisation’s accounting system and underpinning procedures. • Understand the impact of technology on accounting systems. • Recommend improvements to an organisation’s accounting systems. Business Tax (optional): This unit introduces students to UK taxation relevant to businesses. Students will understand how to compute business taxes for sole traders, partnerships and limited companies. They will also be able to identify tax planning opportunities while understanding the importance of maintaining ethical standards. Learning outcomes: • Prepare tax computations for sole traders and partnerships. • Prepare tax computations for limited companies. • Prepare tax computations for the sale of capital assets by limited companies. • Understand administrative requirements of the UK’s tax regime. • Understand the tax implications of business disposals. • Understand tax relief, tax planning opportunities and agent’s responsibilities in reporting taxation to HM Revenue & Customs. Personal Tax (optional): This unit provides students with the fundamental knowledge of the three most common taxes that affect taxpayers in the UK: Income Tax, Capital Gains Tax and Inheritance Tax. With this knowledge students will be equipped to not only prepare the computational aspects of taxes, where appropriate, but also appreciate how taxpayers can legally minimise their overall taxation liability. Learning outcomes: • Understand principles and rules that underpin taxation systems. • Calculate UK taxpayers’ total income. • Calculate Income Tax and National Insurance contributions (NICs) payable by UK taxpayers. • Calculate Capital Gains Tax payable by UK taxpayers. • Understand the principles of Inheritance Tax. Audit and Assurance (optional): This unit aims to give a wider understanding of the principles and concepts, including legal and professional rules of audit and assurance services. The unit will provide students with an awareness of the audit process from planning and risk assessment to the final completion and production of the audit report. Students will also get a practical perspective on audit and assurance, with an emphasis on the application of audit and assurance techniques to current systems. Learning outcomes: • Demonstrate an understanding of the audit and assurance framework. • Demonstrate the importance of professional ethics. • Evaluate the planning process for audit and assurance. • Review and report findings. Cash and Financial Management (optional): This unit focuses on the important of managing cash within organisations and covers the knowledge and skills to make informed decision on financing and investment in accordance with organisational policies and external regulations. Students will identify current and future cash transactions from a range of sources, learn how to eliminate non-cash items and use various techniques to prepare cash budgets. Learning outcomes: • Prepare forecasts for cash receipts and payments. • Prepare cash budgets and monitor cash flows. • Understand the importance of managing finance and liquidity. • Understand the way of raising finance and investing funds. • Understand regulations and organisational policies that influence decisions in managing cash and finance. Credit and Debt Management (optional): This unit provides an understanding and application of the principles of effective credit control systems, including appropriate debt management systems. Students will be introduced to techniques that can be used to assess credit risks in line with policies, relevant legislation and ethical principles. Learning outcomes: • Understand relevant legislation and contract law that impacts the credit control environment. • Understand how information is used to assess credit risk and grant credit in compliance with organisational policies and procedures. • Understand the organisation’s credit control processes for managing and collecting debts. • Understand different techniques available to collect debts. DURATION 420-440 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate