Question

In: Finance

You borrowed $10,000 two years ago. The loan terms are: 5-year loan with APR of 12%...

You borrowed $10,000 two years ago. The loan terms are: 5-year loan with APR of 12% and with monthly payments of $222.44. Today, you decided you want to pay off the loan in 20 months rather than the remaining life of the loan. How much more do you have to add to your monthly payment in order to accomplish it?

Write out your answer in the space provided. MAKE SURE TO SHOW HOW YOU OBTAIN THE ANSWER (STEPS NECESSARY). If you do not show your work, you will not get credit. Showing work is not showing the keys used in a financial calculator, doing that will get you 0 credit.

Solutions

Expert Solution

Step-1:Loan balance as of today
Loan balance is the present value of montly payments.
Loan balance = =-pv(rate,nper,pmt) Where,
= $ 6,697.11 rate 12%/12 = 0.01
nper (5-2)*12 = 36
pmt = $     222.44
Step-2:revised monthly payment
Revised monthly payment = =pmt(rate,nper,-pv) Where,
= $     371.12 rate 12%/12 = 0.01
nper = 20
pv = $ 6,697.11
Step-3:Addition to monthly payment
Addition to monthly payment = Revised monthly payment - Existing monthly payment
= $     371.12 - $   222.44
= $     148.68

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

You borrowed $10,000 two years ago. The loan terms are: 5-year loan with APR of 25%...
You borrowed $10,000 two years ago. The loan terms are: 5-year loan with APR of 25% compounded monthly.   1. What is the monthly payment for the loan? 2. What is the loan balance today? 3. Today, you decide to pay off the loan in 20 months rather than the remaining life of the loan. How much more do you have to add to your monthly payment in order to accomplish the goal? Please include Excel formulas.
you borrowed 100,000 exactly 5 years ago. the loan is structured as an amortized loan. the...
you borrowed 100,000 exactly 5 years ago. the loan is structured as an amortized loan. the interest rate is 6 % and you make quarterly (end of quarter) payments of 1937.06. the loan is amortized over 25 years. how much principal have you paid over the first 5 years ?
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.
Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal installments...
Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal installments at the end of each month. a. How much do you need to pay each month? (Round up your answer to the nearest two decimal points) b.How much is owed (to the bank) at the end of year 3? (Round up your answer to the nearest two decimal points) c. How much interest is paid at the first month of year 4 of the...
Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal installments...
Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal installments at the end of each month. a. How much do you need to pay each month? b.How much is owed (to the bank) at the end of year 3? c. How much interest is paid at the first month of year 4 of the loan? d. How much interest is paid over the last two years of the loan? (Round up your answer to...
Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal installments...
Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal installments at the end of each month. a. How much do you need to pay each month? b.How much is owed (to the bank) at the end of year 3? c. How much interest is paid at the first month of year 4 of the loan? d. How much interest is paid over the last two years of the loan?
Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal installments...
Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal installments at the end of each month. a. How much do you need to pay each month? b.How much is owed (to the bank) at the end of year 3? c. How much interest is paid at the first month of year 4 of the loan? d. How much interest is paid over the last two years of the loan? (Round up your answer to...
EREREFEFE--- Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal...
EREREFEFE--- Suppose you apply a 5-year bank loan of $500000 at 12% APR, repayable in equal installments at the end of each month. a. How much do you need to pay each month? b.How much is owed (to the bank) at the end of year 3? c. How much interest is paid at the first month of year 4 of the loan
You are taking an interest-only $10,000 loan. The loan is to be paid in two years...
You are taking an interest-only $10,000 loan. The loan is to be paid in two years and carries monthly interest payments of 0.5% 1. Show amortization table for the loan. 2. What is the outstanding balance of the loan at any month?
For examples 1, you will consider a standard 4-year car loan of $10,000, with 6% APR...
For examples 1, you will consider a standard 4-year car loan of $10,000, with 6% APR compounded monthly. Payments are $234.85 per month, assuming $0 down payment. All of our expected values are from the perspective of the bank offering the loan. 1)     [Scenarios] Consider people who pay for 2 years, then stop….. a)      Assume that the bank can recover an average of $2000 from the repossession process after 2 years.   How much $ does the bank get back from...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT