In: Accounting
Hydro One is evaluating buying two different transforms.
Ø Transformer #1: costs $370,000 has a 3 year life, has pre-tax operating cost of $80,000 per year.
Ø Transformer #2: costs $475,000 has a 5 year life, has pre-tax operating cost of $30,000 per year.
Ø Both transformers are Class 8 (CCA rate of 20% per year) and both have a savage value of $40,000.
The firm’s tax rate is 35% and discount rate is 10%
1. What is the NPV for Transformer #1?
Depreciation | |
Cost | 370,000 |
Depreciation for Year 1 | 37,000 |
(370,000 x 1/2 x 20%) | |
Balance at the beg of Year 2 | 333,000 |
Depreciation for Year 2 | 66,600 |
(333,000 x 20%) | |
Balance at the beg of Year 3 | 266,400 |
Depreciation for Year 3 | 53,280 |
(266,400 x 20%) |
Post Tax Cashflows | |||
Particulars | Amount | ||
1 | Cost of Transformer 1 (Year 0) | (370,000) | |
2 | Annual Operating Costs for Year 1-3 | (80,000) | |
Add: Tax savings @ 35% | 28,000 | ||
Post-tax operating costs [-80,000 + 28,000] | (52,000) | ||
3 | Tax Savings on Depreciation: | ||
Year 1: 37,000 x 35% | 12,950 | ||
Year 2: 66,600 x 35% | 23,310 | ||
Year 3: 53,280 x 35% | 18,648 | ||
4 | Salvage Value | 40,000 | |
Note | |||
1 | There is no tax savings for cost incurred for the transfromer. | ||
2 | Negative cashflows are given in brackets |
Calculation of NPV | |||||||
Year | Cost | Post-tax operating costs | Tax Savings on Depreciation | Salvage Value | Total cashflow | PVF @ 10% | Present Value |
0 | (370,000) | - | - | - | (370,000) | 1 | (370,000) |
1 | - | (52,000) | 12,950 | - | (39,050) | 0.909091 | (35,500) |
2 | - | (52,000) | 23,310 | - | (28,690) | 0.826446 | (23,711) |
3 | - | (52,000) | 18,648 | 40,000 | 6,648 | 0.751315 | 4,995 |
(424,216) | |||||||
NPV = $ 424,216 |