Trend Percentage Analysis – A First Look
Think of a cricket player's performance over five seasons. You don't just look at the runs in each season; you ask: how much has this player improved compared to his first season? That's exactly what Trend Percentage Analysis does for a business's financial data.
Everyday Intuition
Suppose you earned ₹50,000 in 2020 and ₹60,000 in 2021. The increase is ₹10,000. But is that a big jump or a small one? To know, you compare it to the base year (2020). The trend percentage for 2021 would be:
50,00060,000×100=120%
This means your income in 2021 is 120% of what it was in 2020 — a 20% rise. Now imagine doing this for every item in a company's Profit & Loss statement over 5 years. That's Trend Percentage Analysis.
Precise Meaning
Trend Percentage Analysis (also called Horizontal Analysis) is a technique where each item in a financial statement (like Sales, Cost of Goods Sold, Net Profit) is expressed as a percentage of the same item in a base year. The base year is usually the earliest year in the series, and its value is taken as 100%.
Trend Percentage=Base Year FigureCurrent Year Figure×100
For example, if Sales in 2020 (base year) were ₹2,00,000 and in 2023 they were ₹3,00,000, the trend percentage for 2023 is:
2,00,0003,00,000×100=150%
This tells you sales have grown to 150% of the base year level.
Why It Matters
Trend percentages reveal direction and speed of change — something absolute numbers hide. A company might show rising profits in rupees, but trend analysis could reveal that costs are rising even faster, squeezing margins. It helps:
- Spot consistent growth or decline in sales, expenses, or profits.
- Compare performance across years without being misled by inflation or size differences.
- Identify problem areas (e.g., administrative expenses growing faster than sales).
Accounting Treatment – No Debit/Credit
Here's a crucial point: Trend Percentage Analysis is not a journal entry. It does not involve debiting or crediting any account. It is a financial analysis tool, not an accounting transaction. You never record "trend percentage" in the books of accounts.
Instead, it is presented in a comparative statement or a trend analysis table as part of financial statement analysis. The NCERT textbook (Class 12, Part B, Chapter on Financial Statement Analysis) shows it as a separate column in a comparative income statement or balance sheet.
Format / Proforma (as per NCERT) …