Question: Please show all your working with formulas whether done by excel or on paper Assume a MARR of 4.0%. Note: All values shown are in
Please show all your working with formulas whether done by excel or on paper
Assume a MARR of 4.0%. Note: All values shown are in 1000s, thus -80 represents -80,000. Compute the IRR, ERR and DBPB for the investment represented by the following cash flow table:
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| Revenue | 0 | +1350 | +1300 | +1250 | +1200 | +1350 | +1300 | +1250 | +1200 | +1150 |
| O&M | 0 | -80 | -80 | -80 | -80 | -80 | -80 | -80 | -80 | -80 |
| Capital costs and other major costs | -8000 | -400 | +25 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
