Please help math experts?

Question

I making report now, my boss ask me to find the percent increase of the following;

2005 price (US Dollar)

Item 1. 300
Item 2. 20,282.00
Item 3. 72,061.04
Item 4. 674,893.00
Item 5. 495,229.17

2007 price (US Dollar)

Item 1. 2,600.00
Item 2. 79,425.00
Item 3. 99,672.37
Item 4. 962,702.65
Item 5. 913,330.00



What is the percent increase from 2005 to 2007 for item 1 to 5...

Can you give me the formula for the excel..

Thanks for your help....

Answer 1

Percent increase = (new value - old value) / old value

Item 1 example
% increase = (2600 - 300) / 300
% increase = 766.67%

If you want the annual % increase you would divide by 2 (simple interest) or you would need to use financial values

In Excel
if you wanted total % increase and 2005 values were in column A and 2007 in column B
(B1-A1)/A1

If you wanted simple annual percentage increase
(B1-A1)/A1/2

If you wanted annual compounded percentage increase
=RATE(2,0,-A1,B1)
= 194% compounded annually

Answer 2

I can't help you with the excel part, but here is the formula:

(Price in 2007 - Price in 2005) / Price in 2005 multiplied by 100.

Let us do all the five items:

Item 1: [(2600 - 300) / 300] X 100 = 766.67

Item 2: 291.60 is the answer [ (79425 - 20282)/20282] X 100

I think you can now do the rest.

Answer 3

2005 Total
$1,262,765.21

2007 Total
$2,057,730.02

Subtract 2005 from 2007 totals
2,057,730.02 - 1,262,765.21 = $ 794964.81

The percent
794964.81/1262765.21 = .06295

Multiply by 100
.06295 x 100 = 62.95

Round
63%

Answer 4

Aristotle Winger Dr. Aristotle Winger gained his Ph. D on the age of 26 from Carnegie Mellon college interior the area of Mathematical Sciences. A graduate of the Howard college sort of 1998, he's plenty extra effective than basically a mathematician. He has been Professor of arithmetic at Emory and Henry college in Southwestern Virginia because of the fact the autumn of 2004.

Answer 5

for item 1,increase=2600-300=2300
%increase=2300/300*100=766.6%

for item 2,increse=79425-20282=59143
%increase=59143/20282*100=291.6%

for item 3, increase=99672.37-72061.04=27611.33
%increase=27611.33/72061.04*100=38.31%

for item 4, increase=962702.65-674893.00=287809.65
% increase=287809.65/674893*100=42.64%

for item 5,increase=913330-495229.17=418100.83
%increase=418100.83/495229.17*100=84.42%

Answer 6

(2600/300 - 1)*100% = 766.67%

=(new/old-1)*100