Question

Find the amortization table for a $23,000 loan amortized over 3 years with semiannual payments if the interest rate is 5.3% p

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

To find amortisshion table, first we need to find payment per period or Semiannus! Payment, equenon fort this is a payment =so semiannual payment is 4196.62 @ first interest is 2.651 23600 - 23000* 265 = 609.5 OD Payment to principle on = Payment -for second row (2) payment is sane = 4196.62 Interest - outstanding Principley Interest rate before 100 - 19412.88 * 2.65 = 53rd row 3 4196.62 416.86 11950.94 10 3779.76 for 4th Payment = 4196.62 Interest - 119 50.7 * 2.65 = 316.70 Principle =3879.92for 6th Payment = 4196.62 Interest-4088.28 * 2.65 Too = 108.34 Principle = 4088.28 outstandine Princple = 0.0 End Payment of

Add a comment
Know the answer?
Add Answer to:
Find the amortization table for a $23,000 loan amortized over 3 years with semiannual payments if...
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
  • Find the amortization table for a $13,000 loan amortized over 3 years with semiannual payments if...

    Find the amortization table for a $13,000 loan amortized over 3 years with semiannual payments if the interest rate is 5.7% per year compounded semiannually. (Round your answers to the nearest cent.) End of Period Payment Made Payment Toward Interest Payment Toward Principal Outstanding Principle 13000

  • Find the amortization table for a $8,000 loan amortized over 3 years with semianni cent.) if...

    Find the amortization table for a $8,000 loan amortized over 3 years with semianni cent.) if the interest rate is 5.9% per year compounded semiannually. (Round your answers to the nearest End of Period Payment Made Payment Toward Interest Payment Toward Principal Outstanding Principle 8000

  • Question 4 of 6 Helen's student loan of $23,000 at 4.62% compounded quarterly was amortized over...

    Question 4 of 6 Helen's student loan of $23,000 at 4.62% compounded quarterly was amortized over 5 years with payments made at the end of every month. What was the principal balance on the loan after 3 years? Round to the nearest cent

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

  • Question 2 of 6 Christopher's student loan of $23,000 at 2.82% compounded quarterly was amortized over...

    Question 2 of 6 Christopher's student loan of $23,000 at 2.82% compounded quarterly was amortized over 6 years with payments made at the end of every month. What was the principal balance on the loan after 4 years? Round to the nearest cent Submit Question Next Question

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

  • Find the payment necessary to amortize a 4.9% loan of $7300 compounded semiannually, with 6 semiannual...

    Find the payment necessary to amortize a 4.9% loan of $7300 compounded semiannually, with 6 semiannual payments. Find (a) the payment necessary to amortize the loan and (b) the total payments and the total amount of interest paid based on the calculated semiannual payments. Then create an amortization table to find (c) the total payments and total amount of interest paid based upon the amortization table a. The semiannual payment needed to amortize this loan is $ (Round to the...

  • Find the monthly payment needed to amortize a typical $115,000 mortgage loan amortized over 30 years...

    Find the monthly payment needed to amortize a typical $115,000 mortgage loan amortized over 30 years at an annual interest rate of 5.3% compounded monthly. (Round your answers to the nearest cent.) $ Find the total interest paid on the loan. $

  • Amortization schedule a. set up an amortization schedule for a $23,000 loan to be repaid in...

    Amortization schedule a. set up an amortization schedule for a $23,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 8% compounded annually. Round all answers to the nearest cent Beginning Remaining ar Balance ay men Balance b. What percentage of the payment represents interest and what percentage represents principal for each of the 3 years? Round all answers to two decimal places % interest % Principal Year...

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