Question

In: Finance

Consider a $30,000 loan to be repaid in equal installments at the end of each of...

Consider a $30,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 6%.

  1. Set up an amortization schedule for the loan. Do not round intermediate calculations. Round your answers to the nearest cent. If your answer is zero, enter "0".

    Year Payment Repayment Interest Repayment of Principal Balance
    1 $   $   $   $  
    2 $   $   $   $  
    3 $   $   $   $  
    4 $   $   $   $  
    5 $   $   $   $  
    Total $   $   $  
  2. How large must each annual payment be if the loan is for $60,000? Assume that the interest rate remains at 6% and that the loan is still paid off over 5 years. Do not round intermediate calculations. Round your answer to the nearest cent.

    $  

  3. How large must each payment be if the loan is for $60,000, the interest rate is 6%, 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. Do not round intermediate calculations. Round your answer to the nearest cent.

    $  

    Why are these payments not half as large as the payments on the loan in part b?

    I. Because the payments are spread out over a longer time period, less interest is paid on the loan, which lowers the amount of each payment.
    II. Because the payments are spread out over a shorter time period, more interest is paid on the loan, which lowers the amount of each payment.
    III. Because the payments are spread out over a longer time period, more interest must be paid on the loan, which raises the amount of each payment.
    IV. Because the payments are spread out over a longer time period, more principal must be paid on the loan, which raises the amount of each payment.
    V. Because the payments are spread out over a longer time period, less interest is paid on the loan, which raises the amount of each payment.

Solutions

Expert Solution

Annual Payment = Amount of Loan/Present value annuity factor
=30,000/PVAF(6%, 5 years)
=30,000/4.212364
=$7121.89
Amortization Schedule
Year Beginning Balance Payment Repayment Interest Repayment of Principal Balance
1 30,000.00     7,121.89                     1,800.00                           5,321.89 24,678.11
2 24,678.11     7,121.89                     1,480.69                           5,641.20 19,036.91
3 19,036.91     7,121.89                     1,142.21                           5,979.68 13,057.23
4 13,057.23     7,121.89                        783.43                           6,338.46     6,718.77
5     6,718.77     7,121.89                        403.13                           6,718.76             0.01
Total 35,609.45                     5,609.46                         29,999.99
b.Annual payment = 60,000/4.212364 = $14,243.78
c.Payment = 60,000/PVAF(6%, 10 periods)
=$8152.08
III. Because the payments are spread out over a longer time period, more interest must be paid on the loan, which raises the amount of each payment.

Related Solutions

Amortization Schedule Consider a $30,000 loan to be repaid in equal installments at the end of...
Amortization Schedule Consider a $30,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 6%. Set up an amortization schedule for the loan. Round your answers to the nearest cent. Enter "0" if required Year Payment Repayment Interest Repayment of Principal Balance 1 $   $   $   $   2 $   $   $   $   3 $   $   $   $   4 $   $   $   $   5 $   $   $   $   Total...
Consider a $35,000 loan to be repaid in equal installments at the end of each of...
Consider a $35,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 6%. Set up an amortization schedule for the loan. Round your answers to the nearest cent. Enter "0" if required Year Payment Repayment Interest Repayment of Principal Balance 1 $   $   $   $   2 $   $   $   $   3 $   $   $   $   4 $   $   $   $   5 $   $   $   $   Total $   $  ...
Consider a $50,000 loan to be repaid in equal installments at the end of each of...
Consider a $50,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 10%. Set up an amortization schedule for the loan. Round your answers to the nearest cent. Enter "0" if required Year Payment Repayment Interest Repayment of Principal Balance 1 $    $    $    $    2 $    $    $    $    3 $    $    $    $    4 $    $    $    $    5 $    $    $    $    Total $    $   ...
Consider a loan for $100,000 to be repaid in equal installments at the end of each...
Consider a loan for $100,000 to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 6% compounded annually. What is the remaining balance of the loan after 2 years?
Consider a loan for $100,000 to be repaid in equal installments at the end of each...
Consider a loan for $100,000 to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 5% compounded annually. What is the remaining balance of the loan after 2 years ? $62,900 $76,903 $62,336 $23,097 $53,805
Consider a loan for $100,000 to be repaid in equal installments at the end of each...
Consider a loan for $100,000 to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 7% compounded annually. What is the remaining balance of the loan after 2 years? $63,456 $24,389 $64,005 $75,611 $51,222
Amortization Schedule Consider a $15,000 loan to be repaid in equal installments at the end of...
Amortization Schedule Consider a $15,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 7%. Set up an amortization schedule for the loan. Do not round intermediate calculations. Round your answers to the nearest cent. If your answer is zero, enter "0". Year Payment Repayment Interest Repayment of Principal Balance 1 $   $   $   $   2 $   $   $   $   3 $   $   $   $   4 $   $  ...
Set up an amortization schedule a $30,000 loan to be repaid in equal installments at the...
Set up an amortization schedule a $30,000 loan to be repaid in equal installments at the next 3 years. The interest rate is 8% compounded semiannually a) amortize loan with fixed principal payment b) amortized loan with fixed payment
Set up an amortization schedule for a $30,000 loan to be repaid in equal installments at...
Set up an amortization schedule for a $30,000 loan to be repaid in equal installments at the end of each of the next 20 years at an interest rate of 10 percent. What is the annual payment?
A loan of 100,000 is being repaid by 15 equal installments made at the end of...
A loan of 100,000 is being repaid by 15 equal installments made at the end of each year at 6% interest effective annually. Immediately after the eighth payment, the loan is renegotiated as follows: (i) The borrower will make seven annual payments of K to repay the loan, with the first payment made three years from the date of renegotiation. (ii) The interest rate is changed from 7.5% effective annually. Calculate K (do not use excel) (A) 11,068 (B) 11,666...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT