Cash Flow Return on Investment (CFROI) for a Firm Excel Model
  • 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).

cash flowcfroifinancereturn 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 business tool includes
1 Excel Model

Prof. Aswath Damodaran offers you this business tool 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

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Cash Flow Return On Investment (CFROI) For A Firm Excel Model?

The user community and author are here to help. Go ahead!

please wait...