This image is an Excel-based visual explanation of the Rule of 72, a simple way to estimate how long it takes to double an investment given a fixed annual interest rate.
What Is the Rule of 72?
The Rule of 72 is a quick, mental math formula:
Years to Double = 72 / Interest Rate
In this example:
- Interest rate = 8%
- So, 72 / 8 = 9 years
Excel Simulation Overview
The spreadsheet shown demonstrates:
- How an investment of €1,000 grows over time at 8% annual interest, compounded once per year.
- The “Years” column shows the number of years.
- The “Investment Value” column shows how much the investment grows each year using the FV (Future Value) formula:
=FV(interest_rate, periods, 0, -principal)
Example:
For 1 year at 8%:
=FV(8%/1, 1*1, 0, -1000) = €1,080.00
✅ Key Insight
At Year 9, the investment becomes approximately €1,999.00, nearly double the original €1,000 — just as predicted by the Rule of 72.
The rule closely matches the actual compound interest formula and gives a fast approximation without a calculator.
Formula for Exact Doubling Time
The image also provides the precise formula:
excel
=ROUND(LN(2) / LN(1 + (Rate / 100)), 4)
This gives a more accurate result than the Rule of 72. In this case:
≈ 9.0065 years
Takeaway
- Use Rule of 72 for quick mental calculations.
- Use Excel and compound interest formulas for precision.
- At 8%, your money doubles in about 9 years — fast and simple!
This is an example of combining financial literacy with Excel modeling. Perfect for those learning investment basics or building personal finance spreadsheets!
Comments are closed.