How to Calculate Biweekly Mortgage Payments
A Step-by-Step Tutorial
Tutorial 15
Biweekly mortgages are popular with some borrowers because they reduce the amount of interest due when compared with a conventional mortgage that has monthly payments. Why? The payment amount is 1/2 the periodic monthly payment and it is paid every other week. This results in 26 payments a year, or the equivalent of 13 monthly payments. The impact of this is principal is prepaid and therefore the amount of interest paid is less than it otherwise would be.
All users should work through the more detailed first tutorial to understand the Ultimate Financial Calculator's (UFC) basic concepts and settings.
To create a bi weekly amortization schedule, follow these steps:
- Set "Schedule Type" to "Loan"
- Or click the [New] button to clear any previous entries.
- Set "Rounding" to "Adjust last amount to reach "0" balance" by clicking on the {Settings} {Rounding Options}
- In the header section, make the following settings:
- For "Calculate Method" select "Normal".
- Set "Initial Compounding" to "Monthly".
- Enter 6.25 for the "Initial Interest Rate".
- In row one of the cash flow input area, create a "Loan" series
- Set the "Date" to December 1, 2016
- Set the "Amount" to 375,000.00
- Set the "# Periods" to 1
- Note: Since the number of periods is 1, you will not be able to set a frequency. If a frequency is set, it will be cleared when you leave the row
- Move to the second row of the cash flow input area
- Select "Payment" for the "Series"
- Set the "Date" to January 1, 2017
- Set the "Amount" to "Unknown"
- Set the "# Periods" to 360. Payment are first calculated as if they are based on a 30-year loan
- Your screen will look like this (Fig. 1):
- Calculate the unknown. The result is $2,308.94 for the regular monthly payment. (Fig. 2)
- Prepare to calculate the biweekly term
- Reset the "Initial Compounding" in the header to "Biweekly." Fig. 3
- Click on second row of the cash flow input area
- The Series will already be "Payment"
- Reset the "Date" "December 15, 2016 (first biweekly due date)
- Reset the "Amount" to $1,154.47 or half the value of the monthly payment calculated in Step 6 above
- Reset the "# Periods" to "Unknown"
- Reset the "Frequency" to "Biweekly" (See note below)
- Your screen will look like this (Fig. 3):
- Calculate the unknown number of periods. The result is 632 biweekly payments
- While the number of payments has increased, the term of the loan has decreased. Fig. 4
- View the amortization schedules to see the early payoff for the biweekly loan and evaluate the interest savings. In this case, the borrower will realize just over a $100,000 savings in interest expense or about 20%
NOTE: When the payment frequency is equal to the compounding frequency there is no impact on the payoff as a result of changing the 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.
This tutorial illustrates one way to set up a calculation for a biweekly mortgage. You may need a variation of what is shown here. The calculator will support any cash flow scenario. If you need assistance, please ask your question in the comment area at the bottom of the calculator page.
Back to the Ultimate Financial Calculator.