Check all of my answer and corect anything is wrong please

?also explain the

Cash Beginning Balance

25000

44555

45442

40418

25000

Master Budget: XYZ Merchandising Company

XYZ Merchandising Company is preparing its master budget for year 20X2, please consider the balance sheet below prepared for the year 20X1.

XYZ Merchandising Balance Sheet December 31, 20X1
Cash	25,000
Accounts Receivable	52,600
Inventory	30,500
Long-Term Assets	50,000
Accounts Payable		27,420
Common Stock		75,000
Retained Earnings		55,680

a. Sales for the first quarter of 20X2 are expected to be $150,000 and sales are expected to increase each quarter by 10% through quarter four of 20X2. Sales for the first quarter of 20X3 are expected to be $180,000. All sales are initially on credit.

b. Credit sales are collected over two quarters. In the quarter of sale 60% of the credit sales are collected and the additional 40% is collected in the quarter following the sale.

c. Cost of Goods Sold equals 60% of Sales. Inventory purchases at ABC are made based on a desired ending inventory of 25% of the next quarters Cost of Goods Sold, beginning inventory is $30,500.

d. All inventory purchases are made on credit and the payment cycle is over two quarters with 50% of the purchases being paid in the quarter of purchase and the remainder paid in the following quarter. Inventory units cost $5.00 each.

e. Selling and administrative expenses include a variable and fixed portion. The variable portion is 25% of Sales and the fixed portion will be $17,000 for the 1^st quarter, $18,000 for the 2^nd quarter, $20,000 for the 3^rd quarter, and $22,000 for the 4^th quarter. All cash payments are made in the same quarter as the expense. The fixed portion of S & A Expenses includes $3,000 of depreciation in the 1^st quarter, 4,000 in the 2^nd, 6,000 in the 3^rd, and 8,000 in the 4^th.

f. The company plans on paying $2,000 in cash dividends each quarter and will make cash investments in equipment in the 2^nd quarter for $8,000, the 3^rd quarter for $12,000, and the 4^th quarters for $17,000.

Required:

Please complete the sales budget, cash receipts from sales, inventory purchases budget, cash payments for inventory, selling and administrative budget, cash payments for selling and administrative costs. Please clearly identify any amounts that are relevant for the cash budget or the pro-forma financial statements. Complete a Cash Budget with the information provided in letter f.

1 Sales Budget Q4 Summary Sales $150,000 $165,000 $181,500 $199,650 $696,150 3 5 Cash Recepts Quarter of 60% $90,000 $99,000 $108,900 $119,790 $52,600 $60,000 $66,000 $72,600 $79,860 8 Quarter after 40 Total S142,600 S159000 S174900 S192390 S668,890 9 11 Inventory Purchases CGs $90,000 $99,000 S108,900 S119,790 S417,690 13 14 Add: Ending Inventory $24,750 $27,225 $29,948 $27,000 $27,000 15 Inventory Needed $114,750 126,225 $138,848 $146,790 $444,690 16 Less: Beginning Inventory 7 Total 19 Cash Payments A/R 20 Q3 Q4 $27,420 $42,125 $50,738 $55,811 $42,125 $50,738 $55,811 $58,421 $58 A21 22 50% $69,545 $92,863 $106,549 $114,233 $383,189 23 24 Selling& administrative Budget 26 27 Variable Cost (25% of sales $37,500 $41,250 $45,375 $49,913 S174,038 28 29 Fixed Costs in Cash $17,000 $18,000 $20,000 $22,000 $3,000 $4,000 $6,000 $8,000 30 Less: Depreciation $14,000 $14,000 $14,000 $14,000 $56,000 32 Add: Variable cost $37500 $41.250 $45.375 $49913 $51,500 $55,250 $59,375 $63,913 S230,038 33 Total 35 86 Cash Payments (100%) $51.500 $55,250 $59,375 $63,913 s230,038 37 38 Dividend Paid In Cash $2,000 $2,000 $2,000 $2,000 $8,000 39 Purchase of Equipment $0 $8,000 $12,000 $17,000 $37,000 40 11 Cash Budget 43 Cash Beginning Balance $25,000 $44,555 $45,442 $40,418 $25,000 Add: Collections from $142,600 $159,000 $174,900 $192,390 $668,890 44 Customers $167,600 $203,555 $220,342 $232,808 $693,890 15 Total Cash Available 47 Less: Disbursements 48 Purchases $69,545 $92,863 $106,549 $114,233 $383,189 operating Expenses (Variable & $51,500 $55,250 $59,375 $63,913 $230,038 49 Fixed Cash $2,000 50 Dividends $2,000 $2,000 $2,000 $8,000 51 Equipment purchases 50 $8,000 $12,000 $17,000 $37,000 32 Total Disbursements $123,045 $158,113 $179,924 $197,145 $658,226 53 $44,555 $45,443 $40,418 $35,663 $35,663 54 Closing Cash balance