Module 6 : Cash Flow
Lecture 3 : Cases on preparation and Interpretation of Cash Flow Statement
Objectives
In this lecture you will learn the following
Cash Flow format.
Cash Flow Problems.
Proforma and Problems
Cash Generated from Operations
Retained Earning XX
Dividend XX
Net Profit After Tax XX
Add: Provision for Tax XX
Net Profit Before Tax XX
Add: Non-cash Expenses
Depreciation XX
Amortisation (Goodwill w/o) XX
Adjust: Non-operating items XX
Loss on sale of Asset/Investment XX
Interest expenses XX
Interest/ Dividend Income (XX)
Profit on sale of Asset/ Investment (XX)
Funds from Operations XX
Adjust: Working Capital Items XX
Decrease in Current Asset XX
Increase in Current Liabilities XX
Increase in Current Asset (XX)
Decrease in Current Liabilities (XX)
Cash generated from operation XX
Income Tax Paid (XX)
Cash flows from operating activities XX
Cash Flow from Investing Activities
Purchase of Assets / Investment (XX)
Sale of Assets / Investment XX
Interest / Dividend received XX
Investment in joint venture (XX)
Cash flows from investing activities XX
Cash Flow from Financing Activities
Issue of shares/ debentures for cash XX
Redemption of Preference shares/ debentures (XX)
Interest / Dividend paid (XX)
Proceeds from borrowings XX
Repayment of loan (XX)
Cash flows from financing activities XX
Cash Flow Statement
1. Cash Flow from Operating Activities XX
2. Cash Flow from Investing Activities XX
3. Cash Flow from Financing Activities XX
Net Increase / decrease in cash (1+2+3) XX
Cash & Cash Equivalents at the beginning XX
Cash & Cash Equivalents at the end XX
Cash & Cash Equivalents at Beginning at End
Cash XX XX
Bank XX XX
Short Term Investment XX XX
Total XX XX
Exercise 1.
Prepare cash flow statement from the following details of the Narendra Ltd.
Profit and Loss A/c for the year ending 31 March 2010 is as follows
Sales 200000
Interest 15000
Total Income 215000
Purchase 70000
Wages 28000
Interest 14000
Depreciation 9000
Office Exp 30000
Goodwill written off 11000
Tax 37000
Dividend 3000
Net profit 13000
Balance Sheet of the Narendra Ltd
2009 2010
Liabilities
Share Capital 160000 190000
General Reserve 50000 50000
Profit and Loss A/c 9000 22000
Debentures 80000 51000
Creditors 20000 40000
Proposed Dividend 2000 3000
321000 356000
2009 2010
Assets
Land 75000 75000
Fixed Assets 140000 131000
Investment 59000 111000
Sundry Debtors 12000 17000
Bank 5000 3000
Goodwill 30000 19000
321000 356000
Cash Flow statement
Retained earnings 13000
Dividend 3000
Profit as per Profit & loss A/c 16000
Depreciation 9000
Goodwill written off 11000
Interest Expenses 14000
Income Tax 37000
Interest Income (15000)
Funds from operations 72000
Add: Increase in creditors 20000
Less: Increase in Debtors (5000)
Cash generated from operation 87000
Income Tax Paid (37000)
Net Cash flow from operating activities 50000
Cash Flow from Investing Activities
Purchase of Investment (52000)
Interest Income 15000
Net cash flows from investing activities (37000)
Cash Flow from Financing Activities
Issue of shares 30000
Dividend (2000)
Redemption of Debentures (29000)
Interest paid (14000)
Net cash flows from Financing activities (15000)
Net decrease in cash (2000)
Cash and Cash Equivalents at the beginning 5000
Cash and Cash Equivalents at the end 3000
Cash & Cash Equivalents at Beginning at End
Bank 5000 3000
Total 5000 3000
Exercise 2.
Prepare cash flow statement from the following details of the Keshav Ltd.
Profit and Loss A/c for the year ending 31 March 2010 is as follows
Sales 90000
Profit on sale of investment (Sale Value: Rs.
2000
4000)
Closing Stock 6000
Total Income 98000
Purchase 40000
Manufacturing Expenses 17000
Wages 1400
Depreciation 5000
General Exp 8000
Discount on issue of debenture 3000
Tax 6000
General Reserve 5000
Net profit 12600
Balance Sheet of the Keshav Ltd
2009 2010
Liabilities
Share Capital 50000 50000
General Reserve 10000 15000
Profit and Loss A/c 8000 20600
Debentures 10000 27000
Creditors 16000 10000
Provision for Tax 7000 12000
101000 134600
2009 2010
Assets
Fixed Assets 40000 40000
Machinery 21000 55600
Investment 5000 3000
Sundry Debtors 15000 14300
Bank 5000 6700
Goodwill 15000 15000
101000 134600
Cash Flow statement
Retained earnings 12600
Transfer General Reserve 5000
Net Profit as per Profit and Loss A/c 17600
Depreciation 5000
Discount on issue of Debentures 3000
Income Tax 6000
Profit on sale of investment (2000)
Funds From operation 29600
Decrease in Sundry Debtors 700
Increase in Bills Payable 5000
Increase in Sundry Creditors (6000)
Cash generated from operation 29300
Income Tax Paid (6000)
Net cash flows from operating activities 23300
Cash Flow from Investing Activities
Sale of Investment 4000
Purchases of Machinery (39600)
Net cash flows from investing activities (35600)
Cash Flow from Financing Activities
Issue of Debentures 14000
Net increase in cash 1700
Cash & Cash Equivalents at the beginning 5000
Cash & Cash Equivalents at the end 6700
Cash Flow statement
Cash & Cash Equivalents at Beginning at End
Bank 5000 6700
Total 5000 6700
Machinery A/c
Balance B/d 21000 Depreciation 5000
Cash/Bank A/c (purchases) 39600 Balance C/d 55600
60600 60600
