Cash Flow Return on Investment (CFROI) for a Firm Excel Model
Originally published: 12/07/2016 10:55
Last version published: 02/02/2018 14:50
Publication number: ELQ-46606-2
View all versions & Certificate
certified

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

This Excel model calculates CFROI (Cash Flow Return on Investment).

Description
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!

This Best Practice includes
1 Excel Model

Prof. Aswath Damodaran offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Outputs:
- Gross Investment (adjusted for inflation)
- Gross Cash Flow
- Expected Salvage Value
- Remaining Asset Life
- CF Return on Investment
- Real cost of capital


4.5 / 5 (71 votes)

please wait...