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

Your posts are moderated
Related Questions

Generate 1000 samples for each of the following continuous random variables: (a). Exponential distribution with λ = 1.2 and λ = 2.1 (b). Normal distribution with μ = 3.1, σ

Bedovin company manufactures office tables and chairs using job order costing. The data given below were taken from the records as of April 30, the first month of operations. Job

they gave me n=30 and p=.23 to get the answers for P(20,x,23)= and P(x.23)=

how would we find cumulative frequency for the median of discrete series

Q. Illustrate Linear Correlation? Ans. In bivariate studies we are often interested in finding out whether there is a relationship between two sets of data. Are SAT score

What are the steps in a recruitment process and who are responsible for each step?

Read the article “Apple turns over entire inventory every five days.”1 It is not surprising that, the success of managing inventory can lead to the success of a firm’s operational

What are the important principles that have to be observed in the maintenance of discipline

Question 1. In 2009, Research New Zealand conducted a survey on small businesses in New Zealand. Small businesses were defined as enterprises with 19 or fewer employees. 501 small