A part) what is the APR on a 5 year (60 month) 25,000 loan with a monthly payment of 500? B part)What is the effective annual rate (EAR) on the loan in a part?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)
7th Edition
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Chapter7: Using Consumer Loans
Section: Chapter Questions
Problem 7FPE: Calculating interest and APR of installment loan. Assuming that interest is the only finance charge,...
icon
Related questions
Question

Only by excel, i know how to do written so by excel only please

A part) what is the APR on a 5 year (60 month) 25,000 loan with a monthly payment of 500?

B part)What is the effective annual rate (EAR) on the loan in a part?

 

Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Effective Annual Rate Of Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning