Bookmarks    
nPr and nCr    
Random Number    
SD Calculator    
Sample Size    
Percent Error    
Density    
Molarity    
Molar Mass    
Ohm's Law    
Watts to Amps    
Voltage Drop    
Long Division    
Mixed Numbers    
Rounding    
Nth Root    
Exponents    
Half-Life    
Polar Form    
De Moivre    
3D Distance    
Point to Line    
Cross Product    
Determinant    
Sin Cos Tan    
Triangle Area    
Scale Factor    
Sector Area    
Ellipse Area    
Cube Volume    
Box Volume    
Sphere Volume    
Cone Volume    
Pipe Volume    
Time Duration    
Time Card    
Present Value    
Future Value    
Churn Rate    
A/B Test Calc    
SEO Traffic    
Ideal Weight    
Fat Intake    
Child Height    
Golf Handicap    
Heat Index    
Wind Chill    
Dew Point    
Download Time    
kWh to Cost    
AC Size (BTU)    
Heating Costs    
LED Savings    
Trip Gas Cost    
Tire Size    
Solar Output    
Solar Payback    
Battery Size    
Wall Area    
Gravel Needed    
Mortar Mix    
Slope Grade    
Curtain Size    
Soil Needed    
Sod Needed    
Ramp Length    
Blind Size    
Drain Slope    
Board Feet    
Heat Loss    
Furniture Fit    
Moving Boxes    
Plywood Cuts    
Shelf Sag    
   Add
Probability and random number calculators
Independent Events
Independent Events
Two Events Solver
Two Events Solver
Repeated Trials
Repeated Trials
Bayes' Theorem
Bayes' Theorem
Expected Value
Expected Value
Binomial Distribution
Binomial Distribution
nPr and nCr
nPr and nCr
Circular Permutation
Circular Permutation
With Repetition
With Repetition
Random Number
Random Number
Averages and statistics calculators
Average Calculator
Average Calculator
Mean Median Mode
Mean Median Mode
SD Calculator
SD Calculator
Quartiles & IQR
Quartiles & IQR
Frequency Table
Frequency Table
Correlation (r)
Correlation (r)
Normal Probability
Normal Probability
Z-Score Calculator
Z-Score Calculator
Confidence Interval
Confidence Interval
Sample Size
Sample Size
Mark & Recapture
Mark & Recapture
P-Value Calculator
P-Value Calculator
Percentage and ratio calculators
Percentage Calc
Percentage Calc
Percent Change
Percent Change
Percent Difference
Percent Difference
Percent Error
Percent Error
Ratio Calculator
Ratio Calculator
Discount Calculator
Discount Calculator
Sales Tax Calculator
Sales Tax Calculator
Margin Calculator
Margin Calculator
Speed calculators
Speed Calculator
Speed Calculator
Density and concentration calculators
Density
Density
Molarity
Molarity
Molar Mass
Molar Mass
Physics and electricity calculators
Ohm's Law
Ohm's Law
Watts to Amps
Watts to Amps
Resistor Colors
Resistor Colors
Voltage Drop
Voltage Drop
Unit conversion calculators
Weight Converter
Weight Converter
Shoe Size Converter
Shoe Size Converter
Integer and signed number calculators
Long Division
Long Division
LCM Calculator
LCM Calculator
GCF Calculator
GCF Calculator
Integer Calculator
Integer Calculator
Prime Factorization
Prime Factorization
Diophantine Solver
Diophantine Solver
Modulo Calculator
Modulo Calculator
Factor Calculator
Factor Calculator
Roman Numerals
Roman Numerals
Fraction, decimal and rounding calculators
Fraction Calculator
Fraction Calculator
Mixed Numbers
Mixed Numbers
Simplify Fractions
Simplify Fractions
Fraction to Decimal
Fraction to Decimal
Decimal to Fraction
Decimal to Fraction
Rounding
Rounding
Equation and inequality calculators
Linear Equation
Linear Equation
Linear Systems
Linear Systems
Quadratic Formula
Quadratic Formula
Absolute Value
Absolute Value
Quadratic Inequality
Quadratic Inequality
Polynomial calculators
Binomial Theorem
Binomial Theorem
Square root and nth root calculators
Simplify Radicals
Simplify Radicals
Nth Root
Nth Root
Exponent and logarithm calculators
Exponents
Exponents
Log Calculator
Log Calculator
Number of Digits
Number of Digits
Scientific Notation
Scientific Notation
Sci. Notation Math
Sci. Notation Math
Half-Life
Half-Life
Complex number calculators
Complex Numbers
Complex Numbers
Polar Form
Polar Form
De Moivre
De Moivre
Function and graph calculators
Slope Calculator
Slope Calculator
Linear Function
Linear Function
Direct & Inverse Variation
Direct & Inverse Variation
y = ax² Calculator
y = ax² Calculator
Distance Formula
Distance Formula
3D Distance
3D Distance
Section Formula
Section Formula
Point to Line
Point to Line
Lat/Long Distance
Lat/Long Distance
Complete the Square
Complete the Square
Circle Equation
Circle Equation
Conic Sections
Conic Sections
Polar Coordinates
Polar Coordinates
Sequence calculators
Arithmetic Sequence
Arithmetic Sequence
Geometric Sequence
Geometric Sequence
Fibonacci Sequence
Fibonacci Sequence
Recurrence Relation
Recurrence Relation
Vector calculators
Vector Calculator
Vector Calculator
Cross Product
Cross Product
Matrix calculators
Matrix Calculator
Matrix Calculator
Determinant
Determinant
Inverse Matrix
Inverse Matrix
Plane geometry calculators
Sin Cos Tan
Sin Cos Tan
Degrees ⇔ Radians
Degrees ⇔ Radians
a sin θ + b cos θ
a sin θ + b cos θ
Triangle Solver
Triangle Solver
Triangle Area
Triangle Area
Right Triangle
Right Triangle
Pythagorean Theorem
Pythagorean Theorem
Polygon Angles
Polygon Angles
Scale Factor
Scale Factor
Parallel Lines
Parallel Lines
Rectangle Area
Rectangle Area
Parallelogram Area
Parallelogram Area
Trapezoid Area
Trapezoid Area
Circle Calculator
Circle Calculator
Sector Area
Sector Area
Inscribed Angle
Inscribed Angle
Ellipse Area
Ellipse Area
Solid geometry calculators
Cube Volume
Cube Volume
Cube Surface Area
Cube Surface Area
Box Volume
Box Volume
Box Surface Area
Box Surface Area
Cylinder Volume
Cylinder Volume
Cylinder Surface
Cylinder Surface
Sphere Volume
Sphere Volume
Sphere Surface
Sphere Surface
Spherical Cap Volume
Spherical Cap Volume
Cap Surface Area
Cap Surface Area
Ellipsoid Volume
Ellipsoid Volume
Ellipsoid Surface
Ellipsoid Surface
Pyramid Volume
Pyramid Volume
Pyramid Surface
Pyramid Surface
Cone Volume
Cone Volume
Cone Surface Area
Cone Surface Area
Frustum Volume
Frustum Volume
Frustum Surface Area
Frustum Surface Area
Pipe Volume
Pipe Volume
Capsule Volume
Capsule Volume
Capsule Surface Area
Capsule Surface Area
Date and time calculators
Age Calculator
Age Calculator
Days Between Dates
Days Between Dates
Date Calculator
Date Calculator
Hours From Now
Hours From Now
Day of the Week
Day of the Week
Time Calculator
Time Calculator
Time Zone Converter
Time Zone Converter
Hours Calculator
Hours Calculator
Time Duration
Time Duration
Time Card
Time Card
Finance and economics calculators
Compound Interest
Compound Interest
Simple Interest
Simple Interest
Interest Calculator
Interest Calculator
TVM Calculator
TVM Calculator
Present Value
Present Value
Future Value
Future Value
ROI Calculator
ROI Calculator
IRR Calculator
IRR Calculator
Payback Period
Payback Period
Average Return
Average Return
GDP Calculator
GDP Calculator
Web marketing and ad metric calculators
CTR Calculator
CTR Calculator
Conversion Rate
Conversion Rate
CPC, CPM & CPA
CPC, CPM & CPA
ROAS Calculator
ROAS Calculator
Break-Even CPA
Break-Even CPA
LTV Calculator
LTV Calculator
CAC Calculator
CAC Calculator
Churn Rate
Churn Rate
A/B Test Calc
A/B Test Calc
A/B Sample Size
A/B Sample Size
SEO Traffic
SEO Traffic
Break-Even Point
Break-Even Point
Markup vs. Margin
Markup vs. Margin
CAGR Calculator
CAGR Calculator
Health and fitness calculators
BMI Calculator
BMI Calculator
Sleep Calculator
Sleep Calculator
Calorie Calculator
Calorie Calculator
BMR Calculator
BMR Calculator
TDEE Calculator
TDEE Calculator
Ideal Weight
Ideal Weight
Body Fat Calculator
Body Fat Calculator
Lean Body Mass
Lean Body Mass
Calories Burned
Calories Burned
Protein Intake
Protein Intake
Macro Calculator
Macro Calculator
Carb Calculator
Carb Calculator
Fat Intake
Fat Intake
Child Height
Child Height
Sports calculators
Golf Handicap
Golf Handicap
Pace Calculator
Pace Calculator
1RM Calculator
1RM Calculator
Target Heart Rate
Target Heart Rate
Weather calculators
Heat Index
Heat Index
Wind Chill
Wind Chill
Dew Point
Dew Point
Computer calculators
Base Converter
Base Converter
Subnet Calculator
Subnet Calculator
Download Time
Download Time
Household energy and budget calculators
Electricity Cost
Electricity Cost
kWh to Cost
kWh to Cost
Yearly kWh to Cost
Yearly kWh to Cost
AC Size (BTU)
AC Size (BTU)
AC Running Cost
AC Running Cost
Heating Costs
Heating Costs
Gas vs Electric
Gas vs Electric
LED Savings
LED Savings
Salary Calculator
Salary Calculator
Budget Calculator
Budget Calculator
Car calculators
Trip Gas Cost
Trip Gas Cost
EV Charging Cost
EV Charging Cost
EV vs Gas Cost
EV vs Gas Cost
MPG Calculator
MPG Calculator
Tire Size
Tire Size
Solar power and battery calculators
Solar Output
Solar Output
Solar Panel Count
Solar Panel Count
Solar Payback
Solar Payback
Battery Size
Battery Size
Home and DIY calculators
Tile Calculator
Tile Calculator
Stair Calculator
Stair Calculator
Concrete Volume
Concrete Volume
Wall Area
Wall Area
Wallpaper Rolls
Wallpaper Rolls
Paint Calculator
Paint Calculator
Flooring Needed
Flooring Needed
Exterior Walls
Exterior Walls
Gravel Needed
Gravel Needed
Mortar Mix
Mortar Mix
Slope Grade
Slope Grade
Lumber Cut List
Lumber Cut List
Lot Coverage/FAR
Lot Coverage/FAR
Sheet Vinyl Roll
Sheet Vinyl Roll
Insulation Needed
Insulation Needed
Curtain Size
Curtain Size
TV Size & Distance
TV Size & Distance
Soil Needed
Soil Needed
Sod Needed
Sod Needed
Block Calculator
Block Calculator
Brick Calculator
Brick Calculator
Deck Materials
Deck Materials
Ramp Length
Ramp Length
Pilot Hole Size
Pilot Hole Size
Room Ventilation
Room Ventilation
Paint Thinning
Paint Thinning
Baseboard & Trim
Baseboard & Trim
Blind Size
Blind Size
Picture Hanging
Picture Hanging
Drain Slope
Drain Slope
Screw Calculator
Screw Calculator
Board Feet
Board Feet
Fence Calculator
Fence Calculator
Wood Shrinkage
Wood Shrinkage
Caulk Calculator
Caulk Calculator
Heat Loss
Heat Loss
Furniture Fit
Furniture Fit
Moving Boxes
Moving Boxes
Storage Capacity
Storage Capacity
Plywood Cuts
Plywood Cuts
Shelf Sag
Shelf Sag

Simple Interest Calculator (Interest, Principal, Rate and Time)

Out of the four fields (total amount, principal, rate and time), leave blank only the one you want to find and enter numbers in the other three. The blank field is solved for.

Enter numbers only. Enter rates as percentages (for 3%, enter "3"). This is the math of simple interest, and it does not include the fees, taxes or rate changes of real financial products.
Result and graph
Leave blank only the one field you want to find out of the four on the left and press "Calculate". The result and a graph will appear here.

What you can do on this page

  • Enter the principal, rate and time, and you get the total simple interest, \(I = P \times r \times t\), and the total amount right away
  • Fill in any three of the four fields (total amount, principal, rate and time), and the fourth is solved for you (for example, the years it takes to reach a goal, or the actual rate on money you lent)
  • Enter the rate per year or per month, and the time in years or months (they are converted to an annual rate and years inside the calculation)
  • When the time is a whole number of years up to 20, a table shows the interest so far and the balance for each year
  • A graph shows how simple interest grows in a straight line. A plain-language explanation of the formulas and copy-and-paste formulas for Excel, Google Sheets and Python are also on this page
This page does simple interest as math. Most real savings accounts, loans and investments use compound interest (where interest also earns interest), and they involve fees, taxes (interest is generally taxable income) and rates that change, so check the exact amount you will earn or owe with your bank or lender. This page does not recommend any financial product.

What is this calculation used for?

Agreeing on interest for a loan between friends or family

When you lend money to a friend or relative with interest, a plain agreement such as "3% a year simple interest" is natural, rather than compound interest. For example, if you lend $3,000 at 3% simple interest to be repaid in 2 years, the interest is \(3000 \times 0.03 \times 2 = 180\) dollars, so $3,180 is paid back.
Most states have usury laws that cap the interest rate on loans, and large family loans with very low interest can have tax consequences with the IRS. For a large amount, it is safest to write a promissory note and put the terms on paper.

Understanding bond interest payments

A bond, such as a US Treasury note or a corporate bond, pays interest of "face value × coupon rate" each year, usually in two payments six months apart. The interest is not added to the principal, so it is a classic case of simple interest. For example, a $10,000 note with a 4% coupon pays $400 a year ($200 every six months), for a total of \(10000 \times 0.04 \times 10 = 4000\) dollars over 10 years (before taxes).
Some bonds have rates that change over time, such as floating-rate notes, so this formula is an estimate that assumes a fixed rate.

Estimating interest on a late payment

When a payment is late, the interest charged is commonly calculated as daily simple interest, "amount due × annual rate × days late ÷ 365". Many business invoices charge 1.5% a month (18% a year) on overdue balances.
For example, if a $5,000 invoice is paid 60 days late at 18% a year, the interest is \(5000 \times 0.18 \times 60 \div 365 \approx 147.95\) dollars. The rate that can be charged depends on the contract and on state law, which often sets a maximum.

Seeing the difference between simple and compound interest

Even at the same "3% a year", simple and compound interest end up far apart over a long time. Over 20 years, $10,000 grows to \(10000 \times (1 + 0.03 \times 20) = 16000\) dollars with simple interest, but to \(10000 \times 1.03^{20} \approx 18061\) dollars compounded once a year, a difference of about $2,061.
Comparing this page with the compound interest calculator shows in numbers how much the difference between simple and compound interest matters for growth (real returns are reduced by taxes and fees).

Formulas and graphs

The total interest formula (the basics of simple interest)
Graph
Standard notation (the usual math form)
\(I\) \(=\) \(P\) \(\times\) \(r\) \(\times\) \(t\)
In words (symbols replaced with words)
④ \(I\): total interest \(=\) ① \(P\): principal \(\times\) ② \(r\): annual rate \(\times\) ③ \(t\): years
The formula in words
① Take the \(P\): principal
② multiply it by the \(r\): annual rate to get the interest for one year
③ then multiply by the \(t\): years
④ and you get the \(I\): total interest
Quick example
The total interest when you deposit $10,000 at 2% a year simple interest for 3 years is
\(I\): total interest \(=\) principal ($10,000) \(\times\) annual rate (0.02) \(\times\) years (3)
\(10000 \times 0.02 \times 3 = 600\)
Key idea
Simple interest means interest is earned on the original principal only, every year. The interest for one year, \(P \times r\), is the same every year ($200 in this example), so the total interest is just that times the number of years. Enter the annual rate \(r\) as a decimal, the percentage divided by 100 (for 2%, \(r = 0.02\)). Most real savings accounts and loans use compound interest, where interest also earns interest. The simple interest formula is used when interest is not added to the principal, such as bond interest payments and late payment interest. Many US auto loans also charge simple interest, calculated daily on the balance you still owe (see "What is this calculation used for?").
The total amount formula
Graph
Standard notation (the usual math form)
\(B\) \(=\) \(P\) \(\times\) \((\) \(1\) \(+\) \(r\) \(\times\) \(t\) \()\)
In words (symbols replaced with words)
⑤ \(B\): total amount \(=\) ④ \(P\): principal \(\times\) \((\) ① \(1\): the principal part \(+\) ② \(r\): annual rate \(\times\) ③ \(t\): years \()\)
The formula in words
① Start with \(1\): the principal part
② add the product of the \(r\): annual rate and
③ the \(t\): years (the interest share \(rt\)) to find how many times larger the principal gets (the factor \(1 + rt\))
④ multiply the \(P\): principal by that factor
⑤ and you get the \(B\): total amount
Quick example
The total amount when you deposit $10,000 at 2% a year simple interest for 3 years is
\(B\): total amount \(=\) principal ($10,000) \(\times\) \((\) principal part 1 \(+\) annual rate (0.02) \(\times\) years (3) \()\)
\(10000 \times (1 + 0.02 \times 3) = 10000 \times 1.06 = 10600\)
Key idea
The total amount is "principal + total interest", so \(B = P + Prt\) can be written as one formula, \(B = P(1 + rt)\). Money at simple interest grows by the same amount (\(P \times r\)) every year, so on a graph it is a straight line. Compound interest curves upward because the growth also earns interest, and the longer the time, the wider the gap with simple interest.
Solving for the principal, rate or time
Standard notation (the usual math form)
\(P\) \(=\) \(B\) \(\div\) \((\) \(1\) \(+\) \(r\) \(\times\) \(t\) \()\)
\(r\) \(=\) \((\) \(B\) \(\div\) \(P\) \(-\) \(1\) \()\) \(\div\) \(t\)
\(t\) \(=\) \((\) \(B\) \(\div\) \(P\) \(-\) \(1\) \()\) \(\div\) \(r\)
In words (symbols replaced with words)
① \(P\): principal \(=\) \(B\): total amount \(\div\) \((\) \(1\): the principal part \(+\) \(r\): annual rate \(\times\) \(t\): years \()\)
② \(r\): annual rate \(=\) \((\) \(B\): total amount \(\div\) \(P\): principal \(-\) \(1\): the principal part \()\) \(\div\) \(t\): years
③ \(t\): years \(=\) \((\) \(B\): total amount \(\div\) \(P\): principal \(-\) \(1\): the principal part \()\) \(\div\) \(r\): annual rate
The formula in words
① The \(P\): principal is the total amount \(B\) divided by the factor (the principal part \(1\) + annual rate \(r\) × years \(t\))
② The \(r\): annual rate is "total amount \(B\) ÷ principal \(P\)" (how many times larger it got), minus the principal part \(1\), divided by the years \(t\)
③ The \(t\): years is "total amount \(B\) ÷ principal \(P\)", minus the principal part \(1\), divided by the annual rate \(r\)
Quick example
If a principal of $20,000 grows to a total of $26,000 in 10 years, the annual rate is
\(r\): annual rate \(=\) \((\) total amount ($26,000) \(\div\) principal ($20,000) \(-\) principal part 1 \()\) \(\div\) years (10)
\((26000 \div 20000 - 1) \div 10 = (1.3 - 1) \div 10 = 0.03\ \ (3\%)\)
Key idea
Each of these is just the total amount formula \(B = P(1 + rt)\) solved for a different letter, so there is nothing new to memorize. The calculator picks the right formula depending on which field you leave blank. If you enter a monthly rate or a time in months, they are first converted with annual rate = monthly rate × 12 and years = months ÷ 12, and then the same formulas are used. The simple conversion "monthly rate × 12 = annual rate" works only because this is simple interest. With compound interest, interest also earns interest, so a year of monthly compounding is more than the monthly rate × 12 (for example, 1% a month compounded for a year is about 12.68%).
With simple interest, interest is earned on the original principal only. The total interest is principal × rate × time, and the total amount is principal × (1 + rate × time). The key points: the growth is a straight line, and by rearranging the formula you can solve for the principal, the rate or the time.

Symbols and terms

Symbols

\(P\) P The principal, the amount you deposit, lend or borrow at the start. P stands for "principal". (Example - $20,000)
\(r\) r The interest rate. In the formulas on this page, it is the rate per year (the annual rate) written as a decimal. (Example - for 3%, \(r = 0.03\))
\(t\) t The time in years, how long the money is saved, lent or borrowed. t stands for "time".
\(I\) I The total interest, all the interest earned over the whole time, found with \(I = P \times r \times t\). I stands for "interest".
\(B\) B The total amount, the principal plus the total interest, with \(B = P + I\). B stands for "balance".
\(1 + rt\) one plus r t The factor that shows how many times larger the principal gets: the principal part \(1\) plus the interest share \(rt\). (Example - at 3% a year for 10 years, \(1 + 0.03 \times 10 = 1.3\))

Terms

simple interest Interest paid only on the original principal. The interest is the same every year, so the money grows in a straight line.
compound interest Interest that is added to the principal, so the next interest is paid on the total. Because interest earns interest, it grows much more than simple interest over a long time. Most real savings accounts and loans work this way (see the Compound Interest Calculator page).
principal The money you deposit, lend or borrow at the start. Interest is calculated from it. On a loan, it also means the part of the balance that is not interest.
total amount The principal plus the interest, also called the maturity value or future value. It is the final amount the formulas on this page find.
interest Money paid in return for depositing or lending money. A borrower pays interest, and a saver or lender earns it.
annual rate The interest rate per year. In the US, savings accounts, loans and bonds are almost always quoted with an annual rate (such as an APR or APY).
monthly rate The interest rate per month. With simple interest, annual rate = monthly rate × 12. (Example - 1% a month is 12% a year)
late payment interest Money charged when a payment is made after the due date. It is commonly calculated with simple interest by the day, "amount due × annual rate × days late ÷ 365". The allowed rate depends on the contract and on state law.

Good to know before you start

Here is what helps you use the calculation on this page with real understanding, not just by pressing the button.

Percents (Grade 6)
  • Being able to rewrite "3%" as the decimal 0.03
  • Knowing that "3% of the principal" is "principal × 0.03"
Proportional relationships (Grade 7)
  • Knowing that an amount that grows by the same amount every year is proportional to the number of years
  • Knowing that a proportional relationship is a straight line on a graph
Expressions with variables (Grades 6–7)
  • Being able to substitute numbers into a formula such as \(B = P(1 + rt)\) and calculate
Rearranging formulas (Grade 8 and Algebra 1)
  • Being able to solve \(B = P(1 + rt)\) for \(P\) or \(t\) (the idea behind the solving formulas; you can use the calculator without this)

How to calculate it in Excel

Copy the whole table below and paste it into cell A1 in Excel. It works as is.
Table for the total interest
Principal ($) 20000
Annual rate (decimal; 3% is 0.03) 0.03
Time (years) 10
Total interest =B1*B2*B3
Table for the total amount
Principal ($) 20000
Annual rate (decimal; 3% is 0.03) 0.03
Time (years) 10
Total amount =B1*(1+B2*B3)
Table to solve for the principal
Total amount ($) 26000
Annual rate (decimal; 3% is 0.03) 0.03
Time (years) 10
Principal =B1/(1+B2*B3)
Table to solve for the rate
Total amount ($) 26000
Principal ($) 20000
Time (years) 10
Annual rate (decimal) =(B1/B2-1)/B3
Table to solve for the time
Total amount ($) 26000
Principal ($) 20000
Annual rate (decimal; 3% is 0.03) 0.03
Time (years) =(B1/B2-1)/B3
After pasting, the upper rows of column B are your inputs and the last row is calculated automatically.
"*" is multiplication and "/" is division.
The first table shows 6,000 (dollars), the second 26,000 (dollars), the third 20,000 (dollars), the fourth 0.03 (= 3% a year) and the fifth 10 (years).
Note that rates are entered as decimals, the percentage divided by 100 (3% is 0.03), not as the percentage itself. If you only know a monthly rate, multiply it by 12 to get the annual rate. If the time is in months, divide it by 12 to get years before entering it.

How to calculate it in Google Sheets

Copy the whole table below and paste it into cell A1 in Google Sheets. It works as is.
Table for the total interest
Principal ($) 20000
Annual rate (decimal; 3% is 0.03) 0.03
Time (years) 10
Total interest =B1*B2*B3
Table for the total amount
Principal ($) 20000
Annual rate (decimal; 3% is 0.03) 0.03
Time (years) 10
Total amount =B1*(1+B2*B3)
Table to solve for the principal
Total amount ($) 26000
Annual rate (decimal; 3% is 0.03) 0.03
Time (years) 10
Principal =B1/(1+B2*B3)
Table to solve for the rate
Total amount ($) 26000
Principal ($) 20000
Time (years) 10
Annual rate (decimal) =(B1/B2-1)/B3
Table to solve for the time
Total amount ($) 26000
Principal ($) 20000
Annual rate (decimal; 3% is 0.03) 0.03
Time (years) =(B1/B2-1)/B3
The same formulas as in Excel work as is. Copy the whole table, paste it into cell A1, and replace the input values in column B with your own.

How to calculate it in Python

principal = 20000        # principal (dollars)
annual_rate = 0.03       # annual rate (0.03 for 3%; if you only have a monthly rate, use monthly rate x 12)
years = 10               # time (years; for months, use months / 12)

interest = principal * annual_rate * years    # total interest I = P x r x t
balance = principal + interest                # total amount B = P + I

print(f"Total interest: ${interest:,.2f}")
print(f"Total amount: ${balance:,.2f}")
Runs with the standard library only. Change the principal, rate and time at the top, then run the code. To solve for another value, use "balance / (1 + annual_rate * years)" for the principal, "(balance / principal - 1) / years" for the annual rate, and "(balance / principal - 1) / annual_rate" for the years.

How to write it in LaTeX and other math languages (copy and paste)

The total interest formula (the basics of simple interest)
I = P × r × t
I = Prt
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>I</mi>
    <mo>=</mo>
    <mi>P</mi>
    <mo>&#x2062;</mo>
    <mi>r</mi>
    <mo>&#x2062;</mo>
    <mi>t</mi>
  </mrow>
</math>
I = P r t
p r t
interest := P*r*t;
I = P*r*t;
I = Prt
The total amount formula
B = P × (1 + r × t)
B = P(1 + rt)
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>B</mi>
    <mo>=</mo>
    <mi>P</mi>
    <mrow>
      <mo>(</mo>
      <mn>1</mn>
      <mo>+</mo>
      <mi>r</mi>
      <mo>&#x2062;</mo>
      <mi>t</mi>
      <mo>)</mo>
    </mrow>
  </mrow>
</math>
B = P(1 + r t)
p (1 + r t)
B := P*(1 + r*t);
B = P*(1 + r*t);
B = P(1 + rt)
Solving for the principal, rate or time
P = B ÷ (1 + rt),  r = (B/P − 1) ÷ t,  t = (B/P − 1) ÷ r
P = \dfrac{B}{1 + rt}, \quad r = \dfrac{B/P - 1}{t}, \quad t = \dfrac{B/P - 1}{r}
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>P</mi>
    <mo>=</mo>
    <mfrac>
      <mi>B</mi>
      <mrow><mn>1</mn><mo>+</mo><mi>r</mi><mo>&#x2062;</mo><mi>t</mi></mrow>
    </mfrac>
    <mo>,</mo>
    <mi>r</mi>
    <mo>=</mo>
    <mfrac>
      <mrow><mi>B</mi><mo>/</mo><mi>P</mi><mo>&#x2212;</mo><mn>1</mn></mrow>
      <mi>t</mi>
    </mfrac>
    <mo>,</mo>
    <mi>t</mi>
    <mo>=</mo>
    <mfrac>
      <mrow><mi>B</mi><mo>/</mo><mi>P</mi><mo>&#x2212;</mo><mn>1</mn></mrow>
      <mi>r</mi>
    </mfrac>
  </mrow>
</math>
P = B / (1 + r t), r = (B/P - 1)/t, t = (B/P - 1)/r
{b/(1 + r t), (b/p - 1)/t, (b/p - 1)/r}
P := B/(1 + r*t); r_solved := (B/P - 1)/t; t_solved := (B/P - 1)/r;
P = B/(1 + r*t); r = (B/P - 1)/t; t = (B/P - 1)/r;
P = B/(1 + rt),  r = (B/P − 1)/t,  t = (B/P − 1)/r

How to have ChatGPT  do the calculation

You are an interest calculation assistant. Do the following calculation by actually running Python code, and base your answer only on the numbers from the execution result (do not answer by mental math or guessing).

1. Find the total interest and the total amount when a principal of $20,000 earns 3% a year simple interest for 10 years.
2. Find the total interest when a principal of $1,000 earns 1% a month simple interest for 2 years (first multiply the monthly rate by 12 to get the annual rate).
3. A principal of $20,000 grew to a total of $26,000 in 10 years with simple interest. Find the annual rate in percent.

Show the formulas you used and the numbers from the execution result.

How to Use
  1. 1
    Enter your numbers
    Type the numbers you want to calculate with into the input fields
  2. 2
    Calculate
    Press the "Calculate" button
  3. 3
    Check the result
    The result appears on the spot. The same page also explains the idea behind the calculation and the formula
  DataChef Features
Easy and Free
Unlimited conversions for free.
No technical knowledge required.
Intuitive and user-friendly operation.
No Registration Required
Available immediately after access.
Can be used without registering personal information.
Safe and Secure
Fully SSL encrypted communication.
Automatic file deletion by clicking "download".
Fast
High-speed site access
and rapid file conversion.
No Watermark
No watermark.
No attribution required.
Commercial Use Available
Free for commercial use.
No need to contact us for commercial use permission.