Home » Accounting » How To Determine Credit Card Charges In Excel

How To Determine Credit Card Charges In Excel

Download Business Management Templates Excel Dashboards KPI Reports

How To Calculate Credit Card Charges With Excel
Call the credit card business and request the rep for percentage that business utilizes to determine the minimal credit card charge. As a result of current principles, numerous organizations at this point need to set the minimal charge at as a great deal as 4 percentage of the equilibrium every month. Let’s loo at 4 percentage as minimal charge percentage and fourteen percentage as yearly fees in the card.
In Excel, enter within the first column, tab over and enter charge in following column, then attention and Principal in following 2 columns. The will be the titles.
Use enter to choose the following outline. Enter the current credit card equilibrium under the initial row beneath equilibrium. Tab over to the subsequent column under charge (B2) and enter in the next =.04xA2 . This signifies the minimal charge percentage out of step 1. Formula outcome could be $400.
Tab over one more time and enter in the next function to calculate the quantity of the month by moth payments which is relocating in the direction of attention: =(.14/12)xA2. Lastly, tab over when more—you could be in D2 now and enter in =B2-C2 to find any automated calculation of the quantity of principal that you’ll be having to pay down with that charge. The outcome could to illustrate the example.
Use enter when all expressions are set on deliver by yourself to excel cell A3. At this point, enter in just 1 even more formula, =A2-D2 in to the cell A3. This function will right away calculate the new equilibrium once you create a month by moth payments.
Choose cell B2, that is $400 in this case, grab the small square in lower-right edge of the cell and pull it down by using the mouse in to the cell B3. A new calculation could happen, presenting you the new minimal charge for the month. Execute the identical in C2, D2.
Choose the entire third row by using the mouse, locate the small square one more time in corner and next pull anything down any number of rows as you would want to discover the minimal charges in to eternity (each row represents a month). Plug the credit card attention and minimal charge percentage in the first line in this excel worksheet prior to drawing anything down.
Take into account that in case you make new expenses on the credit card, the principal equilibrium goes up and values will change. When you’re devoted to having to pay down the bills and by using the excel worksheet to calculate charges, you must lower up the cards.

Download Business Management Templates Excel Dashboards KPI Reports