If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
determine percentage of growth
I am trying to determine a 6mo. yearly growth chart
to show increase in monthly profit? What would the formula be to do this? |
#2
|
|||
|
|||
Can you give us an example?
"restore" wrote: I am trying to determine a 6mo. yearly growth chart to show increase in monthly profit? What would the formula be to do this? |
#3
|
|||
|
|||
example would be if in 03-04 I had $25,000 total income - in 04-05 - I had
$44,000 income - how do I figure the % of growth between the two years? "Art" wrote: Can you give us an example? "restore" wrote: I am trying to determine a 6mo. yearly growth chart to show increase in monthly profit? What would the formula be to do this? |
#4
|
|||
|
|||
Assuming I understand your dates correctly, you had a profit of $25,000 in
the month of March 2004 and a profit of $44,000 in the month of April 2005. Suppose A1=$25,000 and B1=$44,000. A2=March 2004 B2=April 2005. Set A3=Month(A2)+12*Year(A2). Set B3=Month(B2)+12*Year(B2). Your annual percentage increase would be: (B1/A1)^(A3/B3)-1 I'm not entirely sure this is what you're looking for, but I hope it helps. Art "restore" wrote: example would be if in 03-04 I had $25,000 total income - in 04-05 - I had $44,000 income - how do I figure the % of growth between the two years? "Art" wrote: Can you give us an example? "restore" wrote: I am trying to determine a 6mo. yearly growth chart to show increase in monthly profit? What would the formula be to do this? |
#5
|
|||
|
|||
OOPs I made a mistake in that reply:
The last formula should be: (B1/A1)^(12/(B3-A3))-1 "Art" wrote: Assuming I understand your dates correctly, you had a profit of $25,000 in the month of March 2004 and a profit of $44,000 in the month of April 2005. Suppose A1=$25,000 and B1=$44,000. A2=March 2004 B2=April 2005. Set A3=Month(A2)+12*Year(A2). Set B3=Month(B2)+12*Year(B2). Your annual percentage increase would be: (B1/A1)^(A3/B3)-1 I'm not entirely sure this is what you're looking for, but I hope it helps. Art "restore" wrote: example would be if in 03-04 I had $25,000 total income - in 04-05 - I had $44,000 income - how do I figure the % of growth between the two years? "Art" wrote: Can you give us an example? "restore" wrote: I am trying to determine a 6mo. yearly growth chart to show increase in monthly profit? What would the formula be to do this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo Box using a Percentage Field | Rod | General Discussion | 3 | June 8th, 2004 02:11 AM |
Usinga a Percentage field in a Combo Box (can't get rid of *.00%)? | Rod | Database Design | 3 | June 8th, 2004 01:56 AM |
Percentage (%) sign in PivotTable... URGENT!!! | DDM | Worksheet Functions | 2 | May 11th, 2004 04:37 PM |