FINAL
FINAL
Trend Analysis is a financial analysis technique used to study the direction and pattern of
changes in financial data over a period of time. It helps determine whether a company’s
sales, expenses, profits, assets, liabilities or other financial indicators are increasing, decreasing
or remaining stable.
The technique developed alongside financial statement analysis during the late 19th and
early 20th centuries, when businesses, investors and financial institutions increasingly began
comparing financial statements across different years. Therefore, it is not attributed to one
particular person. The development of ratio analysis and comparative financial statements
contributed significantly to the evolution of modern trend analysis.
In trend analysis, one year is selected as the base year and its value is normally taken as 100.
The figures for subsequent years are expressed as a percentage of the base-year figure. This
makes it easier to identify long-term movements and patterns in a company's financial
performance.
For example, if a company's sales were ₹10 lakh in the base year and ₹15 lakh after three years,
the trend percentage would be 150%, indicating that sales increased by 50% compared with
the base year.
Trend analysis is useful for management, investors, creditors and other stakeholders
because it provides a simple picture of the company's financial direction. A consistent increase
in revenue and profit may indicate growth, while declining profits or continuously increasing
expenses may indicate areas requiring attention.
Thus, trend analysis is an important tool of financial statement analysis that helps users
understand past performance, identify patterns and support future financial planning
and decision-making.
3
5. To Assist in Forecasting
Past trends can provide useful information for estimating possible future performance.
Management can use these patterns while preparing budgets and financial plans.
6. To Support Decision-Making
The information obtained through trend analysis helps management and investors
make better financial and business decisions.
9. To Facilitate Comparison
Trend percentages can make it easier to compare the movement of different financial
items and, where appropriate, the performance of different companies.
Practical Analysis
BMW
BMW Group, officially known as Bayerische Motoren Werke AG (BMW AG), is a leading
German automobile and motorcycle manufacturer headquartered in Munich, Germany. The
company was founded in 1916 and initially operated in the aircraft-engine industry before
becoming well known for automobiles and motorcycles. BMW Group operates major brands
including BMW, MINI and Rolls-Royce Motor Cars and sells its products in markets around
the world. The company is known for producing premium automobiles, electric vehicles,
motorcycles and mobility-related products, with a strong focus on engineering, technology,
performance and innovation. BMW has also been expanding its electric vehicle portfolio as
part of its strategy for sustainable and technologically advanced mobility.
Financial Data
Trend Analysis
2024 Trend 2025 Trend 2026 Trend
Particulars 2024 2025 2026
% % %
Equity Share Capital 22.51 22.51 22.51 100.00 100.00 100.00
Reserves & Surplus 612.69 671.55 784.44 100.00 109.61 128.03
Total Shareholders' Funds 635.20 694.06 806.95 100.00 109.27 127.04
Long-Term Borrowings 41.88 49.94 207.40 100.00 119.25 495.22
Deferred Tax Liabilities 34.54 33.15 40.85 100.00 95.98 118.27
Other Long-Term Liabilities 38.54 42.24 44.26 100.00 109.60 114.84
Total Non-Current Liabilities 117.14 127.90 295.32 100.00 109.19 252.11
Short-Term Borrowings 42.59 56.70 134.58 100.00 133.13 315.99
Trade Payables 39.27 35.72 20.39 100.00 90.96 51.92
Other Current Liabilities 15.21 20.77 33.72 100.00 136.55 221.70
Total Current Liabilities 97.15 113.28 188.89 100.00 116.60 194.43
Total Capital & Liabilities 849.50 935.24 1,291.16 100.00 110.09 151.99
Tangible Assets 449.60 557.05 646.36 100.00 123.90 143.76
Capital Work-in-Progress 72.59 34.49 195.83 100.00 47.51 269.78
Fixed Assets 533.36 602.34 842.18 100.00 112.93 157.90
Non-Current Investments 11.84 11.84 4.80 100.00 100.00 40.54
Other Non-Current Assets 70.33 54.73 142.22 100.00 77.82 202.22
Total Non-Current Assets 615.53 668.91 989.21 100.00 108.67 160.71
Inventories 68.19 56.47 67.29 100.00 82.81 98.68
Trade Receivables 108.39 95.98 148.63 100.00 88.55 137.13
Cash & Cash Equivalents 3.39 5.92 11.27 100.00 174.63 332.45
Short-Term Loans & Advances 13.32 8.36 7.76 100.00 62.76 58.26
Other Current Assets 40.67 60.56 66.99 100.00 148.91 164.72
Total Current Assets 233.96 266.33 301.95 100.00 113.84 129.06
Total Assets 849.50 935.24 1,291.16 100.00 110.09 151.99
8
State Bank of India (SBI) is a leading public sector banking and financial services
institution in India, headquartered in Mumbai, Maharashtra. Its history dates back to 1806,
when the Bank of Calcutta was established; it later became part of the Imperial Bank of India.
SBI was officially established on 1 July 1955 after the nationalisation of the Imperial Bank of
India.
SBI provides a wide range of services including personal banking, corporate banking, loans,
deposits, investment services, digital banking and international banking. It also operates
through subsidiaries in areas such as insurance, mutual funds and credit cards. SBI is one of
India's largest banking organisations, serving customers through a large domestic and
international network.
Financial Data
Trend Analysis
Asian Paints
Asian Paints is one of India’s leading paint and home décor companies. It was established in
1942 by four friends and began as a small partnership firm. Over the years, the company
expanded significantly and became the market leader in paints in India in 1967. Asian Paints
manufactures and sells a wide range of decorative and industrial paints, coatings,
waterproofing products, adhesives and home décor products. The company has also
developed an international presence, operating across multiple countries and serving customers
in more than 60 countries. According to its 2025–26 annual report, the Asian Paints Group has
25 paint manufacturing facilities worldwide and more than 16,000 employees globally.
Financial Data
Trend Analysis
The trend analysis of BMW has been prepared by taking 2024 as the base year (100). The
analysis covers the financial position of the company for 2024, 2025 and 2026.
Interpretation
BMW's total assets increased from 100 in 2024 to 110.09 in 2025 and further to 151.99 in
2026. This indicates that the overall size of the company's balance sheet increased by
approximately 51.99% over the three-year period. The significant increase in 2026 indicates
considerable expansion in the company's asset base.
The shareholders' funds also showed a positive trend, increasing from 100 in 2024 to 109.27
in 2025 and 127.04 in 2026. This was mainly due to the increase in reserves and surplus,
which reached 128.03% in 2026. This indicates that the company's internal funds and
accumulated reserves strengthened during the period.
On the asset side, fixed assets increased to 157.90% in 2026, indicating significant investment
in fixed assets. Capital work-in-progress also increased sharply to 269.78%, which may
indicate that the company had substantial projects or investments under development during
2026.
Current assets increased from 100 in 2024 to 113.84 in 2025 and 129.06 in 2026. Cash and
cash equivalents showed particularly strong growth, reaching 332.45% in 2026. Trade
receivables also increased to 137.13%, while inventories remained almost at the 2024 level at
98.68%.
14
Particulars 2024 Trend % 2025 Trend % 2026 Trend % Change from 2024
Overall Conclusion
Overall, BMW showed strong financial expansion between 2024 and 2026. The growth in
total assets, shareholders' funds and fixed assets indicates an expanding financial base. The
company also experienced a substantial increase in cash and cash equivalents, which may
improve its liquidity position. However, the sharp rise in both long-term and short-term
borrowings indicates increased reliance on external financing. Therefore, while BIL's overall
trend is positive in terms of growth and expansion, its increasing borrowings should be
monitored to ensure that the company's financial risk remains under control.
15
Interpretation
SBI's total assets increased from 100 in 2024 to 108.03 in 2025 and further to 123.36 in
2026. This indicates that the overall size of SBI's balance sheet increased by approximately
23.36% over the period. The continuous increase shows a steady expansion in the bank's
financial operations.
The shareholders' funds showed a strong positive trend, increasing from 100 in 2024 to
116.95 in 2025 and 144.32 in 2026. The major reason for this increase was the growth in
reserves and surplus, which reached 145.96% in 2026. This indicates that SBI strengthened
its internal capital base during the period.
The bank's deposits increased from 100 in 2024 to 109.48 in 2025 and 121.56 in 2026.
This reflects growth in the bank's deposit base and indicates that SBI continued to attract
funds from customers. At the same time, advances increased to 131.69% in 2026, showing
significant expansion in lending activities.
Particulars 2024 Trend % 2025 Trend % 2026 Trend % Change from 2024
Overall Conclusion
Overall, SBI showed a strong and steady positive trend from 2024 to 2026. The most
significant growth was observed in shareholders' funds and reserves, which increased by
more than 44% from the base year. Advances also grew considerably, indicating expansion in
the bank's core lending business. Total assets increased by 23.36%, demonstrating overall
growth in the financial position of the bank.
The trend analysis suggests that SBI's financial position strengthened during the period,
particularly through the growth of its equity base, deposits and advances. The relatively
moderate increase in borrowings and investments indicates that the bank's balance-sheet
growth was not driven solely by additional borrowing. Overall, SBI demonstrated stable
expansion, strengthening of its capital base and growth in core banking operations during
2024–2026.
ASIAN PAINTS
The trend analysis of Asian Paints has been prepared by taking 2024 as the base year (100)
and comparing the financial position of the company for 2025 and 2026.
Interpretation
Asian Paints' total assets increased from 100 in 2024 to 102.58 in 2025 and further to 115.79
in 2026. This indicates that the overall asset base of the company increased by approximately
15.79% during the period. The growth was gradual, showing a moderate expansion in the
company's financial position.
The shareholders' funds increased from 100 in 2024 to 103.03 in 2025 and 112.79 in 2026.
The increase was mainly supported by the growth in reserves and surplus, which reached
112.86% in 2026. This indicates a strengthening of the company's internal funds and equity
position.
The company's fixed assets showed a positive trend, increasing to 119.89% in 2026. This
indicates that Asian Paints increased its investment in long-term operating assets. Current
investments showed particularly strong growth, reaching 199.04% in 2026 compared with the
2024 base.
17
Particulars 2024 Trend % 2025 Trend % 2026 Trend % Change from 2024
Overall Conclusion
Overall, Asian Paints showed moderate and positive growth between 2024 and 2026.
Total assets increased by 15.79%, while shareholders' funds increased by 12.79%. Fixed
assets and current investments showed notable growth, indicating continued investment and
changes in the company's asset allocation.
The company's borrowing percentages increased sharply in 2026, but these figures need to be
viewed in light of the very low 2024 base values. Overall, the trend analysis indicates that
Asian Paints maintained a growing financial position with moderate expansion in assets
and shareholders' funds, while certain components of its financing and investment structure
changed considerably during the period.
18
Key Finding
Based on the trend analysis of BIL, SBI and Asian Paints, taking 2024 as the base year
(100), the following key findings can be drawn:
BIL recorded the highest overall growth, with total assets increasing to 151.99% in
2026.
SBI showed strong growth in shareholders' funds, reaching 144.32%, along with
growth in deposits and advances.
Asian Paints showed moderate growth, with total assets reaching 115.79% in 2026.
BIL experienced a significant increase in borrowings, indicating greater use of
external financing.
SBI showed strong expansion in its core banking activities, particularly advances.
Asian Paints recorded significant growth in current investments, reaching 199.04%.
Overall, BIL had the highest asset growth, SBI had the strongest equity growth,
and Asian Paints showed moderate and stable expansion.
Comparative Summary
Major Growth Area Assets & Borrowings Equity & Advances Investments
Final Finding
BIL demonstrated the highest overall expansion, SBI demonstrated the strongest growth
in shareholders' funds and core banking activities, and Asian Paints showed moderate
but steady growth with significant changes in investments and financing. Thus, each
company followed a different financial growth pattern during 2024–2026.
19
Conclusion
Trend analysis is an important technique for understanding the financial performance and
position of a company over different years. By taking 2024 as the base year (100), the financial
trends of BIL, State Bank of India (SBI), and Asian Paints were analysed for the subsequent
years.
The analysis shows that all three companies experienced overall growth in their total assets.
BIL recorded the highest growth in total assets, while SBI showed strong growth in
shareholders' funds, deposits and advances. Asian Paints experienced comparatively
moderate growth, with notable changes in investments and fixed assets.
Overall, the study shows that trend analysis helps identify changes in a company's assets,
liabilities and shareholders' funds and provides useful information for evaluating financial
performance. However, trend percentages should always be interpreted along with the actual
financial figures and other financial ratios before making final financial decisions.
Bibliography / References