Question: No need to write your name please write my name Aya El Sayed Question 1 (6pts). For the cash flows shown below, answer the following
Question 1 (6pts). For the cash flows shown below, answer the following questions. (Assume MARR=12%) (1) (2pts) Provide the equation using PW to find the ROR of the cash flow given. (2) (2pts) Decide whether the project is acceptable or not using RATE function in MS Excel. Provide the screenshot (3) (2pts) Decide whether the project is acceptable or not using IRR_function in MS Excel. Provide the screenshot Year Factor 0 Investment (S) 1-10 Revenue (s per year) 1-10 M&O cost (S per year) 10 Salvage (S) Amounts 1,200,000 300,000 100,000 400,000 Screenshot Guideline: 1. The screenshot should provide: Name - (A) in the screenshot example below Cash flow - (B) in the screenshot example below Formula-(C) in the screenshot example below Rate of Return-(D) in the screenshot example below Decision-(E) in the screenshot example below fx IRR(D3:07) (C) Formula D (A) Name ( Pilsung Choe -50000 20000 20000 20000 20000 (B) Cash flow 22% (D) Rate of return found IRR:.. Accept Project (E) Final decision
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
