π Lecture 12 β Financial Statements (Continued)
π Overview: This lecture explains the Cash Flow Statement, a mandatory financial statement for limited companies that shows how cash was generated and used during a period. It emphasizes the critical distinction between profitability and liquidity, detailing why a profitable business can still face cash shortages. The lecture breaks down the three components of the cash flow statementβOperating, Investing, and Financing Activitiesβand provides the complete procedure and format for its preparation.
ποΈ Topics Covered
This lecture begins by explaining the need for a cash flow statement and the crucial difference between profitability and liquidity, defining cash and cash equivalents. It then introduces the three main components of a cash flow statement: Cash Flow from Operating Activities, Cash Flow from Investing Activities, and Cash Flow from Financing Activities, providing examples and calculations for each. The lecture concludes with the step-by-step procedure for preparing a cash flow statement and its standard format, along with a summary of inflows and outflows for each activity.
π Lecture Summary
Need For Cash Flow Statement
For any business, it is important to ensure sufficient profits and sufficient funds are available to meet obligations. Information on profitability comes from the Profit and Loss Account, while the balance sheet provides information on financial health, but only as on a specific date. The cash flow statement provides more detailed information about the movement of funds during the period, showing the amount of cash generated from different sources and where it was utilized.
π‘ Why this matters: A business can be profitable on paper but still fail if it cannot pay its bills when they are due. The cash flow statement bridges this gap.
Difference between Profitability and Liquidity
Liquidity is the ability of a business to pay its debts in time, meaning it has sufficient liquid funds (cash and cash equivalents) to repay liabilities. Cash includes cash in hand and demand deposits. Cash Equivalents are short-term investments that can be converted into a known amount of cash at any time, usually those with a maturity of up to three months.
People often confuse profitability with liquidity. A business earning a large profit might not have the same amount of cash.
- Example: A person starts a business with Rs. 10,000 cash.
- Purchases goods for Rs. 20,000, paying Rs. 10,000 in cash and owing Rs. 10,000 (payable at month-end).
- All goods are sold on credit for Rs. 30,000 (due in two months).
- The Profit and Loss account shows a profit of Rs. 10,000.
- However, at month-end, it must pay creditors Rs. 10,000, but it has no cash and cannot collect from debtors yet.
- This shows liquidity is different from profitability, but equally important.
π Definition β Liquidity: The ability of a business to pay its debts in time.
Components of Cash Flow Statement
The cash flow statement is divided into three components:
- Cash Flow from Operating Activities
- Cash Flow from Investing Activities
- Cash Flow from Financing Activities
Cash Flow From Operating Activities
This is derived from the principal revenue-producing activities of the business. It is an indicator of success or failure. If continuously negative, the business's revenue is not covering its costs; in the long run, it must be positive.
Examples of cash flows from operating activities:
- Cash receipts from sale of goods and rendering of services.
- Cash receipts from fees, commission, and other revenues.
- Cash payments to suppliers for goods and services.
- Cash payments to and on behalf of employees.
- Cash payments or refunds of income taxes.
EXAMPLE Calculation:
| Item | Amount (Rs.) |
|---|---|
| Net Profit before Tax | 16,514 |
| Add: Adjustment for Non-Cash Items | |
| Depreciation for the Year | 5,500 |
| Provision for Doubtful Debts | 810 |
| Exchange Gain / Loss | - |
| Gain / Loss on Disposal of Assets | - |
| Return on Investments | 4,000 |
| Mark-up on Loans | 3,500 |
| Operating Profit Before Working Capital Changes | 30,324 |
| Working Capital Changes | |
| Add: Decrease in Current Assets | 40,000 |
| Less: Increase in Current Assets | (50,000) |
| Add: Increase in Current Liabilities | - |
| Less: Decrease in Current Liabilities | - |
| Cash Generated From Operations | 20,324 |
| Less: Markup paid on loans | (3,000) |
| Less: Taxes Paid | (5,000) |
| Net Cash Flow from Operating Activities | 12,324 |
Cash Flow From Investing Activities
This includes cash receipts and payments arising from Fixed and Long Term assets. It shows the investment trend of the business. A negative (outflow) figure means the company is investing in long-term assets and expanding. A positive (inflow) figure over the years means the company is selling its long-term investments.
Examples:
- Cash payments to acquire property, plant, and equipment (including self-constructed assets).
- Cash receipts from sale of property, plant, and equipment.
- Cash payments and receipts from acquisition and disposal of long-term assets like shares, debentures, TFC, and long-term loans.
π Note: If assets are held for trading purposes (e.g., car dealers, bank loans), these cash flows are included in Operating Cash Flow.
EXAMPLE Calculation:
| Item | Amount (Rs.) |
|---|---|
| Add: Disposal of Fixed Asset and Long Term Investments | 100,000 |
| Less: Acquisition of Fixed Assets and Long Term Investments | (80,000) |
| Add: Dividend Received / Returns on Investment Received | - |
| Net Cash Flow from Investing Activities | 20,000 |
Cash Flow From Financing Activities
This includes cash receipts and payments arising from owners and other long-term liabilities of the organization. It shows the behavior of investors (both equity and debt capital). A positive (inflow) figure shows funds are being invested in the company, and vice versa.
Examples:
- Cash received from owners (share issue, capital from sole proprietor/partners).
- Cash payments to owners (dividends, drawings).
- Cash receipts and payments for other long-term loans and borrowings.
EXAMPLE Calculation:
| Item | Amount (Rs.) |
|---|---|
| Add: Shares Issued / Capital Invested | 1,000,000 |
| Less: Dividend Paid / Drawings | (400,000) |
| Add: Increase in Long Term Borrowings | 150,000 |
| Net Cash Flow from Financing Activities | 750,000 |
Procedure Of Preparing Cash Flow
- Start from the Profit / Loss for the period before taxation.
- Make adjustments for non-cash items (e.g., Depreciation, Provisions, items from investing/financing activities) to get Operating Profit before Working Capital Changes.
- Adjust for Working Capital Changes (increase/decrease in current assets and liabilities, excluding Cash and Cash Equivalents) to get Cash Flow from Operations.
- Add/subtract cash flows from Investing and Financing activities.
- This gives the Net Increase / Decrease in Cash and Cash Equivalents.
- Add the Opening Balance of Cash and Cash Equivalents to get the Closing Balance.
Form of Cash Flow Statement
| Name of the Entity | |
|---|---|
| Cash Flow Statement for the Period Ending ----- | |
| Net Profit before Tax | XYZ |
| Add: Adjustment for Non-Cash Items | |
| Depreciation for the Year | XYZ |
| Provision for Doubtful Debts | XYZ |
| Exchange Gain / Loss | XYZ |
| Gain / Loss on Disposal of Assets | XYZ |
| Return on Investments | XYZ |
| Mark-up on Loans | XYZ |
| Operating Profit Before Working Capital Changes | XYZ |
| Working Capital Changes | |
| Add: Decrease in Current Assets | XYZ |
| Less: Increase in Current Assets | (XYZ) |
| Add: Increase in Current Liabilities | XYZ |
| Less: Decrease in Current Liabilities | (XYZ) |
| Cash Generated From Operations | XYZ |
| Less: Markup paid on loans | (XYZ) |
| Less: Taxes Paid | (XYZ) |
| Net Cash Flow from Operating Activities | XYZ |
| Cash Flow from Investing Activities | |
| Add: Disposal of Fixed Asset and Long Term Investments | XYZ |
| Less: Acquisition of Fixed Assets and Long Term Investments | (XYZ) |
| Add: Dividend Received / Returns on Investment Received | XYZ |
| Net Cash Flow from Investing Activities | XYZ |
| Cash Flow from Financing Activities | |
| Add: Shares Issued / Capital Invested | XYZ |
| Less: Dividend Paid / Drawings | (XYZ) |
| Add: Increase in Long Term Borrowings | XYZ |
| Net Cash Flow from Financing Activities | XYZ |
| Net Increase / Decrease in Cash and Cash Equivalents | XYZ |
| Add: Opening Balance of Cash and Cash Equivalents | XYZ |
| Closing Balance of Cash and Cash Equivalents | XYZ |
IV) Statement of cash flows.
This final financial statement provides net results of cash inflows (receipts) and outflows (payments). Banks, creditors, and investors look for this because positive net income does not necessarily mean an increase in cash. A highly profitable business may still go bankrupt. Profitability does not necessarily mean solvency (ability to pay debts).
- Operating Activities: Include producing/delivering goods and providing services. Cash inflows are from sales and interest/dividends received. Outflows are for purchases and operating expenses. Generating positive cash from operations is the preferred method to finance capital expenditures.
- Investing Activities: Include acquiring/disposing of securities and plant assets, and lending money. Inflows are from sales of securities/assets and collection of loans. Outflows are for purchases of securities/assets and making loans.
- Financing Activities: Include borrowing/repaying creditors and obtaining resources from owners. Inflows are from borrowings, issuing bonds, and issuing capital stock. Outflows are for settling debts and paying dividends.
- The sum of the net cash flows from all three activities gives the overall cash flow.
Analysis of the cash flow statement determines a firm's ability to generate cash from operations, its capacity to meet cash obligations, its future financing needs, its success in investing, and the causes of positive or negative operating cash flow.
β Key Takeaways
The single most important concept from this lecture is the fundamental difference between profitability and liquidity: a profitable business can still run out of cash. You must memorize the three components of the cash flow statement (Operating, Investing, Financing) and the specific examples of inflows and outflows for each. Crucially, you must know how to prepare a cash flow statement starting from Net Profit before Tax, by adding back non-cash items like Depreciation and Provisions, then adjusting for working capital changes. Finally, remember that interest and dividends received/paid are classified as Operating Activities according to this lecture, and that negative cash flow from investing activities typically signals business expansion while a negative operating cash flow is a warning sign of failure.
π§ Quick Revision Questions
- What is the primary reason a business can be highly profitable but still go bankrupt?
- List the three main components of a Cash Flow Statement.
- In the procedure for preparing a cash flow statement, what is the first major adjustment made to "Net Profit before Tax"?
- If a company is selling its property and equipment over several years, what does this likely indicate about its cash flow from investing activities (positive or negative) and its business strategy?
- According to the lecture, are interest paid and interest received classified as Operating, Investing, or Financing activities?
π Lecture 13 β Statements of Cash Flows (Continued)
π Overview: This lecture continues the preparation of the statement of cash flows, explaining how to convert accrual-based accounting data into cash-based figures. It covers the process of analyzing the income statement and balance sheet to identify cash inflows and outflows, and reinforces these concepts with a practical example.
ποΈ Topics Covered
The lecture covers the general process of preparing cash flows, including converting accrual accounts to cash-based. It explains how to analyze the income statement by rearranging items into sales/other income and costs/expenses. It also details analyzing the balance sheet by tracking changes in all non-cash accounts and assigning them to the appropriate cash flow activity (operating, investing, or financing). A practical exercise using the Moosa Corporationβs income statement is then presented.
π Lecture Summary
Preparing Cash Flows
Ledgers are maintained on an accrual basis, not a cash basis. Preparing a cash flow statement involves converting accrual-based accounts into cash-based figures. In small businesses, the cash flow statement is prepared directly from the special journals for cash receipts and cash payments. For most businesses, however, the statement is prepared by analyzing the income statement and balance sheet.
Analyzing the Income Statement
Analyzing the income statement involves re-arranging its accounts into two major groups: (i) Sales, other income and gains, and (ii) Cost of sales, other expenses and losses. These cover Operating and Investing Activities.
Analyzing the Balance Sheet
Analyzing the balance sheet involves looking at changes in all of the balance sheet accounts (except cash) from the beginning to the end of the accounting period, and transferring these changes to the appropriate area of the cash flow statement.
The following rules apply to balance sheet accounts:
- An increase in an Asset account is a Dr., while a decrease is a Cr.
- An increase in a Liability account is a Cr., while a decrease is a Dr.
- An increase in an Ownerβs Equity account is a Cr., while a decrease is a Dr.
The arrow β shows increases, and β shows decreases. It must be determined whether an increase or decrease (debited or credited in ledger accounts) involves a cash inflow or cash outflow. For example, a decrease in an Asset Account (other than cash) shows either collection of Accounts Receivable or sale of fixed assets, which results in Cash Inflow. Similarly, an increase in Assets, say fixed assets, would imply the purchase of fixed assets and hence a cash outflow.
π‘ Why this matters: Understanding how to analyze balance sheet changes is crucial for identifying which transactions generated or used cash, regardless of their accrual accounting treatment.
Practical Exercise: Moosa Corporation
The lecture presents the following income statement of Moosa Corporation for the year ended June 30.
MOOSA CORPORATION INCOME STATEMENT FOR THE YEAR ENDED JUNE 30
| Item | Amount (Rs.) |
|---|---|
| Net sales | 900,000 |
| Cost of Goods sold | 500,000 |
| Gross Profit | 400,000 |
| Operating expenses (Includes depreciation Rs. 40,000) | 300,000 |
| Operating Profit (EBIT) | 100,000 |
| Other expenses | |
| Interest | 35,000 |
| Loss on sale of marketable securities | 4,000 |
| Total other expenses | 39,000 |
| Profit before tax (EBT) | 61,000 |
| Income tax expenses | 36,000 |
| Profit after tax | 25,000 |
| Other Income | |
| Dividend revenue | 3,000 |
| Interest revenue | 6,000 |
| Gain on sale of plant assets | 31,000 |
| Total other income | 40,000 |
| Net Income | 65,000 |
π Definition β Accrual Basis: An accounting method where revenue and expenses are recorded when they are earned or incurred, regardless of when cash is actually received or paid. π Definition β Cash Basis: An accounting method where revenue and expenses are recorded only when cash is actually received or paid.
π Formula: Cash Flow from Operations = Net Income + Non-cash Expenses (e.g., Depreciation) - Gains + Losses +/- Changes in Working Capital. π Formula: Change in Asset/Liability Account = Ending Balance - Beginning Balance.
π Example: In the provided income statement, βOperating expenses (Includes depreciation Rs. 40,000)β is a key item. When preparing the cash flow statement, the Rs. 40,000 of depreciation (a non-cash expense) must be added back to Net Income to calculate Cash Flow from Operations. Similarly, the βGain on sale of plant assetsβ of Rs. 31,000 and βLoss on sale of marketable securitiesβ of Rs. 4,000 must also be adjusted (subtract the gain, add the loss) to isolate the actual cash flows from operating activities.
β Key Takeaways
- The statement of cash flows is prepared by converting accrual-based income statement and balance sheet data into a cash-based format.
- Analyzing the income statement requires reclassifying its items into operating and investing activities, noting non-cash items like depreciation.
- Analyzing the balance sheet involves examining the net change (increase or decrease) in each non-cash asset, liability, and equity account.
- The directional change in an account (increase/debit or decrease/credit) dictates the nature of the cash flow, with asset decreases often indicating cash inflows and asset increases indicating cash outflows.
- Non-cash items included in the income statement, such as depreciation, gains, and losses, must be specifically adjusted (added back or subtracted) to determine the actual cash flow from operations.
π§ Quick Revision Questions
- What is the fundamental difference between accrual-based accounting and cash-based accounting?
- If a companyβs Accounts Receivable balance decreases during the year, does this typically represent a cash inflow or a cash outflow from operations? Explain why.
- An increase in a liability account (e.g., Accounts Payable) is a credit entry. Does this increase represent a cash inflow or outflow? Why?
- How would a βGain on Sale of Equipmentβ of Rs. 20,000 be handled when calculating net cash provided by operating activities?
- In the Moosa Corporation example, why is the Net Income (Rs. 65,000) different from the Profit after tax (Rs. 25,000)?
π Lecture 14 β STATEMENTS CASH FLOWS (Continued)
π Overview: This lecture continues the analysis of the Statement of Cash Flows by examining additional information obtained from changes in balance sheet accounts during the current year. It classifies this additional information into the three categories of Operating, Investing, and Financing Activities, and demonstrates how an income statement can be re-arranged to support cash flow analysis.
ποΈ Topics Covered
The lecture covers additional information for cash flow analysis organized into operating, investing, and financing activities. It provides specific numerical details for each category including changes in accounts receivable, inventory, accounts payable, depreciation, purchases and sales of plant assets, borrowing and repayment activities, and share issuances. The lecture concludes with a re-arranged income statement showing sales, revenues, gains, and expenses.
π Lecture Summary
Statements Cash Flows (Continued)
This section presents Additional Information (AI) obtained from analyzing changes in balance sheet accounts during the current year. The Cash & Cash equivalents at the beginning of the year were Rs.40,000 and at the end of the year were Rs.75,000. This additional information is classified into three categories: Operating, Investing, and Financing Activities.
π Definition β Cash equivalents: Short-term, highly liquid investments that are readily convertible to known amounts of cash and which are subject to an insignificant risk of changes in value.
π Example: Beginning cash = Rs.40,000; Ending cash = Rs.75,000; Net increase in cash = Rs.35,000.
π‘ Why this matters: The change in cash is the target figure that the statement of cash flows must explain through operating, investing, and financing activities.
Additional Information relating to Operating Activities
Operating activities include changes in current assets and current liabilities directly related to the company's core business operations. The following changes were identified:
- Accounts Receivable increased by Rs.30,000 β this indicates that sales revenue recognized exceeded cash collected from customers.
- Accrued interest (interest receivable) decreased by Rs.1,000 β Dividend revenue is recognized on cash basis and interest revenue on accrual basis.
- Inventory increased by Rs.10,000 and accounts payable increased by Rs.15,000.
- Short-term prepaid expenses increased by Rs.3,000.
- Accrued expenses (payable) decreased by Rs.6,000.
- Depreciation for the year was Rs.40,000 β a non-cash expense that needs to be added back.
- Interest payable increased by Rs.7,000.
- Income tax payable decreased by Rs.2,000.
π Rule: Increase in current assets (excluding cash) β decreases cash flow from operations; Increase in current liabilities β increases cash flow from operations; Non-cash expenses (depreciation) β added back.
π Example: Accounts Receivable increased by Rs.30,000 means that of the Rs.900,000 net sales, Rs.30,000 was not collected in cash, reducing operating cash flow.
Additional Information relating to Investing Activities
Investing activities involve the purchase and sale of long-term assets and investments not considered cash equivalents.
- Marketable Securities (not qualifying as cash equivalent) show debit entries of Rs.65,000 (purchases) and credit entries of Rs.44,000 (sales).
- Notes Receivable Account shows Rs.17,000 debit (new notes issued) and Rs.12,000 credits (notes collected).
- Purchase of plant assets for Rs.200,000: Cash payment of Rs.160,000 and long-term Note Payable of Rs.40,000 β the cash portion is the investing outflow.
- Sale of plant assets with book value of Rs.44,000 β proceeds from sale are an investing inflow.
π Definition β Investing activities: Transactions involving the acquisition and disposal of long-term assets and other investments not included in cash equivalents.
π Example: Purchase of plant assets for Rs.200,000 with Rs.160,000 cash and Rs.40,000 note payable β only the Rs.160,000 cash payment appears in the investing activities section.
Additional Information relating to Financing Activities
Financing activities include transactions with owners and creditors involving borrowing, repayment, and equity transactions.
- Borrowed Rs.45,000 cash by issuing short-term Notes Payable.
- Repaid Rs.55,000 on account of principal on Loans & Notes Payable.
- Issued bonds payable for Rs.100,000 cash.
- Issued for cash 1,000 shares of Rs.10 par value at Rs.50 per share β total proceeds Rs.50,000.
- Cash dividend paid of Rs.40,000.
π Definition β Financing activities: Transactions that result in changes in the size and composition of the contributed equity and borrowings of the entity.
π Example: Issuance of 1,000 shares at Rs.50 per share (par value Rs.10) generates Rs.50,000 cash inflow β Rs.10,000 goes to share capital and Rs.40,000 to additional paid-in capital.
Re-arranging Income Statement in the two categories of Operating and Investing Activities
The income statement is re-arranged to distinguish between operating revenues/expenses and non-operating items. The MOOSA CORPORATION Income Statement for the year ended June 30 shows:
Sales, other revenue and gains:
- Net sales: Rs.900,000
- Dividend Revenue: Rs.3,000
- Interest Revenue: Rs.6,000
- Gain on sales of plant assets: Rs.31,000
- Total: Rs.940,000
Cost of sales, other expenses and losses:
- Cost of goods sold: Rs.500,000
- Operating expenses: Rs.300,000 (includes Depreciation of Rs.40,000)
- Interest expenses: Rs.35,000
- Income tax expenses: Rs.36,000
- Loss on sale of marketable securities: Rs.4,000
- Total: Rs.875,000
Net Income: Rs.65,000
π Definition β Operating activities: The principal revenue-producing activities of the entity and other activities that are not investing or financing activities.
π Example: Net sales of Rs.900,000 and cost of goods sold of Rs.500,000 are operating items, while gain on sale of plant assets (Rs.31,000) is an investing activity item on the income statement.
π‘ Why this matters: Separating operating from investing items in the income statement helps in preparing the indirect method statement of cash flows, where non-cash items and gains/losses from investing/financing activities must be adjusted.
β Key Takeaways
The most critical items to remember are: (1) Changes in current assets and current liabilities are the primary adjustments needed to convert net income to cash from operating activities β increases in current assets (except cash) reduce cash flow, while increases in current liabilities increase cash flow. (2) Non-cash expenses like depreciation (Rs.40,000) must be added back to net income, and gains/losses on asset sales must be removed because the full proceeds go to investing activities. (3) Investing activities include only actual cash payments for asset purchases (Rs.160,000 of the Rs.200,000 purchase) and actual cash receipts from asset sales. (4) Financing activities track all cash flows with creditors and shareholders β borrowings, repayments, bond issuances, stock issuances, and dividend payments. (5) The ending cash balance (Rs.75,000) must equal the beginning balance (Rs.40,000) plus the net change from all three activities combined.
π§ Quick Revision Questions
- How does an increase in Accounts Receivable of Rs.30,000 affect the cash flow from operating activities when using the indirect method?
- Why is depreciation of Rs.40,000 added back to net income in the operating activities section?
- In the purchase of plant assets for Rs.200,000 (Rs.160,000 cash + Rs.40,000 note payable), what amount appears in investing activities?
- What is the total cash inflow from financing activities given the issuance of shares (1,000 shares at Rs.50) and bonds (Rs.100,000)?
- If Net Income is Rs.65,000 but total cash increased by Rs.35,000, what accounts for the difference between net income and the change in cash?
π Lecture 15 β Financial Statements (Continued) Cash flow from Operating Activities
π Overview: This lecture focuses on the computation of key items on the Income Statement, specifically Net Sales, Cost of Goods Sold, and Interest Expense. It then demonstrates how to calculate cash inflows from operating activities, including cash received from customers and cash received for interest and dividends, using a comprehensive example and a full Cash Flow Statement preparation problem.
ποΈ Topics Covered
The lecture begins with the study of computing Net Sales, Cost of Goods Sold, and Interest Expense on the Income Statement. It then explains how to calculate cash received from customers, both for cash sales and credit sales, using changes in Accounts Receivable. Finally, it presents a detailed, step-by-step example of preparing a complete Cash Flow Statement, including operating, investing, and financing activities, with supporting ledger accounts.
π Lecture Summary
Cash Flow from Operating Activities
To compute cash flow from operating activities, we start with net profit before tax and make adjustments for non-cash items and changes in working capital.
Cash received from customers is calculated differently for cash and credit sales. For cash sales, cash received is equal to Net Sales. For credit sales (sales on account), the formula is: Cash received = Net Sales β increase in Accounts Receivable, or Net Sales + decrease in Accounts Receivable. The increase or decrease in Accounts Receivable is determined by comparing the beginning and ending balances from the Balance Sheet.
π Definition β Net Sales: Total sales revenue after deducting sales returns, allowances, and discounts.
π Formula: Cash received from customers (credit) = Net Sales β (Ending Accounts Receivable β Beginning Accounts Receivable)
π Example: (A1 No:1) If Net Sales are Rs. 900,000 and Accounts Receivable increased by Rs. 30,000, then Cash received from customers = 900,000 β 30,000 = Rs. 870,000.
Cash dividend received is equal to Dividends Revenue, which is based on cash, so whatever Dividend Revenue is received, that is a cash inflow.
Cash interest received is calculated using the formula: Cash interest received = Interest Revenue + Decrease in Interest Receivable, or Interest Revenue β Increase in Interest Receivable.
π Example: (A1 No:2) If Interest Revenue is Rs. 6,000 and Interest Receivable decreased by Rs. 1,000, then Cash interest received = 6,000 + 1,000 = Rs. 7,000.
Interest and Dividend received = 3,000 + 7,000 = Rs. 10,000.
Total Cash Inflow from operating activities = Cash from customers + Interest & dividends received = 870,000 + 10,000 = Rs. 880,000.
Cash Flow Statement β Example Problem (ABC Ltd)
The lecture presents a comprehensive problem to prepare a Cash Flow Statement for ABC Ltd for the year ended June 30, 2002.
Given Data:
- Balance Sheet as at June 30, 2001 and 2002, including:
- Fixed Assets: Building, Plant and Machinery, Long Term Investments
- Current Assets: Debtors, Stock, Short Term Deposits, Cash and Bank
- Current Liabilities: Creditors, Proposed Dividend, Tax Payable
- Equity: Share Capital, Share Premium, General Reserve, Accumulated Profit/Loss
- Long Term Liabilities: Term Finance Certificates (TFC)
- Profit and Loss Account for the year ended June 30, 2002:
- Sales: Rs. 300,000
- Cost of Sales: Rs. 231,000
- Gross Profit: Rs. 69,000
- Other Income: Rs. 4,000 (including dividend on Long Term Investment)
- Administrative Expenses: Rs. 24,000 (including Directorβs Remuneration, Depreciation on Building Rs. 6,000, Loss on Sale of Machinery Rs. 2,000)
- Selling Expenses: Rs. 10,000
- Markup on TFC: Rs. 2,000
- Profit Before Tax: Rs. 37,000
- Provision for Tax: Rs. 9,000
- Profit After Tax: Rs. 28,000
Additional Information:
- Cost of goods sold includes depreciation for the year on machinery Rs. 5,000.
- Accumulated Depreciation on the machine disposed of amounts to Rs. 4,000.
Solution β ABC Ltd Cash Flow Statement for the Year Ended June 30, 2002
| Note | Rs. β000 | |
|---|---|---|
| Net Profit Before Tax | 37,000 | |
| Adjustment of Non-Cash Items | ||
| Depreciation | 11,000 | |
| Loss on Sale of Machinery | 2,000 | |
| Markup on TFC | 2,000 | |
| 52,000 | ||
| Less: Other Income | (4,000) | |
| Operating Profit Before Working Capital Changes | 48,000 | |
| Working Capital Changes | ||
| Reduction in Stock | 15,000 | |
| Increase in Creditors | 3,000 | |
| Increase in Debtors | (9,000) | |
| 9,000 | ||
| Cash Flow from Operations | 57,000 | |
| Markup on TFC Paid | (2,000) | |
| Tax Paid | 1 | (8,000) |
| Net Cash Flow From Operating Activities | 47,000 | |
| Cash Flow From Investing Activities | ||
| Dividend Received | 4,000 | |
| Payment to Acquire Investments | 2 | (7,000) |
| Purchase of Fixed Assets (Building) | 3 | (41,000) |
| Receipt from Sale of Assets | 4 | 1,000 |
| Net Cash Flow From Investing Activities | (43,000) | |
| Cash Flow From Financing Activities | ||
| Issue of Ordinary Shares | 20,000 | |
| Share Premium Account | 5,000 | |
| Dividend Paid | 5 | (16,000) |
| Repayment of TFC | 6 | (4,000) |
| Net Cash Flow From Financing Activities | 5,000 | |
| Net Increase / (Decrease) in Cash and Cash Equivalents | 9,000 | |
| O/B of Cash and Cash Equivalents | 39,000 | |
| C/B of Cash and Cash Equivalents | 48,000 |
The following supporting notes (ledger accounts) are provided to show the calculations for specific items.
Note # 1 β Tax Paid The Provision for Tax Account is used to derive the cash paid for tax.
- Opening balance: Rs. 8,000
- Provision for the year: Rs. 9,000 (dr.)
- Cash paid (balancing figure): Rs. 8,000 (cr.)
- Closing balance: Rs. 9,000
Note # 2 β Payments to Acquire Investments The Investment Account is used to determine cash paid for new investments.
- Opening balance: Rs. 10,000
- Closing balance: Rs. 17,000
- Cash paid (balancing figure): Rs. 7,000
Note # 3 β Purchase of Fixed Assets The Building Cost Account is used to determine cash paid for new building.
- Opening balance: Rs. 140,000
- Closing balance: Rs. 181,000
- Cash paid (balancing figure): Rs. 41,000
Note # 4 β Sale Proceed of Machinery Two accounts are needed to find the cash received from the sale of machinery.
- Machinery at Cost Account: Opening balance Rs. 90,000, Closing balance Rs. 83,000. This implies a cost of machinery sold of Rs. 7,000.
- Disposal of Asset Account: The cost of the disposed asset is Rs. 7,000. Accumulated depreciation is Rs. 4,000. The loss on sale is Rs. 2,000. Therefore, the sale proceed (cash received) is computed as: Cost β Accum. Dep. β Loss = 7,000 β 4,000 β 2,000 = Rs. 1,000.
Note # 5 β Dividend Paid The Dividend Payable Account is used to determine cash dividend paid.
- Opening balance: Rs. 16,000
- Proposed dividend for the year: Rs. 18,000
- Cash paid (balancing figure): Rs. 16,000
- Closing balance: Rs. 18,000
Note # 6 β Repayment of TFC The TFC Account is used to determine the amount repaid.
- Opening balance: Rs. 20,000
- Closing balance: Rs. 16,000
- Cash repaid (balancing figure): Rs. 4,000
β Key Takeaways
The most critical points from this lecture are: first, cash received from customers is not the same as sales revenue; you must adjust credit sales for changes in Accounts Receivable. Second, the Cash Flow Statement is prepared by adjusting net profit before tax for non-cash items (like depreciation and loss on sale) and changes in working capital. Third, cash flows are categorized into operating, investing, and financing activities, providing a complete picture of a company's liquidity. Fourth, supporting ledger accounts (e.g., for tax, investments, fixed assets, dividends, and loans) are essential to derive the actual cash amounts paid or received. Finally, the closing cash balance from the Cash Flow Statement must reconcile with the cash balance on the Balance Sheet.
π§ Quick Revision Questions
- How do you calculate cash received from customers when there is an increase in Accounts Receivable?
- What is the formula for calculating cash interest received from the Income Statement and Balance Sheet?
- In the Cash Flow Statement, why are depreciation and loss on sale of machinery added back to net profit before tax?
- Using the example, explain how the cash paid for tax is derived from the Provision for Tax Account.
- How is the sale proceed from the disposal of an asset calculated when the cost, accumulated depreciation, and loss on sale are known?
π Lecture 16 β Financial Statements (Continued)
π Overview: This lecture continues the detailed analysis of financial statements, specifically focusing on constructing the cash flow statement from the balance sheet and income statement. It demonstrates how to compute cash payments for merchandise, operating expenses, interest, and income tax by adjusting accrual-based figures for changes in related balance sheet accounts. The lecture culminates in preparing the operating activities section of the cash flow statement and explaining the difference between net income and net cash flow from operations.
ποΈ Topics Covered
This lecture covers the calculation of cash payments for merchandise using changes in inventory and accounts payable, cash payments for operating expenses using changes in prepaid expenses and accrued expenses along with depreciation, and cash payments for interest and income tax using changes in accrued interest payable and tax liability. It then presents the complete operating activities section of the cash flow statement and analyzes the reasons for the difference between net income and net cash flow from operating activities.
π Lecture Summary
Cash Payment for Merchandise
The cash payment for merchandise is calculated by adjusting the Cost of Goods Sold for changes in Inventory and Accounts Payable. An increase in Inventory means more cash was paid to purchase goods than were sold, so it is added to COGS. A decrease in Accounts Payable means cash was paid to suppliers to reduce the outstanding liability, so it is also added to COGS. The formula is: Cash Payment = COGS + Increase in Inventory + Decrease in Accounts Payable. Alternatively, if Inventory decreases or Accounts Payable increases, those amounts are subtracted.
π Formula: Cash payment for Merchandise = Cost of Goods Sold + increase in Inventory + Decrease in Accounts Payable β This calculates the actual cash outflow to suppliers.
π Example: For A1 No.3, Cost of Goods Sold = Rs.500,000, Inventory increased by Rs.10,000, and Accounts Payable decreased by Rs.15,000. Cash payment for merchandise = 500,000 + 10,000 + 15,000 = Rs.495,000.
Cash Payment for Operating Expenses (A1 No.4, 5 & 6)
Operating expenses as reported on the income statement must be adjusted for changes in prepaid and accrued expenses, as well as non-cash charges like depreciation. Prepaid expenses increased by Rs.3,000, meaning cash was paid in advance for expenses not yet incurred, so this amount is added to the expense. Accrued expenses (Payable) decreased by Rs.6,000, meaning cash was paid to settle liabilities that were previously accrued, so this amount is also added. Depreciation of Rs.40,000 is a non-cash expense that reduces net income but requires no cash outflow, so it is deducted from total operating expenses.
π Formula: Cash payment for operating expenses = Operating Expenses + increase in Pre Paid expenses + decrease in Accrued Expenses β Depreciation
π Example: Operating expenses are Rs.300,000. Prepaid expenses increased by Rs.3,000, accrued expenses decreased by Rs.6,000, and depreciation is Rs.40,000. Cash payment = 300,000 + 3,000 + 6,000 - 40,000 = Rs.269,000.
π‘ Why this matters: Total cash paid for merchandise and operating expenses together = 495,000 + 269,000 = Rs.764,000.
Cash Payment for Interest (A17)
The cash payment for interest is determined by adjusting the interest expense shown on the income statement for the change in accrued interest liability (interest payable) . An increase in interest payable means that not all of the interest expense was paid in cash; the increase represents the portion that remains unpaid. Therefore, the increase is subtracted from the interest expense to find the actual cash paid.
π Formula: Cash payment for interest = Interest Expense - Increase in Accrued Interest Liability
π Example: Interest expense in the Income Statement is Rs.35,000, and accrued interest liability increased by Rs.7,000. Cash paid for interest = 35,000 - 7,000 = Rs.28,000.
Cash Payment for Income Tax (A18)
The cash payment for income tax is calculated by adjusting the tax expense for the change in the tax liability. A decrease in tax liability means that cash payments made during the period exceeded the expense incurred, as the company paid down some of the previous period's liability. Therefore, the decrease is added to the tax expense.
π Formula: Cash payment for Income Tax = Tax Expense + Decrease in Tax Liability
π Example: Tax expenses in the Income Statement are Rs.36,000, and the tax liability decreased by Rs.2,000. Income tax paid in cash = 36,000 + 2,000 = Rs.38,000.
Operating Activitiesβ Portion of Cash Flow Statement
The cash flows from operating activities are summarized by listing all cash inflows and outflows calculated in the previous sections. Cash inflows include receipts from customers and interest/dividends received. Cash outflows include payments to suppliers, for operating expenses, interest, and income tax. The net cash flow from operating activities is the difference between total inflows and outflows.
π Example:
- Cash Inflows: Cash received from customers (Rs.870,000) + Interest & dividend received (Rs.10,000) = Rs.880,000
- Cash Outflows: Cash paid to suppliers & operating expenses (Rs.764,000) + Interest paid (Rs.28,000) + Income tax paid (Rs.38,000) = Rs.830,000
- Net cash flow from Operating Activities: 880,000 - 830,000 = Rs.50,000
Difference Between Net Income and Net Cash Flow from Operations
The net income reported on the Income Statement is Rs.65,000, while the net cash flow from Operating Activities is Rs.50,000. The difference is Rs.15,000. The primary reasons for this difference are depreciation expense, which reduces net income but does not require any cash payment, and adjustments made to convert accrual-based items (like net sales, cost of goods sold, and expenses) to cash-based figures. Additionally, non-operating gains and losses that affect net income are classified under Investing & Financing Activities in the cash flow statement.
β Key Takeaways
The critical concept from this lecture is that the cash flow statement's operating section is prepared by adjusting income statement items for changes in related balance sheet accounts. Increases in current assets (like inventory and prepaid expenses) represent cash outflows and are added to expenses, while decreases represent cash inflows and are subtracted. Conversely, increases in current liabilities (like accounts payable and accrued expenses) represent cash inflows (or reduced outflows) and are subtracted from expenses, while decreases are added. The difference between net income and net cash flow from operations is primarily due to non-cash charges like depreciation and the timing differences captured by these working capital adjustments.
π§ Quick Revision Questions
- If Cost of Goods Sold is Rs.400,000, Inventory decreased by Rs.20,000, and Accounts Payable increased by Rs.10,000, what is the cash payment for merchandise?
- Operating expenses are Rs.250,000, Prepaid expenses decreased by Rs.5,000, Accrued expenses increased by Rs.8,000, and Depreciation is Rs.30,000. Calculate the cash payment for operating expenses.
- Explain why an increase in Accrued Interest Liability is subtracted from Interest Expense to calculate cash paid for interest.
- If Income Tax Expense is Rs.50,000 and the tax liability increased by Rs.3,000, what is the cash payment for income tax?
- List two specific reasons why net income (Rs.65,000) can differ from net cash flow from operating activities (Rs.50,000).