Amortization schedule

src: palladiumes.com

An amortization schedule is a table detailing any periodic payments on an amortization loan (usually a mortgage), as generated by an amortization calculator. Amortization refers to the process of paying off debt (often from a loan or mortgage) over time through regular payments. A portion of each payment is for interest, while the remainder is used for the principal balance. Percentage of interest on principal in each payment is determined in the amortization schedule. The schedule differentiates the portion of the payment that is part of the interest cost of the portion used to close the discount or premium gap of the principal after each payment.

While a portion of each payment is applied for both interest and principal balance, the exact amount applied to the principal varies each time (with the rest going to interest). The amortization schedule shows the specific amount of money put into the interest, as well as the specified amount entered into the principal balance, with each payment. Initially, most of each payment is devoted to interest. When the loan matures, a larger portion is used to pay the principal.

Video Amortization schedule

Amortization method

There are various methods used to develop an amortization schedule. These include:

• Straight line (linear)
• Balance decreases
• Annuity
• Bullets (at once)
• Balloons (payment of amortization and final big payments)
• Improve your balance (negative amortization)

The amortization schedule runs in chronological order. The first payment is assumed to happen one full payment period after the loan is taken, not on the first day (the date of origination) of the loan. The last payment actually pays the rest of the loan. Often, the last payment will be a slightly different amount than all previous payments.

In addition to splitting each payment into interest and principal, the amortization schedule also shows interest paid up to date, principal payments to date, and outstanding principal balance at each payment date.

Maps Amortization schedule

Assumption of amortization schedule

This amortization schedule is based on the following assumptions:

First, it should be noted that rounding errors occur and, depending on how the lender accumulates these errors, integrated payments (principal plus interest) may be slightly different in several months to keep these errors from accumulating; or, the accumulated error is adjusted for each end of the year or on the last loan payment.

There are several important points to consider when mortgaging a home with an amortized loan. First, there is a substantially different allocation of monthly payments to interest, especially during the first 18 years of a 30-year mortgage. In the example below, payment 1 allocates about 80-90% of total payments to interest and only $ 67.09 (or 10-20%) against principal balance. The exact percentage that is allocated to the underlying payment depends on the interest rate. Not until the payment of 257 or more than two-thirds over a period of time to allocate payment of principal and interest even out and then tip the majority to the first.

For fully amortized loans, at a fixed rate (ie, non-variable), the payments remain the same for the duration, regardless of the outstanding principal balance. For example, payments for the above scenario will remain $ 733.76 regardless of whether the unpaid (unpaid) principal balance is $ 100,000 or $ 50,000. Paying more than the monthly contract amount reduces the amount outstanding and thus the interest paid to the lender; if the contractual monthly payment remains the same, the payment amount and the loan term must be reduced. Conversely, paying less of the monthly contract amount will increase the amount owed and thus the interest payable (negative amortization); if the contractual monthly payment remains the same, the payment amount and the loan period must increase.

src: i.ytimg.com

Calculation of outstanding loan balance

The balance of the loan at a specified time during the loan term can be calculated by finding the present value of the remaining payment at the given interest rate. This amount is made up of principal only.

Example of outstanding loan balance calculation: 28,000.00

• Loan Term = * Interest Rate = 9%
• Payment is $ 284.00 per month

Question: What is the balance of the loan at the end of the year?

First, calculate the monthly payment by using the loan amount ($ 100,000 as the present value, the 52 week period, 7% interest). This will give you a monthly payment of $ 775.30. Presentation Values ​​The annuity formula should be used here to complete monthly payments.

Next, to find the balance of the loan, you need to find the present value of the remaining payment. Use a monthly payment of $ 775.30 as a payment function, the term will be 156 ((20-7) x12), and.583333% as the exchange rate. This will give you a loan balance of $ 79,268.02. Again, the present value of the annuity formula should be used.

This means that by the end of the seventh year the loan may be paid off entirely by the amount of $ 79,268.02. Usually the mortgage lender will have a balloon payment clause in the contract that will charge for the initial payment. This is because the lender will not get the same results if the loan balance is not held to maturity.

Similarly here is a table that shows the interest and principal paid for the first two years.

src: apprize.info

External links

• Amortize the calculator in Curlie (based on DMOZ)

src: i.ytimg.com

References

Source of the article : Wikipedia