Introduction to financial statements


This course will give you step-by-step guide to analysing historical financial statements in Microsoft Excel. Using the financial statements of a fictional company, you will learn how to evaluate the performance of a company by testing for profitability, solvency and liquidity, building common-size financial statements and calculating a host of other financial KPIs.  Created & customized for Chartered Accountants Ireland by

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
CPD hours:  
Speaker details
First nameLast name


Product type:  
CPD online course
Information technology

Who Should Attend?

This course is suitable for advanced learners who are very familiar with writing formulas and performing analysis in Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 14 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Introducing Financial Statements
  • Revenue & revenue recognition
  • Calculating gross profit
  • Operating expenses
  • Interest, taxes & net profit
  • Common-size income statements
  • Current assets
  • Current liabilities and liquidity ratios
  • Long-term assets
  • Long-term liabilities and Shareholders' Equity
  • Common-size balance sheet
  • Statement of cash flows
  • Additional Financial KPIs

Key Outcomes

Once you have completed this course you will know how analyse each of the 3 financial statements. You will know what each line in the Balance Sheet, Income Statement and Statement of Cash Flows represents. And lastly, you will know how to evaluate company performance by calculating a host of different financial metrics.