Understanding the income statement, balance sheet and cash flow statement and how they fit together is key to unlocking more complex concepts like valuation, ratio analysis, accounting shenanigans and equity investing.

Delegates will learn how the income statement, balance sheet and cash flow statement fit together and be able to produce integrated financial statement. Delegates will also understand how accrual accounting leads to differences in income and cash flow, and be confident reading a set of report and accounts.

Who should attend this course:

With extensive use of practical exercises and current company accounts, the Introduction to Financial Statement Analysis in Excel course is ideal for delegates with little prior accounting knowledge, or those seeking a refresher.


Duration: 2 days/4 online sessions

Location: London
CPD Hours: 12 / online 14
Level: Basic / Intermediate
Maximum number of delegates: 7
Course fee: £1195 + VAT
Next Dates:


9-12 March 2021



Day 1

• Key Excel functions, shortcuts and formatting

• Best practice modelling standards

 Understanding the income statement, balance sheet and cash flow statement
• Accrual accounting and other key concepts
•  Principles of DCF, DDM and EVA valuation methodologies
• Content & uses of company accounts and the Principal-Agent problem
• Linking together the financial statements
• Introduction to ratio analysis

• Familiarisation with the three main statements (income statement, balance sheet and cash flow)
• Building an integrated set of financial statements
• Ratio analysis

Day 2

• Identifying and forecasting key drivers

• Linking the financial statements

• Producing DCF, DDM and EVA valuations

• Comparing valuation methodologies

• Sensitivity analysis and presentation tools

• Industry comparison
• Company analysis