Discounted Payback
Discount
factor: the
reciprocal of the discount rate
k – rate of return; in this case k=0.15;
t – year;
Year |
Cash Flow |
DF |
Discounted Cash Flow |
Cum. Dis. C.F. |
0 |
($50 000) |
1 |
($50 000) |
($50 000) |
1 |
$30 000 |
0.869 |
26 070 |
($23 930) |
2 |
30 000 |
0.75 |
22 500 |
370 |
3 |
40 000 |
0.65 |
26 000 |
28 450 |
4 |
25 000 |
0.57 |
14250 |
44 050 |
5 |
15 000 |
0.49 |
7350 |
52 360 |
So payback period is equal 2-370/23700=1.98
Net Present Value
Discount
Factor =
k – Required rate of return; k=0.125;
t – Year;
p - Inflation rate during period t;
k=0.1 and p=0.03
E.G,
in 3rd year DF =
= 0.693
Project |
Year |
Inflows |
Outflows |
Net Flow |
D.F. |
NPV |
Project A |
0 |
|
$500 000 |
(500 000) |
1.000 |
(500 000) |
1 |
$150 000 |
|
150 000 |
0.885 |
132 750 |
|
2 |
150 000 |
|
150 000 |
0.783 |
117 450 |
|
3 |
150 000 |
|
150 000 |
0.693 |
103 950 |
|
4 |
150 000 |
|
150 000 |
0.613 |
91 950 |
|
5 |
150 000 |
|
150 000 |
0.543 |
81 450 |
|
Total |
|
|
|
|
27 550 |
|
Project B |
0 |
|
$400 000 |
|
1.000 |
(400 000) |
1 |
$0 |
|
0 |
0.885 |
0 |
|
2 |
50 000 |
|
50 000 |
0.783 |
39 150 |
|
3 |
200 000 |
|
200 000 |
0.693 |
138 600 |
|
4 |
300 000 |
|
300 000 |
0.613 |
183 900 |
|
5 |
200 000 |
|
200 000 |
0.543 |
108 600 |
|
Total |
|
|
|
|
70 250 |
The total in these projects positive number, indicating that the investment is worthwhile and should be pursued. But Project B is the better investment with total is greater than in Project A
Net Present Value
Year |
Inflows |
Outflows |
Net Flow |
D.F. |
NPV |
0 |
|
$110 000 |
(110 000) |
1.000 |
(110 000) |
1 |
$30 000 |
|
30 000 |
0.91 |
27 300 |
2 |
30 000 |
|
30 000 |
0.83 |
24 900 |
3 |
30 000 |
|
30 000 |
0.75 |
22 500 |
4 |
30 000 |
|
30 000 |
0.68 |
20 400 |
5 |
30 000 |
|
30 000 |
0.62 |
18 600 |
Total |
|
|
|
|
$3700 |
Based on this study, the Net Value Present for the project is positive, showing that the investment is definitely worthwhile and should be brought forward.
