In: Finance
ABC) A new computer costs $1,200,000. This cost could be depreciated at 30% per year (Class 10). The computer would actually be worth $110,000 in five years. The new computer would save $523,000 per year before taxes and operating costs. Suppose the new computer requires us to increase net working capital by $62,500 when we buy it. If we require a 12% return, what is the NPV of the purchase? Assume a tax rate of 40%. (Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit $ sign in your response.)
NPV of Purchase | |||
New computer cost | = | $1,200,000 | |
Dep Rate | = | 0.3 | |
Scrap Value | = | $110,000 | |
Working Capital | = | $62,500 | |
Life | |||
Depreciation per year | = | $1,200,000*0.3 | |
$3,60,000 | |||
Depraciable value | = | $1,200,000-$110,000 | |
$10,90,000 | |||
Life | = | Depreciable value / Depraciation per year | |
= | 3.03 | ||
Life(Approx) | = | 3 years | |
A | Outflows | ||
New computer cost | = | $12,00,000 | |
Working Capital | = | $62,500 | |
= | $12,62,500 | ||
B | Savings | ||
1 | Depreciation | = | $1,200,000*0.3 |
= | $3,60,000 | ||
Tax Rate | = | 0.4 | |
Tax savings on Depreciation | = | $1,44,000 | |
2 | Savings before taxes and operating costs due to new computer | = | $5,23,000 |
Less : Taxes @0.4 | = | $2,09,200 | |
Net savings | = | $3,13,800 | |
Total savings per year (1+2) | = | $4,57,800 | |
C | Terminal Cash inflows | ||
Scrap value of Computer | = | $1,10,000 | |
Working Capital | = | $62,500 | |
= | $1,72,500 | ||
Present value of yealy cash Inflows | = | PVAF (12%,3 years)*$457,800 | |
= | $457,800*2.402 | ||
= | $10,99,635.60 | ||
Present value of Terminal cash flows | = | PV(12%,3rd Year)*$172,500 | |
= | $172,500*0.7118 | ||
= | $1,22,785.50 | ||
Present value of cash inflows | = | $12,22,421.10 | |
NPV | = | Present value of cash inflows - Present value of cash outflows | |
= | $1,222,421-$1,262,500 | ||
NPV | = | -$40,079.00 | |