Consider a project to supply Detroit with 20,000 tons of machine screws annually
ID: 2726740 • Letter: C
Question
Consider a project to supply Detroit with 20,000 tons of machine screws annually for automobile production. You will need an initial $3,600,000 investment in threading equipment to get the project started; the project will last for four years. The accounting department estimates that annual fixed costs will be $850,000 and that variable costs should be $250 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the four-year project life. It also estimates a salvage value of $250,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $380 per ton. The engineering department estimates you will need an initial net working capital investment of $360,000. You require a return of 16 percent and face a marginal tax rate of 38 percent on this project.
What is the estimated OCF for this project? (Do not round intermediate calculations. Round your answer to the nearest whole number, e.g., 32.)
What is the estimated NPV for this project? (Do not round intermediate calculations. Round your answer to 2 decimal places, e.g., 32.16.)
Suppose you believe that the accounting department’s initial cost and salvage value projections are accurate only to within ±15 percent; the marketing department’s price estimate is accurate only to within ±10 percent; and the engineering department’s net working capital estimate is accurate only to within ±5 percent. What are your worst-case and best-case NPVs for this project? (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places, e.g., 32.16.)
Consider a project to supply Detroit with 20,000 tons of machine screws annually for automobile production. You will need an initial $3,600,000 investment in threading equipment to get the project started; the project will last for four years. The accounting department estimates that annual fixed costs will be $850,000 and that variable costs should be $250 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the four-year project life. It also estimates a salvage value of $250,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $380 per ton. The engineering department estimates you will need an initial net working capital investment of $360,000. You require a return of 16 percent and face a marginal tax rate of 38 percent on this project.
Explanation / Answer
Answer to Part a 1) Estimated Operating Cash Flow of the project=
Selling price = 380
Variable cost = 250
Unit supplied = 20000
Depreciation per year = 3,600,000 /4 = 900,000
OCF= ((380-250) * (20000) - 850,000) * (1 - 0.38) + 900,000 * (0.38) = $1,427,000
Answer to Part a 2) :
CF0 = -3,600,000 - 360,000 = -3,960,000
CF(SV) = 250,000 - (250,000-0)(0.38) = 155,000
CF1 = CF2 = CF3 = CF4 = 1,427,000, CF5 = 1,942,000
NPV = $317,433.69
Answer to Part b.
In the worst-case, the OCF is:
OCFworst = {[($380)(0.90) – 250](20,000) – $850,000}(1-0.38) + 0.38 * ($4,140,000/4)
OCFworst = $1,007,100
And the worst-case NPV is:
NPVworst = –$4,140,000 – $360,000(1+0.05) + $1,007,100(PVIFA16%,4) + [$360,000(1+0.05) +
$250,000(1-0.15)(1 – 0.38)]/1.166
NPVworst = –$1,490,729.34
The best-case OCF is:
OCFbest = {[($380)(1.10) – 250](20,000) – $850,000}(1-0.38) + 0.38 * ($3,060,000/4)
OCFbest = $1,846,900
And the best-case NPV is:
NPVbest = –$3,060,000 – $360,000(1-0.05) + $1,846,900(PVIFA16%,4) + [$360,000(1-0.05) +
$250,000(1+0.15)(1 – 0.38)]/1.166
NPVbest = $1,979,492.40
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.