Calculate the total pv of the tax shield, Basic Statistics

Assignment Help:

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. 

 

 


Related Discussions:- Calculate the total pv of the tax shield

estimate the mean chloride concentratio, An article in the Journal of Env...

An article in the Journal of Environmental Engineering (Vol. 115, No. 3,1989, pp. 608-619) reported the results of a study on the occurrence of sodium and chloride in surface str

Acc, Project I The trial balance of the Parton Wholesale Company contain...

Project I The trial balance of the Parton Wholesale Company contained the following accounts at December 31, 2010 the end of the company’s calendar year. PARTON WHOLESALE COMPA

The linear regression, Print out your results and bring them with you to th...

Print out your results and bring them with you to the midterm as there will be additional questions on the midterm related to this analysis.  You must hand in your take-home by the

Biomechanics , what are the biomechanical techniques for swimming freestyle...

what are the biomechanical techniques for swimming freestyle?

In-depth analysis of the effects of the salary, Background: There was no 2...

Background: There was no 2004-05 National Hockey Leagues (NHL) season because of a labour dispute between the players and the teams. One of the outcomes of the labour dispute was

Survival analysis and regression for rates, This assignment counts for 40% ...

This assignment counts for 40% of the total grade for the subject.  There are 100 marks for the assignment.  Including figures and tables, it should be no more than 10 pages. Yo

Time series, what are the importances of time series

what are the importances of time series

Psy1110 Module 2, Which of the following does Utts consider a disaster in s...

Which of the following does Utts consider a disaster in sampling?sk question #Minimum 100 words accepted#

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd