Finance
Find how long money takes to double
=LN(2)/LN(1+B1)How it works in Excel
- B1 is the yearly return.
- LN compares doubling to one year of growth.
- The rule of 72 is the shortcut: 72 divided by the percent return. At 6%, that gives 12 years.
The idea in general
Steady growth doubles your money on a regular schedule.
What I assumed
- The yearly return is in B1.
Check the result on your own data before relying on it.