34220259-29bb-4ca1-b571-b1d07069ad32.xls
10 Year Fixed
Mortgage Calculations Created By John Weeks john@johnweeks.com Date Month Jan-04 Feb-04 Mar-04 Apr-04 May-04 Jun-04 Jul-04 Aug-04 Sep-04 Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05 May-05 Jun-05 Jul-05 Aug-05 Sep-05 Oct-05 Nov-05 Dec-05 Jan-06 Feb-06 Year MonthPayment Number In YearNumber 1 1 1 1 2 2 1 3 3 1 4 4 1 5 5 1 6 6 1 7 7 1 8 8 1 9 9 1 10 10 1 11 11 1 12 12 2 1 13 2 2 14 2 3 15 2 4 16 2 5 17 2 6 18 2 7 19 2 8 20 2 9 21 2 10 22 2 11 23 2 12 24 3 1 25 3 2 26 Principal Balance $150,000.00 $149,084.69 $148,164.81 $147,240.32 $146,311.22 $145,377.47 $144,439.05 $143,495.94 $142,548.11 $141,595.54 $140,638.21 $139,676.09 $138,709.17 $137,737.41 $136,760.78 $135,779.28 $134,792.87 $133,801.53 $132,805.23 $131,803.95 $130,797.66 $129,786.34 $128,769.96 $127,748.50 $126,721.94 $125,690.24 Principal Interest Payment $150,000.00 <-- Fill In Value 1) To get payment, do a goal seek on cell I130 6.00000% <-- Fill In Value Set the value of I130 to be zero by changing cell F4. $1,665.31 <-- Do A Goal Seek2) To change months, edit A11, then select from A11 to A130. Then Edit - Fill - Series, and pick months. 3) To pay additional principal, simply type in the amount. Watch the payments at the end go away. Principal Amount $915.31 $919.88 $924.48 $929.11 $933.75 $938.42 $943.11 $947.83 $952.57 $957.33 $962.12 $966.93 $971.76 $976.62 $981.50 $986.41 $991.34 $996.30 $1,001.28 $1,006.29 $1,011.32 $1,016.38 $1,021.46 $1,026.57 $1,031.70 $1,036.86 Interest Amount $750.00 $745.42 $740.82 $736.20 $731.56 $726.89 $722.20 $717.48 $712.74 $707.98 $703.19 $698.38 $693.55 $688.69 $683.80 $678.90 $673.96 $669.01 $664.03 $659.02 $653.99 $648.93 $643.85 $638.74 $633.61 $628.45 Additional Principal Pmt $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Ending Balance $149,084.69 $148,164.81 $147,240.32 $146,311.22 $145,377.47 $144,439.05 $143,495.94 $142,548.11 $141,595.54 $140,638.21 $139,676.09 $138,709.17 $137,737.41 $136,760.78 $135,779.28 $134,792.87 $133,801.53 $132,805.23 $131,803.95 $130,797.66 $129,786.34 $128,769.96 $127,748.50 $126,721.94 $125,690.24 $124,653.39 Owned Eguity $915.31 $1,835.19 $2,759.68 $3,688.78 $4,622.53 $5,560.95 $6,504.06 $7,451.89 $8,404.46 $9,361.79 $10,323.91 $11,290.83 $12,262.59 $13,239.22 $14,220.72 $15,207.13 $16,198.47 $17,194.77 $18,196.05 $19,202.34 $20,213.66 $21,230.04 $22,251.50 $23,278.06 $24,309.76 $25,346.61
Page 1
34220259-29bb-4ca1-b571-b1d07069ad32.xls
Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09
3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 6 6 6
3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
$124,653.39 $123,611.35 $122,564.09 $121,511.61 $120,453.86 $119,390.82 $118,322.47 $117,248.77 $116,169.71 $115,085.25 $113,995.37 $112,900.04 $111,799.23 $110,692.92 $109,581.07 $108,463.67 $107,340.68 $106,212.08 $105,077.83 $103,937.91 $102,792.30 $101,640.95 $100,483.85 $99,320.96 $98,152.26 $96,977.71 $95,797.29 $94,610.97 $93,418.72 $92,220.50 $91,016.30 $89,806.07 $88,589.79 $87,367.44 $86,138.97 $84,904.35 $83,663.57
$1,042.04 $1,047.25 $1,052.49 $1,057.75 $1,063.04 $1,068.35 $1,073.70 $1,079.06 $1,084.46 $1,089.88 $1,095.33 $1,100.81 $1,106.31 $1,111.84 $1,117.40 $1,122.99 $1,128.60 $1,134.25 $1,139.92 $1,145.62 $1,151.35 $1,157.10 $1,162.89 $1,168.70 $1,174.55 $1,180.42 $1,186.32 $1,192.25 $1,198.21 $1,204.21 $1,210.23 $1,216.28 $1,222.36 $1,228.47 $1,234.61 $1,240.79 $1,246.99
$623.27 $618.06 $612.82 $607.56 $602.27 $596.95 $591.61 $586.24 $580.85 $575.43 $569.98 $564.50 $559.00 $553.46 $547.91 $542.32 $536.70 $531.06 $525.39 $519.69 $513.96 $508.20 $502.42 $496.60 $490.76 $484.89 $478.99 $473.05 $467.09 $461.10 $455.08 $449.03 $442.95 $436.84 $430.69 $424.52 $418.32
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$123,611.35 $122,564.09 $121,511.61 $120,453.86 $119,390.82 $118,322.47 $117,248.77 $116,169.71 $115,085.25 $113,995.37 $112,900.04 $111,799.23 $110,692.92 $109,581.07 $108,463.67 $107,340.68 $106,212.08 $105,077.83 $103,937.91 $102,792.30 $101,640.95 $100,483.85 $99,320.96 $98,152.26 $96,977.71 $95,797.29 $94,610.97 $93,418.72 $92,220.50 $91,016.30 $89,806.07 $88,589.79 $87,367.44 $86,138.97 $84,904.35 $83,663.57 $82,416.58
$26,388.65 $27,435.91 $28,488.39 $29,546.14 $30,609.18 $31,677.53 $32,751.23 $33,830.29 $34,914.75 $36,004.63 $37,099.96 $38,200.77 $39,307.08 $40,418.93 $41,536.33 $42,659.32 $43,787.92 $44,922.17 $46,062.09 $47,207.70 $48,359.05 $49,516.15 $50,679.04 $51,847.74 $53,022.29 $54,202.71 $55,389.03 $56,581.28 $57,779.50 $58,983.70 $60,193.93 $61,410.21 $62,632.56 $63,861.03 $65,095.65 $66,336.43 $67,583.42
Page 2
34220259-29bb-4ca1-b571-b1d07069ad32.xls
Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12
6 6 6 6 6 6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 8 8 8 8 8 8 8 8 8 8 8 8 9 9 9 9
4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4
64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
$82,416.58 $81,163.35 $79,903.86 $78,638.07 $77,365.96 $76,087.48 $74,802.61 $73,511.31 $72,213.56 $70,909.32 $69,598.56 $68,281.25 $66,957.35 $65,626.83 $64,289.65 $62,945.79 $61,595.21 $60,237.88 $58,873.77 $57,502.83 $56,125.03 $54,740.35 $53,348.75 $51,950.18 $50,544.62 $49,132.04 $47,712.39 $46,285.65 $44,851.77 $43,410.72 $41,962.47 $40,506.97 $39,044.20 $37,574.11 $36,096.67 $34,611.85 $33,119.60
$1,253.22 $1,259.49 $1,265.79 $1,272.12 $1,278.48 $1,284.87 $1,291.29 $1,297.75 $1,304.24 $1,310.76 $1,317.31 $1,323.90 $1,330.52 $1,337.17 $1,343.86 $1,350.58 $1,357.33 $1,364.12 $1,370.94 $1,377.79 $1,384.68 $1,391.61 $1,398.56 $1,405.56 $1,412.58 $1,419.65 $1,426.75 $1,433.88 $1,441.05 $1,448.25 $1,455.50 $1,462.77 $1,470.09 $1,477.44 $1,484.82 $1,492.25 $1,499.71
$412.08 $405.82 $399.52 $393.19 $386.83 $380.44 $374.01 $367.56 $361.07 $354.55 $347.99 $341.41 $334.79 $328.13 $321.45 $314.73 $307.98 $301.19 $294.37 $287.51 $280.63 $273.70 $266.74 $259.75 $252.72 $245.66 $238.56 $231.43 $224.26 $217.05 $209.81 $202.53 $195.22 $187.87 $180.48 $173.06 $165.60
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$81,163.35 $79,903.86 $78,638.07 $77,365.96 $76,087.48 $74,802.61 $73,511.31 $72,213.56 $70,909.32 $69,598.56 $68,281.25 $66,957.35 $65,626.83 $64,289.65 $62,945.79 $61,595.21 $60,237.88 $58,873.77 $57,502.83 $56,125.03 $54,740.35 $53,348.75 $51,950.18 $50,544.62 $49,132.04 $47,712.39 $46,285.65 $44,851.77 $43,410.72 $41,962.47 $40,506.97 $39,044.20 $37,574.11 $36,096.67 $34,611.85 $33,119.60 $31,619.89
$68,836.65 $70,096.14 $71,361.93 $72,634.04 $73,912.52 $75,197.39 $76,488.69 $77,786.44 $79,090.68 $80,401.44 $81,718.75 $83,042.65 $84,373.17 $85,710.35 $87,054.21 $88,404.79 $89,762.12 $91,126.23 $92,497.17 $93,874.97 $95,259.65 $96,651.25 $98,049.82 $99,455.38 $100,867.96 $102,287.61 $103,714.35 $105,148.23 $106,589.28 $108,037.53 $109,493.03 $110,955.80 $112,425.89 $113,903.33 $115,388.15 $116,880.40 $118,380.11
Page 3
34220259-29bb-4ca1-b571-b1d07069ad32.xls
May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13
9 9 9 9 9 9 9 9 10 10 10 10 10 10 10 10 10 10 10 10
5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12
101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
$31,619.89 $30,112.68 $28,597.94 $27,075.62 $25,545.69 $24,008.11 $22,462.85 $20,909.85 $19,349.10 $17,780.53 $16,204.13 $14,619.84 $13,027.63 $11,427.46 $9,819.29 $8,203.08 $6,578.79 $4,946.38 $3,305.80 $1,657.02
$1,507.21 $1,514.74 $1,522.32 $1,529.93 $1,537.58 $1,545.27 $1,552.99 $1,560.76 $1,568.56 $1,576.40 $1,584.29 $1,592.21 $1,600.17 $1,608.17 $1,616.21 $1,624.29 $1,632.41 $1,640.58 $1,648.78 $1,657.02
$158.10 $150.56 $142.99 $135.38 $127.73 $120.04 $112.31 $104.55 $96.75 $88.90 $81.02 $73.10 $65.14 $57.14 $49.10 $41.02 $32.89 $24.73 $16.53 $8.29
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$30,112.68 $28,597.94 $27,075.62 $25,545.69 $24,008.11 $22,462.85 $20,909.85 $19,349.10 $17,780.53 $16,204.13 $14,619.84 $13,027.63 $11,427.46 $9,819.29 $8,203.08 $6,578.79 $4,946.38 $3,305.80 $1,657.02 $0.00
$119,887.32 $121,402.06 $122,924.38 $124,454.31 $125,991.89 $127,537.15 $129,090.15 $130,650.90 $132,219.47 $133,795.87 $135,380.16 $136,972.37 $138,572.54 $140,180.71 $141,796.92 $143,421.21 $145,053.62 $146,694.20 $148,342.98 $150,000.00
Page 4
34220259-29bb-4ca1-b571-b1d07069ad32.xls
Accumulated Interest $750.00 $1,500.00 $2,245.42 $2,986.25 $3,722.45 $4,454.01 $5,180.89 $5,903.09 $6,620.57 $7,333.31 $8,041.29 $8,744.48 $9,442.86 $10,136.40 $10,825.09 $11,508.89 $12,187.79 $12,861.75 $13,530.76 $14,194.79 $14,853.81 $15,507.80 $16,156.73 $16,800.58 $17,439.32 $18,072.93
Accumulated Payments $1,665.31 $3,330.62 $4,995.92 $6,661.23 $8,326.54 $9,991.85 $11,657.15 $13,322.46 $14,987.77 $16,653.08 $18,318.38 $19,983.69 $21,649.00 $23,314.31 $24,979.61 $26,644.92 $28,310.23 $29,975.54 $31,640.84 $33,306.15 $34,971.46 $36,636.77 $38,302.07 $39,967.38 $41,632.69 $43,298.00
Page 5
34220259-29bb-4ca1-b571-b1d07069ad32.xls
$18,701.38 $19,324.65 $19,942.71 $20,555.53 $21,163.08 $21,765.35 $22,362.31 $22,953.92 $23,540.16 $24,121.01 $24,696.44 $25,266.41 $25,830.92 $26,389.91 $26,943.38 $27,491.28 $28,033.60 $28,570.30 $29,101.36 $29,626.75 $30,146.44 $30,660.40 $31,168.61 $31,671.03 $32,167.63 $32,658.39 $33,143.28 $33,622.27 $34,095.32 $34,562.42 $35,023.52 $35,478.60 $35,927.63 $36,370.58 $36,807.42 $37,238.11 $37,662.63
$44,963.30 $46,628.61 $48,293.92 $49,959.23 $51,624.53 $53,289.84 $54,955.15 $56,620.46 $58,285.76 $59,951.07 $61,616.38 $63,281.69 $64,946.99 $66,612.30 $68,277.61 $69,942.92 $71,608.22 $73,273.53 $74,938.84 $76,604.15 $78,269.45 $79,934.76 $81,600.07 $83,265.38 $84,930.68 $86,595.99 $88,261.30 $89,926.61 $91,591.91 $93,257.22 $94,922.53 $96,587.84 $98,253.14 $99,918.45 $101,583.76 $103,249.07 $104,914.37
Page 6
34220259-29bb-4ca1-b571-b1d07069ad32.xls
$38,080.95 $38,493.03 $38,898.85 $39,298.37 $39,691.56 $40,078.39 $40,458.83 $40,832.84 $41,200.40 $41,561.47 $41,916.01 $42,264.01 $42,605.41 $42,940.20 $43,268.33 $43,589.78 $43,904.51 $44,212.49 $44,513.68 $44,808.04 $45,095.56 $45,376.18 $45,649.89 $45,916.63 $46,176.38 $46,429.10 $46,674.76 $46,913.32 $47,144.75 $47,369.01 $47,586.07 $47,795.88 $47,998.41 $48,193.63 $48,381.50 $48,561.99 $48,735.05
$106,579.68 $108,244.99 $109,910.30 $111,575.60 $113,240.91 $114,906.22 $116,571.53 $118,236.83 $119,902.14 $121,567.45 $123,232.76 $124,898.06 $126,563.37 $128,228.68 $129,893.99 $131,559.29 $133,224.60 $134,889.91 $136,555.22 $138,220.52 $139,885.83 $141,551.14 $143,216.45 $144,881.76 $146,547.06 $148,212.37 $149,877.68 $151,542.99 $153,208.29 $154,873.60 $156,538.91 $158,204.22 $159,869.52 $161,534.83 $163,200.14 $164,865.45 $166,530.75
Page 7
34220259-29bb-4ca1-b571-b1d07069ad32.xls
$48,900.64 $49,058.74 $49,209.31 $49,352.30 $49,487.68 $49,615.40 $49,735.44 $49,847.76 $49,952.31 $50,049.05 $50,137.96 $50,218.98 $50,292.08 $50,357.21 $50,414.35 $50,463.45 $50,504.46 $50,537.36 $50,562.09 $50,578.62
$168,196.06 $169,861.37 $171,526.68 $173,191.98 $174,857.29 $176,522.60 $178,187.91 $179,853.21 $181,518.52 $183,183.83 $184,849.14 $186,514.44 $188,179.75 $189,845.06 $191,510.37 $193,175.67 $194,840.98 $196,506.29 $198,171.60 $199,836.90
Page 8