Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am struggling to complete this assignment and need assistance in showing the steps. See attachments. I need it by tonight. Billingham Packaging is considering

image text in transcribed

I am struggling to complete this assignment and need assistance in showing the steps. See attachments. I need it by tonight.

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.82 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 generate $ 10.05 million per year in additional sales, which will continue for the ten-year life of the machine. Operations: The disruption caused by the installation will decrease sales by $ 5.09 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 69 % of their sale price. The increased production will also require increased inventory on hand of $ 1.18 million during the life of the project, including year 0 and depleted in year 10. Human Resources: The expansion will require additional sales and administrative personnel at a cost of $ 2.07 million per year. Accounting: The XC-750 will be depreciated via the straight-line method over the ten-year life of the machine. The firm expects receivables from the new sales to be 16 % of revenues and payables to be 10 % 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 9.6%, compute the NPV of the purchase. d. While the expected new sales will be $ 10.05 million per year from the expansion, estimates range from $ 7.95 million to$ 12.15 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? If the firm believes that sales will not increase, but costs would be reduced by purchasing the new machine, what is the break-even level for the cost of goods sold? f. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC900 is $ 4.07million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3-10. What level of additional sales (above the $ 10.05 million expected for the XC-750) per year in those years would justify purchasing the larger machine? And- the sheet I fill ina. Determine the incremental earnings from the purchase of the XC-750. Calculate the incremental earnings from the purchase of the XC-750 below:(Round to the nearest dollar.) Incremental Earnings Year 0 Sales Revenues $ Cost of Goods Sold $ S, G, and A Expenses $ Depreciation $ EBIT $ Taxes at 35% $ Unlevered Net Income $ (Round to the nearest dollar.) Incremental Earnings Year 110 Sales Revenues $ Cost of Goods Sold $ S, G, and A Expenses $ Depreciation $ EBIT $ Taxes at 35% $ Unlevered Net Income $ 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:(Round to the nearest dollar.) Incremental Free Cash Flow Year 0 Unlevered Net Income $ Depreciation $ Capital Expenditures $ Change in Net Working Capital $ Free cash flow $ (Round to the nearest dollar.) Incremental Free Cash Flow Year 1 Unlevered Net Income $ Depreciation $ Capital Expenditures $ Change in Net Working Capital $ Free cash flow $ (Round to the nearest dollar.) Incremental Free Cash Flow Year 29 Unlevered Net Income $ Depreciation $ Capital Expenditures $ Change in Net Working Capital $ Free cash flow $ (Round to the nearest dollar.) Incremental Free Cash Flow Year 10 Unlevered Net Income $ Depreciation $ Capital Expenditures $ Change in Net Working Capital $ Free cash flow $ (Round to the nearest dollar.) Incremental Free Cash Flow Year 11 Unlevered Net Income $ Depreciation $ Capital Expenditures $ Change in Net Working Capital $ Free cash flow $ c. If the appropriate cost of capital for the expansion is 9.6 %9.6%, compute the NPV of the purchase. The NPV of the purchase is $ (Round to the nearest dollar.) d. While the expected new sales will be $ 10.05 million per year from the expansion, estimates range from $ 7.95 million to$ 12.15 million. What is the NPV in the worst case? In the best case? The NPV of the purchase for sales of $ 7.95 million is $ (Round to the nearest dollar.) The NPV of the purchase for sales of $ 12.15 million is $ (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 break-even level for the cost of goods sold? The break-even level for the cost of goods sold is $ (Round to the nearest dollar.) f. Billingham could instead purchase the XC-900, which offers even greater capacity. The cost of the XC900 is $ 4.07 million. The extra capacity would not be useful in the first two years of operation, but would allow for additional sales in years 3-10. What level of additional sales (above the $ 10.05 million expected for the XC-750) per year in those years would justify purchasing the larger machine? The additional sales are $ (Round to the nearest dollar.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

International Financial Management

Authors: Geert Bekaert, Robert Hodrick

3rd edition

1107111820, 110711182X, 978-1107111820

More Books

Students also viewed these Finance questions