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...
An investment project requires a net investment of $200 million. The project is expected to generate...
An investment project requires a net investment of $200 million. The project is expected to generate annual net cash flows of $25 million for the next 15 years with a one-time end of project cash flow of $3 million. The firm's cost of capital is 14 percent and marginal tax rate is 40 percent. a) Evaluate the project using the NPV method and state whether or not the project should be accepted. b) Evaluate the project using the IRR method...
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
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT