Simple Interest Calculator
Estimate interest earned or paid on a fixed principal without compounding, then export the current assumptions and results to Excel.
Inputs
Results
Year-by-year balance
| Elapsed time | Interest added | Cumulative interest | Balance |
|---|---|---|---|
| Start | $0.00 | $0.00 | $5,000.00 |
| Year 1 | $300.00 | $300.00 | $5,300.00 |
| Year 2 | $300.00 | $600.00 | $5,600.00 |
| Year 3 | $300.00 | $900.00 | $5,900.00 |
How to use the simple interest calculator
What this calculator does
This calculator estimates simple interest on a fixed principal. It uses the identity I = P × r × t, where principal is the original amount, the annual rate is entered as a percentage and time is expressed in years. It also shows the final balance, annual and monthly interest, the interest as a percentage of principal, and a year-by-year accumulation table. It does not model compounding, changing rates, fees, taxes, scheduled principal repayments, day-count conventions written into a contract, or lender-specific rounding.
When to use it
Use it to compare a simple-interest note, estimate interest on a short-term private loan, check a classroom or budgeting calculation, or forecast earnings where interest is not reinvested. For consumer credit or investments, confirm whether the actual agreement uses simple interest, compound interest, an amortization schedule, or a special daily-interest basis.
How to calculate
- The calculator opens with a ready-to-use demonstration: a $5,000 principal, 6% annual rate and 3-year term. The example workbook is already validated and Download Excel is immediately available.
- Replace Principal, Annual interest rate and Term with your assumptions. Choose the appropriate Term unit; switching units converts the current duration rather than changing the underlying time span.
- Read Total interest first, then use Final balance and the periodic figures to understand the cash effect. Review the table to see linear accumulation over time.
- Select Download Excel to export the current typed inputs and calculated outputs. Reset clears the demonstration and results; Excel remains unavailable until a complete valid set of inputs is entered again.
Input guide
Principal is required and accepts a non-negative U.S.-dollar amount, such as 5000 or 5000.50. Use a period for decimals; ambiguous decimal-comma or scientific notation is rejected. A larger principal increases every dollar result proportionally. Annual interest rate is required, entered as a percentage from 0 to 1000, such as 6 for 6%. Do not enter 0.06 when you mean 6%, because that means 0.06%. A higher rate raises interest linearly. Term is required, must be greater than zero, and may include decimals such as 2.5. Term unit can be Years, Months, or Days using a 365-day year. A longer term raises total interest linearly but does not change annual interest.
Output guide
Total interest is the estimated cumulative interest over the selected term. Final balance is principal plus total interest. Interest per year equals principal times the annual rate; Interest per month divides that annual amount by 12. Interest as % of principal equals rate times time in years, so 18% means the total interest is 18% of the starting principal. The summary pills repeat the annual rate, normalized term and total interest. In the table, Elapsed time identifies each checkpoint, Interest added is the increment since the prior row, Cumulative interest is interest to date, and Balance is principal plus cumulative interest. These are exact identities under the stated model, but actual contract values may differ because of rounding or day-count rules.
Worked example
With the startup values, convert 6% to 0.06 and multiply: $5,000 × 0.06 × 3 = $900. The final balance is $5,000 + $900 = $5,900. Annual interest is $300, monthly interest is $25, and total interest equals 18% of principal. This matches the first-open controls, result cards, table and exported workbook.
For a formal mathematical treatment, see Texas State University's explanation of the simple-interest formula and accumulated amount.
Simple interest versus compound interest
Simple interest grows in a straight line because the principal used in the formula never changes. Compound interest grows faster because each compounding period can add prior interest to the balance used for the next calculation. The U.S. Securities and Exchange Commission's Investor.gov site explains how compound interest changes future value. Use a compounding model when earnings are reinvested or when an agreement explicitly compounds.
Practical interpretation and common mistakes
A 0% rate produces zero interest and a final balance equal to principal. A high interest-to-principal percentage can result from a high rate, a long term, or both. Common mistakes include entering the rate as a decimal instead of a percentage, treating months as years, assuming the displayed balance itself earns interest, and applying this model to an amortizing loan where principal declines after each payment. Some obligations calculate daily interest using a specified denominator; for example, the U.S. Treasury describes a simple daily interest method for prompt-payment calculations. Always use the convention in the relevant contract or regulation.