X

Last market hits the finish line! A final update for HSH's Home Price Recovery Index.

Last market hits the finish line! A final update for HSH's Home Price Recovery Index.

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)
Submitting your question...

Question received! Check back later to see if your
question gets published.

Q: Can my friends and I buy a house together?
JUL 18, 2021
A:

The answer is "yes," you can certainly all buy a house together.

Read More
Q: What is the difference between "rate" and "APR"?
APR 26, 2021
A:

APR is perhaps the most misunderstood part of mortgage finance. "Rate", or more properly "contract interest rate" is the actual rate of interest you are being charged...

Read More
Q: How do I find out who owns my mortgage?
MAR 15, 2021
A:

The owner of the loan is most often the "investor" -- the entity who put up the actual funds to make your mortgage happen.

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