If you take out a loan or mortgage, it’s important to keep track of your payments. However, calculating payment amounts and planning a schedule can be tricky. That’s where an Excel amortization schedule template comes in handy. An amortization schedule is a table that lists all payments that will be made on a loan over time. The payment amounts are generated by an amortization calculator.
“Amortizing” a loan means paying off the total balance—including both the interest and the principal—in regular, incremental amounts. Using an amortization template for Excel will show you the amount of your payment going toward the principal, and how much is going toward the interest. Early on, your payments will mostly go toward paying interest, but over time, larger portions of your payments will go toward paying off the principal.
The following amortization schedule templates provide a framework for easily determining balances paid and owed. They also list all scheduled payments over the lifetime of the loan, and show the total amount that remains. Simply plug in your figures for the total loan amount, interest rate, loan duration, and payment frequency, and the calculator will do the rest. We’ve provided a variety of templates you can use for a number of different loans - choose the one that’s best for you and start managing your finances more effectively. You can also use Excel’s built-in amortization template by following these instructions.
General Loan Amortization Schedule Template
This all-purpose Microsoft Excel amortization schedule template can be used for a variety of loan types including personal loans, mortgages, business loans, and auto loans. It calculates the interest and principal payments for a given loan amount within a set timeframe. This amortization table Excel template will show you the balance remaining after each payment, and the amount of interest paid to date. It also calculates the total number of payments necessary to pay the loan balance in full, so you can plan accordingly.
Mortgage Loan Amortization Schedule Template
This loan amortization calculator Excel template can be used for a home mortgage loan—one of the most common types of amortizing loans. Use this template to calculate the balances paid and owed, as well as the distribution of payments across the interest and principal. This will help you determine how many payments remain until you officially own your home. You can also see how much you will save by making extra mortgage payments.
Balloon Loan Amortization Schedule Template
Use this Excel amortization schedule template to determine balloon payments. A balloon payment is when you schedule payments so that your loan will be paid off in one large chunk at the end, after a series of smaller payments are made to reduce the principal. This loan amortization template will calculate both your monthly payments and the balloon payment amount and schedule.
Home Equity Loan Amortization Schedule Template
This amortization Excel template allows you to calculate how much equity you have in your home after a specific number of years. Since a home equity loan is essentially a second mortgage, you can determine how long it will take you to pay off each of your loans. This template can also help you answer important questions related to selling your home, such as the amount of equity you’ll build over a certain period of time, how much you’ll owe if the value of your home drops, and what happens if you make extra payments.
Auto Loan Amortization Schedule Template
Use this loan amortization Excel template to determine the total loan amount when you purchase a car, factoring in trade-ins, rebates, down payments, sales tax, and any other extra fees. You can calculate the time it will take to pay off your loan, and experiment with how making extra payments can expedite your full ownership of the car.
Use Smartsheet’s Amortization Tool for a More Collaborative Experience
Smartsheet is a work management and automation platform that enables enterprises and teams to work better. You can easily create an amortization schedule in Smartsheet using the pre-built “Loan Amortization Schedule” template. Modify the template to fit the specific needs of your payment plan and easily visualize and track monthly loan payments. Smartsheet’s amortization table calculates the beginning balance, total payment, interest and principal payments, and end balance for each period.
Additionally, Smartsheet’s powerful collaboration features give outside stakeholders insight into the payment schedule, and allow multiple editors to make changes and check for accuracy. Attach relevant documents directly to the rows in your sheet, or copy emails and add notes in Comments. Share your sheet with an infinite number of collaborators and specify editing permissions, and set alerts and reminders so you never miss a payment.