CohnReznick Audit Analyst Interview Questions and Answers for Experienced

General questions like why valuations, what is FCFF, FCFE, DCF and their components, few ratios and relative valuation questions.

Company screening and industry analysis

Why valuations, DCF and learnings attitude

Q1. SQL related questions : 1.) Write the output of all 4 types of join b/w two tables having the same values. 2.) Case and when statement question. 3.) Ask to write group by statement. Python questions: 1...read more
Add your answer

Q1. Lookup Function in Excel
Ans. 
Lookup function in Excel helps to find specific data in a table or range of cells.
• Lookup function can be used to search for a specific value in a table or range of cells.

• VLOOKUP and HLOOKUP are two commonly used lookup functions in Excel.

• Lookup functions can be used to retrieve data from another worksheet or workbook.

• Lookup functions can also be used to perform approximate matches or exact matches.

• Lookup functions can
Answered by AI
Add your answer

Q1. About Yourself, Resume related questions, Future career plans
Add your answer

Q1. What is difference between calculated column and measure
Ans. 
Calculated columns are pre-defined while measures are dynamic calculations based on user input.
• Calculated columns are computed during data modeling and added to the table

• Measures are computed on the fly based on user input and can be changed dynamically

• Calculated columns are used for static analysis while measures are used for dynamic analysis

• Examples of calculated columns include concatenation of columns, while measur
Answered by AI
Add your answer

Q1. How do you see yours self in 3 years
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and experience working with large datasets

• I am proficient in statistical software such as R and Python

• I have a proven track record of delivering actionable insights to drive business decisions
Answered by AI
Add your answer

Q1. Questions regarding past work experience
Add your answer
Q2. How to handle a situation where you require a signature of important person who is in leave?
Ans. 
Delegate the task to a trusted colleague or use electronic signature if possible.
• Delegate the task to a trusted colleague who has the authority to sign in the absence of the important person.

• If electronic signature is an option, request the signature through email or a digital platform.

• If urgent, consider reaching out to the important person on leave through phone or email for alternative solutions.
Answered by AI
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. Why do you wish to switch your current role?
Add your answer

Q1. About prior experience, future career plans, Risk & Compliance, EY
Add your answer
Q2. What do you know about Regulations?
Ans. 
Regulations are rules and guidelines set by governing bodies to ensure compliance and safety in various industries.
• Regulations are enforced by government agencies to ensure compliance with laws and standards.

• They are designed to protect consumers, employees, and the environment.

• Examples include FDA regulations for food and drug safety, OSHA regulations for workplace safety, and EPA regulations for environmental protect...read more
Answered by AI
Add your answer