A. Complete the table given above. B. Assuming that the firm has a cash balance of Rs. 80,000 at the beginning of September, determine the end-of-month cash balances for each month, September 2020 through July 2021. C. Assuming that the firm wishes to maintain a Rs. 25,000 minimum cash balance, determine the required total financing or excess cash balance for each month. D. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your answer.

The actual sales and purchases for ABC Co., for August & September 2020, along with its forecast sales and purchases for the period October 2020 through August 2021, follow. Actual & Forecasted Purchases Actual & Forecasted Sales 400,000 ? ? ? ? ? Year Month 2020 August Septembe 2020 2020 October Novembe 2020 2020 December 2021 January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August ? ? ? 2 ? ? ? ? ? ? ? ? ? ? ? ? ? ? Sales of every month of the first quarter of the year will increased by 20%, every month of the Second quarter of the year will increased by 30%, every month of the Third quarter of the year will decreased by 10% and every month of the last quarter of the year will increased by 10%. The firm makes 20% of all sales on Cash Sales. Total Purchases are 60% of the forecasted month sales. 40% of Accounts Receivable are collected in first month following the sale and 60% in the 2 months following the sale. Company purchased 30% on Cash and aid 20% of the remaining amount in 1" Month following to the purchases and 80% in 2nd Month following to the purchases. Other cash inflows are expected to be Rs. 12,000 in September and April, Rs. 15,000 in January and March, and Rs. 27,000 in February. Payroll amount to 15% of the preceding month's sales. Rent of Rs. 15,000 per month must be paid. Interest payments are 24% per year are due in November, January and April as monthly interest. A principal payment of 20% is also due in April. The total loan amount is Rs. 300,000 The firm expects to pay cash dividends of Rs. 25,000 in March, August and April. Taxes of Rs. 75,000 are due in September. The firm also intends to make a Rs. 65,000 cash purchase of fixed assets in October. A. Complete the table given above. B. Assuming that the firm has a cash balance of Rs. 80,000 at the beginning of September, determine the end-of-month cash balances for each month, September 2020 through July 2021. C. Assuming that the firm wishes to maintain a Rs. 25,000 minimum cash balance, determine the required total financing or excess cash balance for each month. D. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your