please in excel

please in excel

WC UVCCI HOL BUS. IL COMally Tas approached the Bank for a 90-day loan of $25,000. The Bank has asked the corporation to submit a cash budget for the 90 days period. The following data has provided to you: a. On October 1s the beginning balance of cash will be $10,000. b. Sales figures is given below Month Sales in Dollars August 2019 $40,000 September 2019 $42.000 October 2019 $60,000 November 2019 $90,000 December 2019 $92,000 Past experience shows that 40% of a month's sales are collected in the month of sale, 55% in the month following sale, and 5% in the second month following sale. . c. Budgeted raw materials purchase and expenses is given below in dollars October November December Materials Purchase 48,000 47,000 52,000 Salary Expense 16,000 16,000 16,000 Utilities Expense 2,000 2,000 2,000 Depreciation Expense 3,000 3,000 3,000 Rent Expense 2,500 2,500 2,500 d. Payment for Material purchase is always paid in the following month. e. Payment for Material purchase due for the month of September to be paid in October is $46,000 f. The company paid a dividend of $3,000 in October g. They bought a computer for $1,800 and paid in cash in October h. In preparing the cash budget, assume that the beginning of November 2019 $90,000 December 2016 $92,000 Past experience shows that 40% of a month's sales are collected in the month of sale, 55% in the month following sale, and 5% in the second month following sale. - c. Budgeted raw materials purchase and expenses is given below in dollars October November December Materials Purchase 48,000 47,000 52,000 Salary Expense 16,000 16,000 16,000 Utilities Expense 2,000 2,000 2,000 Depreciation Expense 3,000 3,000 3,000 Rent Expense 2,500 2,500 2,500 d. Payment for Material purchase is always paid in the following month. e. Payment for Material purchase due for the month of September to be paid in October is $46,000 f. The company paid a dividend of $3,000 in October g. They bought a computer for $1,800 and paid in cash in October h. In preparing the cash budget, assume that the $25,000 loan will be taken in the beginning of October and repaid in December with interest at the rate of 6% per year. Required: Prepare 1. Prepare a schedule of cash collections for the fourth quarter. 2. Prepare the Cash Budget to be submitted to the Bank for the fourth quarter