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

Probability, s. All human blood can be "ABO-typed" as one of O, A, B, or AB...

s. All human blood can be "ABO-typed" as one of O, A, B, or AB, but the distribution of the types varies a bit among groups of people. Here is the distribution of blood types for a

Characteristics of data in statistics, Important Characteristics of Data ...

Important Characteristics of Data Center - The representative or average value which indicates where the middle of the data is located.   Variation - the measur

Simple data analysis&comparison, Progect Guid: PROJECT 1: SIMPLE DATA ANA...

Progect Guid: PROJECT 1: SIMPLE DATA ANALYSIS & COMPARISON REPORT GUIDELINES This document contains general guidelines for the preparation of the Project Report I. Please note,

#titletime series, importance of time series in statistics

importance of time series in statistics

Cronbach alpha, How to calculate manually Cronbach alpha

How to calculate manually Cronbach alpha

Responsiblity accounting significance, What is significance of Responsiblit...

What is significance of Responsiblity accounting in divisional performance statement measurement?

Balance of payments and mobility of labor & capital, Balance of Payments, M...

Balance of Payments, Mobility of Labor and Capital, Trade and Wages Balance of Payments 1. Will a country running a trade deficit import or export capital?  Explain. 2.

Role of accountant, What are the roles of accountant, let me know the caree...

What are the roles of accountant, let me know the career opportunity in accounting subject?

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