Calculate the total pv of the tax shield, Basic Statistics

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's WACC is 9%.

a. 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.

b. Add a column that shows the value of the annual tax shield. 

c. Add a column that shows the PV of the annual tax shield. 

d. Calculate the total PV of the tax shield in Excel. 

e. Calculate the PV of the tax shield using the PVCCA formula. 

 

 

Posted Date: 3/1/2013 12:04:50 AM | Location : United States







Related Discussions:- Calculate the total pv of the tax shield, Assignment Help, Ask Question on Calculate the total pv of the tax shield, Get Answer, Expert's Help, Calculate the total pv of the tax shield Discussions

Write discussion on Calculate the total pv of the tax shield
Your posts are moderated
Related Questions
IASC:  The IASC (International Accounting Standards Committee is an international organization which was set up in 1973 was restructured to form IASB in 2001. It was an agreement b

Problems 15. An art professor was interested in seeing what size group is best to prime the pump so to speak to encourage strangers to gather together in front of various exhibi

how do i calculate standard deviation for a frequency distribution

Mention the characteristics of Statistics. Explain any two applications of Statistics


All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below. Format the document professionally so it flows well

Angler survey A survey used by sport fishery managers to calculate the total catch, fishing effort and catch rate for the given body of water. For instance, the whole effort m

how to record a new hedging in your books

This problem set consists of three problems and a short essay.  Each problem is worth 7 points, the essay is worth 4 points for a total of 25 points. 1.  What are the chances th

paid installation charges of machinery rs1100