Cash Flow Return on Investment (CFROI) for a Firm Excel Model

The user must define the following inputs:

- Fixed Assets

- Non-cash working capital

- Capitalized Operating leases

- Accumulated Depreciation on Assets

- Average Life of Assets

- Inflation rate (annual) during asset life

- Remaining Life of Assets

- Salvage value at end of life (as %)

- Current EBIT

- Current Depreciation

- Marginal Tax rate

- Nominal cost of capital

- Prof. Aswath Damodaran

Side note: If you have appreciated this model, feel free to give it a rating/review!