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.

Expert Solution

The payment frequency and compounding frequency are not the same i.e. payment is made annually whereas the interest rate is compounded quarterly, we have to find the effective annual rate.

The size of the annual payment is found using the following equation

Annual payment = $ 6184.5

--------------------------------------------------------------------------------------

The payment schedule can be constructed using excel.

Interest = 0.1011 Beginning balance

Principal paid = Annual payment - interest

Ending balance = Beginning balance - principal paid

The formulas used in the cell is shown below

ekkarill92 answered 2 years ago

11) A debt of $10,000 with interest at 8% compounded quarterly is to be repaid by...

11) A debt of $10,000 with interest at 8% compounded quarterly is to be repaid by equal payments at the end of every six months for two years. a) Calculate the size of the semi-annual payments. b) Construct an amortization table for the complete 2 years with dollar amounts to two decimal places i.e. include the pennies. Round your semi-annual payment to the next higher dollar. If you did not get an answer to part a), assume a debt of...

A debt of $10 000.00 with interest at 8% compounded quarterly is to be repaid by...

A debt of $10 000.00 with interest at 8% compounded quarterly is to be repaid by equal payments at the end of every three months for two years. a) Calculate the size of the monthly payments. b) Construct an amortization table. c) Calculate the outstanding balance after three payments. Amortization Table Payment Number Amount Paid Interest Paid Principal Repaid Outstanding Principal Balance 0 1 2 3 4 5 6 7 8 Barbara borrowed $12 000.00 from the bank at...

A debt of $42000 is repaid by making payments of $4500. If interest is 9% compounded...

A debt of $42000 is repaid by making payments of $4500. If interest is 9% compounded monthly, for how long will payments have to be made at the end of every six months? b) What payment made at the end of each year for 18 years will amount to $48000 at 4.2% compounded monthly?

A 25-year, $435,000 mortgage at 4.10% compounded quarterly is repaid with monthly payments. a. What is...

A 25-year, $435,000 mortgage at 4.10% compounded quarterly is repaid with monthly payments. a. What is the size of the monthly payments? b. Find the balance of the mortgage at the end of 6 years? c. By how much did the amortization period shorten by if the monthly payments are increased by $100 at the end of year six?

The interest rate on a $100,000 loan is 7.5% compounded quarterly. What quarterly payments will reduce...

The interest rate on a $100,000 loan is 7.5% compounded quarterly. What quarterly payments will reduce the balance to $75,000 after five years? (Do not round intermediate calculations and round your final answer to 2 decimal places.)

You borrow $2000 at 4% annual interest compounded quarterly, to be paid off with equal quarterly...

You borrow $2000 at 4% annual interest compounded quarterly, to be paid off with equal quarterly payments. Your first payment will be one year from now, and your last payment will be nine years from now. What will your payments be?

A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over...

A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over 10 years. a) What will be the principal component of the sixth payment? b) What will be the interest component of the sixteenth payment? c) How much will Payments 6 to 15 inclusive reduce the principal? d) How much interest will be paid in the third year? e) What will be the final payment?

Gary borrows 150,000 with interest at 15% compounded quarterly. How many 9,500 quarterly payments are required?...

Gary borrows 150,000 with interest at 15% compounded quarterly. How many 9,500 quarterly payments are required? Show complete solution

Jia borrows $50,000 at 10 percent annually compounded interest to be repaid in four equal annual...

Jia borrows $50,000 at 10 percent annually compounded interest to be repaid in four equal annual installments. The actual end-of-year loan payment is

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.

Question