Trend analysis in detail with example, Financial Accounting

Assignment Help:

Trend Analysis

Trend analysis is an improvement over year-to-year analysis. When a comparison of financial statements covering more than three years in undertaken, the year-to-year analysis becomes too cumbersome. In trend analysis, changes are calculated for several successive years instead of for two or three years. Therefore, Trend analysis is a comparative analysis of a company's financial position over long period of time. Trend analysis is important because it may point to basic changes in the nature of a business and also helps in drawing meaningful conclusions regarding the operating performance over several years and financial position of the enterprise.  It is based on the idea that what has happened in the past gives an idea of what will happen in the future.

One of the main goals of trend analysis is to forecast future values of the series. It allows a researcher to look at a pattern of change over long time rather than at a single discrete point in time or over a short period so that better conclusions can be drawn.

The computation of a series of index numbers requires the choice of a base year that will have an index number of 100 for all items. The base period should be a normal year with regard to business conditions, since the base year used as a reference should be representative. Generally, the earliest year is selected as the base year. However, where the earliest year cannot fulfil the conditions of being a normal year then another year is chosen. All index numbers are computed with reference to the base year using this formula:

                   Index = 100 x Index Year Amount/Base Year Amount

In planning an index number trend comparison, it is not necessary to include in it all the items in the financial statements; only the most significant items may be included.  As in the case of year-to-year analysis, certain changes, and negative and positive amounts cannot be expressed by means of index numbers. Hence, this acts as a limitation of using trend analysis. The trend analysis using index number is also referred to as trend percentage.

The index number trend or trend percentage has been found to be well suited to comparison of changes in the working capital items over the years. The strength of trend analysis lies in the fact that it conveys to the analyst a better understanding of management's philosophy, policies, motivations, which are revealed through analysis over years. The more diverse the economic environments covering the periods compared, the better a picture of the ways in which the enterprise has weathered its adversities and taken advantage of its opportunities.

The first step in trend analysis is the preparation of a trend statement. For example, if we want to carryout trend analysis for five years, say, 2002 to 2006, of Infosys Technologies Limited we will take 2002 as base year. So the figures of each item of 2002 will act as 100. Then, we will convert financial statement items of the following years as a percentage of base-year value of 2002. Table 3 carries such percentages for two financial statement items and one can observe the trend of each item. For example, sales have increased to 347% in five years. And the trend of the sales is an increasing trend. Fixed assets also show an upward trend. However, growth in fixed assets is less than the growth in sales signifying better utilization of fixed assets.

Following is the Extract taken from the Annual Reports of Infosys:

                                                                                                 (Rs. in crore)

Particulars

2003

2004

2005

2006

2007

Sales

3623

4761

6860

9028

13,149

Other income

100

121

119

144

375

Operating expenses

407

476

961

739

1091

Employee expenses

1677

2366

3182

4801

7114

Selling and marketing expenses

267

335

392

499

719

Depreciation expenses

189

231

268

409

469

Operating profit

1,272

1,584

2,325

2,989

4,225

Profit after tax

958

1243

1859

2421

3777

PBDIT as a % of sales

35.11

33.26

33.90

33.12

32.13

 

The above table is converted into percentage terms (i.e. trend analysis) by taking 2003 as base year. 

 

Trend Analysis in Percentage

Particulars

2003

2004

2005

2006

2007

Sales

100

131

189

249

363

Other income

100

121

119

144

375

Operating expenses

100

117

236

182

268

Employee expenses

100

141

190

286

424

Selling and marketing expenses

100

125

147

187

269

Depreciation expenses

100

122

142

216

248

Operating profit

100

125

183

235

332

Profit after tax

100

130

150

253

394

PBDIT as a % of sales

100

95

97

94

92


Related Discussions:- Trend analysis in detail with example

Extent of tests of control, Extent of Tests of Control -Every year AUDITOR ...

Extent of Tests of Control -Every year AUDITOR should obtain sufficient evidence about whether company's internal control over financial reporting, including controls for all inter

Effect of winding up order-liquidation of companies, Effect of Winding-up O...

Effect of Winding-up Order The consequences of a winding-up order are: 1) Any disposition of the company's property and any transfer of shares is void, unless the court otherwis

The balance of arndt''s retained earnings, On December 31, 2010, the stockh...

On December 31, 2010, the stockholders' equity section of Arndt, Inc., was as follows: Common stock, par value $10; authorized 30,000 shares; issued and outstanding 9,000 shares $

calculate a weighted average contribution margin per unit, Part A   ...

Part A   The contribution margin income statement of Nice Cup Company for 31 December 2011 follows: Nice Cup Company   Contribution Mar

What do you eman by lease, Q. What do you eman by Lease? Lease - Convey...

Q. What do you eman by Lease? Lease - Conveyance of buildings orland, equipment or other ASSETS from one person (LESSOR) to another (LESSEE) for a specific period of time for m

Prepare partial income statement through fifo and lifo , Prepare Partial In...

Prepare Partial Income Statement through FIFO, And LIFO Methods The records of XYZ Restaurant Supply include the following accounts for cases of coffee cups at December 31 of t

Compute the npv of the cash flows, Ace Company has a 30 percent marginal ta...

Ace Company has a 30 percent marginal tax rate and uses a 12% discount rate to compute NPV. The firm started a venture that will yield the following before-tax cash flows: year 0,

Describe what you understand by the term fund accounting, Question: (a)...

Question: (a) ‘Public accounting is often called fund accounting'. Describe what you understand by the term ‘fund accounting'. (b) "What's the difference between nation

Nature of a deeds of arrangement-bankruptcy and liquidation, Nature of a De...

Nature of a Deeds of Arrangement To avoid the expense and delay involved in a bankruptcy, a debtor in trouble may make a private arrangement with the creditors to accept paymen

Traditional techniques - techniques of inventory control, Inventory Control...

Inventory Control Ratios For reasons of monitoring the effectiveness of inventory management this is useful to look at the subsequent ratios and indexes: Overall Inventory Tu

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd