Question

In: Finance

Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...

Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The cost of the​ XC-750 is $ 2.84 million.​ Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $ 47000 feasibility study to analyze the decision to buy the​ XC-750, resulting in the following​ estimates:

bullet ​Marketing: Once the​ XC-750 is operational next​ year, the extra capacity is expected to generate $ 10.00 million per year in additional​ sales, which will continue for the​ 10-year life of the machine.

bullet ​Operations: The disruption caused by the installation will decrease sales by $ 5.01 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 an increased inventory on hand of $ 1.17 million during the life of the​ project, including year 0.

bullet Human​ Resources: The expansion will require additional sales and administrative personnel at a cost of $ 2.02 million per year.

bullet ​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 11 % 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.

Calculate the incremental earnings from the purchase of the​ XC-750 below​ (with vs. without​ XC?750): ​(Round to the nearest​ dollar.)

Year 0 1-10
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 below​ (with vs. without​ XC?750): ​ (Note: the change in net working capital for year 0 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.)

Year 0 1 2-9 10 11
Unlevered Net Income $    $ $ $    $
Depreciation $ $ $ $ $
Capital Expenditures $ $ $ $ $
Change on Net Working Capital $ $ $ $ $
Free cash flow $ $ $ $ $

  

c. If the appropriate cost of capital for the expansion is 10.3 %​, 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.00 million per year from the​ expansion, estimates range from $ 8.10 million to $ 11.90 million. What is the NPV in the worst​ case? In the best​ case?

The NPV of the purchase for sales of $ 8.10 million is ​$______. ​(Round to the nearest​ dollar.)
The NPV of the purchase for sales of $ 11.90 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 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 $ 3.92 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.00 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.)

Solutions

Expert Solution

a]

incremental earnings before tax = additional sales - cost of goods sold - additional costs - depreciation

incremental earnings after tax = incremental earnings before tax - taxes

b]

Operating cash flow (FCF) each year = incremental income after tax + depreciation

FCF in year 0 = -(cost of machine + increase in inventory + incremental income after tax)

Decrease in contribution in year 0 =   decreased sales * (1 – cost of goods %)

The amount spent on feasibility study is a sunk cost as it is incurred in the past, and cannot be recovered. It should not be considered in the incremental cash flow analysis.

FCF in year 2 = OCF – increase in NWC (net working capital)

Increase in NWC = increase in accounts receivable – increase in accounts payable

FCF in years 2 to 9 = OCF

FCF in year 10 = OCF + terminal cash flow

Terminal cash flow = recovery of inventory + recovery of NWC

c]

NPV is calculated using NPV function in Excel

NPV is -$2,301,398

d]

NPV in the worst case is -$4,096,074

NPV in the best case is -$506,722


Related Solutions

Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The cost of the​ XC-750 is $2.72 million.​ Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $48,000 feasibility study to analyze the decision to buy the​ XC-750, resulting in the following​ estimates: • ​ Marketing: Once the​ XC-750 is operating next​ year, the extra capacity is expected to generate $10.2 million per year in...
Billingham Packaging is considering expanding its production capacity by purchasing a new machine, the XC-750. The...
Billingham Packaging is considering expanding its production capacity by purchasing a new machine, the XC-750. The cost of the XC-750 is $2.75 million. Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $50,000 feasibility study to analyze the decision to buy the XC-750, resulting in the following estimates: ■ Marketing: Once the XC-750 is operating next year, the extra capacity is expected to generate $10 million per year in additional...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...
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 $50,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.10 million per year in...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The cost of the​ XC-750 is $2.79 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: bullet •​Marketing: Once the​ XC-750 is operational next​ year, the extra capacity is expected to generate $10.00 million per year in additional​...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The cost of the​ XC-750 is $2.83 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.10 million per year in additional​...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The cost of the​ XC-750 is $ 2.71 million.​ Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $ 45 comma 000 feasibility study to analyze the decision to buy the​ XC-750, resulting in the following​ estimates: bullet ​Marketing: Once the​ XC-750 is operational next​ year, the extra capacity is expected to generate $ 10.20...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The cost of the​ XC-750 is $ 2.77$2.77 million.​ Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $ 49 comma 000$49,000 feasibility study to analyze the decision to buy the​ XC-750, resulting in the following​ estimates: bullet• ​Marketing: Once the​ XC-750 is operational next​ year, the extra capacity is expected to generate $ 10.00$10.00...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The cost of the​ XC-750 is $2.79 million.​ Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $46,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,...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The cost of the​ XC-750 is $ 2.76 million.​ Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $ 45,000 feasibility study to analyze the decision to buy the​ XC-750, resulting in the following​ estimates: bullet ​Marketing: Once the​ XC-750 is operational next​ year, the extra capacity is expected to generate $ 10.00 million per...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The...
Billingham Packaging is considering expanding its production capacity by purchasing a new​ machine, the​ XC-750. The cost of the​ XC-750 is $ 2.71 million.​ Unfortunately, installing this machine will take several months and will partially disrupt production. The firm has just completed a $49,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.00 million per year in additional​...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT