drvnkd
January 4, 2007, 10:12am
1
can anyone give me equations i can plug in to excel to calculate
monthy interest charges for credit card debt.
i dont want the the “OMG it will take you 89 years to pay your bills” type calculation.
i’m looking to prioritize my wife’s and my CC debts by what it is really
costing me to carry the balances.
thanks
drvnkd
January 4, 2007, 12:15pm
3
if i take ((%APR / 365) * # days in month ) * balance
it works out.
that should be close enough for me…
seems a lot simpler than i thought
Nikuk
January 4, 2007, 6:28pm
4
except that formula doesnt account for daily compounding. or, any compounding for that matter.
drvnkd
January 5, 2007, 6:13am
5
it matches the charge on my CC statement, so i’m happy with it.
Hit the formula function button in the near the input bar in Excel. Look at the menu for the appropriate calculation type. Enter correct numbers in the fields given and run.