Cellwise Start free

Excel guide · 4 min read

How to calculate free cash flow in Excel

Quick answerFree cash flow = cash from operating activities - capital expenditure. In Excel, with operating cash flow in E6 and capex in E7: =E6-E7. If you only have the P&L and balance sheet, use net profit + depreciation - increase in working capital - capex. This business generated 35,500 from operations in 2026 and spent 12,000 on equipment, so its free cash flow was 23,500.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABCDEFGH
1Year2023202420252026Statement 2026Amount
2Revenue186000204000221000248000Cash from operating activities35500
3Net profit18200219002610030400Purchase of equipment-12000
4Depreciation4200510058006500
5Increase in working capital3100480026001400
6Cash from operating activities19300222002930035500
7Capital expenditure650031000980012000
8Free cash flow12800-88001950023500
9FCF margin0.068817204301-0.0431372549020.0882352941180.094758064516
10FCF / net profit0.7032967033-0.401826484020.747126436780.77302631579

Download this sheet as an Excel practice file (.xlsx)

What free cash flow tells you

Profit says whether the business earned more than it spent on paper. Free cash flow (FCF) says how much cash was left after running the business and paying for the equipment it needs. That's the money available to repay loans, pay the owners, or build up a cash buffer.

The sample has four years across B:E: revenue, net profit, depreciation, the increase in working capital, cash from operating activities, and capital expenditure (capex: money spent on equipment, vehicles, fit-outs and other long-term assets). The 2026 column ties to the example in cash flow statement in Excel.

Method 1: from the cash flow statement

If you have a cash flow statement, take cash from operating activities and subtract the cash spent on fixed assets in the investing section. That's the whole calculation.

Watch the sign. A cash flow statement shows the equipment purchase as a negative number (-12,000), so you add it rather than subtract it. Subtracting a negative capex turns it into an addition and overstates FCF by twice the capex, which is the most common FCF mistake. In the yearly table, capex in row 7 is typed as a positive number, so row 8 subtracts it.

=H2+H3

Result: 23500

23,500: 35,500 of operating cash flow plus the -12,000 equipment line as it appears in the statement.

What goes into capex?

Cash paid for long-term assets in the period: equipment, vehicles, computers, building work. Proceeds from selling old equipment are a separate investing line; some analysts net them off and some don't, so say which you did. Leases, acquisitions and interest have treatments that vary, so follow the classification in your own statement and ask your accountant.

Method 2: from net profit (the shortcut)

Without a cash flow statement, build operating cash flow yourself: net profit + depreciation - increase in working capital. Depreciation is added back because it reduced profit without any cash leaving. The working capital line is the increase in receivables and inventory minus the increase in payables over the year; an increase uses cash, so it's subtracted.

Then subtract capex. In one formula for 2026: 30,400 + 6,500 - 1,400 - 12,000 = 23,500, the same answer as Method 1.

=E3+E4-E5-E7

Result: 23500

23,500 of free cash flow in 2026, built up from net profit.

FCF margin and years side by side

One year of FCF doesn't say much on its own. Put several years next to each other and add two ratios: FCF margin (free cash flow / revenue) and FCF / net profit, sometimes called cash conversion. Format both as percentages.

2024 is negative: operations brought in 22,200, but the business spent 31,000 on a new van and a shop fit-out, so free cash flow was -8,800. A negative year after a big purchase isn't a warning sign by itself. A run of negative years while capex stays normal is a different story: it means operations aren't funding the business.

=E8/E2

Result: 0.094758064516 shows as 9.5% with Percent format

0.0948: free cash flow was 9.5% of 2026 revenue (23,500 / 248,000).

What's the average FCF margin over several years?

Divide total FCF by total revenue rather than averaging the yearly percentages, so big years count for more than small ones.

=SUM(B8:E8)/SUM(B2:E2)

Result: 0.054714784633 shows as 5.5% with Percent format

0.0547: 47,000 of free cash flow on 859,000 of revenue over four years, 5.5%. The simple average of the four margins would be 5.2%.

Why free cash flow and profit differ

Over the four years the business made 96,600 of profit but only 47,000 of free cash flow, about 49%. The gap comes from two places. Capex (59,300 in total) ran well ahead of depreciation (21,600), because the business was buying new equipment faster than the old wore out on paper. And working capital grew by 11,900 as sales grew: more customers owing money and more stock on the shelves.

That's normal for a growing business, and it's why a profitable business can still run short of cash. To see how long your cash lasts when FCF is negative, see cash runway in Excel. To compare profit itself with revenue, see profit margin in Excel.

=SUM(B8:E8)/SUM(B3:E3)

Result: 0.48654244306 shows as 49% with Percent format

0.4865: free cash flow was about 49% of net profit over 2023 to 2026.

Common mistakes

Subtracting a negative capex

In a cash flow statement capex is already negative. Add it to operating cash flow, or flip it to positive first.

Using EBITDA or net profit as the cash figure

Neither includes working capital changes or capex. Start from operating cash flow, or adjust net profit as in Method 2.

Averaging yearly FCF margins

Use total FCF / total revenue for a multi-year margin.

Mixing definitions between years

Treat asset sales, leases and interest the same way every year and write the definition next to the table.

FAQ

What is the formula for free cash flow?

Cash from operating activities minus capital expenditure. From the P&L: net profit + depreciation - increase in working capital - capital expenditure.

Can free cash flow be negative?

Yes. It's negative when capex is larger than operating cash flow, often in a year with a big equipment purchase. Look at the trend across several years.

What is a good free cash flow margin?

It varies a lot by industry and by how fast a business is growing, since growth needs capex and working capital. Compare with your own previous years rather than a general rule.

Is free cash flow the same as net cash flow?

No. Net cash flow is the total change in the cash balance, including loans taken or repaid and money paid to owners. Free cash flow stops before financing, so it shows what operations left over to fund those.

Functions used

Related guides

Updated