Escalon Business Services Team Manager Interview Questions and Answers

It was an aptitude test with basic SQL and Python based questions

It was an SQL round with questions from Hackerrank (Medium Complexity)

It was a Whiteboarding Interview with Partner on Pyspark and Pandas

Q1. Ways to fill a null value in SQL
Ans. 
Use COALESCE function, UPDATE statement, or CASE statement to fill null values in SQL.
• Use COALESCE function to replace null values with a specified default value

• Use UPDATE statement to update null values with a specific value

• Use CASE statement to conditionally fill null values based on certain criteria
Answered by AI
Add your answer
Q2. Window functions
Add your answer

Q1. Professional growth
Add your answer

Analytical and writing test need to take lots of practice test in order to do well

Q1. Walk me through cv with details
Add your answer
Q2. She asks personal questions and salary
Add your answer
Q3. Also be ready for expected salary
Add your answer

Q1. Ai use case in fp&a
Ans. 
AI in FP&A can be used for predictive analytics, forecasting, and scenario planning.
• AI can analyze historical financial data to predict future trends and outcomes.

• AI algorithms can be used to forecast sales, expenses, and cash flow with greater accuracy.

• AI can help in scenario planning by simulating different financial scenarios and their potential impact.

• AI can automate repetitive tasks like data entry, freeing up tim
Answered by AI
Add your answer

Q1. L1-5 FP&a process
Add your answer

Q1. Basic technical questions
Add your answer

Q1. Purely technical
Add your answer

Q1. With Executive Director
Add your answer

Quantative analysis questions were asked

Q1. IFRS 15 steps required for revenue assessment
Ans. 
IFRS 15 outlines five steps for revenue recognition
• Identify the contract with the customer

• Identify the performance obligations in the contract

• Determine the transaction price

• Allocate the transaction price to the performance obligations

• Recognize revenue when (or as) the entity satisfies a performance obligation
Answered by AI
Add your answer
Q2. IFRS 16 assessment for leases
Ans. 
IFRS 16 assessment for leases
• IFRS 16 is a new accounting standard for leases

• It requires lessees to recognize all leases on their balance sheet

• Lessees must assess whether a contract contains a lease

• IFRS 16 impacts financial statements and key performance indicators

• Companies must ensure compliance with the new standard
Answered by AI
Add your answer

Q1. What is DCF valuation
Ans. 
DCF valuation is a method used to estimate the value of an investment based on its expected future cash flows.
• Discounted Cash Flow (DCF) valuation involves forecasting future cash flows of an investment and discounting them back to present value using a discount rate.

• It is commonly used in finance to determine the intrinsic value of a company or asset.

• DCF valuation helps investors make informed decisions about whether ...read more
Answered by AI
Add your answer
Q2. How to value a business
Ans. 
Valuing a business involves analyzing its financial statements, market position, growth potential, and industry trends.
• Consider the company's revenue, profits, and assets to determine its financial health.

• Evaluate the market demand for the company's products or services.

• Assess the company's competitive position and market share.

• Factor in the potential for future growth and expansion.

• Compare the business to similar comp...read more
Answered by AI
Add your answer

Q1. Different valuation techniques
Ans. 
Valuation techniques are methods used to determine the value of a company or asset.
• Comparable company analysis (CCA)

• Discounted cash flow (DCF) analysis

• Asset-based valuation

• Earnings multiple approach

• Liquidation valuation
Answered by AI
Add your answer