Paid Live Webinar $25 (includes live event, pdf manual and Excel file plus the recording)
Save money with the Webinar Pass ($20 webinars when you pre-pay).
This session examines how you can create a combined Profit & Loss, Balance Sheet and a Cash Flow budget.
We will focus on reviewing existing formulas and structures.
The techniques covered include
- display and format techniques for budgets
- functions used EDATE, IF, SUMIFS, INDEX, MATCH
- 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
Plus I will be sharing extra tips along the way.