CENG360: Engineering Economies, Fall 2017 6. Due on 15-Nov-2017, Monday. (Submit the hardcopy in class) Assignment Class Section: Student Name: QUID: Question. For the cash flows shown in the table below, answer the following questions. Use ROR Analysis for your decision, assuming MARR-15% per year. For the sub-questions (2) and (3) provide the screenshot of the spreadsheet showing (A) the formula, (B) the final answer, and (C) your name in the first row as shown in the example at the bottom of this page. *I) If the same screeshots are found among your homework answers both will receive 0 point 2) If you don't show your name in the excel file. 2pts will be automatically deducted decide whether to accept or reject the project based on a ROR. Assume MARR-15% per year (1) (2pts) Provide the equation to find the ROR of the cash flow given. (2) (4pts) Decide the project using IRR function in MS Excel (4pts). Provide the screenshot (3) (4pts) Decide the project using RATE function in MS Excel (4pts). Provide the screenshot Year Factor Amounts 1,000,000 300,000 100,000 400,000 Investment (S) I-10 Revenue (S per year) 1-101 M&O cost($ per year) ( 10 Salvage (S) Screenshot example (showing the formula used in the function). B8 IRR(B3:86) (cPilsung Choe Year Cash 0 -25000 1 10000 2 10000 3 10000 IRR 10% Use this page as the cover page (The grading policy as the previous assignments will be applied)