Overview
This session examines how you can create a combined Profit & Loss, Balance Sheet and a Cash Flow budget.
This session uses the subscription version of Excel with dynamic arrays.
We will focus on reviewing existing formulas and structures.
Why you should Attend
Getting your Balance Sheet to balance in a budget can be a challenge. There are different ways to model Balance Sheet items - see examples that handle most situations.
Areas Covered in the Session
The techniques covered include:
- Display and format techniques for budgets
- Functions used EDATE, IF, SUMIFS, INDEX, MATCH
- Dynamic array function used SEQUENCE
- Using dynamic array formulas
- Using centralised logic calculations
- Different budget assumption calculations
- Handling single or monthly assumptions
- Getting a flexible starting position for the balance sheet
- Using a workings sheet
- Loan schedule
- Handling GST
- Validations that handle error cells
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
Instructor
Neale Blackwood