X

Wondering if the income needed to buy a home in the top 50 metro areas is starting to decline? Hint: Not yet.

Wondering if the income needed to buy a home in the top 50 metro areas is starting to decline? Hint: Not yet.

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: Should we pay off our mortgage?
OCT 04, 2022
A:

Whether you should pay off your mortgage or not sounds like a simple problem with an easy answer... but it's not.

Read More
Q: How are mortgage interest rates determined?
AUG 18, 2022
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
Q: Will today's stock market influence tomorrow's mortgage rates?
AUG 16, 2022
A:

Mortgage rates are influenced by a variety of factors, rather than moving in lockstep with any one economic indicator. The stock market rises and falls for a wide variety of reasons, including global, economic and political issues, but as a broad rule of thumb, a rising stock market indicates optimism among investors about the economy.

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