Question

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 p
b. Fill in the amortization schedule, rounding the answers to two decimal places. Amount Paid Payment Number Interest Portion
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. Rate per quarter = 6.5% 4 = 1.625%

Using pmt function in excel or financial calculator : PMT ( 1.625%,4,-9000,0)

Size of payments = 2342.14

2.

Payment number Amount paid Interest portion
[Principal balance *1.625%]
Principal portion
[Amount paid - Interest portion]
Principal balance
0 9000
1 2342.14 146.25 2195.89 6804.11
2 2342.14 110.57 2231.57 4572.54
3 2342.14 74.30 2267.84 2304.70
4 2342.14 37.45 2304.70 0.0
Total 9368.56 368.57 9000.00
Add a comment
Know the answer?
Add Answer to:
Melissa received a loan of $9,000 at 6.50% compounded quarterly. She had to make 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
  • Danielle received a loan of $37,000 at 3.75% compounded monthly. She had to make payments at...

    Danielle received a loan of $37,000 at 3.75% compounded monthly. She had to make payments at the end of every month for a period of 7 years to settle the loan. a. Calculate the size of payments. I 0.00 Round to the nearest cent b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. Payment Payment Number Interest Portion Principal Portion Principal Balance $37,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00...

  • Casey received a loan of $29,000 at 6.5% compounded quarterly. He had to make payments at...

    Casey received a loan of $29,000 at 6.5% compounded quarterly. He had to make payments at the end of every quarter for a period of 7 years to settle the loan. a) Calculate the size of payments b) . Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places.

  • b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal...

    b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. Holly received a loan of $36,000 at 3.5% compounded monthly. She had to make payments at the end of every month for a period of 5 years to settle the loan. a. Calculate the size of payments. 0.00 Round to the nearest cent Interest Principal Payment Principal Payment Portion Portion Balance Number $36,000.00 $0.00 $0.00 $0.00 $0.00 1 $0.00 $0.00 $0.00 $0.00 2...

  • loan amortization schedule question OMAT 230 OS X Microsoft Office Home X B MATH 230 051...

    loan amortization schedule question OMAT 230 OS X Microsoft Office Home X B MATH 230 051 Amortization - x + ment/9286 Question 3 (6) Corey received a loan of $26,000 at 4.5% compounded semi-annually. He had to make payments at the end of every half-year for a period of 5 years to settle the loan. AB CLOSE DATE Sun, March 15th 11:59 pm Submit Print a. Calculate the size of payments. Save Progress 0.00 Round to the nearest cent b....

  • b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal...

    b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. General Computers Inc. purchased a computer server for $58,500. It paid 35.00% of the value as a down payment and received a loan for the balance at 7.50% compounded semi-annually. It made payments of $2,050.27 at the end of every quarter to settle the loan. a. How many payments are required to settle the loan? o payments Round up to the next payment...

  • A design studio received a loan of $9,650 at 4.60% compounded semi-annually to purchase a camera....

    A design studio received a loan of $9,650 at 4.60% compounded semi-annually to purchase a camera. If they settled the loan in 3 years by making quarterly payments, construct the amortization schedule for the loan and answer the following questions: a. What was the payment size? Round to the nearest cent b. What was the size of the interest portion on the first payment? Round to the nearest cent c. What was the balance of the loan at end of...

  • Calculate the accumulated amount of end-of-month payments of $5,000 made at 3.21% compounded quarterly for 4...

    Calculate the accumulated amount of end-of-month payments of $5,000 made at 3.21% compounded quarterly for 4 years. Round to the nearest cent How much should Austin have in a savings account that is earning 4.50% compounded quarterly, if he plans to withdraw $2,400 from this account at the end of every quarter for 9 years? Round to the nearest cent Zachary deposits $350 at the end of every quarter for 4 years and 6 months in a retirement fund at...

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

  • Question 4 of 5 A $85,000 loan was amortized over 14 years at 4.00 % compounded...

    Question 4 of 5 A $85,000 loan was amortized over 14 years at 4.00 % compounded annually. Payments were made at the end of every month to clear the loan. a. What is the size of the payments at the end of every month? $0.00 Round to the nearest cent b. What was the balance at the end of 4 years? $0.00 Round to the nearest cent c.What was the interest portion of payment 84? $0.00 Round to the nearest...

  • A loan of $8,400 was received at a rate of 9% compounded quarterly. Payments will be...

    A loan of $8,400 was received at a rate of 9% compounded quarterly. Payments will be made at the end of each month for 5 years. Determine the size of the payments. Simple interest is paid for part of a period.

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