FCFE Calculator

How to use the FCFE calculator

What this calculator does

This calculator estimates free cash flow to equity, the cash flow attributable to common equity holders after the operating result is adjusted for reinvestment needs and net debt financing. It supports five standard starting points so you can work from the line items available in a company's statements: Net income, EBIT, EBITDA, Cash flow from operations (CFO), or Free cash flow to firm (FCFF). The result is an analytical cash-flow identity, not a stock-price target, dividend forecast, or recommendation. For the valuation context behind the measure, see the CFA Institute overview of free-cash-flow valuation.

When to use it

Use FCFE when you want to compare a company's reported earnings with cash potentially available to shareholders, reconcile equity cash flow from different financial-statement starting points, examine how capital spending or working-capital needs affect equity cash generation, or prepare a cash-flow input for an equity-focused discounted cash-flow analysis. It is especially useful when dividends do not closely track the cash the business could theoretically distribute.

How to calculate

1. The calculator opens with a complete demonstration data set and an immediately available example XLSX workbook. Start by choosing a Calculation method that matches the source figure you have.
2. Replace the visible method-basis amount and the required debt and adjustment fields with values from the same reporting period. Use U.S.-style numbers: a decimal point for decimals and optional comma thousands separators. Currency symbols are shown beside money fields, so they do not need to be typed.
3. Read Free cash flow to equity (FCFE) together with Net borrowing and any applicable Reinvestment outflow or After-tax interest. The breakdown table shows every signed component in the selected identity.
4. Select Download Excel to export the current validated model as a real XLSX workbook. Reset clears the demonstration/input data rather than restoring it, so Download Excel may be disabled until you enter a complete valid state again.

Input guide

Calculation method is required and selects the formula branch. Net income is a required currency amount for the Net income method; the example is $56,000,000, and a higher value raises FCFE dollar-for-dollar. EBIT is required for the EBIT method; the example is $95,000,000, and it is multiplied by one minus the tax rate before the remaining adjustments. EBITDA is required for the EBITDA method; the example is $145,000,000, and the formula separately recognizes the depreciation tax effect. Cash flow from operations (CFO) is required for the CFO method; the example is $81,000,000, and FCFE then deducts fixed capital investment and adds net borrowing. Free cash flow to firm (FCFF) is required for the FCFF method; the example is – $8,500,000, and negative values are permitted because firm cash flow can be negative.

Beginning total debt and Ending total debt are required nonnegative currency balances for every method; the example uses $110,000,000 and $134,000,000. Their difference is Net borrowing, so more ending debt relative to beginning debt raises FCFE in this identity, while debt repayment lowers it. Do not enter debt issued during the period in one field and a balance-sheet debt balance in the other; both must be comparable period-end balances. Depreciation and amortization is a required nonnegative currency amount for the Net income, EBIT, and EBITDA methods; the example is $50,000,000. Fixed capital investment is a required nonnegative currency outflow for Net income, EBIT, EBITDA, and CFO; the example is $100,000,000, and a higher value reduces FCFE. Working capital investment is required for Net income, EBIT, and EBITDA; the example is $25,000,000, and a higher investment reduces FCFE. Interest expense is required and nonnegative for EBIT, EBITDA, and FCFF; the example is $15,000,000. Corporate tax rate is required for those same methods, accepts 0% through 100%, and is 30% in the example. Typing scientific notation or an ambiguous decimal comma is rejected rather than silently reinterpreted.

Output guide

Free cash flow to equity (FCFE) is the primary currency result. Positive FCFE means the modeled period leaves cash available to equity after the stated reinvestment and financing effects; zero means the components exactly offset; negative FCFE means the modeled needs exceed the starting cash-flow basis. Net borrowing is Ending total debt minus Beginning total debt and can be positive, zero, or negative. Reinvestment outflow is the applicable capital-investment burden shown for the selected method: fixed capital plus working capital for Net income, EBIT, and EBITDA, fixed capital alone for CFO, and not applicable to the FCFF conversion. After-tax interest equals Interest expense multiplied by one minus Corporate tax rate and is shown for EBIT, EBITDA, and FCFF. The header pills repeat the selected Method, Net borrowing, and the most relevant adjustment for quick scanning. In the Calculation breakdown, Component names the term, Role explains its sign or purpose, and Amount shows the exact signed currency contribution used by the model.

Worked example

The first-open example uses the Net income method with Net income of $56,000,000, Depreciation and amortization of $50,000,000, Fixed capital investment of $100,000,000, Working capital investment of $25,000,000, Beginning total debt of $110,000,000, and Ending total debt of $134,000,000. Net borrowing is therefore $24,000,000. Applying the identity gives $56,000,000 + $50,000,000 – $100,000,000 – $25,000,000 + $24,000,000 = $5,000,000.00 FCFE. The demonstration also stores consistent EBIT, EBITDA, CFO, FCFF, interest, and tax-rate values, so switching methods preserves the same $5,000,000 result when the inputs describe the same underlying company period.