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
1. What type of correlation coefficient would you use to examine the relationship between the following variables? Explain why you have selected the correlation coefficients. A.

#quHOW TO MAKE ASSIGMENT ON MEDIANestion..

What are the applications of measure of dispersion in civil engineering?

compute three protected t tests to compare all possible pairs of means.  Also, for α = .05, what is the value of LSD ? Which pairs are significantly different from one another,

Definition of brokerage is termed as a fee paid to a broker for services. BROKERAGE is a fee which is paid to the broker for his/her services to act as an intermediary between the


1. Generate 1000 samples for each of the following discrete random variables: (a). Binomial distribution with n=40, p=0.7, and distr. with n=50, p=0.5 (b). Geometric distribu

Cluster Sampling and Area Sampling: Cluster sampling involves grouping the population and then selecting the group or the cluster rather than individual elements for inclusion in t

Mean The mean is commonly the most significant of all the numerical measurements used to describe data, and it is what the most people call an average. Example  Find

what are the importances of time series