Question

A personal property loan is made in the amount of $5,687. The interest rate is 10%...

A personal property loan is made in the amount of $5,687. The interest rate is 10% and equal payments are made quarterly over 8 years. What is the amount of interest for the 4th payment? SHOW ALL WORK!!   

Homework Answers

Answer #1

The amount of interest for the 4th payment is calculated using IPMT function in Excel :

rate = 10% / 4   (converting annual rate into quarterly rate - there are 4 quarters per year)

per = 4 (we are calculating the interest amount in the 4th payment)

nper = 8 * 4 (8 year loan with 4 quarterly payments each year)

pv = 5687 (loan amount)

IPMT is calculated to be $133.09

The amount of interest for the 4th payment is  $133.09 as calculated above

Know the answer?
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
Similar Questions
A loan is made in the amount of $13,675. The interest rate is 6% and equal...
A loan is made in the amount of $13,675. The interest rate is 6% and equal payments are to be made semi-annually over 4 years. SHOW ALL WORK!! What is the amount of each payment? What is the total installment cost for the loan?    What is the finance charge for the loan?                                                                               
ABC borrowed $236,000 at an annual interest rate of 11 percent. The terms of the loan...
ABC borrowed $236,000 at an annual interest rate of 11 percent. The terms of the loan required ABC to make quarterly payments and to completely amortize the loan over five years. Assuming ABC made the payments as agreed, how much total interest did ABC pay over the life of the loan? Please show all work.
ABC Bank made a loan to XYZ, Inc. at a rate of 5.04%, compounded monthly, payable...
ABC Bank made a loan to XYZ, Inc. at a rate of 5.04%, compounded monthly, payable in equal monthly payments over a 15 year period. This resulted in a loan payment of $1,585.76, the first payment of which occurred one month after the loan was issued. XYZ, Inc. made payments over a period of 7 years and decided to refinance the loan because of lower interest rates. Assume the refinance was based on the remaining 8 years of the loan...
The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be...
The following loan is fully amortizing. The loan is for $13,000 at 10% interest to be repaid over three (3) years. Amortize this loan on a monthly basis. Calculate the interest portion of the fourth (4th) payment considering that an additional payment of $2,000 was made with the second payment. no excel
A 10-year loan in the amount of $527,000 is to be repaid in equal annual payments....
A 10-year loan in the amount of $527,000 is to be repaid in equal annual payments. What is the remaining principal balance after the sixth payment if the interest rate is 5 percent, compounded annually? Show work.
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $49,000 at a 3% annual rate of...
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $49,000 at a 3% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments. a.  Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a.  The amount of the​ equal,...
2), How large must each payment be if the loan is for $50,000, the interest rate...
2), How large must each payment be if the loan is for $50,000, the interest rate is 10%, and the loan is paid off in equal installments at the end of each of the next 10 years? The loan is for the same amount as the loan in part 1, but the payments are spread out over twice as many periods. Why are these payments not half as large as the payments on the loan in part 1?   Please calculate...
Consider an amortizing loan. The amount borrowed initially is $21618, the interest rate is 5% APR,...
Consider an amortizing loan. The amount borrowed initially is $21618, the interest rate is 5% APR, and the loan is to be repaid in equal monthly payments over 17 years. As we know, while each monthly payment will be the same, the amounts of interest and principle paid will change from payment to payment. How much of the very first payment is interest?
Loan amortization schedule  Personal Finance Problem Joan Messineo borrowed 41,000 at a 4​% annual rate of...
Loan amortization schedule  Personal Finance Problem Joan Messineo borrowed 41,000 at a 4​% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments. a.  Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.
You take out a 15-year loan amount in the amount of $300,000 at a 7% rate...
You take out a 15-year loan amount in the amount of $300,000 at a 7% rate annually. The loan is to be paid off by equally monthly installments over 15 years. Draw an amortization table showing the beginning balance, total payment, principle repayment, interest payment, and ending balance for each month. How much is the total interest payment for the 5 months? (Show only 5 months on the table) ***Please show all work***
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT