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

Page No 3.35:

Question 13:

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

Particulars

31st March,

2019

31st March,

2018

Revenue from Operations

 ` 37,50,000

 ` 25,00,000

Other Income

 ` 4,50,000

 ` 5,00,000

Cost of Materials Consumed

 ` 22,50,000

 ` 12,50,000

Other Expenses

 ` 3,75,000

 ` 2,50,000

Tax Rate

50%

50%

Answer:

Comparative Income Statement

for the year ended March 31, 2018 and 2019

Particulars

March 31, 2018

( `)

March 31, 2019

( `)

Absolute

Change

( `)

Percentage

Change

(%)

I. Revenue from operations

25,00,000

37,50,000

12,50,000

50.00

II. Other Income

5,00,000

4,50,000

(50,000)

(10.00)

III. Total Revenue (I + II)

30,00,000

42,00,000

12,00,000

40.00

IV. Expenses

 

 

 

 

a. Cost of Materials Consumed

12,50,000

22,50,000

10,00,000

80.00

b. Other Expenses

2,50,000

3,75,000

1,25,000

50.00

 

15,00,000

26,25,000

11,25,000

75.00

 

 

 

 

 

Profit before Income Tax

15,00,000

15,75,000

75,000

5.00

Less: Income Tax @ 50%

7,50,000

7,87,500

37,500

5.00

Profit after Income Tax

7,50,000

7,87,500

37,500

5.00

 

 

 

 

 



Page No 3.34:

Question 14: Prepare a Comparative Statement of Profit and Loss from the 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

15,00,000

10,00,000

Other Income (% of Revenue from Operations)

60%

50%

Employee Benefit Expenses (% of total revenue)

40%

30%

Tax Rate

40%

40%

 (Delhi 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

15,00,000

5,00,000

50.00

Other Income

(% of Revenue from Operations)

 

5,00,000

9,00,000

4,00,000

80.00

Total Revenue

 

15,00,000

24,00,000

9,00,000

60.00

Employee Benefit Expenses

(% of total revenue)

 

4,50,000

9,60,000

5,10,000

113.33

Profit before Tax

 

10,50,000

14,40,000

3,90,000

37.14

Less: Tax 40%

 

4,20,000

5,76,000

1,56,000

37.14

Profit after Tax

 

6,30,000

8,64,000

2,34,000

37.14

 



Page No 3.35:

Question 15:

From the following information, prepare Comparative Statement of Profit and Loss showing increase, decrease and percentage:

Particulars

31st March, 2019

31st March, 2018

Cost of Materials Consumed

 ` 13,44,000

 ` 6,00,000

Revenue from Operations (% of Materials Consumed)

125%

200%

Other Expenses (% of Operating Revenue)

10%

10%

Tax Rate

50%

50%

Answer:

Comparative Income Statement

for the year ended 31st March, 2018 and 2019

Particulars

March 31, 2018

( `)

March 31, 2019

( `)

Absolute

Change

( `)

Percentage

Change

(%)

I. Revenue from Operations (WN1)

12,00,000

16,80,000

4,80,000

40.00

II. Expenses

 

 

 

 

a. Cost of Material Consumed

6,00,000

13,44,000

7,44,000

124.00

b. Other Expenses (WN2)

1,20,000

1,68,000

48,000

40.00

 

7,20,000

15,12,000

7,92,000

110.00

 

 

 

 

 

Profit before Income Tax (I-II)

4,80,000

1,68,000

(3,12,000)

(65.00)

Less: Income Tax @ 50%

2,40,000

84,000

(1,56,000)

(65.00)

Profit after Income Tax

2,40,000

84,000

1,56,000

(65.00)

 

 

 

 

 


Working Notes:
 

WN1 Computation of Revenue from Operations
 

Particulars

2018

( `)

2019

( `)

Cost of Materials Consumed

6,00,000

13,44,000

% of Materials Consumed

200%

125%

Revenue from Operations

12,00,000

16,80,000

 

WN2 Computation of Other Expenses
 

Particulars

2018

( `)

2019

( `)

Revenue From Operations

12,00,000

16,80,000

% of Operating Revenue

10%

10%

Other Expenses

1,20,000

1,68,000

 



Page No 3.35:

Question 16:

From the following particulars obtained from the books of Mark, prepare a Comparative Statement of Profit and Loss:

Particulars

31st March,

2018 (`)

31st March,

2017 (`)

Revenue from Operations

50,00,000

40,00,000

Purchase of Stock-in-Trade

40,00,000

30,00,000

Changes in Inventory

10,00,000

8,00,000

Other Expenses

5,00,000

4,00,000

Other Incomes

2,50,000

2,00,000

 

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

 

40,00,000

50,00,000

10,00,000

25

Other Incomes

 

2,00,000

2,50,000

50,000

25

Total Revenue

 

42,00,000

52,50,000

10,50,000

25

Expenses

 

 

 

 

 

Purchase of Stock-in-Trade

 

30,00,000

40,00,000

10,00,000

33.3

Changes in Inventory

 

8,00,000

10,00,000

2,00,000

25

Other Expenses

 

4,00,000

5,00,000

13,00,000

25

Total Expenses

 

42,00,000

55,00,000

13,00,000

30.95

Profit before Tax

 

. . .

(2,50,000)

(2,50,000)

Less: Tax … %

 

. . .

. . .

. . .

Profit after Tax

 

42,00,000

55,00,000

13,00,000

30.95