Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
What do you want to know?
-- Kind regards, Niek Otten Microsoft MVP - Excel "Trainee" wrote in message ... Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
If A1 contains 1500.00 and B1 the 12.99 in C1 input =A1*B1%
-- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Trainee" wrote: Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
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 Please hit "Yes" if this post was helpful. "Trainee" wrote: Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
The monthly finance charges in C1 "Niek Otten" wrote: What do you want to know? -- Kind regards, Niek Otten Microsoft MVP - Excel "Trainee" wrote in message ... Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
Remember to make your questions clear in future by setting out what you
really want. I answered your question quite bluntly and I had the idea that your question was not complete. 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 Please hit "Yes" if this post was helpful. "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 Please hit "Yes" if this post was helpful. "Trainee" wrote: Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
a1: Annual interest rate (12.99%)
b1: Balance c1: =b1*a1/12 Regards, Fred "Trainee" wrote in message ... The monthly finance charges in C1 "Niek Otten" wrote: What do you want to know? -- Kind regards, Niek Otten Microsoft MVP - Excel "Trainee" wrote in message ... Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
Sun, 4 Apr 2010 06:37:01 -0700 from Trainee
: 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 your textbook. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
"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 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) -- about $56.94. (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" wrote in message ... 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 Please hit "Yes" if this post was helpful. "Trainee" wrote: Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
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 ... "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 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) -- about $56.94. (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" wrote in message ... 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 Please hit "Yes" if this post was helpful. "Trainee" wrote: Let's say a balance of 1500.00 at 12.99% how do we calculate the FINANCE CHARGES on XL? TX. |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Credit Card %
The question was as to how it can be done in Excel.
-- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Stan Brown" wrote: Sun, 4 Apr 2010 06:37:01 -0700 from Trainee : 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 your textbook. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Credit card Calculation | Excel Discussion (Misc queries) | |||
Credit Card Calculation | Excel Discussion (Misc queries) | |||
Credit Card Number | Excel Worksheet Functions | |||
Credit Card # | Setting up and Configuration of Excel | |||
How long will it take to pay off my credit card | Excel Discussion (Misc queries) |