Question

Michelle takes out a $50,000 loan for 15 years which she repays with annual payments at...

Michelle takes out a $50,000 loan for 15 years which she repays with annual payments at the end of each year. The annual interest rate is 1% for the first 2 years and then increases to 5% for the remainder of the loan. Michelle's payments increase by 7% each year. Find the loan balance immediately following the tenth payment.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

Lets first calculate the amount to be paid by Michelle at the end of 15 years:

Amount after 2 years

Using the TVM row on BA II plus calci

PV = 50000, n=2 , I/Y =1 , PMT =0 .FV=?

Press CPT + FV we get FV = 51005.

Amunt after 15 years beginning from the theird year

PV = 51005 , N = 13, I/Y =5 , PMT =0 , FV =?

Press CPT + FV = 96177.53

Now we know Michelles payments increase by 7% each year so

Let the payment of michelle in year 1 is x

x + x(1.07) + x (1.07)^2+ ….. . . . + x (1.07)^14 = 96177.53

x { 1+ 1.07 +1.07^2 + … . . + 1.07^14} = 96177.53 ---1)

Sum to n terms of a GP is = a (r^n-1) / r-1

a =1 , r = 1.07 , n =15

We get Sn = 1(1.07^15-1)/(1.07-1) = (2.759 -1 ) / 07 = 39.4147

Now Considering 1)

x * 39.4147 = 96177.53

x = 96177.53 / 39.4147 = 2440.141

Sum till tenth payment / Sum of 10 terms of Gp = x * (a(r^10 -1)/(1-r))

2440.141 * 1(1.07^10 -1)/.07 = 2440.141 {(1.967-1)/ .07} = 2440.141 * 13.81644 = 33714.081

Loan balance left = 96177.53 - 33714.081 = 62463.4488

Add a comment
Know the answer?
Add Answer to:
Michelle takes out a $50,000 loan for 15 years which she repays with annual payments at...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Helen borrows $20000 to be repaid over 15 years with level annual payments with an annual...

    Helen borrows $20000 to be repaid over 15 years with level annual payments with an annual effective interest rate of 8%. The first payment is due one year after she takes out the loan. Helen pays an additional $4000 at the end of year 9 (in addition to her normal payment). At that time (the end of year 9) she negotiates to pay off the remaining principal at the end of year 14 with a sinking fund. The sinking fund...

  • 21. Dr. Rock takes out a loan for 100.000. The annual effective interest rate on the...

    21. Dr. Rock takes out a loan for 100.000. The annual effective interest rate on the loan is 10%. Dr. Rock repays the loan by making payments at the end of each year. With the exception of the final payment, the payment amount is equal to three times the interest due. Dr. Rock's final payment is the balance due at that time, and the loan is arranged so that final payment does not exceed 1000. (a) How many payments does...

  • 1. A company takes out a loan of $50,000 at 6 % interest. The term of...

    1. A company takes out a loan of $50,000 at 6 % interest. The term of the loan is seven years, with equal payments of $5000 at the end of the first through sixth years. The balance of the loan is due as a "balloon payment" at the end of the seventh year. Draw a cash flow diagram for this problem, assigning proper symbols to any unknown values. DO NOT solve for the unknowns.

  • Theory of Interest: Sally takes out a $7,000 loan which requires 60 equal monthly payments starting...

    Theory of Interest: Sally takes out a $7,000 loan which requires 60 equal monthly payments starting at the end of the first month. The nominal annual interest rate is 8% convertible monthly. She arranges to make no payments for the first five months and then make the same payments she would have made plus an extra payment at the end of the 60th month. How much will this balloon payment be? Answer: $1,178.41. If you are using Excel worksheets, please...

  • An amortized loan is repaid with annual payments which start at $550 at the end of...

    An amortized loan is repaid with annual payments which start at $550 at the end of the first year and increase by $ 50 each year until a payment of $ 2,000 is made, after which they cease. If interest rate is 4% effective, find the amount of principal in the tenth payment. would prefer to understand the financial mathematics behind obtaining the solution, not using excel spreadsheet or financial calculator online

  • A B C A borrower takes out a 29-year mortgage loan for $286,819 with an interest...

    A B C A borrower takes out a 29-year mortgage loan for $286,819 with an interest rate of 9%. What would the monthly payment be? A borrower takes out a 30-year mortgage loan for $190,372 with an interest rate of 8% and monthly payments. What portion of the first month's payment would be applied to interest? A borrower has a 25-year mortgage loan for $495,186 with an interest rate of 9% and monthly payments. If she wants to pay off...

  • Claire repays a loan to banker Maggie by amortization method at 6% effective. She makes 25 equal payments of $1000 at the end of each year. If the amount of interest in each payment is invested by Mag...

    Claire repays a loan to banker Maggie by amortization method at 6% effective. She makes 25 equal payments of $1000 at the end of each year. If the amount of interest in each payment is invested by Maggie at 6% effective as she receives the payments. What is the accumulated amount of the reinvested interest at the end of the 25th year?

  • Mark takes out a 30-year loan on January 1, 1992 for 20,000 at an annual effective...

    Mark takes out a 30-year loan on January 1, 1992 for 20,000 at an annual effective interest rate of 5%. Payments are made at the end of each year. On January 1, 2002, Mark takes out a 20-year loan for 10,000 at an annual effective interest rate of 7%. Payments are also made at the end of each year. Calculate the total amount of principal repaid during the year 2002 on both loans.

  • Without the use of excel: A borrows 20000 for 8 years and repays the loan with...

    Without the use of excel: A borrows 20000 for 8 years and repays the loan with level annual payments at the end of each year. B also borrows 20000 for 8 years, but pays only interest as it is due each year and plans to repay the entire loan at the end of the 8 year period. Both loans carry an effective rate of 8.5%. How much more interest will B pay than A pays over the life of the...

  • A loan of $370,000 is amortized over 30 years with payments at the end of each...

    A loan of $370,000 is amortized over 30 years with payments at the end of each month and an interest rate of 8.9%, compounded monthly. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the first 15 payments. $ c) Find the total amount of interest paid over the life of the loan. $ d) Find the total of all payments made over 30...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT