Question

In: Finance

Jamie owes $21,750 at a 5% APR compounded monthly. The minimum amount that she must pay...

Jamie owes $21,750 at a 5% APR compounded monthly. The minimum amount that she must pay monthly is $230.69. How much sooner can she pay off this loan if she makes monthly payment of $300 ?

Solutions

Expert Solution

Loan amount owed by Jamie = $21,750

Monthly Interest rate = APR/12 = 5%/12 = 0.4167%

Minimum monthly payment = $230.69

Calculating the number of months it will take Jamie to pay off the Loan using Excel "NPER" function:-

Number of Months = 120 months

- Now, Jamie makes monthly payment of $300 with evertything else remains the same.

Calculating the number of months it will take Jamie to pay off the Loan with monthly payment of $300 using Excel "NPER" function:-

Number of Months if Monthly payment is $300= 86.50 months

- Number of months sooner jamie can pay off the loan with $300 monthly payment = 120 months - 86.50 months

= 33.5 months or 2.79 years

If you need any clarification, you can ask in comments.    

If you like my answer, then please up-vote as it will be motivating       


Related Solutions

Abigail is saving to buy a car in 5 years when she graduates from college. She finds an account that pays an APR of 5.7% compounded monthly.
Abigail is saving to buy a car in 5 years when she graduates from college. She finds an account that pays an APR of 5.7% compounded monthly.If she deposits $3000 right now, how much will she have in five years?What if instead of investing one amount at the beginning she invests $60 each month. How much will she have in five years?What is the APY on 5.7% compounded monthly?
Which of the following APRs compounded monthly is equivalent to an APR of 14.15% compounded quarterly...
Which of the following APRs compounded monthly is equivalent to an APR of 14.15% compounded quarterly using 360-day calendar years, 30-day months, and 3-month quarters? a) 12.960% b) 13.320% c) 13.680% d) 14.040% e) 14.400%
You have just taken out a $23000 car loan with a ​5% APR, compounded monthly. The...
You have just taken out a $23000 car loan with a ​5% APR, compounded monthly. The loan is for five years. When you make your first payment in one​ month, how much of the payment will go toward the principal of the loan and how much will go toward​ interest?  ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.) When you make your first​ payment, ​$___ will go toward the principal of the loan and...
You have found three investment choices for a one-year deposit 11.7 % APR compounded monthly, 11.7 % APR compounded annually, and 10 8% APR compounded daily
You have found three investment choices for a one-year deposit 11.7 % APR compounded monthly, 11.7 % APR compounded annually, and 10 8% APR compounded daily. Compute the EAR for each investment choice (Assume that there are 365 days in the year) (Note Be careful not to round any intermediate steps less than six decimal places) The EAR for the first investment choice is% (Round to three decimal places) The EAR for the second investment choice is % (Round to three decimal...
Mary owes an amount of $1,460 on her credit card. The annual percentage rate (APR) is...
Mary owes an amount of $1,460 on her credit card. The annual percentage rate (APR) is 3%, compounded monthly. Her minimum monthly payment is $20. a. If she makes only this minimum payment, how long will it take to repay the card balance (assuming no more charges are made)? b. If she makes the minimum payment plus $10 extra each month (for a total of $30), how long will it take to repay the card balance?
You just bought a house and borrowed 15-year mortgage at 5% APR, compounded monthly. Your loan...
You just bought a house and borrowed 15-year mortgage at 5% APR, compounded monthly. Your loan amount is $250,000. Calculate your monthly payment Calculate the principal and interest portions of your 1st and last payment Calculate how much principal and interest you paid within 5 years and your outstanding balance at the end of the fifth year.
Find the amount of each annuity A) after 12 monthly deposits of $200 at 5% compounded...
Find the amount of each annuity A) after 12 monthly deposits of $200 at 5% compounded monthly B) after 5 annual deposits of $1000 at 3% compounded annually.
Your bank is offering a certificate of deposit with an APR of 4.48% compounded monthly. What...
Your bank is offering a certificate of deposit with an APR of 4.48% compounded monthly. What is the effective annual rate?
You are taking out a loan at a 12.5% apr, compounded monthly. What is your effective...
You are taking out a loan at a 12.5% apr, compounded monthly. What is your effective annual rate? Enter answer in percents, accurate to two decimal places.
The APR on a loan is 13.45%, compounded monthly. What is the effective semi-annual rate? Select...
The APR on a loan is 13.45%, compounded monthly. What is the effective semi-annual rate? Select one: a. 6.725% b. 6.916% c. 7.225% d. One cannot compare rates with different compounding frequencies.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT