can you solve this question in exel sheets

f you know that, the fiscal year of XYZ Company begins on 01/01 and ends on $1/12, and the beginning account balances as follows: cash balance 5,000 Accounts receivable 10,000 1 Accounts payable 8,000 Administrative expense 6,000 In addition, the company estimates its sales and purchases from the beginning of the month of January until the end of April according to the following schedules: Month Budgeted Sales Budgeted purchases 5,000 January February 10,000 March 12,000 April 20,000 47,000 Total 4242 44 10,000 20,000 20,000 30,000 80,000 44 From the data given above Prepare a cash budget using a spreadsheet.in addition use the below information: Preparing a Scheduled of expected cash collection proceeds from sales, if you know that the company's policy when selling states that : 70% of sales are collected during the month of sale, and 30% of sales are collected during the following month. 2 Prepare a Scheduled of expected cash disbursement for purchases, if you know that the company pays: 50% of the purchases during the month of purchase, and pays 50% of the purchases during the following month. Management would like to have a cash balance at least 5,000 at the end of each month. 3 4 The board of director has approved cash dividend of 6,000 for March. 5 Management planes to spend 5,000 on equipment purchase April