C3.4 Determine the number of compounding periods using technology

Ontario Grade 11 Mathematics

Discrete Functions

Using Technology to Solve Compound Interest Problems — MCR3U Expectation C3.4

Have you ever wondered how long it would take to double your money in a savings account, or how many monthly payments remain on a loan? Both questions ask for the same thing: the number of compounding periods. In this lesson you will learn how to set up the compound interest formula, recognise when the number of periods is the unknown, and use technology — a graphing calculator or a spreadsheet — to find the answer. You will use a graph or a table of values to locate the answer, which is exactly the technology-based approach this course requires.

What you will learn

Set up the compound interest formula correctly and identify the unknown number of compounding periods.
Use a graphing calculator or spreadsheet to find the number of compounding periods needed for an investment or loan to reach a target amount.
Interpret the technology result in context, including rounding to a whole number of periods.
Solve problems involving different compounding frequencies (annual, semi-annual, monthly) using technology.

Prerequisite Bridge: The Compound Interest Formula

Before finding an unknown number of periods, you need to be comfortable with the compound interest formula from earlier in this unit. The formula is

A = P(1 + i)^{n}

, where

A

is the future value (the amount after interest),

P

is the principal (the starting amount),

i

is the interest rate per compounding period written as a decimal, and

n

is the number of compounding periods.

The interest rate per period is found by dividing the annual interest rate by the number of compounding periods per year. For example, if the annual rate is 6% and interest compounds monthly, then

i = \frac{0.06}{12} = 0.005

per month.

In most problems you have seen so far,

n

was given and you solved for

A

. In this lesson,

A

and

P

are both known, and your job is to find

n

. Because

n

sits in the exponent, you cannot isolate it with the algebra tools available at this course level — that is precisely why technology is the right tool here.

A = P(1+i)^{n}

The compound interest formula is $A = P(1+i)^{n}$ .
$i$ = annual rate ÷ number of compounding periods per year.
When $n$ is unknown and $A$ is known, technology is used to find $n$ .

Understanding What You Are Looking For

When the number of compounding periods is unknown, you are asking: for what value of

n

does

P(1+i)^{n}

equal the target amount

A

? Think of

P(1+i)^{n}

as an exponential function of

n

. You can write it as

f(n) = P(1+i)^{n}

. Its graph rises steadily to the right, and the target amount

A

appears as a horizontal line. The answer is the

n

-value where the curve and the line meet.

Because

n

must be a whole number in real life — you cannot have 3.7 monthly payments; you must make 4 — you interpret any decimal result by rounding up. Rounding up ensures the accumulated amount actually reaches or passes the target. Rounding down would leave the amount just short of the goal.

Two main technology methods work for this: (1) graphing both sides of the equation on a graphing calculator and finding the intersection point, and (2) building a spreadsheet or table of values and scanning for the row where the amount first meets or exceeds the target. Both methods are shown in the worked examples below.

f(n) = P(1+i)^{n}

Think of $A = P(1+i)^{n}$ as an exponential function of $n$ .
The answer is where the exponential curve meets the horizontal line $y = A$ .
Always round up to the next whole number of periods in a real-life context.
Both graphing technology and spreadsheet tables are valid approaches.

Using a Graphing Calculator: The Intersection Method

To use a graphing calculator, enter two equations:

Y_1 = P(1+i)^{X}

(the exponential function, using

X

as the stand-in for the number of periods) and

Y_2 = A

(the target amount as a constant horizontal line). Adjust the viewing window so the

x

-axis covers a reasonable range of periods and the

y

-axis spans from below

P

to above

A

. Then use the Intersect feature — usually found in the CALC menu — to find the

x

-coordinate of the crossing point.

The calculator returns a decimal value for

X

. Because

n

must be a whole number, round that decimal up to the next integer. That integer is the number of compounding periods required.

A quick sandwiching check confirms your answer: substitute the rounded-up value back into the formula and verify the result is at or above the target, then substitute one period less and verify the result is still below the target. This pair of checks proves you have the right

n

.

Enter $Y_1 = P(1+i)^{X}$ and $Y_2 = A$ into the graphing calculator.
Use the Intersect feature to read the $x$ -coordinate.
Round the decimal result up to the next whole number.
Check by substituting $n$ and $n - 1$ back into the formula.

Using a Spreadsheet: The Table of Values Method

A spreadsheet is another powerful tool for this type of problem. Set up column A as the period number, starting at 0 and increasing by 1 in each row. Set up column B with the compound interest formula: for the period number

n

in column A, column B computes

P \times (1 + i)^{n}

. Fill the formula downward until the amount in column B reaches or exceeds your target

A

.

Scan down column B and find the first row where the value is greater than or equal to

A

. The period number in column A for that row is your answer. The spreadsheet makes the pattern visible: you can watch the amount grow period by period and pinpoint the exact crossing point.

Spreadsheets are especially helpful when compounding happens frequently, such as monthly, because the number of periods can be large. Instead of adjusting a graph window, you simply extend the table. Both the graphing method and the table method give the same answer — use whichever your teacher or your available technology supports.

Column A: period number $n$ starting at 0.
Column B: accumulated amount $= P(1+i)^{n}$ for each row.
Identify the first row where column B meets or exceeds the target.
The period number in that row is the answer.

Interpreting Your Answer in Context

The number of periods

n

you find is not yet the complete answer to most word problems. You still need to convert it to a meaningful unit of time. If compounding is monthly and

n = 36

, that means 36 months, which equals 3 years. If compounding is semi-annual and

n = 10

, that is 10 half-years, which equals 5 years. Always state the unit of time clearly in your conclusion.

Also read carefully whether the problem asks 'how long until the investment reaches the target?' or 'how many payments are made?'. Both use the same calculation, but the wording of the final answer differs. For an investment you report the total time; for a loan with regular payments you report the number of payments.

Rounding up is a practical interpretation rule: the intersection point gives the exact mathematical crossing, and rounding up makes the answer realistic. In a savings scenario, you need at least that many complete periods for the money to grow to the goal.

Convert periods to years (or months) using the compounding frequency.
State the unit clearly in your final answer.
Rounding up is required because a partial period does not earn a full interest payment.
Re-read the problem to ensure you answer exactly what was asked.

Spreadsheet Table of Values — Example 2 (Selected Rows)

Period n (months)	Amount Owed: $8000(1.005)^{n}$ (CAD)
0	8 000.00
12	8 497.53
24	9 028.16
36	9 594.01
48	10 197.39
60	10 840.76
64	10 984.48
65	11 039.40

Worked example

Example 1 — How Many Years to Reach a Savings Goal? (Annual Compounding)

Fatima deposits CAD 3 000 into a savings account that pays 4% interest per year, compounded annually. She wants her account to grow to at least CAD 4 500. Using a graphing calculator, determine the number of years it will take.

Identify the known values
Write down what you know from the problem. The principal is $P = 3000$ , the target amount is $A = 4500$ , and since interest compounds annually, the rate per period is $i = \frac{0.04}{1} = 0.04$ . The unknown is $n$ , the number of annual compounding periods, which equals the number of years here.
$P = 3000, \quad A = 4500, \quad i = 0.04$
Set up the two graphing equations
Treat $n$ as the variable and call it $X$ on the calculator. Enter the exponential function as $Y_1$ and the target as the horizontal line $Y_2$ . You want to find where these two graphs cross.
$Y_1 = 3000(1.04)^{X}, \quad Y_2 = 4500$
Set the viewing window and find the intersection
Set the calculator window so $X$ runs from 0 to about 20 (years) and $Y$ runs from 2 000 to 5 500. Graph both equations and use the Intersect feature from the CALC menu. The calculator displays the intersection at approximately $X \approx 10.338$ .
$X \approx 10.338$
Round up to the next whole number of periods
Because $n$ must be a whole number of years, and the account has not yet reached CAD 4 500 after exactly 10 complete years, round up to $n = 11$ .
$n = 11$
Check by substituting back into the formula
Substitute $n = 10$ to confirm the amount is still below CAD 4 500, then substitute $n = 11$ to confirm it meets or exceeds the target. After 10 years the balance is $3000(1.04)^{10} \approx 4440.73$ , which is below CAD 4 500. After 11 years the balance is $3000(1.04)^{11} \approx 4618.36$ , which exceeds CAD 4 500. The check confirms $n = 11$ is correct.
$3000(1.04)^{10} \approx 4440.73 < 4500 < 4618.36 \approx 3000(1.04)^{11}$

Answer: Fatima needs 11 years for her account to grow to at least CAD 4 500.

Check: After 10 years the balance is approximately CAD 4 440.73, which is short of the goal. After 11 years the balance is approximately CAD 4 618.36, which meets the goal. So 11 years is correct.

Worked example

Example 2 — How Many Monthly Periods Until a Debt Exceeds a Threshold? (Monthly Compounding)

Marcus borrows CAD 8 000 at an annual interest rate of 6%, compounded monthly. He makes no payments. Using a spreadsheet table of values, determine after how many months his debt will first exceed CAD 11 000.

Identify the known values and find the rate per period
The principal is $P = 8000$ , the target amount is $A = 11000$ , and the annual rate is 6%. Since compounding is monthly, divide the annual rate by 12 to find the monthly rate $i$ .
$i = \frac{0.06}{12} = 0.005$
Write the formula for the accumulated debt
The amount owed after $n$ months is given by the compound interest formula with $P = 8000$ and $i = 0.005$ . This is the expression you evaluate for increasing values of $n$ in the spreadsheet.
$A = 8000(1.005)^{n}$
Build the spreadsheet table
In a spreadsheet, put the period number in column A starting at $n = 0$ , and enter the formula $8000 \times (1.005)^{n}$ in column B for each row. Fill the rows downward. Selected rows from the table are shown below. Watch for the first row where column B exceeds CAD 11 000.
Locate the crossing row
Scanning the table, at $n = 64$ the amount is approximately CAD 10 984.48, which is still below CAD 11 000. At $n = 65$ the amount is approximately CAD 11 039.40, which first exceeds CAD 11 000. The answer is $n = 65$ months.
$8000(1.005)^{64} \approx 10984.48 < 11000 < 11039.40 \approx 8000(1.005)^{65}$
Convert to years and months and state the conclusion
Convert 65 months to years and months by dividing by 12. Since $65 = 5 \times 12 + 5$ , this equals 5 full years and 5 remaining months.
$65 = 5 \times 12 + 5$

Answer: Marcus's debt first exceeds CAD 11 000 after 65 months, which is 5 years and 5 months.

Check: At

n = 64

:

8000(1.005)^{64} \approx 10984.48

— still below CAD 11 000. At

n = 65

:

8000(1.005)^{65} \approx 11039.40

— first exceeds CAD 11 000. The answer of 65 months is confirmed.

Common mistakes and how to avoid them

Rounding down instead of up when

n

is a decimal, causing the answer to be one period short of the target.

Correction: Always round up to the next whole number of periods. A partial period does not count — you must complete the full period for the interest to be applied.

Using the annual interest rate directly as

i

instead of dividing by the number of compounding periods per year.

Correction: Divide the annual rate by the compounding frequency first. For monthly compounding at 6% annually,

i = 0.06 \div 12 = 0.005

, not

0.06

.

Forgetting to convert the number of periods into years (or months) when the question asks for time.

Correction: After finding

n

, divide by the compounding frequency. For example, 65 monthly periods equals 5 years and 5 months.

Reading the

y

-coordinate instead of the

x

-coordinate from the intersection point on the graphing calculator.

Correction: The number of periods is the

x

-coordinate (horizontal axis) at the intersection, not the

y

-coordinate. The

y

-coordinate is the accumulated amount.

Setting up the spreadsheet with a simple interest formula — for example,

P(1 + i \cdot n)

— instead of the compound interest formula

P(1+i)^{n}

.

Correction: Make sure the period number appears as an exponent, not as a multiplier. Compound interest grows exponentially, not linearly.

Lesson summary

The compound interest formula $A = P(1+i)^{n}$ has four variables; in this lesson $n$ (the number of periods) is the unknown.
Technology — a graphing calculator or spreadsheet — is used to find $n$ because isolating an exponent requires tools beyond this course level.
Graphing method: plot $Y_1 = P(1+i)^{X}$ and $Y_2 = A$ , then use the Intersect feature to read the $x$ -coordinate of the crossing point.
Spreadsheet method: build a table with period numbers in column A and accumulated amounts in column B; scan for the first row that meets or exceeds the target.
Always round the decimal result up to the next whole number of periods, because a partial period does not earn a full interest payment.
Convert the number of periods to meaningful time units (months or years) and state the unit clearly in your final answer.

Check your understanding

Question 1

An investment of CAD 5 000 grows at 5% per year, compounded annually. Using a graphing calculator, the intersection of

Y_1 = 5000(1.05)^{X}

and

Y_2 = 7000

occurs at

X \approx 6.73

. How many whole years are needed for the investment to reach at least CAD 7 000?

6 years
7 years
8 years
6.73 years

Show answer and explanation

7 years

The intersection is at

X \approx 6.73

, meaning after exactly 6.73 years the amount equals CAD 7 000. Since

n

must be a whole number and 6 complete years are not enough (the amount is still below CAD 7 000), you round up to 7 years. A decimal is not an acceptable final answer for a number of periods.

Question 2

An account pays 4.8% per year compounded monthly. What is the correct value of

i

to enter in the compound interest formula?

$i = 0.048$
$i = 4.8$
$i = 0.004$
$i = 0.4$

Show answer and explanation

i = 0.004

The rate per compounding period is the annual rate divided by the number of periods per year:

i = 0.048 \div 12 = 0.004

. Using the full annual rate of 0.048 directly would give the wrong answer because compounding happens 12 times a year, so only one-twelfth of the annual rate applies each month.

Question 3

A spreadsheet shows that

8000(1.003)^{n}

is approximately CAD 9 970.35 when

n = 63

and approximately CAD 10 000.26 when

n = 64

. If the target amount is CAD 10 000, how many compounding periods are needed?

63 periods
64 periods
65 periods
60 periods

Show answer and explanation

64 periods

You need the first value of

n

for which the accumulated amount meets or exceeds CAD 10 000. At

n = 63

the amount is approximately CAD 9 970.35, which is still below the target. At

n = 64

the amount is approximately CAD 10 000.26, which first meets the target. So 64 periods is the answer.

Question 4

A student finds that her savings will reach the target after

n = 30

monthly compounding periods. How should she express this as years and months?

3 years and 0 months
2 years and 6 months
2 years and 10 months
3 years and 6 months

Show answer and explanation

2 years and 6 months

Divide 30 months by 12 to convert to years:

30 \div 12 = 2

with a remainder of 6. So 30 months equals 2 full years and 6 remaining months. Always convert periods to meaningful time units when stating your final answer.

Key terms

Principal ( $P$ ): The initial amount of money deposited or borrowed before any interest is applied.
Future value ( $A$ ): The total amount of money in an account (or owed on a loan) after interest has been added over a number of periods.
Compounding period: The length of time between successive interest calculations. Common periods include annually (once a year), semi-annually (twice a year), and monthly (twelve times a year).
Interest rate per period ( $i$ ): The annual interest rate divided by the number of compounding periods per year. This is the rate applied at the end of each single period.
Number of compounding periods ( $n$ ): The total count of times interest is calculated and added over the full duration of the investment or loan.
Intersection point: The point where two graphs cross. In this lesson it is where the exponential curve $Y_1 = P(1+i)^{X}$ meets the horizontal line $Y_2 = A$ , giving the exact (possibly decimal) value of $n$ .
Compounding frequency: The number of times per year that interest is calculated and added to the account. For example, monthly compounding has a frequency of 12.
Round up: To increase a decimal result to the next higher whole number. In this context, rounding up ensures the accumulated amount actually reaches the target, since a partial period does not earn a full interest payment.

Continue through MCR3U

View the complete Ontario Grade 11 Mathematics learning path

About this lesson

Published by DoAssignment. This AI-assisted lesson follows Ontario Grade 11 Mathematics (MCR3U), expectation C3.4. It is a study resource, not an official curriculum publication.

Official curriculum reference

Report a correction or ask a question

C3.4 · Determine the number of compounding periods using technology

Ontario Grade 11 Mathematics

Using Technology to Solve Compound Interest Problems — MCR3U Expectation C3.4

What you will learn

Prerequisite Bridge: The Compound Interest Formula

Understanding What You Are Looking For

Using a Graphing Calculator: The Intersection Method

Using a Spreadsheet: The Table of Values Method

Interpreting Your Answer in Context

Spreadsheet Table of Values — Example 2 (Selected Rows)

Example 1 — How Many Years to Reach a Savings Goal? (Annual Compounding)

Example 2 — How Many Monthly Periods Until a Debt Exceeds a Threshold? (Monthly Compounding)

Common mistakes and how to avoid them

Lesson summary

Check your understanding

Question 1

Question 2

Question 3

Question 4

Key terms

Continue through MCR3U

About this lesson