Problem:
Nortel is considering the purchase of a new call routing system. The system will cost $50M to purchase, an additional $7M to install, and will last for 30 years. The CCA rate associated with the system is 6%, the firm's margin tax rate is 20%, and the firm'sWACC is 9%.
- Using Excel, create a CCA table, as in class for the 30 year life of the asset. Assume that the asset is sold for its UCC at the end of year 30.
- Add a column that shows the value of the annual tax shield.
- Add a column that shows the PV of the annual tax shield.
- Calculate the total PV of the tax shield in Excel.
- Calculate the PV of the tax shield using the PVCCA formula.
Additional Information:
The question is from Finance and it is about a company considering purchasing new call routing system. A CCA table has to be created. The table should show UCC, annual tax shield and the present value of tax shield.