One change in revenue total revenue old revenue and two change in quantity total quantity old quantity. Year 1 revenue cell D3 60000 Year 2 revenue cell E3 Year 1 revenue cell D3 x 1 increase Year 2 revenue 60000 x 1 80 Year 2 revenue 108000 The revenue projection formula to enter in cell E3 is therefore D3180. Divide this difference in revenue by the later years revenue.
The 196 is normally the amount found on the top line of the income statement.
So lets say once again this is the formula 2019 revenue minus 2020 revenue divided by 2019 revenue multiplied by a hundred. One change in revenue total revenue old revenue and two change in quantity total quantity old quantity. Sales Revenue formula Units Sold x Sales Price. Lets say that we have for 2019 either annual or a quarter 60000 for 2019.