DoAssignment.ca

B1.5 · Use technology to find interest rates or compounding periods

Learn to use technology to find interest rates or compounding periods through clear examples and targeted practice.

Ontario Grade 11 Mathematics

Personal Finance

MBF3C study topic B1.5

A savings plan or loan may tell you the starting amount, the time, and the final amount, but leave out the interest rate. Or it may give the rate but not say how often interest is compounded. Technology can help find these missing values. In this lesson, you will use a compound-interest model and a spreadsheet’s Goal Seek tool, or an equivalent financial calculator feature. The model gives the technology a clear relationship to work with; the technology handles the repeated calculations.

What you will learn

Identify the values needed to model compound interest.
Use a spreadsheet or financial calculator to find an unknown interest rate.
Use technology to identify a compounding period that matches a known investment result.
Check whether a technology result is reasonable and uses an appropriate compounding frequency.

1. Review the compound-interest model

The principal is the starting amount invested or borrowed. The accumulated amount is the total after interest has been added. The annual interest rate is the rate for one year, written as a decimal in calculations. For example, an annual rate of 5% is 0.05.

Compounding means that interest is added to the balance, so later interest can be calculated on the increased balance. The number of compounding periods per year tells how often this happens. For example, annual compounding has one period per year, while monthly compounding has 12.

In the model below, the annual rate is treated as a rate divided evenly among the compounding periods. Time is measured in years. The model lets us enter known values and use technology to adjust an unknown value until the calculated amount matches the amount in the question.

A=P(1+r/m)^{mt}

Convert a percent rate to a decimal before entering it in a formula or spreadsheet.
Use the same time unit throughout: this model uses years.
The number of periods per year must match the compounding schedule.

2. Set up technology to find a missing value

A spreadsheet can calculate the accumulated amount from the principal, annual rate, number of compounding periods per year, and time. Enter the known values in separate cells. In a formula cell, refer to those cells and calculate the amount. Keep the formula cell separate from the input cells so it is easy to see what the program is changing.

Goal Seek is a spreadsheet feature that changes one selected input until a formula cell reaches a target. To find an interest rate, set the amount cell to the known accumulated amount and tell Goal Seek to change the rate cell. To find a compounding frequency, set the amount cell to the known amount and tell it to change the periods-per-year cell.

Some spreadsheet versions do not include Goal Seek. A financial calculator or another approved tool may have a similar feature. If you do not have a solver, test sensible candidate rates or standard compounding frequencies in the model and compare the results. Technology gives an answer, but you still need to check that the input being changed is the one the question asks for.

Set the target using the known accumulated amount.
Choose only the unknown input as the value for technology to change.
Use the result’s context to decide whether it is reasonable.

3. Interpret and check the result

An interest rate reported as a decimal may need to be changed back to a percent for the final answer. Multiply the decimal by 100 and include the percent sign. Keep enough digits while working, then round the final rate as directed or to a sensible number of decimal places.

A compounding frequency is a count of periods in each year. Common schedules include annual, semi-annual, quarterly, and monthly compounding. These correspond to 1, 2, 4, and 12 periods per year. A solver may produce a value that is not a whole number. That does not automatically describe a practical compounding schedule; check the value against the choices or schedule stated in the question.

A quick reasonableness check can catch setup errors. With a positive rate, the accumulated amount should be greater than the principal. For the same positive annual rate and time, more frequent compounding usually produces a slightly greater amount. These checks do not replace the technology calculation, but they can reveal a mistaken rate, time, or period count.

Convert a decimal rate to a percent for reporting.
Check whether a periods-per-year result matches a meaningful schedule.
Compare the calculated amount with the principal and the question’s information.

4. Guided technology workflow

Before using Goal Seek, write down what is known and what is unknown. Put the known information into the correct input cells. Confirm that the model’s output is an amount, not a rate or a period count.

In a spreadsheet, open Goal Seek and select the formula cell as the cell to set. Enter the known accumulated amount as the target. Select the input cell for the unknown rate or frequency as the cell to change. After the tool reports a result, check the value in the input cell and recalculate the amount using that result.

The final response should state what was found, with units or context. For example, report an annual interest rate as a percent per year, or a compounding frequency as periods per year and name the matching schedule when appropriate. Do not report only a number without explaining what it represents.

Name the unknown before opening the tool.
The target is the known accumulated amount.
State the result with its meaning and suitable rounding.

Common compounding schedules

Schedule	Periods per year
Annual	1
Semi-annual	2
Quarterly	4
Monthly	12

Worked example

Find an annual interest rate

An account starts with CAD 1,200 and grows to CAD 1,323 after 2 years with annual compounding. Use a spreadsheet Goal Seek setup to find the annual interest rate.

Identify the inputs
The starting amount is the principal, the final amount is the target, and the time is 2 years. Annual compounding means there is one compounding period per year. The annual rate is unknown.
$P=1200,\quad A=1323,\quad t=2,\quad m=1$
Set up the model
Enter the known values in the spreadsheet and put the rate in a separate input cell. Use the amount formula as the output. Set Goal Seek to make the output 1323 by changing only the rate cell.
$1323=1200(1+r)^2$
Read and report the result
Goal Seek returns a rate of 0.05. Convert the decimal to a percent by multiplying by 100. The result is the annual interest rate, not the rate for one compounding period stated as a percent.
$0.05\times100\%=5\%$

Answer: The annual interest rate is 5%.

Check: Substituting 0.05 gives 1200(1.05)^2 = 1323, so the model matches the stated accumulated amount.

Worked example

Find a compounding frequency

An investment of CAD 2,000 earns an annual interest rate of 6% for 1 year. The accumulated amount is CAD 2,123.36. Use technology to identify the compounding frequency from annual, semi-annual, quarterly, or monthly compounding.

Identify the unknown
The principal, annual rate, time, and accumulated amount are known. The number of compounding periods per year is unknown. Convert the rate to a decimal before entering it.
$P=2000,\quad r=0.06,\quad t=1,\quad A=2123.36$
Test the available schedules
Enter a candidate periods-per-year value in the spreadsheet and calculate the amount. Compare the output with CAD 2,123.36. Repeat for the listed schedules, or use Goal Seek and then check the result against those schedules.
$m∈\{1,2,4,12\}$
Match the result
The monthly schedule uses 12 periods per year. The model gives about CAD 2,123.36, matching the amount in the question when rounded to the nearest cent.
$2000\left(1+\frac{0.06}{12}\right)^{12}\approx2123.36$

Answer: The investment uses monthly compounding, or 12 compounding periods per year.

Check: The quarterly schedule gives about CAD 2,121.83, which does not match the stated amount. The monthly result rounds to CAD 2,123.36.

Common mistakes and how to avoid them

Entering 5 as the rate when the rate is 5%.

Correction: Enter 0.05 in the calculation because percent means per hundred.

Telling Goal Seek to change the principal when the question asks for a rate.

Correction: Select the cell for the requested unknown and keep the known values fixed.

Treating a periods-per-year answer such as 7.4 as a standard schedule.

Correction: Compare the result with the schedules or choices in the question. A practical frequency is usually a whole-number count.

Rounding the rate or intermediate result too early.

Correction: Keep the technology’s full displayed precision while checking, and round only the reported answer.

Lesson summary

A compound-interest model connects the starting amount, rate, compounding frequency, time, and accumulated amount.
Goal Seek can find an unknown rate or compounding frequency by changing one input until the output matches a known amount.
Check the reported value, its units, and whether it makes sense for the stated schedule.

Check your understanding

Question 1

A spreadsheet model has an accumulated amount cell and an annual-rate input cell. To find the annual rate from a known final amount, what should Goal Seek change?

The accumulated amount cell
The annual-rate input cell
The principal input cell
The time input cell

Show answer and explanation

The annual-rate input cell

The known accumulated amount is the target. The rate is the unknown, so Goal Seek must change the annual-rate input cell.

Question 2

Which value represents monthly compounding?

1 period per year
2 periods per year
4 periods per year
12 periods per year

Show answer and explanation

12 periods per year

There are 12 months in a year, so monthly compounding has 12 periods per year.

Question 3

A technology result for a rate is 0.04. What is this rate as a percent?

0.04%
0.4%
4%
40%

Show answer and explanation

Convert the decimal to a percent by multiplying by 100. The result is 4%.

Key terms

Accumulated amount: The total balance after interest has been added.
Annual interest rate: The interest rate for one year, usually written as a percent.
Compounding: Adding interest to a balance so that later interest is based on the increased balance.
Compounding period: One time interval when interest is added to the balance.
Goal Seek: A spreadsheet tool that changes an input value to make a formula reach a chosen target.
Principal: The starting amount invested or borrowed.

Continue through MBF3C

View the complete Ontario Grade 11 Mathematics learning path

About this lesson

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

Official curriculum reference

Report a correction or ask a question