Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**Doubling Time Formula (Table of Contents)**

### What is Doubling Time Formula?

The term “doubling time” in financial parlance refers to the period of time required for a certain present value of the interest-bearing investment to double in value. The equation for doubling time in terms of years is derived by dividing the natural log of 2 by the product of number of compounding period per year and natural log of one plus the rate of periodic return.

Mathematically, the doubling time formula is represented as,

**Doubling Time = ln 2 / [n * ln (1 + r/n)]**

where

- r = rate of annual return
- n = no. of compounding period per year

In case of continuous compounding, the calculation of doubling time formula in terms of years is derived by dividing the natural log of 2 by the rate of annual return (since (1 + r/n) ~ e^{r/n}). Mathematically, the doubling time equation is represented as,

**Doubling time = ln 2 / [n * ln e ^{r/n}]**

**Doubling time = ln 2 / [n * r / n]****Doubling time = ln 2 / r**

where r = rate of return

The above formula can be further expanded as,

**Doubling time = 0.69 / r**

**Doubling time = 69 / r%**which is known as the rule of 69.

However, the above formula is also modified as the rule of 72 because practically continuous compounding is not used and hence 72 gives a more realistic value of the time period for less frequent compounding intervals. On the other hand, there is also the rule of 70 in vogue which is used just for the ease of calculation.

### Explanation of the Doubling Time Formula

The equation for doubling time can be calculated by using the following steps:

**Step 1:** Firstly, determine the rate of annual return for the given investment. The annual rate of interest is denoted by ‘r’.

**Step 2:** Next, try to figure out the frequency of compounding per year, which can be 1, 2, 4 etc corresponding to annual compounding, half yearly and quarterly respectively. The number of compounding periods per year is denoted by ‘n’. (The step is not required for continuous compounding)

**Step 3:** Next, the rate of periodic return is calculated by dividing the rate of annual return by the number of compounding periods per year.

**Rate of periodic return = r / n**

**Step 4:** Finally, in case of discrete compounding, the formula for doubling time in terms of years is computed by dividing the natural log of 2 by the product of no. of compounding period per year and natural log of one plus the rate of periodic return as,

4.9 (927 ratings)

**Doubling time = ln 2 / [n * ln (1 + r/n)]**

On the other hand, in case of continuous compounding, the formula for doubling time in terms of years is derived by dividing the natural log of 2 by the rate of annual return as,

**Doubling time = ln 2 / r**

### Example of Doubling Time Formula (with Excel Template)

**Let us take an example where the rate of annual return is 10%. Calculate the doubling time for the following compounding period:**

**Daily****Monthly****Quarterly****Half Yearly****Annual****Continuous**

Given, Rate of annual return, r = 10%

**#1 – Daily Compounding**

Since daily compounding, therefore n = 365

The doubling time is calculated using the above formula as,

Doubling time = ln 2 / [n * ln (1 + r/n)]

- Doubling time = ln 2 / [365 * ln (1 + 10%/365)
- Doubling time = 6.9324 years

**#2 – Monthly Compounding**

Since monthly compounding, therefore n = 12

The doubling time is calculated using the above formula as,

Doubling time = ln 2 / [n * ln (1 + r/n)]

- Doubling time = ln 2 / [12 * ln (1 + 10%/12)
- Doubling time = 6.9603 years

**#3 – Quarterly Compounding**

Since quarterly compounding, therefore n = 4

The doubling time is calculated using the above formula as,

Doubling time = ln 2 / [n * ln (1 + r/n)]

- Doubling time = ln 2 / [4 * ln (1 + 10%/4)
- Doubling time = 7.0178 years

**#4 – Half Yearly Compounding**

Since half yearly compounding, therefore n = 2

The doubling time is calculated using the above formula as,

Doubling time = ln 2 / [n * ln (1 + r/n)]

- Doubling time = ln 2 / [2 * ln (1 + 10%/2)
- Doubling time = 7.1033 years

**#5 – Annual Compounding**

Since annual compounding, therefore n = 1,

The doubling time is calculated using the above formula as,

Doubling time = ln 2 / [n * ln (1 + r/n)]

- Doubling time = ln 2 / [1 * ln (1 + 10%/1)
- Doubling time = 7.2725 years

**#6 – Continuous Compounding**

Since continuous compounding,

The doubling time is calculated using the above formula as,

Doubling time = ln 2 / r

- Doubling time = ln 2 / 10%
- Doubling time = 6.9315 years

Therefore, the calculation of doubling time for various compounding periods will be –

The above example shows that the doubling time depends not only on the rate of annual return of the investment but also on no. of compounding periods per year and it increases with the increase in the frequency of compounding per year.

### Relevance and Use

It is important that an investment analyst understands the concept of doubling time because it helps them to roughly estimate how many years it will take for the investment to double in value. Investors, on the other hand, use this metric to evaluate various investments or the growth rate for a retirement portfolio. In fact, the doubling time finds application in the estimation of how long a country would take to double its real gross domestic product (GDP).

### Recommended Articles

This has been a guide to Doubling Time Formula. Here we discuss the calculation of Doubling Time Equation using practical examples along with downloadable excel templates. You may learn more about excel modeling from the following articles –

- Examples of Compound Interest Formula
- Growth Formula Excel
- Examples of Monthly Compound Interest Formula (with Excel Template)
- Rate Formula in Excel
- TIME Formula in Excel
- Daily Compound Interest Formula | Examples
- CAGR Formula
- Compound Interest Formula in Excel
- Exponential Growth Formula & Calculations
- Effective Annual Rate Formula

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced