Question

In: Finance

Consider a 4-year amortizing loan. You borrow $2,700 initially and repay it in four equal annual...

Consider a 4-year amortizing loan. You borrow $2,700 initially and repay it in four equal annual year-end payments.

a.

If the interest rate is 10%, what is the annual payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

  Annual payment $   
b.

Prepare an amortization schedule. (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.)

Time Loan Balance, $ Year-End Interest Due on Loan Balance, $ Total Year-End Payment, $ Amortization of Loan, $
1
2
3
4
5

Solutions

Expert Solution

a. Annual payment = Loan amount / Present value of annuity of 1
= $       2,700.00 /    3.16987
= $           851.77
Working:
Present value of annuity of 1 = (1-(1+i)^-n)/i Where,
= (1-(1+0.10)^-4)/0.10 i 10%
=             3.16987 n 4
b. Amortization Schedule:
Time Loan Balance (1) Year-End Interest Due on Loan Balance (2)=(1)*10% Total Year-End Payment (3) Amortization of Loan (4)=(3)-(2)
1 $ 2,700.00 $ 270.00 $ 851.77 $           581.77
2 $ 2,118.23 $ 211.82 $ 851.77 $           639.95
3 $ 1,478.28 $ 147.83 $ 851.77 $           703.94
4 $     774.34 $    77.43 $ 851.77 $           774.34

Related Solutions

Consider a 4-year amortizing loan. You borrow $2,900 initially and repay it in four equal annual...
Consider a 4-year amortizing loan. You borrow $2,900 initially and repay it in four equal annual year-end payments. a. If the interest rate is 9%, what is the annual payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. Prepare an amortization schedule. (Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.)
You borrow $42,000 and repay the loan with 6 equal annual payments. The first payment occurs...
You borrow $42,000 and repay the loan with 6 equal annual payments. The first payment occurs one year after receipt of the $42,000 and you pay 8% annual compound interest. a)Solve for the payment size. b)What is the payment size when interest is 8% compounded monthly, and monthly payments are made over 6 years? c)What is the payment size when interest is 8% compounded semiannually, and annual payments are made over 6 years? d)What is the payment size when the...
Your sibling wants to borrow money from you that she can repay in four equal annual...
Your sibling wants to borrow money from you that she can repay in four equal annual payments of $1,000 at the end of each of the next four years. If you charge 3% interest rate on the loan to your sibling, and that is the competitive interest rate, what would be the amount that you can lend to her today? Group of answer choices $ 3,717.10 $ 3,828.61 $ 3,956.72 $ 4,310.13 $ 3,,549.95 $ 3,289.55
Equal annual instalments required to repay a loan in 3 years.
A sum of Rs.6000 is borrowed at 10% pa compounded interest and paid back in three equal annual instalments. What is the approximate amount of each instalment?
If you borrow $20,000, you have to repay in equal instalments over four years. Interest Rate...
If you borrow $20,000, you have to repay in equal instalments over four years. Interest Rate is 9%. What is the interest payment in the fourth year, 14. a) 1499 b)1171 c)510 d)977 e)1406 f)814
Suppose you plan to borrow $300,000 from a financial institution and you are required to repay the loan by making equal annual payments for five years (payment at the end of each year).
  Suppose you plan to borrow $300,000 from a financial institution and you are required to repay the loan by making equal annual payments for five years (payment at the end of each year). The interest rate for the loan is 3.5% per year. Show your answers correct to two decimal points. Calculate the annual payment required. Prepare an amortization schedule for the loan for each year according to the following format. Year Beginning balance Annual payment Interest paid Principal...
If you borrow a principal amount of $11,778 and are required to repay the loan in...
If you borrow a principal amount of $11,778 and are required to repay the loan in ten equal installments of $2,000, what is the interest rate associated with the loan?
Chad borrows $75,000 and agrees to repay the loan in five equal annual installments. The loan's...
Chad borrows $75,000 and agrees to repay the loan in five equal annual installments. The loan's interest rate is 6.75 percent. What is his loan's balance after making the third payment?
You want to borrow $25,000. For the loan to be paid off, youmust repay $1000...
You want to borrow $25,000. For the loan to be paid off, you must repay $1000 every quarter (4 times per year) for the next 7 years plus $7000 at the end of the 7 years. Based on this, what rate of interest are you paying?
You borrow $80,000 at 5.00% per year and will pay off the loan in equal payments...
You borrow $80,000 at 5.00% per year and will pay off the loan in equal payments starting one year after the loan is made over a period of ten years. What are the annual end-of-year payments? Determine the amount of interest and principal that are paid each year. What is the total interest paid for the loan? If you are using the excel please show me the code or equation to do it myself
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT