Question

Calculate trend percentages from the following figures of ABC Limited, Taking year 2,000 as base.

$\begin{array}{cccc}\text{Year}& \text{Sales}& \text{Stock}& \text{Profit Before Tax}\\ 2000& 1500& 700& 300\\ 2001& 2140& 780& 450\\ 2002& 2365& 820& 480\\ 2003& 3020& 930& 530\\ 2004& 3500& 1160& 660\\ 2005& 4000& 1200& 700\end{array}$

Answer 1

Trend Percentages
(Base Year 2000 = 100)

$\begin{array}{ccccccc}\text{Years}& \text{Sales (Rs.)}& \text{Trend (\%)}& \text{Stock (Rs.)}& \text{Trend (\%)}& \text{Profit after}& \text{Trend}\\ & & & & & \text{Tax (Rs.)}& \text{(\%)}\\ 2000& 1500& 100.00& 700& 100.00& 300& 100.00\\ 2001& 2140& 142.67& 780& 111.43& 450& 150.00\\ 2002& 2365& 157.67& 820& 117.14& 480& 160.00\\ 2003& 3020& 201.33& 930& 132.86& 530& 176.67\\ 2004& 3500& 233.33& 1160& 165.71& 660& 220.00\\ 2005& 4000& 266.67& 1200& 171.43& 700& 233.33\end{array}$

$\text{Trend Percentage}=\frac{\text{Present Year Value}}{\text{Base Year Value}}\times 100$