Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Banner Image

MMPA 2022 Integrated Case Competition

A guide to company and industry research for MMPA 2022 students participating in the Integrated Case Competition

DISCOUNT CASH FLOW TEMPLATE

FactSet's Discounted Cash Flow template provides a summary of different valuation multiples based upon projected cash flows.

1. Load the desired company by clicking on the magnifying glass icon beside the 'Identifier' box.  A separate window will open for searching and selecting the appropriate company.  Click the 'Finish' button to load the company.  The spreadsheet will then refresh with new data for the identifier.
2.

Scroll down to the 'Value Drivers' section to review the default inputs for these fields:

  • Revenue Growth
  • EBIT Growth
  • Tax Rate
  • Depreciation & Amortization Growth
  • Working Capital Growth
  • CapEx Growth
3. If you want to model DCF with different inputs, modify the data in the blue cells found in each 'User Input' row.  Think carefully about the assumptions implicit in the defaults - and about any changes you make!
4. Scroll up to the top of the spreadsheet.  Use the menus besides each of the categories to select 'User Input' if you made changes to the data items in the 'Value Drivers' section.  You can also use the toggle menus to change the 'WACC or IRR' and 'Terminal Value Multiple' rates in this section.
5. Select the 'Home' button to select another template.

FactSet's Discounted Cash Flow Analysis template

 

FactSet's Discounted Cash Flow Analysis: Value Drivers