VIEWS: 2,237 PAGES: 9 CATEGORY: Financing With Debt POSTED ON: 11/24/2009
This Loan Amortization Schedule sets forth a basic spreadsheet to calculate the principal and interest payments on a loan. The user should only populate the cells for: the principal amount, loan term, annual interest rate, and payments per year. The spreadsheet will automatically calculate, based on these user inputs, the balance remaining on the loan and cumulative interest on the loan. This basic spreadsheet should be used by borrowers to assess whether they will have the ability to make the scheduled principal and interest payments due on a fully amortizing loan.
"Loan Amortization Schedule with Guide"