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:'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,
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

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

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

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

Read More