In these uncertain times, constructing dynamic cash flows is important to go ahead of the invariable forecasting protocol. The course equips you with a comprehension of the critical stages in building effortless yet robust forecast models and also helps you handle recognized model complexities by employing the best modeling methodologies and techniques. Our course offers a step-by-step and in- depth knowledge of the tools for structuring your model strategy per your business requirements. The trainees will also thoroughly understand applying and practicing the essential methodologies and techniques in quantitative risk analysis and incorporating flexibility into their forecast models

Overview

The course is an exceptional and interactive real-time training solution, improving your skills in financial modeling, cash flow, and risk analysis.

On completion of the course, you will be able to:

Renew your business prediction skills and advance your decision-making choices;
Build a complete forecast model and get acquainted with model items, such as assets, debt, depreciation, and more;
Carry out advanced sensitivity analysis, construct alternative scenarios;
Enhance your financial model’s blueprint, style, and framework.

Who should attend

All individuals who want to improve their financial modeling skills should attend this course

Middle to senior managers from different industries
All professionals who want to deal or currently deal with financial modeling in their company
Consultants, advisors, and other professionals who wish to improve their modeling skills

Methodology

The nontheoretical methodology includes interactive discussions, case studies, interactive games, and assignments to understand the concepts and their applicability.

Trainer

We carefully choose all our trainers with rich and vast experience in the financial sector. The course will be conducted by an experienced training consultant having more than 20 years of industry experience with some of the world’s leading financial institutions, specializing in corporate finance, investment banking, and private equity.

About the Certification

All About the FMI examinations?

The FMI conducts its examinations on three levels as follows:

Level 1 – Advanced Financial Modeller (AFM)

The FMI level 1 course helps you to prepare for the AFM examination. The course concentrates on the basic skills essential for designing and building an organization's completely-integrated financial forecast model.

Level 2 – Chartered Financial Modeller (CFM)

The FMI level 2 course helps you to prepare for the CFM examination. The course enables you to gain in-depth and comprehensive knowledge of advanced corporate finance (valuation, project economics), financial modeling (capital structure, mergers, and acquisitions, LBO), and data manipulation.

Master Financial Modeller (MFM)

The FMI level 3 examination assesses your mastery over eight complex topics and specialties: private equity, real estate, resources, digital and technology, industrial markets, healthcare, supply chain, and more.

Why should you earn the level 2 CFM certification?

• Securing the level 2 CFM certification validates that one has advanced and complete knowledge of financial modeling, financial analysis, and advanced Excel. Candidates who wish to take the level 2 CFM course should have earned the level 1 AFM certification.

• Earning the Level 2 CFM certification will demonstrate that you can handle any complex modeling scenario.

• The level 1 AFM examination assesses the candidates for their basic knowledge of financial modeling. In contrast, the level 2 CFM examination further assesses these skills by introducing concepts related to financial analysis and problem-solving, which are desirable in a prominent analyst or manager.

Who should take up the level 2 CFM certification?

The level 2 CFM certification is ideal for professionals who:

• Work in collaboration with managers to offer financial modeling perceptions;

• Make sure that various projects advance per the financial modeling best practices;

• Use models to show the business case and “narrate the story.”

Topics that need to be covered for the level 2 CFM certification

In the 4-hour exam, students should finish various tricky questions from complex modeling topics, including revenue, operating costs, depreciation, working capital, income tax, debt, equity, subsidiaries, model automation, timing flexibility, model checking, data management, and sensitivity analysis.

Course Content

Module – 1

Revenues

• Creating revenue schedules with the incorporation of divisional allocations

• Creating revenue schedules based on geography, currency, and capacity constraints

• Forecasting revenue based on operational changes and contingent revenue

Module – 2

Operating and Non-operating Costs

• How to build a cost schedule based on economies of scale

• What is multi-currency costing?

• Analyzing semi-variable or step-function costs

Module – 3

Capital Expenditures and Depreciation

• Assessing the different methodologies for building a depreciation schedule

• Criteria for purchasing and disposing of depreciable company assets

• Determining the useful life of fully depreciating company assets

Module – 4

Working Capital

• Studying the different working capital issues of companies

• How to build a working capital schedule based on an inventory continuity schedule?

• How to calculate working capital in a monthly or quarterly model?

Module – 5

Income Tax

• How does a company build a tax schedule based on its tax losses?

• What is the tax loss continuity schedule?

• Calculating income tax for a company operating in multiple jurisdictions

• Calculation of effective tax rates for companies

Module – 6

Debt

• How to model facets of a complex capital structure with various debt features

• Calculating various debt ratios compared with covenants

• What is debt sculpting?

• Building debt refinancing functionality into debt schedules

Module – 7

Equity

• Modeling equity issues, such as issuances/buybacks

• Tracking the impact of various dilutive securities

• Calculation of tiered equity returns

Module – 8

Subsidiaries

• Modeling financial statements with noncontrolling/minority interest

• Modeling financial statements for equity method investments

• Modeling financial statements for long- term investments

Module – 9

Sensitivity Analysis/Summary Page Automation

• Creating a dynamic, easy-to-interpret summary page

• Automating summary dynamically for multiple model scenarios

• Creating an input section for analysis of sensitivities and scenarios

Module – 10

Timing Flexibility

• Building timing flexibility for events and transactions in financial models

• Building automated timing switches for timing product launches

• Making automated timing switches for timing financing transactions

Module – 11

Model Checking

• How to spot embedded errors using Excel techniques

• Correcting errors in financial models without employing third-party tools

• Including master checks in financial models for spotting embedded mistakes and inconsistencies

Module – 12

Data Management

• Managing large data sets to analyze trends

• Using Excel tools and formulas to extract requested information from large datasets

If you need further information, please visit www.riverstonetraining.com.sg or send mail at info@riverstonetraining.com.sg or whatsapp at +65 9730 4250

Riverstone – Corporate Training

https://www.riverstonetraining.com.sg

Chartered Financial Modeler (CFM)