can someone help me to solve all this problem .. please..

X P4-19 (Similar to) Question Help Proforma balance sheet Peabody & Peabody has 2019 sales of $10 9 million It wishes to analyze expected performance and financing needs for 2021-2 years ahead Given the following information respond to parts and be (1) The percent of sales for tems that vary directly with sales are as follows Accounts receivable 12% Inventory 1835 Accounts payable 14.5% Neprofit margin 27% (2) Marketable securities and other cument s we expected to remain unchanged (3) A mum cash balance of $475 000 is desired (4) A m achine o g 1648000 will be acquired in 2020 and equipment Costing $855 000 will be purchased in 2021 Total depreciation in 2020 is forecast as $28.000 and in 2021 5392.000 af depreciation will be taken (5) Accruals are expected to rise to $502 000 by the end of 2021 05) No sale of rement of long-term is expected No se o repurchase of common stock is expected 3) The vidend payout of 50% of net profits is expected to continue 9 Sales are expected to be $11 million in 2020 and $117 on in 2021 Compte the part of the proforma batance sheet for at & Day forecambe 1.2 the nearest do Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Mateus 600 195.000 1427 400 2.541100 Che t her formances 32 blow on the door ProFormance Show Peabody & Peabody Accounts payable, 145% Net profit margin 27% (2) Marketable securities and other current liabilities are expected to remain unchanged (3) A minimum cash balance of $475 000 is desired (4) A new machine costing $648 000 will be acquired in 2020 and equipment conting $855 000 will be purchased in 2021 Total depreciation in 2020 is forecast as $288.000, and in 2021 $ 392 000 of depreciation will be taken 15) Accruals are expected to rise to $502000 by the end of 2021. 16) No sale of retirement of long-term debt is expected (T) No sale or repurchase of common stock is expected 18) The dividend payout of 50% of net profit is expected to continue (9) Sales are expected to be $11 8 million in 2020 and $117 million in 2021 (10) The December 31 2019 balance sheet is here a. Prepare a pee forma balance sheet dated December 31, 2021 b. Discuss the financing changes w ested by the Matement prepared in part(a) Compete these pan of the proforma alance sheet or abocy & Peabody for December 31, 201 W ound to the nearest dolar) Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Assets Current assets 476000 195.000 1.427 400 Mascus Accounts receivable investors Total current Net Com 31.2021 below e s and holdersport of the probala to the nearest do ProFormalance She Peabody Peabody the newest dolar) Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Assets Current assets 6 Data Table (Click on the con 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, 2019 Liabilities and Stockholders' Equity $397.000 Accounts payable Marketable secure 195 000 Accruals Accounts receivable 1,201,000 Other current Babies Inventor 1.800.000 Total current liabilities Total current sets 33 593 000 Long-term debit Nated assets Common stock $1.405.000 403.000 30 300 $1 BBB 300 1.903.700 3.723,000 51.595.000 stockholders' equity $7,595 000 Other curs Long terdekat Total Exema nered Check Awe