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.