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.


Details


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:

Online

13-14 & 17-18 August 2020
30 November & 1-3 December 2020

Face to Face
27 & 28 October 2020

BOOK NOW


Content


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

Exercises
• 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

Exercises
• Industry comparison
• Company analysis


BOOK NOW