HW Score: 86.36 % , 6.91 of P4-19 (similar to) EOuestion Help Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.3 million It wishes to analyze expected porformance and financing needs for 2021-2 years ahead Given the following information respond to parts a. and b. (1) The percents of sales for tems that vary directly with sales are as follows Apcounts receivable: 11.6%, Inventory; 18.3 % ; Accounts payable, 13 7 % Net proft margin 29 (2) Marketable securities and other current liabilties are expected to remain unchanged (3) A minimum cash balance of $480,000 is desired (4) A new machine costing $653,000 will be acquired in 2020, and equipment costing $845,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $289,000, and in 2021 $391,000 of depreciation will be taken. (5) Accruals are expected to rise to $503,000 by the end of 2021 (6) No sale or tretirement of long-term debt is expected )No sale or ropurchase 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 4 million in 2020 and $11.4 miltion in 2021. 10 The enemher 31 2010 halanen sheet in hern 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 nearost dollar) Pro Forma Balance Sheet Peabody & Peabody Enter any number in the edt fields and then cick Check Answer Check Agm pats remainino Clear Al 245 PM 6/12/2019 Type here to search Score: 0 of 1 pt 8 of 8 (7 complete) HW Score: 86 36 % , 691 of 8) P4-19 (similar to) EQuestion Help (1) The percents of sales for hems that vary directly with sales are as follows: Accounts receivable; 11.6 %, Inventory: 18.3 % ; Accounts payable, 13.7 %, Net profit margin, 29% (2) Marketable securities and other current liablities are expected to remain unchanged. (3) A minimum cash balance of $480,000 is desired (4) A new machine costing $653,000 will be acquired in 2020, and equipment oosting $845.000 will be purchased id2021. Total depreciation in 2020 is forecast as $289,000, and in 2021 $391.000 of depreciation will be taken (5) Accruals are expected to rise to $503,000 by the end of 20021. (6) No sale or retirement of long-term debt is expected. (7) No sale or repurchase of oommon stock is expected. (8) The dividend payout of 50% of net profts is expected to continue (9) Sales are expected to be $11.4 milion in 2020 and $11.4 milion in 2021, (10) The December 31, 2019, balance shoot is here m a. Prepare a pro forma balance shoot daled December 31, 2021 b. Discuss the financing changes suggesbed by the statement prepared in part (a) a. Propare a pro forma balance shoet dated December 31, 2021. Complete the assels part of the pro forma balance shoet for Poabody & Peabody for December 31, 2021 below (Round to the nearest dolar Pro Forma Balance Sheet Peabody & Peabody Enter any number in the edit felds and then click Check Answer parts aining Check Answer Clear Al 247 PM Type here to searchy snag09 ter 4 Homework 8 of 8 (7 complete) 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.) Leonard Industries Balance Sheet December 31, 2019 Assets Liabilities and Stockholders' Equity Accounts payable Accruals $1,402,000 396,000 80,300 Cash $404,000 Marketable securities 204,000 1,197,000 Accounts receivable Other current liabilities Total current liabilities Long-term debt Common stock 4P Inventories $1,878,300 al 1,799,000 $3,604,000 Total current assets Net fixed assets 2,004,700 3,718,000 h s S 3,997,000 Total liabilities and stockholders' equity sh Total assets $7,601,000 $7,601,000 e pr Print Done ma l body it fields and then click Check Answer. Clear All search HW Score: 86.36 % , 6.91 of P4-19 (similar to) EOuestion Help Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.3 million It wishes to analyze expected porformance and financing needs for 2021-2 years ahead Given the following information respond to parts a. and b. (1) The percents of sales for tems that vary directly with sales are as follows Apcounts receivable: 11.6%, Inventory; 18.3 % ; Accounts payable, 13 7 % Net proft margin 29 (2) Marketable securities and other current liabilties are expected to remain unchanged (3) A minimum cash balance of $480,000 is desired (4) A new machine costing $653,000 will be acquired in 2020, and equipment costing $845,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $289,000, and in 2021 $391,000 of depreciation will be taken. (5) Accruals are expected to rise to $503,000 by the end of 2021 (6) No sale or tretirement of long-term debt is expected )No sale or ropurchase 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 4 million in 2020 and $11.4 miltion in 2021. 10 The enemher 31 2010 halanen sheet in hern 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 nearost dollar) Pro Forma Balance Sheet Peabody & Peabody Enter any number in the edt fields and then cick Check Answer Check Agm pats remainino Clear Al 245 PM 6/12/2019 Type here to search Score: 0 of 1 pt 8 of 8 (7 complete) HW Score: 86 36 % , 691 of 8) P4-19 (similar to) EQuestion Help (1) The percents of sales for hems that vary directly with sales are as follows: Accounts receivable; 11.6 %, Inventory: 18.3 % ; Accounts payable, 13.7 %, Net profit margin, 29% (2) Marketable securities and other current liablities are expected to remain unchanged. (3) A minimum cash balance of $480,000 is desired (4) A new machine costing $653,000 will be acquired in 2020, and equipment oosting $845.000 will be purchased id2021. Total depreciation in 2020 is forecast as $289,000, and in 2021 $391.000 of depreciation will be taken (5) Accruals are expected to rise to $503,000 by the end of 20021. (6) No sale or retirement of long-term debt is expected. (7) No sale or repurchase of oommon stock is expected. (8) The dividend payout of 50% of net profts is expected to continue (9) Sales are expected to be $11.4 milion in 2020 and $11.4 milion in 2021, (10) The December 31, 2019, balance shoot is here m a. Prepare a pro forma balance shoot daled December 31, 2021 b. Discuss the financing changes suggesbed by the statement prepared in part (a) a. Propare a pro forma balance shoet dated December 31, 2021. Complete the assels part of the pro forma balance shoet for Poabody & Peabody for December 31, 2021 below (Round to the nearest dolar Pro Forma Balance Sheet Peabody & Peabody Enter any number in the edit felds and then click Check Answer parts aining Check Answer Clear Al 247 PM Type here to searchy snag09 ter 4 Homework 8 of 8 (7 complete) 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.) Leonard Industries Balance Sheet December 31, 2019 Assets Liabilities and Stockholders' Equity Accounts payable Accruals $1,402,000 396,000 80,300 Cash $404,000 Marketable securities 204,000 1,197,000 Accounts receivable Other current liabilities Total current liabilities Long-term debt Common stock 4P Inventories $1,878,300 al 1,799,000 $3,604,000 Total current assets Net fixed assets 2,004,700 3,718,000 h s S 3,997,000 Total liabilities and stockholders' equity sh Total assets $7,601,000 $7,601,000 e pr Print Done ma l body it fields and then click Check Answer. Clear All search