123k views
2 votes
marpole carpet cleaning borrowed $7600 from richmond credit union at 8% compounded quarterly. the loan is to be repaid by equal quarterly payments over a two-year term. construct the amortization schedule for the loan.

1 Answer

4 votes

Final Answer:

1. The quarterly payment for Marpole Carpet Cleaning's $7,600 loan at 8% compounded quarterly over a two-year term is approximately $1,064.94.

2. The amortization schedule includes eight payments, detailing interest paid, principal paid, and remaining balance for each quarter.

3. The final payment reduces the remaining balance to $0, completing the repayment of the loan.

Step-by-step explanation:

To construct the amortization schedule for the loan, we can use the loan amortization formula:


\[ P = (r \cdot PV)/(1 - (1 + r)^(-nt)) \]

where:

( P ) is the quarterly payment,

( r ) is the quarterly interest rate,

( PV ) is the present value of the loan,

( n ) is the total number of payments (in quarters), and

( t ) is the loan term in years.

First, let's calculate the quarterly interest rate ( r ):


\[ r = \frac{\text{Annual Interest Rate}}{4 * 100} \]

In this case, the annual interest rate is 8%, so
\( r = (8)/(4 * 100) = 0.02 \).

Now, let's calculate the total number of payments (\( n \)):

Since the loan term is two years, and payments are made quarterly, \( n = 2 \times 4 = 8 \).

The present value of the loan
(\( PV \)) is $7,600.

Now, we can substitute these values into the amortization formula to calculate the quarterly payment ( P ):


\[ P = (0.02 * 7600)/(1 - (1 + 0.02)^(-8)) \]

Now, let's calculate ( P ):


\[ P = (152)/(1 - (1.02)^(-8)) \]


\[ P = (152)/(1 - 0.85734) \]


\[ P = (152)/(0.14266) \]


\[ P \approx 1064.94 \]

So, the quarterly payment ( P ) is approximately $1,064.94.

Now, let's construct the amortization schedule. The schedule will include columns for the payment number, the remaining balance, the interest paid, the principal paid, and the total payment.

| Payment # | Remaining Balance | Interest Paid | Principal Paid | Total Payment

| 1 | $7,600.00 | $152.00 | $912.94 | $1,064.94 |

| 2 | ... | ... | ... | ... |

| 3 | ... | ... | ... | ... |

| ... | ... | ... | ... | ... |

| 8 | $0.00 | ... | ... | ... |

For each payment, you can calculate the interest paid, principal paid, and the remaining balance using the appropriate formulas. The interest paid is calculated as the remaining balance multiplied by the quarterly interest rate, and the principal paid is the difference between the total payment and the interest paid. Update the remaining balance accordingly for each payment.

User Tobiq
by
7.9k points