Question: Below is both the question problem as well as MY calculations and answers. My problem is: I ' m concern my NPV answer is somehow

Below is both the question problem as well as MY calculations and answers. My problem is: I'm concern my NPV answer is somehow incorrect but I'm not sure how or where I went wrong in my calculation steps. So I need help looking over it all and finding my misteps, if there are any. ??Is the 40% tax supposed to on the pretax operating income, or on the incremental depreciation?? Thank you
Financial Analysis: C10: Pr 10-2:
The Dauten Toy Corporation currently uses an injection molding machine that was purchased two years ago. This machine is being depreciated on a straight-line basis toward a $500 salvage value, and it has six years of remaining life. Its current book value is $2,600, and it can be sold for $3,000 at this time. Thus, the annual depreciation expense is ($2,600- $500)/6= $350 per year.
Dauten is offered a replacement machine that has a cost of $8,000, an estimated useful life of six years, and an estimated salvage value of $800. This machine falls into the MACRS 5-year class. (MACRS 5year percentages used: Yr120%, Yr232%, Yr319%, Yr412%, Yr511% and lastly Yr66%).
The replacement machine would permit an output expansion, so sales would rise by $1,000 per year. In addition, the new machine's much greater efficiency would cause operating expenses to decline by $1,500 per year. The new machine would require that net working capital be increased by $1,500.
Dauten's marginal tax rate is 40 percent, and its required rate of return is 15 percent. Should the old machine be replaced?
MY CALCULATIONS: Step 1: Sale of Old Machine:
Selling price of old: 3000
-Tax on Sale (40%): 160>(3000-2600)*0.4
= Net CF from Sale: $2840
Step 1.5: Initial Investment Outlay (Yr 0)
Purchase of new: -$8000
Net Working Cap: (1500)
Net CF from Old: 2840
= Initial NCF (Yr 0): -$6,660
Step 2. Change in Depreciation (MACRS 5-years):
Yr1: (8000*.20)-350= $1250
Yr2: (8000*.32)-350= $2210
Yr3: (8000*.19)-350= $1170
Yr4: (8000*.12)-350= $610
Yr5: (8000*.11)-350= $530
Yr6: (8000*.06)-350= $130
Step 3: Tax on Incremental Depreciation:
Yr1: 1250*0.4= $500
Yr2: 2210*0.4= $884
Yr3: 1170*0.4= $468
Yr4: 610*0.4= $244
Yr5: 530*0.4= $212
Yr6: 130*0.4= $52
Step 4: After-tax Incremental Net Cash Flows:
Yr1: $2500-(1250+500)+1250= $2000
Yr2: $2500-(2210+884)+2210= $1616
Yr3: $2500-(1170+468)+1170= $2032
Yr4: $2500-(610+244)+610= $2256
Yr5: $2500-(530+212)+530= $2288
Yr6: $2500-(130+52)+130= $2448
Step 5: AT Increm NCF + Terminal CF (Yr 6):
$2448-500*(1-.4)+800*(1-.4)+1500
= $4128
INCF - Old Salvage *(1-tax)+ New
Salvage *(1-tax)+ Recovery of Net
Working Capital
Step 6: BA 2 Calculator for NPV:
CFO: -6,660
CF1: 2000
CF2: 1616
CF3: 2032
CF4: 2256
CF5: 2288
CF6: 4128
I/Y: 15%
NPV = $1,849.20(ROUNDED)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!