In: Accounting
Consider the following investment opportunities.
Period |
A |
B |
C |
D |
0 |
-12,500 |
-11,000 |
12,500 |
-13,000 |
1 |
5,400 |
-3,000 |
-7,000 |
5,500 |
2 |
14,400 |
21,000 |
-2,000 |
5,500 |
3 |
7,200 |
13,000 |
4,000 |
8,500 |
a) Compute the present worth of each investment, assuming a MARR of 15%
b) Compute the future worth of each investment, assuming a MARR of 15%
c) Which project or projects are acceptable?
a) Investment A
Period | 0 | 1 | 2 | 3 |
Cashflow | -12500 | 5400 | 14400 | 7200 |
DF | 1 | 0.87 | 0.756 | 0.658 |
Present Value | -12500 | 4698 | 10886 | 4738 |
Net Present Worth = 8322
Investment B
Period | 0 | 1 | 2 | 3 |
Cashflow | -11000 | -3000 | 21000 | 13000 |
DF | 1 | 0.87 | 0.756 | 0.658 |
PV | -11000 | -2610 | 15876 | 8554 |
Net Present Worth = 10820
Investment C
Period | 0 | 1 | 2 | 3 |
CF | 12500 | -7000 | -2000 | 4000 |
DF | 1 | 0.87 | 0.756 | 0.658 |
PV | 12500 | -6090 | -1512 | 2632 |
Net present worth = 7530
Investment D
Period | 0 | 1 | 2 | 3 |
CF | -13000 | 5500 | 5500 | 8500 |
DF | 1 | 0.87 | 0.756 | 0.658 |
PV | -13000 | 4785 | 4158 | 5593 |
Net present worth = 1536
b) Investment A
Period | 0 | 1 | 2 | 3 |
Cashflow | -12500 | 5400 | 14400 | 7200 |
Compounding | 1.15^3 | 1.15^2 | 1.15^1 | 1 |
Future Value | -19011 | 7142 | 16560 | 7200 |
Net Future Worth = 11891
Investment B
Period | 0 | 1 | 2 | 3 |
Cashflow | -11000 | -3000 | 21000 | 13000 |
Compounding | 1.15^3 | 1.15^2 | 1.15^1 | 1 |
FV | -16730 | -3968 | 31500 | 13000 |
Net Future Worth = 23802
Investment C
Period | 0 | 1 | 2 | 3 |
CF | 12500 | -7000 | -2000 | 4000 |
Compounding | 1.15^3 | 1.15^2 | 1.15 | 1 |
FV | 19011 | -9258 | -2300 | 4000 |
Net future worth = 11453
Investment D
Period | 0 | 1 | 2 | 3 |
CF | -13000 | 5500 | 5500 | 8500 |
Compounding | 1.15^3 | 1.15^2 | 1.15 | 1 |
FV | -19771 | 7274 | 6325 | 8500 |
Net future worth = 2328
c) All 4 projects can be acceptable because all projects are having positive Present worth and Future worth.