PDURATION |
PDURATION(rate, pv, fv) |
Returns the number of periods required by an investment to reach a specified value. |
rate | The interest rate per period. |
pv | The present value of the investment. |
fv | The future value of the investment. |
REMARKS |
* You can use the FV function to return the future value of a series of equal cash flows at regular intervals. * You can use the PV function to return the present value of a series of equal cash flows at regular intervals. * You can use the RATE function to return the interest rate for a series of equal cash flows at regular intervals. * You can use the RRI function to return an equivalent interest rate for the growth of an investment. * This function was added in Excel 2013. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - How many periods are needed for an investment of £9,000 to reach £10,000 when you have an interest rate of 3%. 2 - How many periods are needed for an investment of £50 to reach £100 when you have an interest rate of 5%. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top