Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Statistics and Probability Expert

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. 

 

 

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M9525254

Have any Question?


Related Questions in Statistics and Probability

A laboratory worker finds that the 3 of his blood samples

A laboratory worker finds that the 3% of his blood samples test positive for the HIV virus. In a random sample of 70 blood tests, what is the mean number that test positive for the HIV virus? (Round your answer to 1 deci ...

On average the parts from a supplier have a mean of 975

On average, the parts from a supplier have a mean of 97.5 inches and a standard deviation of 12.2 inches. Find the probability that a randomly selected part from this supplier will have a value between 85.3 and 109.7 inc ...

Two plots at rothamsted experimental station were studied

Two plots at Rothamsted Experimental Station were studied for production of wheat straw. For a random sample of years, the annual wheat straw production (in pounds) from one plot was as follows. 6.12 7.03 5.77 6.96 7.31 ...

Suppose you want to estimate the proportion of traditional

Suppose you want to estimate the proportion of traditional college on your campus who own their own car. Based on some research on other campuses, you believe the proportion will be near 25%. What sample size is needed i ...

A stock price is currently 112 stock price move up by 10 or

A stock price is currently $112. Stock price move up by 10% or down by 14%. The risk-free interest rate is APR 2% with continuous compounding. What is the value of a six-month European put option with a strike price of $ ...

A 36-year maturity bond with par value 1000 makes

A 36-year maturity bond with par value $1,000 makes semiannual coupon payments at a coupon rate of 14%. What is the  EQUIVALENT  annual yield to maturity of the bond if the bond sells for $1,080? A 31-year maturity, 9.5% ...

Suppose the timing device used in the mens race failed to

Suppose the timing device used in the men's race failed to activate at the start of the race and instead began to record the times seconds into the race. Consider how the competitors' times would be affected. Would the s ...

1 overproduction of uric acid in the body can be an

1. Overproduction of uric acid in the body can be an indication of cell breakdown. This may be an advance indication of illness such as gout, leukemia, or lymphoma.† Over a period of months, an adult male patient has tak ...

A student recieves the grades shown below with an a worth 4

A student recieves the grades shown below, with an A worth 4 points, a B worth 3 points, a C worth 2 points, and a D worth 1 point. What is the students grade point average? A in 1 four - credit classes C in 1 three - cr ...

An independent measures study with n 6 in each sample

An independent measures study with n = 6 in each sample, produces a sample mean difference of 4 points and a pooled variance of 12. What is the value for the t statistic?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As