The mortgage lending industry is much in the news right now, and has been for a couple of years. But I suspect that many of us haven’t sat down to study mortgages closely. For a while, our inboxes were filled with mortgage refinancing offers. And many of us engaged in serial refinancings, some taking out cash, some simply to lower their rate. Those who are comfortable with a spreadsheet can noodle the numbers with relative ease. But I thought I’d present some data from my own spreadsheet analyses.

This is the first of a series. It looks at simple 30 year fixed rate mortgages.

I’ve compared a range of rates, from 4.0% to 7.0%. This range may seem quite ordinary to those in the market in the past few years, but are quite a bit below what home buyers were paying in the early 1980s. My examples here will work with 4%, 5%, 6% and 7%. I’ve assumed principal of $100,000 and a 30 year fixed rate mortgage; if typical mortgages in your neighborhood are higher, simply multiply all by whichever whole number seems best.

  1. Monthly Principal and Interest Payment per $100,000 of principal:
  • At 4%, $477
  • At 5%, $537
  • At 6%, $600
  • At 7%, $665
  1. Allocation of first payment:
  • At 4%, 30% of one’s first mortgage payment is principal, 70% is interest. ($144 principal and $333 interest)
  • At 5%, 22% is principal, 78% is interest. ($120 and $417)
  • At 6%, 17% is principal, 83% is interest. ($100 and $500)
  • At 7%, 12% is principal, 88% is interest. ($ 82 and $583)
  1. Allocation of the 12th payment:
  • At 4%, 31% of the 12th monthly payment is principal, 69% is interest
  • At 5%, 23% of the 12th monthly payment is principal, 77% is interest
  • At 6%, 17% of the 12th monthly payment is principal, 83% is interest
  • At 7%, 13% of the 12th monthly payment is principal, 87% is interest
  1. At the end of 1 year,
  • At 4%, you’ve paid off 1.8% of the principal
  • At 5%, you’ve paid off 1.5% of the principal
  • At 6%, you’ve paid off 1.2% of the principal
  • At 7%, you’ve paid off 1.0% of the principal
  1. At the end of 1 year, for each $100,000 borrowed, you’ve paid interest of
  • At 4%, $3,968
  • At 5%, $4,966
  • At 6%, $5,967
  • At 7%, $6,968
  1. At the end of 3 years,
  • At 4%, you’ve paid off 5.5% of the principal
  • At 5%, you’ve paid off 4.7% of the principal
  • At 6%, you’ve paid off 3.9% of the principal
  • At 7%, you’ve paid off 3.3% of the principal
  1. Allocation of the 36th payment:
  • At 4%, 33% of the 36th monthly payment is principal, 66% is interest
  • At 5%, 26% of the 36th monthly payment is principal, 74% is interest
  • At 6%, 20% of the 36th monthly payment is principal, 80% is interest
  • At 7%, 15% of the 36th monthly payment is principal, 85% is interest
  1. At the end of 3 years,
  • At 4%, you’ve paid interest of $11,686 and built your equity by $5,501
  • At 5%, you’ve paid interest of $14,669 and built your equity by $4,656
  • At 6%, you’ve paid interest of $17,668 and built your equity by $3,916
  • At 7%, you’ve paid interest of $20,678 and built your equity by $3,273
  1. At the end of 5 years, on that $100,000 mortgage
  • At 4%, you’ve paid down the mortgage by $9,552 and paid interest of $19,092
  • At 5%, you’ve paid down the mortgage by $8,171 and paid interest of $24,038
  • At 6%, you’ve paid down the mortgage by $6,946 and paid interest of $29,027
  • At 7%, you’ve paid down the mortgage by $5,868 and paid interest of $34,050
  1. Allocation of the 60th payment:
  • At 4%, 37% of the 60th monthly payment is principal, 63% is interest
  • At 5%, 29% of the 60th monthly payment is principal, 71% is interest
  • At 6%, 22% of the 60th monthly payment is principal, 78% is interest
  • At 7%, 17% of the 60th monthly payment is principal, 83% is interest
  1. After 10 years,
  • At 4%, you’ve paid down the mortgage by $21,216 and paid interest of $36,074
  • At 5%, you’ve paid down the mortgage by $18,658 and paid interest of $45,761
  • At 6%, you’ve paid down the mortgage by $16,314 and paid interest of $55,632
  • At 7%, you’ve paid down the mortgage by $14,188 and paid interest of $65,649
  1. Allocation of the 120th payment:
  • At 4%, 45% of the 120th payment is principal, 55% is interest
  • At 5%, 37% of the 120th payment is principal, 63% is interest
  • At 6%, 30% of the 120th payment is principal, 70% is interest
  • At 7%, 25% of the 120th payment is principal, 75% is interest