S&P Global Data Analyst Interview Questions, Process, and Tips

Q1. Previous Jobs and Salary discussion
Add your answer

English Language, Excel and word shortcuts,

Q1. Disscussion about previous job and present.
Add your answer
Q2. Previous job roles
Add your answer

Duration -1 hr
AGM related question.
equity calculation, derivatives, shares allocation, Accounting Knowledge.

Q1. Salary negotiation and they ask whether you'll be able to come to office on anchor days.
Add your answer

Q1. How to find P/E of a company
Ans. 
To find the P/E of a company, divide the current stock price by the earnings per share (EPS).
• P/E ratio = Current Stock Price / Earnings Per Share (EPS)

• Current Stock Price can be found on financial websites or platforms

• Earnings Per Share (EPS) can be obtained from the company's financial statements

• Compare the P/E ratio with industry averages to assess valuation
Answered by AI
Add your answer
Q2. Price/earnings is the equation
Add your answer

Mediocre aptitude test with 50 financial questions, 20 aptitude and reasoning, and 10 comprehensive, all within 90 mins

Q1. What is EPS, DPS
Ans. 
EPS stands for Earnings Per Share and DPS stands for Dividends Per Share.
• EPS is a financial metric that measures the amount of profit a company has earned per share of its outstanding common stock.

• DPS is the amount of dividends paid out per share of common stock.

• EPS is used to evaluate a company's profitability and is often used by investors to determine the value of a company's stock.

• DPS is an important metric for inv...read more
Answered by AI
Add your answer
Q2. What is red hearing?
Ans. 
Red herring is a misleading clue or piece of information that diverts attention from the actual issue.
• It is a tactic used in debates, investigations, and storytelling.

• It is intentionally used to mislead or distract the audience.

• Examples include false leads in detective stories and irrelevant arguments in debates.

• The term originated from the practice of using smoked herrings to distract hunting dogs.
Answered by AI
Add your answer
Q3. What is current ratio & PE raio
Ans. 
Current ratio is a liquidity ratio that measures a company's ability to pay short-term obligations. PE ratio is a valuation ratio that compares a company's current share price to its per-share earnings.
• Current ratio = Current assets / Current liabilities

• PE ratio = Market value per share / Earnings per share

• Current ratio indicates the company's ability to pay off its short-term liabilities

• PE ratio indicates how much inv...read more
Answered by AI
Add your answer

Conversing in English is positive/good for MNC?

Q1. Ratio fixed or floating interest rate basic financial knowledge ratios
Add your answer

Q1. What according to you is financial Market?
Ans. 
Financial market is a platform where buyers and sellers trade financial assets such as stocks, bonds, currencies, and commodities.
• Financial market facilitates the exchange of financial assets between buyers and sellers

• It includes stock markets, bond markets, currency markets, and commodity markets

• Financial market plays a crucial role in the economy by allocating capital to businesses and governments

• Examples of financia...read more
Answered by AI
Add your answer

Q1. Describe uses of V-lookup and H-lookup
Ans. 
V-lookup and H-lookup are Excel functions used to search for specific data in a table and return corresponding values.
• V-lookup searches for a specific value in the leftmost column of a table and returns a corresponding value from a specified column to the right.

• H-lookup searches for a specific value in the top row of a table and returns a corresponding value from a specified row below.

• Both functions are commonly used i...read more
Answered by AI
Add your answer
Q2. What is primary market and secondary market
Ans. 
Primary market is where new securities are issued and sold for the first time, while secondary market is where already issued securities are traded among investors.
• Primary market is also known as the new issue market.

• Companies issue securities in the primary market to raise capital.

• Investors buy securities in the primary market directly from the issuer.

• Secondary market is also known as the stock market.

• Investors buy an...read more
Answered by AI
Add your answer