Advertisements
Advertisements
Question
Explain how common size statements are prepared giving an example.
Solution
The two Common Size Statements that are most commonly prepared are as follows.
1. Common Size Balance Sheet
2. Common Size Income Statements
Common Size Statement is prepared in a columnar form for analysis. In a Common Size Statement each item of the financial statements is compared to a common item. The analyses based on these statements are commonly known as Vertical Analysis.
The following are the columns prepared in a Common Size Statement.
i) Particulars Column: This column shows the various financial items under their respective heads.
ii) Amount Columns: These columns depict the amount of each item, sub-totals and the gross total of a particular year.
iii) Percentage or Ratio Columns: These columns show the proportion of each item to the common item either in terms of percentage or ratio.
The Common Size Statements can be presented in the following two ways.
Method 1
1. Percentage Column is shown beside the Amount Column of the year to which percentage column belongs.
Particulars |
Year (2007) |
% |
Year (2006) |
% |
|
|
|
|
Method 2
Amount Columns are shown first and their percentage columns are shown after the Amount Columns.
Particulars | Years (2007) (Rs) | Years (2007) (Rs) | % 2007 | % 2008 |
The preparation of the Common Size Statements can be better understood by the help of the following example.
Particulars |
Note No. |
2012 |
2013 |
I. Equity and Liabilities |
|
|
|
1. Shareholders’ Funds |
|
|
|
(a) Equity Share Capital |
|
4,00,000 |
6,00,000 |
(b) Reserves and Surplus |
|
1,00,000 |
1,50,000 |
2. Non-Current Liabilities |
|
|
|
(a) Long-Term Borrowings |
|
3,00,000 |
3,20,000 |
3. Current Liabilities |
|
|
|
(a) Trade Payables |
|
2,00,000 |
2,50,000 |
Total |
|
10,00,000 |
13,20,000 |
II. Assets |
|
|
|
1. Non-Current Assets |
|
|
|
(a) Fixed Assets |
|
|
|
(i) Tangible Assets |
|
5,00,000 |
6,75,000 |
(ii) Intangible Assets |
|
1,00,000 |
1,20,000 |
(b) Non-Current Investments |
|
1,50,000 |
2,00,000 |
2. Current Assets |
|
2,50,000 |
3,25,000 |
Total |
|
10,00,000 |
13,20,000 |
Common Size Balance Sheet
as on….
Particulars |
Note No. |
Absolute Amount |
Percentage of Balance Sheet Total |
||
2012 (Rs) |
2013 (Rs) |
2012 (%) |
2013 (%) |
||
I. Equity and Liabilities |
|
|
|
|
|
1. Shareholders’ Funds |
|
|
|
|
|
(a) Equity Share Capital |
|
4,00,000 |
6,00,000 |
40 |
45.45 |
(b) Reserves and Surplus |
|
1,00,000 |
1,50,000 |
10 |
11.36 |
2. Non-Current Liabilities |
|
|
|
|
|
(a) Long-Term Borrowings |
|
3,00,000 |
3,20,000 |
30 |
24.24 |
3. Current Liabilities |
|
|
|
|
|
(a) Trade Payables |
|
2,00,000 |
2,50,000 |
20 |
18.94 |
Total |
|
10,00,000 |
13,20,000 |
100 |
100 |
II. Assets |
|
|
|
|
|
1. Non-Current Assets |
|
|
|
|
|
(a) Fixed Assets |
|
|
|
|
|
(i) Tangible Assets |
|
5,00,000 |
6,75,000 |
50 |
51.14 |
(ii) Intangible Assets |
|
1,00,000 |
1,20,000 |
10 |
9.09 |
(b) Non-Current Investments |
|
1,50,000 |
2,00,000 |
15 |
15.15 |
2. Current Assets |
|
2,50,000 |
3,25,000 |
25 |
24.62 |
Total |
|
10,00,000 |
13,20,000 |
100 |
100 |
Working Note:
`"Percentage (Previous Year)" = "Precious year Absolute Figure"/"Balance Sheet Total of Previous Year" xx 100`
`"Percentage (Current Year)" = "Current year Absolute Figure"/"Balance Sheet Total of Current Year" xx 100`
For example,
Percentage of Equity Share Capital (Previous Year)= `400000/1000000 xx 100 = 40%`
Percentage of Equity Share Capital (Current Year)= `600000/1320000 xx 100 = 45.45%`
Preparation
Step 1: Title of the Common Size Statement, i.e. ‘Common Size Balance Sheet’ is written on the top of the statement.
Step 2: In the ‘Particulars’ column, the various items of the Balance Sheet are shown under the headings of ‘Assets’ and ‘Equity and Liabilities’.
Step 3: In the ‘Amount’ column, amount of the items are shown in the ‘Year’ column to which they belong
Step 4: The Assets and Liabilities are totaled and are shown separately for each year.
Step 5: In the ‘Percentage’ column, the percentage of each item in comparison to the Total of Balance Sheet are shown.
APPEARS IN
RELATED QUESTIONS
What is meant by a 'Common Size Statement'?
From the following information, prepare a Common Size Statement of Profit and Loss of Prudence Ltd. for the
year ending 31st March, 2017:
Particulars 31.03.2017
Revenue from Operations 20,00,000
Purchases 15,00,000
Changes in inventories 1,00,000
Other Income (Dividend received) 40,000
Depreciation and Amortization expenses 60,000
Tax Rate @ 40%
Select the appropriate answer from the alternatives given below & rewrite the completed statement :
The common size statement requires _____________.
Give one word/term/ phrase for the following statement
The tool for analysis of financial statement where, individual figures of balance sheet is converted into percentage.
Explain the following :
Common size balance sheet.
Prepare a Common size statement of profit and loss of Shefali Ltd. with the help of following information:
Particulars | 2015-16 (Rs) |
2016-17 (Rs) |
Revenue from operations | 6,00,000 | 8,00,000 |
Indirect expense | 25% of gross profit | 25% of gross profit |
Cost of revenue from operations | 4,28,000 | 7,28,000 |
Other incomes | 10,000 | 12,000 |
Income tax | 30% | 30% |
Prepare a Common Size balance sheet from the following balance sheet of Aditya Ltd. and Anjali Ltd.:
Particulars | Aditya Ltd. Rs. |
Anjali Ltd. Rs. |
I. Equity and Liabilities | ||
a) Equity share capital |
6,00,000 | 8,00,000 |
b) Reserves and surplus |
3,00,000 | 2,50,000 |
c) Current liabilities |
1,00,000 | 1,50,000 |
Total | 10,00,000 | 12,00,000 |
II. Assets | ||
a) Fixed assets |
4,00,000 | 7,00,000 |
b) Current assets |
6,00,000 | 5,00,000 |
Total | 1,00,0000* | 12,00,000 |
*The total of Liabilities side must be equal to the total of Assets side, therefore, it should be 10,00,000.
From the following Statement of Profit and Loss of Star Ltd., for the year ended 31st March, 2015 and 2016, prepare a Common-size statement:
Particulars | Note No. | 2015-16 |
2014-15 |
||
Revenue from Operations | ₹ 25,00,000 | ₹ 20,00,000 | |||
Employee Benefit Expenses | ₹ 10,00,000 | ₹ 7,00,000 | |||
Other Expenses | ₹ 2,00,000 | ₹ 3,00,000 | |||
Tax Rate |
40% |
40% |
Prepare Common-size Statement of Profit and Loss from the following Statement of Profit and Loss:
Particulars |
Note No. |
31st March, 2018 (₹) |
I. Income | ||
Revenue from Operations |
15,00,000 | |
Other Income |
60,000 |
|
Total Revenue |
15,60,000 | |
II. Expenses |
|
|
Purchases of Stock-in-Trade |
7,50,000 | |
Change in Inventories of Stock-in-Trade |
50,000 | |
Other Expenses |
2,10,000 |
|
Total |
10,10,000 |
|
III. Net Profit before Tax (I-II) | 5,50,000 |
Prepare Common-size Statement of Profit and Loss from the following Statement of Profit and Loss:
Particulars |
Note No. |
Year I (₹) |
Year II (₹) |
I. Income | |||
Revenue from Operations (Net Sales) |
14,00,000 |
16,00,000 |
|
II. Expenses | |||
Purchases of Stock-in-Trade |
9,00,000 |
10,00,000 |
|
Change in Inventories of Stock-in-Trade |
1,00,000 |
1,80,000 |
|
Finance Costs |
80,000 |
80,000 |
|
Other Expenses |
90,000 |
1,30,000 |
|
Total |
11,70,000 |
13,90,000 |
|
III. Net Profit (I-II) |
2,30,000 |
2,10,000 |
|
IV. Less: Tax |
40,000 |
36,000 |
|
V. Net Profit After Tax (III-IV) |
1,90,000 |
1,74,000 |
Prepare Common-size Balance Sheet and comment on the financial position of Sun Ltd. and Star Ltd. The Balance Sheet of Sun Ltd. and Star Ltd. as at 31st March, 2019 are:
Particulars |
Sun Ltd. (₹) |
Star Ltd. (₹) |
I. EQUITY AND LIABILITIES | ||
1. Shareholders' Funds |
||
(a) Share Capital |
9,00,000 |
12,00,000 |
(b) Reserves and Surplus |
4,00,000 |
3,50,000 |
2. Current Liabilities |
|
|
Trade Payables (Creditors) |
2,00,000 |
2,50,000 |
Total |
15,00,000 |
18,00,000 |
II. ASSETS | ||
1. Non-Current Assets |
||
Fixed Assets (Tangible) |
10,00,000 |
16,00,000 |
2. Current Assets |
|
|
Trade Receivables (Debtors) |
5,00,000 |
2,00,000 |
Total |
15,00,000 |
18,00,000 |
Prepare common size statement of profit and loss from the following information:
Particulars | Note No. | 2017-18 | 2016-17 |
Revenue from operations | ₹ 16,00,000 | ₹ 8,00,000 | |
Cost of material consumed | |||
(% of revenue from operations) | 60% | 50% | |
Operating expenses | ₹ 80,000 | ₹ 40,000 | |
Income tax rate | 40% | 30% |
Consider the following statements.
Statement 1 - "Common size statements and financial ratios are the two tools employed in vertical analysis."
Statement 2 - "Common size statements are also as a component percentage statement
Common Size Statements are prepared ______.
The objective of the Common Size Statement of Profit and Loss is not to:
Prabhu wants to know the main objective of Common Size Statement, help him to choose one:
From the following Balance Sheet of Rohit Ltd., prepare a Common Size Balance Sheet:
Balance Sheet of Rohit Ltd. as at 31st Mach, 2021 |
|||
Particulars | Note No. | 31st March 2021 (₹) |
31st March 2020 (₹) |
I. Equity and Liabilities | |||
1. Shareholders' Funds | 3,20,000 | 1,60,000 | |
2. Current Liabilities | 80,000 | 40,000 | |
Total | 4,00,000 | 2,00,000 | |
II. Assets | |||
1. Non-Current Assets | 3,00,000 | 1,50,000 | |
2. Current Assets | 1,00,000 | 50,000 | |
Total | 4,00,000 | 2,00,000 |
From the following information, prepare a 'Common Size Statement of Profit and Loss' of K K Ltd. for the year ended 31.3.2021 and 31.3.2022:
Particulars | 31.3.2022 Amount (₹) |
31.3.2022 Amount (₹) |
Revenue from operations | 20,00,000 | 15,00,000 |
Other Income | 2,00,000 | 1,50,000 |
Expenses | 4,00,000 | 3,00,000 |
Tax Rate 50% |
From the following information, prepare a 'Common Size Statement of Profit and Loss' of GG Ltd. for the year ended 31.3.2021 and 31.3.2022:
31.3.2022 | 31.3.2021 | |
Revenue from operations | 20,00,000 | 10,00,000 |
Other Income | 2,00,000 | 1,00,000 |
Expenses | 15,00,000 | 8,00,000 |
Tax @ 50% |
From the information extracted from the statement of Profit & Loss of Zee Ltd for the year ended 31st March 2022 and 31st March 2023, prepare a common size statement of profit & loss:
Particulars | Note No. | 2022-23 (₹) | 2021-22 (₹) |
Revenue from operations |
8,00,000 | 10,00,000 | |
Gross Profit | 60% | 70% | |
Other Expenses | 2,20,000 | 2,60,000 | |
Tax Rate | 50% | 50% |
From the following information, you are required to prepare a Common Size Balance Sheet of Super Ltd. as at 31st March, 2024.
Particulars | (₹) |
Non-Current Liabilities | ₹ 2,00,000 |
Shareholders’ Fund | 2.5 times more than the Non-Current Liabilities |
Current Liabilities | ₹ 1,00,000 |
Current Assets | ₹ 3,00,000 |
Non-Current Assets | 70% of the Equity & Liabilities |