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