Question

A $10,000 loan is being paid off by annual payments of $2,000 plus a smaller final payment. If the annual effective rate of ithe amount is 1125.5, but not entirely sure how to get there. No excel please

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

Annual Payments = $ 2000, Interest Rate = 15% and Loan = $ 10000

Let the required final payment be $ P

Further, the number of payments is at least 5 as 5 x 2000 = $ 10000 in case the discount rate is zero.

Therefore, 2000 x (1/0.15) x [1-{1/(1.15)^(5)}] = $ 6704.31

Remaining Payment = $ 10000 - 6704.31 = $ 3295.69

PV of Another $ 2000 coming in at the end of Year 6 = 2000 / (1.15)^(6) = $ 864.655

Remaining Payment = 3295.69 - 864.655 = $ 2431.03

PV of Another $ 2000 coming in at the end of Year 7 = 2000 / (1.15)^(7) = $ 751.874

Remaining Payment = 2431.03 - 751.874 = $ 1679.16

PV of Another Payment coming in at the end of Year 8 = 2000 / (1.15)^(8) = $ 653.804

Remaining Payment = 1679.16 - 653.804 = $ 1025.36

PV of Another Payment coming in at the end of Year 9 = 2000 / (1.15)^(9) = $ 568.525

Remaining Payment = 1025.36 - 568.525 = $ 456.832

PV of Another $ 2000 at the end of Year 10 is higher than the outstanding payment, thereby implying that the final payment P is made at the end of Year 10

Therefore, P = 456.832 x (1.15)^(10) = $ 1848.14

Loan Outstanding at the end of Year 4 = 2000 x (1/0.15) x [1-{1/(1.15)^(5)}] + 1848.14 / (1.15)^(6) = $ 7503.31

Interest Accrued on Outstanding Loan during year 5 = 7503.31 x 0.15 = $ 1125.5

Interest Portion of 5th Payment = Interest Accrued on Outstanding Loan during Year 5 = $ 1125.5

Hence, the correct option is (E)

Add a comment
Know the answer?
Add Answer to:
the amount is 1125.5, but not entirely sure how to get there. No excel please A...
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
  • 1. A $12,000 loan is being repaid with $1000 payments at the end of each year...

    1. A $12,000 loan is being repaid with $1000 payments at the end of each year for as long as necessary, plus a smaller payment one year after the last $1000 payment. The first payment is due one year after the loan is taken out, and the effective annual interest rate is 6%. Calculate the balance on the loan immediately following the ninth payment

  • all of three please LOANS: Written Answer Questions (3) Due 7/2 1 Sylvia is repaying a...

    all of three please LOANS: Written Answer Questions (3) Due 7/2 1 Sylvia is repaying a loan of X by making 17 annual payments of 100. Each payment consists of interest on the loan at 5% effective and an amount that is deposited in a sinking fund earning 4% effective. At the end of 17 years, the amount in the sinking fund is equal to the original loan amount accumulated with interest at the sinking fund rate. Determine X. 2....

  • Problem 3 A) Pierluigi is trying to get a loan for $10,000 to start a business...

    Problem 3 A) Pierluigi is trying to get a loan for $10,000 to start a business as a financial advisor and is trying to decide between several options. (15 points) i) A $10,000 loan that needs to be paid back after 5 years with a 5% nominal annual interest rate, compounded monthly interest ) A $10,000 loan that needs to be paid back after 6 years, the first 2 years there is no and after the annual effective interest rate...

  • ** USE FORMULA TO SOLVE THIS PROBLEM (NO EXCEL PLEASE!!!) (3) An amortized loan is repaid with annual payments which st...

    ** USE FORMULA TO SOLVE THIS PROBLEM (NO EXCEL PLEASE!!!) (3) An amortized loan is repaid with annual payments which start at $400 at the end of the first year and increase by $45 each year until a payment of $1,480 is made, after which they cease. If interest is 4% effective, find the amount of principal in the fourteenth payment

  • Problem 3 B) Pierluigi is trying to get a loan for $10,000 to start a business...

    Problem 3 B) Pierluigi is trying to get a loan for $10,000 to start a business as a financial advisor and is trying to decide between several options. (15 points) DA $10,000 loan that needs to be paid back in 6 years with a 6 % nominal annual interest rate, compounded monthly i) A $10,000 loan that needs to be paid back in 7 years, which accrues no interest during the first 2 years but has a 10% effective interest...

  • EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a...

    EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a home loan with yearly loan repayments, ie. the loan is paid by payments at the end of each year for n years, until the loan is completely paid off. Please use your spreadsheet to answer the following questions: (a) Given loan amount is $600,000, annual effective interest rate i is 11%, loan term is 20 years. Find the annual repayment amount. (b) Given annual...

  • can somebody help me with 37,38 and (most needed) 40 please??? 200 The theory of interest...

    can somebody help me with 37,38 and (most needed) 40 please??? 200 The theory of interest 36. A loan is being repaid with 10 payments. The first payment is 10, the second 9, d so forth with the tenth payment being 1. Show that the amount of interest in te sixth payment is 5- ag- 37. A loan is repaid with payments which start at $200 the first year and increase by $0 per year until a payment of $1000...

  • Explain without excel (3) An amortized loan is repaid with annual payments which start at $400...

    Explain without excel (3) An amortized loan is repaid with annual payments which start at $400 at the end of the first year and increase by $45 each year until a payment of $1,480 is made, after which they cease. If interest is 4% effective, find the amount of principal in the fourteenth payment.

  • Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $1...

    Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...

  • Can anyone help me solve these without excel? 1) If Serena invests $10,000 today in a...

    Can anyone help me solve these without excel? 1) If Serena invests $10,000 today in a project and receives $7,000 one year from today and $5,000 two years from today in return, what is her annual internal rate of return? You can assume that her effective annual discount rate is 20%. 2) Jamie will buy a $2,000,000 house today. She will make a 20% deposit, and borrow the remaining amount in the form of a mortgage. She will repay the...

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