HomeCasa Compound interest explained with your own numbers
Understand compound interest using your figures: the formula explained, a year-by-year table, the cost of starting late, the effect of fees and inflation, and a spreadsheet formula. Designed for ChatGPT, Claude, Gemini and Microsoft Copilot. It includes 5 customizable variables and you can copy it for free in one click.
Beginner · Text · Pending editorial review
Prompt
Act as a financial literacy teacher who explains concepts with concrete examples and no jargon.
My example numbers:
- Starting amount: {{starting_amount}}
- Monthly contribution: {{monthly_contribution}}
- Hypothetical annual return: {{annual_rate}}
- Time horizon: {{years}}
- My level: {{level}}
Deliverables:
1. A plain-language explanation of compound interest, with an analogy and the difference from simple interest.
2. The future value formula with regular contributions, explaining every symbol, then the calculation applied to my numbers step by step.
3. A year-by-year table: total contributed, accumulated interest and ending balance. If the horizon is long, show selected years.
4. A comparison of "start today vs start 5 years later" with the same monthly contribution.
5. The effect of a 1% annual fee and 2% inflation on the final result, to show the difference between nominal and real value.
6. The dark side: how compounding makes credit card debt grow when only the minimum is paid.
7. The spreadsheet function to replicate it (for example FV) with my data.
8. Three self-check questions with answers.
Constraints:
- The return is an assumption for learning, not a forecast: no investment guarantees a return and losses are possible.
- Do not recommend products, funds or providers.
- Say that the calculations are rounded and should be checked in a spreadsheet.
- For decisions about where to invest, suggest speaking to a qualified financial advisor.
Format: short sections, tables and the formula in a highlighted block.How to use it
Start with small numbers, then change the time horizon or contribution to see how the result moves. Copy the spreadsheet formula to run your own scenarios.
Usage example
Starting amount: $1,000 · Contribution: $150/month · Hypothetical return: 5% a year · Horizon: 20 years · Level: beginner.
Sample output
The idea in one sentence
Compound interest is a snowball: this year's interest earns interest of its own next year. With simple interest, only the money you put in earns anything.
The formula
FV = P · (1 + r)ⁿ + C · [(1 + r)ⁿ − 1] / r P = $1,000 · C = $150/month · r = 5% / 12 · n = 240 months
Year by year (hypothetical 5% return)
| Year | Contributed | Interest earned | Balance |
|---|---|---|---|
| 1 | $2,800 | $93 | $2,893 |
| 5 | $10,000 | $1,484 | $11,484 |
| 10 | $19,000 | $5,939 | $24,939 |
| 20 | $37,000 | $27,368 | $64,368 |
Start today vs in 5 years
Starting 5 years later (15 years of contributions) gets you about $42,207: roughly $22,000 less, even though you only contribute $9,000 less.
In a spreadsheet
=FV(5%/12, 240, -150, -1000) → ≈ $64,368
The 5% is a learning assumption, not a forecast: no investment guarantees a return and losses are possible. Figures are rounded; check them in a spreadsheet. …
Key facts
- Category
- Finance · Financial education
- Output type
- Text
- Level
- Beginner
- Designed for
- ChatGPT, Claude, Gemini and Microsoft Copilot
- Verified in
- Pending editorial verification
- Variables
- Starting amount, Monthly contribution, Hypothetical annual return, Time horizon and Level
- Language
- English
- Price
- Free, no sign-up
- Updated
- Nov 7, 2026
Frequently asked questions
What return should I enter?
Try several assumptions (for example 2%, 5% and 7%) to see a range. It is a learning exercise: real returns can be higher, lower or negative.
Why include inflation and fees?
Because over long periods they cut the real result a lot. A one-point difference per year adds up over decades, also because of compounding.
What is this prompt for?
Understand compound interest using your figures: the formula explained, a year-by-year table, the cost of starting late, the effect of fees and inflation, and a spreadsheet formula.
Which AI tools does it work with?
It is designed for ChatGPT, Claude, Gemini and Microsoft Copilot. We have not verified it in these tools yet, so results may vary between them.
How do I customize the prompt?
Click “Customize” and fill in the variables (Starting amount, Monthly contribution, Hypothetical annual return, Time horizon and Level). The text updates instantly and you can then copy it in one click. Values are stored only in your browser.
Do I need experience to use it?
No. It is a beginner-level prompt: just fill in the details and paste it into your AI tool.
Is this prompt free?
Yes. Every HomeCasa Prompts prompt is free, with no sign-up or subscription. You can also use them in professional projects.
Can I trust the AI output?
Treat it as a high-quality draft: always check data, figures and important claims before publishing or making decisions.