Loan Information

The purpose of this template is to produce a loan amortization schedule and to calculate the current and long-term portion of the loan as of the balance sheet date.

Entering Information

All of the information needed to produce the calculations is entered on the Input worksheet. The yellow highlighted cells are calculated fields, and no data should be entered in these cells.  Gray cells are not calculated fields, but data should not be entered in these cells.

Enter any three of the following amounts:

  • Amount borrowed
  • Interest rate
  • Periodic payment
  • Payback periods (in years)
Loan Information