**Formula of Net Cash Flow (Table of Contents)**

## What is Net Cash Flow Formula?

Net Cash Flow formula calculates the difference between the firm’s cash inflow and the firm’s cash outflow in a given time period.

The formula for calculating Net Cash Flow is per below:

**Net Cash Flow = Total Cash Inflows – Total Cash Outflows**

OR

**Net Cash Flow = Net Cash Flow from Operating Activities + Net Cash Flow from Investing Activities + Net Cash Flow from Financing Activities**

- Net Cash Flow formula is very useful equation as it allows the firm or the company to know the amount of cash that is generated whether its positive or negative and also the firm can bifurcate the same into three major activities among which operating activity is the key as the firm generates its revenue from operating activities and a healthy cash flow from operating activity is a good sign that business is performing well.
- The second activity is the cash flow from investing activity, this would be most of the cases be in negative as the firm invests their major cash flow either in plant and machinery or in another product as an investment and the cash inflow here would be dividend received, etc.
- The last activity is the cash flow from financing activity, in this, the firm would know how it has raised its funds from whether it was internally i.e. by issuing shares or by raising externally that is by a loan.

### Examples of Net Cash Flow Formula (with Excel Template)

Let’s see some simple to advanced examples of net cash flow equation to understand it better.

#### Net Cash Flow Formula Example #1

Company WYZ has been operating in the manufacturing business since ages. The accountant of company WYZ wants to calculate net cash flow for the year ended. The company reported $34 million as the opening cash balance. It was further reported that the firm has earned $100 million from operating activities, $-50 million from investing activities and $30 million from financing activities.

Based on the above information you are required to calculate the closing cash balance of the firm.

**Solution:**

Use below given data for the calculation of net cash flow.

Calculation of net cash flow can be done as follows:

This is a simple example of calculating cash flow, we can use the above equation to calculate the same.

4.9 (1,067 ratings)

Net Cash Flow Formula = $100 million – $50 million + $30 million

Net Cash Flow will be –

**Net Cash Flow = $80 million**

The Net cash flow for the firm is $80 million.

The opening cash balance of the firm is $34 million and if we add net cash flow which is $80 million, we will get the closing balance as $114 million.

#### Net Cash Flow Formula Example #2

Mr. M is the sole proprietor of M & M Associates. The turnover of the firm is less than $2.5 million and hence as per tax rules, they are not required to maintain books of accounts and can directly show 50% as net profit. However, Mr. M wants to know how much cash flow occurred during the year as it wants to borrow a loan from a bank for future requirement.

Below is the summary which was prepared by the accountant for loan appraisal.

The firm is looking to have 80,000 as cash in hand and the same will be met by loan and cash in hand. You are required to calculate the amount of loan that will be required by M&M Associates.

**Solution:**

We are given a summary of financial information. In order to calculate the loan amount, we will first calculate the available cash in hand and for same, we need to calculate the net cash flow.

Calculation of total cash inflows will be –

Calculation of total cash outflows will be –

Calculation of net cash flow can be done as follows:

Net Cash Flows = 55,000 – 23,000

Net Cash Flow will be –

**Net Cash Flow = 32000**

Hence, the loan amount required will be 80,000 – 32000 which is 48,000.

#### Net Cash Flow Formula Example #3

Dynamic Label Inc. has been preparing the cash flow statement to know which activity gave them positive cash flow and which activity gave them negative cash flow. They have gathered below information from cash account and now they want to segregate the cash flow in operating, financing and investing activities.

You are required to calculate the net cash flow using a direct method.

**Solution:**

We will first categories the sources and applications of funds in the three activities which are Operating, financing and investing.

Now we will just add the cash flow and deduct the cash outflow and arrived at respective cash flow from that activity per below:

Net Cash Flow = -21722 + 22213 + 24534

Net Cash Flow will be –

**Net Cash Flow = 25025**

### Net Cash Flow Formula Calculator

You can use this net cash flow formula calculator.

Total Cash Inflows | |

Total Cash Outflows | |

Net Cash Flow | |

Net Cash Flow = | Total Cash Inflows – Total Cash Outflows |

0 – 0 = | 0 |

### Relevance and Uses

Net cash flow as mentioned earlier is an important concept and is the fuel which shall aids firms in developing new products, buy-back its stock, expansion plans, pay dividends to shareholders, or repaying their loans or debt. It is what allows the firms to perform their daily routine business smoothly. This is the reason why some person values the net cash flow even more than any other measure of finance, which also includes EPS that is earnings per share. The big drivers of the net cash flows are the Revenues or sales and expenses.

### Recommended Articles

This has been a guide to Net Cash Flow Formula. Here we discuss how to calculate net cash flow with practical examples and downloadable excel template. You can learn more about financing from the following articles –