Cash Flow Statement Exercise with Detailed Solution (2024)

by Niranjan
(Jodhpur, India)

Before you begin: It's very important that when you are preparing for tests and exams that you not only answer questions correctly but learn to complete the questions at the right speed. Please time yourself while attempting this exercise.

Difficulty Rating:
Intermediate --> Advanced

Time limit:
35 minutes

Please note that in this question Rs = Rupees = Indian currency. Also figures are written in Indian style: Rs 1,00,000 (Indian figure) = 100,000 Rupees (Western system). Rs 15,30,000 (Indian figure) = 1,530,000 Rupees (Western system). Etc., etc.

Question:

SVKM’s Narsee Monjee Institute of Management Studies (NMIMS)
School of Distance Learning
SUBJECT : ACCOUNTING AND FINANCE
FOR MANAGERS Marks: 20
All questions are compulsory:

Good Luck Limited has submitted the following condensed Balance Sheets as on 31st December, 2006 and 31st December, 2007 and the Statement of Income and Reconciliation of Retained Earnings for the year ended 31st December, 2007:

Cash Flow Statement Exercise with Detailed Solution (1)

Cash Flow Statement Exercise with Detailed Solution (2)

Additional Information:
1. The cash inflow and outflow during the course of operations of the firm are as follows:
Collection from customers Rs 15,30,000
Cash paid to suppliers Rs 10,80,000
Cash paid to employees and other expense Rs 2,46,000
Income tax paid during the year Rs 75,000
2. During 2007, the company purchased a building for Rs 1,00,000.

You are required to prepare the Cash Flow Statement and comment on the cash flow condition of the company.

*****************************************************

Solution:

Cash Flow Statement Exercise with Detailed Solution (3)


Notes to the Above Solution:

Here are a few important points about this solution and general pointers about how to go about answering a typical cash flow statement question.

Since you are graded or marked according to each correct line item you put in the cash flow statement, the most important thing is to try get as many correct line items in there - even if you don't get everything done or your final "net increase or decrease in cash" doesn't add up correctly - get as much in there as possible so you get maximum marks.

With that in mind, one of the first things I complete is the final lines of the cash flow statement with the cash at the beginning and the end of the period, which they either just tell you (as they did in this question) or they show you under the balance sheet line item "cash and cash equivalents."

You can then also do a quick calculation of the net increase or decrease in cash.

The next thing I would do is fill in any of the other items that they give you. In this case, they gave you cash receipts from customers (1,530,000), cash paid to suppliers (1,080,000) and cash paid to employees and other expenses (246,000).

They also gave tax paid (75,000) and the investment in the building (100,000), which is an "addition."

One of the other easy things they gave is the dividends paid figure (100,000), which is listed in the income statement (or the "statement of income and reconciliation of retained earnings" as they gave here).

Remember that depreciation is an expense only in the accounting books, not an actual cash expense, so

this does not go into the cash flow statement.

Some of the Trickier Points:

The share capital increased by 100,000 during the year, which means 100,000 cash inflow. This is calculated as the difference between the closing balance and opening balance (400,000 - 300,000).

Note that we don't include any changes in the general reserve in the above calculation of capital contributed as they show in the income statement that this amount (20,000) was taken from the profit figure. So it is not a cash investment, only an amount in the books. The same applies to the retained earnings - no actual cash movement here, just a distribution of our profits to equity accounts.

When we look at the non-current or long-term liabilities we can see that the debentures decreased by 75,000, which means we paid this amount to the holders of that debt. We can also see that the mortgage loan increased from 0 to 40,000, which means a cash inflow equal to 40,000.

The creditors and wages outstanding are already taken into account to calculate the "cash paid to suppliers and employees" figure that was given to us.

Final Notes - Interest and Prepaid Expenses

As a final note, there are a few unusual points in this question which don't seem to require anything in the solution but may require more attention in another cash flow statement question:

1) Good Luck Limited has interest-bearing long-term debt in the form of the debentures and the mortgage loan. Interest paid is a pretty routine line item in the cash flow statement (under "cash flow from operating activities"). However, since they did not give an interest payment amount and since we don't know exactly when the debentures and mortgage amounts changed during the year, we cannot calculate the interest paid here.

2) The preliminary expenses (an asset account) is reduced as 5,000 is written off as an expense during the year. This was not a cash movement but rather just recognizing part of this asset's balance as an expense in the books.

However, the prepaid expenses account increases by 3,000 during the year. This would indicate a cash outflow of 3,000 and should be included somewhere in the cash flow statement. However, if you try include this as a line item in the cash flow statement, it throws off the final calculated net cash flow figure. The only explanation is that this 3,000 is already included in the figure for "cash paid to suppliers" which they gave us (1,080,000).

So, how did you find this cash flow statement exercise?

Was it similar to the ones you've seen in your classes?

Did you get most of the points right?

Have your say by adding a comment below.

Best,
Michael Celender
Founder of Accounting Basics for Students

Related Questions & Tutorials:
  • The Indirect Cash Flow Statement Method
  • Cash Flow Statement and Depreciation
  • Bad debts in Cash Flow Statement?
  • Cash Flow Statement: Dividends Paid under Financing or Operating Activities?
  • Cash Flow Statement: Purpose and Importance

Return to the main Cash Flow Statement Tutorial

Click here for more Full Accounting Exercises

I am an expert and enthusiast based assistant. I have access to a wide range of information and can assist you with various topics. I can provide factual information, engage in discussions, and offer insights based on my knowledge and the search results I have access to.

Regarding the concepts mentioned in the article you provided, let's go through them one by one:

Cash Flow Statement:

A cash flow statement is a financial statement that provides information about the cash inflows and outflows of a company during a specific period. It helps analyze the sources and uses of cash, providing insights into a company's liquidity and cash management. The statement is divided into three sections: operating activities, investing activities, and financing activities. The cash flow statement is an important tool for financial analysis and decision-making.

Balance Sheets:

Balance sheets are financial statements that provide a snapshot of a company's financial position at a specific point in time. They present the company's assets, liabilities, and shareholders' equity. The balance sheet equation states that assets equal liabilities plus shareholders' equity. Balance sheets are used to assess a company's financial health, liquidity, and solvency.

Statement of Income and Reconciliation of Retained Earnings:

The statement of income, also known as the income statement or profit and loss statement, shows a company's revenues, expenses, and net income or loss over a specific period. It provides insights into a company's profitability and performance. The reconciliation of retained earnings is a statement that explains the changes in a company's retained earnings from the beginning to the end of a period. It includes factors such as net income, dividends, and adjustments.

Cash Inflow and Outflow:

Cash inflow refers to the money coming into a company, while cash outflow refers to the money going out of a company. In the context of the article, the cash inflow and outflow during the course of operations of the firm are mentioned. The specific amounts of cash collected from customers, paid to suppliers, paid to employees and other expenses, and paid as income tax are provided.

Building Purchase:

The article mentions that the company purchased a building for a specific amount. This is considered an investing activity and should be included in the cash flow statement under the investing activities section.

Share Capital:

The article states that the share capital increased by a specific amount during the year. This increase represents a cash inflow and should be included in the cash flow statement under the financing activities section.

Debentures and Mortgage Loan:

The article mentions changes in the debentures and mortgage loan. The decrease in debentures represents a cash outflow, while the increase in the mortgage loan represents a cash inflow. These should be included in the cash flow statement under the financing activities section.

Dividends Paid:

The article states that dividends were paid by the company. Dividends paid represent a cash outflow and should be included in the cash flow statement under the financing activities section.

These are the main concepts mentioned in the article. If you have any specific questions or need further clarification, feel free to ask.

Cash Flow Statement Exercise with Detailed Solution (2024)

References

Top Articles
Latest Posts
Article information

Author: Ms. Lucile Johns

Last Updated:

Views: 6201

Rating: 4 / 5 (41 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Ms. Lucile Johns

Birthday: 1999-11-16

Address: Suite 237 56046 Walsh Coves, West Enid, VT 46557

Phone: +59115435987187

Job: Education Supervisor

Hobby: Genealogy, Stone skipping, Skydiving, Nordic skating, Couponing, Coloring, Gardening

Introduction: My name is Ms. Lucile Johns, I am a successful, friendly, friendly, homely, adventurous, handsome, delightful person who loves writing and wants to share my knowledge and understanding with you.