How to Use Excel to Calculate Amortization. Microsoft Excel is a widely used spreadsheet program that can use formulas to compute and display values. When your small business is taking out a loan ...

You can also use a biweekly loan amortization template to figure out how your payments and schedule differs by making half-payments every two weeks instead of 12 whole payments in a year.