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

Applying missing data, For this assignment, you will have to review each co...

For this assignment, you will have to review each column and make a decision for how to adjust for the missing data. After you correct for missing data in each column, please des

The decision tree costs and benefits of present value, Question: Imagin...

Question: Imagine that your client, Hillside County Forest Preserve (HCFP), is considering how best to protect their natural lagoons.  They have asked for your help, and you ha

Role of statistics, what is the role of statistics in other sciences?

what is the role of statistics in other sciences?

Analysis and interpretation business report, Case Study. Using the data, pr...

Case Study. Using the data, prepare a report that analyses the profitability, liquidity and solvency of a Accessorize Pty Ltd and help the owner to decided whether to purchase the

Ploblem, free hand curve to measure secular trend

free hand curve to measure secular trend

Compute the z scores, 1. Compute the z scores for the following raw scores ...

1. Compute the z scores for the following raw scores where   = 78 and the standard deviation = 4. a. 72 b. 82 c. 78 d. 87 e. 71

Certificate of participation [cop), Certificate of participation [cop) A d...

Certificate of participation [cop) A debt financing agenda administered by the Office of the State Treasurer, A COP is an instrument evidencing a pro rata split in a exact pledged

Ogive curve.., will the ogive curve eventually decrease?

will the ogive curve eventually decrease?

Actual velocity, A boat is heading across a river at a velocity of 25 mph. ...

A boat is heading across a river at a velocity of 25 mph. The river is flowing downstream at 10 mph. What is the actual velocity of the boat?

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