Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

Loan amortization schedule Personal Finance Problem Joan Messino borrowed $47

Finance Nov 27, 2020

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)

Expert Solution

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.

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment