Question

Suppose you borrowed $10,000 for 4 years with quarterly payments at an APR of 7%. Please...

  1. Suppose you borrowed $10,000 for 4 years with quarterly payments at an APR of 7%.

Please show all work and formulas used!!

  1. What is the Quarterly payment?
  2. Amortize the first four payments .Set up a table like the one below:

Payment Number                    Payment              Interest                Principle               Remaining Balance

               

1                                              ________           ________           ________           _______________

2                                              ________           ________           ________           _______________

3                                              ________           ________           ________           _______________

4                                              ________           ________           ________           _______________

  1. How much interest will you pay over the life of the loan?
0 0
Add a comment Improve this question Transcribed image text
Answer #1
a) if payments are made quarterly
P = Regular Payments
PV = Loan Amount
r = rate of interest
n = no of periods
P = r (PV)
1 - (1 + r )-n
P = (7%/4)*10000
1 - (1 / (1 + 7%/4)^16))
P = 175
0.242383693
P = 722.00
Quarterly payment = $ 722
b) Payment NO Payment Interest Principal Remaining Balance
1 722 $175.00 $547.00 $9,453.00
2 722 $165.43 $556.57 $8,896.44
3 722 $155.69 $566.31 $8,330.13
4 722 $145.78 $576.22 $7,753.91
C) Overall Interest = Overall Emi - Loan amount
(722 * 16) - 10000
$1552
Add a comment
Know the answer?
Add Answer to:
Suppose you borrowed $10,000 for 4 years with quarterly payments at an APR of 7%. Please...
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
  • 13-19 odd please 13. A $10,000 loan is to be amortized for 10 years with quarterly...

    13-19 odd please 13. A $10,000 loan is to be amortized for 10 years with quarterly payments of $334.27. If the interest rate is 6% compounded quarterly, what is the unpaid balance immediately after the sixth payment? 14. A debt of $8000 is to be amortized with 8 equal semi- annual payments of $1288.29. If the interest rate is 12% compounded semiannually, find the unpaid balance immediately after the fifth payment. 15. When Maria Acosta bought a car 2 years...

  • Please provide the answer showing all steps. Suppose you borrowed $10,000 at an interest rate of...

    Please provide the answer showing all steps. Suppose you borrowed $10,000 at an interest rate of 12%, compounded monthly over 36 months. At the end of the first year (after 12 payments), you want to negotiate with the bank to pay off the remainder of the loan in 8 equal quarterly payments. What is the amount of this quarterly payment, if the interest rate and compounding frequency remain the same?

  • Janine borrowed $35,000 from her bank. Monthly payments are $600, including interest at 6.8% compounded quarterly....

    Janine borrowed $35,000 from her bank. Monthly payments are $600, including interest at 6.8% compounded quarterly. a.How many payments will Janine make altogether? (Do not round intermediate calculations and round your answer up to the next whole number.) No. of payments b.How much is the last payment? (Do not round intermediate calculations and round your answer to 2 decimal places.) Last payment c.How much interest will Janine pay over the life of the loan? (Do not round intermediate calculations and...

  • you make quarterly (and of quarter payments of $1,75743. The You borrowed $100.000 exactly 2 years...

    you make quarterly (and of quarter payments of $1,75743. The You borrowed $100.000 exactly 2 years ago. The loan is structured as an amortized loan. The interest rate is is amortized over 25 years. How much principal have you paid over the first 2 years! How much principal have you paid over the first 2 years? (Round to the nearest dolar.)

  • need help thanks! Suppose that you have just borrowed $250,000 in the form of a 30...

    need help thanks! Suppose that you have just borrowed $250,000 in the form of a 30 year mortgage. The loan has an annual interest rate of 9% with monthly payments and monthly compounding. a. What will your monthly payment be for this loan? b. What will the balance on this loan be at the end of the 12th year? How much interest will you pay in the 7th year of this loan? d. How much of the 248th payment will...

  • please solve without excel 2. Suppose you are in the market for a new car worth...

    please solve without excel 2. Suppose you are in the market for a new car worth $35,000. You are offered a deal to make a 15% down payment now and to pay the balance in equal end-of-month payments over 60 months with an APR of 12%. a. What should be the required monthly payment? b. Complete the following table: End of Month Interest Payment Principle Payment Remaining Balance 31 $114 42 49

  • Suppose you borrow $710 for a term of four years at simple interest with an APR...

    Suppose you borrow $710 for a term of four years at simple interest with an APR of 3.51%. Determine the total you must pay back on the loan. - A particular payday loan company offers quick, short-term loans using the borrower's future paychecks as collateral. The loan company charges $17 for each $120 loaned for a term of 16 days. Find the APR charged by the payday loan company. Suppose you borrow $710 for a term of four years at...

  • You borrowed $20,000 one year ago. The loan terms are: 5-year loan with APR of 24%...

    You borrowed $20,000 one year ago. The loan terms are: 5-year loan with APR of 24% compounded monthly. There are 3 questions to answer for this problem. In your answers, do not use the $ sign, use comma to separate thousands, and round to the nearest dollar. 1. What is the monthly payment for this loan? 2. What is the loan balance today? 3. Today, you decide you want to pay off the loan in 20 months rather than the...

  • Suppose you have a student loan of $30,000 with an APR of 12% for 40 years....

    Suppose you have a student loan of $30,000 with an APR of 12% for 40 years. Complete parts (a) through (c) below. a. What are your required monthly payments? The required monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.) b. Suppose you would like to pay the loan off in 20 years instead of 40. What monthly payments will you need to make? The monthly payment required to pay...

  • Your mortgage has 25 years​ left, and has an APR of 5.326 % with monthly payments...

    Your mortgage has 25 years​ left, and has an APR of 5.326 % with monthly payments of $ 1 449 . a. What is the outstanding​ balance?   b. Suppose you cannot make the mortgage payment and you are in danger of losing your house to foreclosure. The bank has offered to renegotiate your loan. The bank expects to get $ 179 968 for the house if it forecloses. They will lower your payment as long as they will receive at...

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