English

You Are Required to Prepare Cash Flow Statement. - Accountancy

Advertisements
Advertisements

Question

Following is the summarised Balance Sheet of Philips India Ltd. as at 31st March 2018:

Particulars

Note No.

31st March, 2018

(₹)

31st March, 2017

(₹)

I. EQUITY AND LIABILITIES      

1. Shareholders' Funds

     

(a) Share Capital

  13,50,000 13,50,000

(b) Reserves and Surplus

1 11,34,000 10,68,000

2. Non-Current Liabilities

     

Long-term Borrowings:
10% Mortgage Loan

  8,10,000 ...

3. Current Liabilities

     

(a) Trade Payables (Creditors)

  4,20,000 5,04,000

(b) Short-term Provisions:

     

      Provision for Tax

  30,000 2,25,000

Total

  37,26,000 31,47,000
II. ASSETS      

1, Non-Current Assets

     

(a) Fixed Assets (Tangible)

  9,60,000 12,00,000

(b) Non-Current Investments

  1,80,000 1,50,000

2. Current Assets

     

(a) Current Investments

  21,000 17,000

(b) Inventories

  63,30,000 7,82,000

(c) Trade Receivables

  13,65,000 6,30,000

(c) Cash and Cash Equivalents

  5,70,00 4,30,000

Total

  37,26,000 31,47,000
       

Notes to Accounts

Particulars

31st March, 2018

(₹)

31st March, 2017

(₹)

I. Reserves and Surplus    

General Reserve

9,30,000 9,00,000

Surplus, i.e., Balance in Statement of Profit and Loss

2,04,000 1,68,000

 

11,34,000 10,68,000
     

Additional Information:
1. Investments costing ₹ 24,000 were sold during the year for ₹ 25,5000.
2. Provistion for Tax made during the year was ₹ 27,000.
3. During the year, a part of the Fixed Assets costing ₹ 30,000 was sold for ₹ 36,000. The rofits were included in the Statement of Profit and Loss.
4. The Interim Dividend paid during the year amounted to ₹ 1,20,000.
You are required to prepare Cash Flow Statement.

Numerical

Solution

Cash Flow Statement

for the year ended March 31, 2018

 

Particulars

Amount

(Rs)

Amount

(Rs)

A

Cash Flow from Operating Activities

 

 

 

Profit as per Statement of Profit and Loss
(2,04,000 – 1,68,000)

36,000

 

 

Transfer to General Reserve

30,000

 

 

Interim Dividend

1,20,000

 

 

Provision for Taxation

27,000

 

 

Profit Before Taxation

2,13,000

 

 

Items to be Added:

 

 

 

Depreciation

2,10,000

 

 

Profit on Sale of Investments

(1,500)

 

 

Profit on Sale of Fixed Assets

(6,000)

 

 

Operating Profit before Working Capital Adjustments

4,15,500

 

 

Less: Increase in Current Assets

 

 

 

Trade Receivables

(7,35,000)

 

 

Less: Decrease in Current Liabilities

 

 

 

Trade Payables

(1,02,000)

 

 

Add: Decrease in Current Assets

 

 

 

Inventories

90,000

 

 

Cash Generated from Operations

(3,31,500)

 

 

Less: Tax Paid

(2,22,000)

 

 

Net Cash from (used in) Operating Activities

 

(5,53,500)

 

 

 

 

B

Cash Flow from Investing Activities

 

 

 

Sale of Investments

25,500

 

 

Sale of Fixed Assets

36,000

 

 

Purchase of Investments

(54,000)

 

 

Net Cash Flow from Investing Activities

 

7,500

 

 

 

 

C

Cash Flow from Financing Activities

 

 

 

Proceeds from Issue of 10% Mortgage Loan

8,10,000

 

 

Interim Dividend Paid

(1,20,000)

 

 

Net Cash Flow from Financing Activities

 

6,90,000

 

 

 

 

D

Net Increase in Cash and Cash Equivalents

 

1,44,000

 

Add: Cash and Cash Equivalent in the beginning of the period

 

4,47,000

 

Cash and Cash Equivalents at the end of the period

 

5,91,000

Working Notes:
WN1

Fixed Assets Account

Dr.

Cr.

Particulars

Amount

(Rs)

Particulars

Amount

(Rs)

Balance b/d

12,00,000

Bank A/c  (Sale)

36,000

Profit and Loss A/c (Profit on Sale)

6,000

Depreciation (Bal. Fig.)

2,10,000

 

 

Balance c/d

9,60,000

 

12,06,000

 

12,06,000

WN2

Investments Account

Dr.

Cr.

Particulars

Amount

(Rs)

Particulars

Amount

(Rs)

Balance b/d

1,50,000

Bank A/c (Sale)

25,500

Profit and Loss A/c (Profit on Sale)

1,500

Balance c/d

1,80,000

Bank A/c (Purchases- Bal. Fig.)

54,000

 

 

 

2,05,500

 

2,05,500

WN 3

Provision for Taxation Account

Dr.

Cr.

Particulars

Amount

(Rs)

Particulars

Amount

(Rs)

Bank A/c (Tax Paid- Bal. Fig.)

2,22,000

Balance b/d

2,25,000

Balance c/d

30,000

Profit and Loss A/c

27,000

 

2,52,000

 

2,52,000

shaalaa.com
Preparation of Cash Flow Statement
  Is there an error in this question or solution?
Chapter 4: Cash Flow Statement - Exercises [Page 113]

APPEARS IN

TS Grewal Accountancy - Analysis of Financial Statements [English] Class 12
Chapter 4 Cash Flow Statement
Exercises | Q 51 | Page 113

RELATED QUESTIONS

Calculate Cash Flow from Operating Activities from the following details:

Particulars 31st March, 2019 (₹) 31st March, 2018 (₹)
Surplus, i.e.,Balance in Statement of Profit and Loss 80,000 60,000
Trade Receivables 25,000 31,000
Provision for Depreciation 40,000 30,000
Inventories 80,000 60,000
Outstanding Rent 12,000 21,000
Goodwill 30,000 38,000
Prepaid Insurance 1,000 2,000
Trade Payables (Creditors) 13,000 19,000

Charles Ltd. earned a profit of ₹ 1,00,000 after charging depreciation of 20,000 on assets and a transfer to General Reserve of ₹ 30,000. Goodwill amortised was ₹ 7,000, and gain on sale of machinery was ₹ 3,000. Other information available is (changes in the value of Current Assets and Current Liabilities): trade receivables showed an increase of ₹ 3,000; trade payables an increase of ₹ 6,000; Prepaid expenses an increase of ₹ 200; and outstanding expenses a decrease of ₹ 2,000.
Ascertain Cash Flow from Operating Activities.


Compute Cash Flow from Operating Activities from the following:
(i) Profit for the year ended 31st March, 2019 is ₹ 10,000 after providing for depreciation of ₹ 2,000.
(ii) Current Assets and Current Liabilities of the business for the year ended 31st March, 2018 and 2019 are as follows:

Particular

31st March
2018

(₹)

31st March
2019

(₹)
Trade Receivables 14,000 15,000

Provision for Doubtful Debts

1,000 1,200

Trade Payables

13,000 15,000
Inventories 5,000 8,000
Other Current Assets 10,000 12,000
Expenses Payables 1,000 1,500
Prepaid Expenses 2,000 1,000
Accrued Income 3,000 4,000
Income Received in Advance

2,000

1,000

Calculate Cash Flow from Operating Activities from the following information:
INCOME STATEMENT (STATEMENT OF PROFIT AND LOSS)for the year ended 31st March, 2019

Particulars

Note No.

(₹)

I. Revenue from Operations (Sales)  

5,98,000

II. Other Income

1

19,500

III. Total Revnue (I + II)  

6,17,500

IV. Expenses :    

Cost of Materials Consumed

 

4,00,000

Change in Inventories of Finished Goods and Work-in-Progress

2

15,000

Employee Benefit Expenses

 

1,05,000

Depreciation and Amortisation Expenses

 

15,000

Other Expenses

3

20,000

Total Expenses

 

5,55,000

V. Profit before Tax (III − IV)  

62,500

VITax @ 30%  

18,750

VII. Profit after Tax (V − VI)  

43,750

Notes to Accounts

Particulars

1. Other Income  

Rent

15,000

Gain (Profit) on Sale of Machinery

2,500

Interest on Debentures held as Investments

2,000

 

19,500

Changes in Inventories of Finished Goods and Work-in-Progress  
(a) Finished Goods  

Opening Inventories

37,500

Less: Closing Inventories

25,000

Sub-Total

12,500
(b) Work-in-Progress  

Opening Inventories

22,500

Less: Closing Inventories

20,000

Sub-Total

2,500

Total (a + b)

15,000

2. Other Expenses  

Office Expenses

12,500

Selling Expenses

6,000

Loss on Sale of Furniture

1,500

 

20,000

 

Current Assets and Current Liabilities

As on 31st March,
2019 (₹)

As on 1st April,
2018 (₹)

Trade Receivables

25,000

20,000

Trade Payables

32,500

35,000

Outstanding Expenses

8,000

5,000

Prepaid Expenses

5,000

3,500


Following is the Balance Sheet of Fine Products 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: Equity Share Capital

 

3,50,000

3,00,000

(b) Reserves and Surplus

1

57,000

38,000

2. Current Liabilities : 

     

(a) Trade Payables

 

53,000

35,000

(b) Other Current Liabilities

 

6,000

8,000

(c) Short-term Provisions

2

32,000

28,000

Total  

4,98,000

4,09,000

II. ASSETS :      

1. Non-Current Assets :

     

(a) Fixed Assets:

     

(i) Tangible Assets

3

2,48,000

2,00,000

(ii) Intangible Assets (Goodwill)

 

40,000

50,000

(b) Non-Current Investments

 

35,000

10,000

2. Current Assets :

     

(a) Inventories

 

39,000

57,000

(b) Trade Receivables

 

1,08,000

75,000

(c) Cash and Bank Balance

 

28,000

17,000

Total  

4,98,000

4,09,000

Notes to Accounts

Particulars

31st March, 2019

(₹)

31st March, 2018

(₹)

1. Reserves and Surplus    

General Reserve

30,000

20,000

Surplus, i.e.,Balance in Statement of Profit and Loss

27,000

18,000

 

57,000

38,000

2. Short-term Provisions    

Provision for Tax

32,000

28,000

3. Tangible Fixed Assets    

Land and Building

57,000

1,10,000

Plant and Machinery

1,91,000

90,000

 

2,48,000

2,00,000

Note: Proposed dividends on equity for the years ended 31st March, 2018 and 2019 are ₹ 39,000 and ₹ 45,000 respectively. You are required to prepare Cash Flow Statement for the year ended 31st March, 2019.


Prepare a Cash Flow Statement on the basis of the information given in the Balance Sheet of Libra Ltd. as at 31st March, 2013 and 31st March 2012:

Particulars

Note No.

31st March, 2013

(₹)

31st March, 2012

(₹)

I. EQUITY AND LIABILITIES      

1. Shareholders' Funds

     

(a) Share Capital

  8,00,000 6,00,000

(b) Reserves and Surplus

1 4,00,000 3,00,000

2. Non-Current Liabilities

     

Long-term Borrowings

  1,00,000 1,50,000

3. Current Liabilities

     

(a) Trade Payables

  40,000 48,000

Total

  13,40,000 10,98,000
II. ASSETS      

1, Non-Current Assets

     

(a) Fixed Assets:

     

Tangible Assets

  8,50,000 5,60,000

(b) Non-Current Investments

  2,32,000 1,60,000

2. Current Assets

     

(a) Current Investments

  50,000 1,34,000

(b) Inventories

  76,000 82,000

(c) Trade Receivables

  38,000 92,000

(d) Cash and Cash Equivalents

  94,000 70,000

Total

  13,40,000 10,98,000

Notes to Accounts

Particulars

31st March, 2013

(₹)

31st March, 2012

(₹)

I. Reserves and Surplus    

Surplus, i.e., Balance in Statement of Profit and Loss

4,00,000 3,00,000

From the following Balance Sheet of Kumar Ltd. as at 31st March, 2019, prepare Cash Flow Statement

Particulars

Note No.

31st March, 2019

(₹)

31st March, 2018

(₹)

I. EQUITY AND LIABILITIES      

1. Shareholders' Funds

     

(a) Share Capital

1 16,00,000 10,40,000

(b) Reserves and Surplus,

2 5,50,000 2,60,000

2. Non-Current Liabilities

     

  Long-term Borrowings:

     

    9% Debentures

  4,00,000 6,00,000

3. Current Liabilities

     

  Trade Payables

  4,50,000 1,00,000

Total

  30,00,000 20,00,000
II. ASSETS      

1. Non-Current Assets

     

  Fixed Assets

  20,00,000 15,00,000

2. Current Assets

     

 (a) Inventories

  3,00,000 2,00,000

 (b) Trade Receivables

  2,00,000 1,00,000

 (c) Cash and Cash Equivalents

  5,00,000 2,00,000

Total

  30,00,000 20,00,000

Notes to Accounts

Particulars

31st March, 2019

(₹)

31st March, 2018

(₹)

1. Share Capital    

    Equity Share Capital

15,00,000 10,00,000

    7% Preference Share Capital

1,00,000 40,000
  16,00,000 10,40,000
2. Reserves and Surplus    

    General Reserve

4,00,000 60,000

    Surplus, i.e., Balance in Statement of Profit and Loss

1,50,000 2,00,000
  5,50,000 2,60,000

Additional Information:
1. During a year, a machinery costing ₹ 20,000 was sold for ₹ 6,000.
2. Dividend paid during the year ₹ 50,000.


Following was the Balance Sheet of M.M. Ltd. as at 31st March, 2015

Particulars Note No.

(₹)

(₹)

I. EQUITY AND LIABILITIES      

1. Shareholders' Funds

     

(a) Share Capital

  5,00,000 4,00,000

(b) Reserves and Surplus

1 2,00,000 (50,000)

2. Non-Current Liabilities

     

Long-term Borrowings

2 4,50,000 5,00,000

3. Current Liabilities

     

(a) Short-term Borrowings

3 1,50,000 50,000

(b) Short-term Provisions

4 70,000 90,000

Total      Total Expenses

  13,70,000 9,90,000
II. ASSETS      

1. Non-Current Assets

     

(a) Fixed Assets:

     

(i) Tangible Assets

5 10,03,000 7,20,000

 (ii) Intangible Assets

6 20,000 30,000

(b) Non-Current Investments

  1,00,000 75,000

2. Current Assets

     

(a) Current Investments

  50,000 60,000

(b) Inventories

7 1,07,000 45,000

(c) Cash and Cash Equivalents

  90,000 60,000

Total

  13,70,000 9,90,000

Notes to Accounts :

Particular

31st March 2015

(₹)

31st March 2014

(₹)

1.

Reserves and Surplus    

 

Surplus, i.e., Balance in Statement of Profit and Loss

2,00,000

(50,000)

 

 

2,00,000

(50,000)

2.

Long-term Borrowings

 

 

 

12% Debentures

4,50,000

5,00,000

 

 

4,50,000

5,00,000

3.

Short-term Borrowings

 

 

 

Bank Overdraft

1,50,000

50,000

 

 

1,50,000

50,000

4.

Short-term Provisions

 

 

 

Provision for Tax

70,000

90,000

 

 

70,000

90,000

5.

Tangible Assets

 

 

 

Machinery

12,03,000

8,21,000

 

  Less: Accumulated Depreciation

(2,00,000)

(1,01,000)

 

 

10,03,000

7,20,000

6.

Intangible Assets

 

 

 

Goodwill

20,000

30,000

 

 

20,000

30,000

7.

Inventories

 

 

 

Stock-in-Trade

1,07,000

45,000

 

 

1,07,000

45,000

Additional Information:
1. 12% Debentures were redeemed on 31st March, 2015.
2. Tax ₹ 70,000 was paid during the year.
Prepare Cash Flow Statement.


From the following Balance Sheet of JY Ltd. as at 31st March 2017, prepare a Cash Flow Statement:

Balance sheet as at 31st March, 2017

Particular

Note No.

31st March, 2017 (₹)

31st March, 2016 (₹)

I. EQUITY AND LIABILITIES      
1. Shareholders' Funds      
(a) Share Capital   5,00,000 5,00,000
(b) Reserves and Surplus 1 1,00,000 25,000
2. Non-Current Liabilities      
Long-term Borrowings 2 2,50,000 1,50,000
3. Current Liabilities      
(a) Short-term Borrowings 3 1,50,000 1,10,000
(b) Short-term Provisions 4 1,25,000 75,000
Total   11,25,000 8,00,000
II. ASSETS      
1. Non-Current Assets      
Fixed Assets–Tangible 5 6,00,000 4,50,000
2. Current Assets      
(a) Trade Receivables   2,75,000 2,25,000
(b) Cash and Cash Equivalents   50,000 25,000
(c) Short-term Loans and Advances   2,00,000 1,00,000
Total   11,25,000 8,00,000

Notes to Accounts

Particular 31st March, 2017
(₹)
31st March, 2016
(₹)
1. Reserves and Surplus    
  Surplus, i.e., Balance in Statement of Profit and Loss 1,00,000 (25,000)
    1,00,000 (25,000)
2. Long-term Borrowings    
  10% Debentures 2,50,000 1,50,000
    2,50,000 1,50,000
3. Short-term Borrowings    
  Bank Overdraft 1,50,000 1,00,000
    1,50,000 1,00,000
4. Short-term Provisions    
  Provision for Tax 1,25,000 75,000
    1,25,000 75,000
5. Tangible Assets    
  Machinery 7,37,500 5,25,000
  Accumulated Depreciation (1,37,500) (75,000)
    6,00,000 4,50,000

Note: Proposed Dividend for the years ended 31st March, 2016 and 2017 are ₹ 50,000 and ₹ 75,000, respectively.

Additional Information: 
₹ 1,00,000, 10% Debentures were issued on 31st March, 2017.


From the following Balance Sheet of Akash Ltd. as at 31st March 2014:

Particulars

Note No.

31st March, 2014

(₹)

31 March, 2013

(₹)

I. EQUITY AND LIABILITES

1. Shareholders' Funds

     

(a) Share Capital

 

15,00,000

14,00,000

(b) Reserves and Surplus

1

2,50,000

1,10,000

2. Non-Current Liabilities

     

Long-term Borrowings

 

2,00,000

1,25,000

3. Current Liabilities

     

(a) Short-term Borrowings

2

12,000

10,000

(b) Trade Payables

  15,000 83,000

(c) Short-term Provisions

3

18,000

11,000

Total

 

19,95,000

17,39,000

II. ASSETS

     

1. Non-Current Assets

     

Fixed Assets:

     

(i) Tangible Assets

4

18,60,000

16,10,000

(ii) Intangible Assets

5 50,000 30,000

2. Current Assets

     

(a) Current Investments

 

8,000

5,000

(b) Inventories

  37,000 59,000

(c) Trade Receivables

 

26,000

23,000

(d) Cash and Cash Equivalents

 

14,000

12,000

Total

 

19,95,000

17,39,000

 

Notes to Accounts :
Particulars 31st March, 2014 (₹) 31st March, 2013 (₹)
1. Reserves and Surplus    

Surplus,i.e.,Balance in Statement of Profit and Loss

2,50,000 1,10,000
2. Short-term Borrowings :    

Bank Overdraft

12,000 10,000
3. Short-term Provisions    

Provision for Tax

18,000 11,000
4. Tangible Assets :    

Machinery

20,00,000 17,00,000

Less: Accumulated Depreciation

(1,40,000) (90,000)
  18,60,000 16,10,000
5. Intangible Assets    

Patents

50,000 30,000

Additional Information :  
(i) Tax paid during the year amounted to ₹ 16,000.
(ii) machine with a net book value of ₹ 10,000 (Accumulated Depreciation ₹ 40,000) was sold for ₹ 2,000.
Prepare Cash Flow Statement.


From the following Balance Sheet and information of Sun Ltd., prepare Cash Flow Statement:

Particulars Note No. 31st March, 2019
(₹)
31st March, 2018
(₹)
I. EQUITY AND LIABILITIES      
1. Shareholders' Funds      
(a) Share Capital 1 7,00,000 6,00,000
(b) Reserves and Surplus 2 4,10,000 2,00,000
2. Non-Current Liabilities      
Long-term Borrowings: 
10% Debentures
  3,00,000 2,00,000
3. Current Liabilities      
(a) Trade Payables   1,40,000 60,000
Total   15,50,000 10,60,000
II. ASSETS      
1. Non-Current Assets      
(a) Fixed Assets−Tangible   7,00,000 6,00,000
(b) 10% Investments   2,00,000 1,00,000
2. Current Assets      
(a) Current Investments   90,000 50,000
(b) Inventories   2,00,000 1,00,000
(c) Trade Receivables 3 2,80,000 1,90,000
(d) Cash and Cash Equivalents   80,000 20,000
Total   15,50,000 10,60,000

Notes to Accounts :

Particulars 31st March, 2019
(₹)
31st March, 2018
(₹)
1. Share Capital    
Equity Share Capital 5,00,000 3,00,000
10% Preference Share Capital 2,00,000 3,00,000
  7,00,000 6,00,000
2. Reserves and Surplus    
Securities Premium Reserve 10,000 -
Surplus i.e., Balance in Statement of Profit and Loss 4,00,000 2,00,000
  4,10,000 2,00,000
3. Trade Receivables    
Sundry Debtors 3,00,000 2,00,000
Less: Provision for Doubtful Debts 20,000 10,000
  2,80,000 1,90,000

You are informed that during the year:

(i) Proposed Dividend: 31st March, 2019 31st March, 2018
  Equity Share Capital Nil Nil
  Preference Share Capital 10% 10%

(ii) A machine with a book value of ₹ 90,000 was sold for ₹ 50,000;

(iii) Depreciation charged during the year ₹ 60,000;

(iv) Debentures were issued on 1st April 2018;

(v) Investments were purchased on 31st March 2019;

(vi) Preference shares were redeemed on 31st December 2018;

(vii) An interim dividend @ 15% was paid on equity shares on 31st December 2018.

(viii) Fresh equity shares were issued at a premium of 5% on 31st March 2019.


Which of the following transactions will result in 'Flow of Cash'?


Dividend received by the financial enterprise is shown in the cash flow statement under:


From the following information, find out the inflow of cash:

  31st March, 2015 31st March, 2014
Plant and Machinery Account ₹ 6,00,000 ₹ 4,50,000
Accumulated Depreciation ₹ 1,60,000 ₹ 1,00,000

Additional Information:

Depreciation for the years 2014-2015 is ₹ 80,000

During the year Machinery was purchased for ₹ 2,50,000 and a part of the asset was sold at a profit of ₹ 40,000.


Shareholders get:


From the following information, find out the Cash Flow from Financing Activities.

Proposed Dividend  
31st March, 2013 ₹ 20,000
31st March, 2014 ₹ 15,000

 

Additional Information:  
Equity Share Capital raised ₹ 3,00,000
10% Debentures Redeemed ₹ 1,00,000
Preference Share Capital Redeemed ₹ 50,000
Interim Dividend paid during the year ₹ 20,000

Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×