Quantitative Analyst Test Advice

Fellow Monkeys,

I have gone through a few phone interviews for a 'Quantitative Analyst' role at a locally based, but publicly traded, commercial bank, up here in Seattle. Interviews went well and now they want me to take an Excel-based exam. They are literally going to email me an Excel spreadsheet and 3-4 hours later I will send it back to them with the 'answers', 'formulae', etc.

Anyone ever had a test/exam like this for a similar position?

The bank specializes primarily in commercial banking. I do not believe they have an 'official' so to speak investment banking division. Nonetheless, The phone interviews asked a fair amount of questions regarding valuation, building a DCF, arriving at a discount rate, SQL, and derivatives in general.

The job mentions a lot of quant analysis regarding financial instruments...such as Mortgage Service Rights (MSR's), derivatives, fixed income securities, mortgage banking, etc...and managing interest rate risk to ID risks/strategies to protect/enhance the bank's earnings/equity.

Any thoughts? Would really appreciate any advice, suggestions, etc.

Thanks in advance.

0 Comments

Career Advancement Opportunities

June 2026 Investment Banking

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

Overall Employee Satisfaction

June 2026 Investment Banking

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

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (78) $151
  • Intern/Summer Analyst (72) $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
kanon's picture
kanon
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Linda Abraham's picture
Linda Abraham
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...”