1-Cash Flow Statement
1-Cash Flow Statement
Definitions
Cash
It means cash on hand and Demand Draft (bank balance/bank O/D also)
Cash Equivalents
These are short term, highly liquid investments that are readily convertible to known amount of
cash and which are subject to an insignificant risk of changes in value.
Cash Flows
These are inflows and outflows of cash by operating, investing, and financing activities.
An enterprise should report cash flows from operating activities using either;
I. Direct Method
Whereby major classes of gross (actual) cash receipts and gross (actual) cash payments are
disclosed: or
II. Indirect Method
Whereby net profit or loss is adjusted for the effects of transactions of a non-cash nature, any
deferrals or accruals of past or future operating cash receipts or payments, and items of income
or expense associated with investing or financing cash flows.
Enterprises are encouraged to report cash flows from operating activities using the direct method.
Operating Activities
Account heads which are used to prepare income statement will go to Operating Activities.
Investing Activities
Cash receipt from selling of investment or Cash payment to acquire investment or plant
plant assets assets
cash receipts from collecting principal amount Cash payment made as an advance to
of loan borrowers
Financing Activities
Cash receipts from both short term and long Repayment of amount borrowed(excluding
term borrowings interest payment)
Cash received from owners like stock or bond Cash payment to owners like dividend
issue
Cash flow statement is the Reconciliation of Net Profit to the Net Cash Flows.
Cash Flow Statement
For the Period Ended December 20XX
Using Direct Method
INSTRUCTIONS Prepare a statement of cash flows using direct method of reporting cash
flows from operating activities.
Many of the items above will be listed in your statement without change. However, you will
have to combine certain given information to compute the amounts of (1) collections from
customers, (2) cash paid to suppliers and employees, and (3) proceeds from sales of plant assets.
(Hint: Not every item listed above is used in preparing a statement of cash flow.)
Solution
Description Amount Amount
Cash flow from operating activities
Collection from Customers – W1 3,000,000
Interest and dividends received 100,000
Cash provided by operating activities 3100,000
Cash paid to suppliers and employees W2 2,550,000
Interest paid 180,000
Income tax paid 95,000
Cash disbursed from operating activities (2,825,000)
Net cash flow from operating activities 275,000
Cash flow from investing activities
Loans made to borrowers (500,000)
Collections on loans 260,000
Cash paid to acquire plant assets (3,100,000)
Proceeds from sales of plant assets - W3 580,000
Net cash flow from investing activities (2,760,000)
Cash flow from financing activities
Proceeds from issuing bonds payable 2,500,000
Dividend paid (120,000)
Net cash flow from financing activities 2,380,000
Increase (Decrease) in cash during the year (105,000)
Add. Cash and cash equivalent – opening 446,000
Cash and cash equivalent – ending 341,000
Working - 1
Description Amount Amount
Cash sales 800,000
Collection of accounts receivables 2,200,000
Total 3,000,000
Working - 1
Description Amount Amount
Payments on accounts payable to merchandise suppliers 1,500,000
Cash payment for operating expenses 1,050,000
Total 2,550,000
Working 3
Description Amount Amount
Book value of plant asset sold 660,000
Loss on sales of plant assets (80,000)
Proceeds from sale of plant assets 580,000
PROBLEM # 2: The accounting staff of TeleGift Corporation has assembled the following
information for the year ended December 31, 19--.
Cash sales ----------------------------------------------------------------------------------------- $402,000
Credit sales ----------------------------------------------------------------------------------------- 3,420,000
Collections on accounts receivable ------------------------------------------------------------- 3,193,000
Cash transferred from the money market fund to the general bank account -----------------180,000
Interest and dividends received --------------------------------------------------------------------- 40,000
Purchases (all on account) ----------------------------------------------------------------------- 1,950,000
Payments on accounts payable to merchandise suppliers ------------------------------------ 2,036,000
Cash payment for operating expenses ---------------------------------------------------------- -- 822,000
Interest paid -------------------------------------------------------------------------------------------- 99,000
Income tax paid -------------------------------------------------------------------------------------- 180,000
Loans made to borrowers --------------------------------------------------------------------------- 220,000
Collections on loans (excluding receipts of interest) ------------------------------------------- 145,000
Cash paid to acquire plant assets ---------------------------------------------------------------- 1,640,000
Book value of plant assets sold ---------------------------------------------------------------------- 70,000
Loss on sales of plant assets ------------------------------------------------------------------------- 35,000
Proceeds from issuing capital stock ------------------------------------------------------------- 1,355,000
Dividend paid ---------------------------------------------------------------------------------------- 180,000
Cash and cash equivalents, beginning of year --------------------------------------------------- 297,000
Cash and cash equivalents, end of year -----------------------------------------------------------------?---
INSTRUCTIONS Prepare a statement of cash flows using direct method of reporting cash
flows from operating activities.
Many of the items above will be listed in your statement without change. However, you will
have to combine certain given information to compute the amounts of (1) collections from
customers, (2) cash paid to suppliers and employees, and (3) proceeds from sales of plant assets.
(Hint: Not every item listed above is used in preparing a statement of cash flow.)
Solution
Description Amount $ Amount $
Cash flows from Operating Activities
Cash received from customers - 1 3,595,000
Interest and divided received 40,000
Cash provided by Operating Activities 3,635,000
Cash paid to suppliers and employees -2 (2,858,000)
Interest paid (199,000)
Income tax paid (180,000)
Cash disbursed for Operating Activities (3,137,000)
Net cash flows from Operating Activities 498,000
Cash flows from Investing Activities
Loans made to borrowers (220,000)
Collection on loans 145,000
Cash paid to acquire plant assets (1,640,000)
Proceeds from sale of plant assets - 3 35,000
Net cash used by Investing Activities (1,680,000)
Cash flows from Financing Activities
Proceeds from issuing capital stock 1,355,000
Dividend paid (180,000)
Net cash provided by Financing Activities 1,175,000
Net increase (decrease) in cash and cash equivalent (7,000)
Add. Cash and cash equivalent – opening balance 297,000
Cash and cash equivalent – ending balance 290,000
Working - 1
Description Amount $
Cash received from customers
Cash sales 402,000
Collection on accounts receivables 3,193,000
Cash received from customers 3,595,000
Working - 2
Description Amount $
Cash paid to suppliers and employees
Payment on account payable to suppliers 2,036,000
Cash payment for operating expenses 822,000
Cash paid to suppliers and employees 2,858,000
Working - 3
Description Amount $
Proceeds from sales of plant assets
Book value of plant assets sold 70,000
Lain on sales of plant assets 35,000
Proceeds from sale of plant assets 35,000
PROBLEM # 3: The accounting staff of Carolina Crafts, Inc. has assembled the following information for
the year ended December 31, 1994.
Cash and cash equivalents, beginning of year ------------------------------------------------------------------ $45,200
Cash and cash equivalents, end of year --------------------------------------------------------------------------- 64,200
Cash paid to acquire plant assets ----------------------------------------------------------------------------------- 21,000
Proceeds from short term borrowing------------------------------------------------------------------------------ 10,000
Loans made to borrowers ---------------------------------------------------------------------------------------------- 5,000
Collections on loans (excluding receipts of interest) ------------------------------------------------------------ 4,000
Interest and dividends received ------------------------------------------------------------------------------------- 17,000
Cash received from customers -------------------------------------------------------------------------------------795,000
Proceeds from sale of plant assets ----------------------------------------------------------------------------------- 9,000
Dividend paid ------------------------------------------------------------------------------------------------------------ 65,000
Cash paid to suppliers and employees ---------------------------------------------------------------------------635,000
Interest paid ------------------------------------------------------------------------------------------------------------- 19,000
Income tax paid --------------------------------------------------------------------------------------------------------- 71,000
INSTRUCTIONS
Using this information, prepare a formal statement of cash flows. Include a proper heading for the
financial statement, and classify the given information into the categories of operating activities,
investing, and financing activities. Net cash flows from operating activities are determined by the direct
method. Place brackets around the dollar amounts of all cash disbursements
Solution
Description Amount $ Amount $
Cash Flow from Operating Activities
Interest and dividend received 17,000
Cash received from customers 795,000
Cash flow provided by operating activities 812,000
Cash paid to suppliers and employees 635,000
Interest paid 19,000
Income tax paid 71,000
Cash flow disbursed by operating activities (725,000)
Net cash flow generated by operating activities 87,000
Cash Flow from Investing Activities
Cash paid to acquire plant assets (21,000)
Proceeds from short term borrowing 10,000
Loan made to borrowers (5,000)
Collection on loan 4000
Proceeds from sale of plant assets 9,000
Net cash flow generated by investing activities (3,000)
Cash Flow from Financing Activities
Dividend paid (65,000)
Net cash flow generated by financing activities (65,000)
Net cash increase (decrease) 19,000
Add. Cash and cash equivalent – opening balance 45,200
Cash and cash equivalent – ending balance 64,200
Cash flow statement through Indirect Method
Operating Activities
Net Income
Add:
Depreciation
Decrease in accounts receivable
Decrease in inventories
Decrease in prepaid expenses
Increase in account payable
Increase in accrued expense payable
Increase in deferred income tax payable
Non-operating losses deducted in computing net income
Less:
Increase in accounts receivable
Increase in inventories
Increase in prepaid expenses
Decrease in accounts payable
Decrease in accrued expense payable
Decrease in deferred income tax payable
Non-operating gains included in net income
Net cash provided by (used in) operating activities
PROBLEM # 1: The data below are taken from the income statement and balance sheet of All
Night Pharmacies, Inc.
Dec. 31 Jan. 1
1994 1994
Income statement:
Net income $400,000
Depreciation expense 120,000
Amortization of intangible assets 40,000
Gain on sale of plant assets 80,000
Loss on sale of investments 35,000
Balance sheets:
Accounts receivable $335,000 $380,000
Inventory 503,000 575,000
Prepaid expenses 22,000 10,000
Accounts payables (to merchandise suppliers) 379,000 410,000
Accrued expenses payable 180,000 155,000
Instructions:
Using this information, prepare a partial statement of cash flows for the year ended December
31, 1994, showing the computation of net cash from operating activities by the indirect method.
Additional Information
1. Net income for the year amounted to $250,000.
2. Cash dividend is of $140,000 were declared and paid.
3. Company’s only noncash expense was depreciation which is $60,000.
4. Marketable securities costing to $15,000 were sold for $35,000 cash, resulting in a
$20,000 non-operating gain.
5. The company purchased plant assets for $100,000, making a $30,000 cash down payment
and issuing a $70,000 mortgage note payable for the balance of the purchase price.
Auto Supply Corporation
Statement of Cash Flows through Indirect Method
As on December 31, 2001
Working 1
Purchase of plant assets 100,000
Less. Portion financed through issuance of debt (70,000)
Cash paid to acquire plant assets 30,000
PROBLEM # 4: Preparing the statement of cash flows—indirect method.
Plywood Products Corporation of America accountants have assembled the following data for the year
ended December 31, 19X7
1997 1996
-------- -----------
Current accounts ( all result from operations)
Current assets:
Cash and cash equivalents..............................................................$85,700 $22,700
Accounts recievable......................................................................... 59,700 64,200
Inventories........................................................................................88,600 83,000
Prepaid expenses................................................................................5,300 4,100
Current liabilities:
Notes payable (for inventory purchases)........................................$22,600 $18,300
Accounts payable..............................................................................52,900 55,800
Income tax payable...........................................................................18,600 16,700
Accrued liablities.............................................................................. 25,500 27,200
Transaction data for 19X7:
Acquisition of long term Sale of equipment......................... $58,000
Investment..........................................$ 31,600 Amortization expense................... 5,300
Acquisition of land by issuing long Purchase of treasury stock........... 14,300
term notepayable..............................113,000 Loss sale of equipment.................. 11,700
Stock dividends.....................................31,800 Payment of cash dividends.............18,300
Collection of loan................................... 8,700 Issuance of long term note
Depreciation expense.......................... 26,800 payable to borrow cash…………….....34,400
Acquisition of building........................ 125,300 net income………………………………......67,100
Retirement of bondspayable Issuance of common stock
by issuing common stock.....65,000 for cash............................................41,200
REQUIRED:
Prepare Plywood products' statement of cash flows, using the indirect method to report operating
activities. Include an accompanying schedule of noncash investing and financing activities.
PROBLEM # 5: Prepare the 19X3 statement of cash flows for Robins Corporation, using the indirect
method to report cash flows from operating activities. In a separate schedule, report robins noncash
investing and financing activities.
December 31
_________________________
19X3 19X2
_________________________
Current assets:
Cash and cash equivalents $19,000 $3,000
Accounts receivable 22,000 23,000
Inventories 34,000 31,000
Prepaid expenses 1,000 3,000
Current liabilities:
Notes payable (for inventory purchase) $11,000 $7,000
Accounts payable 24,000 19,000
Accrued liabilities 7,000 9,000
Income tax payable 10,000 10,000
REQUIRED:
Prepare statement of cash flows, using the indirect method to report operating activities. Include an
accompanying schedule of noncash Investing and financing activities.
PROBLEM # 7:
The comparative Balance Sheet of ABC Company for two years is as under;
Assets Dec. 31, 02 Dec. 31, 01
Cash Rs.87500 Rs.105000
Inventory 162500 175000
Prepaid rent 40000 45000
Accounts receivable 175000 160000
Plant assets 440000 415000
905000 900000
Liabilities and shareholder’s equities
Share capital Rs.605000 Rs.570000
Accounts payable 90000 100000
Salaries payable 15000 15000
Unearned Rent 15000 10000
Long term loan 60000 100000
Retained Earnings 120000 105000
905000 900000
Additional data:
Net income for the year 2002 Rs.90000. Cash dividend paid Rs.75000.
Required:
Prepare cash flow statement.
PROBLEM # 8: The balances of accounts of Multan Cement Co. Ltd. at end of 2002 and 2003 are as
follows;
Additional data:
Company reported net loss for the year 2003 Rs.40000.
Required:
Prepare cash flow statement