Sign Up, Its Free

We have launched one more exciting feature on the site!! Now, as a Vendor apart from selling tools and templates, you can also provide hourly consultation!

Vendors who will register with us until 30.09.2020, will get the benefit of "subscription-free" registration. Vendors who are registering post 30.09.2020 might have to pay a yearly subscription fee for using our platform. So, get registered soon and spread the word.

We are launching with few Categories... However, we will be continuously multiplying our bucket list with exciting categories and sub-categories of different fields and professions!!

If you are a Vendor looking to sell tools in any specific category which is not present at the moment on our platform, for instance, say "Branding and Strategy." Simply, email us along with one of your sample business tools on "support@icrestmodels.com" and we will add the same after verifying.

We have our showcased inventory as well so that the upcoming vendors can view the quality of business tools we are looking for.

What's New

Single Sheet DCF (Discounted Cash Flow) Excel Template

Type of Business : Excel Tools and Wizard

Price : USD 0 0.00

Need More Clarifications/Customized Tool? Generate Ticket

Add to Wishlist icrest approved product

  • Short Description

    Single sheet DCF Template helps the user understand the dynamics of Discounted Cash Flow (DCF) valuation. Single Sheet DCF Template aims to appraise user with DCF Fundamentals. This tool can be used for understanding the concept of DCF valuation.

  • Full 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 assess 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 represent assumptions cells and white color cells with black text represent calculation cells. This business tool includes 1 Excel File

  • Table of Content
    No. Content
    Single Sheet DCF (Discounted Cash Flow) Excel Template Single sheet DCF Template helps the user understand the dynamics of Discounted Cash Flow (DCF) valuation
  • Reviews

    parviz syed

    great ..comprehensive


Related Products