1 2 Inputs 3 Periodic Rate 4 Pay Back Cutoff 5 Discounted Pay Back Cut off 6 Periods 7 Cash Flows 8 Cummultive Cashflows 9 First Time Positive 10 Paybackperiod 11 12 13 Output 14 PBP 15 NPV 16 IRR 17 18 Rate 19 20 21 22 23 24 25 26 27 28 29 30 0 0.004 0.008 0.012 0.016 0.02 0.024 0.028 0.032 0.036 0.04 0.044 4% 4.00 0 -1230 NPV 1 110 2 120 3 130 4 140 5 150 $1.20 $1.00 $0.80 $0.60 $0.40 6 160 7 170 8 180 NPV 9 190 10 200 11 210 Plot Area 12 <-NPV 13 14 15