Fund Flow Statement , By: A.K.Chowdhury

No ratings yet. Rate
|
|
|
 

FUND FLOW STATEMENT

A fund flow statement is a summary of a firm's inflow and outflow of funds. It tells us from where funds have come and where funds have gone. Fund flows statement can indicate whether sourcing of funds and their use match in ALM sense and also reveal the prudence or otherwise of a firm's financing and investment decisions.

A firm's balance sheet
From a bank's perspective a borrower's balance sheet can be seen as a structure of five boxes as below.

We can observe the following from above figure:

  • Owner's fund and long term loans represent long term sources of funds
  • Current liabilities (including short term loans repayable within one year) represents short term sources of capital.
  • Thee whole of long term funds is not invested in long term assets but a portion of it is invested in short term or current assets as well. The extent by which current assets are financed by long term funds is known as net working capital or NWC.

If we convert balance sheets of two consecutive years into boxes as above and work out the change in amounts in the boxes, we will get a fund flow statement as below.

Therefore, preparation of fund flow statement involves the followings steps:

  • Take balance sheets as at two dates covering the period for which fund flows statement is intended to be prepared.
  • Work out increase /decrease in each of items
  • Classify change in each item under any of the four heads: (1) Long term sources (2) Long term uses (3) Short term sources (4) Short term uses. The deficit or the surplus in the long term category will be equal to the surplus or deficit in the short term category.

Preparing fund flow statement
Generally changes in assets and liabilities lead to inflows or outflows of cash (or funds). Increase in assets or liabilities, however does not always lead to flow of funds, for instance, depreciation or any kind of revaluation. Therefore, all increases/decreases in asset or liabilities will not form part of fund flow statement but only those that result in the flows of funds.  The following table encapsulates the fund flow implications of changes in asset/liabilities values.


Table -1

Asset

Liability

Type of fund flow

Non-fund based adjustments

Increase

 

Outflows

Upward revaluation

Decrease

 

Inflows

Depreciation

 

Increase

Inflows

Upward revaluation (as in the case foreign currency liabilities)

 

Decrease

Outflows

Depreciation (as in the case foreign currency liabilities)

When preparing fund flow statement we have to nullify the non-fund based adjustments in order to capture only those changes in the values of assets and liabilities that are accompanied by flows of fund. Increase in the item "reserves and surplus" indicate the amount of retained profits for the year. If we add profits distributed to this figure we will get the amount of net profit for the year after taxes. We need to adjust the net profit figure for all non-cash expenses and non-cash incomes. As a rule, we have to add all non-cash expenditure to and deduct all non-cash income from the figure of net profit. For depreciation in assets: Add depreciation to the change in reserve and surplus and correspondingly to the value of assets concerned. The opposite holds for appreciation. For write offs: Add the amount of write offs to net profits.

Income accrued but received and expenses incurred but not received reckoned in the profit and loss account should not be excluded from the profit figure for the purpose of Fund Flow Statement. The rationale for this rule is that so long as accrued incomes are expected to be received and outstanding expenses are expected to be paid in the normal course of business there is no harm in treating these as inflow or outflow of funds, albeit with a lag.

As regards changes in items of current assets and liabilities, we can either show the items separately or net them to arrive at the figure of "change in net working capital". It is however more informative to show the current items separately.

The following example illustrates the preparation of fund flow statement.

Table -2

Liabilities

31-3-06

31-Mar-07

Assets

31-3-06

31-3-07

 

Rs. lakh

Rs. lakh

 

Rs. lakh

Rs. lakh

Capital

90

110

Fixed Assets

135

221

Res. & Sur

35

50

Inv. In Associates

30

86

Term Loan

110

150

Inventory

140

175

Cash Credit

75

90

Receivables

20

25

Trade Crs.

20

100

Cash & Bank

10

8

Bank Borr.

15

20

Other CA

10

5

TOTAL

345

520

TOTAL

345

520

The enterprise has made a profit of Rs. 95,00,000 during the year.
A provision for tax of Rs. 30,00,000 has been made from the profit. An amount of Rs.50,00,000 was withdrawn by the proprietor from the profits during the year.
Besides, the following additional information in respect of the fixed asset items of the enterprise is also available.

 

Rs. Lakh

 

31-3-06

Addition

Disposal

31-3-07

Gross FA

225

125

Nil

350

Total Depreciation

90

 

Nil

129

Net FA

135

125

Nil

221

The first step in working out fund flows is to compute the changes in assets and liabilities during 2006-07. This is shown in the following table.

 

Table-3

Liabilities

Change

Type

Assets

Change

Type

Capital

+20

LTS

Fixed Assets

+86

LTU

Res. & Sur

+15

LTS

Inv. In Associates

+56

LTU

Term Loan

+40

LTS

Inventory

+35

STU

Cash Credit

+15

STS

Receivables

+5

STU

Trade Crs.

+80

STS

Cash & Bank

-2

STS

Other CL

+5

STS

Other CA

-5

STS

Total

175

 

 

175

 

Note that increase in assets is use of funds (outflows) while decrease in assets is source of funds (inflows) and so forth as shown in Table-1. Further, depending on which 'box' (see Figure 2) the items belong the change can represent either a long term or short term source/use. Accordingly, the changes have been categorized as LTS, LTU, STS, STU in the table above. This is our skeleton fund flow statement. We now have to nullify the impact of non-fund based adjustments hidden in the above numbers. Also, certain adjustments are made just in order to make a more meaningful presentation. For example, we are told that the proprietor has withdrawn Rs.50,00,000 from Capital A/c. The withdrawal is fund-based adjustment not requiring any adjustment, strictly speaking. But according to our skeleton fund flow statement increase in reserve and surplus (that is, profit for the year) is Rs.15,00,000. This figure is obviously after the withdrawal of Rs.50,000. The true profit is not therefore Rs.15,00,000 but Rs.65,000. Therefore, a better presentation would be to show profit from operations as Rs.65,00,000 on the Source side and Rs.15,00,000 as profits withdrawn on Uses side. This is arithmetically same as showing just Rs.15,00,000 on the Source side. Therefore our adjustment is as under:

Profit from operations Rs.lakh

Increase in reserves and surplus:15

Add: Profit withdrawn 50

-----------------------------------------------------------------------------------------------------------

Total 65

Provision for tax does not require any adjustment as even though a mere provision does entail fund flow as tax will have to be paid anyway; it is just a matter of timing.

Finally, the increase in fixed assets shown as Rs.86,000 in Table 3, does not represent the correct figure of fixed assets purchased as the fixed assets values include the effect of depreciation. We will have to nullify that.
Rs.lakh
Depreciation provision as on 31.3.2007-129
Depreciation provision as on 31.3.2006-90
Depreciation provided in 2006-07-39

Profit before depreciation adjustment-65
Add depreciation (non-cash expense)-39
Correct cash profit (LT source of funds)-104

Balance of fixed assets as at 31.3.20072-21
Add: depreciation for 2006-07-39
Balance of fixed asset as at 31.3.07 before depreciation-260
Less: Balance of fixed asset as at 31.3.2006-135
Fixed assets purchased during 06-07 (LT application of funds)-125

Fund Flow Statement

Rs. Lakh

Long term Sources

 

Long Term Uses

 

Increase in capital

20

Purchase of fixed assets

125

Profit from operations

104

Investment in associates

56

Increase in long term loan

40

Profit withdrawn

50

Long term deficit

67

 

 

Total

231

Total

231

Short Term Sources

 

Short Term Uses

 

Increase in CC

15

Incraese in inventory

35

Increase in Trade Creditors

80

Increase in receivables

5

Increase in Other Current Liabilities

5

Short term surplus

67

Decrease in cash

2

 

 

Decrease in other current assets

5

 

 

Total

107

Total

107

How do we interpret the above fund flow statement? Basically, it shows healthy cash flows from operations. However the problem is that the firm is using short term money to finance long term investments. This can lead to liquidity problems in future. The onset of liquidity problems is visible as the firm has increased current assets by Rs.33 lakhs as compared with increase in current liabilities by Rs.100 lakh, which produces incremental current ratio of 0.33. Also, the promoter has withdrawn nearly half the profit, which is serious imprudence when he had plans to invest heavily in fixed assets. From another angle, it can be argued that the promoter has withdrawn the more than the entire bank loan. Prima facie, this also appears to be a case of diversion of funds.

In this manner a fund flow statement can be used to derive valuable information on the manner in which a firm raises and deploys its funds.

Revised  by Shri  Arnab Kumar Chowdhury, DGM and Member of Faculty, CAB,Pune (March 2007)

 
  User Feedback
   
 No Feedback is present at this moment.