Analyzing common size balance sheets
In analyzing a common size balance sheet, emphasis is laid on these aspects:
-
Sources of financing, including the distribution of financing among current liabilities, non-current liabilities and equity capital.
-
Composition of investments, including current and non-current assets.
-
Composition of cash and cash equivalents in current assets.
Common-size balance sheet analysis is often extended to examine the proportions comprising particular sub-groups. For example, in assessing liquidity of current assets, it is often important to know what proportion of current assets comprises inventories, and not simply what proportion of inventories are total assets.
The common-size balance sheet can be used for cross-sectional analysis by comparing it with the common-size balance sheets of other similar firms or companies.
Let us undertake a cross-sectional analysis of common-size balance sheets of Infosys Technologies with the statements of TCS and Satyam Computer Services.
Cross-sectional Analysis using Common-size Balance Sheet as at March 31, 2007
(Rs. in crore)
Particulars
|
TCS
|
INFOSYS
|
SATYAM
|
Rs.
|
(%)
|
Rs.
|
(%)
|
Rs.
|
(%)
|
Sources of Funds
|
|
|
|
|
|
|
Shareholder's Funds:
|
|
|
|
|
|
|
Share Capital
|
97.86
|
1.20
|
286
|
2.56
|
141.29
|
2.43
|
Reserves and Surplus
|
7,961.13
|
97.89
|
10,876
|
97.44
|
5,648.07
|
97.33
|
Loan Funds:
|
|
|
|
|
|
|
Secured loans
|
41.76
|
0.513
|
|
|
13.79
|
0.24
|
Unsecured loans
|
8.98
|
0.110
|
|
|
|
|
|
50.74
|
0.623
|
|
|
|
|
Deferred Tax Liability
|
23.00
|
0.283
|
|
|
|
|
|
8,132.73
|
100
|
11,162
|
100
|
5,803.15
|
100
|
Application of Funds
|
|
|
|
|
|
|
Fixed Assets
|
|
|
|
|
|
|
Original Cost
|
2,312.36
|
28.43
|
3,889
|
34.84
|
1,280.40
|
22.06
|
Less: Accumulated Depreciation
|
851.75
|
10.47
|
1,739
|
15.58
|
930.45
|
16.03
|
Net Book Value
|
1,460.61
|
17.96
|
2,150
|
19.26
|
349.95
|
6.03
|
Add: Capital work-in-progress
|
757.85
|
9.32
|
957
|
8.57
|
290.05
|
5.00
|
|
2218.46
|
27.28
|
3,107
|
27.84
|
640.00
|
11.03
|
Investments
|
3,252.04
|
39.99
|
839
|
7.52
|
201.15
|
3.47
|
Deferred Tax Assets
|
|
|
79
|
0.71
|
43.36
|
|
Current Assets, Loans and Advances:
|
|
|
|
|
|
|
Sundry debtors
|
3,323.68
|
40.87
|
2,292
|
20.53
|
1,649.86
|
28.43
|
Cash and bank balances
|
557.14
|
6.85
|
5,507
|
49.34
|
3,959.82
|
68.24
|
Loans and advances
|
1,363.74
|
16.77
|
1,162
|
10.41
|
261.75
|
4.51
|
Interest accrued on investments
|
0.51
|
0.006
|
|
0.000
|
64.83
|
1.12
|
Inventories
|
12.06
|
0.148
|
|
0.000
|
|
0.000
|
|
5,257.13
|
64.64
|
8,961
|
80.28
|
5,936.26
|
102.29
|
Less: Current Liabilities and Provisions:
|
|
|
|
|
|
|
Current liabilities
|
1,689.85
|
20.78
|
1,162
|
10.41
|
597.17
|
10.29
|
Provisions
|
905.05
|
11.13
|
662
|
5.93
|
420.45
|
7.25
|
|
2,594.90
|
31.91
|
1,824
|
16.34
|
1,017.62
|
17.54
|
Net Current Assets
|
2,662.23
|
32.73
|
7,137
|
63.94
|
4,918.64
|
84.76
|
TOTAL
|
8,132.73
|
100
|
11,162
|
100
|
5,803.15
|
100
|
Common-size balance sheet of TCS, Satyam and Infosys can be compared from the following perspectives:
-
Short-term Liquidity: The short-term liquidity can be assessed by looking at the proportion of net current assets to total assets. This percentage is relatively very high for Satyam Computer Services when compared to others. This can be attributed to two factors - one, the large composition of cash in current assets (68.24%) and the relatively lower percentage of current liabilities (17.54%). On the other extreme, the net current assets percentage to total assets is less in TCS, because of the relatively meager proportion of cash balances which are only 6.85% of total assets.
-
A closer look at the cash flow information of Satyam Computer Services reveals that the actual net increase in absolute cash is only Rs.907.49 crore which means that the cash balance at the end of the year is only Rs.593.16 crore. The remaining balance in "cash and bank balances" represents a long-term fixed deposit of Rs.3,366.66 crore.
-
Long-term Solvency: All the three software companies are financed mostly through internal funds (i.e., reserves and surplus) and hence the proportion of debt-to-equity is very negligible. As such they have a satisfactory long-term financial position.
-
Composition of Fixed Assets: Since all the three companies are software companies, their major fixed assets comprise land and buildings and computer equipment. A look at the notes to accounts and the schedules to balance sheet reveals that in case of TCS, out of the gross block of assets, 60% are buildings and computer equipment, while in case of Satyam and Infosys the composition of these two assets is 76% and 62% respectively.
-
While buildings have been depreciated on straight line basis over their useful life in case of TCS and Infosys, in case of Satyam, they have WDV method. The proportion of accumulated depreciation to gross block of assets is more in case of Satyam (72%) which suggests that the company must have adopted a faster depreciation of its assets in their initial years. On the other hand, the proportion of accumulated depreciation to gross block of assets is considerably low for TCS (37%).
-
Investments: The proportion of investments also shows considerable variation with TCS having a higher percentage (39.99%) while Satyam has the lowest percentage in investments (3.47%). But, Satyam has a major portion (58% of total assets) invested in long-term fixed deposit which is included in cash and bank balances.
Email based Accounting assignment help - homework help at Expertsmind
Are you searching Accounting expert for help with Analyzing common size balance sheets questions? Analyzing common size balance sheets topic is not easier to learn without external help? We at www.expertsmind.com offer finest service of Accounting assignment help and Accounting homework help. Live tutors are available for 24x7 hours helping students in their Analyzing common size balance sheets related problems. We provide step by step Analyzing common size balance sheets question's answers with 100% plagiarism free content. We prepare quality content and notes for Analyzing common size balance sheets topic under Accounting theory and study material. These are avail for subscribed users and they can get advantages anytime.
Why Expertsmind for assignment help
- Higher degree holder and experienced experts network
- Punctuality and responsibility of work
- Quality solution with 100% plagiarism free answers
- Time on Delivery
- Privacy of information and details
- Excellence in solving Accounting questions in excels and word format.
- Best tutoring assistance 24x7 hours