Alchemy Research & Analytics Senior Analyst Interview Questions and Answers

Duration: 1 hour ,6 sections: Accounting, logical reasoning, excel, quants, current affairs and english

Q1. Self introduction, what does oxane partners do, tell us about academic projects, what are the other financial statements apart from p&l, balance sheet and cash flow, what is asset backed lending, what is S...read more
Add your answer
Q2. What is vlookup
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from a specified column.
• Used in Excel to search for a value in a table

• Returns a corresponding value from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for value in A2 in the table B2:D10 and returns value from the 3rd colum
Answered by AI
View 1 more answer

Moderate quant, general question may be defficult also the market awareness

Q1. Questions about Time Value of Money, 2008 Financial Crisis, Collateralization of Debt, other questions related to Finance and Credit
Add your answer

Q1. Questions consisting of Puzzles were asked
Add your answer

Q1. Sql, finance basic
Add your answer
Q2. Dcf,debt, npv, irr
Add your answer

Q1. Sql as a case study
Add your answer

Q1. What is securitization?
Ans. 
Securitization is the process of converting illiquid assets into marketable securities.
• Securitization involves pooling together assets such as mortgages, auto loans, or credit card debt.

• These assets are then sold to a special purpose vehicle (SPV) which issues securities backed by the cash flows from the assets.

• Investors can then buy these securities, which offer a return based on the cash flows from the underlying ass...read more
Answered by AI
Add your answer
Q2. Walk me through your CV
Add your answer
Q3. How do you arrive at the terminal growth rate while preparing a financial model?
Ans. 
The terminal growth rate is arrived at by considering the long-term growth prospects of the company.
• Consider the industry growth rate and the company's historical growth rate

• Analyze the company's competitive position and market share

• Evaluate the company's future investment plans and potential for expansion

• Take into account any regulatory or economic factors that may impact growth

• Use a range of values to account for unc
Answered by AI
Add your answer
Q4. If you have two ropes that burn in 60 seconds but not at the same rate. They burn unevenly. Given a match and the two ropes how would you figure out the 45 seconds mark?
Add your answer
Q5. Explain indirect and offset functions in excel
Ans. 
Indirect and Offset are functions in Excel used to reference cells or ranges indirectly.
• Indirect function is used to reference a cell or range using a text string that contains the cell or range address.

• Offset function is used to reference a cell or range that is a specified number of rows and columns away from a given cell or range.

• Both functions are useful for creating dynamic formulas that can be updated easily.

• Exam...read more
Answered by AI
Add your answer
Q6. What do you understand by loan servicing?
Ans. 
Loan servicing refers to the management of loans after they have been issued.
• It involves collecting payments from borrowers, managing escrow accounts, and handling delinquencies and defaults.

• Loan servicing can be done by the lender or a third-party servicer.

• Servicers may also provide customer service and support to borrowers.

• Examples of loan types that require servicing include mortgages, student loans, and auto loans.
Answered by AI
Add your answer

Q1. Explain 3 statement financial model Calculating discount rate Could you walk me through the DCF model? Other valuation methods. What PE is ideal? What is the other matrix to value the company? Difference ...read more
Ans. 
Financial analyst interview questions covering DCF model, valuation methods, bond yield, creditworthiness, and credit quality.
• Three statement financial model includes income statement, balance sheet, and cash flow statement.

• Discount rate is calculated using the weighted average cost of capital (WACC) or cost of equity.

• DCF model involves projecting future cash flows and discounting them back to present value.

• Other valua...read more
Answered by AI
Add your answer
Q2. Tell me about yourself. What was your role in the past internship Suppose you are investing in stock market, then what factors will you look for. Recent news you read and its impact on business I have ment...read more
Add your answer

Q1. Most questions in line with leverage ratios cash flows and Alternate investments like CDOs CLOs Debt and CRE MBS RMBS valuations etc.
Add your answer

Q1. SWOT ANALYSIS and ability to gel up with the organisation
Ans. 
SWOT analysis and ability to gel up with the organization are crucial for success in the role of Senior Analyst.
• I have experience in conducting SWOT analysis and have used it to identify areas of improvement and growth opportunities for the organization.

• I am a team player and have the ability to work collaboratively with colleagues from different departments and levels of seniority.

• I am adaptable and can quickly adjust...read more
Answered by AI
Add your answer