Score of it 5 of 14 complete P4-10 (similar to) son Cashbudget-Basic Grenoble Enterprises had also 40.000 in Marchand $50,900 in April. Forecast for May June and July are 500.000, 500,100 and 100,400, respectively. The cof.200 on Mynd wishes to maintain a minimum cash balance of 55.200 Given the following data, prepare and interpreta cash budget for the months of May, June and July ) The tem maks 21% of sales for cash,62% are collected in the next month, and the remaining 17% or collected in the second morfolowing sale The frecvencome of $2.200 per month The sul respected purchase, il made for cash, are $50.000, 500,800 and $79,900 for the month of May through July respectively 14) Rantis 52.600 per month Wages and sales 12% of the previous montissa 6) Cash dividends of 3.500 will be paid in June Payment of principal and interest of 34.000 is dus in June A cash purchase of conting 8.500 is scheduled in July ses of $6.100 einune Complete the first months of the cash budget for Grenoble Carries below. Round to the newest dolor. Pese input it the values in the table before checking your answers.) May $ 50 500 5 125791 10.416 $ 3 Homework: Homework 3 Score: 0 of 1 pt 8 of 8 (5 complete HW Score: 56.2196,4 P4-19 (similar to) Question Pro formabance sheet Peabody & Peabody has 2019 sales of $10.6 milion. It wishes to analyze expected performance and financing needs 2021-2 years ahead. Given the following information, respond to parts and b. (1) The percent of sales for them that very directly with sales are as follows: Accounts receivable; 11.8%, Inventory: 18.1%; Accounts payable, 14.1. Net profit margin, 3.3% 2) Martable secure and other current respected to remain unchanged (3) A minimum cash balance of 5479.000 is desired (4) A new machine costa 56.00 wib squired in 2020, and equipment costing $854,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $200,000, and in 2021 $392,000 of depreciation will be taken 15) Accesore expected to rise to $500.000 by the end of 2021. 16) Nortement of long-term debitis expected m Now repurchase of common stock is expected (B) The dividend payout of 50% of not profit is expected to continue (0) Sierpected to be 5114 million in 2020 and 511 milion in 2021 (10) The December 31, 2018, bolance sheet is hoe a. Prepare a profobo e dated December 31, 2021 b. Discuss the racing changes suggested by the statement prepared in part 2. Prepare a potomce she died December 31, 2021 Complete the assets part of the proforma balance sheet for Peabody & Peabody for December 31, 2021 below. (Round to the nearest dolar) Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Assets Current Canh 3 5 3 Enter any number in the edt suits and then click Check Anawen. Clear Al S 2 3 & 7 4 5 6 8 0 HomeWUIR. HUMIWIU Score: 0 of 1 pt 8 of 8/7 complete) HW Score: 69.56%, 5.57 of 8 pts P4-19 (similar to) Question Help Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.6 million. It wishes to analyze expected performance and financing needs for 20212 years ahead Given the following information, respond to parts a, and b. (1) The percent of sales for items that vary directly with sales are as follows: Accounts receivable; 11.8%, Inventory, 18.1%; Accounts payable, 14.1%; Net profit margin, 3.3% (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $479,000 is desired. (4) A new machine costing $655,000 will be acquired in 2020, and equipment costing $854,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $286,000, and in 2021 $392,000 of depreciation will be taken (5) Accruals are expected to rise to $503,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 proffs is expected to continue (9) Salies are expected to be $11.4 million in 2020 and $11.5 million in 2021. December 31, 2021 Assets Current assets Cash $ Enter any number in the edin fields and then click Check Answer 2 parte Clear All Check Answer remaining Pearson Copyright 2020 Pearson Education Inc. All rights reserved. Terms of Use Privacy Policy | Permissions Contact Us TV AR A 09 w MacBook Pro 21 FS DO F FB 10 SM 192 % 5 4 & 7 + 6 8 Score.UULI *** P4-19 (similar to) Question Help www (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $479,000 is desired (4) A new machine costing $655,000 will be acquired in 2020, and equipment costing $854,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $286,000, and in 2021 $392,000 of depreciation will be taken (5) Accruals are expected to rise to $503,000 by the end of 2021 (8) 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.4 million in 2020 and $11,5 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 suggested by the statement prepared in part (a). December 31, 2021 Assets Currento Cash $ Enter any number in the edit fields and then click Check Answer parts remaining Clear All Check Answer P Pearson Copyright 2020 Pearson Education Inc. All rights reserved. Terms of Use Privacy Policy | Permissions Contact Us tv A A w MacBook Pro . al 00 al FB 3 FS 4 $ 4 & 7 + 0 ( 9 3 5 6 0 = { w E R T Y U 1 0 similar to) able secur mum cash machine Data Table 5392,000 of uals are exp sale or retiren sale or repurd (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) me dividend pay Leonard Industries Balance Sheet December 31, 2019 ales are expect Assets Liabilities and Stockholders' Equity The December Cash $397,000 Accounts payable $1,397,000 Prepare a pro for Marketable securities 205,000 Accruals 405,000 Discuss the finand Accounts receivable 1,195,000 Other current liabilities 80,400 Inventories 1,804,000 Total current liabilities $1,882,400 Total current assets $3,601,000 Long-term debt 2,006,600 Assets Net fixed assets 4,005,000 Common stock 3.717,000 Current assets Total liabilities and Total assets $7,606,000 stockholders' equity $7,606,000 Cash Print Done Enter any number Check Answer Clear All 2 parts remaining P Pearson Copyright 2020 Pearson Education Inc. All rights reserved. Terms of Use Privacy Policy | Permissions Contact Us MacBook Pro Score of it 5 of 14 complete P4-10 (similar to) son Cashbudget-Basic Grenoble Enterprises had also 40.000 in Marchand $50,900 in April. Forecast for May June and July are 500.000, 500,100 and 100,400, respectively. The cof.200 on Mynd wishes to maintain a minimum cash balance of 55.200 Given the following data, prepare and interpreta cash budget for the months of May, June and July ) The tem maks 21% of sales for cash,62% are collected in the next month, and the remaining 17% or collected in the second morfolowing sale The frecvencome of $2.200 per month The sul respected purchase, il made for cash, are $50.000, 500,800 and $79,900 for the month of May through July respectively 14) Rantis 52.600 per month Wages and sales 12% of the previous montissa 6) Cash dividends of 3.500 will be paid in June Payment of principal and interest of 34.000 is dus in June A cash purchase of conting 8.500 is scheduled in July ses of $6.100 einune Complete the first months of the cash budget for Grenoble Carries below. Round to the newest dolor. Pese input it the values in the table before checking your answers.) May $ 50 500 5 125791 10.416 $ 3 Homework: Homework 3 Score: 0 of 1 pt 8 of 8 (5 complete HW Score: 56.2196,4 P4-19 (similar to) Question Pro formabance sheet Peabody & Peabody has 2019 sales of $10.6 milion. It wishes to analyze expected performance and financing needs 2021-2 years ahead. Given the following information, respond to parts and b. (1) The percent of sales for them that very directly with sales are as follows: Accounts receivable; 11.8%, Inventory: 18.1%; Accounts payable, 14.1. Net profit margin, 3.3% 2) Martable secure and other current respected to remain unchanged (3) A minimum cash balance of 5479.000 is desired (4) A new machine costa 56.00 wib squired in 2020, and equipment costing $854,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $200,000, and in 2021 $392,000 of depreciation will be taken 15) Accesore expected to rise to $500.000 by the end of 2021. 16) Nortement of long-term debitis expected m Now repurchase of common stock is expected (B) The dividend payout of 50% of not profit is expected to continue (0) Sierpected to be 5114 million in 2020 and 511 milion in 2021 (10) The December 31, 2018, bolance sheet is hoe a. Prepare a profobo e dated December 31, 2021 b. Discuss the racing changes suggested by the statement prepared in part 2. Prepare a potomce she died December 31, 2021 Complete the assets part of the proforma balance sheet for Peabody & Peabody for December 31, 2021 below. (Round to the nearest dolar) Pro Forma Balance Sheet Peabody & Peabody December 31, 2021 Assets Current Canh 3 5 3 Enter any number in the edt suits and then click Check Anawen. Clear Al S 2 3 & 7 4 5 6 8 0 HomeWUIR. HUMIWIU Score: 0 of 1 pt 8 of 8/7 complete) HW Score: 69.56%, 5.57 of 8 pts P4-19 (similar to) Question Help Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.6 million. It wishes to analyze expected performance and financing needs for 20212 years ahead Given the following information, respond to parts a, and b. (1) The percent of sales for items that vary directly with sales are as follows: Accounts receivable; 11.8%, Inventory, 18.1%; Accounts payable, 14.1%; Net profit margin, 3.3% (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $479,000 is desired. (4) A new machine costing $655,000 will be acquired in 2020, and equipment costing $854,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $286,000, and in 2021 $392,000 of depreciation will be taken (5) Accruals are expected to rise to $503,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 proffs is expected to continue (9) Salies are expected to be $11.4 million in 2020 and $11.5 million in 2021. December 31, 2021 Assets Current assets Cash $ Enter any number in the edin fields and then click Check Answer 2 parte Clear All Check Answer remaining Pearson Copyright 2020 Pearson Education Inc. All rights reserved. Terms of Use Privacy Policy | Permissions Contact Us TV AR A 09 w MacBook Pro 21 FS DO F FB 10 SM 192 % 5 4 & 7 + 6 8 Score.UULI *** P4-19 (similar to) Question Help www (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $479,000 is desired (4) A new machine costing $655,000 will be acquired in 2020, and equipment costing $854,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $286,000, and in 2021 $392,000 of depreciation will be taken (5) Accruals are expected to rise to $503,000 by the end of 2021 (8) 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.4 million in 2020 and $11,5 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 suggested by the statement prepared in part (a). December 31, 2021 Assets Currento Cash $ Enter any number in the edit fields and then click Check Answer parts remaining Clear All Check Answer P Pearson Copyright 2020 Pearson Education Inc. All rights reserved. Terms of Use Privacy Policy | Permissions Contact Us tv A A w MacBook Pro . al 00 al FB 3 FS 4 $ 4 & 7 + 0 ( 9 3 5 6 0 = { w E R T Y U 1 0 similar to) able secur mum cash machine Data Table 5392,000 of uals are exp sale or retiren sale or repurd (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) me dividend pay Leonard Industries Balance Sheet December 31, 2019 ales are expect Assets Liabilities and Stockholders' Equity The December Cash $397,000 Accounts payable $1,397,000 Prepare a pro for Marketable securities 205,000 Accruals 405,000 Discuss the finand Accounts receivable 1,195,000 Other current liabilities 80,400 Inventories 1,804,000 Total current liabilities $1,882,400 Total current assets $3,601,000 Long-term debt 2,006,600 Assets Net fixed assets 4,005,000 Common stock 3.717,000 Current assets Total liabilities and Total assets $7,606,000 stockholders' equity $7,606,000 Cash Print Done Enter any number Check Answer Clear All 2 parts remaining P Pearson Copyright 2020 Pearson Education Inc. All rights reserved. Terms of Use Privacy Policy | Permissions Contact Us MacBook Pro