0
You have the current volume of sales and percent change vs a year ago but you need to calculate the year ago volume is there a formula or macro to get this done?
Wiki User
∙ 14y ago
If I get this right you know the volume of sales for this year and know the percentage that it changed since last year and need to know the volume of last year?
First, you need to know what percent of last years volume that this years volume is, if not ...
let's say it increased by x% then this year the volume is 100+x% of last year or
if it decreased by x% then this years volume is (100-x)% of last year
Second,
volume this year = percentage change* last years volume
percentage means per 100 and "of" means multiply
so for example if this year the volume is 150 and it increased by 50%
then your percentage of last year is 150
150 = 150/100 * last years volume
150 = 1.5 * last years volume
150/1.5 = last years volume
100 = last years volume
Hope this helps..
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How do you calculate a paticular year growth percent?
(Final-Initial)/(Initial) is the formula for percent change (multiply by 100 to make it a percentage) I think this is what you are looking for.
What is the percent of change formula?
100 %
What formula is used to calculate accelation?
Change in velocity / time
How can you calculate percentage change per year on a balance sheet?
Subtract the previous year from the current year. Take that amount and divide by the previous year's amount. That will give you the percent. Example: Current assets 2010 550,000 2009 533,000 Increase of 17,000, percent increase is 3.2%
Find percent of change from 60 to 36?
Using the equation of percent of change.(Original Value - Current Value) / Originalvalue *100% = Percent change(60 - 36 ) / 60 *100 = 40%40% is the percent change
What is the formula for converting us dollars to pesos?
just multiply for the current currency like right now its 13.9971
What are the formula for power?
Power = Current * Voltage Power = Change in work/change in time
How do you calculate charge flow?
Rate of change of charge with time. its called current.
How do you calculate percent change in length?
100*(New Length/Old Length - 1)
What is percent of change?
Percent change is the percent amount some value has changed. It has phenomenal usage in every day math and in fields such as business. It's often used to calculate the percent difference in sales between years for business.
What is the formula to find percent of change?
Take the old value and subtract from the new value, then divide by the old value. Multiply by 100. That number representsthe percent change.
What jobs do percent of change?
A stock broker uses percent of change. Almost any buisness might use it to calculate the money gained over a certain period of time.
