Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
(MACRS 5year percentages used: Yr120%, Yr232%, Yr319%, Yr412%, Yr511% and lastly Yr66%).
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:
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 Pretax NOI (1000+1500- Change in Depr):
Yr1: 1250*0.4= $500
Yr2: 290*0.4= $116
Yr3: 1330*0.4= $532
Yr4: 1890*0.4= $756
Yr5: 1970*0.4= $788
Yr6: 2370*0.4= $948
Step 4: Net Cash Flows:
Yr1: $2500-(1250+500)+1250= $2000
Yr2: $2500-(2210+116)+2210= $2384
Yr3: $2500-(1170+532)+1170= $1968
Yr4: $2500-(610+756)+610= $1744
Yr5: $2500-(530+788)+530= $1712
Yr6: $2500-(130+948)+130 $1552-300+480+1500 NWC = $3232 NCF yr6
**Step 5: Terminal CFs:
New: 800 gain *(1-.4)=$480 net cf
After-tax terminal cf
Old: 500 loss *(1-.4)=($300) net cf
Step 6: BA 2 Calculator for NPV:
CFO: -6,660
CF1: 2000
CF2: 2384
CF3: 1968
CF4: 1744
CF5: 1712
CF6: 3232
I/Y: 15%
NPV = $1,421.36(ROUNDED)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance for Executives Managing for Value Creation

Authors: Gabriel Hawawini, Claude Viallet

4th edition

9781133169949, 538751347, 978-0538751346

More Books

Students also viewed these Finance questions

Question

What is the purpose of the journal wizard?

Answered: 1 week ago

Question

How are ???? and ???? different?

Answered: 1 week ago