In: Economics
Eb's Eggs just bought a new egg sorting machine for $106,944. The machine will save $32,760 in year 1, $34,255 in year 2, $18,724 in year 3, and $8,568 per year from year 4 until the machine is salvaged at the end of year 11. At the end of year 11 it will have a salvage value of $2,110. Eb uses a MARR of 7% to make decisions. What is the payback period (PBP) for this machine?
| Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | 
| Year | Cash flows ($) | Present Value Factor (P/F, 7%, n) | Discounted Cash Flow Col 2 * Col 3 | Cumulative Discounted cash flows($) | 
| 0 | -106944 | 1.0000 | -106944.00 | -106944.00 | 
| 1 | 32760 | 0.9346 | 30617.50 | -76326.50 | 
| 2 | 34255 | 0.8734 | 29918.32 | -46408.19 | 
| 3 | 18724 | 0.8163 | 15284.40 | -31123.79 | 
| 4 | 8568 | 0.7629 | 6536.53 | -24587.26 | 
| 5 | 8568 | 0.7130 | 6108.98 | -18478.27 | 
| 6 | 8568 | 0.6663 | 5708.86 | -12769.42 | 
| 7 | 8568 | 0.6227 | 5335.29 | -7434.12 | 
| 8 | 8568 | 0.5820 | 4986.58 | -2447.55 | 
| 9 | 8568 | 0.5439 | 4660.14 | 2212.59 | 
| 10 | 8568 | 0.5083 | 4355.11 | 6567.70 | 
| 11 | 8568 | 0.4751 | 4070.66 | 10638.36 | 
PBP = 8 + |-2447.55| / 4660.14
= 8 + (2447.55 / 4660.14)
= 8 + 0.52
= 8.52 years
Thus, the payback period (PBP) for this machine is 8.52 years.