ExcelwithExcel

PDURATION function is 0ne of the most important functions for any financial analyst. It helps users to compute the time or the specific amount of periods needed for any particular investment made to get to a particular value.

The NPER function is under the Excel Financial functions used to compute the number of periods or time needed to pay off a certain loan or to reach your investment goal through regular periodic payments and at a fixed interest rate.

This video shows how to use one of the Financial function in excel knows as FVSCHEDULE to easily compute the future value of your investment with a series values of interest rates