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
Model 1:  Let's consider the logistic regression model, which we will refer to as Model 1, given by log(pi / [1-pi]) = 0.25 + 0.32*X1 + 0.70*X2 + 0.50*X3

standard material qty per unit- 2 kg standard price per kg - 4 rs actual value of material purchased- 4000 rs closing stock- 200 kg actual usage- 2.5 kg finished stock sold- 200 u

Put the appropriate summary statistics, e.g. mean, median, frequencies, percentages, for the different variables into a table to make them concise. You can see examples of consise

Tim Snyder and Jay Wise have decided to form a partnership. They have agreed that Snyder is to invest 30000 and Wise is to invest 40000. Snyder is to devote full time to the busi

The elevator in the Math and Computer Building can stop at one of six ?oors. Four riders get on the elevator at the ?rst ?oor and the elevator heads up. Each rider picks a ?oor at

Quartile Deviation The range as a measure of dispersion discussed above has certain limitations. It is based on two extreme items and it fails to take account of the scatter withi

Holding period return: Holding period return is the return earned by the virtue of holding an asset over a given period. The return is equal to the income and other gains earned fr

An occupational health inspector was interested in determining whether there is a difference in the loss in man-hours due to accidents  by introducing a new safety programme.  The

Conduct a test to determine if the proportion of males that responded true to the statement in the survey that, "Whole foods (i.e. raw vegetables and meats) contain sodium," is dif

Each firm in a competitive research industry can undertake one project at a constant cost, f = $960 to try and develop a certain new product. The inverse demand curve for the new