Advertisements
Advertisements
Question
Prepare Comparative Income Statement from the following information:
| Particulars | 2016-17 Rs. |
2015-16 Rs. |
| Freight Outward | 20,000 | 10,000 |
| Wages (office) | 10,000 | 5,000 |
| Manufacturing Expenses | 50,000 | 20,000 |
| Stock adjustment | (60,000) | 30,000 |
| Cash purchases | 80,000 | 60,000 |
| Credit purchases | 60,000 | 20,000 |
| Returns inward | 8,000 | 4,000 |
| Gross profit | (30,000) | 90,000 |
| Carriage outward | 20,000 | 10,000 |
| Machinery | 3,00,000 | 2,00,000 |
| Charge 10% depreciation on machinery | 10,000 | 5,000 |
| Interest on short-term loans | 20,000 | 20,000 |
| 10% debentures | 20,000 | 10,000 |
| Profit on sale of furniture | 20,000 | 10,000 |
| Loss on sale of office car | 90,000 | 60,000 |
| Tax rate | 40% | 50% |
Solution
Comparative Income Statement
for the year ended March 31, 2016 and 2017
|
Particulars |
Note No. |
2015-16 (Rs) |
2016-17 (Rs) |
Absolute Change |
Percentage Change |
|
1. Revenue from Operations |
|
2,16,000 |
92,000 |
(1,24,000) |
(57.4) |
|
2. Other Income |
|
10,000 |
20,000 |
10,000 |
100 |
|
3. Total Revenue (1 + 2) |
|
2,26,000 |
1,12,000 |
(1,14,000) |
(50.44) |
|
4. Expenses |
|
|
|
|
|
|
a. Purchases of Stock-in-Trade |
|
80,000 |
1,40,000 |
60,000 |
75 |
|
b. Change in Inventories |
|
30,000 |
(60,000) |
(90,000) |
(300) |
|
c. Employee Benefit Expenses |
|
5,000 |
10,000 |
5,000 |
100 |
|
d. Finance Costs |
|
21,000 |
22,000 |
1,000 |
100 |
|
e. Depreciation and Amortisation Expenses |
|
5,000 |
10,000 |
5,000 |
100 |
|
f. Other Expenses |
|
80,000 |
1,30,000 |
50,000 |
62.5 |
|
Total Expenses |
|
2,21,000 |
2,52,000 |
31,000 |
14.03 |
|
5. Profit before Tax (3 – 4) |
|
5,000 |
(1,40,000) |
(1,35,000) |
166 |
|
Less: Income Tax |
|
2,500 |
- |
(2,500) |
(100) |
|
6. Profit After Tax |
|
2,500 |
(1,40,000) |
(1,37,500) |
550 |
Working Notes:
1. Calculation of Net Sales
Net Sales = Cost of Goods Sold + Gross Profit - Sales Return
or, Net Sales = Purchases + Manufacturing Expenses + Change in Inventory + Gross Profit - Sales Return
Net Sales (2016) = 80,000 + 20,000 +30,000 + 90,000 - 4,000 = Rs 2,16,000
Net Sales (2017) = 1,40,000 + 50,000 + (- 60,000) + (- 30,000) + (- 8,000) = Rs 92,000
2. Calculation of Finance Cost
Finance Cost = Interest on short-term loans + Interest on 10% Debentures
Finance Cost (2016) = 20,000 + 1,000 = Rs 21,000
Finance Cost (2017) = 20,000 + 2,000 = Rs 22,000
3. Calculation of Other Expenses
Other Expenses = Freight Outward + Carriage Outward + Loss on sale of office car
Other Expenses (2016) = 10,000 + 10,000 + 60,000 = Rs 80,000
Other Expenses (2017) = 20,000 + 20,000 + 90,000 = Rs 1,30,000
APPEARS IN
RELATED QUESTIONS
Following is the statement of Profit and Loss of DD Ltd. For the year ended 31-3-2015.
| Particulars | Note No. | 31-3-2015 (Rs.) | 31-3-2014 (Rs.) |
|
Revenue from operations Other Income Employee benefit – expenses 60% of total revenue Other expenses 10% of employee benefit expenses Tax Rate |
75,00,000 1,50,000
40% |
34,00,000 3,00,000
50% |
The motto of DD Ltd. is to produce and supply green energy in the rural areas of India. It has also taken up a project of constructing a road that will pass through five villages so that these villages could be connected to the nearby town. It will use the local resources and employ local people for construction of the road.
You are required to prepare a comparative statement of Profit and Loss of DD Ltd. from the given statement of Profit and Loss. Also identify any two values that the company wishes to convey to the society.
Following is the Statement of Profit and Loss of Moon India Ltd for the year ended 31st March 2015.
| Particulars | Note No. | 31-3-2015 (Rs.) | 31-3-2014 (Rs.) |
|
Revenue from operations Other Income Employee benefit – expenses Other expenses Tax Rate |
50,00,000 2,00,000 60% of the total revenue 10% of employee benefit expenses 50% |
40,00,000 10,00,000 50% of the total revenue 20% of employee benefit expenses 40% |
The motto of Moon India Ltd. is to produce and distribute green energy in the backward areas of India. It has also taken up a project of giving vocational training to the girls belonging to the backward areas of Rajasthan.
You are required to prepare a comparative statement of Profit and Loss of Moon India Ltd. from the given statement of Profit and Loss and also identify any two values that the company wishes to convey to the society.
From the following Statement of profit and loss of the year ended 31st March, 2013; prepare a comparative statement of Profit and Loss of Good Service Ltd.
| Particulars | 2012-13 (Rs.) | 2011-12 (Rs.) |
| Revenue from operation | 20,00,000 | 15,00,000 |
| Other expenses | 10,00,000 | 4,00,000 |
| Expenses | 21,00,000 | 15,00,000 |
Rate of Income tax was 50%.
The motto of 'Pharma Ltd', a company engaged in the manufacturing of low-cost generic medicines, is 'Healthy India'. Its management and employees are hardworking, honest and motivated. The net profit of the company doubled during the year ended 31-3-2014. Encouraged by its performance, the company decided to pay the bonus to all employees at double the rate than last year. Following is the Comparative Statement of Profit and Loss of the company for the years ended 31-3-2013 and 31-3-2014.
| Pharma Ltd Comparative Statement of Profit and Loss |
|||||
| Particulars | Note No. |
2012-13 Rs |
2013-14 Rs |
Absolute Rs |
% Change |
|
Revenue from operations Less Employee benefit expenses Profit before tax Tax Rate 25% Profit after tax |
20,00,000 12,00,000 8,00,000 2,00,000 6,00,000 |
30,00,000 14,00,000 16,00,000 4,00,000 12,00,000 |
10,00,000 2,00,000 8,00,000 2,00,000 6,00,000 |
50 16-87 100 100 100 |
|
1) Calculate Net Profit Ratio for the years ending 31st March, 2013 and 2014
2) Identify any two values which ‘Pharma Ltd’ is trying to propagate
From the following Statement of profit and loss of the year ended 31st March 2013, prepare a comparative ‘Statement of Profit and Loss’ of Vidya Ltd
| Particulars | 2012-13 Rs | 2011-12 Rs |
|
Revenue from operation Other expenses Expenses |
14,00,000 4,00,000 11,00,000 |
11,00,000 3,00,000 12,00,000 |
A rate of Income-tax was 50%.
From the following Statement of profit and loss of Fenox Ltd, for the year ended 31st March 2013; prepare a comparative statement of Profit and Loss:
| Particulars |
2012-13 Rs |
2011-12 Rs |
| Revenue from operation | 8,00,000 | 6,00,000 |
| Other Income | 1,00,000 | 50,000 |
| Expenses | 5,00,000 | 4,00,000 |
A rate of Income-tax was 40%.
From the Following Statements of Profit and Loss Suntrack Ltd., for the years ended 31st March 2011 and 2012, prepare a 'Comparative Statement of Profit and Loss'.
| Particulars | Note No. |
2011-12 | 2010-11 |
| Revenue from Operations | 20,00,00 | 12,00,000 | |
| Other Incomes | 12,00,000 | 9,00,000 | |
| Expenses | 13,00,000 | 10,00,000 |
Give any two differences between horizontal analysis and vertical analysis of financial statements.
Give one word/term/ phrase for the following statement
The statement showing profitability of two different period and its percentage change.
Answer the following in brief :
What is comparative financial statement?
Solve the following :
If office expenses of two different periods are Rs 4,000 and Rs 5,000 respectively and sales for same two periods are Rs 1,00,000 and Rs 2,00,000 respectively then what is absolute change and percentage?
Prepare Comparative Income Statement from the following information:
| Particulars | 2015-16 Rs. |
2016-17 Rs. |
| Manufacturing expenses | 35,000 | 80,000 |
| Opening stock | 30,000 | 60% of closing stock |
| Sales | 9,60,000 | 4,50,000 |
| Returns outward | 4,000 (out of credit purchase) | 6,000 (out of cash purchase) |
| Closing stock | 150% of opening stock | 1,00,000 |
| Credit purchases | 1,50,000 | 150% of cash purchase |
| Cash purchases | 80% of credit purchases | 40,000 |
| Carriage outward | 10,000 | 30,000 |
| Building | 1,00,000 | 2,00,000 |
| Depreciation on building | 20% | 10% |
| Interest on bank overdraft | 5,000 | - |
| 10% debentures | 2,00,000 | 20,00,000 |
| Profit on sale of copyright | 10,000 | 20,000 |
| Loss on sale of personal car | 10,000 | 20,000 |
| Other operating expenses | 20,000 | 10,000 |
| Tax rate | 50% | 40% |
Following is the Balance Sheet of Radha Ltd. as at 31st March, 2019:
|
Particulars |
Note No. |
31st March, 2019, (₹) |
31st March, 2018, (₹) |
|
I. EQUITY AND LIABILITIES 1. Shareholders' Funds |
|||
|
(a) Share Capital |
15,00,000 |
10,00,000 |
|
|
(b) Reserves and Surplus |
10,00,000 | 10,00,000 | |
|
2. Non-Current Liabilities |
|||
|
Long-term Borrowings |
|
8,00,000 |
2,00,000 |
|
3. Current Liabilities |
|||
|
(a) Trade Payables |
|
5,00,000 |
3,00,000 |
|
Total |
38,00,000 |
25,00,000 |
|
|
II. ASSETS |
|||
|
1. Non-Current Assets |
|||
|
Fixed Assets: |
|||
|
(i) Tangible Assets |
|
25,00,000 |
15,00,000 |
|
(ii) Intangible Assets |
5,00,000 | 5,00,000 | |
|
2. Current Assets |
|||
|
(a) Trade Receivables |
|
6,00,000 |
3,50,000 |
|
(b) Cash and Cash Equivalents |
2,00,000 |
1,50,000 |
|
|
Total |
38,00,000 |
25,00,000 |
You are required to prepare Comparative Balance Sheet on the basis of the information given in the above Balance Sheet.
From the Following Balance Sheet of Royal Industries Ltd. as at 31st March, 2019, prepare Comparative Balance Sheet:
|
Particulars |
Note No. |
31st March, 2019 (₹) |
31st March, 2018 (₹) |
| I. EQUITY AND LIABILITIES
1. Shareholder's Funds |
|||
|
(a) Share Capital |
|||
|
Equity Share Capital |
10,00,000 |
5,00,000 |
|
|
(b) Reserves and Surplus |
1,00,000 |
1,00,000 |
|
|
2. Non-Current Liabilities |
|||
|
Long-term Borrowings |
2,00,000 |
3,00,000 |
|
|
3. Current Liabilities |
|||
|
Trade Payables |
2,00,000 |
1,00,000 |
|
|
Total |
15,00,000 |
10,00,000 |
|
| II. ASSETS | |||
|
1. Non-Current Assets |
|||
|
(a) Fixed Assets: |
|||
|
(i) Tangible Assets |
8,00,000 |
4,00,000 |
|
|
(ii) Intangible Assets |
2,00,000 |
2,00,000 |
|
|
(b) Non-Current Investments |
2,00,000 |
2,00,000 |
|
|
2. Current Assets |
|||
|
(a) Inventories |
2,50,000 |
1,50,000 |
|
|
(b) Cash and Cash Equivalents |
50,000 |
50,000 |
|
|
Total |
15,00,000 |
10,00,000 |
From the following Balance Sheet of Depth Ltd. as at 31st March, 2019, prepare Comparative Balance Sheet:
|
Particulars |
Note No. |
31st March, 2019 (₹) |
31st March, 2018 (₹) |
|
I. EQUITY AND LIABILITIES |
|||
|
1. Shareholders' Funds |
|||
|
(a) Share Capital |
2,80,000 |
1,80,000 |
|
|
(b) Reserves and Surplus |
1,00,000 |
1,00,000 |
|
|
2. Non-Current Liabilities |
|||
|
Long-term Borrowings |
80,000 |
20,000 |
|
|
3. Current Liabilities |
|||
|
Trade Payables |
50,000 |
30,000 |
|
|
Total |
5,10,000 |
3,30,000 |
|
|
II. ASSETS |
|||
|
1. Non-Current Assets |
|||
|
(a) Fixed Assets: |
|||
|
(i) Tangible Assets |
2,80,000 |
1,80,000 |
|
|
(ii) Intangible Assets |
50,000 |
30,000 |
|
|
(b) Non-Current Investments |
80,000 |
50,000 |
|
|
2. Current Assets |
|||
|
(a) Inventories |
70,000 |
30,000 |
|
|
(b) Cash and Cash Equivalents |
30,000 |
40,000 |
|
|
Total |
5,10,000 |
3,30,000 |
From the following Balance Sheet of H.P. Ltd. as at 31st March, 2019, prepare Comparative Balance Sheet:
|
Particulars |
Note No. |
31st March, 2019 (₹) |
31st March, 2018 (₹) |
|
I. EQUITY AND LIABILITIES |
|||
|
1. Shareholders' Funds |
|||
|
(a) Share Capital: |
|||
|
(i) Equity Share Capital |
12,50,000 |
5,00,000 |
|
|
(ii) Preference Share Capital |
2,50,000 |
2,50,000 |
|
|
(b) Reserves and Surplus |
3,00,000 |
4,50,000 |
|
|
2. Non-Current Liabilities |
|||
|
Long-term Borrowings: 12% Debentures |
9,50,000 |
5,50,000 |
|
|
Loan from Directors |
2,50,000 |
2,00,000 |
|
|
3. Current Liabilities |
|||
|
(a)Short-term Borrowings |
3,50,000 |
1,75,000 |
|
|
(b) Trade Payables |
2,00,000 |
1,00,000 |
|
|
(c) Short-term Provisions |
50,000 |
25,000 |
|
|
Total |
36,00,000 |
22,50,000 |
|
|
II. ASSETS |
|||
|
1. Non-Current Assets |
|||
|
(a) Fixed Assets (Tangible) |
22,50,000 |
15,00,000 |
|
|
2. Current Assets |
|||
|
(a) Inventories |
4,50,000 |
2,50,000 |
|
|
(b) Trade Receivables |
8,00,000 |
4,50,000 |
|
|
(c) Cash and Cash Equivalents |
1,00,000 |
50,000 |
|
|
Total |
36,00,000 |
22,50,000 |
Prepare Comparative Statement of Profit and Loss from the following Statement of Profit and Loss:
|
Particulars |
Note No. |
31st March, 2019 (₹) |
31st March, 2018 (₹) |
| I. Income | |||
|
Revenue from Operations (Net Sales) |
3,50,000 | 3,00,000 | |
| II. Expenses | |||
|
Purchases of Stock-in-Trade |
2,10,000 | 1,80,000 | |
|
Change in Inventories of Stock-in-Trade |
15,000 | 20,000 | |
|
Employees Benefits Expenses |
17,500 | 15,000 | |
|
Other Expenses |
7,500 |
5,000 | |
|
Total |
2,50,000 | 2,20,000 | |
| III. Profit before Tax (I-II) |
1,00,000 |
80,000 | |
|
IV. Less: Tax |
30,000 |
24,000 | |
|
V. Profit after Tax (III-IV) |
70,000 |
56,000 |
Prepare Comparative Statement of Profit and Loss from the following Statement of Profit and Loss:
|
Particulars |
Note No. |
31st March, 2019 (₹) |
31st March, 2018 (₹) |
|
I. Income |
|||
|
Revenue from Operations (Net Sales) |
3,00,000 |
2,50,000 |
|
|
II. Expenses |
|||
|
Cost of Materials Consumed |
1,20,000 |
1,00,000 |
|
|
Changes in Inventories of WIP and Finished Goods |
(2,000) |
5,000 |
|
|
Employees Benefits Expenses (Wages) |
30,000 |
25,000 |
|
|
Other Expenses |
22,000 |
20,000 |
|
|
Total |
1,70,000 |
1,50,000 |
|
|
III. Net Profit (I-II) |
1,30,000 |
1,00,000 |
From the following Information, prepare Comparative Statement of Profit and Loss:
|
Particulars |
31st March, 2019 |
31st March, 2018 |
||
|
Revenue from Operations |
₹ 30,00,000 |
₹ 20,00,000 |
||
|
Other Income (% of Revenue from Operations) |
12% |
20% |
||
| Expenses (% of Operating Revenue) |
70% |
60% |
||
| Tax Rate |
40% |
40% |
||
From the following Statement of Profit and Loss, prepare Comparative Statement of Profit and Loss:
|
Particulars |
Note No. |
31st March, 2019 (₹) |
31st March, 2018 (₹) |
| I. Income | |||
|
Revenue from Operations (Net Sales) |
50,00,000 |
40,00,000 | |
| II. Expenses |
|
||
|
Purchases of Stock-in-Trade |
34,00,000 | 28,50,000 | |
|
Change in Inventories of Stock-in-Trade |
1 | 1,00,000 | 1,50,000 |
|
Employees Benefits Expenses |
1,00,000 | 1,00,000 | |
|
Other Expenses |
2 |
2,00,000 |
1,50,000 |
|
Total |
38,00,000 |
32,50,000 | |
| III. Net Profit (I-II) | 12,00,000 | 7,50,000 |
Notes to Accounts
|
Particulars |
31st March, 2019 (₹) |
31st March, 2018 (₹) |
| I. Change in Inventory of stock-in-Trade | ||
|
Opening Inventory |
2,00,000 |
3,50,000 |
|
Less: Closing Inventory |
1,00,000 |
2,00,000 |
|
1,00,000 |
1,50,000 | |
| 2. Other Expenses | ||
|
Administrative Expenses |
50,000 |
50,000 |
|
Selling and Distribution Expenses |
1,50,000 |
1,00,000 |
|
2,00,000 |
1,50,000 |
From the following Statement of Profit and Loss of Antriksh Ltd. for the year ended 31st March, 2012 and 2013, Prepare Comparative Statement of Profit and Loss:
| Particulars | Note No. | 31st March, 2013 (₹) |
31st March, |
||
| Revenue from Operations | 14,00,000 | 8,00,000 | |||
| Other Incomes | 6,00,000 |
4,00,000 |
|||
|
Expenses |
17,00,000 |
11,00,000 |
|||
Rate of Income Tax was 40%.
From the following Statement of Profit and Loss, prepare Comparative Statement of Profit and Loss:
|
Particulars |
Note No. |
31st March, 2019 (₹) |
31st March, 2018 (₹) |
| I. Income | |||
|
Revenue from Operations (Net Sales) |
20,00,000 | 17,50,000 | |
|
Other Income |
75,000 |
50,000 | |
|
Total |
20,75,000 | 18,00,000 | |
| II. Expenses |
|
||
|
Purchases of Stock-in-Trade |
11,60,000 | 10,00,000 | |
|
Change in Inventories of Stock-in-Trade |
10,000 | (25,000) | |
|
Employees Benefits Expenses |
1 | 3,00,000 | 3,00,000 |
|
Depreciation and Amortisation Expenses |
50,000 | 50,000 | |
|
Other Expenses |
2 |
90,000 |
75,000 |
|
Total |
16,10,000 |
14,00,000 | |
| III. Net Profit (I-II) | 4,65,000 | 4,00,000 |
Notes to Accounts
|
Particulars |
31st March, 2019 (₹) |
31st March, 2018 (₹) |
| I. Employees Benefit Expenses | ||
|
Wages |
3,00,000 |
3,00,000 |
| 2. Other Expenses | ||
|
Administrative and General Expenses |
70,000 |
50,000 |
|
Miscellaneous Expenses |
20,000 |
25,000 |
|
90,000 |
75,000 |
From the following Balance Sheets of Vinayak Ltd. as at 31st March, 2019, prepare a comparative Balance Sheet.
Vinayak Ltd.
Balance Sheet as at 31st March, 2019
| Particulars |
Note No. |
31-03-19(₹) |
31-03-18(₹) |
|
| Equity and Liabilities |
|
|
|
|
| (1) | Shareholders Funds |
|
|
|
| (a) Share capital |
|
21,00,000 |
20,00,000 |
|
| (b) Reserves and Surplus |
|
2,30,000 |
2,00,000 |
|
| (2) | Non-current liabilities |
|
|
|
| Long term borrowing |
|
5,60,000 |
2,00,000 |
|
| (3) | Current liabilities |
|
|
|
| Trade payables |
|
2,80,000 |
1,00,000 |
|
| Total |
|
31,70,000 |
25,00,000 |
|
| Assets |
|
|
|
|
| (1) | Non-current Assets |
|
|
|
| Fixed Assets |
|
|
|
|
| (i) Tangible assets |
|
21,00,000 |
20,00,000 |
|
| (ii) Intangible assets |
|
3,00,000 |
2,00,000 |
|
| (2) | Current Assets |
|
|
|
| (a) Inventories |
|
5,60,000 |
2,00,000 |
|
| (b) cash and cash equivalents |
|
2,10,000 |
1,00,000 |
|
| Total |
|
31,70,000 |
25,00,000 |
Prepare a comparative statement of Profit and Loss from the following information extracted from the statement of Profit and Loss for the year ended 31st March, 2017 and 2018.
| Particulars | 2017-18 | 2016-17 |
| Revenue from operations | (₹) 12,00,000 | (₹)10,00,000 |
| Other income (% of Revenue from operations) | 25% | 25% |
| Employee benefit expenses(% of Total Revenue) | 40% | 30% |
| Tax Rate | 40% | 40% |
From the information extracted from the Statement of Profit and Loss prepare a Comparative Statement of Profit and Loss for the year ended 31st March, 2021:
| Particulars | 2020 - 21 (₹) | 2019 - 20 (₹) |
| Revenue from operations | 7,20,000 | 4,00,000 |
| Expenses | 5,00,000 | 2,00,000 |
| Tax Rate @ 50% |
From the following Balance Sheet of J. J. Ltd. prepare a Comparative Balance Sheet as at 31.3.2022:
| J. J. Ltd. Balance Sheet as at 31.3.2022 |
|||
| Particulars | Note No. | 31.3.2022 (₹) | 31.3.2021 (₹) |
| I. Equity and Liabilities | |||
| 1. Shareholders' Funds | |||
| (a) Equity Share Capital | 25,00,000 | 20,00,000 | |
| (b) Reserves and Surplus | 5,00,000 | 4,00,000 | |
| 2. Non-Current Liabilities | |||
| Long-term borrowings | 10,00,000 | 10,00,000 | |
| 3. Current Liabilities | |||
| Trade payables | 2,00,000 | 1,00,000 | |
| Total | 42,00,000 | 35,00,000 | |
| II. Assets | |||
| 1. Non Current Assets | |||
| Fixed Assets | 30,00,000 | 25,00,000 | |
| 2. Current Assets | |||
| Inventories | 12,00,000 | 10,00,000 | |
| Total | 42,00,000 | 35,00,000 | |
From the following data of Horizon Ltd., you are required to prepare a Comparative Statement of Profit and Loss.
| Particulars | 31.03.2022 | 31.03.2021 |
| Revenue from Operations (% of Other Income) | 100% | 100% |
| Other Income | ₹ 1,00,000 | ₹ 50,000 |
| Cost of Materials consumed | ₹ 50,000 | ₹ 20,000 |
| Depreciation and Amortisation Expense | ₹ 10,000 | ₹ 5,000 |
