Archive for the ‘NPER’ tag
_468 x 60_20091205090514.jpg)
Excel Finance Trick 11: How Long Pay Off Credit Card Balance
See how to calculate HOW LONG IT TAKES TO PAY OFF A CREDIT CARD BALANCE using the NPER function. When you make only the minimum payment on a credit card, it takes a long time to pay off the balance. How long? Use the NPER function to find out how long it will take to pay off the credit card balance. Solve for how many total periods there are. In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions …
