# How to Use the Ultimate Financial Calculator

## How to Calculate Biweekly Mortgage Payments

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.

This example applies to our online Ultimate Financial Calculator. The C-Value! program for Windows works in a similar way and has a few more features including the ability to save your work.

All users should work through the first tutorial to understand basic concepts about the calculator.

To create a bi weekly amortization schedule, follow these steps:

- Set "Schedule Type" to "
**Loan**"- Or click the [Clear] button to clear any previous entries.
- The top two rows of the grid will not be empty
- Delete the 2nd row by selecting it and clicking on the [Delete] button

- 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".

- For "Calculate Method" select "

- 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

- Set the "Date" to
- 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

- Select "

- Your screen will look like this:

- Calculate the unknown. The result is $2,308.94 for the regular monthly payment

- Prepare to calculate the biweekly term
- Reset the "Initial Compounding" in the header to "
**Biweekly**" - 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)

- Reset the "Initial Compounding" in the header to "

- Your screen will look like this:

- 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

- 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.

##### C-Value!, A TVM Calculator for Windows

An extremely flexible time-value-of-money calculator for Windows computers.

- Loan or investment calculations.
- Cash flows can be regular or irregular
- Create and print schedules.
**Save your data to disk for later use.**

Suitable for auditors, accountants, lawyers and you!