Financial Analysis and Forecasting: Tools and Techniques - Virtual Learning - Meirc

Financial Analysis and Forecasting: Tools and Techniques - Virtual Learning

Why Attend

In today’s constantly changing world, decision-making is a challenge given the high levels of risk and uncertainty. This course will provide participants with the essential skills required to develop robust financial models that can help analyze risks and aid in making sound future forecasts.

Course Objectives

By the end of the course, participants will be able to:

  • Use ratio and financial analysis to interpret company financials and industry position
  • Analyze real-life financial statements from companies traded on the international and GCC stock exchanges
  • Implement various financial analysis techniques such as liquidity, solvency, profitability, vertical, and horizontal analysis
  • Apply different forecasting techniques that assist in making sound financial and business decisions
  • Utilize Microsoft Excel to build effective forecasting models

Target Audience

Financial controllers, analysts, finance managers, accounting managers, supervisors, and finance professionals who need to interpret and analyze financial statements and use them to create and maintain forecasts in their organizations.

Target Competencies

  • Understanding and performing financial analysis
  • Performing vertical and horizontal trend analysis
  • Forecasting
  • Modeling financial statements
  • Applying Excel functions and tools


This is a hands-on training course using laptops. Participants are required to use their own laptops equipped with Excel 2016 or higher for the duration of the training.

  • Required components of financial statement analysis
    • Role of financial reporting and analysis
    •  Core financial statements and the importance of the annual report
    • The important role of notes and supplementary information
    •  Objectives of financial statements audit
    •  Types of audits
    •  Financial statement analysis framework
    •   The accounting cycle
    • Financial reporting mechanics
    • Relationship, elements, and classification of financial statements
  • An inside look at financial statements
    •  Income statement components
    • The three important components of income statements
    • Revenue and expense recognition
    • Balance sheet components
      • Measurement and classification
      • The five important components of a balance sheet
    • Statement of changes in owner’s equity
    •  Cash flow statement:
      • Operating, investing, and financing activities
      • Direct versus indirect methods in cash flow preparation
      • Reading and interpreting cash flow
      • The cash rich standard
  • Mechanisms of financial analysis techniques
    • Vertical analysis and strategy: balance sheet and income statement approaches
    • Horizontal trend analysis and growth
    • Liquidity analysis:
      • Current, quick, and cash ratios, defensive interval and cash conversion cycle
    •  Asset management and activity ratios:
      • Total and fixed assets turnover
    • Solvency analysis:
      • Debt, equity, and times interest earned ratios
    • Profitability analysis:
      • Profit margin, gross margin, return on assets, return on equity
    • Market and valuation:
      • Price earnings and earnings-per-share ratios
    • DuPont analysis: the three-step and five-step models
    •  Limitation of ratio analysis
  • Forecasting techniques
    • Qualitative models
      • Market research approach
      • Delphi method technique
    • Quantitative models
      • Causal models
        • Econometric models
        • Regression analysis: simple and multiple
        • Correlation coefficient and coefficient of determination
    • Time series methods
      • Simple average
      • Moving average
      • Exponential smoothing
      • Expected value
  • Modeling projected financial statements
    • Micro and macro factors
    •  Forecasting sales
    • Estimating market demand
    •  Estimating company demand
    • Developing sales forecast
    •  Forecasting cost of sales
    • Forecasting operating expenses
    • Forecasting key assets and liabilities accounts
    •  Modeling the income statement forecast
    •  Modeling the balance sheet forecast

Meirc Professional Certificate (MPC)

MPC certified courses by Meirc Training and Consulting are designed for those willing to challenge themselves and go the extra distance. Participants who fully attend an MPC course and successfully complete the test on the last day, will receive a Meirc Professional Certificate (MPC), in addition to the one they receive for attendance. MPC certificates are regionally recognized and can be quite valuable when applying for more senior roles within the organization or outside.

Per participant

USD 2,250

Fees + VAT as applicable

Tax Registration Number : 100239834300003

Online Training