Question: I need excel formulas! Question 16 Input area: $ Annual cash flows: Year 0 Year 1 Year 2 Year 3 Year 4 M (140,000) 61,500
I need excel formulas!
Question 16 Input area: $ Annual cash flows: Year 0 Year 1 Year 2 Year 3 Year 4 M (140,000) 61,500 73,400 68,100 40,500 A A A A A N (359,000) 159,300 168,400 154,800 110,400 Required return 15% Output area: a. IRR (M) IRR (N) IRR decision rule implies accept because its IRR is greater. Project N b. NPV (M) NPV (N) NPV criterion implies accept Project N because it has a higher NPV. c. The only decision rule that can rank mutually exclusive projects is NPV. Therefore you should accept Project N
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
