Certificate in Finance and Accounting Courses

Financial Analysis, Modeling & Forecasting Course


This comprehensive financial analysis, modeling, and forecasting course is intended to equip professionals with financial analysis and forecasting expertise.

The financial analysis, modeling, and forecasting course is designed for individuals looking to deepen their understanding of economic and financial analysis and those aspiring to enhance their modeling and forecasting skills with advanced techniques and Excel tools.

A thorough grasp of financial analysis principles is crucial for effective business management. This advanced financial modeling course goes beyond conventional financial analysis training courses.

The financial analysis, modeling, and forecasting course incorporates fundamental analysis principles and Excel's powerful capabilities to uncover strategic drivers that significantly uplift your organization's shareholder value.

Targeted Groups

  • Financial accounting team members.
  • Cost and management accounting staff.
  • Finance managers.
  • Planning managers.
  • Commercial managers.
  • Capital investment and project team members.

Course Objectives

Participants in the financial analysis, modeling, and forecasting course will be able to:

  • Grasp the essentials of strategic financial planning.
  • Employ cutting-edge financial analysis modeling and forecasting techniques.
  • Utilize financial tools, such as understanding the time value of money.
  • Determine critical performance indicators to manage business success drivers.
  • Forge tools for use in their businesses.
  • Learn the essential steps in developing a robust financial forecasting model.
  • Analyze a company's financial statements and forecast future performance.
  • Comprehend interest theory and time value of money applications.
  • Develop an economic and financial value-added model from a shareholder perspective.
  • Realize the extent of capital investment benefits.
  • Master Excel® tools like Solver, Goal Seek, and Scenario.
  • Impact shareholder value positively.
  • Gain confidence while discussing financial strategy.

Targeted Competencies

  • Performing capital budgeting analysis.
  • Forecasting cash flow.
  • Calculating the cost of capital.
  • Practicing financial modeling and analysis course techniques.
  • Understanding scenario analysis.
  • Calculating free cash flow.
  • Utilizing advanced Excel features.

Course Content

Unit 1: Overview of Financial Modelling and the International Business Environment

  • Define the team model and financial model.
  • Discover the 10 steps to create accurate economic and financial models.
  • Apply flowcharting techniques to enhance your model.
  • Overview of strategic and operational aspects in a global business context.
  • Understand the organizational planning model.
  • Delve into the product/decision/Information cycle.
  • Objectives of financial analysis.
  • Creating wealth by adding value.
  • Basic metrics of wealth creation and financial performance.

Unit 2: Analysing the Annual Report and Creating Shareholder Value

  • Dive into ratio analysis.
  • The heart of financial analysis
  • Utilize Excel templates for liquidity, leverage, and profitability metrics.
  • Interpret accrual accounting ratio analysis results.
  • Learn the "DuPont" formula and EVA® correlation.
  • Working with the Altman Z-Score
  • Benchmarking financial analysis with investment surveys.
  • Delve into shareholder value concepts.
  • Find the cost of equity.
  • Determine the cost of debt, preferred equity, and common equity.
  • Calculate the weighted average cost of capital WACC.
  • Construct the EVA© model.
  • Explore WACC's impact on acquisitions.

Unit 3: The Time Value of Money and Steps in Building Financial Models

  • Understand the effect of time on money value.
  • Master various interest calculations.
  • Using WACC and ROIC as benchmarks.
  • Utilize Excel® for present value, future value, NPV, IRR, and MIRR.
  • Apply IRR for capital project evaluation.
  • Know when to build models.
  • Understand models and shareholder value (EVA®).
  • Develop forecast validation criteria.
  • Determine model and forecast horizons.
  • Recognize risk in forecasts.
  • The significance of financial forecast model Excel assumptions.

Unit 4: Evaluating Capital Project Proposals and Excel Data Management

  • Identify the various types of capital projects.
  • Discuss the capital project evaluation process.
  • Determining the initial and subsequent capital project cash flows.
  • Create and develop a hurdle rate for projects.
  • Discuss terminal value in project analysis.
  • Apply Excel® for NPV, IRR, and discounted payback models.
  • Work with Financial Forecasting model methods.
  • Identify Historical Data patterns.
  • Leverage Excel® data analysis tools.
  • Critical Factors in Determining the Proper Time Horizon to Choose for Your Model
  • Determining Degrees of reliability in model projections
  • Selecting the degree of robustness and sensitivity of the model
  • Understanding and applying established modeling techniques.

Unit 5: Time Series Analysis and Investment Portfolio Evaluation

  • Creating time series models with various analytical tools.
  • Exponential smoothing as data analysis.
  • Validate time series analysis effectiveness.
  • Grasp sensitivity analysis utility.
  • Develop What-if scenarios.
  • Utilize Excel scenario and goal seek tools.
  • Fundamental principles of risk in securities.
  • Portfolio expected return and risk graphing with variance analysis.
  • Apply modern portfolio theory with the capital asset pricing model.
  • Portfolio management essentials.
  • Employ Excel to compute share beta on securities markets.

Certificate in Finance and Accounting Courses
Financial Analysis, Modeling & Forecasting Course (FA)


Mercury dynamic schedule is constantly reviewed and updated to ensure that every category is being addressed at least once a month, if not once every week. Please check the training courses listed below and if you do not find the subject you are interested in, email us or give us a call and we will do our best to assist.