Interactive Mortgage Loan Amortization Worksheet

In this interactive worksheet, students will explore the impact of adjusting interest rates and loan durations on the amortization of a mortgage loan. Using sliders to adjust the interest rate and loan duration, students will observe real-time changes in a stacked bar chart that visualizes the distribution of payments between principal (blue portion) and interest (red portion).

Activities:

• Interactive Graph Presentation: Students will be presented with an interactive stacked bar chart that visualizes the amortization of a mortgage loan. The chart will show the principal (blue) and interest (red) portions of each payment.
• Slider Adjustment: Students will use sliders to adjust the interest rate and loan duration. They will observe how the blue and red areas of the stacked bar chart change in real-time based on their adjustments.
• Reflection: Guided questions will help students reflect on the importance of understanding loan parameters and making informed decisions when choosing mortgage terms.