UnThreaded | Threaded | Whole Thread (11) | Ignore Thread Prev Thread | Next Thread
Author: PaintItBlue Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 127815  
Subject: mortgage calculator? Date: 2/22/2014 10:49 AM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 0
Are there calculators on here that can tell me what I want to figure out?

I got a house 7 years ago. I'm happy with it, though it sure would be nice if I could take advantage of the lower interest rates. And I never intended to take 30 years to pay it off, in fact I've thought of paying the mortgage off before retirement. (I have a 30 year fixed rate mortgage at 6.15%.) Unfortunately with the crash, home prices dropped, & I haven't been getting anywhere with refinancing.

So what I have been doing is paying extra on principal every month.

What I'm wondering is:

How long would it take for the mortgage to be paid off if I kept going the way I am now?

What would I have to do to pay it off in 10 years? In 15?
Print the post Back To Top
Author: pauleckler Big funky green star, 20000 posts Top Favorite Fools Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126831 of 127815
Subject: Re: mortgage calculator? Date: 2/22/2014 12:12 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 1
This is an easy calculation to set up in a spreadsheet program like Excell or even on line on the Google spreadsheet.

You start out with your outstanding balance, and then deduct payment minus interest from principle each month. Then recalculate interest due the following month on the reduced outstanding balance.

You can also set up a column to count months or even set up calendar months and years.

Once you do two rows of calcs you can copy down to make it easy. 358 months for a 30 yr mortgage. If you increase the amount paid each month you can see how much sooner the outstanding balance goes to zero.

Print the post Back To Top
Author: Rayvt Big gold star, 5000 posts Top Favorite Fools Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126832 of 127815
Subject: Re: mortgage calculator? Date: 2/22/2014 1:03 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 0
http://www.dinkytown.net/java/MortgagePayoff.html

Print the post Back To Top
Author: PaintItBlue Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126833 of 127815
Subject: Re: mortgage calculator? Date: 2/22/2014 7:36 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 0
This looks like a good project for learning to set up a spreadsheet.

Print the post Back To Top
Author: PaintItBlue Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126834 of 127815
Subject: Re: mortgage calculator? Date: 2/22/2014 7:46 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 1
Thanks! I can get a general idea of what is happening here. I think I need to increase the extra payment on principal and/or try again to refinance if I am going to pay off a 30 year mortgage in 17-20 years.

(And maybe I need to get Excel on this computer and learn to do spreadsheets.)

Print the post Back To Top
Author: PaintItBlue Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126836 of 127815
Subject: Re: mortgage calculator? Date: 2/22/2014 8:29 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 1
The problem I was hearing is that I was underwater on the mortgage, or close to it. This resulted from bad timing buying the house with 3% down, in a state where the economy rebounded sluggishly. As far as I know, my FICO score is good. No debt except the mortgage (unless you count the credit card which I usually pay off every month.)

I've fixed the place up some & done some work on the landscaping. Maybe this spring I'll be able to get a better deal.

Print the post Back To Top
Author: aj485 Big gold star, 5000 posts Feste Award Nominee! Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126837 of 127815
Subject: Re: mortgage calculator? Date: 2/22/2014 8:47 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 2
The problem I was hearing is that I was underwater on the mortgage, or close to it. This resulted from bad timing buying the house with 3% down, in a state where the economy rebounded sluggishly.

If you only put down 3%, that suggests that you got an FHA mortgage. If that's the case, have you looked into an FHA streamline refinance? https://www.fha.com/fha_article?id=27 This type of refinance doesn't require an appraisal. You will probably have to come up with some money for closing costs, as closing costs aren't allowed to be rolled into an FHA streamline loan, although if you are willing to take a higher rate, the lender may be able to pay for the closing costs.

AJ

Print the post Back To Top
Author: PaintItBlue Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126838 of 127815
Subject: Re: mortgage calculator? Date: 2/22/2014 10:58 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 0
It was a state program. From what I can tell, we're on our own.

Print the post Back To Top
Author: Bimmer325 Two stars, 250 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126840 of 127815
Subject: Re: mortgage calculator? Date: 2/23/2014 10:20 AM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 1
Ditto, Kahuna. It's easily among the best tools I've ever purchased.

Print the post Back To Top
Author: PaintItBlue Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126842 of 127815
Subject: Re: mortgage calculator? Date: 2/23/2014 2:56 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 1
That figures.

Do you think it will matter that the house next door is empty and really needs some work on the roof? At least people have been working on the interior & it is no longer boarded up, but there are no tenants yet. I hesitated to do anything that would cause people to drive by here & notice that I was living next door to a board-up. Didn't want the insurance people to freak out.

Print the post Back To Top
Author: CCinOC Big funky green star, 20000 posts Top Recommended Fools Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: 126850 of 127815
Subject: Re: mortgage calculator? Date: 2/27/2014 2:53 AM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Recommendations: 3
Here's a passel of mortgage calculators.

http://www.mtgprofessor.com/calculators.htm

Print the post Back To Top
UnThreaded | Threaded | Whole Thread (11) | Ignore Thread Prev Thread | Next Thread
Advertisement