Amortized LoansIntroductionCharting the history of a loanA table of the previous exampleFinding a monthly paymentPayment formulaExampleExample using Table 1Another example using table 1Table 1 - Amortization Table at 10%Example Using Table 2Table 2 - Amortization Table for $1000 LoanAmortized LoansSection 5.4Introduction•The word amortize comes from the Latin word admoritz which means “bring to death”.•What we are saying is that we want to bring the debt to death! More gently it is retiring the debt.•The important factors related to an amortized loan are the principal, annual interest rate, the length of the loan and the monthly payment.•If we know any 3 of the above factors, the fourth can be found.Charting the history of a loan•Chart the history of an amortized loan of $1000 for three months at 12% interest, with a monthly payment of $340.•When the 1st payment is made 1/12 of a year has gone by, so the interest is $1000 x .12 x 1/12 = $10.•The payment first goes toward paying the interest, then the rest is applied to the unpaid balance. The net payment is $340 - $10 = $330.•The new balance is $1000 - $330 = $670.•Now we calculate the interest on the remaining balance. •$670 x .12 x 1/12 = $6.70.•The net payment is $340 - $6.70 = $333.30.•The new balance is $670 - $333.30 = $336.70.•Once again we calculate the interest on the remaining balance.•$336.70 x .12 x 1/12 = $3.37.•Thus the last payment has to cover the interest and the remaining balance.•This is $3.37 + $336.70 = $340.07. Thus the last payment is $340.07A table of the previous example•Beginning balance $1000Payment Interest Net PaymentNew Balance$340.00 $10.00 $330.00 $670.00$340.00 $6.70 $333.30 $336.70$340.07 $3.37 $336.70 $0.00Finding a monthly payment•Many times we know the length of a loan, the annual interest rate and the amount of the loan. Can we afford to make the monthly payment??? This question is very important when considering a mortgage.•The monthly payment formula is basically derived from the equation future value of annuity = future value of loan amount.Payment formula•Let P be present value or full amount of loan, r is the annual interest rate, t is the length of the loan and PMT is the monthly payment. ]1)1[(11212121212trtrrPPMTExample•What is the monthly payment for a loan of $29,000 for 5 years at an annual interest rate of 5%.•The monthly payment is $547.27•Note: If you follow this schedule, you will make 60 payments of $547.27 which in total is $32836.20. The amount of interest paid to the lender is $32836.20 - $29000 = $3836.20 ]1)1[(129000)5)(12(1205.)5)(12(1205.1205.PMTExample using Table 1•Amortization tables have been created so that people don’t need to use the complicated payment formula.•For example, find the monthly payment for a $10000 loan at 10% annual interest for 5 years. •Looking at Table 1, this corresponds to the entry of $212.48.•Verify using the PMT formula. You may be off by a cent or two, that’s because rounding error was introduced into the table.Another example using table 1•What would be the payment on a loan of $58,000 at 10% annual interest for 30 years?•$58000 = $50000 + 4 x $2000•We will use the entries for $50000 at 30 years and $2000 at 30 years.•The PMT = $438.79 + 4 x $17.56 = $509.03•Verify using the PMT formula. Rounding error has been introduced.Table 1 - Amortization Table at 10%Amount 5 years10 years15 years20 years25 years 30 years35 years40 years100 2.13 1.33 1.08 0.97 0.91 0.88 0.86 0.85200 4.25 2.65 2.15 1.94 1.82 1.76 1.72 1.70500 10.63 6.61 5.38 4.83 4.55 4.39 4.30 4.251000 21.25 13.22 10.75 9.66 9.09 8.78 8.60 8.502000 42.50 26.44 21.50 19.31 18.18 17.56 17.20 16.995000 106.24 66.08 53.74 48.26 45.44 43.88 42.99 42.4610000 212.48 132.16 107.47 96.51 90.88 87.76 85.97 84.9220000 424.95 264.31 214.93 193.01 181.75 175.52 171.94 169.8350000 1062.36 660.76 537.31 482.52 454.36 438.79 429.84 424.58100000 2124.71 1321.51 1074.61 965.03 908.71 877.58 859.68 849.15Example Using Table 2•Recall that we calculated the monthly payment of a $29000 loan for 5 years at 5% annual interest to be $547.27.•Let’s use table 2. •The entry that corresponds to 5% for 5 years is $18.871234. •Since this is a $1000 table, and the loan amount is for $29000, we multiply the $18.871234 by 29 to get a monthly payment of $547.265786 or properly $547.27. The same as we computed using the formula.Table 2 - Amortization Table for $1000 LoanPercent 5 years 10 years 15 years 20 years 25 years 30 years5 18.871234 10.60552 7.907936 6.599557 5.845900 5.3682166 19.332802 11.102050 8.438568 7.164311 6.443014 5.9955057 19.801199 11.610848 8.988283 7.752989 7.067792 6.6530258 20.276394 12.132759 9.556521 8.364401 7.718162 7.3376469 20.758355 12.667577 10.142666 8.997260 8.391964 8.04622610 21.247045 13.215074 10.746051 9.650216 9.087007 8.77571611 21.742423 13.775001 11.365969 10.321884 9.801131 9.52323412 22.244448 14.347095 12.001681 11.010861 10.532241 10.28612613 22.753073 14.931074 12.652422 11.715757 11.278353 11.06199514 23.268251 15.526644 13.317414 12.435208 12.037610 11.84871815 23.789930 16.133496 13.995871 13.167896 12.808306
View Full Document
Unlocking...