Grover Limited, liquid soaps is ready to begin its first quarter, in which peak sales occur. The company wants to re-assess its cash management strategy. Hence, senior manage provided data for the first quarter of the current year and the last to month of the year before. As a result, directors requested a cash budget for the period. a. On January 1, the beginning of the third quarter, the company will have a cash balance of $110,000. b. Actual sales for the last two months of the prior quarter and budgeted sales for the first quarter of 2022 are as follows All sales are on credit. Past experiences show that 20% of a months sales are collected in the month of the sale, 70% in the month following the sale, and 10% in the second month following the sale. November $200,000 December $250,000 January $400,000 February $750,000 March $1,000,000 c. Budgeted merchandise purchases and budgeted expenses for the third quarter are given below: January February March Purchases $250,000 $400,000 $200,000 Wages $50,000 $55,000 $60,000 Advertising $150,000 $120,000 $175,000 Other expenses $50,000 $50,000 $50,000 Purchases as paid in full one month after the month of purchase. The total purchase for the month of December 2014 was $200,000. Other expenses include depreciation of $40,000 per month d. Equipment costing $20,000 will be purchased for cash during February 2015, while a machine is to be bought at a cost of $69,000 during the month of March 2015. e. In preparing the cash budget, assume that the $50,000 loan will be made at the end of January 2015 at 12% per annum. The loan as well as any interest will be paid at the end of the first quarter Required: (i) Prepare a schedule of expected cash collections for January, February, and March and for the quarter in total. 6 marks (ii) Prepare a cash budget, by month and in total, for the third quarter. 23 marks (iii) If the company needs a minimum cash balance of $25,000 to start each month, can the loan be repaid as planned? Explain