CTC/MTC 374 - Project 3 (Measures of Merit)
Develop an Excel File that Solves the various “Measures of Merit”—see below as an example (but include keys/equations an descriptions of those equations). Remember to include the original problem statement and answer the one question.
Problem Statement: Determine the financial measures of merit for the following cash flow (MARR=4%). For the ERR (use 3% for e). Is this cash flow “economically feasible?”
|
End of Year |
Net Cash Flow |
|
0 |
($4,000) |
|
1 |
$1,500 |
|
2 |
$1,500 |
|
3 |
$1,500 |
|
4 |
$1,500 |
|
5 |
$1,500 |
