Paying Off Your Credit Card Balances By Stephen Nelson At Isnare.com Ezine Articles

Ever thought about paying off your credit card balances? Maybe you would like to be debt free just to reduce your stress. Or perhaps you need to be debt free to retire.

If you have Microsoft Excel running on your computer at home or work, you can use Excel’s NPER function to calculate how quickly you can pay off a debt such as a credit card balance.

The NPER function calculates the term, or number of regular payments, needed to pay off a debt given its interest rate, payment amount, oustanding balance, balloon payment (if any), and, optionally, the type-of-annuity switch.

The type-of-annuity switch is a little complicated, but here's how it works. If you set the type-of-annuity switch to 1, Excel assumes payments occur at the beginning of the month, following the annuity due convention. If you set the annuity switch to 0 or you omit the argument, Excel assumes payments occur at the end of the month following the ordinary annuity convention.

But let me show you how the function works in theory and in practice. All of this will become quite clear, I'm sure.

The function uses the following syntax:

=NPER(rate,pmt,pv,fv,type)

For example, to calculate the number of $100 monthly payments required to pay off a 9% credit card that has a $10,000 balance, you enter the following formula into an Excel worksheet cell:

=NPER(.09/12,-100,10000,0,0)

The function returns the value 185.53, representing roughly 185 payments and then another roughly half payment. Notice that to convert the 9% annual interest to a period interest, the formula divides the annual interest rate by 12. Notice, too, that the payment amount, as a cash outflow, shows as a negative value while the loan balance, as an implicit cash inflow, shows as a positive value.

One final note: The NPER function rarely returns an integer, or whole-number result. As in the preceding example, it commonly returns a fractional value, indicating that after the last regular payment, an additional fractional payment will also need to be made.

Published At: Isnare Free Articles Directory http://www.isnare.com
Permanent Link: http://www.isnare.com/?aid=72642&ca=Finances

Important Notice DISCLAIMER: All information, content, and data in this article are sole opinions and/or findings of the individual user or organization that registered and submitted this article at Isnare.com without any fee. The article is strictly for educational or entertainment purposes only and should not be used in any way, implemented or applied without consultation from a professional. We at Isnare.com do not, in anyway, contribute or include our own findings, facts and opinions in any articles presented in this site. Publishing this article does not constitute Isnare.com's support or sponsorship for this article. Isnare.com is an article publishing service. Please read our Terms of Service for more information.