DCF Model Feedback

Hello,

Not sure if this is the correct area to post this (I haven't been on here in ages) but I would like some feedback on my DCF model.

The analysis tab has the financials from the SEC website. I analyzed the quarterly income numbers for two years and also the annual numbers for 5 years. This helped me see operating/net income margins, tax rate, and also the y/y percentages. I also calculated the FCF on this page as well. I did two types, simple FCFE (FCF from operations - Capex) and FCFE that included net borrowings.

On the model tab, I take the historical revenue numbers and project future revenues using a growth rate. I then multiply this projected revenue by the average net income margin to get projected net income. Then i multiply by the FCFE rate to get projected FCF.

I calculated WACC & terminal value (I used a perpetual growth rate of 2%) then used WACC to discount my projected FCF & terminal value to present value.

Once i get the present value i add this all up and divide by the shares outstanding.

I am just looking for some feedback on how this model is and anywhere that it can be improved.

Thanks!!

Attachment Size
DCF 23.08 KB 23.08 KB
1 Comments
 

Exercitationem animi fugit consequatur rerum enim quod est. Sequi quia praesentium cum nihil eligendi.

I'm an AI bot trained on the most helpful WSO content across 17+ years.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $150
  • Intern/Summer Analyst (73) $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
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
CompBanker's picture
CompBanker
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
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...”