Oxane Partners
Interview Questions and Answers
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 moreFinancial 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
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?
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
Q3. How do you arrive at the terminal growth rate while preparing a financial model?
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
Q4. What do you understand by loan servicing?
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.
Q5. What is securitization?
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
Q6. Explain indirect and offset functions in excel
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
Q7. SWOT ANALYSIS and ability to gel up with the organisation
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
Q8. what is vlookup
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
Top Senior Analyst Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month