Question

In: Finance

How long will it take payment of $500 per quarter to amortize a loan of $8,000...

How long will it take payment of $500 per quarter to amortize a loan of $8,000 at 16% compounded quarterly? Approximate your answer in terms of years and months. How much less time will it take if loan payments are made at the beginning of each quarter rather that at the end?

Solutions

Expert Solution

Formula for PV of annuity can be used to compute required number of periods as:

PV = P x [1 – (1+r)-n]/r

PV = Present value of loan = $ 8,000

P = Periodic payment = $ 500

r = Rate per period = 16 % p.a. or 0.16/4 = 0.04 p. q.

n = Number of periods

$ 8,000 = $ 500 x / [1 – (1+0.04)-n]/0.04

   = $ 500 x [1 – (1.04)-n]/0.04

$ 8,000 / $ 500 = [1 – (1.04)-n]/0.04

[1 – (1.04)-n]/0.04 = 16

1 – (1.04)-n = 16 x 0.04 = 0.64

(1.04)-n = 1 – 0.64

(1.04)-n = 0.36

Taking log of both sides and solving for n, we get:

-n log 1.04 = log 0.36

-n x 0.0170333392988= -0.443697499233

n = 0.443697499233/0.0170333392988

   = 26.04876774 periods or 6 years 6.15 months

It will take 6 years 6.15 months to pay off the loan.

Formula for PV of annuity due can be used to compute required number of periods if payments are made at the beginning of periods.

PV = P + P [1 – (1+r)-n-1/r]

$ 8,000 = $ 500 + $ 500 [ 1 – (1+0.04)1-n/0.04]

$ 8,000 - $ 500 = $ 500 [ 1 – (1.04)1-n/0.04]

$ 7,500 = $ 500 [ 1 – (1.04)1-n/0.04]

15 = 1 – (1.04)1-n/0.04

1 – (1.04)1-n = 15 x 0.04 = 0.6

(1.04)1-n = 1 – 0.6

(1.04)1-n = 0.4

Taking log of both sides and solving for n, we get:

1-n x log 1.04 = log 0.4

1-n x 0.0170333392988 = -0.397940008672

n -1 = 0.397940008672/0.0170333392988

n – 1 = 23.36241894

n = 23.36241894 + 1 = 24.36241894 periods or 6 years 1.09 months

It will take 6 years 1.09 months to pay off the loan if payments are made at the beginning of periods.

Time difference = 26.04876774 - 24.36241894 = 1.686348799 periods

= 5.059046396 months or 5.06 months

It will take 5.06 months less time if payments are made at the beginning of periods.


Related Solutions

What is the monthly payment required to fulling amortize a $300,000 mortgage loan over a 30...
What is the monthly payment required to fulling amortize a $300,000 mortgage loan over a 30 years at an intrest rate of 3.5% annual rate compound monthly? $1,244 $1,367 $1,482 $1,390 $1,344
Sec 5.4 -find the payment necessary to amortize a 12% loan of $2100 compounded quarterly with...
Sec 5.4 -find the payment necessary to amortize a 12% loan of $2100 compounded quarterly with 15 quarterly payments -find the monthly house payments necessary to amortize a 10.8% loan of 162,200 over 25 years -find the payment made by ordinary annuity with the present value. -77,822; monthly payments for 24 years; interest rate 4.3%, compounded monthly -287,938; quarterly payments for 29 years; interest rate 6%, compounded quarterly
25. The annual payment necessary to amortize (pay off) a 5% $200,000 loan with a 20...
25. The annual payment necessary to amortize (pay off) a 5% $200,000 loan with a 20 year repayment period (annual end of year payments required) is   __________________ 26. A prospective new creditor (a vendor for materials purchases) is evaluating financial ratios for ABC Company. The creditor is likely most interested in the __________ ratios a. inventory management related b. return on equity related c. return on assets related d. liquidity related 27. ABC Inc. signs a note payable in the...
5. How long will it take $5,000 to become $8,000 when the $5,000 grows at 9.5...
5. How long will it take $5,000 to become $8,000 when the $5,000 grows at 9.5 percent per year? Group of answer choices A. 6.26 years B. 6.11 years C. 5.18 years D. 5.79 years E. 5.35 years
1. Amortize a $125,000 (Sale Price) house with 20% down payment on a 15 year loan...
1. Amortize a $125,000 (Sale Price) house with 20% down payment on a 15 year loan at 3.0% annual interest rate (1) What is the monthly payment? (2) What month will the debt be less than $50,000? (Assume that you just took out the loan) (3) How much will you pay in interest over the life of the loan?
Find the periodic payment R required to amortize a loan of P dollars over t years...
Find the periodic payment R required to amortize a loan of P dollars over t years with interest charged at the rate of r%/year compounded m times a year. (Round your answer to the nearest cent.) a. P = 50,000, r = 4, t = 15, m = 4 b. P = 90,000, r = 3.5, t = 17, m = 12' c. P = 120,000, r = 5.5, t = 29, m = 4
How long will it take to pay off a loan of ​$54,000 at an annual rate...
How long will it take to pay off a loan of ​$54,000 at an annual rate of 11 percent compounded monthly if you make monthly payments of ​$750​? Use five decimal places for the monthly percentage rate in your calculations.
How long will it take monthly payments of $600 to repay a $65,000 loan if the...
How long will it take monthly payments of $600 to repay a $65,000 loan if the interest rate on the loan is 9.5% compounded semiannually? How much will the time to repay the loan be reduced if the payments are $50 more per month?
How long will it take to pay off a loan of ​$52,000 at an annual rate...
How long will it take to pay off a loan of ​$52,000 at an annual rate of 12 percent compounded monthly if you make monthly payments of ​$750​? Use five decimal places for the monthly percentage rate in your calculations. The number of years it takes to pay off the loan is ____ years. (Round to one decimal​ place.)
How long will it take to pay off a loan of $45,000 at an annual rate...
How long will it take to pay off a loan of $45,000 at an annual rate of 8 percent compounded monthly if you make monthly payments of $600? Use five decimal places for the monthly percentage rate in your calculations.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT