Tag: Formulas

Using Excel to Calculate Repayments & Interest using PMT, IPMT & PPMT Functions

April 10, 2015 0 comments Article Easy, Excel

If you’re borrowing or saving money, and want to compare rates, perhaps perform some What If analysis, there are built in function in Excel which can quickly help you PMT() The main one is PMT() This function takes a value, a rate and a ‘number of periods’ value and gives you the repayment. There are also Read More