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