Calculating Amortization Schedule

Amortization schedule shows the calculation of periodic interest and the application of periodic payment towards the principal and interest. In other words, it is a tabular presentation of the periodic payment amount, principal amount, interest, and the unpaid principal balance for each payment period. Amortization schedule is also known as an amortization table.

Source :www.MortgagesAnalyzed.com

We are taking an example of a 2 year fixed rate loan for to illustrate how an amortization schedule is calculated. The loan amount is $100,000 and carries an interest rate of 6% per annum. The payment is made monthly and interest is compounded monthly. The steps are described in detail below.

Source :www.MortgagesAnalyzed.com

The first step is to calculate periodic payment.

Where,

P | = | principal amount = $100,000 |

r | = | annual interest rate = 6% |

t | = | time in years/loan term = 2 |

c | = | compounding periods per year = 12 (monthly compounding) |

i | = | periodic interest rate (r/c) = 6%/12 = 0.005 |

n | = | number of periods = t × c = 2 × 12 = 24 |

Given the information above, we can calculate the payment using the formula below.

PMT =
periodic payment =
[ P × i × (1+i)^{n} ]
[ (1+i)^{n} – 1 ]
=
[ 100,000 × 0.005 × (1+0.005)^{24} ]
[ (1+0.005)^{24} – 1 ]
=
$4,432.06

The payment remains the same each month. The amortization schedule will show how the monthly payment pays off the entire principal loan amount and interest at the end of the loan period.

Source :www.MortgagesAnalyzed.com

For the first period the starting balance is the principal balance. For all subsequent periods the initial balance is the ending balance/unpaid principal balance of previous period.

In our example,

Period 1: starting balance is $100,000.

Source :www.MortgagesAnalyzed.com

Periodic interest =
starting balance × periodic interest rate

In period 1:

Periodic interest | = | $100,000.00 × 0.005 = $500.00 |

Source :www.MortgagesAnalyzed.com

New balance is the sum of starting amount and periodic interest.

In period 1:Periodic interest | = | $100,000.00 + $500.00 = $100,500.00 |

The new balance reflects the amount that would be required to pay the entire loan balance.

Source :www.MortgagesAnalyzed.com

Ending balance =
new balance – payment amount

In period 1:

Ending balance | = | $100,500.00 - $4,432.06 = 96,067.94 |

Ending balance is generally known as unpaid principal balance (UPB).

Optionally you can also calculate the principal reduction amount, which is the amount of principal that was paid in the period.

Principal reduction amount =
Payment/PMT – periodic interest

In period 1:

Principal reduction amount | = | $4,432.06 - $500.00 = $3,932.06 |

Source :www.MortgagesAnalyzed.com

Repeat steps 2 to 5 for each period to calculate the amortization schedule.

For period 2:• Starting balance is the ending balance/UPB for period 1, which is $96,067.94 |

• Periodic interest | = | $96,067.94 × 0.005 = $480.34 |

• New balance | = | $96,067.94 + $480.34 = $96,548.28 |

• Ending balance | = | $96,548.28 - $4,432.06 = $92,116.22 |

• Principal reduction amount | = | $4,432.06 - $480.34 = $3,951.72 |

Source :www.MortgagesAnalyzed.com

For period 24:

• Starting balance | = | $4,410.01 |

• Periodic interest | = | $4,410.01 × 0.005 = $22.05 |

• New balance | = | $4,410.01 + $22.05 = $4,432.06 |

• Ending balance | = | $4,432.06 - $4,432.06 = $0.00 |

• Principal reduction amount | = | $4,432.06 - $22.05 = $4,410.01 |

The complete amortization schedule is presented below.

$4,432.06

$6369.48

Monthly Payment

Total Interest Paid

$106,369.44

24 Months

Total Payments

Period

Source :www.MortgagesAnalyzed.com

Period |
Starting Balance |
Interest |
New Balance |
Periodic Payment |
Principal Reduction |
Unpaid Balance |
---|---|---|---|---|---|---|

1 | $100,000.00 | $500.00 | $100,500.00 | $4,432.06 | $3,932.06 | $96,067.94 |

2 | $96,067.94 | $480.34 | $96,548.28 | $4,432.06 | $3,951.72 | $92,116.22 |

3 | $92,116.22 | $460.58 | $92,576.80 | $4,432.06 | $3,971.48 | $88,144.74 |

4 | $88,144.74 | $440.72 | $88,585.46 | $4,432.06 | $3,991.34 | $84,153.40 |

5 | $84,153.40 | $420.77 | $84,574.17 | $4,432.06 | $4,011.29 | $80,142.11 |

6 | $80,142.11 | $400.71 | $80,542.82 | $4,432.06 | $4,031.35 | $76,110.76 |

7 | $76,110.76 | $380.55 | $76,491.31 | $4,432.06 | $4,051.51 | $72,059.25 |

8 | $72,059.25 | $360.30 | $72,419.54 | $4,432.06 | $4,071.76 | $67,987.48 |

9 | $67,987.48 | $339.94 | $68,327.42 | $4,432.06 | $4,092.12 | $63,895.36 |

10 | $63,895.36 | $319.48 | $64,214.84 | $4,432.06 | $4,112.58 | $59,782.78 |

11 | $59,782.78 | $298.91 | $60,081.69 | $4,432.06 | $4,133.15 | $55,649.63 |

12 | $55,649.63 | $278.25 | $55,927.88 | $4,432.06 | $4,153.81 | $51,495.82 |

13 | $51,495.82 | $257.48 | $51,753.30 | $4,432.06 | $4,174.58 | $47,321.23 |

14 | $47,321.23 | $236.61 | $47,557.84 | $4,432.06 | $4,195.45 | $43,125.78 |

15 | $43,125.78 | $215.63 | $43,341.41 | $4,432.06 | $4,216.43 | $38,909.35 |

16 | $38,909.35 | $194.55 | $39,103.89 | $4,432.06 | $4,237.51 | $34,671.83 |

17 | $34,671.83 | $173.36 | $34,845.19 | $4,432.06 | $4,258.70 | $30,413.13 |

18 | $30,413.13 | $152.07 | $30,565.20 | $4,432.06 | $4,280.00 | $26,133.14 |

19 | $26,133.14 | $130.67 | $26,263.80 | $4,432.06 | $4,301.40 | $21,831.74 |

20 | 21,831.74 | $109.16 | $21,940.90 | $4,432.06 | $4,322.90 | $17,508.84 |

21 | $17,508.84 | $87.54 | $17,596.38 | $4,432.06 | $4,344.52 | $13,164.32 |

22 | $13,164.32 | $65.82 | $13,230.14 | $4,432.06 | $4,366.24 | $8,798.08 |

23 | $8,798.08 | $43.99 | $8,842.07 | $4,432.06 | $4,388.07 | $4,410.01 |

24 | $4,410.01 | $22.05 | $4,432.06 | $4,432.06 | $4,410.01 | $0.00 |

Source :www.MortgagesAnalyzed.com

Use our amortization schedule calculator or download the amortization schedule spreadsheet calculator to calculate amortization schedule for your mortgage loan.

Source :www.MortgagesAnalyzed.com

Updated: Jan 12, 2017

Share This Page:

Learn how to build the amortization schedule for your mortgage loan.

Finance

Know all there is to know about the US Mortgage Industry. We help you to make a well informed decision.

Finance
Loan Products

Confused about the choosing right loan product for you? We help you decide the loan product that suits your needs best.

Loan Products
Documents

Here you will find all there is to know about the forms, papers & documents required for Home Loan Mortgage and much more.

Documents
## Comments

comments powered by Disqus