Over 2 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.
Start Free
What is an Amortization Schedule?
An amortization schedule is a table that provides both loan and payment details for a reducing term loan.
Details typically include the original loan amount, the loan balance at each payment, the interest rate, the amortization period, the total payment amount, and the proportion of each payment that is made up of interest vs. principal. Amortization schedules can be easily generated using several basic Microsoft Excel functions.
In general, amortization schedules are provided to borrowers by banks or other financial institutions when credit is extended so that borrowers understand the repayment structure.
Key Highlights
An amortization schedule is presented as a table that outlines key loan characteristics like payment amount, interest vs. principal, and the current balance.
An “amortizing loan” is another way of saying a “reducing loan” (for which the balance outstanding reduces at each payment).
A non-amortizing loan where the full balance outstanding is due at the end of the loan term is often called a “bullet repayment.”
Reducing term loans are usually structured as either equal payment (blended) or as equal amortizing (principal + interest).
Understanding Loan Amortization
A good deal of both consumer credit (like car loans and home mortgages) and business credit (like CAPEX loans for PP&E and commercial mortgages) is repaid by periodic payments, sometimes called installments. These are often monthly, but not always.
When a loan is repaid in installments, it’s typically referred to as an amortizing loan (or a reducing loan). Below is an example of a $100,000 loan on a 12-month (1-year) amortization.
The point of a reducing loan is that the outstanding balance is paid down to zero at the end of the amortization period:
Components of a Loan Payment
Every loan payment has two components, interest and principal.
With a reducing loan, some portion of the original loan amount is repaid at each installment. Only this principal portion of the loan payment reduces the total loan amount outstanding; the interest portion does not.
The proportion of interest vs. principal depends largely on the interest rate and on whether the loan is structured as an equal amortizing loan or as an equal payment loan (often called blended payments).
Equal Payment vs. Equal Amortizing
Amortization schedules should clearly show if a loan is equal payment or equal amortizing.
Equal Payment Loans
This is often referred to as a blended payment structure. The borrower knows exactly how much their loan payment is, and the payment amount will be equal each period. A common example is a residential mortgage, which is often structured this way.
Here’s an easy way to visualize loan payments on a 2-year (24-month) amortization schedule:
Since interest is calculated on the principal amount outstanding at the end of the previous period, the proportion of interest embedded in the loan payment (orange) is higher earlier on, then lower later.
The secondary vertical axis shows the total loan balance, represented graphically by the gray line. You’ll notice that the outstanding loan balance decreases with each installment of principal (blue bars).
Equal Amortizing Loans
This is often referred to as a P&I structure (principal + interest). In an equal amortizing structure, the loan amount is divided by the total number of payments; this becomes the principal payment amount each period, with interest being charged over and above the principal amount.
Here is the same loan as before ($100,000 over 24 months) but using an equal amortizing structure instead of an equal payment structure:
Here the blue “principal” bar remains the same over the loan amortization period, with the orange interest being added incrementally.
Related Resources
CFI offers the Commercial Banking & Credit Analyst (CBCA)™ certification program for those looking to take their careers in banking to the next level. To keep learning and advancing your career, the following resources will be helpful:
Learn what credit is, compare important loan characteristics, and cover the qualitative and quantitative techniques used in the analysis and underwriting process.
CFI is a global provider of financial modeling courses and of the FMVA Certification. CFI’s mission is to help all professionals improve their technical skills. If you are a student or looking for a career change, the CFI website has many free resources to help you jumpstart your Career in Finance. If you are seeking to improve your technical skills, check out some of our most popular courses. Below are some additional resources for you to further explore:
CFI is a global provider of financial modeling courses and of the FMVA Certification. CFI’s mission is to help all professionals improve their technical skills. If you are a student or looking for a career change, the CFI website has many free resources to help you jumpstart your Career in Finance. If you are seeking to improve your technical skills, check out some of our most popular courses. Below are some additional resources for you to further explore:
Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.
A well rounded financial analyst possesses all of the above skills!
Additional Questions & Answers
CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.
In order to become a great financial analyst, here are some more questions and answers for you to discover:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.