do the calculations in excel with the steps

Prepare a cash budget for Amigo Corporation for the 4th quarter.

The following information pertains to Amigo Corporation: Cash is collected from customers in the following manner: 40% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. Fixed manufacturing overhead costs are $34,000 per month which includes $8,000 of depreciation. The remaining costs are paid monthly