Houses and Cars and Loans
- Mathematics
- Senior

- Activity Time
- Materials
- Concepts / Topics
- Resource Type
Students look up compound interest formulas, build a spreadsheet with loan payments and amortization schedules, research mortgage and car loan rates, and justify affordable purchase prices within a monthly budget.
Subject Area: Algebra II Grade Level: 10 or 11
Lesson Summary
Students will use loan formulas they have learned in class to create a loan calculation spreadsheet. Given a monthly budget amount, they will determine how much they could afford for the purchase price of a house and a car.
Learning Objectives
- Students working in pairs will create a loan calculation spreadsheet using the compound interest formula and including a loan amortization schedule.
- Students will use their loan calculator to determine how much they can afford when purchasing a house and a car, given a monthly budget amount.
Computer Functions
Students will use spreadsheet software to create a loan calculation spreadsheet for compound interest with a loan amortization schedule.
Specific Problem
You have recently graduated from college and found a good job in the field you studied. You would like to buy a better car to have more reliable transportation to and from work. Currently, you are renting and would like to purchase a house to build up equity. Your monthly salary is $2,500.00, and you think you could afford to pay a total of $1,250.00 per month for house and car payments. What purchase price could you afford to pay for a house and a car?
Research and Analysis
- Students will use spreadsheet software to create a loan calculation spreadsheet for compound interest. It will include inputs for the principal amount of the loan, interest rate, and term of the loan. They will create their own formulas.
- Students will do a brief internet search to determine approximate current interest rates for home loans and car loans.
- Students will use their loan calculator to analyze how much they could afford when purchasing a house and a car, using the approximate current interest rates they found in their internet search. Students will justify their final figures.
Student Activities Before Computer Use
- Students will look up the formulas in their textbooks for compound interest.
- Students will sketch a rough layout of their spreadsheet, including row and column headings.
Student Activities During Computer Use
- Students will create a loan calculation spreadsheet using spreadsheet software. It will have inputs for the principal loan amount, interest rate, and loan term. It will calculate the monthly payment based on these terms and should be color coded to make the inputs easy to identify.
- Students will include a loan amortization schedule as part of their loan calculator spreadsheet. The amortization schedule will include the payment number, principal portion of the payment, interest portion of the payment, and balance left on the loan. It should be color coded as well for easy reading.
- Students will research the internet to determine the current national average interest rates for a mortgage and a car loan.
- Students will use their loan calculation spreadsheet to determine how much they could afford to pay for a house and a car using the current national average interest rates determined in their internet search.
Student Activities After Computer Use
- Students will justify their reasoning for the purchase prices they chose for their house and car.
- Students will verify that their spreadsheets have correct calculations.
Results Presentation
Students will hand in two spreadsheets, one for the house loan and one for the car loan. The spreadsheets will include the principal loan amounts, interest rates, loan term, and loan amortization schedule.
Supporting Activities
- Students can research property taxes and home and car insurance to determine how much these might be for their situation.
- Students can look up other loan calculators on the internet (http://www.mlcalc.com/) that include calculations with property taxes, mortgage insurance, and property insurance to see how all of these added expenses would fit into their budget.
Assessment
The spreadsheets will be evaluated using a rubric.
Teachers.Net · https://teachers.net/lessons/4554.html