Skip to content
Felix
  • Topics
    • My List
    • Felix Guide
    • AI
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Industrials
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
    • What’s The Big Deal?
  • Pathways
  • Certified Courses
  • Ask An Instructor
  • Support
  • Log in
  • NEW Signal AI
  • Topics
    • My List
    • Felix Guide
    • AI
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Industrials
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
    • What’s The Big Deal?
  • Pathways
    • Asset Management
    • CFA Institute
    • Commercial Banking
    • Credit Analysis
    • Engineering
    • Equity Research
    • Investment Banking
    • Operations
    • Private Equity
    • Restructuring
    • Sales and Trading
    • Venture Capital
  • Certified Courses
  • NEW Signal AI
Felix
  • Data
    • Company Analytics
    • My Filing Annotations
    • Market & Industry Data
    • United States
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
    • Europe
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
  • Models
  • Account
    • Edit Profile
    • Manage Account
    • My List
    • Restart Homepage Tour
    • Restart Company Analytics Tour
    • Restart Filings Tour
  • Log in
  • Ask An Instructor
    • Glossary
    • Email Our Experts
    • Felix User Guide
    • Contact Support

DCF Challenge - ATI Inc

Felix DCF Challenge asks participants to do a discounted cash flow using live data from Felix. Numbers are checked using the growth of invested capital as an important metric to get consistent growth in the free cash flow values and in the terminal value. The solution we are giving you is at May 14 2025. Your numbers will look a bit different if you are using live financial data, but your overall conclusion and analysis should be the same.

Unlock Your Certificate   
 
0% Complete

7 Lessons (27m)

Show lesson playlist
  • Description & Objectives

  • 1. Briefing Call - DCF Felix Challenge

    03:06
  • 2. DCF - Requirements

    03:17
  • 3. DCF - Historicals From Felix

    03:36
  • 4. DCF - Forecast Assumptions

    07:48
  • 5. DCF - WACC

    02:43
  • 6. DCF - Discounting to Enterprise Value

    01:27
  • 7. DCF - EV Bridge Using Felix, and Outputs

    05:06

DCF - Requirements

  • Notes
  • Questions
  • Transcript
  • 03:17

Setting up and discussing the requirements as set by an MD. A review of the estimates and assumptions given to us by the company's management, and looking at what will have to be filled by us.

Downloads

Felix DCF Challenge HandoutATI Felix Data
Back to top
Financial Edge Training

© Financial Edge Training 2026

California Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices
Topics
Introduction to Finance Accounting Financial Modeling Valuation M&A and Divestitures Private Equity
Venture Capital Project Finance Credit Analysis Transaction Banking Restructuring Capital Markets
Asset Management Risk Management Economics Data Science and System
Request New Content
System Account User Guide Privacy Policy Terms & Conditions Log in
Transcript

In this session, we'll look at the Felix DCF challenge. If you want to pause the recording for a moment, read through this handout and then come back and we'll look at some noteworthy items. Okay, so we're looking at ATI and we need to do a DCF on them. The CEO is keen to understand whether the company's current market valuation reflects the changes that are going on. It's important to realize that the solution we're giving you here is at a very particular date. Your numbers will look a bit different because you are using live financial data, but your overall conclusion and analysis should be the same, albeit at a different date. Okay, so if we have a quick look down, we're told we're valuing as at the 1st of January 25. It's an eight year DCF. We're going to use the growing perpetuity formula for terminal value and ultimately we want to look at an implied share price. We will then compare that to the company's real share price as of today, as of the day that I'm recording this, and we'll look at an implied EV EBITDA multiple and again, compare that to the real multiples happening today. Now we need to spend quite a bit of time coming up with the assumptions in the DCF, but we've been given some guidance. Management expects revenue growth of circa 8% per annum over the next few years, and eight year revenue CAGR of 6%. So we're going to have to bridge the gap between those two numbers. We're then given some EBITDA margins. That's great. CapEx will be elevated. That's great. We can easily put those numbers in. Tax operating working capital and the JV, no real issues, but then randomly we're told for the company's main competitors. Now that is interesting, we're going to have to use that in just a moment. We're then told when building the DCF obtained the required year 24 financial statements. Now why do we need that? Well, we're going to take the old revenue in year 24 and we'll grow that and it'll enable us to calculate free cash flow in year 24 and then compare that to 25 and we can use that as a sense check. We're then told you don't have to build a three statement model. Great. But we do want to monitor the invested capital growth. Now this feels like the MD has just kind of thrown this in. It feels like it's a bit of an aside, but this is actually insanely important to any good DCF model. We have to model how quickly the invested capital is growing. If it's growing way too fast or if it's going way up and then down and up and down, it means there's something wrong with our DCF free cash flows. So we definitely need to monitor that. We're going to spend quite a bit of time looking at that. We then need to calculate that WACC. Now we're told some specifics. We'll use a custom equity risk premium of 5%. We'll put that into Felix, but then we're told to come up with an industry beta based on identified peers. We are going to use these specific peers mentioned up at the top here. We'll put them into Felix, and Felix will then calculate the required beta for us.

AI for Analysts Series - Accelerate your workflows with Claude, ChatGPT, Endex and more. Watch the recordings!

Content Requests and Questions

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account
Help

You need an account to contact support.

Create a free account or log in to an existing one

Sorry, you don't have access to that yet!

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account

You have reached the limit of annotations (10) under our premium subscription. Upgrade to unlock unlimited annotations.

Find out more about our premium plan

You are trying to access content that requires a free account. Sign up or login in seconds!

Create a free account or log in to an existing one

You are trying to access content that requires a premium plan.

Find out more about our premium plan or log in to your account

Only US listed companies are available under our Free and Boost plans. Upgrade to Pro to access over 7,000 global companies across the US, UK, Canada, France, Italy, Germany, Hong Kong and more.

Find out more about our premium plan or log in to your account

A pro account is required for the Excel Add In

Find out more about our premium plan

Congratulations on completing

Name(Required)
Rate this course out of 5, where 5 is excellent and 1 is terrible.
Were the stated learning objectives met?(Required)
Were the stated prerequisite requirements appropriate and sufficient?(Required)
Were the program materials, including the qualified assessment, relevant and did they contribute to the achievement of the learning objectives?(Required)
Was the time allotted to the learning activity appropriate?(Required)
Are you happy for us to use your feedback and details in future marketing?(Required)

Thank you for already submitting feedback for this course.

CPE

What is CPE?

CPE stands for Continuing Professional Education, by completing learning activities you earn CPE credits to retain your professional credentials. CPE is required for Certified Public Accountants (CPAs). Financial Edge Training is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.

What are CPE credits?

For self study programs, 1 CPE credit is awarded for every 50 minutes of elearning content, this includes videos, workouts, tryouts, and exams.

CPE Exams

You must complete the CPE exam within 1 year of accessing a related playlist or course to earn CPE credits. To see how long you have left to complete a CPE exam, hover over the locked CPE credits button.

What if I'm not collecting CPE credits?

CPE exams do not count towards your FE certification. You do not need to complete the CPE exam if you are not collecting CPE credits, but you might find it useful for your own revision.


Further Help
  • Felix How to Guide walks you through the key functions and tools of the learning platform.
  • Playlists & Tryouts: Playlists are a collection of videos that teach you a specific skill and are tested with a tryout at the end. A tryout is a quiz that tests your knowledge and understanding of what you have just learned.
  • Exam: If you are collecting CPE points you must pass the relevant CPE exam within 1 year to receive credits.
  • Glossary: A glossary can be found below each video and provides definitions and explanations for terms and concepts. They are organized alphabetically to make it easy for you to find the term you need.
  • Search function: Use the Felix search function on the homepage to find content related to what you want to learn. Find related video content, lessons, and questions people have asked on the topic.
  • Closed Captions & Transcript: Closed captions and transcripts are available on videos. The video transcript can be found next to the closed captions in the video player. The transcript feature allows you to read the transcript of the video and search for key terms within the transcript.
  • Questions: If you have questions about the course content, you will find a section called Ask a Question underneath each video where you can submit questions to our expert instructor team.