Loan Amortization

#

LOAN AMORTIZATION FORMULA

With the input of loan amount, interest rate and term (duration) of the loan, this template will create a monthly payment schedule of principal and interest for the life of the loan.  It is used to realize the true cost of money and can create “what if scenarios” with different interest rates and terms.  It allows the business to schedule financing into the expense section of the “Income Statement” as part of the cost of doing business.

 

Loan Amortization Example

Request Consulting from NJSBDC!