PLEASE USE EXCEL AND SHOW FUNCTIONS USED!
Posted: Sun May 08, 2022 9:47 am
PLEASE USE EXCEL AND SHOW FUNCTIONS USED!
2. (20 points) Consider two investments at a MARR of 10% with the following sequences of cash flows: Period Project A Project B 0 $4,500 -$3,500 1 $2,000 $1,500 2 $1,600 $1,200 3 $1,200 $900 4 $800 $600 5 $400 $300 a) Do both projects have an acceptable rate of return? b) Based on incremental analysis, which project would you select?
2. (20 points) Consider two investments at a MARR of 10% with the following sequences of cash flows: Period Project A Project B 0 $4,500 -$3,500 1 $2,000 $1,500 2 $1,600 $1,200 3 $1,200 $900 4 $800 $600 5 $400 $300 a) Do both projects have an acceptable rate of return? b) Based on incremental analysis, which project would you select?