Subjects finance

Mortgage Schedule Cb70Dd

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

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.