Excel Modeling Interview Questions for a CF Analyst Position

Hi all,

I am a Management Consultant who is trying to pivot into a career in corporate finance. I have my first interview next week and was told there would be technical questions around excel modeling and finance knowledge. My undergrad background is in accounting and finance, so I am confident that after some studying/reviewing I will be able to speak intelligently on finance concepts. My main concern is with the excel modeling. I use excel in consulting, but definitely not to the extent of financial modeling. I know basic pivot tables, lookups and (very basic) macros. What should I look into studying specifically? I was told that the entire company runs on the finance team's models, so I want to make sure I can speak to these models at a some what intelligent level.

Thanks!

PS: I've looked through alot of the WSO templates, but there are just so many I want to know if there is anything specific (Balancesheet ratios/ income statement ratios) that I can focus on.

Thanks!

3 Comments
 
Most Helpful

Illo porro quo molestias voluptatum magni voluptas iste. Sed tempora rem eos deleniti quod sint veniam commodi. Cum quam eos odit quibusdam quo consequatur molestiae illum.

Corp. Fin. Analyst currently working two finance jobs (and a teaching gig and trying to save my music production solo career). I love avocado's. And yes Cape Town is the most beautiful place in the world. Don't believe me, come thru and find out.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Goldman Sachs 01 97.8%
  • Guggenheim Partners No 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

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

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.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (23) $182
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (81) $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
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
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...”