Biweekly Mortgage Use this template to create a bi-weekly mortgage amortization schedule. This bi-weekly amortization assumes that the borrower will make 26 payments per year, as opposed to a traditional mortgage where the 12 monthly payments per year is the norm. The template is designed to accept up to 30 years as a loan term. Enter all input values or #VALUE will be displayed in the amortization schedule. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next. Bi-Weekly Mortgage Amortization KEY FIGURES INPUTS Annual Loan Payments Loan Principal Amount Bi-Weekly Payments Annual Interest Rate Interest Over Term of Loan Loan Period in Years (30 Max) Sum of All Payments Base Year Loan Start Date Date of First Payment First 26 Payments Payment Beginning Cumulative Cumulative Ending Payment # Date Balance Payment Principal Interest Principal Interest Balance 123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Payments for Calendar Years after Year 1 Beginning Ending Year Balance Payment Principal Interest Balance