Q.The expenses of the current year of a company is ₹ 6,00,000; and if it is increased by 20% compared to the previous year, what would be the expenses of the previous year?

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:

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%.

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:

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) …