## Savings Calculator.xlsx - Section 3: Work Time and Extensions

# The Cost of Debt (Part 3 of the Spending & Saving Project)

Lesson 15 of 19

## Objective: SWBAT investigate how changing parameters of a purchase will change the total cost of debt.

*43 minutes*

#### Opener: A Big Purchase

*5 min*

Today's class is in the computer lab, where students will use spreadsheet software to explore how changing the parameters of a purchase on credit will change the overall cost of the debt.

As students arrive, I greet them and tell them to take a seat at any computer they'd like. While they're logging in to the computers, I explain the day's first task: "Think of a big purchase that you'd like to make today, or someday, something that you might not be able to afford right now. Your purchase can be as realistic or as unlikely as you want." Then I tell students to spend a few minutes researching the cost of their item online. Some students will ask for a price-range for their item. With a smile, I tell them to keep it between five hundred dollars and ten million dollars.

As they're conducting this initial research, I distribute copies of Part 3 of the Spending & Saving Project, which I describe in the next section of this lesson.

*expand content*

**About Part 3 of the Project**

Today, students will use computers to complete Part 3 of the Spending & Saving Project. In previous days, they've worked on Parts 1 and 2. Until today, I've asked that students show me their complete work on one part of the project before I provide the next. Today, regardless of what each student has done so far, all students will work on Part 3. Here is the handout for Part 3 of the project. I make double-sided photo copies of this two page document (here is the original Word file, if you'd like to be able to make edits).

I give an overview of Part 3 in this narrative video.

**Debt Calculator Spreadsheet**

In order to complete this part of the project, students will use this "Debt Calculator" spreadsheet. I use a link on my class website to share this file with students. I give students a minute or two to download and open the file, and I project it on the screen at the front of the room. When everyone is ready, I teach a mini-lesson about how to use the spreadsheet to complete the project. Please see this screencast video for an overview of how the debt calculator works, and for a description of how I teach this mini-lesson.

*expand content*

#### Work Time and Extensions

*25 min*

Students now have the rest of class to finish Part 3 of the project. Once they understand how the spreadsheet works and what I'm asking them to do, it doesn't take long to finish the front of this assignment. I circulate to make sure everyone understands what's going on. I use this opportunity to make sure that students understand the word *parameter*, and that while two parameters stay the same (*Price of Item* and *Annual Percentage Interest Rate*), we exploring how changing the *Monthly Payment* will cause the outputs - *Months to payoff * and *Total Cost* - to change.

Students may need help figuring out how to make a plan that's possible to pay off. This student's work, for example, shows how it might take some students a few tries before they come up with a monthly payment that will actually give them a chance to get out of debt.

**Part 3 Extensions**

For anyone who finishes with time to spare, I make sure that they've recorded their thoughts on the two prompts on the bottom of Part 3, before directing them to back of the assignment, which lists some "Extensions" to the project. I describe the thinking behind these extensions in this narrative video. Students will have the next two class periods to finish up the project, so even if they don't get to these today, we'll be able to work on them soon.

*expand content*

With a few minutes left in class, I ask the question that I've been asking throughout the lesson: *Is debt worth it?* The answer I want them to leave with is that *it depends *and that debt *can be worth it*, but that you have to be very careful. I ask if anyone has ever heard the phrase, "The rich get richer," and what it might mean. We touch on the idea that it can save someone a lot of money by paying for an item up front, rather than using debt, but that on the other hand, the use of debt might be only way that someone can make a necessary purchase.

What I really want to kids to see is that there are options when it comes to debt. There are ways - in the context of the learning target, there are * parameters* that we can change - to make debt

*very*expensive, or to minimize its cost. So I get this conversation started, and I then I give kids the floor to share their thoughts for a few minutes.

*expand content*

##### Similar Lessons

###### Applications of Power Functions

*Favorites(7)*

*Resources(13)*

Environment: Suburban

###### Parking and Pencils: Step Functions and Piecewise Functions

*Favorites(3)*

*Resources(14)*

Environment: Suburban

###### Rabbit Run -- Day 2 of 2

*Favorites(2)*

*Resources(16)*

Environment: Urban

- UNIT 1: Number Tricks, Patterns, and Abstractions
- UNIT 2: The Number Line Project
- UNIT 3: Solving Linear Equations
- UNIT 4: Creating Linear Equations
- UNIT 5: Statistics
- UNIT 6: Mini Unit: Patterns, Programs, and Math Without Words
- UNIT 7: Lines
- UNIT 8: Linear and Exponential Functions
- UNIT 9: Systems of Equations
- UNIT 10: Quadratic Functions
- UNIT 11: Functions and Modeling

- LESSON 1: How Will Your Salary Grow?
- LESSON 2: Sequences, Spreadsheets, and Graphs
- LESSON 3: Sequences Gallery Walk (Day 1 of 2)
- LESSON 4: Sequences Gallery Walk (Day 2 of 2)
- LESSON 5: Graphing Stories
- LESSON 6: More Graphing Stories
- LESSON 7: Parameters on Desmos
- LESSON 8: Functions: When One Representation Sheds Light on Another
- LESSON 9: Using Points to Determine the Shape of a Graph
- LESSON 10: Introduction to the Spending & Saving Project
- LESSON 11: Spending & Saving, and Function Notation
- LESSON 12: The Spending & Saving Project, Day 3
- LESSON 13: The Spending & Saving Project, Day 4
- LESSON 14: Earning Interest, Paying Interest
- LESSON 15: The Cost of Debt (Part 3 of the Spending & Saving Project)
- LESSON 16: Finishing Up the Spending & Saving Project, With Extensions
- LESSON 17: Tying a Bow on Unit 4 (Review Day 1 of 2)
- LESSON 18: Tying a Bow on Unit 4 (Review Day 2 of 2)
- LESSON 19: Unit 4 Exam