Question
only need the second part
B SECTION 5-18 Amortization 1. Suppose you borrowed $30,000 on a student loan at a rate of 8% and must repay it in 3 equal in
0 0
Add a comment Improve this question Transcribed image text
Answer #1

using excel formula to calculate second part.

Years Beginning Balance=30000 PMT =PMT(8%,3,-30000) Interest part of PMT Principal part of PMT= PMT-Interest Ending Balance
1.00 30000.00 11641.01 2400.00 9241.01 20758.99
2.00 20758.99 11641.01 1660.72 9980.29 10778.71
3.00 10778.71 11641.01 862.30 10778.71 0.00
Add a comment
Know the answer?
Add Answer to:
only need the second part B SECTION 5-18 Amortization 1. Suppose you borrowed $30,000 on a...
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
  • wity. Amortization schedule Excel Online Structured Activity: Amortization schedule The data on a loan has been...

    wity. Amortization schedule Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadshee a. Complete an amortization schedule for a $30,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. Round all answers to the nearest cent Ending...

  • Suppose you borrowed $15,000 at a rate of 8.5% and must repay it in 5 equal...

    Suppose you borrowed $15,000 at a rate of 8.5% and must repay it in 5 equal installments at the end of each of the next 5 years. How much would you still owe at the end of the second year, after you have made the second payment? Here we use an annual compounding. Hint: Amortization loan table.

  • 8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal paym...

    8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal payments at the end of each of the next three years. The lender charges a 6 percent interest rate on the loan balance that is outstanding at the beginning of each year. 1) Calculate the payment the firm must repay each year. 2) Prepare the loan amortization schedule (fill all the numbers in each cell). Repayment of Remaining Principal Beginning...

  • Loan amortization schedule  Personal Finance Problem   Joan Messineo borrowed ​$49 comma 00049,000 at a 66​% annual...

    Loan amortization schedule  Personal Finance Problem   Joan Messineo borrowed ​$49 comma 00049,000 at a 66​% 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...

  • 8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be...

    8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal payments at the end of each of the next three years. The lender charges a 6 percent interest rate on the loan balance that is outstanding at the beginning of each year. 1) Calculate the payment the firm must repay each year. 2) Prepare the loan amortization schedule (fill all the numbers in each cell). Beginning Amount Repayment of Remaining...

  • An amortization table reports the amount of interest and principal contained within each regularly scheduled payment...

    An amortization table reports the amount of interest and principal contained within each regularly scheduled payment used to repay an amortized loan. Example Amortization Schedule Payment Interest Repayment of Principal Year Beginning Amount Ending Balance 1 2 3 Consider the amount of the interest payments included in each of the payments of an amortized loan. Which of the following statements regarding the pattern of the interest payments is true? The portion of the payment going toward interest is smaller in...

  • AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $34,000 loan to be repaid in equal...

    AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $34,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 10% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Interest ofPrincipal Balance Balance avment Interest Payment b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places. 96 Interest %...

  • 8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal paym...

    8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal payments at the end of each of the next three years. The lender charges a 6 percent interest rate on the loan balance that is outstanding at the beginning of each year. 1) Calculate the payment the firm must repay each year. 2) Prepare the loan amortization schedule (fill all the numbers in each cell). Beginning Amount Repayment of Principal...

  • Please show the works P5-48 Loan amortization schedule Joan Messineo borrowed $45,000 at a 4% annual...

    Please show the works P5-48 Loan amortization schedule Joan Messineo borrowed $45,000 at a 4% annual rate of interest that she must repay over 3 years. The loan is amortized into three equal, end-of-year payments. a. Calculate the end-of-year loan payment. b. Prepare a loan amortization schedule showing the interest and principal break- down of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.

  • 1. Brenda and Matt borrowed $40,000 from the Farm Service Agency for spring crop inputs, at 8% annual interest rate...

    1. Brenda and Matt borrowed $40,000 from the Farm Service Agency for spring crop inputs, at 8% annual interest rate. They took out the loan on March 1 and paid it back on December 10, 285 days later. How much did they have to repay? Principal Interest TotalS 2. They also borrowed $12,000 from Farm Credit Services to buy some sows. They agreed to pay it back with 3 annual payments, plus 8% interest on the remaining loan balance. If...

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