Dr. Alvano borrowed $8000 at 8% compounded quarterly to purchase a new X-Ray machine for his clinic. The agreement requires quarterly payments during a two-year amortization period. Suppose that the loan permits an additional prepayment of principal on any scheduled payment date. Prepare an amortization schedule that reflects a prepayment of $1500 with the third scheduled payment.

Question

Quizplus · Accepted Answer

The Answer is To prepare an amortization schedule for Dr. Alvano's loan, we need to calculate the regular quarterly payment first and then adjust the schedule to reflect the additional prepayment of $1500 with the third scheduled payment.

The loan details are as follows:
- Principal (P): $8000
- Annual interest rate (r): 8% or 0.08
- Compounding frequency: Quarterly
- Amortization period: 2 years (or 8 quarters)

The formula to calculate the regular quarterly payment (R) is given by the annuity formula for compounded interest:

R = P * [i / (1 - (1 + i)^(-n))]

Where:
- i is the quarterly interest rate (annual rate divided by the number of compounding periods per year)
- n is the total number of payments (amortization period in quarters)

First, let's calculate the quarterly interest rate and the total number of payments:

i = 0.08 / 4 = 0.02 (2% per quarter)
n = 2 * 4 = 8 quarters

Now, we can calculate the regular quarterly payment (R):

R = 8000 * [0.02 / (1 - (1 + 0.02)^(-8))]
R = 8000 * [0.02 / (1 - 1.02^(-8))]
R = 8000 * [0.02 / (1 - 0.8535)]
R = 8000 * [0.02 / 0.1465]
R = 8000 * 0.1365
R = 1092.04 (rounded to two decimal places)

Dr. Alvano's regular quarterly payment is approximately $1092.04.

Now, let's prepare the amortization schedule. We'll calculate the interest and principal components of each payment and adjust the third payment to include the additional $1500 prepayment.

| Payment # | Beginning Balance | Payment | Interest | Principal | Additional Prepayment | Ending Balance |
|-----------|-------------------|---------|----------|-----------|-----------------------|----------------|
| 1 | $8000.00 | $1092.04| $160.00 | $932.04 | $0.00 | $7067.96 |
| 2 | $7067.96 | $1092.04| $141.36 | $950.68 | $0.00 | $6117.28 |
| 3 | $6117.28 | $1092.04| $122.35 | $969.69 | $1500.00 | $3647.59 |
| 4 | $3647.59 | $1092.04| $72.95 | $1019.09 | $0.00 | $2628.50 |
| ... | ... | ... | ... | ... | ... | ... |
| 8 | ... | ... | ... | ... | ... | $0.00 |

Note: The interest for each payment is calculated by multiplying the beginning balance by the quarterly interest rate (2%). The principal for each payment is the total payment minus the interest. The ending balance is the beginning balance minus the principal and any additional prepayment.

After the third payment, the remaining balance and the regular payment amount may change due to the prepayment. We would need to recalculate the regular payment amount based on the new balance after the prepayment, or we could continue with the same payment amount and the loan would be paid off earlier than originally scheduled.

For simplicity, I've shown the calculations for the first three payments and the fourth payment after the prepayment. The remaining payments would continue in a similar fashion until the loan is fully amortized.

Please note that the actual amortization schedule would need to be recalculated after the prepayment to reflect the new balance and potentially adjusted payment amounts or amortization period. The calculations above are simplified and rounded for illustrative purposes.

Dr Alvano Borrowed $8000 at 8% Compounded Quarterly to Purchase