I need help with the next 3 parts. Please show how the answers were figured out.

Thanks

Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.8 million. It wishes to analyze expected performance and financing needs for 2021-2 years ahead. Given the following information, respond to parts a. and b. (1) The percents of sales for items that vary directly with sales are as follows: Accounts receivable; 12.5%, Inventory; 18.4%; Accounts payable, 13.6%; Net profit margin, 2.8% (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $478,000 is desired (4) A new machine costing $654,000 will be acquired in 2020, and equipment costing $853,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $287,000, and in 2021 $395,000 of depreciation will be taken (5) Accruals are expected to rise to $505,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. (8) The dividend payout of 50% of net profits is expected to continue. (9) Sales are expected to be $11.6 million in 2020 and $11.9 million in 2021. (10) The December 31, 2019, balance sheet is here a. Prepare a pro forma balance sheet dated December 31, 2021. b. Discuss the financing changes Sugested by the statement nranared in partial a. 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: (Round to the nearest dollar.) Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Assets Current assets Cash $ Marketable securities Accounts receivable Inventories on 478,000 203,000 1,487,500 2,189,600 4,358,100 4,828,000 9.186.100 Total current assets Net fixed assets $ $ Total assets Complete the liabilities and stockholders' equity part of the pro forma balance sheet for Peabody & Peabody for December 31, 2021 below: (Round to the nearest dollar.) i Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Liabilities and stockholders' equity Current liabilities Accounts payable $ Accruals Other current liabilities Total current liabilities $ Long-term debt Total liabilities Common stock and Retained Eamings S External funds required 1,618,400 505,000 79,700 2,203,100 1,992,300 4.195,400 Leonard Industries Balance Sheet December 31, 2019 Assets Liabilities and Stockholders' Equity Cash $405,000 Accounts payable Marketable securities 203,000 Accruals Accounts receivable 1,195,000 Other current liabilities Inventories 1,795,000 Total current liabilities Total current assets $3,598,000 Long-term debt Net fixed assets 4,003,000 Common stock Total liabilities and Total assets $7,601,000 stockholders' equity $1,405,000 402,000 79.700 $1,886,700 1,992,300 3,722,000 $7,601,000 Total liabilities and stockholders' equity S Print Done Enter any number in the edit fields and then click Check Answer. Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.8 million. It wishes to analyze expected performance and financing needs for 2021-2 years ahead. Given the following information, respond to parts a. and b. (1) The percents of sales for items that vary directly with sales are as follows: Accounts receivable; 12.5%, Inventory; 18.4%; Accounts payable, 13.6%; Net profit margin, 2.8% (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $478,000 is desired (4) A new machine costing $654,000 will be acquired in 2020, and equipment costing $853,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $287,000, and in 2021 $395,000 of depreciation will be taken (5) Accruals are expected to rise to $505,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. (8) The dividend payout of 50% of net profits is expected to continue. (9) Sales are expected to be $11.6 million in 2020 and $11.9 million in 2021. (10) The December 31, 2019, balance sheet is here a. Prepare a pro forma balance sheet dated December 31, 2021. b. Discuss the financing changes Sugested by the statement nranared in partial a. 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: (Round to the nearest dollar.) Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Assets Current assets Cash $ Marketable securities Accounts receivable Inventories on 478,000 203,000 1,487,500 2,189,600 4,358,100 4,828,000 9.186.100 Total current assets Net fixed assets $ $ Total assets Complete the liabilities and stockholders' equity part of the pro forma balance sheet for Peabody & Peabody for December 31, 2021 below: (Round to the nearest dollar.) i Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Liabilities and stockholders' equity Current liabilities Accounts payable $ Accruals Other current liabilities Total current liabilities $ Long-term debt Total liabilities Common stock and Retained Eamings S External funds required 1,618,400 505,000 79,700 2,203,100 1,992,300 4.195,400 Leonard Industries Balance Sheet December 31, 2019 Assets Liabilities and Stockholders' Equity Cash $405,000 Accounts payable Marketable securities 203,000 Accruals Accounts receivable 1,195,000 Other current liabilities Inventories 1,795,000 Total current liabilities Total current assets $3,598,000 Long-term debt Net fixed assets 4,003,000 Common stock Total liabilities and Total assets $7,601,000 stockholders' equity $1,405,000 402,000 79.700 $1,886,700 1,992,300 3,722,000 $7,601,000 Total liabilities and stockholders' equity S Print Done Enter any number in the edit fields and then click Check