Calculate the projects NPV, IRR, MIRR, and payback. Do these indicators suggest that the project should be accepted? Explain. Please use formulas 
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%
