Mortgage Schedule Cb70Dd
1. The problem is to continue the mortgage amortization schedule for another 5 years (60 months) beyond month 24.
2. The schedule shows monthly payments of $1356, with interest and capital repaid changing each month.
3. The interest each month is calculated as $\text{Interest} = \text{Beginning Balance} \times r$, where $r$ is the monthly interest rate.
4. The capital repaid each month is $\text{Capital Repaid} = \text{Payment} - \text{Interest}$.
5. The ending balance is $\text{Ending Balance} = \text{Beginning Balance} - \text{Capital Repaid}$.
6. From the data, the interest decreases by about 2 each month, indicating a constant monthly interest rate.
7. Calculate the monthly interest rate $r$ using month 1: $678 = 247241 \times r \Rightarrow r = \frac{678}{247241} \approx 0.00274$ (0.274% per month).
8. To continue the table, for each month $n$ from 25 to 84:
- $\text{Beginning Balance}_n = \text{Ending Balance}_{n-1}$
- $\text{Interest}_n = \text{Beginning Balance}_n \times 0.00274$
- $\text{Capital Repaid}_n = 1356 - \text{Interest}_n$
- $\text{Ending Balance}_n = \text{Beginning Balance}_n - \text{Capital Repaid}_n$
9. Repeat these calculations for 60 months to complete the 5-year extension.
10. This process amortizes the loan by gradually reducing the principal while paying interest on the remaining balance.
Final answer: The mortgage schedule can be extended by applying the formulas above for each month, recalculating interest, capital repaid, and ending balance iteratively for 60 months beyond month 24.