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

What is an irrevocable letter of credit?, What is an irrevocable letter of ...

What is an irrevocable letter of credit? A permanent mail of credit score is a financial instrument used by banks to guarantee a customer's obligations to a supplier. It is perm

Basic statistics, Since you have answered the same below question on 2012, ...

Since you have answered the same below question on 2012, can you provide it to me as free of charge this time? if yes, please send it to me on: Question" Case 1: Decision Analysis

Hitorigrams, difference between historigrams and histogram

difference between historigrams and histogram

Applied problems, A company determines that the profit (P) in Pula and the ...

A company determines that the profit (P) in Pula and the advertising expenditure (e) in Pula have a linear relationship. a) Find an equation of linear relationship

Question, In a survey of 284 smokers, 197 smokers reported that they wanted...

In a survey of 284 smokers, 197 smokers reported that they wanted to quit smoking. Compute a 90% confidence interval for the true proportion of smokers that want to quit smoking.

Linear regression model, Q. Explain Linear Regression model? Ans. ...

Q. Explain Linear Regression model? Ans. Linear correlation measures the strength of a linear relationship, but not the exact numerical relationship. Linear regression, o

Mean, It is a numerical average, as equal to the sum of terms in a given se...

It is a numerical average, as equal to the sum of terms in a given series divided by the number of terms in that series is the mean which is also called the expected value.

FIFO, how to figure out cost of good available for sale, cost of sales, end...

how to figure out cost of good available for sale, cost of sales, ending inventory

Revenues , why are revenues an important number in financial statements?

why are revenues an important number in financial statements?

Relationship between mediation activity, Is there a relationship between me...

Is there a relationship between mediation activity and cooperation between two nations in conflict? A data set was assembled across 15 time periods. Both variables were measured on

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