# finance calculations
**URL:** https://forums.speedlife.net/t/finance-calculations/22555
**Category:** NYSpeed Off Topic
**Created:** [January 4, 2007, 10:12am UTC](https://forums.speedlife.net/t/finance-calculations/22555 "2007-01-04T10:12:36Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@drvnkd](https://forums.speedlife.net/u/drvnkd)
#### Post date: [January 4, 2007, 10:12am UTC](https://forums.speedlife.net/t/finance-calculations/22555/1 "2007-01-04T10:12:36Z")
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 🙂
---
### Author:  [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)
#### Post date: [January 4, 2007, 10:34am UTC](https://forums.speedlife.net/t/finance-calculations/22555/2 "2007-01-04T10:34:51Z")
[http://math2.org/math/general/interest.htm](http://math2.org/math/general/interest.htm)
that?
---
### Author:  [@drvnkd](https://forums.speedlife.net/u/drvnkd)
#### Post date: [January 4, 2007, 12:15pm UTC](https://forums.speedlife.net/t/finance-calculations/22555/3 "2007-01-04T12:15:44Z")
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 😃
---
### Author:  [@Nikuk](https://forums.speedlife.net/u/Nikuk)
#### Post date: [January 4, 2007, 6:28pm UTC](https://forums.speedlife.net/t/finance-calculations/22555/4 "2007-01-04T18:28:12Z")
except that formula doesnt account for daily compounding. or, any compounding for that matter.
---
### Author:  [@drvnkd](https://forums.speedlife.net/u/drvnkd)
#### Post date: [January 5, 2007, 6:13am UTC](https://forums.speedlife.net/t/finance-calculations/22555/5 "2007-01-05T06:13:59Z")
it matches the charge on my CC statement, so i’m happy with it.
---
### Author:  [@JaysGreenLX](https://forums.speedlife.net/u/JaysGreenLX)
#### Post date: [January 5, 2007, 6:29am UTC](https://forums.speedlife.net/t/finance-calculations/22555/6 "2007-01-05T06:29:55Z")
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.