12th | Ts grewal 2021-2022 Question 9 to 12 | ch:3 Tools of Financial statement analysis- Comparative statement and Common-Size statement

Page No 3.33:

Question 9: From the following Statement of Profit and Loss of Skills India Ltd. for the year ended 31st March, 2018 and 2019, prepare a Comparative Statement of Profit and Loss:

Particulars

31st March, 2019 (`)

31st March,

2018 (`)

Revenue from Operations

45,00,000

20,00,000

Employee Benefit Expenses

10,00,000

8,00,000

Other Expenses

5,00,000

2,00,000

Tax Rate 30%

 

 

 (CBSE 2020)

Answer:

Comparative Statement of Profit and Loss as at 31st March, 2019

Particulars

Note No.

31st March, 2018 (`)

31st March, 2019(`)

Absolute Change

(Increase/Decrease)(`)

Percentage Change

(Increase/Decrease)(%)

 

(A)

(B)

(C = A-B)

(D = C/A×100)

Revenue from Operations

 

20,00,000

45,00,000

25,00,000

125

Employee Benefit Expenses

 

8,00,000

10,00,000

2,00,000

25

Other Expenses

 

2,00,000

5,00,000

3,00,000

150

Total Expenses

 

10,00,000

15,00,000

5,00,000

50

Profit before Tax

 

10,00,000

30,00,000

20,00,000

200

Less: Tax 30%

 

3,00,000

9,00,000

6,00,000

200

Profit after Tax

 

7,00,000

21,00,000

14,00,000

200

 



Page No 3.33:

Question 10:

Following information is extracted from the Statement of Profit and Loss of Gold Coin Ltd. for the year ended 31st March, 2015:

 

Particulars

31st March,

2015

31st March, 2014

Revenue from Operations

 ` 60,00,000

 ` 45,00,000

Employee Benefit Expenses

 ` 30,00,000

 ` 22,50,000

Depreciation

 ` 7,50,000

 ` 6,00,000

Other Expenses

 ` 15,50,000

 ` 10,00,000

Tax Rate

30%

30%

Answer:

Comparative Income Statement

for the year ended March 31, 2014 and 2015

Particulars

2014

(Rs)

2015

(Rs)

Absolute

Change

(Rs)

Percentage

Change

(%)

I. Revenue from Operations

45,00,000

60,00,000

15,00,000

33.33

II. Expenses

 

 

 

 

a. Depreciation

6,00,000

7,50,000

1,50,000

25.0

b. Employees Benefit Expenses

22,50,000

30,00,000

7,50,000

33.33

c. Other Expenses

10,00,000

15,50,000

5,50,000

55.0

     

38,50,000

53,00,000

14,50,000

37.66

Profit before Income Tax

6,50,000

7,00,000

50,000

7.69

Less: Income Tax

1,95,000

2,10,000

15,000

7.69

Profit after Income Tax

4,55,000

4,90,000

35,000

7.69

 

 

 

 

 

 



Page No 3.34:

Question 11:

Prepare Comparative Statement of Profit and Loss from the following Statement of Profit and Loss:
 

Particulars ulars

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

 

 

 

 

Answer:

Comparative Income Statement

for the year ended March 31, 2018 and 2019

Particulars

2018
(
`)

2019
(
`)

Absolute

Change

( `)

Percentage

Change

(%)

I. Revenue from Operations

3,00,000

3,50,000

50,000

16.67

II. Expenses

 

 

 

 

a. Purchase of Stock-in-Trade

1,80,000

2,10,000

30,000

16.67

b. Changes in Inventories of Stock-in-Trade

20,000

15,000

(5,000)

(25.00)

c. Employees Benefit cost

15,000

17,500

2,500

16.67

d. Other Expenses

5,000

7,500

2,500

50.00

 

2,20,000

2,50,000

30,000

13.67

Profit before Income Tax (I-II)

80,000

1,00,000

20,000

25.00

Less: Income Tax

24,000

30,000

6,000

25.00

Profit after Income Tax

56,000

70,000

14,000

25.00

 

 

 

 

 



Page No 3.34:

Question 12: Prepare a Comparative Income Statement of Bikul Ltd. with the help of the following information:

Particulars

2016-17 (`)

2017-18 (`)

Revenue from Operations

10,00,000

16,00,000

Cost of Materials Consumed

5,00,000

10,00,000

Employee Benefit Expenses

80,000

40,000

Other Indirect Expenses

60,000

80,000

Income Tax Rate 40%.

 

 

(CBSE 2019)

Answer:

Comparative Statement of Profit and Loss as at 31st March, 2018

Particulars

Note No.

31st March,

2017 (`)

31st March,

2018(`)

Absolute Change

(Increase/Decrease)(`)

Percentage Change

(Increase/Decrease)(%)

 

(A)

(B)

(C = A-B)

(D = C/A×100)

Revenue from Operations

 

10,00,000

16,00,000

6,00,000

60.00

Expenses

 

 

 

 

 

Cost of Materials Consumed

 

5,00,000

10,00,000

5,00,000

100.00

Employee Benefit Expenses

 

80,000

40,000

(40,000)

(50.00)

Other Indirect Expenses

 

60,000

80,000

20,000

33.33

Total Expenses

 

6,40,000

11,20,000

4,80,000

75.00

Profit before Tax

 

3,60,000

4,80,000

1,20,000

33.33

Less: Tax 40%

 

1,44,000

1,92,000

48,000

33.33

Profit after Tax

 

2,16,000

2,88,000

72,000

33.33