Biweekly Mortgage Calculator Spreadsheet, 26 Payments a Year (ODS)
By EducoPrice in USD. Local taxes calculated at checkout.
Buy 3 or more, save 20% from this shop
- 1 ZIP download · ODS, TTF, TXT, ZIP formats · 4 tabs; ODS
- Buyer protection. Corrupt or mismatched files? Full refund.
Item details
Model a fixed-rate loan with 26 payments per year, optional extra amounts and a full schedule up to 30 years.
'Yearly Summary' adds the schedule into 30 yearly rows and summary table interest against principal and the falling balance. 'Amortization' lists up to 780 payments with date, beginning balance, payment, extra, interest, principal and ending balance with each extra payment applied straight to principal. 'Loan Calculator' takes the home price, down payment %, rate, term, property tax, home insurance and mortgage insurance and reports the payment, total interest, total paid, number of payments and final payment date.
Extra-payment cells (recurring and one-time) show interest saved and payments saved against the plain schedule. Payments are every two weeks.
The editable tabs are Loan Calculator: Inputs (price, down payment, rate, term, start date, extra payments), results block and balance summary table.; Amortization: Schedule for up to 780 payments: date, beginning balance, payment, extra, interest, principal, ending balance.; Yearly Summary: 30 rows of yearly payments, interest, principal and ending balance plus two summary table..
The default inputs are a made-up mortgage loan of about $280,000; replace them with your own figures.
A single ZIP contains ODS workbook, Lexend, Andika OFL font files and licences, and README.txt. The Start Here tab explains inputs, calculations and how to clear the worked entries.
The workbook contains 7151 formulas. Its sage green design uses coloured input cells and separate calculation cells. Use the supplied fonts for the exact layout shown.
Works with spreadsheet software supporting ODS files. Digital download; no macros or external data connections.
This ODS edition presents calculated results as cells and summary tables.
File specs
| Formats | ODS, TTF, TXT, ZIP |
|---|---|
| Dimensions | 4 tabs; ODS |
| Color space | sRGB |
| Downloadable files | 1 ZIP download · ODS, TTF, TXT, ZIP formats |
| Category | Templates |
| Last updated |
What you’ll download
- zipbiweekly-mortgage-calculator-spreadsheet-26-payments-a-year.zip227 KB
License and usage
- Personal · $6.49
- Use the files in your own non-commercial projects: home prints, gifts, personal social posts and school work. Anything made with them can’t be sold.
- Commercial · $18.99
- Use the files in client work and in products you sell, up to 5,000 units across all products. Credit is appreciated but not required.
No license allows reselling, sharing or redistributing the original files as they are, including in free packs or AI training sets.
