can I get Excell formulas as well please and thank you !

B29 XVfx E F un 6 OD B C D 1 Problem 3: Preparation of Purchase budget and Cash payment sched 2 3 Walton Inc. is preparing its inventory purchase budget for the second quarter of 20YY, 4 and provided the following sales budget for the second quarter of 20YY. 5 April May June 7 Projected sales $300,000 $400,000 $500,000 8 9 The following relevant information are also provided: 10 11 Budgeted monthly cost of goods sold equals 40% of budgeted monthly sales. 12 Each month's desired ending inventory should be $10,000 plus 10% of the current month's COGS 13. The ending inventory balance at March 31 20YY was $18,000 14 All purchases are made on account. 15 The company's suppliers require Walton to pay 30% of its accounts payable during the month of purcha 16 with the remaining 70% in the month after purchase. 17 The outstanding accounts payable at March 31, 20YY was $56,800 which is to be paid in April. 18 19 Required: 20 Use the Table below to prepare: 21 Inventory Purchase Budget and Cash Payment Schedule for the second quarter of 20YY. 22 Value must be entered in the green cells of the table below. 23 CA B29 V fox A C F L M 6 April B D E G H 1 Problem 3: Preparation of Purchase budget and Cash payment sched K 2 3 Walton Inc. is preparing its inventory purchase budget for the second quarter of 20YY 4 and provided the following sales budget for the second quarter of 20YY 5 May June 7 Projected sales $300,000 $400,000 $500,000 8 9. The following relevant information are also provided 10 11 Budgeted monthly cost of goods sold equals 40% of budgeted monthly sales. 12 Each month's desired ending inventory should be $10,000 plus 10% of the current month's COGS 13. The ending inventory balance at March 31 20YY was $18,000 14 All purchases are made on account. 15 The company's suppliers require Walton to pay 30% of its accounts payable during the month of purcha 16 with the remaining 70% in the month after purchase 17 The outstanding accounts payable at March 31, 20YY was $56,800 which is to be paid in April 18 19 Required: 20 Use the Table below to prepare: 21 Inventory Purchase Budget and Cash Payment Schedule for the second quarter of 20YY. 22 Value must be entered in the green cells of the table below. 23 24 Solution: 25 Siddique, Salina: 26 Inventory purchases budget for the second quarter 20YY Relevant budgeted data to be reported in the Budgeted Income Statement and Budgeted Balance Sheet 27 April May June Proforma statement data 28 Purchase Budget $ $ $ $ Siddique, Salina: Total Budgeted COGS to be reported in the Budgeted 29 Budgeted cost of goods sold Income Statement of the Second Quarter of 207Y 30 Desired ending inventory 31 Total inventory needed Siddique, Salina: 32 Less beginning inventory Desired Ending inventory to be reported in the Budgeted Balance Sheet as at Jume 30, 20YY Required inventory purchases 34 Schedule of cash payments for the second quarter 20YY $ $ 35 Cash payments for: 36 Current month's inventory purchases Siddique, Salina 37 Previous month's inventory purchases Expected Accounts Payable to be reported in the budgeted Balance Sheet as at June 30, 20YY. 38 Total cash payments for inventory 39 40 41 S