Single Sheet DCF (Discounted Cash Flow) Excel Template

Single sheet DCF Template helps the user understand the dynamics of Discounted Cash Flow (DCF) valuation

Description
Fin-wiser Advisory has developed the single sheet Discounted Cash Flow (DCF) Template to helps user to understand the dynamics of Discounted Cash Flow (DCF) valuation.

This template is designed to include one Actual period and ten forecast periods.

User can input various assumptions around Revenue Growth Rate, EBITDA Margin, Capital Expenditure, Working Capital Requirement and Depreciation & Amortization as a % of Revenue and other DCF components like Discount Rate, Terminal Growth Rate and Tax Rate to understand their impact on Intrinsic Value.

Template Calculates:
1. Free Cash Flow to Firms (FCFF) using the conventional equation starting from EBIT and adjusting for Taxes, Depreciation & Amortization, Capital Expenditure and Change in Working Capital.
2. Discount Rate for the calculation of present value of FCFF
3. Terminal Values based on perpetual growth rate
4. Enterprise Value
5. Implied Valuation Multiple like 'Enterprise Value/Revenue' and 'Enterprise Value/EBITDA'

User has the option to calculated discount rate and perpetual growth rate for three different steps to asses the impact of change in rate on terminal value.

Objective of this template is to appraise user with the discounted cash flow fundamentals and should not be used for valuation in real world scenario.

Yellow Color cells represents assumptions cells and white color cells with black text represents calculation cells.

This business tool includes
1 Excel File

Fin-Wiser Advisory offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

Single Sheet DCF Template aims to appraise user with DCF Fundamentals

This tool can be used for understanding the concept of DCF valuation

This tool should not be used for Real world DCF Valuation

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More tools from Fin-Wiser Advisory

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Single Sheet DCF (Discounted Cash Flow) Excel Template?

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

please wait...