English

From the Following Balance Sheet of Mishi Ltd. as at 31st March, 2019, Prepare Cash Flow Statement: - Accountancy

Advertisements
Advertisements

Question

From the following Balance Sheet of Mishi 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

  16,00,000 12,00,000

(b) Reserves and Surplus

1 6,60,000 4,40,000

2. Non-Current Liabilities

     

  Long-term Borrowings (10% Debentures)

  3,20,000 2,00,000

3. Current Liabilities

     

(a) Short-term Borrowing (Bank Loan)

  80,000 1,10,000

(b) Trade Payables

  1,50,000 1,80,000

Total      Total Expenses

  28,10,000 21,30,000
II. ASSETS      

1. Non-Current Assets

     

 (a) Fixed Assets−Tangible

2 19,00,000 12,10,000

 (b) Non-Current Investments

  2,70,000 2,00,000

2. Current Assets

     

  (a) Current Investments

  1,60,000 80,000

  (b) Trade Receivables

  1,80,000 4,00,000

  (c) Cash and Cash Equivalents

3 3,00,000 2,40,000

Total

  28,10,000 21,30,000

  

Notes to Accounts :

Particulars

31st March,

2019

(₹)

31st March,

2018

(₹)

1. Reserves and Surplus :

   

Securities Premium Reserve

20,000

...

General Reserve

3,00,000

2,40,000

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

3,40,000

2,00,000

 

6,60,000

4,40,000

2. Fixed Assets−Tangible

   

Machinery (Cost)

21,40,000

14,00,000

Less: Accumulated Depreciation

2,40,000

1,90,000

 

19,00,000

12,10,000

3. Cash and Cash Equivalents

   

Cash in Hand

1,40,000

1,10,000

Bank Balance

1,60,000

1,30,000

 

3,00,000

2,40,000

Additional Information :
(i) During the year, Machinery costing ₹ 1,40,000 (accumulated depreciation provided thereon ₹ 1,10,000) was sold for ₹ 20,000.
(ii) During the year, Non-current Investments costing ₹ 80,000 were sold at a profit of ₹ 16,000.

Numerical

Solution

 

Cash Flow Statement 

for the year ended March 31, 2019

 

Particulars

Amount

(₹)

Amount

(₹)

A

Cash Flow from Operating Activities

 

 

 

Profit as per Statement of Profit and Loss

1,40,000

 

 

General Reserve

60,000

 

 

Profit Before Taxation

 

2,00,000

 

Items to be Added:

 

 

 

Depreciation

1,60,000

 

 

Debentures Interest

20,000

 

 

Loss on Sale of Fixed Assets

10,000

 

 

Items to be Deducted:

 

 

 

Profit on sale of Investment

(16,000)

1,74,000

 

Operating Profit before Working Capital Adjustments

 

3,74,000

 

Less: Decrease in Current Liabilities

 

 

 

       Trade Payables

(30,000)

 

 

Add: Decrease in Current Assets

 

 

 

      Trade Receivables

2,20,000

1,90,000

 

Cash Generated from Operations

 

5,64,000

 

Less: Tax Paid

 

-

 

Net Cash Flows from Operating Activities

 

5,64,000

 

 

 

 

 

B

Cash Flow from Investing Activities

 

 

 

 

Sale of Fixed Assets

20,000

 

 

 

Sale of Non-Current Investment

96,000

 

 

 

Purchase of Non-Current Investment

(1,50,000)

 

 

 

Purchase of Fixed Assets

(8,80,000)

 

 

Net Cash Used in Investing Activities

 

(9,14,000)

 

 

 

 

C

Cash Flow from Financing Activities

 

 

 

 Proceeds from Issue of Share Capital

     4,00,000

 

 

Proceeds from Issue of issue of Debentures

1,20,000

 

 

Security Premium Reserve

20,000

 

 

Repayment of Bank Loan

(30,000)

 

 

Interest Paid

(20,000)

 

 

Net Cash Flow from Financing Activities

 

4,90,000

 

 

 

 

 

D

Net Increase Decrease in Cash and Cash Equivalents

 

1,40,000

 

 

Add: Cash and Cash Equivalent in the beginning of the period (1,10,000+1,30,000+80,000)

 

3,20,000

 

Cash and Cash Equivalents at the end of the period (1,40,000+1,60,000+1,60,000)

 

4,60,000

Working Notes:
WN1:

Fixed Assets Account

Dr.

Cr.

Particulars

Amount

(₹)

Particulars

Amount

(₹)

Balance b/d

14,00,000

Bank A/c (Sale)

20,000

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

8,80,000

Accumulated Depreciation

1,10,000

 

 

Profit and Loss A/c (Loss on Sale)

10,000

 

 

Balance c/d

21,40,000

 

22,80,000

 

22,80,000

WN2:

Accumulated Depreciation Account

Dr.

Cr.

Particulars

Amount

(₹)

Particulars

Amount

(₹)

Fixed Assets A/c

1,10,000

Balance b/d

1,90,000

Balance c/d

2,40,000

Profit and Loss A/c (Dep. charged during the year- Bal. Fig.)

1,60,000

 

3,50,000

 

3,50,000

WN3:

Non-Current Investment Account

Dr.

Cr.

Particulars

Amount

(₹)

Particulars

Amount

(₹)

Balance b/d

2,00,000

Bank A/c (Sale) (80,000+16,000)

96,000

Profit and Loss A/c (Profit on Sale)

16,000

Balance c/d

2,70,000

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

1,50,000

 

 

 

3,66,000

 

3,66,000

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

APPEARS IN

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

RELATED QUESTIONS

From the following Balance Sheet of Computer India Ltd., prepare cash flow statement.

                                                                          (Rs in '000)
Particulars Note No. 31st March
2017
(Rs)
31st
March
2016
(Rs)
I) Equity and Liabilities      
1. Shareholders’ Funds
     
a) Share capital
  50,000 40,000
b) Reserves and surplus-Surplus
1 3,700 3,000
2. Non-Current Liabilities
     
10% Debentures
  6,500 6,000
3. Current Liabilities
     
a) Short-term borrowings
2 6,800 12,500
b) Trade payables
  11,000 12,000
c) Short-term provisions
3 10,000 8,000
Total   88,000 81,500
II) Assets      
1. Non-current assets
     
a) Fixed assets
4 25,000 30,000
2. Current assets
     
a) Inventories
  35,000 30,000
b) Trade receivables
  24,000 20,000
c) Cash and cash equivalents-cash
  3,500 1,200
d) Other current assets-prepaid exp.
  500 300
Total    88,000 81,500

Notes to Accounts

Particulars

31st March

2017

(Rs)

31st
March

2016

(Rs)

 

1.

Reserve and surplus    

 

(i) Balance in statement of profit and loss

1,200

1,000

 

(ii) General reserve

2,500

2,000

 

 

3,700

3,000

2.

Short-term borrowings    

 

Bank Overdraft

6,800

12,500

3.

Short-term provisions    

 

(i) Provision for taxation

4,200

3,000

 

(ii) Proposed dividend

5,800

5,000

 

 

10,000

8,000

4.

Fixed Assets:    

 

  Fixed Assets

40,000

41,000

 

  Less: Accumulated Depreciation

(15,000)

(11,000)

 

 

25,000

30,000

Additional Information:

Interest paid on Debenture Rs. 600


Welprint Ltd. has given the following information:
Machinery as on 1st April, 2018 50,000
Machinery as on 31st March, 2019 60,000
Accumulated Depreciation on 1st April, 2018 25,000
Accumulated Depreciation on 31st march, 2019 15,000

During the year, a machine costing ₹ 25,000 (accumulated depreciation thereon ₹ 15,000) was sold for ₹ 13,000. Calculate Cash Flow from Investing Activities on the basis of the above information.


From the following Balance Sheet of Combiplast Ltd. for the year ended 31st March, 2019 and additional information, calculate Cash Flow from Investing Activities:

Particulars

Note No.

31st March, 2019

(₹)

31st March, 2018

(₹)

I. EQUITY AND LIABILITIES

     

1. Shareholders' Funds

 

   

(a) Share Capital

  7,50,000 5,00,000

(b) Reserves and Surplus

  10,00,000 8,50,000

2. Current Liabilities

 

4,50,000 3,50,000

Total

  22,00,000 17,00,000
II. ASSETS      

1. Non-Current Assets

     

(a) Fixed Assets−Tangible Assets

1 12,00,000 12,00,000

(b) Non-Current Investments

  5,00,000 3,00,000

2. Current Assets

     

(a) Trade Receivables

  3,00,000 1,10,000

(b) Cash and Cash Equivalents

  2,00,000 90,000

Total

  22,00,000 17,00,000

Notes to Accounts

Particulars

31st March, 2019

(₹)

31st March, 2018

(₹)

I. Tangible Assets    

Land

3,00,000 3,00,000

Building

4,00,000 4,00,000

Plant and Machinery

5,00,000 5,00,000

 

12,00,000 12,00,000

Additional Information:During the year the company sold machinery at Book Value of ₹ 1,50,000.


From the following information, calculate Net Cash Flow from Operating Activities and Financing Activities:

Particulars

31st March 2019 (Rs.)

31st March 2019 (Rs.)
Equity Share Capital

13,75,000

11,25,000
5% Preference Share Capital 5,00,000 7,50,000
General Reserve 3,75,000 3,00,000
Surplus i.e., Balance in Statement of Profit and Loss 3,75,000 (3,50,000)
Securities Premium Reserve 25,000 ...
Provision for Tax 1,00,000 50,000
Non-current Liabilities (8% Debentures) 6,50,000 3,75,000
Short-term Borrowings (8% Bank Loan) 1,00,000 1,25,000
Trade Payables 5,00,000 2,50,000
Trade Receivables and Inventories

13,00,000

11,50,000

Additional Information:

  1. During the year additional debentures were issued at par on 1st October and Bank Loan was repaid on the same date.
  2. Dividend on Equity Shares @ 8% was paid on Opening Balance.
  3. Income tax ₹ 1,12,500 has been provided during the year.
  4. Preference shares were redeemed at par at the end of the year.

From the following information, prepare Cash Flow Statement:

Particulars

(₹)

Opening Cash and Bank Balances

1,50,000

Closing Cash and Bank Balances 1,70,000
Decrease in Stock 80,000
Increase in Bills Payable 1,20,000
Sale of Fixed Assets 3,00,000
Repayment of Long-term Loan 5,00,000
Net Profit for the Year

20,000


From the following Balance Sheet of Young India Ltd., prepare Cash Flow Statement:
 BALANCE SHEET OF YOUNG INDIA LTD.as at 31st March, 2019

Particular

Note No.

31st March, 2019 (₹)

31st March, 2018 (₹)

I. EQUITY AND LIABILITIES      

1. Shareholders' Funds

     

(a) Share Capital

 

2,50,000

2,00,000

(b) Reserves and Surplus: Surplus, i.e., Balance in Statement of Profit and Loss

 

1,83,000

82,000

2. Non-Current Liabilities

 

   

Long-term Borrowings:

 

   

15% Debentures

 

80,000

50,000

3. Current Liabilities

 

   

(a) Trade Payables

 

1,50,000

1,10,000

(b) Other Current Liabilities

 

12,000

20,000

Total

 

6,75,000

4,62,000

II. ASSETS      

1. Non-Current Assets

     

(a) Fixed Assets (Tangible)

 

2,74,000

1,17,000

(b) Non-Current Investments

 

68,000

55,000

2. Current Assets

 

   

(a) Inventories

 

2,06,000

1,50,000

(b) Trade Receivables

 

32,000

70,000

(c) Cash and Cash Equivalents

 

95,000

70,000

Total

 

6,75,000

4,62,000


Following is the Balance Sheet of Mevanca Limited as at 31st March, 2017:
Mevanca Limited BALANCE SHEET as at 31st March, 2017:

Particulars

Note No.

31st March, 2017

(₹)

31st March, 2016

(₹)

I. EQUITY AND LIABILITIES

     

1. Shareholders' Funds

     

(a) Share Capital

 

3,00,000

1,00,000

(b) Reserves and Surplus

1

25,000

1,20,000

2. Non-Current Liabilities

     

Long-term Borrowings

2

80,000

60,000

3. Current Liabilities

     

(a) Trade Payables

 

6,000

20,000

(b) Short-term Provisions

3

68,000

70,000

Total

 

4,79,000

3,70,000

II. ASSETS

     

1. Non-Current Assets

     

Fixed Assets

4

3,36,000

1,92,000

2. Current Assets

     

(a) Inventories

 

67,000

60,000

(b) Trade Receivables

 

51,000

65,000

(c) Cash and Cash Equivalents

 

25,000

49,000

(d) Other Current Assets

 

4,000

Total

 

4,79,000

3,70,000

 Notes to Accounts

Particulars

31st March, 2017

(₹)

31st March, 2016

(₹)

1. Reserves and Surplus

   

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

25,000

1,20,000

 

25,000

1,20,000

2. Long-term Borrowings

   

10% Long-term Loan

80,000

60,000

 

80,000

60,000

3. Short-term Provisions

   

Provision for Tax

68,000

70,000

 

68,000

70,000

4. Fixed Assets

   

Machinery

3,84,000

2,15,000

Accumulated Depreciation

(48,000)

(23,000)

 

3,36,000

1,92,000

Additional Information :
(i) Additional loan was taken on 1st July, 2016.
(ii) Tax of ₹ 53,000 was paid during the year.
Prepare Cash Flow Statement.


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.


The Balance Sheet of Virendra Paper Ltd. as at 31st March, 2019 is given below:

Particulars

Note No.

31st March, 2019

(₹)

31st March, 2018

(₹)

I. EQUITY AND LIABILITIES      

1. Shareholders' Funds

     

  (a) Share Capital

  7,20,000 6,00,000

  (b) Reserves and Surplus:

     

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

  4,80,000 3,75,000

2. Non-Current Liabilities

     

Long-term Borrowings:

     

   10% Debentures

  2,70,000 4,50,000

3. Current Liabilities

     

  Trade Payables

  1,20,000 90,000

Total

  15,90,000 15,15,000
II. ASSETS      

1. Non-Current Assets

     

  Fixed Assets (Tangible)

1 7,50,000 7,20,000

2. Current Assets

     

(a) Inventories

  3,60,000 4,20,000

(b) Trade Receivables

  3,00,000 2,25,000

(c) Cash and Cash Equivalents

  1,80,000 1,50,000

Total

  15,90,000 15,15,000

Notes to Accounts

Particulars

31st March, 2019

(₹)

31st March, 2018

(₹)

1. Fixed Assets (Tangible)

 

 

   

Land

 

 

2,40,000

3,00,000

 

31st March,

31st March,

   
 

2019 (₹)

2018 (₹)

   

Plant and Machinery

7,50,000

6,00,000

   

Less:Accumulated Depreciation

2,40,000

1,80,000

   
 

5,10,000

4,20,000

5,10,000

4,20,000

 

 

 

7,50,000

7,20,000

Additional Information:
1. Interim Dividend of ₹75,000 has been paid during the year.
2. Debenture Interest paid during the year ₹ 27,000.
You are required to 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.


Prepare Cash Flow Statement from the following Balance Sheet:

Particulars

Note No.

31st March, 2013

(₹)

31st March, 2012

(₹)

I. EQUITY AND LIABILITIES      

1. Shareholders' Funds

     

(a) Share Capital

  6,00,000 5,00,000

(b) Reserves and Surplus

1 4,00,000 2,00,000

2. Current Liabilities

     

(a) Trade Payables

  2,80,000 1,80,000

Total

  12,80,000 8,80,000
II. ASSETS      

1, Non-Current Assets

     

(a) Fixed Assets:

     

Plant and Machinery

  5,00,000 3,00,000

2. Current Assets

     

(a) Inventories

  1,00,000 1,50,000

(b) Trade Receivables

  6,00,000 4,00,000

(c) Cash and Cash Equivalents

  80,000 30,000

Total

  12,80,000 8,80,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 2,00,000

Additional Information:
(i) An old machinery having book value of ₹50,000 was sold for ₹60,000.
(ii) Depreciation provided on Machinery during the year was ₹30,000.


From the following Balance Sheet of Kiero Ltd. and the additional information as on 31-3-2018, prepare a Cash Flow Statement:

Kiero Ltd.
Balance Sheet as at 31-03-2018

Particulars Note No.

31-03-18 (₹)

31-03-17 (₹)

I. Equity and Liabilities      
1. Shareholders Funds
     
(a) Share Capital
1 7,90,000 5,80,000
(b) Reserves and Surplus   4,60,000 1,20,000
       
2. Non-Current Liabilities      
Long term Borrowings 2 5,00,000 3,00,000
       
3.Current Liabilities      
(a) Short term borrowings 3 1,15,000 42,000
(b) Short term Provisions 4 1,18,000 46,000
Total   19,83,000 10,88,000
       
II. Assets
     
1. Non-Current Assets
     
Fixed Assets
     
(i) Tangible Assets 5 9,80,000 6,35,000
(ii) Intangible Assets 6 2,68,000 1,70,000
2. Current Assets      
(a) Current Investments
  1,40,000 70,000
(b) Trade Receivables   4,40,000 1,50,000
(c) Cash and Cash Equivalents   1,55,000 63,000

Total

  19,83,000 10,88,000

Notes to Accounts

Note No. Particulars 31-03-18 (₹) 31-03-17 (₹)
1. Reserves and Surplus    
  Surplus (Balance in Statement of Profit and Loss) 3,20,000 60,000
  General Reserve 1,40,000 60,000
    4,60,000 1,20,000
       
2. Long-term Borrowings    
  12% Debentures 5,00,000 3,00,000
    5,00,000 3,00,000
       
3. Short-term Borrowings    
  Bank Overdraft 1,15,000 42,000
    1,15,000 42,000
       
4. Short-term Provisions    
  Provision for Tax 1,18,000 46,000
    1,18,000 46,000
       
5. Tangible Assets    
  Plant and Machinery 11,00,000 7,50,000
  Less:Accumulated Depreciation (1,20,000) (1,15,000)
    9,80,000 6,35,000
       
6. Intangible Assets    
  Goodwill 2,68,000 1,70,000
    2,68,000 1,70,000

Additional Information: 12% debentures were issued on 1st September, 2017.


Cash flow example from a financing activity is:


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


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:


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×