PDURATION Function
Calculates the time or specific number of periods required for an investment to reach a particular value
Calculates the time or specific number of periods required for an investment to reach a particular value
The PDURATION function is a Financial function. It helps the user calculate the time or the specific number of periods required for an investment made to reach a particular value.
In simple terms, it will answer the question: Suppose we invested $1,000,000 at 4% per annum, how long will it take for our investment to reach $1,500,000?
The PDURATION function was introduced in MS Excel 2013 and hence is unavailable in earlier versions.
=PDURATION (rate, pv,fv)
The PDURATION function uses the following arguments:
To understand the PDURATION function, let’s consider a few examples:
Let’s assume that on an initial investment of $1 million, we wish to get $1.5 million when the interest rate is 4% per annum. To see how much time it will take to reach the desired amount, we will use the formula below:
We get the result below:
So, it would take 10.34 years for the investment to reach $1.5 million. The PDURATION function is quite helpful in financial planning. With specific financial goals in mind, the function will tell us how much time it would take to achieve the goal with the money on hand.
In the example below, let’s assume we are given the rate of interest per period as 10%, the FV, and the PV.
Based on the information, we wish to find out RRI along with duration. We can first find the duration, which is the number of periods that would be required for the investment of $100,000 to reach $500,000. Afterward, we can use the RRI function. The formula would be:
So, in our example, PDURATION says it will take approximately 17 years to get $500,000.
If we wish to know what would be the CAGR be, we use the RRI function. RRI will tell us that the investment growth rate would be 10%. We can also use the following combined formula to get RRI.
Now let’s take an example wherein we wish to know the number of months and not years. Let’s see how the formula needs to be changed.
In the example, for an initial investment of $1,000 at 5% interest per annum, we need to know how many months it will take to reach $1,200. The formula to use is:
In the formula above, we divided the interest rate with 12 (number of months) to get the result in months.
The result we got is 44 months. The investment will take 44 months to reach $1,200.
Another way to do it is to get the result in years and then multiply the result by 12 (number of months) to get the result in months, as shown below:
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:
To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!