Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hello. I ONLY NEED the answers for e and f. thank you Billingham Packaging is considering expanding its production capacity by purchasing a new machine,

hello. I ONLY NEED the answers for "e" and "f". thank you image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Billingham Packaging is considering expanding its production capacity by purchasing a new machine, the XC-750. The cost of the XC-750 is $2.69 million. Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $47.000 feasibility study to analyze the decision to buy the XC-750, resulting in the following estimates Marketing Once the XC-750 is operational next year, the extra capacity is expected to generato $10 10 million per year in additional sales, which will continue for the 10 year life of the machine Operations. The disruption caused by the installation will decrease sales by $492 million this year. As with Billingham's existing products the cost of goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0 Human Resources: The expansion will require additional sales and administrative personnel at a cost of $203 million per year Accounting. The XC-750 will be depreciated via the straight-line method over the 10-year ife of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC 750 c. If the appropriate cost of capital for the expansion is 10.5% comoute the NPV of the purchase a. Determine the incremental earnings from the purchase of the XC-750 Calculate the incremental earnings from the purchase of the XC-750 below (with vs without XC2750) (Round to the nearest dollar) Incremental Effects Year 4920000 s -3090000 Sales Revenues Cost of Goods Sold S. G and A Expenses Depreciation EBIT 1-10 10100000 7575000 2030,00 269000 226000 OS 8610000) s Enter any number in the edit fields and then continue to the next question goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1,17 million during the life of the project, including year 0. Human Resources. The expansion will require additional sales and administrative personnel at a cost of $2.03 million per year. Accounting. The XC-750 will be depreciated via the straight-line method over the 10-year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold. Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10.10 million per year from the expansion, estimates range from $8.00 million to $12 20 million. What is the NPV in the worst case? In the best case? e. What is the break-even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? 1. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC-900 is $405 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? Incremental Effects Year Sales Revenues Cost of Goods Sold S. G. and A Expenses Depreciation EBIT Taxes at 35% 4920000 -3690000 $ Os 0 $ 8610000l s -430500 $ -799500 s 1-10 10100000 7575000 2030,00 269000 226000 79100 146900 $ Unlevered Net Income Enter any number in the edit fields and then continue to the next question. goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0 Human Resources. The expansion will require additional sales and administrative personnel at a cost of $203 million per year Accounting. The XC-750 will be depreciated via the straight-line method over the 10 year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10 10 million per year from the expansion, estimates range from $8.00 million to $12 20 million What is the NPV in the worst case? In the best case? e. What is the break-even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? 1. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC 900 is $405 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? b. Determine the free cash flow from the purchase of the XC-750 Calculate the free cash flow from the purchase of the XC-750 below (with vs without XC2750) (Note: the change in net working capital for year is equal to the sum of the change in accounts receivable due to the decrease in sales, the change in inventory due to the increase in inventory starting in year 0, and the change in accounts payable due to the decrease in cost of goods sold ) (Round to the nearest dollar) 2.9 10 Incremental Effects Year Unlevered Net Income Depreciation Capital Expenditures Change on Net Working Capital -799500 $ O $ -2690000 $ .714900 $ 146900 L 269000 $ os 1390000 $ 146900 269000 os 0 148300 269000 0 1170000 $ $ $ 5 930000 Enter any number in the edit fields and then continue to the next question goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0 Human Resources. The expansion will require additional sales and administrative personnel at a cost of $2.03 million per year. Accounting. The XC-750 will be depreciated via the straight-line method over the 10-year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10 10 million per year from the expansion, estimates range from $8.00 million to $12 20 million. What is the NPV in the worst case? In the best case? e. What is the break-even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? 1. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC-900 is $4.05 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? 2.9 Incremental Effects Year Unlevered Net Income Depreciation Capital Expenditures Change on Net Working Capital Free cash flow -799500 $ 146900 s 146900 L Os 269000 $ 269000 $2690000 S OLO $ SL714900 SL.1390000 S 0 $ 4204400 S 974100 415000 146900 269000 0 1 170000 1585000 s $ $ 930000 930000 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase. The NPV of the purchase is $ - 2190000 (Round to the nearest dollar.) Enter any number in the edit fields and then continue to the next question. goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0 Human Resources: The expansion will require additional sales and administrative personnel at a cost of $203 milion per year Accounting The XC-750 will be depreciated via the straight-line method over the 10-year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10 10 million per year from the expansion, estimates range from $8.00 million to $12 20 million. What is the NPV in the worst case? In the best case? e. What is the break even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? f. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC-900 is $4.05 million. The extra capacity would not be useful in the first two years of operation but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? d. While the expected new sales will be $10. 10 million per year from the expansion estimates range from $800 milion to $12 20 million What is the NPV in the worst case? In the best case? The NPV of the purchase for sales of $8.00 million is $ - 4180000 (Round to the nearest dolar) The NPV of the purchase for sales of $12 20 million is $ 270000 (Round to the nearest dollar) e. What is the break-even level of new sales from the expansion? The break even level of new sales from the expansion is $ (Round to the nearest dollar) What is the breakeven level for the cost of goods sold? The breakeven level for the cost of goods sold is of sales (Round to two decimal places.) Enter any number in the edit fields and then continue to the next question. goods for the products produced by the XC-750 is expected to be 75% of their sale price The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0. Human Resources. The expansion will require additional sales and administrative personnel at a cost of $2.03 milion per year Accounting The XC-750 will be depreciated via the straight-line method over the 10-year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10 10 million per year from the expansion, estimates range from $8.00 million to $12 20 million What is the NPV in the worst case? In the best case? e. What is the break-even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? 1. Billingham could instead purchase the XC 900, which offers even greater capacity. The cost of the XC-900 is $4.05 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the S10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? TENT U purcis SIS 0 20 ruuvu nun wird und e. What is the break-even level of new sales from the expansion? The break-even level of new sales from the expansion is $ . (Round to the nearest dollar) What is the breakeven level for the cost of goods sold? The breakeven level for the cost of goods sold is % of sales (Round to two decimal places ) f. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC-900 is $4,05 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? The additional sales would need to be $ (Round to the nearest dollar) Billingham Packaging is considering expanding its production capacity by purchasing a new machine, the XC-750. The cost of the XC-750 is $2.69 million. Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $47.000 feasibility study to analyze the decision to buy the XC-750, resulting in the following estimates Marketing Once the XC-750 is operational next year, the extra capacity is expected to generato $10 10 million per year in additional sales, which will continue for the 10 year life of the machine Operations. The disruption caused by the installation will decrease sales by $492 million this year. As with Billingham's existing products the cost of goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0 Human Resources: The expansion will require additional sales and administrative personnel at a cost of $203 million per year Accounting. The XC-750 will be depreciated via the straight-line method over the 10-year ife of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC 750 c. If the appropriate cost of capital for the expansion is 10.5% comoute the NPV of the purchase a. Determine the incremental earnings from the purchase of the XC-750 Calculate the incremental earnings from the purchase of the XC-750 below (with vs without XC2750) (Round to the nearest dollar) Incremental Effects Year 4920000 s -3090000 Sales Revenues Cost of Goods Sold S. G and A Expenses Depreciation EBIT 1-10 10100000 7575000 2030,00 269000 226000 OS 8610000) s Enter any number in the edit fields and then continue to the next question goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1,17 million during the life of the project, including year 0. Human Resources. The expansion will require additional sales and administrative personnel at a cost of $2.03 million per year. Accounting. The XC-750 will be depreciated via the straight-line method over the 10-year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold. Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10.10 million per year from the expansion, estimates range from $8.00 million to $12 20 million. What is the NPV in the worst case? In the best case? e. What is the break-even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? 1. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC-900 is $405 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? Incremental Effects Year Sales Revenues Cost of Goods Sold S. G. and A Expenses Depreciation EBIT Taxes at 35% 4920000 -3690000 $ Os 0 $ 8610000l s -430500 $ -799500 s 1-10 10100000 7575000 2030,00 269000 226000 79100 146900 $ Unlevered Net Income Enter any number in the edit fields and then continue to the next question. goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0 Human Resources. The expansion will require additional sales and administrative personnel at a cost of $203 million per year Accounting. The XC-750 will be depreciated via the straight-line method over the 10 year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10 10 million per year from the expansion, estimates range from $8.00 million to $12 20 million What is the NPV in the worst case? In the best case? e. What is the break-even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? 1. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC 900 is $405 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? b. Determine the free cash flow from the purchase of the XC-750 Calculate the free cash flow from the purchase of the XC-750 below (with vs without XC2750) (Note: the change in net working capital for year is equal to the sum of the change in accounts receivable due to the decrease in sales, the change in inventory due to the increase in inventory starting in year 0, and the change in accounts payable due to the decrease in cost of goods sold ) (Round to the nearest dollar) 2.9 10 Incremental Effects Year Unlevered Net Income Depreciation Capital Expenditures Change on Net Working Capital -799500 $ O $ -2690000 $ .714900 $ 146900 L 269000 $ os 1390000 $ 146900 269000 os 0 148300 269000 0 1170000 $ $ $ 5 930000 Enter any number in the edit fields and then continue to the next question goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0 Human Resources. The expansion will require additional sales and administrative personnel at a cost of $2.03 million per year. Accounting. The XC-750 will be depreciated via the straight-line method over the 10-year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10 10 million per year from the expansion, estimates range from $8.00 million to $12 20 million. What is the NPV in the worst case? In the best case? e. What is the break-even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? 1. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC-900 is $4.05 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? 2.9 Incremental Effects Year Unlevered Net Income Depreciation Capital Expenditures Change on Net Working Capital Free cash flow -799500 $ 146900 s 146900 L Os 269000 $ 269000 $2690000 S OLO $ SL714900 SL.1390000 S 0 $ 4204400 S 974100 415000 146900 269000 0 1 170000 1585000 s $ $ 930000 930000 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase. The NPV of the purchase is $ - 2190000 (Round to the nearest dollar.) Enter any number in the edit fields and then continue to the next question. goods for the products produced by the XC-750 is expected to be 75% of their sale price. The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0 Human Resources: The expansion will require additional sales and administrative personnel at a cost of $203 milion per year Accounting The XC-750 will be depreciated via the straight-line method over the 10-year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10 10 million per year from the expansion, estimates range from $8.00 million to $12 20 million. What is the NPV in the worst case? In the best case? e. What is the break even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? f. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC-900 is $4.05 million. The extra capacity would not be useful in the first two years of operation but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? d. While the expected new sales will be $10. 10 million per year from the expansion estimates range from $800 milion to $12 20 million What is the NPV in the worst case? In the best case? The NPV of the purchase for sales of $8.00 million is $ - 4180000 (Round to the nearest dolar) The NPV of the purchase for sales of $12 20 million is $ 270000 (Round to the nearest dollar) e. What is the break-even level of new sales from the expansion? The break even level of new sales from the expansion is $ (Round to the nearest dollar) What is the breakeven level for the cost of goods sold? The breakeven level for the cost of goods sold is of sales (Round to two decimal places.) Enter any number in the edit fields and then continue to the next question. goods for the products produced by the XC-750 is expected to be 75% of their sale price The increased production will also require increased inventory on hand of $1.17 million during the life of the project, including year 0. Human Resources. The expansion will require additional sales and administrative personnel at a cost of $2.03 milion per year Accounting The XC-750 will be depreciated via the straight-line method over the 10-year life of the machine. The firm expects receivables from the new sales to be 16% of revenues and payables to be 9% of the cost of goods sold Billingham's marginal corporate tax rate is 35% a. Determine the incremental earnings from the purchase of the XC-750 b. Determine the free cash flow from the purchase of the XC-750 c. If the appropriate cost of capital for the expansion is 10.5%, compute the NPV of the purchase d. While the expected new sales will be $10 10 million per year from the expansion, estimates range from $8.00 million to $12 20 million What is the NPV in the worst case? In the best case? e. What is the break-even level of new sales from the expansion? What is the breakeven level for the cost of goods sold? 1. Billingham could instead purchase the XC 900, which offers even greater capacity. The cost of the XC-900 is $4.05 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the S10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? TENT U purcis SIS 0 20 ruuvu nun wird und e. What is the break-even level of new sales from the expansion? The break-even level of new sales from the expansion is $ . (Round to the nearest dollar) What is the breakeven level for the cost of goods sold? The breakeven level for the cost of goods sold is % of sales (Round to two decimal places ) f. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC-900 is $4,05 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3 through 10. What level of additional sales (above the $10.10 million expected for the XC-750) per year in those years would justify purchasing the larger machine? The additional sales would need to be $ (Round to the nearest dollar)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

What are the objectives of Human resource planning ?

Answered: 1 week ago

Question

Explain the process of Human Resource Planning.

Answered: 1 week ago