Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    QM
    QM is offline
    Registered User QM's Avatar
    Join Date
    Oct 2008
    Location
    Canada
    Posts
    4,312
    Post Thanks / WTG / Hug
    Rep Power
    28

    Default My Bank is FRUSTRATING...Who is good with numbers...I need help...

    I'm hoping somebody can help me with some calculations. What I want to know is based on the information I have, how much I'd have to pay towards my mortgage to pay off one year. I know that the amount will change as it gets closer to getting paid off, but...can somebody please help me?...I'm so confused, and the bank didn't help me at all.

    Principal Balance is $125,883.69
    Interest Rate 4.9900%
    Remaining Amortization 15 year(s), 6 month(s)

    What other information do you need to figure this out? TIA for your help.
    An obstacle is what comes up when you lose sight of your goal.

    Daily Fix It, Sort It, or Clean It Challenge

    May No-Spend: 9/12 "A penny saved is a penny earned!"
    1 (), 2 (), 3 (), 4 (), 5 (), 6 (), 7 (), 8 (), 9 (), 10 (), 11 (), 12 (), 13 (), 14 (), 15 (), 16 (), 17 (), 18 (), 19 (), 20 (), 21 (), 22 (), 23 (), 24 (), 25 (), 26 (), 27 (), 28 (), 29 (), 30 (), 31 ()

    2012 Lose-A-Pound-A-Week Challenge
    I have 8.2 lbs to lose (as of Mon, May 28th, 2012)

    Personal
    Pay off my Morgage
    $101,927.57 (as of May 28th, 2012 - 10 years, 0 months left...partly because we got a new interest rate )/$108,631.38 (as of Dec. 3rd, 2011 - 12 years, 7 months left)
    Pay off my Line of Credit
    $6,977.26 (as of May 28th, 2012)/$17,790.73 (as of Dec. 3rd, 2011)

  2. #2
    Registered User mombottoo's Avatar
    Join Date
    Feb 2008
    Location
    Michigan
    Age
    53
    Posts
    1,770
    Post Thanks / WTG / Hug
    Rep Power
    13

    Default

    Take your principle balance, multiply that # by your interest rate, divide the answer by 12. Take that answer and subtract it from your mortgage payment (not including the taxes/insurance part if you have those escrowed)...the total you now have is your principle payment for that month. Subtract the principle payment from your mortgage balance. If you want to know how much you will have paid off the principle in one future year you need to repeat all the steps 12 times.

    To make it easier to track, get a piece of paper make 4 columns. Column 1= Mortgage Pymt., Column 2= Interest pymt., Column 3= Principle pymt and Column 4= Mortgage balance.

    I'd do it for you, but doing an amortization schedule takes some time, you can do it if you follow the steps I have laid out.
    "Life is what happens while you are busy making other plans." John Lennon
    "Infinite goodness has wide arms." Dante

    Change & Penny Challenges:
    Penny : $22.07
    Change : $97.70
    $ bills : $22.00


    Grocery Challenge:
    Grocery $400 per month: $0/$400 March
    Running Total (updated monthly): $751.73

    Savings Challenge:

    $100.36/$3,000 to replenish BEF

    2012 Coupon Savings Challenge:
    : YTD: $308.41

    2012 Fling Challenge: 691/2012
    20 Wishes Challenge: 2/20
    2012 Sell Stuff Challenge: /60

  3. #3
    QM
    QM is offline
    Registered User QM's Avatar
    Join Date
    Oct 2008
    Location
    Canada
    Posts
    4,312
    Post Thanks / WTG / Hug
    Rep Power
    28

    Default

    Quote Originally Posted by mombottoo View Post
    Take your principle balance, multiply that # by your interest rate, divide the answer by 12. Take that answer and subtract it from your mortgage payment (not including the taxes/insurance part if you have those escrowed)...the total you now have is your principle payment for that month. Subtract the principle payment from your mortgage balance. If you want to know how much you will have paid off the principle in one future year you need to repeat all the steps 12 times...
    OK...I'm still confuzzled. This is what I've got, and I don't think the numbers are working.

    Principle balance $125,883.69 times Interest Rate 4.99% = 6281.596
    6281.596 divided by 12 = 523.466

    This is where it gets confusing. My mortgage payment (including the principal and interest) is $446.48.

    So what do I do? Subtract 523.466-446.48? That equals $76.986

    Where does that leave me? Is it $76.986 per month that is the principal (not including the interest)? If I paid that off it's one month off my mortgage? Is that right?

    Then if I want to see what the next month is I subtract $76.986 from $125,883.69 and start over again?
    An obstacle is what comes up when you lose sight of your goal.

    Daily Fix It, Sort It, or Clean It Challenge

    May No-Spend: 9/12 "A penny saved is a penny earned!"
    1 (), 2 (), 3 (), 4 (), 5 (), 6 (), 7 (), 8 (), 9 (), 10 (), 11 (), 12 (), 13 (), 14 (), 15 (), 16 (), 17 (), 18 (), 19 (), 20 (), 21 (), 22 (), 23 (), 24 (), 25 (), 26 (), 27 (), 28 (), 29 (), 30 (), 31 ()

    2012 Lose-A-Pound-A-Week Challenge
    I have 8.2 lbs to lose (as of Mon, May 28th, 2012)

    Personal
    Pay off my Morgage
    $101,927.57 (as of May 28th, 2012 - 10 years, 0 months left...partly because we got a new interest rate )/$108,631.38 (as of Dec. 3rd, 2011 - 12 years, 7 months left)
    Pay off my Line of Credit
    $6,977.26 (as of May 28th, 2012)/$17,790.73 (as of Dec. 3rd, 2011)

  4. #4
    Registered User
    Join Date
    Dec 2008
    Posts
    2,224
    Post Thanks / WTG / Hug
    Rep Power
    20

    Default

    Hi,

    I'm very good with this. An estimate of how much you would need to pay off 1 year of your mortgage is $5607.94. To get the exact amount and if you want to e-mail me the info I will figure it out for you. I have a computer program that does that. You need to find out exactly how much your mortgage was to start with and how many years and put the information at the website bankrate.com. It will tell you exactly where you are on your mortgage and all you have to do is add up the principle for the next 12 payments. Hope this helps

    That $5607.94 is not making payments that would be paying off that much right now.
    Last edited by craftypam; 06-15-2009 at 09:22 PM.

  5. #5
    Registered User Landscape25's Avatar
    Join Date
    Mar 2009
    Posts
    54
    Post Thanks / WTG / Hug
    Rep Power
    4

    Default

    http://www.bankrate.com/calculators/...alculator.aspx

    Sorry Crafty Pam, I didn't see you suggested that
    Last edited by Landscape25; 06-15-2009 at 09:25 PM.

  6. #6
    QM
    QM is offline
    Registered User QM's Avatar
    Join Date
    Oct 2008
    Location
    Canada
    Posts
    4,312
    Post Thanks / WTG / Hug
    Rep Power
    28

    Default

    Quote Originally Posted by craftypam View Post
    ...I'm very good with this. An estimate of how much you would need to pay off 1 year of your mortgage is $5607.94...
    How did you get this amount? I typed my information into the website and didn't get this. Maybe I'm doing something wrong.
    An obstacle is what comes up when you lose sight of your goal.

    Daily Fix It, Sort It, or Clean It Challenge

    May No-Spend: 9/12 "A penny saved is a penny earned!"
    1 (), 2 (), 3 (), 4 (), 5 (), 6 (), 7 (), 8 (), 9 (), 10 (), 11 (), 12 (), 13 (), 14 (), 15 (), 16 (), 17 (), 18 (), 19 (), 20 (), 21 (), 22 (), 23 (), 24 (), 25 (), 26 (), 27 (), 28 (), 29 (), 30 (), 31 ()

    2012 Lose-A-Pound-A-Week Challenge
    I have 8.2 lbs to lose (as of Mon, May 28th, 2012)

    Personal
    Pay off my Morgage
    $101,927.57 (as of May 28th, 2012 - 10 years, 0 months left...partly because we got a new interest rate )/$108,631.38 (as of Dec. 3rd, 2011 - 12 years, 7 months left)
    Pay off my Line of Credit
    $6,977.26 (as of May 28th, 2012)/$17,790.73 (as of Dec. 3rd, 2011)

  7. #7
    Registered User
    Join Date
    Dec 2008
    Posts
    2,224
    Post Thanks / WTG / Hug
    Rep Power
    20

    Default

    Quote Originally Posted by Quiltin' Mama View Post
    How did you get this amount? I typed my information into the website and didn't get this. Maybe I'm doing something wrong.
    I have an amortization program in my computer. I typed in the information you gave me. It asks for amount, then interest rate, then amount of months. Then I added up all of the principle payments. If you payoff that amount you will only owe principle payments, no interest.

  8. #8
    Registered User frugalwarrior's Avatar
    Join Date
    Aug 2006
    Posts
    1,607
    Post Thanks / WTG / Hug
    Blog Entries
    173
    Rep Power
    19

    Default

    Quiltin' mama crown ministries has all kinds of calculators on the sight. It is a .org

  9. #9
    Registered User
    Join Date
    Dec 2008
    Posts
    2,224
    Post Thanks / WTG / Hug
    Rep Power
    20

    Default

    I see why you are having a problem. My program tells you what each payment is from 1-30 or 1-15 years. It also tells you for payment 1, principle and interest all the way to payment 180 or 360. If you are not getting what you want at your bank go to the mgr. Ask for amortization of your specific loan and that should give you the exact information. If you have been making your exact payment it will tell you what you owe now. If you have been making extra payments. You would go to the amount you owe now and it will tell you where you are at with your mortgage.

  10. #10
    Registered User
    Join Date
    Dec 2008
    Posts
    2,224
    Post Thanks / WTG / Hug
    Rep Power
    20

    Default

    Quilting mama; I've got it for you!!!!! Go to interest.com. Click on calculators; then fixed rate or interest only mortgage; fill in information where it says fixed mortgage. Would be better if you type in info when you got your mortgage. How much you borrowed; how many years; and at what interest rate. It will be more accurate since less is paid off in the beginning. Under the graph click schedule by month; then calculate; then view report Scroll down It will tell you the same information that I was telling you that my program has.

  11. #11
    QM
    QM is offline
    Registered User QM's Avatar
    Join Date
    Oct 2008
    Location
    Canada
    Posts
    4,312
    Post Thanks / WTG / Hug
    Rep Power
    28

    Default

    Quote Originally Posted by craftypam View Post
    ...If you are not getting what you want at your bank go to the mgr. Ask for amortization of your specific loan and that should give you the exact information...
    I think this is what I should do. My mind is spinning with numbers as I try to figure it out.
    An obstacle is what comes up when you lose sight of your goal.

    Daily Fix It, Sort It, or Clean It Challenge

    May No-Spend: 9/12 "A penny saved is a penny earned!"
    1 (), 2 (), 3 (), 4 (), 5 (), 6 (), 7 (), 8 (), 9 (), 10 (), 11 (), 12 (), 13 (), 14 (), 15 (), 16 (), 17 (), 18 (), 19 (), 20 (), 21 (), 22 (), 23 (), 24 (), 25 (), 26 (), 27 (), 28 (), 29 (), 30 (), 31 ()

    2012 Lose-A-Pound-A-Week Challenge
    I have 8.2 lbs to lose (as of Mon, May 28th, 2012)

    Personal
    Pay off my Morgage
    $101,927.57 (as of May 28th, 2012 - 10 years, 0 months left...partly because we got a new interest rate )/$108,631.38 (as of Dec. 3rd, 2011 - 12 years, 7 months left)
    Pay off my Line of Credit
    $6,977.26 (as of May 28th, 2012)/$17,790.73 (as of Dec. 3rd, 2011)

  12. #12
    Registered User strezzed's Avatar
    Join Date
    Jun 2009
    Location
    Ontario, Canada
    Posts
    363
    Post Thanks / WTG / Hug
    Rep Power
    4

    Default

    amortization schedules - always hated them in university. Let us know if you can't get the info from your bank. We'll attempt the old-fashioned schedules in that case.

  13. #13
    Registered User imagine's Avatar
    Join Date
    Mar 2008
    Posts
    3,870
    Post Thanks / WTG / Hug
    Rep Power
    27

    Default

    Are you wanting this info to pay down your principal and thus less on the loan and faster? If so then when you make extra payments make sure you say you want it to go to principal. That way it isn't going to any interest.

  14. #14
    Rude and Vile Master Greebo's Avatar
    Join Date
    May 2008
    Location
    Baltimore, Maryland
    Age
    43
    Posts
    8,243
    Post Thanks / WTG / Hug
    Rep Power
    71

    Default

    Why the focus on "one year"? I fear you are putting the cart before the horse.

    A mortgage is a debt for an amount, not a time period. If you pay more up front than is scheduled, the time remaining decreases, but time is only a secondary component of the mortgage.

    What is it you really want to accomplish?
    Last edited by Greebo; 06-16-2009 at 09:22 AM.
    If you could kick in the pants the person responsible for your problems, you wouldn't be able to sit for a month.

    Did you know that a 4 year student paying $20,000/year who finances their education graduates with over $103,000 in debt to start? But a student who works and pays cash and takes 6 years to graduate ends with $6,300 in their pocket! So much for "getting a head start by financing!"


    Greebo
    (Nerd Spender): Loving and extremely patiently tolerated husband of ceashels.
    WARNING: Y Chromosome behind the keyboard. Adjust your listening filters appropriately!

    Three
    Two mortgages, two one no car loans, one no credit cards, and a partridge in pear tree!

  15. #15
    Registered User strezzed's Avatar
    Join Date
    Jun 2009
    Location
    Ontario, Canada
    Posts
    363
    Post Thanks / WTG / Hug
    Rep Power
    4

    Default

    Any update (reply from bank), Quiltin' Mama?

Page 1 of 2 12 LastLast

Similar Threads

  1. Man Sues Bank For Excessive Bank Fees And Wins!
    By staceyy in forum Leisure & Media Arts
    Replies: 4
    Last Post: 05-03-2007, 07:37 AM
  2. So Frustrating
    By AmyBoz in forum Home Environment
    Replies: 30
    Last Post: 02-19-2006, 09:41 AM
  3. Sometimes it can be so frustrating!!!
    By Daphne in forum Supplemental Income, Small Business
    Replies: 14
    Last Post: 06-06-2004, 06:02 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •