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

Simple arithamatic mean, following the hight of studen 155,153,168,160,162...

following the hight of studen 155,153,168,160,162,166,167,180,257,165,

Venn diagrams, how do i solve questions with venn diagrams

how do i solve questions with venn diagrams

Find the probability, Question: (a) Find the number of different words...

Question: (a) Find the number of different words which can be formed with the letters A, A, A, B, B, C, C if (i) there is no restriction (ii) they must st

Find an equivalent martingale and state prices, It is a sunny Tuesday after...

It is a sunny Tuesday afternoon in the perfectly manicured harbourside city of Sydney. Dressed in your favourite pin stripe Gucci (Black Label thank you very much) and those hand c

State the model and apply t-test, Studies have linked brain size in infants...

Studies have linked brain size in infants and toddlers to a number of future ailments, including autism. One study looked at the brain sizes of 30 autistic boys and 12 nonautistic

How to choose a sample, Q. How to Choose a Sample? The way a sample is ...

Q. How to Choose a Sample? The way a sample is chosen is extremely important in all statistical studies. This is because, ultimately, all the inferences will be based on the s

Define overtime pay, Define Overtime Pay Extra time represents time wor...

Define Overtime Pay Extra time represents time worked in excess of 40 times weekly. Whether or not workers are bought overtime will depend on each worker's job obligations and

Volume, I have a box that measures 3m x 3m x 3m. What is the volume of the...

I have a box that measures 3m x 3m x 3m. What is the volume of the cube?

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