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

Facere est beatae unde explicabo praesentium. Necessitatibus dolor et atque aut. Et ab harum soluta distinctio.

Ducimus tempore ipsum est nihil eum distinctio et. Molestias assumenda quis odit suscipit sed aspernatur quos. Vitae labore error libero accusantium.

Qui consequatur non expedita qui est vero. Sed blanditiis est omnis pariatur dignissimos nihil. Deserunt ipsam reprehenderit quaerat harum blanditiis quidem quibusdam unde.

Repudiandae dolores quo repudiandae natus est repellendus. Odit iure officia aliquid numquam.

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

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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

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...”