Dataford
Dataford
Top 50
Prep plan
Updated weekly · Last refresh Oct 17

Morgan Stanley Financial Analyst Interview Questions

The questions to prepare for a Morgan Stanley Financial Analyst interview. Questions from real interview reports rank first. Updated daily.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
StrategyStart here. 18 questions · ~144 min
Tell Me About YourselfEasy
Recently asked

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive AnalysisMorgan Stanley
Moats for Surgical RobotsHard
Recently asked

Evaluates industry analysis and competitive advantage reasoning.

market analysisindustry knowledgeMorgan Stanley
More Strategy questions with a free account
2
Finance & Accounting18 questions · ~144 min
Link Between Income Statement and Cash FlowMedium
Recently asked

Evaluates ability to connect accrual accounting to cash flows and interpret EBITDA.

Financial StatementsMorgan Stanley
Riddles and Market StatsMedium
Recently asked

Tests composure, structured thinking, and ability to reason under uncertainty.

Morgan Stanley
More Finance & Accounting questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
SQL & Data Manipulation4 questions + 3 drills · ~62 min
Traverse Outside Nodes of a TreeMedium
Recently asked

Tests algorithmic thinking and ability to design a traversal approach.

AlgorithmsMorgan Stanley
Algorithms: Stack, Queue, SortingMedium
Recently asked

Assesses your grasp of core data structures and algorithm concepts.

Data StructuresAlgorithmsMorgan Stanley
Top Clients by Region SQLMedium
Practice
Practice drill

Find the top three spending clients in each region during the previous calendar quarter.

Window FunctionsDate Functionsfinancial dataMorgan Stanley
Optimizing a Slow QueryMedium
Practice
Recently asked
Practice drill

Rewrite a slow PostgreSQL reporting query to reduce scanned rows, avoid join multiplication, and return accurate monthly site metrics.

Subqueriesdatabase optimizationJoinsContinental FinanceCapgeminiDISH
SQL IndexingHard
Practice
Recently asked
Practice drill

Use a representative PostgreSQL query to evaluate indexing choices for active accounts and recent trade orders.

database optimizationlarge datasetsindexesMorgan Stanley
More SQL & Data Manipulation questions with a free account
4
Statistics & Probability5 questions · ~40 min
Present Value ScenariosMedium
Recently asked

Assesses cash flow extrapolation and discounting intuition.

Morgan Stanley
Broken Clock RiddleMedium
Recently asked

Evaluates logical reasoning and ability to solve structured puzzles.

Morgan Stanley
More Statistics & Probability questions with a free account
5
Behavioral & Leadership5 questions · ~40 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.