‘Excel’ing. Understanding MS Excel functions: PV This function helps in calculating the investment needed for a desired corpus ...

The PPMT function in Excel returns the payment on the principal for an investment for a given period. The formula for the PPMT function is PPMT(rate, per,nper, pv,[fv], [type]).

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]).