In: Economics
An electronics company estimated the investment cost for equipment for producing replacement CCTV will be $800,000. The operating and maintenance cost is expected to be $500,000 per year with an annual revenues estimated at $650,000. Considering MARR of 15% per year, find:
The simple payback period=.......years
The discounted payback period=......years
The formula to be used = year where cash flow is last negative + (absolute value of last negative value/cash flow of positive cum cash flow)
Simple payback period
Year |
Expenditure |
Income |
Net Cashflow |
Cumulative cashflow |
0 |
-800000 |
-800000 |
-800000 |
|
1 |
-500000 |
650000 |
150000 |
-650000 |
2 |
-500000 |
650000 |
150000 |
-500000 |
3 |
-500000 |
650000 |
150000 |
-350000 |
4 |
-500000 |
650000 |
150000 |
-200000 |
5 |
-500000 |
650000 |
150000 |
-50000 |
6 |
-500000 |
650000 |
150000 |
100000 |
simple payback period = 5+(50000/150000) = 5.33 years
Discounted pay back period:
Year |
Expenditure |
Income |
Net Cashflow |
Discounted Cashflow |
Cumulative cashflow |
0 |
-800000 |
-800000 |
-800000 |
-800000.00 |
|
1 |
-500000 |
650000 |
150000 |
130434.78 |
-669565.22 |
2 |
-500000 |
650000 |
150000 |
113421.55 |
-556143.67 |
3 |
-500000 |
650000 |
150000 |
98627.43 |
-457516.23 |
4 |
-500000 |
650000 |
150000 |
85762.99 |
-371753.25 |
5 |
-500000 |
650000 |
150000 |
74576.51 |
-297176.74 |
6 |
-500000 |
650000 |
150000 |
64849.14 |
-232327.60 |
7 |
-500000 |
650000 |
150000 |
56390.56 |
-175937.04 |
8 |
-500000 |
650000 |
150000 |
49035.27 |
-126901.77 |
9 |
-500000 |
650000 |
150000 |
42639.36 |
-84262.41 |
10 |
-500000 |
650000 |
150000 |
37077.71 |
-47184.71 |
11 |
-500000 |
650000 |
150000 |
32241.48 |
-14943.22 |
12 |
-500000 |
650000 |
150000 |
28036.07 |
13092.85 |
Discounted payback period = 11+(14943.22/28036.07) = 11.53 years