Calculate the projects NPV, IRR, MIRR, and payback. Do these indicators suggest that the project should be accepted? Explain. Please use formulas. The tax rate is 15%

AutoSave OFF AQES5 Book2 Home Insert Draw Page Layout Formulas Data Review View Tell me Le Share Comments Calibri (Body) v 12 VA A = = Currency ab Insert I. X LC FH Delete v Paste BI V A EE == = $ % 9 Conditional Format Formatting as Table Cell Styles Format Sort & Filter Find & Select Analyze Data B33 fx | B C D E F G H L M N 0 P $ 35,000.00 $ 8,000.00 $ 27,000.00 6 7 Increase in Inventory 8 Increase in Accounts Payable 9 ANOWC 10 11 Project Operating Cash Flows 12 Unit Sales 13 Prices Per Unit 14 Total Revenue 15 Operating Cost W/O Depereciation 16 Depreciation 17 Total Costs 18 Operating Income 19 Taxes on Operating Income 20 EBIT, After Tax Operating Income 21 Add back depreciation 22 EBIT + [ep 23 24 25 Project Termination Cash Flows 26 Salvage Value 27 Rax on Salvage Value za After Tax Salvage Value 29 ANOWC - Recovery of NOWC 30 Project Free Cash Flows 31 EBIT + DEP - CAPEX - ANOWC 32 33 NPV 34 IRR 35 MIRR 36 Payback 37 38 39 $ 230,000.00 $ 230,000.00 $ 230,000.00 $ 230,000.00 $ $ 1.80 $ $ 1.80 $ 1.80S 1.80 $ 414,000.00 $ 414,000.00 $ 414,000.00 $414,000.00 $ 186,300.00 $ 186,300.00 $ 186,300.00 $ 186,300.00 $ 145,250.00 $ 124,500.00 $ 103,750.00 $ 41,500.00 $ 331,550.00 $ 310,800.00 $ 290,050.00 $ 227,800.00 $ 82,450.00 $ 103,200.00 $ 123,950.00 $186,200.00 $ 12,368 $ 15,480 $ 18,599 $ 27,930 $ 70,082.00 $ 87,720.00 $ 105,358.00 $158.270.00 $ 145,250.DO 124,500 $ 103,750.00 $ 41,500.00 $ 215,333.00 $ 212,220.00 $ 209,108.00 $ 199,770.00 $ 40,000.00 $ 6,000.00 $ 34,000.00 $ 27,000.00 $ (442,000.00 $ 215,333.00 $ 212,220.00 $ 209,108.00 $ 260,770.00 (442,000.00) $ (226,667.00) $ 212,220.00 $ 209,108.00 $ 199,770.00 Sheet1 + Edit 101% AutoSave OFF AQES5 Book2 Home Insert Draw Page Layout Formulas Data Review View Tell me Le Share Comments Calibri (Body) v 12 VA A = = Currency ab Insert I. X LC FH Delete v Paste BI V A EE == = $ % 9 Conditional Format Formatting as Table Cell Styles Format Sort & Filter Find & Select Analyze Data B33 fx | B C D E F G H L M N 0 P $ 35,000.00 $ 8,000.00 $ 27,000.00 6 7 Increase in Inventory 8 Increase in Accounts Payable 9 ANOWC 10 11 Project Operating Cash Flows 12 Unit Sales 13 Prices Per Unit 14 Total Revenue 15 Operating Cost W/O Depereciation 16 Depreciation 17 Total Costs 18 Operating Income 19 Taxes on Operating Income 20 EBIT, After Tax Operating Income 21 Add back depreciation 22 EBIT + [ep 23 24 25 Project Termination Cash Flows 26 Salvage Value 27 Rax on Salvage Value za After Tax Salvage Value 29 ANOWC - Recovery of NOWC 30 Project Free Cash Flows 31 EBIT + DEP - CAPEX - ANOWC 32 33 NPV 34 IRR 35 MIRR 36 Payback 37 38 39 $ 230,000.00 $ 230,000.00 $ 230,000.00 $ 230,000.00 $ $ 1.80 $ $ 1.80 $ 1.80S 1.80 $ 414,000.00 $ 414,000.00 $ 414,000.00 $414,000.00 $ 186,300.00 $ 186,300.00 $ 186,300.00 $ 186,300.00 $ 145,250.00 $ 124,500.00 $ 103,750.00 $ 41,500.00 $ 331,550.00 $ 310,800.00 $ 290,050.00 $ 227,800.00 $ 82,450.00 $ 103,200.00 $ 123,950.00 $186,200.00 $ 12,368 $ 15,480 $ 18,599 $ 27,930 $ 70,082.00 $ 87,720.00 $ 105,358.00 $158.270.00 $ 145,250.DO 124,500 $ 103,750.00 $ 41,500.00 $ 215,333.00 $ 212,220.00 $ 209,108.00 $ 199,770.00 $ 40,000.00 $ 6,000.00 $ 34,000.00 $ 27,000.00 $ (442,000.00 $ 215,333.00 $ 212,220.00 $ 209,108.00 $ 260,770.00 (442,000.00) $ (226,667.00) $ 212,220.00 $ 209,108.00 $ 199,770.00 Sheet1 + Edit 101%