Prepare a CCA table with UCC and Annual Tax Shield
$5.50$2.501473 reads
Question
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%.
- 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.
- Add a column that shows the value of the annual tax shield.
- Add a column that shows the PV of the annual tax shield.
- Calculate the total PV of the tax shield in Excel.
- Calculate the PV of the tax shield using the PVCCA formula.
Summary
The question belongs to Finance and it is about a company considering purchasing a new call routing system. A CCA table has to be created. The table must show UCC, annual tax shield and the present value of tax shield.
Total Word Count NA
Related Solutions
Calculation Of Exchange Rates Between Swedish Krona And With Yen Interpretation Of Loan Losses Compared To Percentage Of Total LoaFinance Question NPV, Payback Period, Profitability Index, IRR CCity Of San Antonio Financial Report Analysishow to calculate net cash flow provided by investing activitiesExplan the Importance of Financial Statements in Reporting an Org
Recently Uploaded Solutions
Write an Essay on the Importance of Public RelationsWrite an essay on the positive impact of shareholder power on bonWrite An Essay On What You Want From Work And How To Achieve ItWrite an essay/report on Marketing Mix OrientationWrite an interview structure about poultry litter convert to bio Write Article Reflection On The Article “Improving Teaching And
Most Downloaded Solutions