Example of Amortization Schedule

Definition

An amortization schedule is a table that outlines the periodic payments of a loan, showing the amount of interest and principal paid in each installment, developed from the concept of amortized loans by Francis Bacon in the 17th century.

How It Works

An amortization schedule works by calculating the total amount paid over the life of the loan, taking into account the loan amount, interest rate, and loan term. The monthly payment is calculated using the formula M = P[r(1+r)^n]/[(1+r)^n – 1], where M is the monthly payment, P is the principal loan amount, r is the monthly interest rate, and n is the number of payments. This formula is based on the time value of money concept, which states that a dollar today is worth more than a dollar in the future. For example, a $200,000 mortgage with an interest rate of 4% and a 30-year loan term would have a monthly payment of approximately $955.

The amortization schedule then breaks down each monthly payment into its interest and principal components. In the early years of the loan, the majority of the monthly payment goes towards paying off the interest, while in the later years, the majority goes towards paying off the principal. This is because the interest rate is applied to the outstanding loan balance, which decreases over time as the principal is paid off. For instance, in the first year of the $200,000 mortgage, approximately $7,863 of the $11,460 paid goes towards interest, while in the 30th year, approximately $955 of the $955 paid goes towards principal.

The amortization schedule also takes into account the compounding frequency of the interest rate, which can be monthly, quarterly, or annually. The more frequently the interest is compounded, the more interest will be paid over the life of the loan. For example, if the interest rate on the $200,000 mortgage is compounded monthly, the total interest paid over the 30-year loan term would be approximately $143,739, while if it were compounded annually, the total interest paid would be approximately $134,019.

Key Components

• Loan term: The length of time the borrower has to repay the loan, which affects the monthly payment and total interest paid. A longer loan term results in lower monthly payments, but more interest paid over the life of the loan.
• Interest rate: The percentage of the outstanding loan balance that is paid as interest each year, which affects the monthly payment and total interest paid. A higher interest rate results in higher monthly payments and more interest paid over the life of the loan.
• Principal: The initial amount borrowed, which decreases over time as the borrower makes monthly payments. As the principal decreases, the amount of interest paid also decreases.
• Monthly payment: The amount paid each month to cover the interest and principal, which is calculated using the formula M = P[r(1+r)^n]/[(1+r)^n – 1].
• Total interest paid: The total amount of interest paid over the life of the loan, which is affected by the loan term, interest rate, and compounding frequency.
• Payoff date: The date on which the loan will be fully paid off, which is affected by the loan term and monthly payment.

Common Misconceptions

• Myth: Amortization schedules are only used for mortgages. Fact: Amortization schedules can be used for any type of loan, including car loans, student loans, and personal loans.
• Myth: The interest rate on a loan is always fixed. Fact: Some loans, such as adjustable-rate mortgages, have interest rates that can change over time, affecting the monthly payment and total interest paid.
• Myth: Making extra payments on a loan will always save the borrower money. Fact: While making extra payments can save the borrower money in interest, it may not always be the best use of their money, as they may be able to earn a higher return by investing the money elsewhere, such as in a 401(k) or IRA.
• Myth: Amortization schedules are only used for loans with fixed interest rates. Fact: Amortization schedules can be used for loans with variable interest rates, such as ARMs, which can affect the monthly payment and total interest paid.

In Practice

For example, Wells Fargo offers a 30-year mortgage with an interest rate of 4% and a loan amount of $250,000. Using an amortization schedule, the borrower can see that the monthly payment would be approximately $1,194, and the total interest paid over the life of the loan would be approximately $173,757. If the borrower were to make an extra payment of $500 per month, the loan would be paid off 5 years early, and the total interest paid would be reduced to approximately $134,919. This is based on the amortization formula, which is used to calculate the monthly payment and total interest paid. The borrower can use this information to make informed decisions about their loan and financial planning.