taparts a. and b. be tubre (5) hecruvis will ise to s4y 000 by the end of roes, (6) Jhere wit the ne sale or reteremene at lorg verm octa (7) tea cale or repurchase of common mock is extecied. (10) The Drcember 31. 2022, bavarker shitet in beie 2. Prepare a peo focma biahie sheet dated becenber 3s. 2ove. Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) 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: (Rou to parts a. and b. (2) Marketable securities and other current labilites with remain unchanged. (3) Peatoody desines a minimum cash balance of $462,000. be takon (5) Aconavs will tise to 4490,000 ty the end ot 2024 . (6) There wit be no saln of retiremem of long tem debt. (7) Na sale of reputchase of common saock is expecied (ii) The dimiend payou of 50 sof net peofis wil cortinue. (9) The saies threcast predicts 5113 milion in 2023 and 111.1 mation in 2024. (10) The Decenber 31, 2022, paiance sheet is hese a. Prepae a peo farnin halanoe sheet dated December 31, 2024. b. Discuss the financing cherges turpeuted by the statement prepared in pm (a) 2. Prepaie a poo terma bwance siere ased December 31. 2024. Data table (Click on the icon here : in order to copy the contents of the data table below into a spreadsheet.) to parts a. and b. (1) The percents of sales for items that vary directly with sales are as follows: Acce (2) Marketable securities and other current liabilities will remain unchanged. (3) Peabody desires a minimum cash balance of $482,000. (4) A new machine rnatinn $6510n will he arnulired in 2023 and enutinment cosatir 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 taparts a. and b. be tubre (5) hecruvis will ise to s4y 000 by the end of roes, (6) Jhere wit the ne sale or reteremene at lorg verm octa (7) tea cale or repurchase of common mock is extecied. (10) The Drcember 31. 2022, bavarker shitet in beie 2. Prepare a peo focma biahie sheet dated becenber 3s. 2ove. Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) 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: (Rou to parts a. and b. (2) Marketable securities and other current labilites with remain unchanged. (3) Peatoody desines a minimum cash balance of $462,000. be takon (5) Aconavs will tise to 4490,000 ty the end ot 2024 . (6) There wit be no saln of retiremem of long tem debt. (7) Na sale of reputchase of common saock is expecied (ii) The dimiend payou of 50 sof net peofis wil cortinue. (9) The saies threcast predicts 5113 milion in 2023 and 111.1 mation in 2024. (10) The Decenber 31, 2022, paiance sheet is hese a. Prepae a peo farnin halanoe sheet dated December 31, 2024. b. Discuss the financing cherges turpeuted by the statement prepared in pm (a) 2. Prepaie a poo terma bwance siere ased December 31. 2024. Data table (Click on the icon here : in order to copy the contents of the data table below into a spreadsheet.) to parts a. and b. (1) The percents of sales for items that vary directly with sales are as follows: Acce (2) Marketable securities and other current liabilities will remain unchanged. (3) Peabody desires a minimum cash balance of $482,000. (4) A new machine rnatinn $6510n will he arnulired in 2023 and enutinment cosatir 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