Help with 10 year DCF (EXCEL ATTACHED)

I am trying to do a DCF valuation on DuPont, but my enterprise value is really small compared to the # of shares outstanding. I used a template off stockodo. Please lead me in the right direction. Thanks! I have a worksheet called "Discounted Cash Flow modified" - that sheet includes Net non-op L (G) and Other Non-Cash Adjustments, but the help I am asking for you is for the worksheet called, "Discounted Cash Flow". If you could please help me I shouldn't be getting a book value of ~9.

Few extra points: 1. The FCF are different on Bloomberg, but I am following the steps off stockodo. 2. I added the extra factors in "Discounted Cash Flow modified" to see if I could get a more accurate number, because anything with %5 of total revenue should be significant I believe. You do not have to work out the DCF on this sheet if you do not want to and just follow it like the stockodo worksheet called, "Discounted Cash Flow". 3. Duponts Enterprise value is like 73B but that is because that is not from doing a dcf that is from stock MC + Debt - Cash. 4. DuPonts P/B value is ~5 so does this mean that the stock should be worth around $15 if it was trading at say $75.

Thanks!

Please let me know how to fix the sheet called "Discounted Cash Flow" for DuPont THANKS.

Attachment Size
DD_DCF.xls 92.5 KB 92.5 KB
 

My modified version is way better. I realize that I did not change the CAPEX % change inputs thanks. I got a PT of around 40 for the DCF worksheet and a PT of $50 for the modified version. I also changed the LT growth to 4% and I will change a few things instead of having constant growth through out all the periods.

Thanks to posting this online I was able to see where I made a mistake. I was stuck on it for too much time and it bothered me so I posted it up here. TY

 

Dolorem voluptas fugit dolor animi soluta. Deleniti autem autem neque velit et aut. Repellendus autem et harum aut pariatur autem aut est. Recusandae enim est nisi beatae odit nostrum.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
kanon's picture
kanon
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”