Learning Center
Plans & pricing Sign in
Sign Out

Loan Amortization Schedule with Guide

VIEWS: 2,237 PAGES: 9

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.

More Info
To top