Question

In: Finance

An auto repair shop borrowed $15,000 to be repaid by quarterly payments over 4 years. Interest...

An auto repair shop borrowed $15,000

to be repaid by quarterly

payments over 4 years. Interest on the loan is 3%

compounded quarterly.

(a) What is the size of the periodic payment?

(b) What is the outstanding principal after payment

10?

(c) What is the interest paid on payment

11?

(d) How much principal is repaid in payment

11?

Could you please show full steps as i want to use this as a learning tool.

Solutions

Expert Solution

(a) Size of periodic payment $     998.38
Working:
Size of periodic payment =-pmt(rate,nper,pv,fv)
= $     998.38
Where,
rate = 3%/4 = 0.0075
nper = 4*4 = 16
pv = $       15,000
fv = 0
(b) Principal balance after payment 10 =PV(rate,nper,pmt,fv)
= $ 5,836.14
Working:
Where,
rate = 3%/4 = 0.0075
nper = 16-10 = 6
pmt = $     -998.38
fv = 0
(c) Interest paid on payment 11 $       43.77
Working:
Interest paid on payment 11 = Loan Balance after payment 10 * Quarterly interest rate
= $ 5,836.14 * 0.0075
= $       43.77
(d) Principal repaid in payment 11 $     954.61
Working:
Principal repaid in payment 11 = Payment 11 - Interest paid in payment 11
= $     998.38 - $         43.77
= $     954.61

Related Solutions

3. Leo’s Auto Repairs Inc. borrowed $5500 to be repaid by end-of-month payments over four years....
3. Leo’s Auto Repairs Inc. borrowed $5500 to be repaid by end-of-month payments over four years. Interest on the loan is 9% compounded monthly. What is the size of the periodic payment? What is the outstanding principal after the 13th payment? What is the interest paid in the 14th payment? How much principal is repaid in the 14th payment? 4. To start their business, Ming and Ling borrowed $24 000 to be repaid by semi-annual payments over 12 years. Interest...
The Company borrowed $266,779 at 8.51 % to be repaid quarterly over 30 years. They just...
The Company borrowed $266,779 at 8.51 % to be repaid quarterly over 30 years. They just remitted payment number 74. How much interest did the bank receive in year 3
Joan Messineo borrowed $15,000 at a 14% annual rate of interest to be repaid over 3...
Joan Messineo borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual, end-of-year payments. (i) Calculate the annual, end-of-year loan payment. (ii) Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. (iii) Explain why the interest portion of each payment declines with the passage of time.
The Company borrowed $206,116  at 7.89 % to be repaid quarterly over 30 years. They just remitted...
The Company borrowed $206,116  at 7.89 % to be repaid quarterly over 30 years. They just remitted payment number 74. How much interest did the bank receive in year 3?
Suppose you borrowed $32,000 for 4 years with quarterly payments at an APR of 6%. What...
Suppose you borrowed $32,000 for 4 years with quarterly payments at an APR of 6%. What is the quarterly payment? (ordinary annuity) PLEASE SHOW WORK USING FORMULAS *NOT through excel or financial calulator Amortize the first four payments. Use the table below: (Payment number) (Payment) (Interest) (Prinicipal) (Remaining Balance) 1 _______ _______ _______ ________ 2 _______ _______ ________ ________ 3 _______ _______ _______ _________ 4 _______ ________ _______ __________ How much in interest will you pay over the life of...
A debt of $30000 with interest at 9.75% compounded quarterly is to repaid by equal payments...
A debt of $30000 with interest at 9.75% compounded quarterly is to repaid by equal payments at the end of each year for 7 years. what is the size of annual payment also construct a payment schedule.
A debt of ​$38000 is repaid over 15 years with payments occurring semi-annually. Interest is 6...
A debt of ​$38000 is repaid over 15 years with payments occurring semi-annually. Interest is 6 % compounded monthly.monthly. ​(a) What is the size of the periodic​ payment? ​(b) What is the outstanding principal after payment 24​? ​(c) What is the interest paid on payment 25​? ​(d) How much principal is repaid in payment 25​?
$5,000 are borrowed now with the understanding that it will be repaid in equal monthly payments over 24 months
$5,000 are borrowed now with the understanding that it will be repaid in equal monthly payments over 24 months, if the interest rate is 1% per month, for payment number 6 find the amount that is due to principal? Your answer might be exact or to the closest.a. $833.33b. $194.83c. -540.54d. $40.54
$5000 is borrowed, to be repaid in three equal, annual payments with 10% interest. Approximately how...
$5000 is borrowed, to be repaid in three equal, annual payments with 10% interest. Approximately how much principal is amortized with the second payment? $2,010.57 $1,510.57 $900.68 $1,661.63 include calculations please
A debt of $6,500.00 is repaid in equal monthly installments over 4 years. The interest rate...
A debt of $6,500.00 is repaid in equal monthly installments over 4 years. The interest rate is 9% and compounded monthly. a. What is the size of the monthly payment? b. What will be the total cost of borrowing? c. What is the outstanding balance after 1 years? d. How much is the 30th payment is interest? P.S. i need a detailed answer please.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT