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.

Solutions

Expert Solution

(Suppose Loan starting Date is April, 2018)

$10,000 Two years Ago,
5 Years Term(5*12= 60 Payment), 25% Compounded Monthly (25%/12= 0.0208)
(1) Monthly Payment for the loan :-
$10,000 = Monthly Payment * [1 – (1/1.0208)60] / 0.0208
Monthly Payment = $10,000 / [ 1- 0.979660] /0.0208
= $10,000 / [ 1 - 0.2908 ] / 0.0208
= $10,000 / 34.0972
= $293.28 or say $293.00.................Monthly Payment for loan (1)

(2) Loan balances Today... is (after 2 years)
= $ 7,388.41 (as per excel sheet calculation)

3) If today, i 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...
By making Trail and Error method into amortization schedule we found that $162.20 added into current payment of EMI so that loan is closed within 20 months from as of now. (Atmost 44 emi (24+20))
New EMI is $455.48 respectively for next 20 month.

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 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 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.

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...

A $26,000 loan borrowed 5 years ago, has been scheduled for re-pay starting today. The payment...

A $26,000 loan borrowed 5 years ago, has been scheduled for re-pay starting today. The payment schedule is equal monthly payments made at the end of every month for the next 10 years. Find the size of the payments if interest is 3.6% p.a. compounding monthly.

A property was financed 5 years ago at 80% of 360,000 and an APR of 3%....

A property was financed 5 years ago at 80% of 360,000 and an APR of 3%. Five years have passed and interest rates have dropped to an APR of 2.65% for a five year mortgage. Required fees for the new mortgage are $1,400. What is the effective cost to refinance the mortgage? A. 2.72% B. 2.96% C. 3.02% D. 3.07%

5. If you borrowed a car loan last year at 7% when inflation was expected to...

5. If you borrowed a car loan last year at 7% when inflation was expected to be 4% and now inflation is expected to be only 1%, then who is better off, you or the lender? Why?

10-years ago, you took out a 30-year mortgage with an APR of 6.5% for $430,000. If...

10-years ago, you took out a 30-year mortgage with an APR of 6.5% for $430,000. If you were to refinance the mortgage today for 20 years at an APR of 4.25%, how much would your monthly payment change by? Please explain how to solve step-by-step

You purchase a car for 10,000 The car loan is financed with a 5% per year,...

You purchase a car for 10,000 The car loan is financed with a 5% per year, 5 year loan with annyual payments starting at time 1 (1 year from today) through time 5 Each payment reduces the principal by a certain amount until the loan is completely paid off. What is the interest component of the first payment? (I am allowed to use the TI-34 and BAII Plus calculators)

Subjects