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

Inferential statistics and descriptive statistics, A team of archeologists ...

A team of archeologists have discovered the fossil skull of an extinct and exceptionally large crocodile (sarcosuchus).  Unfortunately, they have not been able to fi

Cost accounting, What is the journal entry for starting and completing 1912...

What is the journal entry for starting and completing 1912 puzzles (in units)

Why Agency code is useful, Why Agency code is useful The four personality n...

Why Agency code is useful The four personality number code allocated by the Workplace of Economical Control to select the unique business models of condition. Organization requirem

Probebility., what is probebility? and how to solve the sums of this?

what is probebility? and how to solve the sums of this?

What is the point estimate of the proportion, According to Thomson Financia...

According to Thomson Financial, through January 25, 2006, the majority of companies reporting profits had beaten estimates (BusinessWeek, February 6, 2006). A sample of 162 compani

Frequency, midpoint of class containing highest frequency

midpoint of class containing highest frequency

Budgetary accounts, Budgetary accounts Accounts used to go through the ado...

Budgetary accounts Accounts used to go through the adopted budget into the all-purpose ledger as part of the administration control method of formal budgetary addition.

Explain accounting Accumulated depreciation , A contra-asset assessment con...

A contra-asset assessment consideration used to history the buildup of regular credit created to indicate the conclusion of the approximated useful life of investment resources.

Statistics, Mention the characteristics of Statistics. Explain any two appl...

Mention the characteristics of Statistics. Explain any two applications of Statistics.

Current Liabilities and Payroll , Prior to the last payroll period of the c...

Prior to the last payroll period of the calendar year, the cumulative earnings of Employer A were $105000. The earnings for the last payroll period of the year which will be paid o

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