Analyzing common size balance sheets Assignment Help

Assignment Help: >> Common Size Statements >> Analyzing common size balance sheets

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

  1. Higher degree holder and experienced experts network
  2. Punctuality and responsibility of work
  3. Quality solution with 100% plagiarism free answers
  4. Time on Delivery
  5. Privacy of information and details
  6. Excellence in solving Accounting questions in excels and word format.
  7. Best tutoring assistance 24x7 hours

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