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

Price level change, how effect changes in prices to a financial statement?

how effect changes in prices to a financial statement?

Define payroll withholdings, Define Payroll Withholdings The U. S. earn...

Define Payroll Withholdings The U. S. earnings tax system-as well as most condition earnings tax systems-requires business employers to hold paycheck taxation from their staff'

Compute the data using both Megastats and Excel Data, AA major razor blade ...

AA major razor blade manufacturer advertises that its twin-blade disposable razor “gets you lots more shaves” than any single-blade disposable razor on the market. A rival company

Meaning of book keeping, What do you understand by the term “Book Keeping”?...

What do you understand by the term “Book Keeping”? Ans. In nutshell the attending the Accounting Process is called or referred as Book Keeping in other plain words we may concern

Historigram, what is historigram in statistics please give the problems and...

what is historigram in statistics please give the problems and there solution in statistics as soon as possible

What is meaning of the ldd detection strategy, A, Suppose a CD player playe...

A, Suppose a CD player player tries to detect whether its partner is C player instead of a DD player by looking for external signals that are at least as typical for DD players tha

HYPOTHESIS TESTING, The fluctuations in the stock market induce some invest...

The fluctuations in the stock market induce some investors to sell and move their money into more stable investments. To determine the degree to which recent fluctuation affected o

Vital statistics, various types of measure of fertility

various types of measure of fertility

Correlation, difference between positive and negative correlaiton

difference between positive and negative correlaiton

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