finance calculations

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 :slight_smile:

http://math2.org/math/general/interest.htm

that?

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 :smiley:

except that formula doesnt account for daily compounding. or, any compounding for that matter.

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.