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
Introduce the aim of this section of the report including an explanation of the data to be analysed. • Use Excel to produce a box and whisker plot for the two sets of booking data

An assessment time frame for certain purchases and debt equipment that reviews on the stability piece only that part of their face value that shows major and interest acquired curr

A coin was flipped twenty times and landed on heads fifteen times. If the coin was balanced fair what is the probability of a head on the next toss

I will need to upload the question sheets.

A politician claims that the mean salary for managers in his state is more than national mean $82,000.  The salaries (in dollars) for a random sample of 30 managers in the state ar

Data was gathered on a group of ninth grade students. Some students have been diagnosed with a learning disability.  All students were measured on conduct, attention, hyperactivity


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

Capital budget The piece of a budget: a separate budget: dedicated to proposed additions to capital assets & the means of financing to those additions,

1) Here we are given a raw data and we are supposed to construct the frequency distribution of that data and plot the histogram of it. The dataset contains the values from 1 to