Add office photos
Employer?
Claim Account for FREE

Oxane Partners

3.7
based on 66 Reviews
Filter interviews by

Interview Questions and Answers

Updated 5 Feb 2024
Popular Designations

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

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 valuation methods include comparable company analysis (CCA) and...read more

Add your answer

Q2. 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?

Ans.

Light both ropes at the same time, when the first rope burns out, light the other end of the second rope.

  • Light both ropes at the same time

  • When the first rope burns out, light the other end of the second rope

  • The 45 seconds mark is when the second rope burns out completely

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 uncertainty and sensitivity analysis

Add your answer

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

Add your answer
Discover null interview dos and don'ts from real experiences

Q5. 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 assets.

  • Securitization can help to increase liquidity in the m...read more

Add your answer

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

  • Example: =INDIRECT("A1") will reference the cell A1, while =OF...read more

Add your answer

Q7. 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 to changes in the organization's goals and priorities.

  • I h...read more

Add your answer

Q8. 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 column

View 1 answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Senior Analyst Interview Questions from Similar Companies

3.6
 • 48 Interview Questions
4.0
 • 17 Interview Questions
3.6
 • 11 Interview Questions
4.0
 • 11 Interview Questions
3.7
 • 10 Interview Questions
3.3
 • 10 Interview Questions
View all
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter