The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Here is the link to my spreadsheet where you can calculate a loan over x years to be paid back monthly.No. Due Date, Due Payment, Extra Payment (Recurring), Extra Payment (Irregular), Interest Paid, Principal Paid, Balance. This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments. No depreciation or amortization expenses are allowed. 292, 3), Fill in the annual operating expense amounts for the following line items as appropriate:. Welcome to the 2012-2013 Academic Year at Lassen Community College. The community college system provides cost effective opportunities for all.