#### Calculation of Credit Card %

```Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
CHARGES on XL?
TX.
```
 0
Utf
4/4/2010 1:37:01 PM
excel.misc 78881 articles. 5 followers.

10 Replies
494 Views

Similar Articles

[PageSpeed] 25

```What do you want to know?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Trainee" <Trainee@discussions.microsoft.com> wrote in message
> Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
> CHARGES on XL?
> TX.

```
 0
Niek
4/4/2010 2:23:03 PM
```If A1 contains 1500.00 and B1 the 12.99 in C1 input =A1*B1%

--
Russell Dawson
Excel Student

"Trainee" wrote:

> Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
> CHARGES on XL?
> TX.
```
 0
Utf
4/4/2010 2:27:01 PM
```I guess this is the formula I'm looking for, probably just need to divide
it for 12(months) to get the monthly FINANCE CHARGES IN C1

"Russell Dawson" wrote:

> If A1 contains 1500.00 and B1 the 12.99 in C1 input =A1*B1%
>
> --
> Russell Dawson
> Excel Student
>
>
>
> "Trainee" wrote:
>
> > Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
> > CHARGES on XL?
> > TX.
```
 0
Utf
4/4/2010 2:32:01 PM
```The monthly finance charges in C1
"Niek Otten" wrote:

> What do you want to know?
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Trainee" <Trainee@discussions.microsoft.com> wrote in message
> > Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
> > CHARGES on XL?
> > TX.
>
```
 0
Utf
4/4/2010 2:33:01 PM
```Remember to make your questions clear in future by setting out what you

To get a full response to questions you must state exactly what you are
trying to achieve, e.g. you didn't specify that you wanted the monthly
charges.

Just watch out for the over judicious use of UPPER CASE.

Regards
--
Russell Dawson
Excel Student

"Trainee" wrote:

> I guess this is the formula I'm looking for, probably just need to divide
> it for 12(months) to get the monthly FINANCE CHARGES IN C1
>
>
> "Russell Dawson" wrote:
>
> > If A1 contains 1500.00 and B1 the 12.99 in C1 input =A1*B1%
> >
> > --
> > Russell Dawson
> > Excel Student
> >
> >
> >
> > "Trainee" wrote:
> >
> > > Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
> > > CHARGES on XL?
> > > TX.
```
 0
Utf
4/4/2010 3:03:01 PM
```a1: Annual interest rate (12.99%)
b1: Balance
c1: =b1*a1/12

Regards,
Fred

"Trainee" <Trainee@discussions.microsoft.com> wrote in message
news:AAA4DE00-F6FA-4732-B5BB-A653902B4680@microsoft.com...
>
> The monthly finance charges in C1
> "Niek Otten" wrote:
>
>> What do you want to know?
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>> Microsoft MVP - Excel
>>
>> "Trainee" <Trainee@discussions.microsoft.com> wrote in message
>> > Let's say a balance of 1500.00 at 12.99% how do we calculate the
>> > FINANCE
>> > CHARGES on XL?
>> > TX.
>>

```
 0
Fred
4/4/2010 3:45:01 PM
```Sun, 4 Apr 2010 06:37:01 -0700 from Trainee
<Trainee@discussions.microsoft.com>:
>
> Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
> CHARGES on XL?
> TX.

It's really, really, really hard: multiply the two and divide by 12.

This isn't an Excel problem, it's a problem in business arithmetic.
You'd probably have learned more if you'd studied the examples in

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
Shikata ga nai...
```
 0
Stan
4/4/2010 5:04:17 PM
```"Trainee" <Trainee@discussions.microsoft.com> wrote:
> I guess this is the formula I'm looking for, probably just need to divide
> it for 12(months) to get the monthly FINANCE CHARGES IN C1

But I hope you understand that that is only an estimate of the monthly
finance charges.

You wrote previously:
> Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
> CHARGES on XL?

Generally, for credit card accounts in the US, you cannot use the balance at
the end of the billing cycle as basis for the calculation -- although the
degree of the inaccuracy depends on how you use your credit card event.

The details are in the disclosure statement (and updates) that the credit
card company sent to you.

Generally, interest is calculated by multiplying the daily interest rate
(usually a variable annual rate as of the first day of the billing cycle
divided by 365) by the average daily balance (ADB) during the billing cycle,
then multiplied by the number of days in the billing cylce.

So if the balance of your account was \$10,000 for 30 days, but zero on the
31st day, your finance charge would not be zero (0 * 12.99%/12).  Instead,
it would be about \$106.77 -- (30*10000/31) * (12.99%/365) * 31.

And of course, an account balance is normally not constant throughout the
billing cycle (less one day, in my example).  Instead, the ADB is calculated
by AVERAGE(A1:A31), where A1:A31 is the balance at the end of each day of
the billing cycle.

Needless to say, that is too detailed for most of us to calculate.

Alternatively, assuming that your account grows daily (except for the
payment for the previous billing period, usually received in the middle of
the period), I would estimate the ADB by taking the ending balance (or the
largest daily balance in my example above) divided by the total days in the
billing cycle (i.e. the average amount added to the balance daily), multiply
by the sum of the days, then divide by the total days.  For my example:
(10000/31)*31*(31+1)/2 / 31.  Algebraically, this can be reduced to
10000*(31+1)/2/31.

Thus, the finance charge in my example would be estimated by the following,
making some algebraic simplifications:  (10000*(31+1)/2) * (12.99%/365) --

(BTW, that can be written more succinctly as 12.99%*10000*(31+1)/2/365.)

As you can see, that is significantly less than the original estimate of
\$106.77, and less than 10000*12.99%/12 (\$108.25).

----- original message -----

"Trainee" <Trainee@discussions.microsoft.com> wrote in message
news:FD5E4A39-24BC-4287-BBFF-0AAAB593788F@microsoft.com...
>I guess this is the formula I'm looking for, probably just need to divide
> it for 12(months) to get the monthly FINANCE CHARGES IN C1
>
>
> "Russell Dawson" wrote:
>
>> If A1 contains 1500.00 and B1 the 12.99 in C1 input =A1*B1%
>>
>> --
>> Russell Dawson
>> Excel Student
>>
>>
>>
>> "Trainee" wrote:
>>
>> > Let's say a balance of 1500.00 at 12.99% how do we calculate the
>> > FINANCE
>> > CHARGES on XL?
>> > TX.

```
 0
Joe
4/4/2010 5:11:57 PM
```I wrote:
> BTW, that can be written more succinctly as 12.99%*10000*(31+1)/2/365.

I should have noted that 31 is an example, not a constant, just as 12.99%
and 10000 are examples.  Instead of writing 31, you would calculate it by
B1-A1, where A1 and B1 are the starting and ending dates of the billing
cycle respectively.

In contrast, 365 is a constant, at least for my credit card accounts.  But
some credit card companies might use 366 in leap years.

----- original message -----

"Joe User" <joeu2004> wrote in message
news:%230EYvnB1KHA.5828@TK2MSFTNGP02.phx.gbl...
> "Trainee" <Trainee@discussions.microsoft.com> wrote:
>> I guess this is the formula I'm looking for, probably just need to divide
>> it for 12(months) to get the monthly FINANCE CHARGES IN C1
>
> But I hope you understand that that is only an estimate of the monthly
> finance charges.
>
>
> You wrote previously:
>> Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
>> CHARGES on XL?
>
> Generally, for credit card accounts in the US, you cannot use the balance
> at the end of the billing cycle as basis for the calculation -- although
> the degree of the inaccuracy depends on how you use your credit card
> event.
>
> The details are in the disclosure statement (and updates) that the credit
> card company sent to you.
>
> Generally, interest is calculated by multiplying the daily interest rate
> (usually a variable annual rate as of the first day of the billing cycle
> divided by 365) by the average daily balance (ADB) during the billing
> cycle, then multiplied by the number of days in the billing cylce.
>
> So if the balance of your account was \$10,000 for 30 days, but zero on the
> 31st day, your finance charge would not be zero (0 * 12.99%/12).  Instead,
> it would be about \$106.77 -- (30*10000/31) * (12.99%/365) * 31.
>
> And of course, an account balance is normally not constant throughout the
> billing cycle (less one day, in my example).  Instead, the ADB is
> calculated by AVERAGE(A1:A31), where A1:A31 is the balance at the end of
> each day of the billing cycle.
>
> Needless to say, that is too detailed for most of us to calculate.
>
> Alternatively, assuming that your account grows daily (except for the
> payment for the previous billing period, usually received in the middle of
> the period), I would estimate the ADB by taking the ending balance (or the
> largest daily balance in my example above) divided by the total days in
> the billing cycle (i.e. the average amount added to the balance daily),
> multiply by the sum of the days, then divide by the total days.  For my
> example: (10000/31)*31*(31+1)/2 / 31.  Algebraically, this can be reduced
> to 10000*(31+1)/2/31.
>
> Thus, the finance charge in my example would be estimated by the
> following, making some algebraic simplifications:  (10000*(31+1)/2) *
>
> (BTW, that can be written more succinctly as 12.99%*10000*(31+1)/2/365.)
>
> As you can see, that is significantly less than the original estimate of
> \$106.77, and less than 10000*12.99%/12 (\$108.25).
>
>
> ----- original message -----
>
> "Trainee" <Trainee@discussions.microsoft.com> wrote in message
> news:FD5E4A39-24BC-4287-BBFF-0AAAB593788F@microsoft.com...
>>I guess this is the formula I'm looking for, probably just need to divide
>> it for 12(months) to get the monthly FINANCE CHARGES IN C1
>>
>>
>> "Russell Dawson" wrote:
>>
>>> If A1 contains 1500.00 and B1 the 12.99 in C1 input =A1*B1%
>>>
>>> --
>>> Russell Dawson
>>> Excel Student
>>>
>>>
>>>
>>> "Trainee" wrote:
>>>
>>> > Let's say a balance of 1500.00 at 12.99% how do we calculate the
>>> > FINANCE
>>> > CHARGES on XL?
>>> > TX.
>

```
 0
Joe
4/4/2010 5:23:42 PM
```The question was as to how it can be done in Excel.
--
Russell Dawson
Excel Student

"Stan Brown" wrote:

> Sun, 4 Apr 2010 06:37:01 -0700 from Trainee
> <Trainee@discussions.microsoft.com>:
> >
> > Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE
> > CHARGES on XL?
> > TX.
>
> It's really, really, really hard: multiply the two and divide by 12.
>
> This isn't an Excel problem, it's a problem in business arithmetic.
> You'd probably have learned more if you'd studied the examples in
>
> --
> Stan Brown, Oak Road Systems, Tompkins County, New York, USA
> Shikata ga nai...
> .
>
```
 0
Utf
4/4/2010 6:31:01 PM

Similar Artilces:

I have a workbook with multiple sheets. Two of the sheets each have a different VBA function in several Cells. When I switch between the sheets, the values returned by the function are gone and a "Calculate" has to be done. I have Application.Volatile turned on, otherwise I have PF9 everytime. How can I preserve the value when I switch between sheets? Thank you.... "Bruce A. Julseth" <bruceaj_nospam@bellsouth.net> wrote in message news:uD3xvUrcKHA.1652@TK2MSFTNGP05.phx.gbl... >I have a workbook with multiple sheets. Two of the sheets each ...

Date-Time Calculations
I need to create a little spreadsheet to calculate dates for drug tests. The two inputs are (1) the date & time when the test was taken and (2) the time period that the test covers. The output is the date when the test coverage starts. That's simple except that the units vary. Some tests are good for hours and others for days. One test can detect alcohol usage for 80 hours. Another can detect drug use for 90 days. If the test duration units are hours, something like this will work: A B C D E 1 7/08/08 9:15 am Timesta...

Calculate % from list of scores or ratings
I have eight responses to an evaluation that scored experience from 0 (worst) to 10 (best). From the results posted below, I need to compute % of responses received for each 0 -10 score received. I also need to compute one overall combined % for the evaluations received. Rating Score # of Responses 0 0 1 0 2 0 3 1 4 2 5 0 6 ...

Calculate very slow
I have my calculate set to automatic and calculations are getting done automatically, but at a very slow rate. The word calculate is constantly on, on the status/task bar at the bottom of the screen and when you enter a number or delete it, the 'Ready' changes to 'Calculating cells: ??%' and this is when it is now going slow. Any ideas..?? Look here: http://decisionmodels.com/calcsecrets.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Rayasiom" <Rayasiom@discussions.microsoft.com> wrote in message news:D1AF7DB1-7DE0-4412-B739-62317333273B@micros...

Calculating the number of months
I have a column for start date and end date. I would like a formular that tells me how many months it is including the start month and end month. ex. Start date: 11/1/2009 end date: 4/1/2010 this would be 6 months if you include November and April. Thanks in advance hi assuming that start date is in A1 and end date is in b1.... =DATEDIF(A1,B1,"m")+1 regards FSt1 "Philangr8" wrote: > I have a column for start date and end date. I would like a formular that > tells me how many months it is including the start month and end month. > > e...

Find formula not calculating?
Hi All I'm using Excel 2007 on Windows Vista. I have a decription in column I like "S/back 2.0 TDI SE DSG " and in column Q I have the formula FIND("DSG",\$I2). Looks simple enough to me but it isnt bringing the result I want! Just an #VALUE! error value. Can anyone see what I am doing wrong? In column R I have FIND("multi",\$I2) and thats working fine!! Many Thanks! Adam If your description is accurate (i.e., that \$I2 contains "S/back 2.0 TDI SE DSG "), then your formula in column R (FIND("multi",\$I2) should return #VALUE!, so ar...

Calculate #2
Calculate never goes away in the Status Bar. I have a rather small workbook in which I've deleted all links to try and reduce the number of calculations. Each time I hit F9 or Ctrl-Alt-F9 the Status bar flashes 6% and then still Calculate. Any ideas? Thanks, Adam http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References AdamMCW wrote: > > Calculate never goes away in the Status Bar. I have a rather small workbook > in which I've deleted all links to try and reduce the number of calculations. > ...

Showing + and
Hello Everyone I have 3 number fields, all currency in a form. I have Budget Amount, Estimate Amount and Difference. What I would like to do is to make the Difference work automatically, I know you would normally do the is the control source part of the field but what I need is for it to also display a + or - in front of the answer so for example. .. Budget £200 Estimate £220 Difference will show +£20 Budget £400 Estimate £250 Difference will show -£150 Can anyone help as to what the code would be for this? Thank You !! -- Message posted via AccessMonster.c...

Subtotal a calculated field in a pivot table
I'm creating a pivot table listing Accounts Receivable transactions by customer. It includes both payments and invoices in the results. Unfortunately both payments and invoices are listed as positive numbers, so I can't just subtotal the "amount" column. I've created a formula field in the pivot called "calcamt" that contains an if statement. The if statement examines the transaction type code and if it indicates a payment, multiplies the amount column by -1. Otherwise it just returns the amount column as a positive number. When I drag the calcamt field int...

Problem Calculating SUms in Tabular Reports
I have created a couple reports from Crosstab queries and when I go to sum up the columns I seem to get the number of rows as the amount every time. For example: My columns labeled 1 through 10 and there are 10 rows. I use the following command: =sum(1) then =sum(2) etc. I then get the following results: 10, 20, 30, as the totals of each column. Access seems to be summing the number of rows and adding the previous sum. Any ideas? Grant No guarantee, but the first thing I would try would be to make sure taht Access is recognizes that you are referring to fields. =Sum([1]) =Sum([2]) -- ...

Reducing repetitive calculation not working
A B C 1 Fruit Qty =INDEX(\$1:\$1048576,2,2):INDEX(\$1:\$1048576,4,2) 2 Apple 1 3 Orange 2 4 Apple 3 Why does =SUMIF(A2:A4,"Apple",B2:B4) return the correct value ... .... while =SUMIF(A2:A4,"Apple",C1) returns a #VALUE error ? The reason I'm not including the formula in C1 as the sum_range in the SUMIF formula is to reduce the number of duplicate calculations (100,000+). I tried creating a name with the formula in C1 and using the name in the SUMIF formula as the sum_range and that works. But since the sum_range changes, I would have to use the OFFSET function to inc...

I setup and accept the multi tender Gift Card in my store. This is the problem that I just find out. I have a \$20 gift card and using it to redeem a purchase of \$25, the balance is 5 dollars. Another gift card tender is pop up in order to allow me to accept another gift card. But the problem is that I use the same gift card that I already redeem above and enter 5 dollars on the second gift card tender. The RMS still accept it and processing the completed transation and print out the receipt for customer with the balance left is 15 dollars. But When I go back the jounal and check t...

Calculating hours worked in a day
I'm trying to create a time sheet for employees to enter their daily time. I want them to put in the time they came in (ex. 7:50 AM), and the time they went home (5:15 PM). I want a to be able to calculate the number of hours worked. In this case it would be 9.42 hours. How would I be able to do that? Thanks, Jasper Bonjour, *Jaz* the time they came in in E6 (19:50) format, hh:mm the time they went home in F6 (5:15) format, hh:mm =MOD(F6-E6;1)/"1:" Format, standard gives 9.42 -- Bien amicordialement, P. Bastard > I'm trying to create a time sheet for employ...

Ytd Calculation In Pivot #3
For some reason that I do not know I could not read threads but now I a back. I would like to thank you for your answer but I think that I confuse you somehow. What I actually try to present are the weekly sales of my compan stores (about 100 stores) and number of customers for each shop, i contrast with the previous year (2004 vs 2003) for every week and als YTD for the current week (also 2004 vs 2003) for comparable shops. I tried to do a pivot, with the following format: Column A shops, column B 2004 sales for the running week, column C 200 sales for the running week, column D ytd sale...

AMEX
I have 2 cards tied to my AMEX account. (3 total = Mine + wife's + Business) The correct transactions download to the correct account numbers, but the total shown for each card is still that of all three cards combined. Then, in any report, Money adds this combined total three times to generate an inaccurate total that is triple what it should be. Suggestions anyone? -- DT I have seen this too but it puts my Corp Amex in there too. Kind of skewsmy spending on travel/ent. Hope and answer comes up soon. The way I was able to seperate my Business Amex from my personal was to cre...

How do i calculate fiscal week of the year
Hi, I would like to know how to calculate fiscal week of the year. for example, the first week of the year is started from Feb 1, 2005 instead of Jan. =INT((A1-DATE(2005,2,1))/7)+(WEEKDAY(A1)<7) -- HTH Bob Phillips <evlai@hotmail.com> wrote in message news:1127314586.929249.152250@g14g2000cwa.googlegroups.com... > Hi, > > I would like to know how to calculate fiscal week of the year. for > example, the first week of the year is started from Feb 1, 2005 instead > of Jan. > Thanks Bob, i really appreciate it, i will try to see of this works for my file T...

calculating time 03-25-10
Hi, I have to calculate the following Employee job in must be 9:00 am, but employee arrived 8.53 am. Which formula must I use to calculate the 7 min ? Hi, take a look at CPearson web has everything related to timesheet http://www.cpearson.com/excel/overtime.htm "Xavie" wrote: > Hi, > > I have to calculate the following > Employee job in must be 9:00 am, but employee arrived 8.53 am. > Which formula must I use to calculate the 7 min ? Hi, Start time in A1 and arrival time in b1 =A1-B1 But this will fail if an employee is late so it'...

PivotTable: Customized Calculations
I have salary data in an EXCEL spreadsheet (each row contains the salary for one individual). I wish to construct a PivotTable that counts the number of individuals in each of several salary intervals that I would specify (\$0 - \$19,999; \$20,000 - \$29,000, etc.) How do I do this? I believe that reporting on such customized calculations are possible, but I can't find any explicit guidance. Thanks for your help. You could add a column to the data table, and calculate the salary groupings there. Create a lookup table with the categories, e.g.: 0 \$0-\$19,999 20000 \$20-\$29...

Trying to calculate a time sheet formula
Hello I am trying to create a spread sheet that the user can put in there time and it will total the total hours owed then what is regular , overtime and double time. I have been able to put in the start time of 7:00 am and Finish 4:30 pm less lunch. I have the total hours but I can't figure out how to get the total hours to be pull into the cell as regular which is 8 hours or less and anything over 8 hours but less than 12 and anything over 12. If anyone has an idea has to what I can do I would greatly appreciate your help Thanks adc Hi have a look at http://www.cpearson.com/excel/over...

how do i set up automatically calculate or run expressions
im trying to program something and im trying to create expression on form but it wont do it... i always have to go to properties then exit before the expressions i made take effect...any body can help me On Tue, 4 Dec 2007 18:03:01 -0800, help!!!!!!!!!!!!!!!!!!!!!!!!!!!! <help!!!!!!!!!!!!!!!!!!!!!!!!!!!!@discussions.microsoft.com> wrote: >im trying to program something and im trying to create expression on form but >it wont do it... i always have to go to properties then exit before the >expressions i made take effect...any body can help me Not unless you tell us what you...

Bleed
Hello, I need a bleed on my business card composition with 2 differents colors before I submit the work for print. I need as well guiding lines to cut properly the business cards Can somebody help me on this ? Thanks Nicolas If you are going to cut the cards yourself you would make it easier if you bought Business card stock in whatever background you like and just break it up at the micro perforations. If you are going to a comercial printer, then I am sure he can cut to dimensions and not need cut marks. -- John G. "Nicolas" <Nicolas@discussions.microsoft.com> ...

Calculating Date difference in 2 ways
Hi, If in cell A1 I write -- = today() - date(2004,12,31) then the answer I get is a number ( let's say 14 or 15) But if in cell B1 If i write -- = C1 - D1 where C1 -- = Today() and D1 -- = date(2004,12,31), the answer I get is in date format (in excel's 1900 base year) Why is there a diference in formatting of results between the above 2 approaches. Regards, Hari India Hi Jim and Aladin, I have not written my initial query properly. My doubt is that inspite of the same formulas and with both A1 and B1 having no previous formating, what causes excel to interpret these 2 approac...