|
| 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
April 4th, 2005, 04:17 PM
|
|||
|
|||
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
April 4th, 2005, 06:11 PM
|
|||
|
|||
|
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
April 4th, 2005, 09:19 PM
|
|||
|
|||
|
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
April 5th, 2005, 01:19 PM
|
|||
|
|||
|
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
April 5th, 2005, 01:25 PM
|
|||
|
|||
|
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 |
Linear Mode
