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

How would you go about choosing a random sample, Q. Suppose a study is bein...

Q. Suppose a study is being done and the population is the American public. How would you go about choosing a random sample population to phone for a survey? Solution: One w

Draw a scatter diagram relating cigarette, The following data relating ciga...

The following data relating cigarette smoking and death rates for lung cancers in 14 states in the USA. The data are based in part on records concerning 1960 cigarette tax receipts

Quartile Deviation, Quartile Deviation The range as a measure of dispersio...

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

Conduct all steps of the hypothesis test, The owner of Big Fish supermarket...

The owner of Big Fish supermarket was reviewing some data from a research report on the type of advertisements in the local paper that are most effective.  Three types of ads (big

Drawing a Diamond Card Question, Find the probability of drawing a diamond ...

Find the probability of drawing a diamond card in each of the consecutive draws from a well shuffled pack of cards, if the card drawn is not replaced after the first draw

Demonstrate the potential risk from financing in eurodollars, You have the ...

You have the following information about rates in London for Eurocurrency loans of one-year duration, the exchange rate between the USD and euros, the currency in which you want fi

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

International accounting standards board-iasb, IASB -International Accounti...

IASB -International Accounting Standards Board : IASB is an independent body based in London, which is responsible for setting accounting standards. IASB started operations in the

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