Question

Question 5 (of 35) Save & Exit Submit Time remaining: 2.51:03 8.00 points Problem 5-55 Amortization with Equal Payments (LO 3

i dont think those answers are correct and i am trying to find the total interest
0 0
Add a comment Improve this question Transcribed image text
Answer #1

DE $81,000 Loan Amount Rate Years Payment 8% 3 $31,430.71 Yea Beginning Balance $81,000 $56,049 $29,103 Total Interest Princi81000 0.08 nm + Loan Amount Rate Years Payment =PMT(C2,C3,-C1) 6 Years 7 1 82 9 3 10 11 Beginning Balance =C1 =F7 =F8 Total P

Add a comment
Know the answer?
Add Answer to:
i dont think those answers are correct and i am trying to find the total interest...
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
  • Prepare an amortization schedule for a three-year loan of $15,000. The interest rate is 10 percent...

    Prepare an amortization schedule for a three-year loan of $15,000. The interest rate is 10 percent per year and the loan calls for equal annual end-of-year payments (Enter rounded answers as directed, but do not use rounded numbers in intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16). Leave no cells blank. You must enter '0' for the answer to grade correctly) Beginning Balance Total Interest Principal Payment Ending Balance Year Payment Payment 1 S 2 3

  • All answers must be entererd as formulas CHAPTER 5 Saved Help Save & Exit Submit Paste B I U. . Font Editing ....

    All answers must be entererd as formulas CHAPTER 5 Saved Help Save & Exit Submit Paste B I U. . Font Editing . A . Alignment Number Conditional Format as Cell - Formatting Table Styles Styles Cells . Clipboard 5 Prepare an amortization schedule for a five-year loan of $67,500. The interest rate is 7 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? Loan amount...

  • repare an amortization schedule for a five-year loan of $45,000. The interest rate is 8% per...

    repare an amortization schedule for a five-year loan of $45,000. The interest rate is 8% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $ $ $ $ $ 2 3 4 5 How much interest...

  • Prepare an amortization schedule for a five-year loan of $33,000. The interest rate is 9% per...

    Prepare an amortization schedule for a five-year loan of $33,000. The interest rate is 9% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Beginning Balance $ Total Payment $ Interest Payment $ Principal Payment $ Year Ending Balance $ 2 3 4 5 How much interest is...

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

  • Prepare an amortization schedule for a five-year loan of $38,000. The interest rate is 7% per...

    Prepare an amortization schedule for a five-year loan of $38,000. The interest rate is 7% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Beginning Total Payment Interest Payment Principal Payment Ending Balance Year Balance Nm in How much interest is paid in the third year? (Do not...

  • Crab State Bank has offered you a $500,000 5-year loan at an interest rate of 9.25...

    Crab State Bank has offered you a $500,000 5-year loan at an interest rate of 9.25 percent, requiring equal annual end-of-year payments that include both principal and interest on the unpaid balance. Develop an amortization schedule for this loan. Round your answers to the nearest dollar. Do not round intermediate calculations. End of Year Payment Interest (9.25%) Principal Reduction Balance Remaining 0 - - - $500,000 1 $   $   $        2                     3               ...

  • sorry for the amount of photos i wanted to make sure the question and its parts...

    sorry for the amount of photos i wanted to make sure the question and its parts were clear. im having trouble with this question, could someone find the answers and explain how they got them? Thanks! a. Complete an amortization schedule for a $26,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. Beginning Balance Repayment of Principal...

  • Prepare an amortization schedule for a five-year loan of $34,000. The interest rate is 8% per...

    Prepare an amortization schedule for a five-year loan of $34,000. The interest rate is 8% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank.be certain to enter "0" wherever required.) Beginning Total Interest Principal Ending Balance Payment Payment Balance 31000 2720 Payment Year 1 2 $ 3 4 5 How much interest is paid in the...

  • I did the work. Please check my answers. Thank you. Question 9 Loan amount Interest rate...

    I did the work. Please check my answers. Thank you. Question 9 Loan amount Interest rate Number of years 120,000 9.00% 10.00 Please just check my answers. Thank you. Equal Payments $18,698.41 Generate the Loan amortization table with equal payment. Years Beginning Total Interest Principal Ending Balance Payment Paid Payment Balance $ 120,000.00 $ 18,698.41 $ 10,800.00 $ 7,898.41 $ 112,101.59 $ 112,101.59 $ 18,698.41 $ 10,089.14 $ 8,609.27 $ 10 $ 103,492.32 $ 18,698.41 $ 9,314.31 $ 9,384.10 $...

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