X

The Fed made no move at its September meeting, but you'll want to read what the Fed said about future policy and implications for mortgage rates.

The Fed made no move at its September meeting, but you'll want to read what the Fed said about future policy and implications for mortgage rates.

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: What does the term ‘conforming’ mean?
SEP 21, 2023
A:

Simply put, a "conforming" mortgage "conforms" to a set of standards so that the loan can be eligible to be sold to Fannie Mae or Freddie Mac.

Read More
Q: Can you recommend a company specializing in mortgage modifications?
AUG 29, 2023
A:

No, we're not in a position to do that, but you should be careful when reviewing offers that haven't come from your mortgage servicer.

Read More
Q: How are mortgage interest rates determined?
APR 25, 2023
A:

Mortgage rates fluctuate from day to day, depending on a number of factors related to the economy and to choices made by investors. While some mortgage money comes from deposits held by banks and credit unions, most of the funds for borrowers come from investors in capital markets.

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