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

How long to pay?

You want to buy a house for $250,000, at an annual interest rate of 7.25%. You can afford payments of $2,500 per month. How long will you have to make payments? Enter interest = 7.25% (/12), PV = 250,000, pmt = 2,500, FV = 0., and press the Compute n button. You need to make 154 payments.

However, your bank does not offer loans of that duration so you decide to take out a loan for 15 years (180 months). You change the value of n to 180 and press the compute pmt button. Your payment drops to 2,2822.15. You decide to raise your kids allowances by a total of $217.85 per month.

The calculator after the first computation looks like this:

After the recomputation it looks like this:

The plot looks much like the plot in Example 1.

Your payment plan is



Loan: Loan Amortization, version 1.0, March 1999  run # 39
 Payment Plan 
 Principal Value    = $250,000.00
 Interest Rate      = 0.604166%
 number of payments = 180
 payment            = $2,282.15
 Future Value       = -$2.33
 
   #  payment      principal  interest   balance      total interest 
 
   1  $2,282.15    $771.73  $1,510.41    $249,228.26    $1,510.41
   2  $2,282.15    $776.39  $1,505.75    $248,451.87    $3,016.17
   3  $2,282.15    $781.08  $1,501.06    $247,670.78    $4,517.23
   4  $2,282.15    $785.80  $1,496.34    $246,884.97    $6,013.57
   5  $2,282.15    $790.55  $1,491.59    $246,094.42    $7,505.17
   6  $2,282.15    $795.32  $1,486.82    $245,299.09    $8,991.99
   7  $2,282.15    $800.13  $1,482.01    $244,498.96   $10,474.01
   8  $2,282.15    $804.96  $1,477.18    $243,693.99   $11,951.19
   9  $2,282.15    $809.83  $1,472.31    $242,884.16   $13,423.51
  10  $2,282.15    $814.72  $1,467.42    $242,069.43   $14,890.93
  11  $2,282.15    $819.64  $1,462.50    $241,249.78   $16,353.43
  12  $2,282.15    $824.59  $1,457.55    $240,425.18   $17,810.98
  13  $2,282.15    $829.58  $1,452.56    $239,595.60   $19,263.55
  14  $2,282.15    $834.59  $1,447.55    $238,761.01   $20,711.11
  15  $2,282.15    $839.63  $1,442.51    $237,921.37   $22,153.62
  16  $2,282.15    $844.70  $1,437.44    $237,076.67   $23,591.07
  17  $2,282.15    $849.81  $1,432.33    $236,226.85   $25,023.40
  18  $2,282.15    $854.94  $1,427.20    $235,371.91   $26,450.61
  19  $2,282.15    $860.11  $1,422.03    $234,511.80   $27,872.65
  20  $2,282.15    $865.30  $1,416.84    $233,646.49   $29,289.49
  21  $2,282.15    $870.53  $1,411.61    $232,775.95   $30,701.10
  22  $2,282.15    $875.79  $1,406.35    $231,900.16   $32,107.46
  23  $2,282.15    $881.08  $1,401.06    $231,019.07   $33,508.52
  24  $2,282.15    $886.40  $1,395.74    $230,132.66   $34,904.26
  25  $2,282.15    $891.76  $1,390.38    $229,240.90   $36,294.65
  26  $2,282.15    $897.15  $1,384.99    $228,343.74   $37,679.64
  27  $2,282.15    $902.57  $1,379.57    $227,441.17   $39,059.22
  28  $2,282.15    $908.02  $1,374.12    $226,533.14   $40,433.34
  29  $2,282.15    $913.51  $1,368.63    $225,619.63   $41,801.98
  30  $2,282.15    $919.03  $1,363.11    $224,700.60   $43,165.10
  31  $2,282.15    $924.58  $1,357.56    $223,776.02   $44,522.67
  32  $2,282.15    $930.16  $1,351.98    $222,845.85   $45,874.65
  33  $2,282.15    $935.78  $1,346.36    $221,910.06   $47,221.01
  34  $2,282.15    $941.44  $1,340.70    $220,968.61   $48,561.71
  35  $2,282.15    $947.13  $1,335.01    $220,021.48   $49,896.73
  36  $2,282.15    $952.85  $1,329.29    $219,068.63   $51,226.03
  37  $2,282.15    $958.61  $1,323.53    $218,110.02   $52,549.57
  38  $2,282.15    $964.40  $1,317.74    $217,145.62   $53,867.32
  39  $2,282.15    $970.22  $1,311.92    $216,175.39   $55,179.24
  40  $2,282.15    $976.09  $1,306.05    $215,199.30   $56,485.30
  41  $2,282.15    $981.98  $1,300.16    $214,217.31   $57,785.46
  42  $2,282.15    $987.92  $1,294.22    $213,229.39   $59,079.69
  43  $2,282.15    $993.88  $1,288.26    $212,235.50   $60,367.95
  44  $2,282.15    $999.89  $1,282.25    $211,235.61   $61,650.21
  45  $2,282.15  $1,005.93  $1,276.21    $210,229.67   $62,926.42
  46  $2,282.15  $1,012.01  $1,270.13    $209,217.66   $64,196.56
  47  $2,282.15  $1,018.12  $1,264.02    $208,199.53   $65,460.58
  48  $2,282.15  $1,024.27  $1,257.87    $207,175.26   $66,718.46
  49  $2,282.15  $1,030.46  $1,251.68    $206,144.79   $67,970.14
  50  $2,282.15  $1,036.69  $1,245.45    $205,108.10   $69,215.60
  51  $2,282.15  $1,042.95  $1,239.19    $204,065.14   $70,454.79
  52  $2,282.15  $1,049.25  $1,232.89    $203,015.89   $71,687.69
  53  $2,282.15  $1,055.59  $1,226.55    $201,960.29   $72,914.24
  54  $2,282.15  $1,061.97  $1,220.17    $200,898.32   $74,134.42
  55  $2,282.15  $1,068.38  $1,213.76    $199,829.93   $75,348.18
  56  $2,282.15  $1,074.84  $1,207.30    $198,755.08   $76,555.48
  57  $2,282.15  $1,081.33  $1,200.81    $197,673.75   $77,756.30
  58  $2,282.15  $1,087.87  $1,194.27    $196,585.87   $78,950.57
  59  $2,282.15  $1,094.44  $1,187.70    $195,491.43   $80,138.28
  60  $2,282.15  $1,101.05  $1,181.09    $194,390.37   $81,319.37
  61  $2,282.15  $1,107.70  $1,174.44    $193,282.67   $82,493.82
  62  $2,282.15  $1,114.40  $1,167.74    $192,168.27   $83,661.57
  63  $2,282.15  $1,121.13  $1,161.01    $191,047.13   $84,822.58
  64  $2,282.15  $1,127.90  $1,154.24    $189,919.23   $85,976.83
  65  $2,282.15  $1,134.72  $1,147.42    $188,784.50   $87,124.25
  66  $2,282.15  $1,141.57  $1,140.57    $187,642.93   $88,264.83
  67  $2,282.15  $1,148.47  $1,133.67    $186,494.45   $89,398.50
  68  $2,282.15  $1,155.41  $1,126.73    $185,339.04   $90,525.24
  69  $2,282.15  $1,162.39  $1,119.75    $184,176.65   $91,645.00
  70  $2,282.15  $1,169.41  $1,112.73    $183,007.23   $92,757.73
  71  $2,282.15  $1,176.48  $1,105.66    $181,830.75   $93,863.40
  72  $2,282.15  $1,183.58  $1,098.56    $180,647.16   $94,961.96
  73  $2,282.15  $1,190.74  $1,091.40    $179,456.42   $96,053.37
  74  $2,282.15  $1,197.93  $1,084.21    $178,258.49   $97,137.59
  75  $2,282.15  $1,205.17  $1,076.97    $177,053.32   $98,214.57
  76  $2,282.15  $1,212.45  $1,069.69    $175,840.86   $99,284.26
  77  $2,282.15  $1,219.77  $1,062.37    $174,621.08  $100,346.63
  78  $2,282.15  $1,227.14  $1,055.00    $173,393.94  $101,401.64
  79  $2,282.15  $1,234.56  $1,047.58    $172,159.38  $102,449.23
  80  $2,282.15  $1,242.02  $1,040.12    $170,917.35  $103,489.35
  81  $2,282.15  $1,249.52  $1,032.62    $169,667.83  $104,521.98
  82  $2,282.15  $1,257.07  $1,025.07    $168,410.76  $105,547.06
  83  $2,282.15  $1,264.66  $1,017.48    $167,146.09  $106,564.54
  84  $2,282.15  $1,272.30  $1,009.84    $165,873.78  $107,574.38
  85  $2,282.15  $1,279.99  $1,002.15    $164,593.78  $108,576.53
  86  $2,282.15  $1,287.72    $994.42    $163,306.05  $109,570.95
  87  $2,282.15  $1,295.50    $986.64    $162,010.55  $110,557.60
  88  $2,282.15  $1,303.33    $978.81    $160,707.21  $111,536.41
  89  $2,282.15  $1,311.21    $970.93    $159,396.00  $112,507.35
  90  $2,282.15  $1,319.13    $963.01    $158,076.87  $113,470.37
  91  $2,282.15  $1,327.10    $955.04    $156,749.76  $114,425.41
  92  $2,282.15  $1,335.12    $947.02    $155,414.64  $115,372.44
  93  $2,282.15  $1,343.18    $938.96    $154,071.46  $116,311.41
  94  $2,282.15  $1,351.30    $930.84    $152,720.16  $117,242.26
  95  $2,282.15  $1,359.46    $922.68    $151,360.69  $118,164.94
  96  $2,282.15  $1,367.67    $914.47    $149,993.01  $119,079.41
  97  $2,282.15  $1,375.94    $906.20    $148,617.07  $119,985.62
  98  $2,282.15  $1,384.25    $897.89    $147,232.81  $120,883.51
  99  $2,282.15  $1,392.61    $889.53    $145,840.20  $121,773.05
 100  $2,282.15  $1,401.03    $881.11    $144,439.16  $122,654.16
 101  $2,282.15  $1,409.49    $872.65    $143,029.67  $123,526.82
 102  $2,282.15  $1,418.01    $864.13    $141,611.65  $124,390.95
 103  $2,282.15  $1,426.57    $855.57    $140,185.07  $125,246.52
 104  $2,282.15  $1,435.19    $846.95    $138,749.88  $126,093.48
 105  $2,282.15  $1,443.86    $838.28    $137,306.01  $126,931.76
 106  $2,282.15  $1,452.59    $829.55    $135,853.41  $127,761.31
 107  $2,282.15  $1,461.36    $820.78    $134,392.04  $128,582.09
 108  $2,282.15  $1,470.19    $811.95    $132,921.85  $129,394.05
 109  $2,282.15  $1,479.08    $803.06    $131,442.77  $130,197.12
 110  $2,282.15  $1,488.01    $794.13    $129,954.75  $130,991.25
 111  $2,282.15  $1,497.00    $785.14    $128,457.74  $131,776.39
 112  $2,282.15  $1,506.05    $776.09    $126,951.69  $132,552.49
 113  $2,282.15  $1,515.15    $766.99    $125,436.54  $133,319.49
 114  $2,282.15  $1,524.30    $757.84    $123,912.24  $134,077.34
 115  $2,282.15  $1,533.51    $748.63    $122,378.72  $134,825.97
 116  $2,282.15  $1,542.77    $739.37    $120,835.95  $135,565.35
 117  $2,282.15  $1,552.09    $730.05    $119,283.85  $136,295.40
 118  $2,282.15  $1,561.47    $720.67    $117,722.37  $137,016.07
 119  $2,282.15  $1,570.91    $711.23    $116,151.46  $137,727.31
 120  $2,282.15  $1,580.40    $701.74    $114,571.06  $138,429.06
 121  $2,282.15  $1,589.94    $692.20    $112,981.11  $139,121.26
 122  $2,282.15  $1,599.55    $682.59    $111,381.55  $139,803.85
 123  $2,282.15  $1,609.21    $672.93    $109,772.33  $140,476.78
 124  $2,282.15  $1,618.94    $663.20    $108,153.39  $141,139.99
 125  $2,282.15  $1,628.72    $653.42    $106,524.67  $141,793.42
 126  $2,282.15  $1,638.56    $643.58    $104,886.10  $142,437.00
 127  $2,282.15  $1,648.46    $633.68    $103,237.64  $143,070.69
 128  $2,282.15  $1,658.42    $623.72    $101,579.22  $143,694.42
 129  $2,282.15  $1,668.44    $613.70     $99,910.77  $144,308.12
 130  $2,282.15  $1,678.52    $603.62     $98,232.25  $144,911.75
 131  $2,282.15  $1,688.66    $593.48     $96,543.59  $145,505.24
 132  $2,282.15  $1,698.86    $583.28     $94,844.72  $146,088.52
 133  $2,282.15  $1,709.12    $573.02     $93,135.59  $146,661.54
 134  $2,282.15  $1,719.45    $562.69     $91,416.14  $147,224.24
 135  $2,282.15  $1,729.84    $552.30     $89,686.29  $147,776.54
 136  $2,282.15  $1,740.29    $541.85     $87,946.00  $148,318.40
 137  $2,282.15  $1,750.80    $531.34     $86,195.19  $148,849.74
 138  $2,282.15  $1,761.38    $520.76     $84,433.80  $149,370.50
 139  $2,282.15  $1,772.02    $510.12     $82,661.77  $149,880.62
 140  $2,282.15  $1,782.73    $499.41     $80,879.04  $150,380.04
 141  $2,282.15  $1,793.50    $488.64     $79,085.53  $150,868.68
 142  $2,282.15  $1,804.34    $477.80     $77,281.19  $151,346.49
 143  $2,282.15  $1,815.24    $466.90     $75,465.95  $151,813.40
 144  $2,282.15  $1,826.20    $455.94     $73,639.74  $152,269.34
 145  $2,282.15  $1,837.24    $444.90     $71,802.49  $152,714.24
 146  $2,282.15  $1,848.34    $433.80     $69,954.15  $153,148.05
 147  $2,282.15  $1,859.51    $422.63     $68,094.64  $153,570.69
 148  $2,282.15  $1,870.74    $411.40     $66,223.90  $153,982.10
 149  $2,282.15  $1,882.04    $400.10     $64,341.85  $154,382.20
 150  $2,282.15  $1,893.41    $388.73     $62,448.43  $154,770.93
 151  $2,282.15  $1,904.85    $377.29     $60,543.57  $155,148.22
 152  $2,282.15  $1,916.36    $365.78     $58,627.21  $155,514.01
 153  $2,282.15  $1,927.94    $354.20     $56,699.26  $155,868.21
 154  $2,282.15  $1,939.59    $342.55     $54,759.67  $156,210.77
 155  $2,282.15  $1,951.31    $330.83     $52,808.36  $156,541.61
 156  $2,282.15  $1,963.09    $319.05     $50,845.26  $156,860.66
 157  $2,282.15  $1,974.95    $307.19     $48,870.30  $157,167.85
 158  $2,282.15  $1,986.89    $295.25     $46,883.41  $157,463.11
 159  $2,282.15  $1,998.89    $283.25     $44,884.51  $157,746.36
 160  $2,282.15  $2,010.97    $271.17     $42,873.54  $158,017.54
 161  $2,282.15  $2,023.12    $259.02     $40,850.42  $158,276.57
 162  $2,282.15  $2,035.34    $246.80     $38,815.07  $158,523.37
 163  $2,282.15  $2,047.64    $234.50     $36,767.43  $158,757.88
 164  $2,282.15  $2,060.01    $222.13     $34,707.42  $158,980.02
 165  $2,282.15  $2,072.45    $209.69     $32,634.96  $159,189.71
 166  $2,282.15  $2,084.98    $197.16     $30,549.98  $159,386.88
 167  $2,282.15  $2,097.57    $184.57     $28,452.40  $159,571.45
 168  $2,282.15  $2,110.25    $171.89     $26,342.15  $159,743.35
 169  $2,282.15  $2,122.99    $159.15     $24,219.15  $159,902.50
 170  $2,282.15  $2,135.82    $146.32     $22,083.33  $160,048.83
 171  $2,282.15  $2,148.72    $133.42     $19,934.60  $160,182.25
 172  $2,282.15  $2,161.71    $120.43     $17,772.88  $160,302.68
 173  $2,282.15  $2,174.77    $107.37     $15,598.11  $160,410.06
 174  $2,282.15  $2,187.91     $94.23     $13,410.20  $160,504.30
 175  $2,282.15  $2,201.13     $81.01     $11,209.07  $160,585.32
 176  $2,282.15  $2,214.42     $67.72      $8,994.64  $160,653.04
 177  $2,282.15  $2,227.80     $54.34      $6,766.83  $160,707.38
 178  $2,282.15  $2,241.26     $40.88      $4,525.57  $160,748.27
 179  $2,282.15  $2,254.80     $27.34      $2,270.76  $160,775.61
 180  $2,282.15  $2,268.43     $13.71          $2.33  $160,789.33


Last change: [11-Mar-1999]

Copyright © 1998 Department of Mathematics, University of Utah