AccountancyNEB 2075 (old course)

The Balance Sheet of a company for two years are as under: Liabilities Year 1(Rs.) Year 2(Rs.) Assets Year 1 (Rs.) Year 2(Rs.) : : : : : : Share capital 700,000 900,000 Fixed Assets 500,000 700,000…

10

The Balance Sheet of a company for two years are as under:

Liabilities Year 1(Rs.) Year 2(Rs.) Assets Year 1 (Rs.) Year 2(Rs.)
Share capital 700,000 900,000 Fixed Assets 500,000 700,000
5% Debentures 100,000 50,000 Stock 100,000 150,000
Retained earning 150,000 250,000 Sundry debtors 420,000 310,000
Creditors 150,000 2,00,000 Bank balance 120,000 300,000
Outstanding Expenses 40,000 60,000
Total 1,140,000 1,460,000 Total 1,140,000 1,460,000

Additional information: a) Sales revenue: Rs. 13,00,000 b) Cost of goods sold: Rs. 700,000 c) Administrative expenses: Rs. 130,000 d) Purchase of fixed assets: Rs. 300,000

Required:

  • Cash flow statement [10]

Answer

Cash Flow Statement (Indirect Method) - Year 2 (Summary)Dr.Cr.To Opening Bank Balance (Year 1)1,20,000To Cash from Operating Activities6,50,000To Cash from Investing Activities (Net)-3,00,000To Cash from Financing Activities1,00,000To Closing Bank Balance (Year 2)3,00,000By Net Increase in Cash1,80,000
Simplified Cash Flow Statement (Indirect Method) - Year 2 (Rs.)

Cash Flow Statement (Indirect Method) for Year 2

Step 1: Calculate Net Profit Before Tax

From the given data, we can derive the Net Profit Before Tax (PBT) using the following formula:

Step 2: Adjust Net Profit for Non-Cash Items

Since no depreciation or non-cash expenses are given, we assume no adjustments are needed for non-cash items.

Step 3: Calculate Cash Flow from Operating Activities (Indirect Method)

We use the indirect method to calculate cash flow from operations by adjusting net profit for changes in working capital.

Working Capital Changes:

  1. Increase in Stock (Non-Cash Asset): (Deduction from cash flow)
  2. Decrease in Sundry Debtors (Receivables): (Addition to cash flow)
  3. Increase in Creditors (Payables): (Deduction from cash flow)
  4. Increase in Outstanding Expenses (Accrued Expenses): (Deduction from cash flow)

Net Change in Working Capital:

Cash Flow from Operating Activities:

Step 4: Calculate Cash Flow from Investing Activities

The only investing activity given is the purchase of fixed assets for Rs. 300,000. Since this is a cash outflow, it is recorded as a negative amount.

Step 5: Calculate Cash Flow from Financing Activities

We analyze changes in share capital, debentures, and retained earnings:

  1. Increase in Share Capital: (Cash inflow)
  2. Decrease in 5% Debentures: (Cash outflow)
  3. Increase in Retained Earnings: (Retained earnings increase due to profit, but no direct cash inflow)

Since retained earnings are not a direct cash flow, we only consider share capital and debentures:

Step 6: Calculate Net Increase in Cash

We verify the opening and closing bank balances to ensure consistency:

Step 7: Prepare the Final Cash Flow Statement

Cash Flow Statement (Indirect Method) for Year 2
Cash Flow from Operating Activities
Net Profit Before Tax
Adjustments:
- Increase in Stock
- Decrease in Debtors
- Increase in Creditors
- Increase in Outstanding Expenses
Net Cash from Operations
Cash Flow from Investing Activities
Purchase of Fixed Assets
Net Cash from Investing
Cash Flow from Financing Activities
Increase in Share Capital
Decrease in Debentures
Net Cash from Financing
Net Increase in Cash
Opening Bank Balance
Closing Bank Balance

Final Answer (Cash Flow Statement)

The Cash Flow Statement for the company for Year 2 is as follows:

0162500325000487500650000Opening Balance120000Operating Cash Flow650000Investing Cash Flow-300000Financing Cash Flow100000Closing Balance300000Cash Flow (Rs.)
Year 2 Cash Flow Components Comparison

Discussion

Loading…

More Accountancy questions

All Accountancy old questions