Overview
Learn a practical method for developing a reliable cashflow statement that ensures your balance sheet always balances.
We'll cover my 'Twin Towers' concept, walk through the 5-step process for building cashflows, and highlight common mistakes to avoid.
Includes live demo examples and tips you can apply immediately.
Why you should Attend
- Your balance sheet doesn't always balance
- You're unsure if your cashflow is accurate
- You've seen inconsistencies between the income statement, balance sheet, and cashflow
- You need a simple but reliable method to build or audit financial model cashflows
Areas Covered in the Session
- The 'Twin Towers' concept to explain the cash effects of balance sheet changes
- My proven 5-step method to create reliable cashflows
- Build the structure Operating, Investing, Financing
- Calculate cashflows from P&L and balance sheet
- Adjust for non-cash items depreciation and dividends
- Compute closing cash balances
- Link to the balance sheet
- 3 common errors - how to find and fix them
Who Will Benefit
- Financial Modelers
- FP&A Professionals
- Accountants and Controllers
- Anyone building or reviewing Financial Models
Speaker Profile
Gary Knott is a chartered accountant and Excel trainer with over 30 years of experience including many years at Deloitte. He is the author of 'Avoid Excel Horror Stories', He was a speaker at the Global Excel Summit, and is a big fan of dynamic arrays, Power Query, and other modern Excel innovations. A sought-after trainer who makes Excel techniques easy, practical, and fun! He now works independently, helping clients improve their spreadsheets and reduce risk.
He’s a popular trainer known for clear, practical techniques and advice and who specializes in making complex tools simple, practical, and powerful.
Instructor
Gary Knott