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

Accounting problem, a business was started on January 1, 2011 and $1000 of ...

a business was started on January 1, 2011 and $1000 of supplies to use in the business. At the end of the month 25% of the supplies remains unpaid and 20% are still on hand. what a

Modules of probability and statistics, Question: (a) Suppose that 100 t...

Question: (a) Suppose that 100 tires made by Bridgestone last on average 21,819 miles with a standard deviation of 1,295 miles. Test the null hypothesis µ = 22, 000 miles again

Rejection of null hypothesis - testing of hypothesis, Two researchers test ...

Two researchers test the same hypothesis. Researcher A rejects the null hypothesis and researcher B fails to reject the null hypothesis.  Discuss three reasons that could cause the

Projectile motion, A fox fleeing from a hunter encounters a 0.730 m tall fe...

A fox fleeing from a hunter encounters a 0.730 m tall fence and attempts to jump it. The fox jumps with an initial velocity of 7.10 m/s at an angle of 45.0°, beginning the jump 2.1

Accounting and finance for managers , From the following cost, production...

From the following cost, production and sales data of Decors Motor Ltd., prepare comparative income statement for three years under (i) absorption costing method, and (ii) marginal

Time series, how we can solve semi average method

how we can solve semi average method

Estimate stand-up time using the rmr system, SCENARIO It is proposed to...

SCENARIO It is proposed to construct a 3m diameter, 50m long tunnel, heading 0950, through the andesite lava flow at Maori Bay (Muriwai). As part of the preliminary investigati

Spatial ability test and musical ability test, This question has multiple p...

This question has multiple parts. Use the following information to answer the questions below: Spatial Ability Test Musical Ability Test Mean 80 74 Standard Deviation 6

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