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

Report on the residual plots, Report on the residual plots – are the assump...

Report on the residual plots – are the assumptions of the regression met

Calculate regression analysis, Questions In a regression analysis, a nu...

Questions In a regression analysis, a nurse researcher found a correlation of .82 between pain relief scores and satisfaction with nursing care.  She also calculated the follow

Normal reaction, Normal Reaction: When two materials are in get in touch wi...

Normal Reaction: When two materials are in get in touch with, then the materials put out makes on each other. The makes are reverse to each other in route and are similar to each o

Standard deviation, define standard deviation. their purpose,uses,advantage...

define standard deviation. their purpose,uses,advantages nd disadvantages,examples ,formula for grouped and ungrouped.

The impact of the shift to ifrs, How do you think the banking sector is goi...

How do you think the banking sector is going to get impacted?   Manager 1: The impact of the shift to IFRS is going to be much higher in the banking sector. This impact woul

Chapter 7, A study of long term phone calls made from general electricss co...

A study of long term phone calls made from general electricss corporate headquarters in fairfeild, conneticuit, revealed the length of the calls, in minutes follows the normal prob

Probability, Find the z value corresponding if the area to the left of the ...

Find the z value corresponding if the area to the left of the z is 0.9452

#title.regression., regression line drawn as y=c+1075x,when x was 2,and y w...

regression line drawn as y=c+1075x,when x was 2,and y was 239,given that y intercept was 11.calculate the residual

3-month absolute deviation, For our class homework we prepared a 3-month fo...

For our class homework we prepared a 3-month forecast for sales (12 months with actual sales for each month). What or how do we figure the absolute deviation of the 3-month foreast

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