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

calculate the chi-square statistic, The table below shows a breakdown of w...

The table below shows a breakdown of women between the ages of 20 to 64 who have had a Pap smear--it shows the number in each age group cross tabulated with the time of their last

Business Research Report Proposal: Initial Research, The initial research p...

The initial research proposal will consist of the following SIX (6) items: 1. Identify a business research topic 2. Define the research questions for the identified problem or opp

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

Icmap, 03 (a) Explain the term capital rationing and suggest the criteria t...

03 (a) Explain the term capital rationing and suggest the criteria to be used in ranking projects under capital rationing. (05) (b) There are three projects X Y and Z having follow

12 questions, normal distribution and the sampling distributions of sample ...

normal distribution and the sampling distributions of sample proportions and sample means, but without confidence interval

Cost behaviour, variable cost per unit remain constent why

variable cost per unit remain constent why

Mean, It is a numerical average, as equal to the sum of terms in a given se...

It is a numerical average, as equal to the sum of terms in a given series divided by the number of terms in that series is the mean which is also called the expected value.

Number of faults to line length, A study on the occurrence of line faults i...

A study on the occurrence of line faults in an electricity supply network was carried out over a two-year period.  Data was collected from six regions on the number of faults per y

Statistics study, Find a statistics study (from a newspaper article, journa...

Find a statistics study (from a newspaper article, journal, research study, or online article) and describe the five-step process of the study. (Hint: it may help to identify the f

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