For this week's assignment, I'd like you to evaluate the numerical
values of the (x/y, i, N) factors used in your calculations,
though you should defer this evaluation to the last stage.
Assignment for Week 3
Any of these methods will give the same result. Let's try the third: make a table showing the increment from A to B:
| Year | Model A | Model B | Increment |
|---|---|---|---|
| 0 | -500 | -3600 | -3100 |
| 1 | -300 | 500 | 800 |
| 2 | -300 | 500 | 800 |
| ... | ... | ... | ... |
| 9 | -300 | 500 | 800 |
| 10 | -300 | 1500 | 1800 |
The IRR of the increment is then calculated as
3100=800(P/A,i,10)+1000(P/F,i,10)
which can be solved to give IRR=23.64%. This is greater than the MARR, so we should upgrade from A to B. We next look at the upgrade from B to C:
| Year | Model B | Model C | Increment |
|---|---|---|---|
| 0 | -3600 | -4000 | -400 |
| 1 | 500 | 1000 | 500 |
| 2 | 500 | -3000 | -3500 |
| 3 | 500 | 1000 | 500 |
| ... | ... | ... | ... |
| 9 | 500 | 1000 | 500 |
| 10 | 1500 | 2000 | 500 |
This does not follow the patern of a simple investment, so we use the ERR instead of the IRR:
400(F/P,ERR,10)+3500(F/P,ERR,8)=500(F/P,12%,9)+500(F/A,12%,8)
From which ERR=8.34%. This is less than the MARR, so we don't upgrade to Model C, but buy Model B.