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
#question how to make an electron dot diagram

When selling books through insaltalments and internet, what is an alternative selling method for better revenue recording?

This is not a statistics course, but you need to conduct some analyses to help solidify your knowledge and understanding about statistical data analysis.  Now you will use the ' pr

Data   If you look at the Variable view (at top of screen - select View and select variables), you will see the names of variables and information about each one.  The lab

how to solve the assignment problem?

For public health purposes, the force of mortality in a population is usually measured by means of such indices as crude death rate. Infant mortality rate, specific death rate at d

A machine is used for machining of a manufactured product. At the beginning of each business day inspection reveals the machine's condition. There are three possible states: 0, 1 a

Your friend Jose is trying to decide whether to buy or lease his next vehicle. He has gathered information about each option but is not sure how to compare the alternatives. Purcha

What is prime cost? Primary price is the combination of a manufactured item's expenditures of immediate materials and immediate labor. In other words, prime price represent

(b) P(X = 8)