In: Accounting
PLEASE USE THE BA 11 PLUS CALCULATOR FUNCTIONS. NO FORMULA METHODS PLEASE. I'M BEING GRADED ON MY FINAL USING CALCULATOR FUNCTIONS ONLY. ALSO PLEASE SHOW WORK IN THE TABLE AS WELL. THANK YOU.
2. LO 1 Angelo Lemay borrowed $8000 from his credit union. He agreed to repay the loan by making equal monthly payments for five years. Interest is 9% compounded monthly.
What is the size of the monthly payments?
How much will the loan cost him?
How much will Angelo owe after 18 months?
How much interest will he pay in his 36th payment?
How much of the principal will be repaid by the 48th payment?
Prepare a partial amortization schedule showing details of the first three payments, Payments 24, 25, 26, the last three payments, and totals.
Please give positive ratings so I can keep answering. If you have any queries please comment. Thanks!
Due to character limit I am attaching the image for amortization schedule.
PMT= | PV*i | |||||
1-(1+i)^-n | ||||||
PV= | Loan amount | 8,000.00 | ||||
n= | no. of payments | 5*12= | 60.00 | |||
i | 9%/12 | 0.0075 | ||||
PMT= | 8000*0.0075 | |||||
1-(1+0.0075)^-60 | ||||||
PMT= | 60 | |||||
1-(1.0075)^-60 | ||||||
PMT= | 60 | |||||
1-0.638699698592769 | ||||||
PMT= | 60 | |||||
0.361300301 | ||||||
PMT= | 166.0668418 | |||||
PMT= | 166.07 | |||||
The size of the monthly payments: $ 166.07. | ||||||
The loan cost will him: $ 9,964.20 | Refer amortization schedule | |||||
Angelo will owe after $ 5964.02 after 18 months. | Refer amortization schedule | |||||
He will pay in his $ 28.30 in his 36th payment. | Refer amortization schedule | |||||
$3,101.22 will be repaid by the 48th payment. | Refer amortization schedule | |||||
For answer F I have attached the entire amortization schedule. | ![]() ![]() |