X

It's a question almost everyone is asking: "Should I refinance my mortgage?" If so, what's the best way to pay for my mortgage refinance

It's a question almost everyone is asking: "Should I refinance my mortgage?" If so, what's the best way to pay for my mortgage refinance

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: Can I get forbearance for my mortgage?
MAY 19, 2020
A:

The answer is "possibly." It depends on the situation.

Read More
Q: Is mortgage insurance tax deductible?
JAN 08, 2020
A:

Tax deductibility for PMI premiums or MI premiums for FHA loans has been an on-again, off-again kind of thing. For 2019 and 2020, it's back on.

Read More
Q: How many times can I use my VA home loan?
OCT 31, 2019
A:

There are three ways you can restore your VA eligibility so that you can take advantage of it more than once.

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