In: Finance
We can calculate the unknown number of periods using the excel sheet calculator given the details of present and future value and the applicable interest rate as follows:
The NPER function can be used to find the unknown number of periods as follows:
= NPER(rate,pmt,-pv,-fv)
For example we can take the annuity payment and Investment present and future values in below sheet
Formulas used in the excel sheet are:
Using the above examples we can figure out how to calculate the time period using the given values.
Hope I am able to solve your concern. If you are satisfied hit a thumbs up !!