Question

In: Finance

You take out a loan in the amount of $260,000 with annual equal repayments over the...

You take out a loan in the amount of $260,000 with annual equal repayments over the next 20years. What is the balance of the loan after the 5th payment? i = 6%

Solutions

Expert Solution

Step-1:Calculation of annual repayment
Annual repayment = Loan amount / Present value of annuity of 1
= $ 2,60,000.00 / 11.46992
= $     22,667.98
Working:
Present value of annuity of 1 = (1-(1+i)^-n)/i Where,
= (1-(1+0.06)^-20)/0.06 i 6%
= 11.46992122 n 20
Step-2:Calculation of loan balance after 5th payment
Loan amount is always present value of annual repayment discounted at interest rate.
So, loan balance after 5th payment = Present value of remaining 15 annual repayment
= Annual payment * Present value of annuity of 1
= $     22,667.98 * 9.712249
= $ 2,20,157.11
Working:
Present value of annuity of 1 = (1-(1+i)^-n)/i Where,
= (1-(1+0.06)^-15)/0.06 i 6%
= 9.712248988 n 15

Related Solutions

Nikita takes out a 10-year loan. The loan is repaid by making 10 annual repayments at...
Nikita takes out a 10-year loan. The loan is repaid by making 10 annual repayments at the end of each year. The first loan repayment is equal to X, with each subsequent repayment 10.16% greater than the previous year’s repayment. The annual effective interest rate being charged on the loan is 8%. The amount of interest repaid during the first year is equal to 892.20. Calculate X. a.1100 b.1150 c.1200 d.1250 e.1300
You take out a loan in the amount of $14,000 to buy a Kia Soul. The...
You take out a loan in the amount of $14,000 to buy a Kia Soul. The bank offers you a 3 year loan with an APR of 2.9%.     a. Create an amortization table. Paste the first five or six lines in your Word document.     b. What is the total amount you end up paying (including principal and interest)? (Hint: You can just add the payment column.)
1. You take out a $20,000, ten-year loan. Equal payments are to be made at the...
1. You take out a $20,000, ten-year loan. Equal payments are to be made at the end of each year at an interest rate of 10%. Calculate the appropriate loan table, showing the breakdown in each year between principal and interest. Cost 20,000 Payment $3,254.91 Interest 10% Years 10 Division of payment between: Year Principal at beginning of year Payment at end of year Interest Principal 1 2 3 4 5 6 7 8 9 10 0.00
If you take out a car loan for $35,000, will pay an annual interest rate of...
If you take out a car loan for $35,000, will pay an annual interest rate of 4% on the loan, and make monthly payments of $547.58, how many payments will you need to make? -What are you solving for? -What is your answer?
A loan of $100,000 is to be repaid by two equal repayments of X. One repayment...
A loan of $100,000 is to be repaid by two equal repayments of X. One repayment is due at the end of 2 years, the second repayment is due at the end of 6 years. The interest rate is at 4% p.a. compounded quarterly for the first 3 years and then 4.4% p.a. compounded quarterly thereafter. What is the size of each repayment? Select one: a. $58,762.97 b. $58,222.14 c. $57,989.46 d. $56,779.19
Fiona takes out a $400 000 home loan over 30 years. Her monthly repayments are set...
Fiona takes out a $400 000 home loan over 30 years. Her monthly repayments are set at $2171.80. a) Find the annual interest rate, compounded monthly (express answer in % to 2 decimal places). [3] b) Find the outstanding balance of the loan after 10 years. [3] c) After 10 years, Fiona transfers the remainder of the loan to a bank charging 4.73% p.a. interest compounded monthly. Assume that the term of the loan remains 30 years. (i) Calculate the...
You take out a 15-year $335,000 mortgage loan with a rate of 6% and annual payments....
You take out a 15-year $335,000 mortgage loan with a rate of 6% and annual payments. In 6 years you decide to pay off the mortgage. What is the principal balance on the loan after 6 years?
You take out a 40 year loan with effective annual interest i = .05 and yearly...
You take out a 40 year loan with effective annual interest i = .05 and yearly payments at the end of each year being $10, 000 for the first 20 years, and then $15, 000 for the next 20 years. Find the outstanding balance after the fourth payment. Also find the outstanding balance after the 37th payment.
You take out a 40 year loan with effective annual interest i = 5% and yearly...
You take out a 40 year loan with effective annual interest i = 5% and yearly payments at the end of each year being $10,000 for the first 20 years, and then $15,000 for the next 20 years. Find the outstanding balance after the fourth payment. Also find the outstanding balance after the 37th payment.
A loan of $100,000 is made today. The borrower will make equal repayments of $918 per...
A loan of $100,000 is made today. The borrower will make equal repayments of $918 per month with the first payment being exactly one month from today. The interest being charged on this loan is constant (but unknown). For the following two scenarios (EXCEL HIGHLY REGARDED), calculate the interest rate being charged on this loan, expressed as a nominal annual rate compounding monthly. Give your answer as a percentage to 2 decimal places. (a) The loan is fully repaid exactly...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT