X

The Fed didn't make a move at the March meeting, but what the Fed had to say about future policy has implications for mortgage rates.

The Fed didn't make a move at the March meeting, but what the Fed had to say about future policy has 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: How do I find out who owns my mortgage?
FEB 20, 2024
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
Q: What loan amount does a mortgage need to be for it to be considered a Jumbo Loan?
NOV 28, 2023
A:

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

Read More
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
Add to Homescreen?
X
X
Install this web app on your phone :tap and then Add to homescreen