Case Study 6 Case Study 5 The following budgeted information is provided for the business of Chalkley's Fishing Supplies for the year to end 30 June 2022 Below is the cash budget information for Robert Fuller for October, November and December Cash Sales $88,000 s Expected receipts Receipts from Accounts Receivable $132,000 October November December Purchase of Shop Fittings $11,000 $18,300 $20,000 $32,000 Payments of Accounts Payable 66,000 = Total budgeted purchases and expenses each month Investment Income Received $5,000 September October November December Repayment of Bank Loan $50,000 $10,400 $13,000 $20,000 $25,000 Operating Expenses Paid $44,000 = 20% of purchases and cash expenses are paid in the month in which they are incurred. The rest are Drawings by Chalkley $30,000 paid in the following month ! Depreciation is $24,000 per annum and is included in the purchases and expenses above Cash at Bank 1 July 2021 (Actual) $15,000 = GST of 5,800 is payable in October, along with an income tax instalment of $12,000 Cash at Bank 30 June 2022 (Budgeted) $30,000 = The expected balance in the bank account on 30 September is $3,000 . . , . /s, Fishing Supplies is GST-registered and reporis on a cash basis. Net GST Collecied will be remitied to (Use tab \"Case Study 5" in template provided in excel spreadsheet included with assessment on the ATO during the year teams for your answer) L B ~ - . (Use 1ab \"Case Study 6" in the template provided in excel spreadsheet included with assessment on Payments Budget teams for your answer) September | October | November December \"f* Prepare a budgeted Statement of Cash Flows for the year ended 30 June 2022 Purchases and Expenses Budgeted Statement of Cash Flows for the year end 30 June Payments s Same Month Cash Flow from Operating Activites, 1 Month Receipts from Customers GST Payments to Suppliers Income Tax Instalment Expenses Paid Total Payments Interest Received Net Cash from Operating Activities Cash Budget Cash Flows from Investing Activities October November December Total Payments for Shop Fittings Opening Cash Balance Net Cash from Investing Activities Add Receipts Cash Flows from Financing Activities Cash Available Repayment of Bank Loan Less Payments Payments for Drawings Ending Cash Balance Net Cash from Financing Activities Net Change in Cash Balance Cash Balance at start of year Depreciation calculation per month P P Cash Balance at end of the year