Please do this in Excel with relevant formulas. Also, for operating cash flows, please use the formula: OCF $=$ Net Income $+$ Depreciation.

Johnny$$s Lunches is considering purchasing a new, energy$-$efficient grill. The grill will cost $$32,000$ and will be depreciated straight$-$line over $3$ years. It will be sold for scrap metal after $5$ years for $$8,000.$ The grill will have no effect on revenues but will save Johnny$$s $$16,000$ in energy expenses. The tax rate is $30\%.$

Required:

What are the operating cash flows in each year?

What are the total cash flows in each year?

Assuming the discount rate is $12\%,$ calculate the net present value $($NPV$)$ of the cash flow stream. Should the grill be purcha