Pro forma balance sheet Peobody 8 Peabody has 2022 sales of $109 inilion. It whhes to analyze expected performance and finarcing needs for 2024 - 2 years ahead. Civen the following information, respond to parts a, and b. (1) The percents of sales for itens that vary directly with sales are as follows Accounts recelvable; 12.3%, Irwentory, 17.7%, Accounts payable, 13.6%; Net profit margin, 3.1%. (2) Markotablo securties and other current fiabisties wit remain unchangod (3) Peabody desires a minimum cash balance of $402,000 (4) A new machine costing $552,000 wal be acquired in 2023, and equipment costing $848,000 will be purchased in 2024 . Total depreciation in 2023 is forecast as $286,000, and in 202.4$391,000 of depreciation will be taken (5) Accruats will fise to $498,000 by the end of 2024 (6) There will be no gale or retirenent of liong teeri debl (Z) No sale or repurchase of comrnon stock is expected (8) The dividend parout of 50% of net profits will continue. (9) The sales forecast procicts $117 million in 2023 and 5120 milion in 2024 a. Prepare a pro forma balance sheet daled 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 8 Peabody has 2022 sales of $10.9 million. It wishes to analyze expectod performance and financing needs for 20242y 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.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.)