In: Finance
Tim’s Brazilian Lunches is considering purchasing a new, energy-efficient grill. The grill will cost $20,000 and will be depreciated in an asset class that carries a CCA rate of 30%. It will be sold for scrap metal after 3 years for $7,500. The grill will have no effect on revenues but will save Tim’s $9,000 in energy expenses. The firm has other assets in this asset class. The tax rate is 35%.
a. What are the operating cash flows in years 1 to 3, not including any CCA calculation?
b. What is the present value of the tax shield if the discount rate is 12%?
c. If the discount rate is 12%, should the grill be purchased?
a) operating cash flow without any CCA calculation is as under
Particulars | 1 | 2 | 3 |
Annual savings in energy expense | 9000 | 9000 | 9000 |
Tax @ 35% | 3150 | 3150 | 3150 |
Annual cash flow without CCA calculation | 5850 | 5850 | 5850 |
b) First of all we need to find depreciation
Statement showing depreciation
Year | Opening balance | Depreciation rate | Depreciation= Depreciation rate *opening balance | Closing balance |
1 | 20000 | 15% | 3000 | 17000 |
2 | 17000 | 30% | 5100 | 11900 |
3 | 11900 | 30% | 3570 | 8330 |
Statement showing PV of Tax shield
Particulars | 1 | 2 | 3 | Total |
Depreciation | 3000 | 5100 | 3570 | |
Tax shield @ 35% | 1050 | 1785 | 1249.5 | |
PV @ 12% | 0.8929 | 0.7972 | 0.7118 | |
Present value | 938 | 1423 | 889 | 3250 |
C) Statement showing NPV
Particulars | 0 | 1 | 2 | 3 | Total |
Cost of new grill | -20000 | ||||
Annual Savings in energy power | 9000 | 9000 | 9000 | ||
Depreciation | 3000 | 5100 | 3570 | ||
PBT | 6000 | 3900 | 5430 | ||
Tax @ 35% | 2100 | 1365 | 1901 | ||
PAT | 3900 | 2535 | 3530 | ||
Add: Depreciation | 3000 | 5100 | 3570 | ||
Annaul cash flow | 6900 | 7635 | 7100 | ||
Salvage value(7500+
35%(8330-7500)) =7500+35%(830) =7500+290.5 |
7791 | ||||
Total cash flow | -20000 | 6900 | 7635 | 14890 | |
PVIF @ 12% | 1 | 0.8929 | 0.7972 | 0.7118 | |
Present value | -20000 | 6161 | 6087 | 10598 | 2846 |
Sunce NPV is positive, Grill should be purchased