comment loan amount interest rate payments per year rate per period number of years total number of payments payments per month
value
period
variable 17000 pv 0.03 12 0 rate 6 72 nper ($257.53) payment
principal 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
interest ($216.45) ($216.97) ($217.50) ($218.02) ($218.55) ($219.08) ($219.61) ($220.14) ($220.67) ($221.20) ($221.74) ($222.27) ($222.81) ($223.35) ($223.89) ($224.43) ($224.97) ($225.52) ($226.06) ($226.61) ($227.15) ($227.70) ($228.25) ($228.81) ($229.36) ($229.91) ($230.47) ($231.03) ($231.58) ($232.14) ($232.70) ($233.27) ($233.83) ($234.40) ($234.96) ($235.53) ($236.10) ($236.67) ($237.24) ($237.81) ($238.39)
($41.08) ($40.56) ($40.04) ($39.51) ($38.98) ($38.46) ($37.93) ($37.40) ($36.86) ($36.33) ($35.80) ($35.26) ($34.72) ($34.18) ($33.64) ($33.10) ($32.56) ($32.02) ($31.47) ($30.93) ($30.38) ($29.83) ($29.28) ($28.73) ($28.17) ($27.62) ($27.06) ($26.51) ($25.95) ($25.39) ($24.83) ($24.27) ($23.70) ($23.14) ($22.57) ($22.00) ($21.43) ($20.86) ($20.29) ($19.72) ($19.14)
42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
($238.97) ($239.54) ($240.12) ($240.70) ($241.28) ($241.87) ($242.45) ($243.04) ($243.63) ($244.21) ($244.80) ($245.40) ($245.99) ($246.58) ($247.18) ($247.78) ($248.38) ($248.98) ($249.58)
($18.57) ($17.99) ($17.41) ($16.83) ($16.25) ($15.67) ($15.08) ($14.49) ($13.91) ($13.32) ($12.73) ($12.14) ($11.54) ($10.95) ($10.35) ($9.76) ($9.16) ($8.56) ($7.96)
balance 17,000.00 $16,783.55 $16,566.58 $16,349.08 $16,131.06 $15,912.51 $15,693.43 $15,473.83 $15,253.69 $15,033.02 $14,811.82 $14,590.08 $14,367.80 $14,144.99 $13,921.65 $13,697.76 $13,473.33 $13,248.35 $13,022.84 $12,796.78 $12,570.17 $12,343.02 $12,115.31 $11,887.06 $11,658.25 $11,428.89 $11,198.98 $10,968.51 $10,737.49 $10,505.90 $10,273.76 $10,041.06 $9,807.79 $9,573.96 $9,339.56 $9,104.60 $8,869.07 $8,632.97 $8,396.30 $8,159.06 $7,921.25 $7,682.86
$7,443.89 $7,204.35 $6,964.23 $6,723.52 $6,482.24 $6,240.37 $5,997.92 $5,754.88 $5,511.26 $5,267.04 $5,022.24 $4,776.84 $4,530.86 $4,284.27 $4,037.09 $3,789.32 $3,540.94 $3,291.97 $3,042.39