Advertisements
Advertisements
Question
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 |
Solution
Common Size Income Statement
for the year ended…..
Particulars |
Absolute Amount (Rs) |
Percentage of Revenue (%) |
||
Year 1 |
Year II |
Year 1 |
Year II |
|
I. Revenue from Operations |
14,00,000 |
16,00,000 |
100.00 |
100.00 |
II. Expenses |
|
|
|
|
a. Purchases of Stock-in-Trade |
9,00,000 |
10,00,000 |
64.28 |
62.5 |
b. Change in Inventories of Stock-in-Trade |
1,00,000 |
1,80,000 |
7.14 |
11.25 |
c. Finance Cost |
80,000 |
80,000 |
5.71 |
5.00 |
d. Other Expenses |
90,000 |
1,30,000 |
6.43 |
8.12 |
Profit before Income Tax |
2,30,000 |
2,10,000 |
16.43 |
13.13 |
Less: Income Tax |
40,000 |
36,000 |
2.84 |
2.25 |
Profit after Income Tax |
1,90,000 |
1,74,000 |
13.57 |
10.88 |
APPEARS IN
RELATED QUESTIONS
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.
Solve the following:
In common size balance sheet fixed assets are Rs 50,000 and balance sheet total as Rs 1,50,000. Find out percentage of fixed assets to total assets.
Explain how common size statements are prepared giving an example.
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 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 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 |