Skip to content
Question
Q.

From the following Balance Sheet of DCX Ltd. and the additional information as at 31st March, 2018 prepare a Cash Flow Statement :

DCX Ltd. Balance Sheet as at 31st March, 2018

ParticularsNote No.31.3.2018 ₹31.3.2017 ₹
I – Equity and Liabilities :
1. Shareholder's Funds :
(a) Share Capital30,00,00021,00,000
(b) Reserves and Surplus14,00,0005,00,000
2. Non-Current Liabilities :
Long-term Borrowings28,00,0005,00,000
3. Current Liabilities :
(a) Trade Payables1,50,0001,00,000
(b) Short-term Provisions376,00056,000
Total44,26,00032,56,000
II – Assets :
1. Non-Current Assets :
Fixed Assets :
(i) Tangible Assets427,00,00020,00,000
(ii) Intangible Assets8,00,0007,00,000
2. Current Assets :
(a) Current Investments89,00078,000
(b) Inventories8,00,0004,00,000
(c) Cash and cash equivalents37,00078,000
Total44,26,00032,56,000

Notes to Accounts :

Note No.Particulars31.3.2018 ₹31.3.2017 ₹
1Reserves and Surplus : (Surplus i.e. Balance in the Statement of Profit and Loss)4,00,0005,00,000
4,00,0005,00,000
2Long-term Borrowings : 8% Debentures8,00,0005,00,000
8,00,0005,00,000
3Short-term Provisions : Provision for Tax76,00056,000
76,00056,000
4Tangible Asset : Machinery33,00,00025,00,000
Less : Accumulated Depreciation(6,00,000)(5,00,000)
27,00,00020,00,000

Additional Information : (i) During the year a machinery costing ₹ 8,00,000 on which accumulated depreciation was ₹ 3,20,000 was sold for ₹ 6,40,000. (ii) Debentures were issued on 1st April, 2017.

CBSECBSE Class XII Board 2019Subjective· 6mImportance★★★★★
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

Net Cash used in Operating Activities = (Rs 1,06,000), Net Cash used in Investing Activities = (Rs 10,71,000), Net Cash from Financing Activities = Rs 11,36,000 - a net decrease in Cash & Cash Equivalents of Rs 41,000 (Rs 78,000 to Rs 37,000).

Working Notes

WN 1 - Net Profit before Tax

ParticularsRs
Decrease in Surplus (P&L): 4,00,000 - 5,00,000(1,00,000)
Add: Provision for Tax made during the year76,000
Net Profit before Tax(24,000)

WN 2 - Provision for Tax (opening Rs 56,000 = tax paid; closing Rs 76,000 = provision made): Tax paid = Rs 56,000.

WN 3 - Depreciation charged during the year

=Closing Acc. Dep.+Dep. on asset sold−Opening Acc. Dep.=6,00,000+3,20,000−5,00,000=4,20,000= \text{Closing Acc. Dep.} + \text{Dep. on asset sold} - \text{Opening Acc. Dep.} = 6{,}00{,}000 + 3{,}20{,}000 - 5{,}00{,}000 = 4{,}20{,}000

WN 4 - Profit on Sale of Machinery: book value =8,00,000−3,20,000=4,80,000= 8{,}00{,}000 - 3{,}20{,}000 = 4{,}80{,}000; sold for 6,40,0006{,}40{,}000, so Profit = Rs 1,60,000.

WN 5 - Machinery purchased

=Closing cost+Cost of asset sold−Opening cost=33,00,000+8,00,000−25,00,000=16,00,000= \text{Closing cost} + \text{Cost of asset sold} - \text{Opening cost} = 33{,}00{,}000 + 8{,}00{,}000 - 25{,}00{,}000 = 16{,}00{,}000

WN 6 - Interest on 8% Debentures (Rs 3,00,000 issued on 1.4.2017, so Rs 8,00,000 outstanding all year): 8%×8,00,000=8\% \times 8{,}00{,}000 = Rs 64,000.

Cash Flow Statement of DCX Ltd. for the year ended 31st March, 2018

A. Operating Activities

ParticularsRsRs
Net Profit before Tax (WN 1)(24,000)
Add: Depreciation (WN 3)4,20,000
Add: Interest on Debentures (WN 6)64,000
Less: Profit on Sale of Machinery (WN 4)(1,60,000)
Operating Profit before Working Capital changes3,00,000
Add: Increase in Trade Payables50,000
Less: Increase in Inventories(4,00,000)
Cash generated from Operations(50,000)
Less: Tax paid (WN 2)(56,000)
Net Cash used in Operating Activities(1,06,000)

B. Investing Activities

ParticularsRsRs
Purchase of Machinery (WN 5)(16,00,000)
Sale of Machinery6,40,000
Purchase of Intangible Assets (8,00,000 - 7,00,000)(1,00,000)
Purchase of Current Investments (89,000 - 78,000)(11,000)

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.