Vertical Growth Percentage?
 

I have 4 years of annual figures that I need to show a Vertical Growth
Percentage for...I am STUCK on the formula to use!
Example:
year 2001: $568,808.24
year 2002: $557,311.98
year 2003: $649,831.71
year 2004: $666,971.40
The resulting Vertical Growth should be 17.26%

How did they come up with this percentage using a formula???

Vertical Growth Percentage?
 

=(A4-A1)/A1

Format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Arealtor12345" wrote in message
...
I have 4 years of annual figures that I need to show a Vertical Growth
Percentage for...I am STUCK on the formula to use!
Example:
year 2001: $568,808.24
year 2002: $557,311.98
year 2003: $649,831.71
year 2004: $666,971.40
The resulting Vertical Growth should be 17.26%

How did they come up with this percentage using a formula???

Vertical Growth Percentage?
 

Assuming all of your data is in B1 to B4:

=(B4-B1)/B1 Format as %

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Arealtor12345" wrote:

I have 4 years of annual figures that I need to show a Vertical Growth
Percentage for...I am STUCK on the formula to use!
Example:
year 2001: $568,808.24
year 2002: $557,311.98
year 2003: $649,831.71
year 2004: $666,971.40
The resulting Vertical Growth should be 17.26%

How did they come up with this percentage using a formula???

Vertical Growth Percentage?
 

"Arealtor12345" wrote:
I have 4 years of annual figures that I need to show a Vertical Growth
Percentage for...I am STUCK on the formula to use!
[....]
The resulting Vertical Growth should be 17.26%
How did they come up with this percentage using a formula?

Others have answered your question, namely: =(666,971.40 / 568,808.24) - 1

formatted as Percentage.

However, that is __not__ "vertical growth analysis", at least according to
http://accounting-financial-tax.com/...ial-statements
and
http://books.google.com/books?id=_ou...ed=0CBYQ6AEwBA .

The difference between horizontal and vertical analysis is: horizontal
analysis compares actual figures (e.g. dollar amounts), whereas vertical
analysis compares percentages (relative sizes).

What you are doing is an example of horizontal analysis. An example
vertical analysis might be.... The percentage of new home sales to total
sales is 20%, 30%, 40% and 50% in the years 2001 through 2004. How has the
percentage of new home sales changed from 2001 to 2004?

I don't know if you are simply using the wrong term for what you need to do,
or if you are doing the wrong thing for the type of analysis that you need
to do.


----- original message -----

"Arealtor12345" wrote in message
...
I have 4 years of annual figures that I need to show a Vertical Growth
Percentage for...I am STUCK on the formula to use!
Example:
year 2001: $568,808.24
year 2002: $557,311.98
year 2003: $649,831.71
year 2004: $666,971.40
The resulting Vertical Growth should be 17.26%

How did they come up with this percentage using a formula???