please solve using excel formula.

D I've already provided the the Old and New situation and calculated the Intial Outlay, what you shoud focus on is that, under the Old Situation, there were na fixed costs and now there is a fixed Labor Expense of $130,000 and Depreciation. REMEMBER: Depreciation is not a cash flow item, however the tax savings from depreciation is a cash flow Savings, Now.complete the areas shaded in Purple. 2 Old Situation New Situation 3 Turkeys per Year 500,000 500,000 4 Cost pet Turkey $ 7.00 5 6.00 5 Shipping Cost per Turkey 8.00 150 6 Selling Price $ 10.00 5 10 00 7 Total Variable Cost per Turkey 5 8.00 $ 7.50 8 Additional Gross Profit per Turkey 5 050 9 Investment in Additional Turkey $ 15,000.00 10 Land Cost 5150,000.00 11 Buildings Cost $300,000.00 12 Labor Expense 5 130,000.00 13 Depreciation Salvage Value (Buildings) $ 100,000.00 14 Annual Depreciation Expense $ 40,000.00 15 Actual Salvage Value (Land) $ 200,000.00 16 Actual Salvage Value (Buildings) $ 100,000.00 17 Life of Project 5 18 Tax Rate 34% 19 Weighted Average Cost of Capital 119 20 Cash Reinvestment Rate 1.5% 21 Initial Outlay '$ 465,000.00 22 Annual After tax Cash Flow 23 Terminal Cash Flow 0 24 25 26 27 Profitability Measures 28 Payback Period 20 NPV 30 Profitability Index 31 IRR 32 MIRR Cash Flow Period 0 3 D G I've already provided the the Old and New situation and calculated the Intial Outlay, What you shoud focus on is that, under the Old Situation, there were no fixed costs and now there is a fixed Labor Expense of $130,000 and Depreciation. REMEMBER: Depreciation is not a cash flow item, however the tax savings from depreciation is a cash flow savings. Now, complete the areas shaded in Purple 8 2 Old Situation New Situation 3 Turkeys per Year 500,000 500,000 4 Cost per Turkey $ 7005 6.00 5 Shipping Cost per Turkey $ 1.005 150 6 Selling Price $ 10.00 S 10.00 7 Total Variable Cost per Turkey 8.00 $ 7.50 a Additional Gross Profit per Turkey 5 0.50 9 Investment in Additional Turkey 5 15,000.00 10 Land Cost $ 150,000.00 11 Buildings Cost $300,000.00 12 Labor Expense $ 130,000.00 13 Depreciation Salvage Value (Buildings) $ 100,000.00 14 Annual Depreciation Expense $ 40,000.00 15 Actual Salvage Value (Land) $ 200,000.00 16 Actual Salvage Value (Buildings) $100,000.00 17 do of Project 18 Tax Rate 345 19 Weighted Average Cost of Capital 11% 20 Cash Reisvestment Rato 1.5% 21 initial Outlay "$ 465,000.00 22 Annual Atterdax Cash Flow 23 Terminal Cash Flow 24 25 26 27 Profitability Measures 28 Payback Panod 29 NPY 30 Profitability Index 31 RR 22 MRR Period Cash Flow 0 2 3 4