for the discount rate, How where the discount for each year acquired? I subtracted from the 1.0000 for the first one but the answer is not the same. how why 1.0000 ?

FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DATA MINING 1 fr 1 2 1 4 2 3 5 C E F G H RMO Cost / Benefit Analysis for CSMS Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 $1,046,000 $1,074,000 $1,104,240 $1,136,899 $1,172,171 -$1,581,000 -$321.000 -$321,000 -$321,000 -$321,000 -$321,000 -$1,581,000 $725,000 $753,000 $783,240 $815,899 $851,171 1.0000 0.9434 0.8900 0.8396 0.7921 0.7473 -$1.581.000 $683.965 $670. 170 $657.608 $646.274 $636.080 -$1,581,000 -$897,035 -$226,865 $430,743 $1,077,017) $1.713,097 2 years + 226.885 / (226,885 + 430.743) = 35 or 2 years + 128 days (35-365) Category Value of benefits Development costs Annual expenses Net benefit costs Discount factor (6%) Net present value Cumulative NPV Payback period 6 7 8 5 6 7 8 10