Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Calculate the projects NPV, IRR, MIRR, and payback. Do these indicators suggest that the project should be accepted? Explain. Please use formulas image text in transcribed

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%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management

Authors: Rob Quail, Ricardo J. Rodriguez

2nd Edition

1557868441, 9781557868442

More Books

Students also viewed these Finance questions

Question

Explain key approaches to implementing LMD

Answered: 1 week ago