Materials Contributed through SERC-hosted Projects
Understanding Mortgage Payments part of Spreadsheets Across the Curriculum:General Collection:Examples
In this Spreadsheets Across the Curriculum activity, students calculate the payment of a mortgage and create an amortization table. As part of the probelm-solving activity, students build a series of spreadsheets which calculate the mortgage and applicable payment. The activity focuses on calculating and understanding the allocation of each payment to principal and interest. Charting is also used to graphically illustrate the payment mix.