Set up an amortization schedule for a $25,000 loan to be repaid (answer attached) - 14439

Solution Posted by
Solution Detail
Price: $12.00
  • From: Business,
  • Posted on: Fri 19 Oct, 2012
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description

 

Set up an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of the next 5 years. The interest rate is 10% compounded annually.

A. I need to set up an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of the next 5 years.  The interest rate is 10% compounded annually.  b. How large must each annual payment be if the loan is for $50,000?  Assume that the interst rate remains at 10%, compounded annually, and that the loan is paid off over 5 years.  c. How large must each payment be if the loan is for $50,000, the interest rate is 10%, compounded annually, and the loan is paid off in equal installments at the end of each of the next 10 years?  This loan is for the same amount as the loan in part b, but the payments are spread out over twice as many periods.  Why are these payments not half as large as the payments on the loan in part b?

Solution Description

 

Set up an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of the next 5 years. The interest rate is 10% compounded annually.

A. I need to set up an a

Attachments
Solution.xls
Solution.xls