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 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.
Duration 5 Days 30 CPD hours This course is intended for Project Team Members IT Support Team Members Advanced Business Analysts System Administrators Application Consultants Business Process Owners / Team Leads / Power Users Program / Project Managers Trainers Overview Learn how to design, configure, consolidate, and report with BPC Standard In this course, students learn all of the key steps to set up Consolidation based on the SAP Business Planning and Consolidation, version for SAP NetWeaver. SAP Business Planning and Consolidation Overview Describing SAP Business Planning and Consolidation Running Consolidation Tasks Implementing BPC Standard Consolidation Modeling Consolidation Structures and Reporting Configuring Environments and Dimensions Creating Models for Consolidation Creating Reports and Formats in the EPM Add-In Report on BPC Standard Data in Analysis for Office Data Collection and Preparation Collecting Transforming Data for Consolidation Scenarios Creating Consolidation Logic Configuring Reclassifications Configuring Balance Carryforward Managing Journals Consolidations and Eliminations Translating Local Currency Configuring Intercompany Matching and Booking Using the Ownership Manager Configuring Integration Rules Eliminating Intercompany Transactions Configuring Intercompany US Elimination Designing Management, Matrix, and Multiple Accounting Standard Solutions Describing Consolidation and Elimination Principles Consolidating Investments Describing Stage Consolidation Configuring Scope Variation Configuring Equity Pickup Consolidation Process Monitoring Configuring Work Status Using the Controls Monitor to Validate Data Configuring Consolidation Business Process Flows
In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over £570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases. As a manager of a law firm, or more crucially an MLRO or MLCO, the ultimate responsibility for the firm's compliance, including with the MLR 2017, lies with you. It is your responsibility to ensure that the firm puts in place, reviews and updates compliant policies, controls and procedures. You must ensure that the firm maintains an up to date practice wide risk assessment. You are required to ensure that your employees are regularly given training on the MLR 2017 and associated risks. If a breach occurs, the SRA will take a wider look at the firm and identify any supervisory deficiencies that may have contributed to failures by fee earners or support staff. It has proven that it will not shy away from holding to account managers, compliance officers and MLRO/MLCOs for failures by their firms to comply with requirements of the MLR 2017. This course will cover the following to assist firms MLROs, MLCOs and Management with fulfilling their AML management responsibilities: How to comply with your obligations and stay compliant FWRA – linked with PCPs Mandatory AML Policies and Procedures - SRA have concerns Training and supervising staff Audits SRA requirements Reporting SARS POCA/TA Fulfilling reporting officer and compliance officer duties Target Audience The online course is suitable for MLROs, MLCOs, firm management and those supporting these roles. Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Helen Torresi, Consultant, DG Legal Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services. Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).
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
Overview The comprehensive course will cover the fundamentals of portfolio management, and delve deeper into risk and return. Participants will develop their understanding of how and why investors allocate money to fixed income, the numerous issues that impact risk and return, and the mechanics of portfolio construction.
Overview This course is designed to evaluate the financial statement, budget and making an effective decision. It will help to understand Discounted Cash Flow and its techniques, applications of financial statements and decision-making process. In this programme, you will challenge representatives to learn how to make use of financial statements to assess the strategic or financial performance of an organization. It will help to understand DCF Discounted Cash Flow techniques along with their apps for financial making decisions and making use of ratios in order to identify the major areas of concern. Find out the elements like weaker financial signals, major success factors, and robust financial signals within your own industry. It Projects future performance assuredly through real-world budgeting.
Overview This course is specially designed, this 5-day Financial Risk Management training course works to expand delegate's understanding and practical skills in the field of financial risk management. Specifically, this training course investigates the inter connection of risk in terms of markets, credit, operations, liquidity and reputation. Via intensive instruction and practical exercises, delegates will explore relevant techniques and methodologies, such as value-at-risk, credit modelling and stress testing.
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.