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: How many times can I use my VA home loan?
OCT 31, 2019
A:

There are three ways you can restore your VA eligibility so that you can take advantage of it more than once.

Read More
Q: Can my lender ask me why I'm buying a specific home?
NOV 06, 2018
A:

Lenders can ask you why you are buying a specific home because there are different lending rules for different types of properties.

Read More
Q: Does the VA allow "asset depletion" mortgages?
SEP 20, 2018
A:

Can you use private-sector retirement income and savings to help qualify for a VA-backed mortgage?

Read More