(I) The percents of sales for items that vary directly with sales are as follows: Accounts receivable; 11.9%, Inventory, 17.5 Accounts payable. 14.5%; Net profit margin, 3.2% (2) Marketable securities and other current liabilities will remain unchanged. (3) Peabody desires a minimum cash balance of $482,000. (4) A new machine costing $051,000 will be acquired in 2023, and equipment costing $853,000 will be purchased in 2024. Total depreciation in 2023 is forecast as $290,000, and in 2024 $394,000 of depreciation wil be taken (5) Accruals will rise to $499,000 by the end of 2024 (6) There will be no sale or retirement of long-term debt (7) No sale or repurchase of common stock is expected () The dividend payout of 50% of net profits will continue (9) The sales forecast predicts $11.3 million in 2023 and $11.1 million in 2024 (10) The December 31, 2022, balance sheet is here a. Prepare a pro forma balance sheet dated December 31, 2024 b. Discuss the financing changes suggested by the statement prepared in part (a). Prepare a pro forma balance sheet dated December 31, 2024 Complete the assets part of the pro forma balance sheet for Peabody & Peabody for December 31, 2024 below (Round to the nearest dollar) Pro Forma Balance Sheet Peabody& Peabody December 31, 2024 Assets Current assets Cash Marketable securities $ ody desires a minimum cash balance of $482,000. machine.coction $51.000 will be sequited in 2022 and equipment costine co2 000 will be purchased in 2024 Tatal depreciation 2022 le forecast as $290,000, arm ua Data table e al sa e D ware cuss (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Assets Cash Marketable securities Peabody & Peabody Balance Sheet December 31, 2022 $400,000 Liabilities and Stockholders' Equity Accounts payable $1,398,000 200,000 Accruals 398,000 Accounts receivable Inventories 1,200,000 Other current liabilities 80,000 1,795,000 epard Total current liabilities $1,876,000 Total current assets $3,595,000 Long-term debt miete Net fixed assets 4,001,000 Common stock 2,004,000 3,716,000 Total liabilities and Total assets $7,596,000 stockholders' equity $7,596,000 Asse Curre C Markatole securices Accounts receivable Print Done - x a. Prepare a pro forma balance sheet dated December 31, 2024. Complete the assets part of the pro forma balance sheet for Peabody & Peabody for December 31, 2024 below: (Round to the nearest dollar.) Pro Forma Balance Sheet Peabody & Peabody Assets December 31, 2024 Current assets Cash $ Marketable securities $ Accounts receivable $ Inventories $ $ Total current assets Net fixed assets Total assets