Keeping a Personal Mortgage Calculator

by 55+ Active Adult Community -Founders' Ridge 09/29/2019

If the nerd in you comes out as soon as someone starts talking numbers, you might find yourself wondering how hard it is to create a mortgage calculator. Technically called an amortization calculator, the numbers you put into the calculation tell you what your payment each month breaks down to in terms of what goes to the principal (the amount to pay down your loan) and interest (the money the lender makes for loaning you the money).

Getting set up

You can download a spreadsheet to fill in for Excel or Numbers. If you don’t use Excel or Numbers, you can create one in Google sheets (a free online spreadsheet program with a Google account). You will also need a few numbers to set up your amortization schedule.

  • The loan amount. This is the amount you intend to borrow. So, in general, it will be the amount of the sales price of the home minus the down payment. It might include some of the closing costs or points, or other amounts so bear that in mind and adjust your calculator once you get the final numbers at closing.
  • The annual interest rate. For a fixed-interest mortgage, this amount will remain the same throughout the life of the loan. For a variable interest or adjustable loan, each time the rate changes, you should set up a new table going forward.
  • The loan period. Usually, you calculate this in years, so even if your loan is for a partial year, express it in decimals. So, fifteen years and six months would be 15.5.
  • The number of payments per year. Usually, this number is 12 since you make payments every month. In rare cases or for particular types of loans, it could be 4 for quarterly payments or even one if you only pay one time each year.
  • You also need the start date of the loan. Typically, loan calculators assume that the first payment is due at the beginning of the next month after the start date.
  • Optional extra payments. Some calculators also have a formula for voluntary additional payments. For example, if you want to pay off your mortgage to coincide with your retirement, you could try various additional payments until the loan zeros out on that date. That way, you would know exactly how much extra to pay each month to achieve your goals.

These calculators do not account for taxes and insurance since those numbers are subject to change even though you pay them with your monthly payment. If you have questions about how to use a mortgage calculator or how to figure out what your payments might be, speak with your lender for a detailed explanation.

About the Author
Author

55+ Active Adult Community -Founders' Ridge

Set on a picturesque hill and centrally located in the desirable Westfield Section of Middletown, Founders’ Ridge is a New 55+ Condominium Community of up to 75 Ranch and Cape Style detached homes.  Named for the Founding Fathers and Mothers of Middletown, each model bears the name of one of our town’s founders – The Allen, The Martin, The Cornwell, and The Whitmore to name a few. 


Attractively priced from $289,900.00, our homes range from approximately 1200 Sq. Ft. to 2250 Sq. Ft.  Our models offer 2 – 4 bedrooms, attached 2 car garages, natural gas heat and AC, city water and sewer and all underground utilities.  Standard features include wood kitchens with granite tops, stainless steel appliances, tiled laundry and baths, hardwood in living areas, paver patios or decks, paved driveways and professional landscaping.
Founders’ Ridge offers a unique agreement with adjacent Ascentria Care’s Luther Ridge, private apartment living for residents age 62+.  Residents of our community have access to meeting and game rooms, and even dining opportunities (for a small fee) all of which are accessed via quiet, peaceful walking trials connecting both communities.


Centrally located on the Connecticut River, the City of Middletown boasts amenities for any lifestyle.  Residents may take advantage of The Institute for Lifelong Learning at Wesleyan University as well as various other university community activities.  The active Middlesex Historical Society offers additional programs such as museum exhibits, walking tours, and re-enactments among its many events.  Wadsworth Mansion offers a summer concert series and our river and parks offer a wonderful opportunity to explore the outdoors.  Also located in the downtown area is Middlesex Hospital, affiliated with the world-renowned Mayo Clinic, Middlesex offers quality medical care and world class technology.  


We would be remiss if we did not mention our thriving Main Street, famous for award winning cuisine at over 30 restaurant locations, and a Downtown Business District boasting over 40 shops for unique purchases and window shopping and a calendar full of events, performances and more.  Don’t forget about the newly opened RJ Julia & Wesleyan Bookstore alive with frequent happenings and book signings by famous authors.  Our community truly offers something for everyone!