This is spreadsheet relate to link for Q4 f(v) a,b,c i need help with them please

4f(v) To minimise errors when reconciling any payments received from debtors, a new integrated financial statement spreadsheet has been established. Required: Click on this link to the Integrated financial statements spreadsheet and answer the following questions. a. If on 30 July Client CD paid the amount owing in full, what would be the balance in the Balance Sheet Bank account? b. If on 30 July Client CD paid only half the amount owing, what would be the balance in the Balance Sheet Bank account? c. Why does the value of total assets remain unchanged when Client CD pays any amount of the outstanding debt? Balance Sheet as at 30 June Subsidiary ledger 30 June Balance Subsidiary ledger 30 July Balance Income Statement for the year ended 30 June Sales 110,000 Less Cost of Goods Sold 16,500 Gross Profit 93,500 Current Assets Bank Accounts Receivable Inventory 33,000 6,450 8,000 47,450 Less Operating Expenses Petty Cash Administration expenses Insurance expense Rent expense Wages expense Total expenses Client AB Client CD Client EF Client GH Client Client KL $450 $1,500 $1,400 $800 $1,050 $1,250 $450 $1,500 $1,400 $800 $1,050 $1,250 Non-Current Assets Equipment 11,000 26,400 4675 14025 37400 82500 Total Assets 58,450 Total $6,450 $6,450 Net Profit 11,000 Current Liabilities Accounts payable Wages Accrued 3,200 7,250 10,450 Non-Current Liabilites Bank Loan 20,000 Total Liabilites Net Assets 30,450 28,000 Owners Equity Capital 1 July 0/B Net Profit 17,000 11,000 28,000