In: Finance
Johnny’s Lunches is considering purchasing a new, energy-efficient grill. The grill will cost $38,000 and will be depreciated according to the 3-year MACRS schedule. It will be sold for scrap metal after 3 years for $9,500. The grill will have no effect on revenues but will save Johnny’s $19,000 in energy expenses per year. The tax rate is 30%. Use the MACRS depreciation schedule.
a. What are the operating cash flows in each year? (Do not round intermediate calculations. Round your answers to 2 decimal places.)
b. What are the total cash flows in each year? (Do not round intermediate calculations. Round your answers to 2 decimal places.)
c. Assuming the discount rate is 12%, calculate the net present value (NPV) of the cash flow stream. Should the grill be purchased? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
a) | Operating cash flow each year | |||||
Year1 | Year2 | Year3 | ||||
a | Saving in Expenses | 19000 | 19000 | 19000 | ||
b | Less: Depreciation | 12665.4 | 16891 | 5627.8 | ||
33.33% | 44.45% | 14.81% | ||||
c | Net saving For Tax | 6334.6 | 2109 | 13372.2 | ||
d | Less Tax (30%*c) | 1900.38 | 632.7 | 4011.66 | ||
e | Net Income After Tax | 4434.22 | 1476.3 | 9360.54 | ||
f | Add: Depreciation | 12665.4 | 16891 | 5627.8 | ||
g | Operating Cash Flow | 17099.62 | 18367.3 | 14988.34 | ||
b) | Total Cash Flow For Each Year | |||||
Year0 | Year1 | Year2 | Year3 | |||
Equipment purchased | -38000 | |||||
Operating cash flow | 17099.62 | 18367.3 | 14988.34 | |||
Scrap metal sold | 9500 | |||||
Total Cash Flow For Each Year | -38000 | 17099.62 | 18367.3 | 24488.34 | ||
c) | Net Present Value | |||||
Year | Cash Flow | Discounting Factor @12% | Discounted Present Value | |||
0 | -38000 | 1 | -38000 | |||
1 | 17099.62 | 0.8929 | 15267.52 | |||
2 | 18367.3 | 0.7972 | 14642.30 | |||
3 | 24488.34 | 0.7118 | 17430.32 | |||
Net Present Value | 9340.13 | |||||
Since NPV is a positive company should be purchased equipment. | ||||||