This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

On the Excel screen, this function can be found using the command ‘fx’ and under the category ‘Financial’. Here’s an example of how PV can be used. Say, you want ₹1 lakh after five years.

The PMT function in Excel is a financial function used to calculates the payment of a loan based on payments and interest rates. The formula for the PMT function is PMT (rate,nper,pv, [fv], [type]).