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?
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..
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 do you calculate charge flow?
Charge flow can be calculated by multiplying the current (in amperes) by the time (in seconds) for which the current flows. The formula is Q = I * t, where Q is the charge flow in coulombs, I is the current in amperes, and t is the time in seconds.
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 percent change in mass?
You can calculate the percent change in mass by subtracting the initial mass from the final mass, dividing that result by the initial mass, and then multiplying by 100 to get the percentage. The formula is: ((Final mass - Initial mass) / Initial mass) * 100.
How do you calculate percent change in length?
100*(New Length/Old Length - 1)
What is the formula to calculate pH slope?
The formula to calculate pH slope is ΔpH/Δlog[H+], where ΔpH is the change in pH and Δlog[H+] is the change in the log concentration of hydrogen ions. This formula is used to determine the sensitivity of a pH electrode.
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.
