X

What's coming up next year for mortgage rates... the Fed... housing markets... home prices? See HSH's 2022 Outlook for our expectations!

What's coming up next year for mortgage rates... the Fed... housing markets... home prices? See HSH's 2022 Outlook for our expectations!

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: What loan amount does a mortgage need to be for it to be considered a Jumbo Loan?
JAN 03, 2022
A:

This question used to have a simple answer, since there was a "bright line" definition -- the conforming loan limit....

Read More
Q: What is the cost of getting a mortgage loan?
NOV 11, 2021
A:

 Costs and fees can vary depending upon lender policies and certain of the choices you make when you get your loan...

Read More
Q: What is the down payment required to get a mortgage these days?
NOV 03, 2021
A:

A: While some 100% financing may be available...

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