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

A Balloon Payment

You are buying a house for $200,000 and you are planning to make payments for 20 years at an interest rate of 8%. The principal value after 20 years will be $50,000 (which you will refinance or pay off with money you obtain from another source by then.) Enter n = 240, p = 8% (/12), PV = 200,000, FV = -50,000 (note the minus sign), and click on compute payment. Your monthly payment will be $1,588.00.

The plot below shows the evolution of your payments. Because of the balloon payment you are paying significant amounts of interest until th every end.

This is your payment plan:


Loan: Loan Amortization, version 1.0, March 1999  run # 40
 Payment Plan 
 Principal Value    = $200,000.00
 Interest Rate      = 0.666666%
 number of payments = 240
 payment            = $1,588.00
 Future Value       = -$49,996.13
 
   #  payment      principal  interest   balance      total interest 
 
   1  $1,588.00    $254.66  $1,333.33    $199,745.33    $1,333.33
   2  $1,588.00    $256.36  $1,331.63    $199,488.96    $2,664.96
   3  $1,588.00    $258.07  $1,329.92    $199,230.89    $3,994.89
   4  $1,588.00    $259.79  $1,328.20    $198,971.10    $5,323.10
   5  $1,588.00    $261.52  $1,326.47    $198,709.57    $6,649.57
   6  $1,588.00    $263.26  $1,324.73    $198,446.30    $7,974.30
   7  $1,588.00    $265.02  $1,322.97    $198,181.28    $9,297.28
   8  $1,588.00    $266.79  $1,321.20    $197,914.48   $10,618.48
   9  $1,588.00    $268.57  $1,319.42    $197,645.91   $11,937.91
  10  $1,588.00    $270.36  $1,317.63    $197,375.55   $13,255.55
  11  $1,588.00    $272.16  $1,315.83    $197,103.39   $14,571.39
  12  $1,588.00    $273.97  $1,314.02    $196,829.41   $15,885.41
  13  $1,588.00    $275.80  $1,312.19    $196,553.61   $17,197.61
  14  $1,588.00    $277.64  $1,310.35    $196,275.97   $18,507.97
  15  $1,588.00    $279.49  $1,308.50    $195,996.47   $19,816.47
  16  $1,588.00    $281.35  $1,306.64    $195,715.12   $21,123.12
  17  $1,588.00    $283.23  $1,304.76    $195,431.88   $22,427.88
  18  $1,588.00    $285.12  $1,302.87    $195,146.76   $23,730.76
  19  $1,588.00    $287.02  $1,300.97    $194,859.74   $25,031.74
  20  $1,588.00    $288.93  $1,299.06    $194,570.81   $26,330.81
  21  $1,588.00    $290.86  $1,297.13    $194,279.95   $27,627.95
  22  $1,588.00    $292.80  $1,295.19    $193,987.15   $28,923.15
  23  $1,588.00    $294.75  $1,293.24    $193,692.39   $30,216.39
  24  $1,588.00    $296.71  $1,291.28    $193,395.68   $31,507.68
  25  $1,588.00    $298.69  $1,289.30    $193,096.98   $32,796.98
  26  $1,588.00    $300.68  $1,287.31    $192,796.29   $34,084.29
  27  $1,588.00    $302.69  $1,285.30    $192,493.60   $35,369.60
  28  $1,588.00    $304.70  $1,283.29    $192,188.89   $36,652.89
  29  $1,588.00    $306.74  $1,281.25    $191,882.15   $37,934.15
  30  $1,588.00    $308.78  $1,279.21    $191,573.37   $39,213.37
  31  $1,588.00    $310.84  $1,277.15    $191,262.52   $40,490.52
  32  $1,588.00    $312.91  $1,275.08    $190,949.61   $41,765.61
  33  $1,588.00    $315.00  $1,272.99    $190,634.60   $43,038.60
  34  $1,588.00    $317.10  $1,270.89    $190,317.50   $44,309.50
  35  $1,588.00    $319.21  $1,268.78    $189,998.28   $45,578.28
  36  $1,588.00    $321.34  $1,266.65    $189,676.94   $46,844.94
  37  $1,588.00    $323.48  $1,264.51    $189,353.45   $48,109.45
  38  $1,588.00    $325.64  $1,262.35    $189,027.81   $49,371.81
  39  $1,588.00    $327.81  $1,260.18    $188,699.99   $50,631.99
  40  $1,588.00    $330.00  $1,257.99    $188,369.99   $51,889.99
  41  $1,588.00    $332.20  $1,255.79    $188,037.79   $53,145.79
  42  $1,588.00    $334.41  $1,253.58    $187,703.38   $54,399.38
  43  $1,588.00    $336.64  $1,251.35    $187,366.74   $55,650.74
  44  $1,588.00    $338.88  $1,249.11    $187,027.85   $56,899.85
  45  $1,588.00    $341.14  $1,246.85    $186,686.70   $58,146.70
  46  $1,588.00    $343.42  $1,244.57    $186,343.28   $59,391.28
  47  $1,588.00    $345.71  $1,242.28    $185,997.57   $60,633.57
  48  $1,588.00    $348.01  $1,239.98    $185,649.55   $61,873.55
  49  $1,588.00    $350.33  $1,237.66    $185,299.21   $63,111.21
  50  $1,588.00    $352.67  $1,235.32    $184,946.54   $64,346.54
  51  $1,588.00    $355.02  $1,232.97    $184,591.52   $65,579.52
  52  $1,588.00    $357.38  $1,230.61    $184,234.13   $66,810.13
  53  $1,588.00    $359.77  $1,228.22    $183,874.36   $68,038.36
  54  $1,588.00    $362.17  $1,225.82    $183,512.19   $69,264.19
  55  $1,588.00    $364.58  $1,223.41    $183,147.60   $70,487.60
  56  $1,588.00    $367.01  $1,220.98    $182,780.58   $71,708.58
  57  $1,588.00    $369.46  $1,218.53    $182,411.12   $72,927.12
  58  $1,588.00    $371.92  $1,216.07    $182,039.20   $74,143.20
  59  $1,588.00    $374.40  $1,213.59    $181,664.79   $75,356.79
  60  $1,588.00    $376.90  $1,211.09    $181,287.89   $76,567.89
  61  $1,588.00    $379.41  $1,208.58    $180,908.47   $77,776.47
  62  $1,588.00    $381.94  $1,206.05    $180,526.53   $78,982.53
  63  $1,588.00    $384.48  $1,203.51    $180,142.04   $80,186.04
  64  $1,588.00    $387.05  $1,200.94    $179,754.99   $81,386.99
  65  $1,588.00    $389.63  $1,198.36    $179,365.36   $82,585.36
  66  $1,588.00    $392.23  $1,195.76    $178,973.12   $83,781.12
  67  $1,588.00    $394.84  $1,193.15    $178,578.28   $84,974.28
  68  $1,588.00    $397.47  $1,190.52    $178,180.80   $86,164.80
  69  $1,588.00    $400.12  $1,187.87    $177,780.67   $87,352.67
  70  $1,588.00    $402.79  $1,185.20    $177,377.88   $88,537.88
  71  $1,588.00    $405.48  $1,182.51    $176,972.40   $89,720.40
  72  $1,588.00    $408.18  $1,179.81    $176,564.21   $90,900.21
  73  $1,588.00    $410.90  $1,177.09    $176,153.31   $92,077.31
  74  $1,588.00    $413.64  $1,174.35    $175,739.66   $93,251.66
  75  $1,588.00    $416.40  $1,171.59    $175,323.26   $94,423.26
  76  $1,588.00    $419.17  $1,168.82    $174,904.08   $95,592.08
  77  $1,588.00    $421.97  $1,166.02    $174,482.11   $96,758.11
  78  $1,588.00    $424.78  $1,163.21    $174,057.32   $97,921.32
  79  $1,588.00    $427.61  $1,160.38    $173,629.71   $99,081.71
  80  $1,588.00    $430.46  $1,157.53    $173,199.24  $100,239.24
  81  $1,588.00    $433.33  $1,154.66    $172,765.90  $101,393.90
  82  $1,588.00    $436.22  $1,151.77    $172,329.67  $102,545.67
  83  $1,588.00    $439.13  $1,148.86    $171,890.54  $103,694.54
  84  $1,588.00    $442.06  $1,145.93    $171,448.47  $104,840.47
  85  $1,588.00    $445.01  $1,142.98    $171,003.46  $105,983.46
  86  $1,588.00    $447.97  $1,140.02    $170,555.49  $107,123.49
  87  $1,588.00    $450.96  $1,137.03    $170,104.52  $108,260.52
  88  $1,588.00    $453.96  $1,134.03    $169,650.55  $109,394.55
  89  $1,588.00    $456.99  $1,131.00    $169,193.56  $110,525.56
  90  $1,588.00    $460.04  $1,127.95    $168,733.51  $111,653.51
  91  $1,588.00    $463.10  $1,124.89    $168,270.40  $112,778.40
  92  $1,588.00    $466.19  $1,121.80    $167,804.21  $113,900.21
  93  $1,588.00    $469.30  $1,118.69    $167,334.90  $115,018.90
  94  $1,588.00    $472.43  $1,115.56    $166,862.47  $116,134.47
  95  $1,588.00    $475.58  $1,112.41    $166,386.88  $117,246.88
  96  $1,588.00    $478.75  $1,109.24    $165,908.13  $118,356.13
  97  $1,588.00    $481.94  $1,106.05    $165,426.18  $119,462.18
  98  $1,588.00    $485.15  $1,102.84    $164,941.02  $120,565.02
  99  $1,588.00    $488.39  $1,099.60    $164,452.63  $121,664.63
 100  $1,588.00    $491.64  $1,096.35    $163,960.98  $122,760.98
 101  $1,588.00    $494.92  $1,093.07    $163,466.06  $123,854.06
 102  $1,588.00    $498.22  $1,089.77    $162,967.83  $124,943.83
 103  $1,588.00    $501.54  $1,086.45    $162,466.28  $126,030.28
 104  $1,588.00    $504.89  $1,083.10    $161,961.39  $127,113.39
 105  $1,588.00    $508.25  $1,079.74    $161,453.13  $128,193.13
 106  $1,588.00    $511.64  $1,076.35    $160,941.49  $129,269.49
 107  $1,588.00    $515.05  $1,072.94    $160,426.43  $130,342.43
 108  $1,588.00    $518.49  $1,069.50    $159,907.94  $131,411.94
 109  $1,588.00    $521.94  $1,066.05    $159,385.99  $132,477.99
 110  $1,588.00    $525.42  $1,062.57    $158,860.57  $133,540.57
 111  $1,588.00    $528.92  $1,059.07    $158,331.64  $134,599.64
 112  $1,588.00    $532.45  $1,055.54    $157,799.18  $135,655.18
 113  $1,588.00    $536.00  $1,051.99    $157,263.18  $136,707.18
 114  $1,588.00    $539.57  $1,048.42    $156,723.60  $137,755.60
 115  $1,588.00    $543.17  $1,044.82    $156,180.42  $138,800.42
 116  $1,588.00    $546.79  $1,041.20    $155,633.62  $139,841.62
 117  $1,588.00    $550.44  $1,037.55    $155,083.18  $140,879.18
 118  $1,588.00    $554.11  $1,033.88    $154,529.07  $141,913.07
 119  $1,588.00    $557.80  $1,030.19    $153,971.26  $142,943.26
 120  $1,588.00    $561.52  $1,026.47    $153,409.74  $143,969.74
 121  $1,588.00    $565.26  $1,022.73    $152,844.47  $144,992.47
 122  $1,588.00    $569.03  $1,018.96    $152,275.43  $146,011.43
 123  $1,588.00    $572.83  $1,015.16    $151,702.60  $147,026.60
 124  $1,588.00    $576.64  $1,011.35    $151,125.95  $148,037.95
 125  $1,588.00    $580.49  $1,007.50    $150,545.46  $149,045.46
 126  $1,588.00    $584.36  $1,003.63    $149,961.10  $150,049.10
 127  $1,588.00    $588.25    $999.74    $149,372.84  $151,048.84
 128  $1,588.00    $592.18    $995.81    $148,780.66  $152,044.66
 129  $1,588.00    $596.12    $991.87    $148,184.53  $153,036.53
 130  $1,588.00    $600.10    $987.89    $147,584.42  $154,024.42
 131  $1,588.00    $604.10    $983.89    $146,980.32  $155,008.32
 132  $1,588.00    $608.13    $979.86    $146,372.19  $155,988.19
 133  $1,588.00    $612.18    $975.81    $145,760.00  $156,964.00
 134  $1,588.00    $616.26    $971.73    $145,143.74  $157,935.74
 135  $1,588.00    $620.37    $967.62    $144,523.36  $158,903.36
 136  $1,588.00    $624.51    $963.48    $143,898.85  $159,866.85
 137  $1,588.00    $628.67    $959.32    $143,270.18  $160,826.18
 138  $1,588.00    $632.86    $955.13    $142,637.31  $161,781.31
 139  $1,588.00    $637.08    $950.91    $142,000.23  $162,732.23
 140  $1,588.00    $641.33    $946.66    $141,358.89  $163,678.89
 141  $1,588.00    $645.60    $942.39    $140,713.29  $164,621.29
 142  $1,588.00    $649.91    $938.08    $140,063.38  $165,559.38
 143  $1,588.00    $654.24    $933.75    $139,409.13  $166,493.13
 144  $1,588.00    $658.60    $929.39    $138,750.53  $167,422.53
 145  $1,588.00    $662.99    $925.00    $138,087.53  $168,347.53
 146  $1,588.00    $667.41    $920.58    $137,420.11  $169,268.11
 147  $1,588.00    $671.86    $916.13    $136,748.25  $170,184.25
 148  $1,588.00    $676.34    $911.65    $136,071.90  $171,095.90
 149  $1,588.00    $680.85    $907.14    $135,391.05  $172,003.05
 150  $1,588.00    $685.39    $902.60    $134,705.66  $172,905.66
 151  $1,588.00    $689.96    $898.03    $134,015.69  $173,803.69
 152  $1,588.00    $694.56    $893.43    $133,321.13  $174,697.13
 153  $1,588.00    $699.19    $888.80    $132,621.94  $175,585.94
 154  $1,588.00    $703.85    $884.14    $131,918.08  $176,470.08
 155  $1,588.00    $708.54    $879.45    $131,209.54  $177,349.54
 156  $1,588.00    $713.26    $874.73    $130,496.27  $178,224.27
 157  $1,588.00    $718.02    $869.97    $129,778.24  $179,094.24
 158  $1,588.00    $722.81    $865.18    $129,055.43  $179,959.43
 159  $1,588.00    $727.63    $860.36    $128,327.80  $180,819.80
 160  $1,588.00    $732.48    $855.51    $127,595.32  $181,675.32
 161  $1,588.00    $737.36    $850.63    $126,857.96  $182,525.96
 162  $1,588.00    $742.28    $845.71    $126,115.68  $183,371.68
 163  $1,588.00    $747.22    $840.77    $125,368.45  $184,212.45
 164  $1,588.00    $752.21    $835.78    $124,616.24  $185,048.24
 165  $1,588.00    $757.22    $830.77    $123,859.01  $185,879.01
 166  $1,588.00    $762.27    $825.72    $123,096.74  $186,704.74
 167  $1,588.00    $767.35    $820.64    $122,329.38  $187,525.38
 168  $1,588.00    $772.47    $815.52    $121,556.91  $188,340.91
 169  $1,588.00    $777.62    $810.37    $120,779.29  $189,151.29
 170  $1,588.00    $782.80    $805.19    $119,996.49  $189,956.49
 171  $1,588.00    $788.02    $799.97    $119,208.46  $190,756.46
 172  $1,588.00    $793.27    $794.72    $118,415.19  $191,551.19
 173  $1,588.00    $798.56    $789.43    $117,616.62  $192,340.62
 174  $1,588.00    $803.88    $784.11    $116,812.73  $193,124.73
 175  $1,588.00    $809.24    $778.75    $116,003.48  $193,903.48
 176  $1,588.00    $814.64    $773.35    $115,188.84  $194,676.84
 177  $1,588.00    $820.07    $767.92    $114,368.77  $195,444.77
 178  $1,588.00    $825.54    $762.45    $113,543.23  $196,207.23
 179  $1,588.00    $831.04    $756.95    $112,712.18  $196,964.18
 180  $1,588.00    $836.58    $751.41    $111,875.59  $197,715.59
 181  $1,588.00    $842.16    $745.83    $111,033.43  $198,461.43
 182  $1,588.00    $847.77    $740.22    $110,185.65  $199,201.65
 183  $1,588.00    $853.42    $734.57    $109,332.23  $199,936.23
 184  $1,588.00    $859.11    $728.88    $108,473.11  $200,665.11
 185  $1,588.00    $864.84    $723.15    $107,608.26  $201,388.26
 186  $1,588.00    $870.61    $717.38    $106,737.65  $202,105.65
 187  $1,588.00    $876.41    $711.58    $105,861.23  $202,817.23
 188  $1,588.00    $882.25    $705.74    $104,978.98  $203,522.98
 189  $1,588.00    $888.14    $699.85    $104,090.84  $204,222.84
 190  $1,588.00    $894.06    $693.93    $103,196.77  $204,916.77
 191  $1,588.00    $900.02    $687.97    $102,296.75  $205,604.75
 192  $1,588.00    $906.02    $681.97    $101,390.73  $206,286.73
 193  $1,588.00    $912.06    $675.93    $100,478.67  $206,962.67
 194  $1,588.00    $918.14    $669.85     $99,560.53  $207,632.53
 195  $1,588.00    $924.26    $663.73     $98,636.26  $208,296.26
 196  $1,588.00    $930.42    $657.57     $97,705.84  $208,953.84
 197  $1,588.00    $936.62    $651.37     $96,769.21  $209,605.21
 198  $1,588.00    $942.87    $645.12     $95,826.34  $210,250.34
 199  $1,588.00    $949.15    $638.84     $94,877.18  $210,889.18
 200  $1,588.00    $955.48    $632.51     $93,921.70  $211,521.70
 201  $1,588.00    $961.85    $626.14     $92,959.84  $212,147.84
 202  $1,588.00    $968.26    $619.73     $91,991.57  $212,767.57
 203  $1,588.00    $974.72    $613.27     $91,016.85  $213,380.85
 204  $1,588.00    $981.22    $606.77     $90,035.63  $213,987.63
 205  $1,588.00    $987.76    $600.23     $89,047.87  $214,587.87
 206  $1,588.00    $994.34    $593.65     $88,053.52  $215,181.52
 207  $1,588.00  $1,000.97    $587.02     $87,052.54  $215,768.54
 208  $1,588.00  $1,007.64    $580.35     $86,044.89  $216,348.89
 209  $1,588.00  $1,014.36    $573.63     $85,030.53  $216,922.53
 210  $1,588.00  $1,021.12    $566.87     $84,009.40  $217,489.40
 211  $1,588.00  $1,027.93    $560.06     $82,981.46  $218,049.46
 212  $1,588.00  $1,034.79    $553.20     $81,946.67  $218,602.67
 213  $1,588.00  $1,041.68    $546.31     $80,904.98  $219,148.98
 214  $1,588.00  $1,048.63    $539.36     $79,856.35  $219,688.35
 215  $1,588.00  $1,055.62    $532.37     $78,800.72  $220,220.72
 216  $1,588.00  $1,062.66    $525.33     $77,738.06  $220,746.06
 217  $1,588.00  $1,069.74    $518.25     $76,668.31  $221,264.31
 218  $1,588.00  $1,076.87    $511.12     $75,591.44  $221,775.44
 219  $1,588.00  $1,084.05    $503.94     $74,507.38  $222,279.38
 220  $1,588.00  $1,091.28    $496.71     $73,416.10  $222,776.10
 221  $1,588.00  $1,098.55    $489.44     $72,317.54  $223,265.54
 222  $1,588.00  $1,105.88    $482.11     $71,211.65  $223,747.65
 223  $1,588.00  $1,113.25    $474.74     $70,098.40  $224,222.40
 224  $1,588.00  $1,120.67    $467.32     $68,977.72  $224,689.72
 225  $1,588.00  $1,128.14    $459.85     $67,849.57  $225,149.57
 226  $1,588.00  $1,135.66    $452.33     $66,713.90  $225,601.90
 227  $1,588.00  $1,143.24    $444.75     $65,570.66  $226,046.66
 228  $1,588.00  $1,150.86    $437.13     $64,419.80  $226,483.80
 229  $1,588.00  $1,158.53    $429.46     $63,261.27  $226,913.27
 230  $1,588.00  $1,166.25    $421.74     $62,095.01  $227,335.01
 231  $1,588.00  $1,174.03    $413.96     $60,920.97  $227,748.97
 232  $1,588.00  $1,181.86    $406.13     $59,739.11  $228,155.11
 233  $1,588.00  $1,189.73    $398.26     $58,549.37  $228,553.37
 234  $1,588.00  $1,197.67    $390.32     $57,351.70  $228,943.70
 235  $1,588.00  $1,205.65    $382.34     $56,146.05  $229,326.05
 236  $1,588.00  $1,213.69    $374.30     $54,932.36  $229,700.36
 237  $1,588.00  $1,221.78    $366.21     $53,710.57  $230,066.57
 238  $1,588.00  $1,229.92    $358.07     $52,480.64  $230,424.64
 239  $1,588.00  $1,238.12    $349.87     $51,242.51  $230,774.51
 240  $1,587.99  $1,246.38    $341.61     $49,996.13  $231,116.13


Last change: [11-Mar-1999]

Copyright © 1998 Department of Mathematics, University of Utah