X

With the Income You Need to Buy a Median-Priced Home rising, you may need to Learn About Adjustable Rate Mortgages to preserve affordability.

With the Income You Need to Buy a Median-Priced Home rising, you may need to Learn About Adjustable Rate Mortgages to preserve affordability.

How do I create a custom amortization schedule?

Q: I need to create a custom amortization schedule for a $20,000 loan, 7% interest, first year monthly payment of $200, $300 per month thereafter. I need a complete schedule and final payoff date. Can you help?

A: HSH.com's Homebuyers Calculator Suite allows for complex amortization. You need to first change the term until you find a $200 per month payment (or close to it); in this case, it is about 150 months. Then, you'll start prepaying the loan by an additional $100 per month starting in month 13. That chops the total term down to 91 months, with a total interest cost of just over $6,000 for the term. You should download a copy of the calculator so that you can create and print the schedule you need.

Ask the expert
Keith Gumbinger
Keith Gumbinger
Mortgage Expert
Vice President, HSH.com
About Keith: Mortgage market observer and analyst with 35 years experience... (more)
Please enter a question.
Please enter name.
Please enter email.
Captcha code invalid
Q: Can I use an equity loan to pay off my mortgage?
JUN 22, 2022
A:

My home is valued at $195,000. I owe $127,000 on the mortgage. I want a 10 year equity loan to pay off the mortgage. Can I find lenders to do this? Certainly! However...

Read More
Q: What is a mortgage insurance premium? Do I need this?
APR 07, 2022
A:

In general, this will be the cost you must pay for a policy which helps to protect your lender.

Read More
Q: Will biweekly mortgage payments save me money?
MAR 23, 2022
A:

Making biweekly mortgage payments will cut your interest cost and shorten the term of your loan.

Read More
Add to Homescreen?
X
X
Install this web app on your phone :tap and then Add to homescreen