Question

In: Finance

A 10-year steel pipe-producing project requires $66 million in upfront investment (all in depreciable assets). The...

  1. A 10-year steel pipe-producing project requires $66 million in upfront investment (all in depreciable assets). The expected price per pipe is $64 and the variable cost is $24 per widget. The fixed costs excluding depreciation are expected to be $14 million per year for ten years. The upfront investment will be depreciated on a straight line basis for the 10-year useful life of the project to $6 million book value. The expected salvage value of the assets is $14 million. The tax rate is 25% and the WACC applicable to the project is 14%.
    1. Calculate the NPV breakeven annual cash flow for the project.
    2. Calculate the NPV break-even point

Solutions

Expert Solution

Initial investments = $66 millions

Useful life = 10 years

S.P. = $64 per pipe, Variable cost = $24 per widget

Fixed cost = $14 million per year

Depreciation = ($66-$6) million/10 years = $6 million

Salvage value = $14 million

Tax rate = 25%

WACC = 14%

Tax on Capital Gains = (Salvage value – Book value at the end of 10 years)*Tax rate

= ($14-$6) million*0.25

= $2 million

Recovery of Salvage Value after Tax = Salvage value before tax – Tax on capital gains

= $14 million - $2 million

= $12 million

(a)

NPV break even cash flow = Annual cash flow at which NPV is equal to Zero.

Therefore, $66 millions = Cumulative present value of Annual Cash flow for 10 years +Present value of Salvage value after tax

$66 millions = Annual Cash flow*(PVIFA14%,10 years)+$12 millions*(PVFA14%,10 years)

$66 millions = Annual Cash flow*5.2161+$12 millions*0.2697

$66 millions - $3.2369 million = Annual Cash flow*5.2161

Annual Cash flow = $62.7631 million/5.2161

Annual Cash flow = $12.0326 million

Therefore, Break even Annual cash flow = $12.0326 million

(b) Calculation of NVP Break-even Point:

Annual cash flow at Break even = $12.0326 million

Particulars

Amount ($)

Sales Per pipe

64

Less: Variable Cost per pipe

24

Contribution per pipe

40

Profit after tax = Cash flow - Depreciation

=$12032600-$6000000

= $6032600

Profit before tax = $6032600/0.75 = $8043467

Total Contribution = Profit before tax + Fixed Cost + Depreciation

= $8043467+$14000000+$6000000

= $28043467

Break-even units = Total contribution/Contribution per unit

= $28043467/$40

= 701086 Units


Related Solutions

A 10-year steel pipe-producing project requires $66 million in upfront investment (all in depreciable assets). The...
A 10-year steel pipe-producing project requires $66 million in upfront investment (all in depreciable assets). The expected price per pipe is $64 and the variable cost is $24 per widget. The fixed costs excluding depreciation are expected to be $14 million per year for ten years. The upfront investment will be depreciated on a straight line basis for the 10-year useful life of the project to $6 million book value. The expected salvage value of the assets is $14 million....
A 10-year steel pipe-producing project requires $66 million in upfront investment (all in depreciable assets), $20.40...
A 10-year steel pipe-producing project requires $66 million in upfront investment (all in depreciable assets), $20.40 million of which is borrowed capital at an interest rate of 6.28% per year. The expected pipe sales are 1,800,000 pipes per year. The expected price per pipe is $64 and the variable cost is $24 per widget. The fixed costs excluding depreciation are expected to be $14 million per year for ten years. The upfront investment will be depreciated on a straight line...
A 10-year steel pipe-producing project requires $60 million in upfront investment (all in depreciable assets), $24...
A 10-year steel pipe-producing project requires $60 million in upfront investment (all in depreciable assets), $24 million of which is borrowed capital at an interest rate of 8.00% per year. The expected pipe sales are 1,600,000 pipes per year. The expected price per pipe is $156 and the variable cost is $129 per unit. The fixed costs excluding depreciation are expected to be $22 million per year for ten years. The upfront investment will be depreciated on a straight line...
If a project requires $10 million investment at year 0, and creates a stream of annual...
If a project requires $10 million investment at year 0, and creates a stream of annual payoffs that grow at 2% per year forever: the first payoff of $1 million arrives in year 1, the payoff in year 2 is $1.02 million (that is, it grows by 2%), and so on. Assume that the cost of capital is 10% per year, and that you face no financial constraint. a. (5 pt) What is the NPV of the project? Would you...
A project to produce rocker seats requires a $10 million investment. If the project is financed...
A project to produce rocker seats requires a $10 million investment. If the project is financed on an all equity basis, the after tax cash flows are $8 million for 10 years. The cost of unlevered equity for such a solar heater project is 12%. The firm intends to raise $5 million in debt financing that will be repaid in equal installments in 10 years. The interest rate on the debt is 8%. Is the project worthwhile? Use APV method.Tax...
Consider a project to produce solar water heaters. It requires a $10 million investment and offers...
Consider a project to produce solar water heaters. It requires a $10 million investment and offers a level after-tax cash flow of $1.75 million per year for 10 years. The opportunity cost of capital is 12%, which reflects the project’s business rick. Suppose the project is financed with $ 5 million of debt and $5 million of equity. The interest rate is 8% and the marginal tax rate is 35%. An equal amount of the debt will be repaid in...
Consider a project to produce solar water heaters. It requires a $10 million investment and offers...
Consider a project to produce solar water heaters. It requires a $10 million investment and offers a level after-tax cash flow of $1.75 million per year for 10 years. The opportunity cost of capital is 12%, which reflects the project’s business rick. Suppose the project is financed with $ 5 million of debt and $5 million of equity. The interest rate is 8% and the marginal tax rate is 35%. An equal amount of the debt will be repaid in...
Consider a project to produce solar water heaters. It requires a $10 million investment and offers...
Consider a project to produce solar water heaters. It requires a $10 million investment and offers a level after-tax cash flow of $1.69 million per year for 10 years. The opportunity cost of capital is 11.25%, which reflects the project’s business risk. a. Suppose the project is financed with $7 million of debt and $3 million of equity. The interest rate is 7.25% and the marginal tax rate is 21%. An equal amount of the debt will be repaid in...
18 A firm is considering an investment project which requires the initial outlay of $10 million....
18 A firm is considering an investment project which requires the initial outlay of $10 million. The 12-year project is expected to generate annual net cash flows each year of $1 million and have the expected terminal value at the end of the project of $5 million. The cost of capital is 6 percent, and its marginal tax rate is 40 percent. Calculate the profitability index of this project. 0.84 0.09 1.70 1.34 1.09
Consider a project to produce solar water heaters. It requires a $10 million investment and offers...
Consider a project to produce solar water heaters. It requires a $10 million investment and offers a level after-tax cash flow of $1.56 million per year for 10 years. The opportunity cost of capital is 9.25%, which reflects the project’s business risk. a. Suppose the project is financed with $4 million of debt and $6 million of equity. The interest rate is 5.25% and the marginal tax rate is 21%. An equal amount of the debt will be repaid in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT