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?

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?