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

Sta, explain two charateristics.and two aapplication ofics statist

explain two charateristics.and two aapplication ofics statist

Inquiry, factors considered when carrying out an inquiry

factors considered when carrying out an inquiry

Treatment of cst and vat, Treatment of CST and VAT in Sales Book A suppl...

Treatment of CST and VAT in Sales Book A supplier who expenses the CST for inter declares purchase by him, is responsible to first deposit the gathered CST from bought to Got Co

Agency funds, Agency funds,define it Organization money is used to account ...

Agency funds,define it Organization money is used to account for the resources presented by the state as an agent for individuals, private companies, and other health systems. Orga

Biomechanics , what are the biomechanical techniques for swimming freestyle...

what are the biomechanical techniques for swimming freestyle?

LINEAR REGRESSION, Y=C+1075x,when x was 2, and y was 239, given that y inte...

Y=C+1075x,when x was 2, and y was 239, given that y intercept was 11. calculate the residual.

How can do entry, mr.sunil join as a new business partner and borrowed rs. ...

mr.sunil join as a new business partner and borrowed rs. 850000 from ansul investment co. and depoisted the money into a uti bank account on 1-4-2006.

What is the coefficient of determination, The data in the table below are t...

The data in the table below are the results of a random sample of recent home sales in your neighborhood that your boss has asked you to use to estimate the relationship between th

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

Quantitative research methods, I have four assignments that are due tomorro...

I have four assignments that are due tomorrow. Can you help?

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