In: Finance
Gateway Communications is considering a project with an initial fixed assets cost of $1.74 million that will be depreciated straight-line to a zero book value over the 10-year life of the project. At the end of the project the equipment will be sold for an estimated $232,000. The project will not change sales but will reduce operating costs by $383,500 per year. The tax rate is 35 percent and the required return is 10.7 percent. The project will require $48,000 in net working capital, which will be recouped when the project ends. What is the project's NPV?
$133,836
$171,046
$176,748
$164,467
$128,017
$133,836
Working:
a. | Calculation of Annual deprceiation | ||||||||||
Annual depreciation | = | (Cost - salvage value)/Useful Life | |||||||||
= | (1740000-0)/10 | ||||||||||
= | $ 1,74,000 | ||||||||||
b. | Calculation of annual cash flow | ||||||||||
Saving in operating cost | $ 3,83,500 | ||||||||||
Depreciation | $ -1,74,000 | ||||||||||
Profit before tax | $ 2,09,500 | ||||||||||
Tax Expense | $ -73,325 | ||||||||||
Net Profit | $ 1,36,175 | ||||||||||
Depreciation | $ 1,74,000 | ||||||||||
Annual cash flow | $ 3,10,175 | ||||||||||
c. | Year | Fixed Asset Investment | Net Working Capital Investment | Annual cash flow | Release of net working capital | After tax sale of Equipment | Total cash flow | Discount factor | Present Value | ||
0 | $ -17,40,000 | $ -48,000 | $ -17,88,000 | 1.0000 | $ -17,88,000 | ||||||
1 | $ 3,10,175 | $ 3,10,175 | 0.9033 | $ 2,80,194 | |||||||
2 | $ 3,10,175 | $ 3,10,175 | 0.8160 | $ 2,53,111 | |||||||
3 | $ 3,10,175 | $ 3,10,175 | 0.7372 | $ 2,28,646 | |||||||
4 | $ 3,10,175 | $ 3,10,175 | 0.6659 | $ 2,06,546 | |||||||
5 | $ 3,10,175 | $ 3,10,175 | 0.6015 | $ 1,86,582 | |||||||
6 | $ 3,10,175 | $ 3,10,175 | 0.5434 | $ 1,68,547 | |||||||
7 | $ 3,10,175 | $ 3,10,175 | 0.4909 | $ 1,52,256 | |||||||
8 | $ 3,10,175 | $ 3,10,175 | 0.4434 | $ 1,37,539 | |||||||
9 | $ 3,10,175 | $ 3,10,175 | 0.4006 | $ 1,24,245 | |||||||
10 | $ 3,10,175 | $ 48,000 | $ 1,50,800 | $ 5,08,975 | 0.3618 | $ 1,84,171 | |||||
$ 1,33,836 | |||||||||||
Working: | |||||||||||
After tax sale of equipment | = | 232000*(1-0.35) | |||||||||
= | $ 1,50,800 | ||||||||||