3-day Virtual Seminar

Three Statement Excel Budget

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