A Mortgage Case Study

In speaking with clients this morning, they lamented the situation of their son who is, like many people, dealing with a substantial drop in value of his primary residence. To compound their worry, they gave him a gift when he purchased the house so he would have more than a reasonable down payment. In the succeeding few years, he has made his mortgage payments, but because he has had a drop in income, his housing expenses currently take up in excess of 50% of his income. The remaining mortgage is greater than the fair market value, and short of trying to do a “short sale,” the prospects for selling the home in the near term are dim.

There are a couple of morals to this story.

First,

as we have previously discussed, it is our opinion that your mortgage payment should represent no more than 25-28% of your gross income.

Second,

under few circumstances should you get anything other than a fixed rate mortgage?  If you are purchasing a home and can guarantee that you will be moving within the interest rate guarantee period, I can see the use of a variable rate loan. Currently, that would be the only exception.

Do not be bashful in dealing with a mortgage broker or lending institution. Ask questions and make sure you receive answers to your satisfaction. There are lending and disclosure forms that you are obliged to receive. Even though they may be in your possession does not necessarily mean you understand them. Until you do, do not sign anything, and if you follow the two rules listed above, you will not be in the same predicament as the young man described above, but will be in a loan which fits your particular financial condition.

Before you commit

to any mortgage it is important to have a complete understanding of how a mortgage amortization works. definition In the tables below you will see how a $100,000 mortgage is amortized monthly over a fifteen, twenty, and thirty year period.

Amortization Table

Amortization Table for $100,000.00 loan at 7.00% interest for a period of 15 years.
Monthly mortgage payments are $898.83
Total interest paid over the life of the loan is $61,789.09
YEARLOAN BALANCEYEARLY INTEREST PAIDYEARLY PRINCIPAL PAIDTOTAL INTEREST PAID
197,423.904,614.53 2,576.104,614.53
293,327.886,689.92 4,096.0211,304.45
388,935.756,393.81 4,392.1317,698.26
484,226.126,076.31 4,709.6323,774.56
579,176.035,735.85 5,050.0929,510.41
673,760.865,370.77 5,415.1634,881.19
767,954.244,979.31 5,806.6339,860.50
861,727.854,559.55 6,226.3944,420.05
955,051.354,109.44 6,676.4948,529.49
1047,892.213,626.80 7,159.1452,156.29
1140,215.543,109.27 7,676.6755,265.66
1231,983.922,554.32 8,231.6257,819.88
1323,157.231,959.25 8,826.6959,779.13
1413,692.461,321.17 9,464.7761,100.30
15 3,543.49 636.9610,148.9861,737.26
16 0.00 51.83 3,543.4961,789.09

Amortization Table

Amortization Table for $100,000.00 loan at 7.00% interest for a period of 20 years. Monthly mortgage payments are $775.30. Total interest paid over the life of the loan is $86,071.74.
YearLoan BalanceYearly Interest PaidYearly Interest PaidTotal Interest Paid
198,432.554,634.941,567.454,634.94
295,940.296,811.332,492.2611,446.27
393,267.866,631.162,672.4318,077.43
490,402.256,437.972,865.6224,515.40
587,329.486,230.813,072.7730,746.22
684,037.576,008.683,294.9036,754.90
780,501.485,770.503,533.0942,525.39
876,712.985,515.093,788.5048,040.48
972,650.615,241.224,062.3753,281.70
1068,294.57`4,947.554,356.0458,229.25
1163,623.634,632.654,670.9462,861.90
1258,615.034,294.995,008.6067,156.88
1353,244.363,932.915,370.6771,089.80
1447,485.443,544.675,758.9274,634.46
1541,310.213,128.366,175.2377,762.82
1634,688.572,681.956,621.6480,444.77
1727,588.252,203.277,100.3282,648.04
1819,974.651,689.997,613.6084,338.02
1911,810.661,139.608,163.9985,477.62
203,056.49 549.428,754.1686,027.04
21 0.00 44.703,056.4986.071.74

Amortization Table

Amortization Table for $100,000.00 loan at 7.00% interest for a period of 30 years.
Monthly mortgage payments are $665.30
Total interest paid over the life of the loan is $139,508.90
YearLoan BalanceYearly Interest PaidYearly Principal PaidTotal Interest Paid
199,330.704,653.12 669.30 4,653.12
298,266.516,919.441,064.19 11,572.56
397,125.386,842.511,141.12 18,415.06
495,901.776,760.011,223.62 25,175.08
594,589.706,671.561,312.07 31,846.64
693,182.776,576.711.406.92 38,423.34
791,674.156,475.001,508.63 44,898.35
890,056.466,365.941,617.69 51,264.29
988,321.836,249.001,734.63 57,513.29
1086,461.816,123.601,860.03 63,636.90
1184,467.325,989.141,994.49 69,626.04
1282,238.655,844.962,138.67 75,471.00
1380,035.385,690.362,293.27 81,161.36
1477,576.325,524.582,459.05 86,685.93
1574,939.505,346.812,636.82 92,032.74
1672,112.075,156.192,827.44 97,188.94
1769,080.244,951.803,031.83102,140.74
1865,829.244,732.633,251.00106,873.37
1962,343.224,497.613,486.02111,370.98
2058,605.204,245.613,738.02115,616.59
2154,596.953,975.394,008.24119,591.97
2250,298.963,685.634,298.00123,277.60
2345,690.253,374.934,608.70126,652.53
2440,748.393,041.764,941.87129,694.30
2535,449.272,684.525,299.11132,378.81
2629,767.092,301.445,682.19134,680.26
2723,674.131,890.686,092.95136,570.93
2817,140.721,450.226,533.41138,021.15
2910,135.01 977.927,005.71138,999.07
30 2,622.85 471.477,512.16139,470.54
31 0.00 38.362,622.85139,508.90

This entry was posted in Money Management. Bookmark the permalink.