Browse the Topics, Table of Contents, and Index
Follow us:
Twitter Facebook

6.3 Home Mortgages

6.3 Home Mortgages
<
>
  • 7. Amortization Schedules

    Use a spreadsheet. (See Example 3.)

    You take out a home mortgage for $238,000 for 30 years at 5%. Each month, you make the regular payment of $1277.64 plus an additional $60.

    1. How much sooner do you pay off the mortgage?
    2. How much do you save in interest?

    • Worked-Out Solution
      1. Use a spreadsheet to create an amortization schedule showing the effect of the additional monthly payment of $60.

        You will pay your mortgage off in 326 months. This is months earlier than if you make the regular payments.

      2. By making the regular monthly payments, you would pay

        With the additional payment of $60 per month, you will pay

        So, you willl save

    Comments (0)

    These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
    When posting a comment, you agree to our Terms of Use.

     _    _      ___     __   _    __   __    _____   
    | \  / ||   / _ \\  | || | ||  \ \\/ //  /  ___|| 
    |  \/  ||  / //\ \\ | '--' ||   \ ` //  | // __   
    | .  . || |  ___  ||| .--. ||    | ||   | \\_\ || 
    |_|\/|_|| |_||  |_|||_|| |_||    |_||    \____//  
    `-`  `-`  `-`   `-` `-`  `-`     `-`'     `---`   
                                                      
    
    Showing 0 comments
    Subscribe by RSS
    There are no comments.
  • 8. Amortization Schedules

    Use a spreadsheet. (See Example 3.)

    You take out a home mortgage for $260,000 for 30 years at 6%. Each month, you make the regular payment of $1558.83 plus an additional $100.

    1. How much sooner do you pay off the mortgage?
    2. How much do you save in interest?

    Comments (0)

    These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
    When posting a comment, you agree to our Terms of Use.

      _  _    __   __    ______     ___      _____   
     | \| ||  \ \\/ //  /_   _//   / _ \\   |__  //  
     |  ' ||   \ ` //     | ||    / //\ \\    / //   
     | .  ||    | ||     _| ||   |  ___  ||  / //__  
     |_|\_||    |_||    /__//    |_||  |_|| /_____|| 
     `-` -`     `-`'    `--`     `-`   `-`  `-----`  
                                                     
    
    Showing 0 comments
    Subscribe by RSS
    There are no comments.
  • 9. Amortization Schedules

    Use a spreadsheet. (See Example 3.)

    You take out a home mortgage for $275,000 for 25 years at 4%.

    1. What is the least amount, to the nearest dollar, that you need to pay in addition to the regular payment to pay off the mortgage 5 years early?
    2. Compare the total interest you pay for the 25-year mortgage to the total interest you pay when you pay off the 25-year mortgage 5 years early.

    • Worked-Out Solution
      1. Your monthly payment is

        If you pay this amount each month your mortgage will be paid off in 25 years (or 300 months). Using a spreadsheet and "trial and error," you can see that you need to make additional payments of $215 to pay the mortgage off 5 years earlier.

      2. By making the regular monthly payments, you would pay

        With the additional payment of $215 per month, you will pay

        So, you will save

    Comments (1)

    These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
    When posting a comment, you agree to our Terms of Use.

     _    _    __   __    _____      ___      ______  
    | \  / ||  \ \\/ //  /  ___||   / _ \\   /_   _// 
    |  \/  ||   \ ` //  | // __    / //\ \\  `-| |,-  
    | .  . ||    | ||   | \\_\ || |  ___  ||   | ||   
    |_|\/|_||    |_||    \____//  |_||  |_||   |_||   
    `-`  `-`     `-`'     `---`   `-`   `-`    `-`'   
                                                      
    
    Showing 1 comments
    Subscribe by RSS
    system user
    Guest   5 years ago |
    Guest
    0
  • 10. Amortization Schedules

    Use a spreadsheet. (See Example 3.)

    You take out a home mortgage for $190,000 for 20 years at 5%.

    1. What is the least amount, to the nearest dollar, that you need to pay in addition to the regular payment to pay off the mortgage 5 years early?
    2. Compare the total interest you pay for the 20-year mortgage to the total interest you pay when you pay off the 20-year mortgage 5 years early.
    3. Compare the total interest you pay for a 15-year mortgage for the same amount and at the same rate to the total interest you pay when you pay off the 20-year mortgage 5 years early.

    Comments (0)

    These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
    When posting a comment, you agree to our Terms of Use.

     __   _    _    _     _  __     ___     __   __  
    | || | || | || | ||  | |/ //   / _ \\   \ \\/ // 
    | '--' || | || | ||  | ' //   / //\ \\   \   //  
    | .--. || | \\_/ ||  | . \\  |  ___  ||  / . \\  
    |_|| |_||  \____//   |_|\_\\ |_||  |_|| /_//\_\\ 
    `-`  `-`    `---`    `-` --` `-`   `-`  `-`  --` 
                                                     
    
    Showing 0 comments
    Subscribe by RSS
    There are no comments.
  • 11. Balloon Mortgages

    Use a spreadsheet. (See Example 4.)

    You take out a 5-year balloon mortgage for $150,000. The monthly payment is equal to that of a 15-year mortgage with an annual percentage rate of 5%. Find the balloon payment and the total interest that you pay.

    • Worked-Out Solution

      Your monthly payment is

      Making this monthly payment for 5 years produces the following spreadsheet.

      The balloon payment is $111,835.67. You will pay a total interest of $33,007.07.

    Comments (0)

    These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
    When posting a comment, you agree to our Terms of Use.

     __   _    __   __               ___      _____   
    | || | ||  \ \\/ //     ___     / _ \\   /  ___|| 
    | '--' ||   \ ` //     /   ||  | / \ || | // __   
    | .--. ||    | ||     | [] ||  | \_/ || | \\_\ || 
    |_|| |_||    |_||      \__ ||   \___//   \____//  
    `-`  `-`     `-`'       -|_||   `---`     `---`   
                             `-`                      
    
    Showing 0 comments
    Subscribe by RSS
    There are no comments.
  • 12. Balloon Mortgages

    Use a spreadsheet. (See Example 4.)

    You take out a 7-year balloon mortgage for $120,000. The monthly payment is equal to that of a 30-year mortgage with an annual percentage rate of 5.5%. Find the balloon payment and the total interest that you pay.

    Comments (0)

    These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
    When posting a comment, you agree to our Terms of Use.

      _  _    __   __    _____     _____     _  _   
     | \| ||  \ \\/ //  / ____||  |  ___||  | \| || 
     |  ' ||   \ ` //  / //---`'  | ||__    |  ' || 
     | .  ||    | ||   \ \\___    | ||__    | .  || 
     |_|\_||    |_||    \_____||  |_____||  |_|\_|| 
     `-` -`     `-`'     `----`   `-----`   `-` -`  
                                                    
    
    Showing 0 comments
    Subscribe by RSS
    There are no comments.