Question 5: Cash Flows Pearce Pty Ltd reports a profit for the year ended 30 June 2013 of $200,000. However, a disgruntled online customer illegally hacked into her systems, eliminating all her business records except those given below. The CEO, Linda Pearce wishes to piece together the ending bank account balance of the company, on 30 June 2013 (denoted by the question mark ?" symbol below). Following are summary comparative balance sheet accounts for the company: 30 June 2013 1 July 2012 Cash ? $20,000 Ac's Receivable $30,000 $25,000 Inventory $30,000 $40,000 Accounts Payable $15,000 $30,000 Unearned Revenue $12,000 $15,000 Prepaid Insurance $18,000 $33,000 Salary Payable $26,000 $12,000 Machine Equipment $300,000 450,000 Acc Depn Machine Equipment $150,000 $160,000 The company holds numerous machine equipment, all recorded in the "Machine Equipment account. No machine equipment was purchased in the 2012-2013 financial year, and there were no upwards or downwards revaluations of machine equipment during this period. There was, however, a sale of one machine equipment on 30 June 2013. This piece of machine equipment had an accumulated depreciation of $50,000 as at 30 June 2013 and was purchased for $150,000. The machine equipment was sold for $115,000. Pearce paid dividends of $10,000, and $15,000 in loan repayments were made, with 80% relating to the repayment of the loan itself (principal), while the remainder was the interest component of the loan repayment. Required: a) Prepare a Cash Flow Statement, use the indirect method to calculate the cash flow from operations. Then, determine the total cash change for the year, and provide your estimate of the ending cash balance on 30 June 2013