Loan amortization calculator excel free download

Generally, your interest costs are at their highest at the beginning of the loan. Especially with long-term loans, the majority of each periodic payment is taken as an interest expense. You only pay off a small piece of the principle amount. As time goes on, more and more of each payment goes towards your principal and you pay less in interest each month. Amortizing a loan usually means establishing a series of equal monthly payments. This will provide the lender with the following:. The amount of each monthly payment is identical.

The interest component of each payment will be decreasing. The principal component of each payment will be increasing during the life of the loan. Each row shows the amount of the payment that is needed to pay interest, the amount that is used to reduce principal, and the balance of the loan remaining at the end of the period. In other words, a schedule which shows repayment broken down by interest and amortization and the loan balance. I have created an easy to use Loan Amortization Template with preset formulas.

Be sure to read the comments within the file marked with a little red triangle on some of the cells if you have questions. I can't answer that for you, but I would strongly recommend reading through the material listed in the references below.

A fixed-rate loan with an interest-only option is fairly simple to understand and predict, but interest-only mortgages with adjustable rates seem much more risky. Disclaimer : This spreadsheet and the information on this page is for illustrative and educational purposes only. We do not guarantee the results or the applicability to your unique financial situation. You should seek the advice of qualified professionals regarding financial decisions.

This loan amortization template will calculate both your monthly payments and the balloon payment amount and schedule. 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. 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. Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change. The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done.

Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed. Try Smartsheet for free, today.

Furthermore, It displays the value at the end of each period as well as at the completion of the period. Thus, this template can be helpful to individuals planning to invest in fixed deposits in banks and for loan purposes.

If you have any queries please share in the comment section below. We will be more than happy to assist you. Skip to primary navigation Skip to main content Skip to primary sidebar.

I have worked in Excel and like to share functional excel templates at ExcelDataPro. This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.

Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website.