ke MI Data table vel de epl nt son (For Income Staement, click on the icon here in order to copy the contents of the data table below into a spreadsheet.) (For Breakdown of Costs and Expenses, click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Metroline Manufacturing Metroline Manufacturing Income Statement Breakdown of Costs and Expenses for the Year Ended December 31, 2019 into Fixed and Variable Components Sales revenue $1,405,000 for the Year Ended December 31, 2019 Less: Cost of goods sold 911,000 Cost of goods sold Gross profits $494,000 Fixed cost $206,000 127,000 Variable cost Less: Operating expenses 705,000 Total cost $911,000 $367,000 Operating profits Less: Interest expense 36,000 Operating expenses Net profits before taxes $331,000 Fixed expenses $30,000 Less: Taxes (rate=40%) 132,400 Variable expenses 97,000 Net profits after taxes $198,600 Total expenses $127.000 Less: Cash dividends 62,000 To retained earnings $136,600 huf ADO -sall $ $ $ Print Done $ an example Get more help Homework: Homework Set 4 Question 5, P4-19 ( Part 1 of 3 Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.7 million. It wishes to analyze expected performance and (1) The percents of sales for items that vary directly with sales are as follows: Accounts receivable; 12.2%, inventory: 18.1%; Acco (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $480,000 is desired. (4) A new machine costing $652,000 will be acquired in 2020, and equipment costing $851,000 will be purchased in 2021. Total de (5) Accruals are expected to rise to $501,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.8 million in 2020 and $11.8 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 financina chances suggested by the statement prepared in part (a). 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 n Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Assets Current assets Cash Marketable securities S Accounts receivable S Inventories Total current assets Net fixed assets Total assets $ $ $ $ $ $ mbody & Peabody has 2010 salm of $10.7 million. It wahes to analyze expected performance and financing nonds for 2001-2 years ahead. Given the following information, respond to parts and b. me that vary directly with sales are as follow. Accounts receivable 12.2%, inventory, 181%; Accounts payable, 144%. Net profit margin, 2.6% the current liabies are expected to remain unchanged 2.000 will be acquired in 2020, and equipment conting $851.000 will be purchased in 2021. Totul depreciation in 2020 ls forecast as $281,000, and in 2021 5393,000 of depreciation will be taken to $501,000 by the end of 2021 g-term debt is expected $480,000 is desired mmon stock is expected of net profits is expected to continue 511.8 million in 2020 and $11.8 million in 2021 balance sheet is here ce sheet dated December 31, 2021 wordt ke MI Data table vel de epl nt son (For Income Staement, click on the icon here in order to copy the contents of the data table below into a spreadsheet.) (For Breakdown of Costs and Expenses, click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Metroline Manufacturing Metroline Manufacturing Income Statement Breakdown of Costs and Expenses for the Year Ended December 31, 2019 into Fixed and Variable Components Sales revenue $1,405,000 for the Year Ended December 31, 2019 Less: Cost of goods sold 911,000 Cost of goods sold Gross profits $494,000 Fixed cost $206,000 127,000 Variable cost Less: Operating expenses 705,000 Total cost $911,000 $367,000 Operating profits Less: Interest expense 36,000 Operating expenses Net profits before taxes $331,000 Fixed expenses $30,000 Less: Taxes (rate=40%) 132,400 Variable expenses 97,000 Net profits after taxes $198,600 Total expenses $127.000 Less: Cash dividends 62,000 To retained earnings $136,600 huf ADO -sall $ $ $ Print Done $ an example Get more help Homework: Homework Set 4 Question 5, P4-19 ( Part 1 of 3 Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.7 million. It wishes to analyze expected performance and (1) The percents of sales for items that vary directly with sales are as follows: Accounts receivable; 12.2%, inventory: 18.1%; Acco (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $480,000 is desired. (4) A new machine costing $652,000 will be acquired in 2020, and equipment costing $851,000 will be purchased in 2021. Total de (5) Accruals are expected to rise to $501,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.8 million in 2020 and $11.8 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 financina chances suggested by the statement prepared in part (a). 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 n Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Assets Current assets Cash Marketable securities S Accounts receivable S Inventories Total current assets Net fixed assets Total assets $ $ $ $ $ $ mbody & Peabody has 2010 salm of $10.7 million. It wahes to analyze expected performance and financing nonds for 2001-2 years ahead. Given the following information, respond to parts and b. me that vary directly with sales are as follow. Accounts receivable 12.2%, inventory, 181%; Accounts payable, 144%. Net profit margin, 2.6% the current liabies are expected to remain unchanged 2.000 will be acquired in 2020, and equipment conting $851.000 will be purchased in 2021. Totul depreciation in 2020 ls forecast as $281,000, and in 2021 5393,000 of depreciation will be taken to $501,000 by the end of 2021 g-term debt is expected $480,000 is desired mmon stock is expected of net profits is expected to continue 511.8 million in 2020 and $11.8 million in 2021 balance sheet is here ce sheet dated December 31, 2021 wordt