Fill This Form To Receive Instant Help
Homework answers / question archive / Loan amortization schedule Personal Finance Problem Joan Messino borrowed $47
Loan amortization schedule Personal Finance Problem Joan Messino borrowed $47.000 at a 3% annual rate of interest to be repaid over 3 years The loan is amortized into the equal anaendelea a Calculate the annual, ond of year loan payment. b. Prepare a loan amortization schedule showing the interest and principal breakdown of ouch of the three loan payments c. Explain why the interest portion of each payment declines with the passage of time a. The amount of the equal, annual, ond-of-year loan payment is Round to the nearest cent) b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments Many financial calculators have an amortization function which makes this process my Once the paymes above, you can use the AMORT function to calculate the interest paid, principal paid and ending loan balance for each payment period. You should consult your calculator estructions for specific details pertaining to your calculator What is the account balance at the beginning of your 12 (Round to the nearest cent) Beginning of-year principal su Loan payment Payments Interest Principal End-of-year principal Year 1 What is the amount of the loan payment at the end of year 12 (Round to the nearest cent) Beginning of-year Payments Loan End-of-year Year principal payment Interest Principal principal $47.000 SO What portion of the payment is applied to interest in your 17 Round to the nearest cent) Beginning Payments End-of-year Loan of-year Year principal payment Interest Principal principal Click to select your answer(s)
a) Annual payment= Loan amount/(1-1/(1+r)^n)/r
= 47000/(1-1/(1+3%)^3)/3%
= 47000/2.828611355
= 16615.93
b)
Year | Beginning of year Principal | Loan payment | Interest | Principal | End of year Principal |
1 | 47000 | $16,615.93 | 1410 | $15,205.93 | $31,794.07 |
2 | $31,794.07 | $16,615.93 | $953.82 | $15,662.10 | $16,131.97 |
3 | $16,131.97 | $16,615.93 | $483.96 | $16,131.97 | $0.00 |
c) The interest is calculated on the principal outstanding at the beginning of the year. The principal is being repaid each year and so the interest payments are declining.
Workings
please see the attached file for the complete solution.