please help

Cash Sales Credit Sales January February March April May June $50,000 $55,000 $43,000 $38,000 $48,000 $80,000 $150,000 $170,000 $130,000 $123,000 $200,000 $170,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections on sales: 50% in month of sale 40% in month following sale 10% in second month following sale I The accounts receivable balance on January 1 of the current year was $65,000. Required: Prepare expected cash collections budget for January, February, March, April and May