Calculation guide
Net borrowing equals new debt less principal repayments. Assume immediate use of tax shields.
Inputs
Operating profit (EBIT)
Example entry 200 (in the selected currency).
Tax rate
Example entry 25 %. Allowed range 0 to 100.
Depreciation and amortization
Example entry 25 (in the selected currency).
Capital expenditure
Example entry 50 (in the selected currency).
Increase in working capital
Example entry 15 (in the selected currency).
Interest expense
Example entry 20 (in the selected currency).
Net borrowing
Example entry 5 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Operating profit (EBIT) | 200 |
| Tax rate | 25% |
| Depreciation and amortization | 25 |
| Capital expenditure | 50 |
| Increase in working capital | 15 |
| Interest expense | 20 |
| Net borrowing | 5 |
| Result | Value |
|---|---|
| Free cash flow to firm | 110 |
| Free cash flow to equity | 100 |
Calculation steps
Free cash flow to firm = ((((Operating profit (EBIT) × (1 − (Tax rate ÷ 100))) + Depreciation and amortization) − Capital expenditure) − Increase in working capital)
((((200 × (1 − (25 ÷ 100))) + 25) − 50) − 15) = 110
Free cash flow to equity = ((Free cash flow to firm − (Interest expense × (1 − (Tax rate ÷ 100)))) + Net borrowing)
((110 − (20 × (1 − (25 ÷ 100)))) + 5) = 100
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Operating profit (EBIT) | 200 | 220 | Free cash flow to firm | 110 | 125 |
| Tax rate | 25% | 28% | Free cash flow to firm | 110 | 104 |
| Depreciation and amortization | 25 | 28 | Free cash flow to firm | 110 | 113 |
| Capital expenditure | 50 | 55 | Free cash flow to firm | 110 | 105 |
| Increase in working capital | 15 | 17 | Free cash flow to firm | 110 | 108 |
| Interest expense | 20 | 22 | Free cash flow to equity | 100 | 98.5 |
| Net borrowing | 5 | 6 | Free cash flow to equity | 100 | 101 |
