A H. K M 1 Fiscal Year 2 Benefit Sources 3 Element 1 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 550 350 100 50 500 525 600 650 700 800 1000 4 Element 2 250 500 600 750 800 900 5 Element 3 6...

find the pay-back period with excel.

Extracted text: A H. K M 1 Fiscal Year 2 Benefit Sources 3 Element 1 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 550 350 100 50 500 525 600 650 700 800 1000 4 Element 2 250 500 600 750 800 900 5 Element 3 6 Element 4 7 Fiscal Year 100 100 100 100 100 100 50 50 50 50 50 50 50 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 8 Cost Sources 9 Element 1 10 Element 2 11 Element 3 300 250 250 200 150 150 0. 0. 300 250 250 12 Element 4 400 450 500 13 Element 5 14 Element 6 150 150 150 400 400 400 15 total net benefit - 700 -1150 -75 1250 1400 1600 1750 2050 -650 16 NPVS $2,412.09 17 EANB $343.43 18 IRR 19 20 21 中 22 23 Sheet1