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
Online
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