Question: Question 1 (6pts). For the cash flows shown below, answer the following questions. (Assume MARR = 12%). Type your answer of (1) and paste the

Question 1 (6pts). For the cash flows shown below, answer the following questions. (Assume MARR = 12%). Type your answer of (1) and paste the screenshot of MS excel solutions of (2) and (3), as requested at page 3, below each question Year Factor 0 Investment ($) 1-10 Revenue ($ per year) 1-10 M&O cost ($ per year) 10 Salvage ($) Amounts 1,200,000 300,000 100,000 400,000 (1) (2pts) Decide whether the project is acceptable or not using RATE function in MS Excel. Provide the screenshot fx =IRR(D3:07) (C) Formula E (A) Name 1 -50000 20000 20000 20000 20000 (B) Cash flow 2 (D) Rate of return found IRR = 22% Accept Project (E) Final decision (2) (4) Screenshot example
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
