
model monthly savings and loan payments with a finite geometric series, solve for a payment or a future value, and compare the model with a spreadsheet.
Instruction
Every car loan, mortgage and retirement account runs on the formula you derived in Lesson 1.3. This workshop shows how.
Saving every month. Suppose you deposit $100 at the end of each month into an account paying 0.4% interest per month, for 36 months. Track the deposits separately. The last deposit earns nothing; the one before earns one month of interest and is worth 100(1.004); the first deposit earns 35 months and is worth 100(1.004)35. The balance is the sum
F = 100 + 100(1.004) + 100(1.004)2 + … + 100(1.004)35,
a geometric series with a = 100, r = 1.004 and n = 36 terms. So
F = 100(1.00436 − 1)/(1.004 − 1) ≈ $3,863.81.
You deposited $3,600, so interest contributed about $263.81. (We wrote the formula as a(rn − 1)/(r − 1), which is the same fraction with numerator and denominator both multiplied by −1 and is easier to use when r > 1.)
Paying off a loan. A loan works in the other direction. Borrow P dollars at monthly rate i and repay with n equal payments M. The lender treats each payment as worth less the later it arrives: a payment k months away is worth M/(1 + i)k today. The loan is fair when the payments, valued today, add up to what you borrowed:
P = M(1 + i)−1 + M(1 + i)−2 + … + M(1 + i)−n.
That is a geometric series with ratio (1 + i)−1. Summing it and solving for M gives
M = P · i / (1 − (1 + i)−n).
For a $15,000 car loan at 6% a year (i = 0.005 per month) for 60 months, M = 15,000(0.005)/(1 − 1.005−60) ≈ $289.99. Sixty payments total about $17,399.52, so the loan costs about $2,399.52 in interest. Read the formula as a model (A1.SSE.A.1): P · i is the first month’s interest, and dividing by a number less than 1 raises the payment enough to also pay down the principal.
Graphing the model (A2.FM.A.1). Plot the savings balance F(n) = 100(1.004n − 1)/0.004 for n = 0 to 120 months with labeled axes: months on the horizontal axis, dollars on the vertical axis, and a scale that shows the whole curve. Compare it with the line D(n) = 100n, the deposits alone. The gap between the curve and the line is the interest, and it widens because interest earns interest.
Comparing representations (A2.IF.A.1). A bank might describe a savings plan in words, a spreadsheet as a table, and your formula as an expression. Build the table in a free spreadsheet: column A the month, column B the balance, with B2 = B1*1.004 + 100. That recursive rule and the explicit formula must agree to the cent. If they differ, find out why before trusting either; usually the error is whether the first deposit is made at the start or the end of the month.
Modeling cautions (MP.4). Real rates change, real people miss payments, and some loans charge fees that the formula ignores. A model is useful when you know which of those simplifications matter for your decision.
📖 Read for this lesson
The reading opens over the lesson; close it to come back to exactly where you were. The checks below draw on it.
Formative check
Work through these before moving on. They are not graded — they tell you whether the standard below has landed yet.
In 100 + 100(1.004) + … + 100(1.004)35, what does the term 100(1.004)35 represent?
A $15,000 loan at 6% for 60 months has payment $289.99. If the term is stretched to 72 months, the total interest will…
Build a spreadsheet for a savings plan of your choosing (deposit, monthly rate and number of months). Check it against the geometric series formula, graph the balance and the deposits-only line on the same labeled axes, and write two sentences interpreting the gap between them.
Simulation & tools
Savings curve versus deposits line
Open a blank Desmos graph. Enter F(n) = 100(1.004^n − 1)/0.004 and D(n) = 100n, and set the window to 0 ≤ n ≤ 120 and 0 ≤ y ≤ 20,000. Click each graph at n = 36 and record both values; confirm F(36) ≈ 3,863.81. Then add a slider r and change the curve to 100((1 + r)^n − 1)/r. Record the balance at n = 120 for r = 0.002, 0.004 and 0.006. Question: doubling the monthly rate from 0.002 to 0.004 raises the 120-month interest by more than double or less than double, and why? No device: compute the three balances with a calculator and sketch the curves by hand from five points each.
Open Desmos ↗ · Desmos · free to use; Desmos terms
How confident are you that you can model a savings plan or loan with a geometric series and solve for the payment or balance?
Practice
Work these on paper or in your notebook, then open Check your answer. Aim for all of Fluency and Application; try at least one Challenge.
Printable version: this unit’s practice workbook (PDF)
Fluency
Build speed and accuracy with the core skill.
- A quantity starts at 1,200 and grows by 8% each year. Write a model and find its value after 10 years, to the nearest whole number.
Check your answer
Answer: A = 1,200(1.08)t; after 10 years ≈ 2,591The growth factor is 1 + 0.08 = 1.08. - A quantity starts at 8,000 and grows by 12% each year. Write a model and find its value after 11 years, to the nearest whole number.
Check your answer
Answer: A = 8,000(1.12)t; after 11 years ≈ 27,828The growth factor is 1 + 0.12 = 1.12. - A quantity starts at 1,200 and grows by 8% each year. Write a model and find its value after 6 years, to the nearest whole number.
Check your answer
Answer: A = 1,200(1.08)t; after 6 years ≈ 1,904The growth factor is 1 + 0.08 = 1.08. - Find the balance after 24 end-of-month deposits of $50 at 0.5% per month.
Check your answer
Answer: $1,271.6050(1.00524 − 1)/0.005. - Find the balance after 60 end-of-month deposits of $200 at 0.3% per month.
Check your answer
Answer: $13,126.32200(1.00360 − 1)/0.003. - Find the monthly payment on a $10,000 loan at 6% a year (0.5% a month) for 36 months.
Check your answer
Answer: $304.22M = Pi/(1 − (1 + i)−n). - Find the monthly payment on a $25,000 loan at 4.8% a year (0.4% a month) for 60 months.
Check your answer
Answer: $469.49
Application
Use the skill in context. Show your reasoning.
- An $18,000 car loan at 7.2% a year (0.6% a month): compare total interest for 48 and 60 months.
Check your answer
Answer: 48 months: payment $432.70, interest $2,769.82. 60 months: payment $358.12, interest $3,487.35.Longer terms lower the payment and raise total interest. - A student wants $5,000 in 30 months for community college costs, saving at 0.4% a month. What end-of-month deposit is needed?
Check your answer
Answer: About $157.20 a monthSolve 5,000 = D(1.00430 − 1)/0.004 for D. - Graph F(n) = 50(1.005n − 1)/0.005 and D(n) = 50n for 0 ≤ n ≤ 24 on labeled axes. How big is the gap at n = 24, and what does it represent?
Check your answer
Answer: About $71.60: the interest earned.F(24) ≈ 1,271.60 and D(24) = 1,200.
Challenge
Stretch problems. Expect to think before you write.
- A $3,000 credit card balance charges 1.5% a month. Paying $100 a month with no new charges, how many payments are needed? (Hint: solve 3,000 = 100(1 − 1.015−n)/0.015.)
Check your answer
Answer: n ≈ 40.15, so 41 payments (the last one smaller).1 − 1.015−n = 0.45, so n = −ln 0.55/ln 1.015.
Review
Keep earlier skills sharp.
- If f(x) = 3x2 + 5x − 1, find f(4).
Check your answer
Answer: f(4) = 67Substitute, then follow the order of operations; square the input first. - Write with a positive exponent: x−4
Check your answer
Answer: 1/x4A negative exponent means reciprocal. - Solve 3x − 7 = 2(x + 4).
Check your answer
Answer: x = 15
A Loan Rate, a Bond Rate, and the Schedules That Come Out of Them
FRED series TERMCBAUTO48NS, Finance Rate on Consumer Installment Loans at Commercial Banks, New Autos 48 Month Loan (May 2026); TreasuryDirect Series I savings bond rate announced May 1, 2026 · Public domain (works of the United States government)
Why this reading. The workshop asks you to build a savings plan and a loan schedule and check them against the geometric series formula. You cannot document a rate you invented. Here are two real, published rates and the schedules they produce, worked to the cent so you can check a spreadsheet against them. The rates are federal statistical and Treasury publications and are in the public domain.
Table 1. Two published rates
| Rate | Series or source | Period | Annual rate | Rate per period |
|---|---|---|---|---|
| New-car loan, 48 months, commercial banks | FRED TERMCBAUTO48NS (Federal Reserve G.19) | May 2026 | 7.47% | 0.0747 ÷ 12 = 0.006225 per month |
| Series I savings bond, composite | TreasuryDirect, announced May 1, 2026 | Bonds issued May 1 – Oct 31, 2026 | 4.26% (fixed part 0.90%) | compounded semiannually |
The loan series is quarterly: the observations run February, May, August and November. The five before May 2026 were 7.37% (Feb 2026), 7.62% (Nov 2025), 7.51% (Aug 2025), 7.63% (May 2025) and 7.71% (Feb 2025). Use the month you actually cite, and say which one.
Table 2. The lesson’s loan, month by month
$15,000 borrowed at 6% a year (i = 0.005 per month) for 60 months. The payment from M = Pi/(1 − (1 + i)−n) is 15,000(0.005)/(1 − 1.005−60) = $289.9920…, which rounds to $289.99. Each row takes interest first, then applies what is left to the principal.
| Month | Interest = balance × 0.005 | To principal | Balance after |
|---|---|---|---|
| 1 | 75.00 | 214.99 | 14,785.01 |
| 2 | 73.93 | 216.06 | 14,568.95 |
| 3 | 72.84 | 217.15 | 14,351.80 |
| … | … | … | … |
| 58 | 4.31 | 285.68 | 575.80 |
| 59 | 2.88 | 287.11 | 288.69 |
| 60 | 1.44 | 288.55 | 0.14 |
Read the last row before you decide your spreadsheet is broken. Paying exactly $289.99 sixty times leaves 14 cents outstanding, because the true payment is $289.9920 and you rounded it down by two-fifths of a cent each month. Sixty payments of the unrounded amount total $17,399.52, giving $2,399.52 of interest; sixty payments of $289.99 total $17,399.40. Both figures are correct answers to slightly different questions, and a report that does not say which one it is using has not finished.
Stretching the same loan to 72 months gives M = 15,000(0.005)/(1 − 1.005−72) = $248.5934…, or $248.59, and 72 payments of the unrounded amount total $17,898.72, so interest rises to about $2,899. The monthly payment fell by $41.40 and the cost of borrowing rose by about $499.
Table 3. The same car at the rate actually being charged
Now use the published May 2026 rate instead of the round 6%: $15,000 for 48 months at 7.47%, so i = 0.006225.
| Lesson’s loan | Published-rate loan | |
|---|---|---|
| Rate per year | 6.00% | 7.47% |
| Months | 60 | 48 |
| Monthly payment | $289.99 | $362.47 |
| Total paid | $17,399.52 | $17,398.73 |
| Total interest | $2,399.52 | $2,398.73 |
| Month 1 interest | $75.00 | $93.38 |
| Month 48 interest | — | $2.24 |
The two loans cost within eighty cents of each other in total interest, and one of them charges a rate almost a point and a half higher. That coincidence is worth explaining rather than admiring: the higher rate is applied for twelve fewer months, and the balance falls faster under the larger payment. Rate alone tells you nothing about the cost of a loan. Rate and term do.
Table 4. The savings side
Depositing $100 at the end of each month at 0.4% a month for 36 months is the series 100 + 100(1.004) + … + 100(1.004)35, so F = 100(1.00436 − 1)/0.004 = $3,863.81 against $3,600 deposited: $263.81 of interest. Over ten years, with the same $100 a month:
| Monthly rate r | Balance at 120 months | Deposits | Interest |
|---|---|---|---|
| 0.002 | $13,547.22 | $12,000 | $1,547.22 |
| 0.004 | $15,363.20 | $12,000 | $3,363.20 |
| 0.006 | $17,500.30 | $12,000 | $5,500.30 |
Doubling the monthly rate from 0.002 to 0.004 multiplies the interest by 3,363.20 ÷ 1,547.22 = 2.17, not by 2. Interest earns interest, so the relationship between rate and total interest is not proportional, and a sentence like “twice the rate, twice the return” is false in a way you can now measure.
Using the I bond rate honestly. The 4.26% composite rate is not a monthly rate and dividing it by 12 is a modeling choice you must declare. Treasury compounds it semiannually, so the exact monthly growth factor is 1.02131/6 = 1.003519, while 0.0426 ÷ 12 = 0.003550. Over 120 months of $100 deposits that is $14,894.54 against $14,928.62, a difference of $34.08 — small, but it is the kind of assumption a limitations section exists to record. Also note the composite rate resets every six months with inflation, so any projection past October 2026 assumes something the Treasury has not announced.
Sources: FRED, Finance Rate on Consumer Installment Loans, New Autos 48 Month (TERMCBAUTO48NS) (fred.stlouisfed.org); TreasuryDirect, Series I savings bond interest rates (treasurydirect.gov)