Monthly Amortization Schedule – Excel Template This monthly amortization schedule helps you calculate your monthly loan payments given the following data: Loan Amount, Annual Interest Rate, Loan Payment in Years, Number of Payment Per Year, Start Date of the Loan and Optional Extra Payments.
Read more »
Mortgage Calculator Amortization Schedule Excel Template This template calculates the amortization on your mortgage loan given some simple basic information: Loan Principal Amount, Annual Interest Rate, Loan Period in Years, Base Year of Loan, and Base Month of Loan.
Read more »
Refinance Mortgage Calculator Excel Template This excel templates calculates your refinanced loan payment when you enter the following data: Personal Marginal Tax Rate, Resale Plan in Months Current Mortgage Terms: Mortgage Amount, Interest Rate, Terms, Months Paid Proposed (New) Mortgage: Mortgage Amount ,Interest Rate, Points, Terms
Read more »
Video of the Loan Calculator and Amortization Template This video demonstrates the very useful loan amortization calculator template. This video demonstrates the different variable that can be entered: loan amount, interest rate, number of payments, and extra payments. This demonstration is an example of the FREE templates available in Excel.
Read more »
Using Loan Amortization Schedule To Keep Track of Your Mortgage Payments If you are buying a new home soon, using loan amortization schedule will be helpful for your budget. This schedule allows you to enter loan amounts, anticipated interest rates, and loan payments per year. With these variables, you are can calculate your anticipated...
Read more »