Financial Statement Analysis using Excel 


The course on Financial Statement Analysis using Excel in Dubai is designed to develop your knowledge and understanding of advanced financial analysis techniques. You will also learn how to apply them, as well as the concepts and principles which underpin them. This course will also help both accountants and auditors identify issues which may require preventative action.

This course will also provide you with the necessary analytical framework and a wide array of practical tools to help you understand and exploit information in financial statements. You will be shown how to examine the many valuable and relevant pieces that make up a financial statement.

Application of advanced techniques will enable you to gain more information out of financial statements, allowing you to better assess a company’s profitability and risk and to make more accurate valuations.

Key Takeaways

  • Be able to identify the significance of the financial statements and know their purpose
  • Understand significant options that companies have in preparing financial statements
  • Know what warning signs to lookout which indicate that company is getting into financial difficulty
  • Appreciate the main financial ratios which can be calculated and what they mean

Key Discussion Areas:

  • The significance of Financial Statements
  • Ratio Analysis : Practical case to analyze a firm’s financial performance
  • Corporate Reporting – a tool for decision making
  • Key Performance Indicators (Performance Prism)
  • Identifying the Strategic objective (Customers, Stakeholders)
  • Financial Strategic Modeling (5-year Business Plans)
  • Economic Value Added
  • Free Cash Flow and its implications
  • IFRS/FASB/IASB New Standards Impact- Revenue, Leases & Consolidations
  • Tools Of Financial Analysis And Control
  • Management’s , Owners & Lenders point of view
  • Integration of financial performance analysis
  • Financial and operating leverage
  • Liquidity & Stress analysis
  • Theory of capital structure
  • EBIT-EPS analysis
  • The Cost Of Capital And Business Decisions
  • Capital asset pricing model
  • Risk categories
  • Weighted cost of capital
  • Multiple rate analysis
  • Fraud Analysis Ratios
  • Valuation And Business Performance
  • Capital asset pricing model
  • Dividend discount model
  • Analysis of company’s performance
  • The most recent trends in company valuations;
  • Merton model, KMV model
  • The use of financial statements for credit risk
  • The importance of analysing off-balance sheet obligations
  • Balance sheet and assessing the company’s liquidity risk

Course Outline

Introduction to Financial Analysis

o Overview of Financial Analysis

o The Importance of Financial Reporting

o The Time Value of Money

Basic Financial Analysis Concepts and Principles

o Generally Accepted Account Principles (GAAP)

o The Double-Entry System

o Overview of Financial Statements

Overview of the Balance Sheet

o The Balance Sheet & Value Problem

o Hidden Balance Sheet Hazards

o The Common Form Balance Sheet

Overview of the Income Statement

o Overview of Cash Flow Statement

o The Cash Flow Statement

o Analytical Applications

o The Company Life Cycle through Cash Flow

Analyzing Financial Statements

o Analyzing Performance and Condition

o The Accounting Cycle

o Interpreting Financial Statements

o Spreading Financial Statements

o Analyzing the Balance Sheet

o Analyzing the Income Statement

o Analyzing Combined Statements

Financial Ratios

o Overview of Ratios

o Types of Ratios

o Significance of Ratios