Question

A loan of $5000 is to be paid back with payments of $500 apiece. If the interest rate charged is 6% compounded quarterly, complete the first two rows of the following amortization table:

Beginning Amount ofInterest for Portion toPrincipal at Balance Payment Period Principal end of Period

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
A loan of $5000 is to be paid back with payments of $500 apiece. If the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Melissa received a loan of $9,000 at 6.50% compounded quarterly. She had to make payments at...

    Melissa received a loan of $9,000 at 6.50% compounded quarterly. She had to make payments at the end of every quarter for a period of 1 year to settle the loan. a. Calculate the size of payments. Round to the nearest cent b. Fill in the amortization schedule, rounding the answers to two decimal places. Amount Paid Payment Number Interest Portion Principal Portion Principal Balance $9,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00...

  • A loan of $1730 at 9.75% interest compounded semi-annually is to be repaid in four years...

    A loan of $1730 at 9.75% interest compounded semi-annually is to be repaid in four years in equal semi-annual payments. Complete an amortization schedule for the first four payments of the loan. Adjust the final payment so the balance is zero. Fill out the amortization schedule below. (Round to the nearest cent as needed. Do not include the $ symbol in your answers.) Payment Amount of Interest for Portion to Principal at Number End of Payment Period Principal Period $1730...

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

    A loan of $450,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.3%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. a) Find the amount of each payment. $   b) Find the total amount of interest paid during the first 15 payments. $   Suppose that payment number...

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

    A loan of $470,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.5%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. 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...

  • 2. A loan of $350,000 is to be paid back to the lender in equal yearly...

    2. A loan of $350,000 is to be paid back to the lender in equal yearly payments during a period of 5 years. The loan terms were made using an interest rate of 12% compounded quarterly. Determine the amount of each yearly payment that will be made by the borrower. 123

  • Consider a loan of $10000 that is paid off quarterly over a period of one year....

    Consider a loan of $10000 that is paid off quarterly over a period of one year. The agreed statement with the bank that the interest will be paid completely only on the last quarter. On the other hand, th first 3 principal payments from the original loan will have the same value while the last principal payment is just $1000. Calculate the dollar amount of interest and loan principal repaid corresponding to each payment if the interest rate is 10%...

  • A $28,000.00 car loan is to be repaid by end-of-month payments of $480.00 (except the smaller...

    A $28,000.00 car loan is to be repaid by end-of-month payments of $480.00 (except the smaller concluding payment).The interest paid for the loan is 5.78 % compounded quarterly.
 a) Calculate the amortization term of the car loan. b) How much interest will be paid in the second year?
 c) How much will the principal be reduced in the second year?
 d) Calculate the balance after two years. e) What will be the final payment?

  • Given the following partial amortization table for a loan repaid in level payments. Fill in the...

    Given the following partial amortization table for a loan repaid in level payments. Fill in the rest of the table (keep adding rows until the loan is paid off) and use it to answer the following questions: (Round the entries in the table off to two decimal places. Give your answers to 2 decimal places but keep 5 decimals for intermediate computations.) Partial Amortization Table Principal Payment Interest Reduction Time Outstanding Balance ? 0 1 ? 4227.441 21072.561 2277.001 ?...

  • Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of...

    Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,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 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...

  • A $27,000 loan at 8% compounded quarterly is to be repaid by equal quarterly payments over...

    A $27,000 loan at 8% compounded quarterly is to be repaid by equal quarterly payments over a seven-year term. a. What will be the principal component of the sixth payment? (Round your answer to 2 decimal places.) Principal component of the sixth payment $ . b. What will be the interest portion of the twenty-second payment? (Round your answer to 2 decimal places.) Interest portion $ . c. How much will the loan’s balance be reduced by Payments 10 to...

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