Example 15 - Biweekly Accelerated Loan

This example applies to our online demo Time Value of Money Calculator. The C-Value! program for Windows works in a similar way and has a few more features. Note, our online demo TVM calculator is limited to calculations using interest rates between 4.0% and 5.99%

Note: This topic has not been proofed and images need to be added. However, we believe that the steps are complete and accurate.

Calculating loans with accelerated biweekly payments.

1. Click the [New] button to clear any previous entries.
2. Set "Rounding" to "Ignore" by either:

• clicking on the "Rounding" button on the toolbar;
• clicking on the {Compute} menu choice and select {Rounding...};

1. One of the most popular conventional mortgages in the US has a thirty year term and is paid monthly. Some lenders offer a variation of this mortgage known as a biweekly mortgage. These mortgages save the borrower usually thousands of dollars in interest charges and result in the loan being paid off substantially faster. The reason these loans have gained in popularity is because the borrower notices very little difference in the payment amount. The biweekly mortgage requires that the borrower makes payments equal to one-half the monthly payment every two weeks. The result, of course, is that over the course of a year there will be twenty-six payments made (every other week or half of fifty-two weeks) which is equivalent to thirteen monthly payments
2. This example assumes that "Rounding" is set to "Ignore", the Compute Method is set to "Normal" and the Year Length is set to 360
3. 1) Set "Compounding" to "Monthly"
4. 2) Enter .6.25% for the "Nominal Annual Rate"
5. 3) Create a "Loan" event in row one of the cash flow input area
6. A) Set the "Date" to December 1, 2004 (12/01/2004)
7. B) Set the "Amount" to 375,000.00
8. C) Set the "# Periods" to 1
9. 4) Move to the second row of the cash flow input area. Select "Payment" for the "Event" type
10. A) Set the "Date" to January 1, 2005 (01/01/2005)
11. B) Set the "Amount" to "Unknown"
12. C) Set the "# Periods" to 360. This tells C-Value! to calculate the payment as if the payment were based on a 30-year loan
13. 5) Calculate the unknown. The result is $2,308.94 for the regular monthly payment
14. NOTE: At this point you might want to view the amortization schedule and make note of the total interest paid ($456,218.40) and the date of the last payment (December 1, 2034). You can compare these to those produced with a biweekly loan after the next calculation
15. 6) Click on the second row of the cash flow input area
16. A) Press [Ctrl][D] to delete this row or click on the "Delete" button on the toolbar
17. B) Set the compounding to "Biweekly"
18. 7) Click on second row of the cash flow input area to create a new row
19. A) The Event will be "Payment"
20. B) The date will be set to Dec. 15th (12/15/2004)
21. C) Set the "Amount" to $1,154.47 or half the value of the monthly payment from Step 5 above
22. D) Set the "# Periods" to "Unknown"
23. E) Set the "Frequency" to "Biweekly". (See note below.)
24. 7) Calculate the unknown number of periods. The result is 632
25. 8) View the amortization schedule. Note that the loan is paid off a little less than six years early (on February 21, 2029), and the borrower will realize about a $100,000 savings in interest expense or about 20%
26. NOTE: When the amount of time between payments is equal to a compounding period there is no impact on the payoff as a result of compounding. That is, there is no additional interest as a result of unpaid interest. Thus setting the compounding to "Biweekly" when biweekly payments are made does not have a negative impact on the total amount of interest paid

Back to the online Time Value of Money Calculator.