Blog · Finance metrics and formulas
Calculate free cash flow growth from comparable operating cash flow and capital spending. Work through a quarterly example, a spreadsheet growth calculator, the driver reconciliation, and negative-base cases.
The FCF growth rate formula is (current FCF - prior FCF) / prior FCF, expressed as a percentage. Use it when the prior period is positive and both periods use the same free cash flow definition. Always show the dollar change beside the rate, because capital spending and collection timing can move it sharply.
For this calculation:
Free cash flow = Cash flow from operating activities - Cash capital expenditures
FCF growth rate = (Current FCF - Prior FCF) / Prior FCF
Free cash flow is a non-GAAP measure. The SEC's guidance on free cash flow, Question 102.07, describes the common operating-cash-minus-capital-expenditures calculation and emphasizes that definitions differ. Record yours before comparing periods.
The free cash flow glossary covers the underlying amount. Here, the question is what changed between comparable amounts. Do not substitute the different calculation used for unlevered free cash flow halfway through the series.
Start with an exported cash flow statement and its capital-spending detail. Keep the entity, reporting currency, period start, period end, cash-flow line, amount, and source reference. Use the reported operating cash subtotal once; do not also add its component rows.
For capex, identify cash payments for property, plant, equipment, and other capitalized assets included in your stated policy. Record those payments as positive amounts to subtract. Exclude noncash additions from this cash calculation, and keep asset-sale proceeds separate unless your disclosed definition explicitly nets them.
A US industrial supplier has these supplied cash-flow totals. All amounts are USD, and all periods are standalone quarters rather than cumulative year-to-date reports.
| Period | Operating cash flow (USD) | Cash capex (USD) | Calculation | FCF (USD) |
|---|---|---|---|---|
| Q3 2025 | 1,200,000 | 400,000 | 1,200,000 - 400,000 | 800,000 |
| Q2 2026 | 1,350,000 | 350,000 | 1,350,000 - 350,000 | 1,000,000 |
| Q3 2026 | 1,500,000 | 540,000 | 1,500,000 - 540,000 | 960,000 |
The same-quarter growth calculation uses Q3 2025 as the denominator:
| Step | Calculation | Result |
|---|---|---|
| Dollar increase (USD) | 960,000 - 800,000 | 160,000 |
| Divide by prior FCF | 160,000 / 800,000 | 0.20 |
| Express as percentage | 0.20 x 100 | 20.0% |
The sequential calculation answers a different question: (960,000 - 1,000,000) / 1,000,000 = -4.0%. Both statements are true: FCF grew against last year's comparable quarter and fell against the immediately preceding quarter. Percentages here are displayed to one decimal place; the calculations retain full precision.
Use this two-period layout in Excel. Enter the four supplied cash-flow amounts, then enter the formulas shown in the value column.
| Cell | Label | Value or formula | Result |
|---|---|---|---|
| B2 | Prior operating cash flow (USD) | 1200000 | 1,200,000 |
| B3 | Prior cash capex (USD) | 400000 | 400,000 |
| B4 | Prior FCF (USD) | =B2-B3 |
800,000 |
| B5 | Current operating cash flow (USD) | 1500000 | 1,500,000 |
| B6 | Current cash capex (USD) | 540000 | 540,000 |
| B7 | Current FCF (USD) | =B5-B6 |
960,000 |
| B8 | FCF dollar change (USD) | =B7-B4 |
160,000 |
| B9 | Growth rate | =IF(B4<=0,NA(),B8/B4) |
20.0% |
Format B9 as a percentage. Microsoft's percentage guidance uses the same new-minus-old, divided-by-old structure. The guard in B9 deliberately returns #N/A for a nonpositive base; it prevents a dashboard from displaying a misleading conventional growth rate. Covirage is not affiliated with Microsoft.
The change in FCF must equal the operating cash flow change minus the capex change:
| Bridge item | Calculation | Effect on FCF (USD) |
|---|---|---|
| Prior FCF | From Q3 2025 | 800,000 |
| Operating cash improvement | 1,500,000 - 1,200,000 | 300,000 |
| Additional cash capex | -(540,000 - 400,000) | -140,000 |
| Current FCF | 800,000 + 300,000 - 140,000 | 960,000 |
The bridge closes to the current-quarter calculation. A second check reverses the rate: 800,000 x (1 + 20.0%) = $960,000. If either check fails, inspect the period mapping or sign convention before interpreting growth.
Next, explain the operating cash change using the supplied cash flow statement. The SEC's financial statement guide explains how operating cash adjusts net income for noncash items and operating assets and liabilities. Faster customer collections can improve the quarter without a matching profit increase; a delayed supplier payment can do the same temporarily.
Consider these separate cases. The arithmetic works, but the conventional percentage tells an unhelpful story.
| Case | Prior FCF (USD) | Current FCF (USD) | Change (USD) | Formula output |
|---|---|---|---|---|
| Crosses into positive cash | -200,000 | 100,000 | 300,000 | -150.0% |
| Cash deficit narrows | -200,000 | -100,000 | 100,000 | -50.0% |
| Starts at zero | 0 | 100,000 | 100,000 | Undefined |
Describe the first case as a $300,000 improvement that moved FCF into positive territory. Describe the second as a $100,000 reduction in the cash deficit. Dividing by the absolute value of the base creates a different measure; do not silently relabel it as conventional FCF growth.
Bring your period cash-flow export and capital-spending schedule to Covirage. Covirage maps the columns; its tools compute and check the period figures and driver bridge, while the external AI model explains the result with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring a sample of your own data.
See FP&A reporting for the wider reporting context.
Yes. When the prior period has positive free cash flow and the current period produces less, the growth rate is negative. Review operating cash flow and capital spending separately before deciding whether the decline reflects weaker operations or investment timing.
The percentage is undefined because the denominator is zero. Report the prior and current dollar amounts, their difference, and the operating-cash and capital-spending changes. Do not replace an undefined result with zero percent.
Either comparison can be useful when labeled clearly. A same-quarter comparison helps control for seasonal patterns. A sequential comparison highlights recent movement, but payment timing can make it volatile. Keep the period length and calculation policy consistent.
No. Growth compares free cash flow between periods. Conversion compares cash generation with a chosen earnings measure within a period. A business can improve its conversion while producing less free cash flow if its earnings base shrinks.