I am trying to determine a 6mo. yearly growth chart
to show increase in monthly profit?
What would the formula be to do this?

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?

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?

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?

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?