Training Course: Advanced Financial Statements Analysis & Forecasting

Introduction

In today’s world, finance professionals are challenged by providing management with a detailed analysis of the impact of the organization's financial decisions. Therefore, finance professionals need to be skilled at reading through the numbers on the financial statements, analyzing the figures, interpreting the various ratios, and presenting this analysis in a dynamic manner. This course takes you from the first step of understanding the relationships between the different elements of financial statements, through the process of calculating and analyzing the financial ratios, to the last step of presenting recommendations. While applying Excel tools and techniques, various real-life examples of published financial statements will be used throughout the course.

Course Objectives

• Apply the framework of financial statements analysis.
• Use ratio and financial analysis.
• Interpret company financials and sector position.
• Appraise the process of company evaluation and analysis.
• Analyze real-life financial statements from companies traded in the world.
• Prepare financial analysis and template models.

Course Outlines

Day 1: 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.
• The financial statement analysis framework.
• The accounting cycle.
• Financial reporting mechanics.
• Relationship, elements, and classification of financial statements.

Financial reporting standards

• Importance of reporting standards in security analysis and valuation.
• The standards-setting bodies.
• International Financial Reporting Standards (IFRS) versus Generally Accepted Accounting Principles (GAAP).

Day 2: 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.

Day 3: Mechanisms of Financial Analysis Techniques

• Vertical analysis and strategy: balance sheet and income statement approach.
• 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.

Day 4: Boosting efficiency in your department

• The 10 must-have Excel tips.
• Working with text files.
• Looking up records from a database.
• Validating data and controlling data input.
• Reconciliations and accounts analysis using pivot tables.
• Creating management reports and dashboards.

Day 5: Financial forecasting techniques for analysts

• Income statement forecasting.
• Revenue.
• Cost of sales.
• Operating expenses.

Balance sheet forecasting

• Fixed assets.
• Working capital.
• Retained earnings and dividend policy.

Cash flow statement forecasting

• Operating cash flows.
• Free cash flows to the firm.
• Free cash flow to equity.