Prepare a pro forma balance sheet dated December 31,2021

Complete the assets part of the pro forma balance sheet for Peabody & Peabody for December 31, 2021.

below:(

Homework: Chapter 4 Homework Score: 0 of 1 pt 7 of 7 (8 complete) Y Hw Score: 67.61%, 4.73 7 pts Question Help P4-19 (similar to Pro forma balance sheet Peabody&Peabody parts a. and b. has 2019 sales of $10.5 mitlon. It wishes to analyze expected performance and financing needs for 2021-2 years ahead. Given the following information, respond to | The percents of saies l raer shat vary drectly with Sales reabl s Accurts roce vable; 117%, invent y 179% Accounts payable, 142% Ne, protmagn, 2e. (2) Marketable securities and other cument labilities are expected to remain unchanged (3) A minimum cash balance of $485,000 is desired (4) A new machine costing $651,000 will be be taken (5) Accruals are expected to rise to $498,000 by the end of 2021. (6) No sale or retirement of long-term debt is expected. (7) No sale or repurchase of common stock is expected (B) The dividend payout of 50% of net profes s expected to contre. (9) Sales are expected to be $11.3 illion in 2020 and $11.4 million in 2021 aoquired in 2020, and equipment costing $846,000 wll be purchased in 2021. Total depreciation in 2020 is forecast as $291,000, and in 2021 $388.000 of depreciation wil Data Table (Click on the icon located on the top-right comer of the data table below in order to copy its contents into a spreadsheet) Leonard Industries Balance Sheet December 31, 201 396,000 Accounts payable Marketable securities Accounts receivable Liabilities and Stockholders Equity Marketable securities Accounts receivable $1,398,000 395,000 79.500 Total current assets Net flxed assets Total assets 205,000 Accruals 201,000 Oher curent liabilities ,796,000 3,598,000 Long-term debt 4,002,000 Common stock Total cument liablibes Total cument assets Net fxed assets $1,872,500 2,012.500 3,715,000 Total iabiliies and Enter any number in the edit felds and then click Check Answer Total assets $7,600,000 stockholders' equity $7,800,000 remaning Print Done 5 6 8