1

11 years into a 30-year mortgage

Submitted by Julie Rains on September 17, 2007 - 10:25.

If you are designing an amortization schedule and then want to see how additional money on the principal will affect your payoff, then you need to use (or download) a 30-year mortgage schedule (not a 21-year or 19-year schedule as the calculations wouldn't work correctly using this method) and then go to year 11 to see where you are in your payoff and what you can do to accelerate the payoff if that is your goal. You can download this schedule (http://www.wisebread.com/files/fruganomics/DIY_acceleration.xls), replace $153,000 with $200,000 and replace the 6% with 7%. You'll also need to refigure the payment amount (I should have designed the spreadsheet a bit better; but the formula for you should use is =PMT(7%/12,360,-153000,0,0) which will equal $1017.91 (principal and interest only, I haven't included escrow amounts for property taxes). If you are in year 11, your balance should be between $125K and $128K. So, starting there (say in month 132), you can add principal amounts to the monthly payment. If you made an extra payment of $1000 in month 132, you'd pay the loan off three months early.

Let me know if you have more questions or if you need some validation of the numbers.

 

Reply

Please keep the comments civil and on-topic. Abusive or inappropriate comments will be removed without warning. By posting here you agree to our terms of use.

The content of this field is kept private and will not be shown publicly.
If you leave a link (include the http:// part), your name will be linked to your homepage.

You may use some HTML for formatting: <strong>bold text</strong>, <em>italics</em>, and <a href="">for links</a>. Empty lines are automatically converted to paragraph breaks.

Or click the link above that says 'enable rich-text' to use the fancy editor.

Captcha
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
1 + 6 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Have more to say? Join the discussions at Wise Bread's Finance and Frugality Forums.

Finance Blogs - Blog Top Sites