Interactive Mortgage Loan Amortization Worksheet

Activity Description

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.

Learning Objective

The learning objective of the amortization graph activity is to help students understand how varying interest rates and loan durations influence mortgage payments over time. By analyzing the graph, students will learn to comprehend amortization schedules, see the division of payments between principal and interest, and observe the effects of different interest rates and loan terms on total and monthly payments.

Teacher Tips