‘Excel’ling. Understanding MS Excel functions: PMT The ‘payment’ function can be used to find out how much to invest on a regular basis to accumulate a desired corpus ...

Excel as a Comprehensive Financial Planning Tool Excel’s “What-If Analysis” tools, combined with the FV and PMT functions, provide a comprehensive solution for financial planning.