Results 1 to 2 of 2

Calculating daily interest on a credit card

This is a discussion on Calculating daily interest on a credit card within the Excel Questions forums, part of the Question Forums category; My wife and I have a few credit cards that are carrying balances. We want to get off the credit ...

  1. #1
    New Member
    Join Date
    Jan 2008
    Posts
    12

    Default Calculating daily interest on a credit card

    My wife and I have a few credit cards that are carrying balances. We want to get off the credit cycle and begin using cash only. As an educational experience for both of us, I'd like to add a cell on our budget worksheet that shows how much interest we are paying per day on a specific credit card.

    For example, one card has a balance of $2,746.50. The interest rate on this card is 8.9%. We pay it online at varying intervals, not just the due date, so I'd like to see just how much these payments affect the amount of interest that is compounding every day. More than anything else, it's meant to be motivational so that when we update the new outstanding balance we can say, "hey honey, look, we were accruing $18.17/day in interest but now they're only getting $16.48 from us".

    Anyone have any ideas?

  2. #2
    Board Regular
    Join Date
    Apr 2008
    Location
    Iowa City, IA, USA
    Posts
    361

    Default Re: Calculating daily interest on a credit card

    Quote Originally Posted by mhuntoon View Post
    For example, one card has a balance of $2,746.50. The interest rate on this card is 8.9%.
    $2,746.50 * 8.9% per annum / 365 days a year = $.66 of interest accruing each day on this particular credit card.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com