PortPhotos Posts: 1, Reputation: 1 New Member #1 Jan 3, 2012, 03:17 PM
Calculate year ago sales from current sales and percent change
I know this years sales and the % change over Last Year ( it is down) how do I find Last Years sales?
 ebaines Posts: 12,132, Reputation: 1307 Expert #2 Jan 4, 2012, 09:18 AM
Start with the formula for percentage change from one year to the next. If we let $x_0$ be the initial value, and $x_1$ be the value one year later, then the change in sales expressed as a percent of the initial value is then:

$
p =\ \frac {\Delta x} {x_0} \times 100 \ =\ \frac {x_1 - x_0} {x_0} \times 100
$

So if you know the percent change p and the value for $x_1$ you can rearrange this to get:

$
x_0 = \frac {x_1}{(1 + \frac p {100})}
$

For example: if $x_1=1000$ and $p = 33.3%$ then

$
x_0 = \frac {1000}{(1 + \frac {33.3} {100})} = \frac {1000}{1.333} = 750
$

You can check this by substituting this value for $x_0$ back into the first equation and see if it agrees:

$
p = \frac {x_1 - x_0} {x_0} \times 100 = \frac {1000-750} {750} \times 100 = 33.3%
$

 Question Tools Search this Question Search this Question: Advanced Search

Check out some similar questions!

When calculating cost of sales on a financial statement do you use sales before discounts of after discounts?

Percent of sales method [ 4 Answers ]

Use the percent of sales method to forecast next yera's accounts payable. Current year sales are $24,500,000 and sales are expected to rise by 25%. The firm's accounts payable balance is$1,701,600. What is the projection for next year's accounts payable?

Percent of cost of sales to sales [ 1 Answers ]

How do I find the percent of cost of sales to sales.

Percent of cost of goods sold to Company sales [ 1 Answers ]

How do you compute the cost of goods sold to company sales for the year 20?2 to 20?3 and tell if the trend is favorable?