Peter Alfeld, --- Department of Mathematics, --- College of Science --- University of Utah

Accumulating Savings

Suppose you already have $10,000 in the bank and you plan on saving $100 a month for the next 10 years, at an annual interest rate of 6%. Enter n=120, p=0.5, PV = -10,000 (not the negative sign), pmt = 100, and press the "Compute" Button next to the Future Value text field. After ten years you will have $34,581.90.

The plot below shows the evolution of your savings. The red area indicates your interest income and the green area indicates the total monthly contributions (payment + interest) to your account.

The following table was obtained with the "Print" Button.


Loan: Loan Amortization, version 1.0, March 1999  run # 32
 Payment Plan 
 Principal Value    = -$10,000.00
 Interest Rate      = 0.500000%
 number of payments = 120
 payment            = $100.00
 Future Value       = $34,581.90
 
   #  payment      principal  interest   balance      total interest 
 
   1    $100.00    $150.00    -$50.00    -$10,150.00      -$50.00
   2    $100.00    $150.75    -$50.75    -$10,300.75     -$100.75
   3    $100.00    $151.50    -$51.50    -$10,452.25     -$152.25
   4    $100.00    $152.26    -$52.26    -$10,604.51     -$204.51
   5    $100.00    $153.02    -$53.02    -$10,757.53     -$257.53
   6    $100.00    $153.78    -$53.78    -$10,911.32     -$311.32
   7    $100.00    $154.55    -$54.55    -$11,065.88     -$365.88
   8    $100.00    $155.32    -$55.32    -$11,221.21     -$421.21
   9    $100.00    $156.10    -$56.10    -$11,377.31     -$477.31
  10    $100.00    $156.88    -$56.88    -$11,534.20     -$534.20
  11    $100.00    $157.67    -$57.67    -$11,691.87     -$591.87
  12    $100.00    $158.45    -$58.45    -$11,850.33     -$650.33
  13    $100.00    $159.25    -$59.25    -$12,009.58     -$709.58
  14    $100.00    $160.04    -$60.04    -$12,169.63     -$769.63
  15    $100.00    $160.84    -$60.84    -$12,330.48     -$830.48
  16    $100.00    $161.65    -$61.65    -$12,492.13     -$892.13
  17    $100.00    $162.46    -$62.46    -$12,654.59     -$954.59
  18    $100.00    $163.27    -$63.27    -$12,817.86   -$1,017.86
  19    $100.00    $164.08    -$64.08    -$12,981.95   -$1,081.95
  20    $100.00    $164.90    -$64.90    -$13,146.86   -$1,146.86
  21    $100.00    $165.73    -$65.73    -$13,312.60   -$1,212.60
  22    $100.00    $166.56    -$66.56    -$13,479.16   -$1,279.16
  23    $100.00    $167.39    -$67.39    -$13,646.56   -$1,346.56
  24    $100.00    $168.23    -$68.23    -$13,814.79   -$1,414.79
  25    $100.00    $169.07    -$69.07    -$13,983.86   -$1,483.86
  26    $100.00    $169.91    -$69.91    -$14,153.78   -$1,553.78
  27    $100.00    $170.76    -$70.76    -$14,324.55   -$1,624.55
  28    $100.00    $171.62    -$71.62    -$14,496.17   -$1,696.17
  29    $100.00    $172.48    -$72.48    -$14,668.65   -$1,768.65
  30    $100.00    $173.34    -$73.34    -$14,842.00   -$1,842.00
  31    $100.00    $174.21    -$74.21    -$15,016.21   -$1,916.21
  32    $100.00    $175.08    -$75.08    -$15,191.29   -$1,991.29
  33    $100.00    $175.95    -$75.95    -$15,367.25   -$2,067.25
  34    $100.00    $176.83    -$76.83    -$15,544.08   -$2,144.08
  35    $100.00    $177.72    -$77.72    -$15,721.80   -$2,221.80
  36    $100.00    $178.60    -$78.60    -$15,900.41   -$2,300.41
  37    $100.00    $179.50    -$79.50    -$16,079.91   -$2,379.91
  38    $100.00    $180.39    -$80.39    -$16,260.31   -$2,460.31
  39    $100.00    $181.30    -$81.30    -$16,441.61   -$2,541.61
  40    $100.00    $182.20    -$82.20    -$16,623.82   -$2,623.82
  41    $100.00    $183.11    -$83.11    -$16,806.94   -$2,706.94
  42    $100.00    $184.03    -$84.03    -$16,990.98   -$2,790.98
  43    $100.00    $184.95    -$84.95    -$17,175.93   -$2,875.93
  44    $100.00    $185.87    -$85.87    -$17,361.81   -$2,961.81
  45    $100.00    $186.80    -$86.80    -$17,548.62   -$3,048.62
  46    $100.00    $187.74    -$87.74    -$17,736.36   -$3,136.36
  47    $100.00    $188.68    -$88.68    -$17,925.04   -$3,225.04
  48    $100.00    $189.62    -$89.62    -$18,114.67   -$3,314.67
  49    $100.00    $190.57    -$90.57    -$18,305.24   -$3,405.24
  50    $100.00    $191.52    -$91.52    -$18,496.77   -$3,496.77
  51    $100.00    $192.48    -$92.48    -$18,689.25   -$3,589.25
  52    $100.00    $193.44    -$93.44    -$18,882.70   -$3,682.70
  53    $100.00    $194.41    -$94.41    -$19,077.11   -$3,777.11
  54    $100.00    $195.38    -$95.38    -$19,272.50   -$3,872.50
  55    $100.00    $196.36    -$96.36    -$19,468.86   -$3,968.86
  56    $100.00    $197.34    -$97.34    -$19,666.21   -$4,066.21
  57    $100.00    $198.33    -$98.33    -$19,864.54   -$4,164.54
  58    $100.00    $199.32    -$99.32    -$20,063.86   -$4,263.86
  59    $100.00    $200.31   -$100.31    -$20,264.18   -$4,364.18
  60    $100.00    $201.32   -$101.32    -$20,465.50   -$4,465.50
  61    $100.00    $202.32   -$102.32    -$20,667.83   -$4,567.83
  62    $100.00    $203.33   -$103.33    -$20,871.17   -$4,671.17
  63    $100.00    $204.35   -$104.35    -$21,075.52   -$4,775.52
  64    $100.00    $205.37   -$105.37    -$21,280.90   -$4,880.90
  65    $100.00    $206.40   -$106.40    -$21,487.30   -$4,987.30
  66    $100.00    $207.43   -$107.43    -$21,694.74   -$5,094.74
  67    $100.00    $208.47   -$108.47    -$21,903.21   -$5,203.21
  68    $100.00    $209.51   -$109.51    -$22,112.73   -$5,312.73
  69    $100.00    $210.56   -$110.56    -$22,323.29   -$5,423.29
  70    $100.00    $211.61   -$111.61    -$22,534.91   -$5,534.91
  71    $100.00    $212.67   -$112.67    -$22,747.59   -$5,647.59
  72    $100.00    $213.73   -$113.73    -$22,961.32   -$5,761.32
  73    $100.00    $214.80   -$114.80    -$23,176.13   -$5,876.13
  74    $100.00    $215.88   -$115.88    -$23,392.01   -$5,992.01
  75    $100.00    $216.96   -$116.96    -$23,608.97   -$6,108.97
  76    $100.00    $218.04   -$118.04    -$23,827.02   -$6,227.02
  77    $100.00    $219.13   -$119.13    -$24,046.15   -$6,346.15
  78    $100.00    $220.23   -$120.23    -$24,266.38   -$6,466.38
  79    $100.00    $221.33   -$121.33    -$24,487.71   -$6,587.71
  80    $100.00    $222.43   -$122.43    -$24,710.15   -$6,710.15
  81    $100.00    $223.55   -$123.55    -$24,933.70   -$6,833.70
  82    $100.00    $224.66   -$124.66    -$25,158.37   -$6,958.37
  83    $100.00    $225.79   -$125.79    -$25,384.16   -$7,084.16
  84    $100.00    $226.92   -$126.92    -$25,611.08   -$7,211.08
  85    $100.00    $228.05   -$128.05    -$25,839.14   -$7,339.14
  86    $100.00    $229.19   -$129.19    -$26,068.34   -$7,468.34
  87    $100.00    $230.34   -$130.34    -$26,298.68   -$7,598.68
  88    $100.00    $231.49   -$131.49    -$26,530.17   -$7,730.17
  89    $100.00    $232.65   -$132.65    -$26,762.82   -$7,862.82
  90    $100.00    $233.81   -$133.81    -$26,996.64   -$7,996.64
  91    $100.00    $234.98   -$134.98    -$27,231.62   -$8,131.62
  92    $100.00    $236.15   -$136.15    -$27,467.78   -$8,267.78
  93    $100.00    $237.33   -$137.33    -$27,705.12   -$8,405.12
  94    $100.00    $238.52   -$138.52    -$27,943.64   -$8,543.64
  95    $100.00    $239.71   -$139.71    -$28,183.36   -$8,683.36
  96    $100.00    $240.91   -$140.91    -$28,424.28   -$8,824.28
  97    $100.00    $242.12   -$142.12    -$28,666.40   -$8,966.40
  98    $100.00    $243.33   -$143.33    -$28,909.73   -$9,109.73
  99    $100.00    $244.54   -$144.54    -$29,154.28   -$9,254.28
 100    $100.00    $245.77   -$145.77    -$29,400.05   -$9,400.05
 101    $100.00    $247.00   -$147.00    -$29,647.05   -$9,547.05
 102    $100.00    $248.23   -$148.23    -$29,895.29   -$9,695.29
 103    $100.00    $249.47   -$149.47    -$30,144.76   -$9,844.76
 104    $100.00    $250.72   -$150.72    -$30,395.49   -$9,995.49
 105    $100.00    $251.97   -$151.97    -$30,647.46  -$10,147.46
 106    $100.00    $253.23   -$153.23    -$30,900.70  -$10,300.70
 107    $100.00    $254.50   -$154.50    -$31,155.20  -$10,455.20
 108    $100.00    $255.77   -$155.77    -$31,410.98  -$10,610.98
 109    $100.00    $257.05   -$157.05    -$31,668.03  -$10,768.03
 110    $100.00    $258.34   -$158.34    -$31,926.38  -$10,926.38
 111    $100.00    $259.63   -$159.63    -$32,186.01  -$11,086.01
 112    $100.00    $260.93   -$160.93    -$32,446.94  -$11,246.94
 113    $100.00    $262.23   -$162.23    -$32,709.17  -$11,409.17
 114    $100.00    $263.54   -$163.54    -$32,972.72  -$11,572.72
 115    $100.00    $264.86   -$164.86    -$33,237.58  -$11,737.58
 116    $100.00    $266.18   -$166.18    -$33,503.77  -$11,903.77
 117    $100.00    $267.51   -$167.51    -$33,771.29  -$12,071.29
 118    $100.00    $268.85   -$168.85    -$34,040.14  -$12,240.14
 119    $100.00    $270.20   -$170.20    -$34,310.35  -$12,410.35
 120     $99.99    $271.55   -$171.55    -$34,581.90  -$12,581.90


Last change: [11-Mar-1999]

Copyright © 1998 Department of Mathematics, University of Utah