AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Cians Analytics Senior Analyst Interview Questions and Answers
8 Interview questions
Trading comps and transaction comps are valuation methods used in investment banking.
Trading comps involves comparing a company's financial metrics to those of its peers in the same industry.
Transaction comps involves analyzing the financial metrics of companies that have recently been acquired or sold.
Both methods are used to determine the value of a company in a potential merger or acquisition.
Trading comps are ...
WACC stands for Weighted Average Cost of Capital. It is the average cost of all the capital used by a company.
WACC is used to determine the minimum return a company must earn on its investments to satisfy its investors.
It is calculated by taking the weighted average of the cost of debt and the cost of equity.
The formula for WACC is: WACC = (E/V x Re) + ((D/V x Rd) x (1 - Tc)), where E is the market value of the co...
The 3 financial statements are linked through the flow of information and transactions between them.
The income statement shows revenue and expenses for a period of time, which affects the retained earnings on the balance sheet.
The balance sheet shows assets, liabilities, and equity at a specific point in time, which affects the cash flow statement.
The cash flow statement shows the inflow and outflow of cash during...
Minority interest refers to the ownership of less than 50% of a company's shares by an investor or group of investors.
It is also known as non-controlling interest.
The minority interest shareholders have limited control over the company's operations.
Their share of profits is proportionate to their ownership percentage.
Minority interest is reported on the balance sheet as a liability.
Example: If Company A owns 80% o...
Adj. EBITDA is calculated by adding back non-recurring expenses to EBITDA. Non-recurring items include one-time expenses or gains.
Adj. EBITDA = EBITDA + non-recurring expenses
Non-recurring items include one-time expenses or gains such as restructuring costs, legal settlements, or gains from asset sales
Non-recurring items are typically disclosed in the footnotes of financial statements
The treasury stock method is used to calculate the potential dilution of stock options and warrants. It assumes that the proceeds from the exercise of options and warrants are used to buy back shares at the average market price.
TSM calculates the dilutive effect of stock options and warrants
It assumes that the proceeds from the exercise of options and warrants are used to buy back shares at the average market pric...
Enterprise value is the total value of a company, including debt and equity.
EV is calculated by adding market capitalization, debt, and minority interest, and then subtracting cash and cash equivalents.
It represents the amount of money required to acquire the entire business.
EV is a more comprehensive measure of a company's value than market capitalization alone.
EV can be used to compare companies with different c...
I am a finance professional with expertise in financial projects, financial ratios, and their impact on share prices.
I have experience in leading finance projects from start to finish
I am well-versed in analyzing financial ratios and interpreting their implications
I understand how financial ratios can impact share prices and can provide insights on this
I have worked with various financial ratios such as liquidity ...
Cians Analytics Senior Analyst Interview Experiences
6 interviews found
Selected
I applied via LinkedIn and was interviewed in Jul 2022. There were 3 interview rounds.
Asked to create a financial model
(2 Questions)
- Q1. 1) Basic related to DCF and Financial Modelling
- Q2. FSA, Financial Modelling, Valuation
Interview Preparation Tips
(1 Question)
- Q1. Tell me abkut yourself Finance project Finacial ratios Effect on share price
- Ans.
I am a finance professional with expertise in financial projects, financial ratios, and their impact on share prices.
I have experience in leading finance projects from start to finish
I am well-versed in analyzing financial ratios and interpreting their implications
I understand how financial ratios can impact share prices and can provide insights on this
I have worked with various financial ratios such as liquidity ratio...
Interview Preparation Tips
Finance terms
College finance project and ratios with
All 3 financial statement
I applied via Recruitment Consultant
Interview Questionnaire
1 Question
- Q1. DCF Valuation, Financial Modelling, Precedent transactions, Forecasting
Interview Preparation Tips
2. Technical round
I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.
(1 Question)
- Q1. Related to Finance, Accounting and General Happening
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed before Jun 2021. There was 1 interview round.
(8 Questions)
- Q1. What is WACC and how do you calculate it?
- Ans.
WACC stands for Weighted Average Cost of Capital. It is the average cost of all the capital used by a company.
WACC is used to determine the minimum return a company must earn on its investments to satisfy its investors.
It is calculated by taking the weighted average of the cost of debt and the cost of equity.
The formula for WACC is: WACC = (E/V x Re) + ((D/V x Rd) x (1 - Tc)), where E is the market value of the company...
- Q2. How are the 3 financial statements linked?
- Ans.
The 3 financial statements are linked through the flow of information and transactions between them.
The income statement shows revenue and expenses for a period of time, which affects the retained earnings on the balance sheet.
The balance sheet shows assets, liabilities, and equity at a specific point in time, which affects the cash flow statement.
The cash flow statement shows the inflow and outflow of cash during a pe...
- Q3. What is trading comps and transaction comps
- Ans.
Trading comps and transaction comps are valuation methods used in investment banking.
Trading comps involves comparing a company's financial metrics to those of its peers in the same industry.
Transaction comps involves analyzing the financial metrics of companies that have recently been acquired or sold.
Both methods are used to determine the value of a company in a potential merger or acquisition.
Trading comps are based...
- Q4. What is enterprise value? What are the components of EV?
- Ans.
Enterprise value is the total value of a company, including debt and equity.
EV is calculated by adding market capitalization, debt, and minority interest, and then subtracting cash and cash equivalents.
It represents the amount of money required to acquire the entire business.
EV is a more comprehensive measure of a company's value than market capitalization alone.
EV can be used to compare companies with different capita...
- Q5. What is Minority Interest?
- Ans.
Minority interest refers to the ownership of less than 50% of a company's shares by an investor or group of investors.
It is also known as non-controlling interest.
The minority interest shareholders have limited control over the company's operations.
Their share of profits is proportionate to their ownership percentage.
Minority interest is reported on the balance sheet as a liability.
Example: If Company A owns 80% of Com...
- Q6. What is the treasury stock method? Give an example of TSM? What are the different types of dilutive securities?
- Ans.
The treasury stock method is used to calculate the potential dilution of stock options and warrants. It assumes that the proceeds from the exercise of options and warrants are used to buy back shares at the average market price.
TSM calculates the dilutive effect of stock options and warrants
It assumes that the proceeds from the exercise of options and warrants are used to buy back shares at the average market price
The ...
- Q7. How do you calculate Adj. Ebitda? What are the different types of non-recurring items?
- Ans.
Adj. EBITDA is calculated by adding back non-recurring expenses to EBITDA. Non-recurring items include one-time expenses or gains.
Adj. EBITDA = EBITDA + non-recurring expenses
Non-recurring items include one-time expenses or gains such as restructuring costs, legal settlements, or gains from asset sales
Non-recurring items are typically disclosed in the footnotes of financial statements
- Q8. Tell me about a recent M&A deal which you have followed?
Interview Preparation Tips
Ravina K
Interview Questionnaire
1 Question
- Q1. Technical ques
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Analyst Interview Questions & Answers
Institutional Shareholder Services
Anonymous
posted on 9 Jul 2020
I applied via Recruitment Consultant and was interviewed in Jan 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Problem solving,Core Java,SQL queries,Design patterns,project based questions
Interview Questionnaire
5 Questions
- Q1. A Big Bazaar store had low profits for the last two months. Whats going on?
- Ans.
Low profits in Big Bazaar store for last two months.
Check if there is a decrease in footfall or sales.
Analyze the competition in the area.
Check if there are any supply chain issues.
Evaluate the marketing strategies and promotions.
Assess the economic conditions of the area.
Consider the impact of COVID-19 on consumer behavior.
Review the store's inventory management and pricing strategies.
- Q2. Heres some data about the quantity of a particular item sold in a store for the last few weeks. Any thoughts?
- Q3. You have two brands of milk that you can sell in your store,. Which one would you pick?
- Ans.
I would pick the brand that has a higher quality and better taste.
Check the quality and taste of both brands
Consider the price of each brand
Look at the expiration date of both brands
Consider the popularity of each brand among customers
- Q4. Why do you want to work at Dunnhumby?
- Ans.
I am passionate about data-driven insights and Dunnhumby's reputation as a leader in customer data science.
I am impressed by Dunnhumby's innovative approach to customer data science
I am excited about the opportunity to work with a talented team of data analysts
I am drawn to Dunnhumby's reputation for delivering actionable insights to clients
I believe that Dunnhumby's focus on customer-centricity aligns with my own valu...
- Q5. Tell me about this particular internship that you did
- Ans.
I interned at a marketing firm where I worked on social media campaigns and market research.
Assisted in creating social media content for clients
Conducted market research on target demographics
Analyzed data to improve campaign performance
Attended client meetings and presented findings
Learned about marketing strategies and industry trends
Interview Preparation Tips
Experience: 70 people shortlisted probably by cv and pre-assessment test results.
Round: Group Discussion
Experience: 70 shortlisted candidates were divided into 10 groups of 10. GD started, we sat in a circle around a table. All of us were handed a booklet and rough sheets. The interviewers told us that the booklet had three sections. Each section contained some data about a company followed by a question. We, as a group had to answer the three questions within one hour. He, himself suggested that we take twenty minutes per section - 5 mins to go through the data, fifteen to discuss and come to a conclusion. The first section gave us an idea about the company and asked some general questions about decreasing costs. Generic case study stuff. The next two sections were quant heavy. Required us to do a lot of calculations albeit simple. We divided the task among the group members. Ran out of time before solving the third question. Interviewer stepped in and helped us reach a conclusion. We were asked to leave the rough sheet behind. One of the longest and most civil Gds that I have attended. A wonderful experience.
Tips: Try to help move the discussion forward. Draw out your calculations and tables in the rough sheet. Let others speak, one hour is enough time for everyone to shine :).
Round: Case Study Interview
Experience: One interviewer. Small talks about the GD. A moderately long case followed by two short cases. The cases involved some quants. Nothing fancy. I did not follow any framework but he did not seem to mind. He helped me out any place that i got stuck. Asked me about why Dunnhumby. Nailed this answer. Did not ask a lot a questions from my cv, just about an internship i had done at a startup. Asked me whether i was comfortable with coding, told him i had not coded since my first year at college. That was it. Shaked hands and asked me to wait outside. HR came and told me i got the job.
Tips: Think out loud. Whatever you are thinking when looking at the tables or numbers, just speak them out loud for the interviewer so that he knows your thought process. Learn about the company a little bit before showing up for the interview. I was asked only cases, I heard others were asked guesstimates as well.
General Tips: Case in Point is more than enough as far as preparation is concerned. A good CV and CGPA helps. Don't worry, I myself lacked both :P
Skills: Ability To Work In A Team, Case Solving Ability, Quant+Math
College Name: IIT Kharagpur
Motivation: Wanted a job as an analyst with a good work-life balance and a moderately good pay.
Interview Preparation Tips
Experience: Pre-Assesment Test conducted in my college.
Consists of Quant, Verbal and logical reasoning.
Students who scored good in this test and had CG above 7 are shortlisted
Tips: Cat preparation would help
Practice aptitude for two months prior to placement season
Round: Group Discussion
Experience: A case was given and should be solved by the group of 8 people in an hour.
They will closely monitor the group and select the students who provide right insights, direct the group in right direction.
Tips: Avoid talking just for sake of talking.
Understand the case and then summarize what you understood.
Speak you idea and also discuss other ideas.
Make sure that the invigilator understands that you are good with cases.
Read Case in point or other case books to get in touch with different cases.
Duration: 60 minutes
Round: Case Study Interview
Experience: Asked few questions like Why Dunnhumy? Type of profiles you applied for? Tell me about your childhood? and few basic HR questions.
Asked a profitability case problem.Even though I did not solve the entire problem, my approach was right.
Gave some data and asked my inference.
Asked to calculate a problem without using pen and paper.
Tips: You need to be good with numbers.
You need to show them that you have the enthusiasm to learn things.
Skill Tips: Go through any good case book.
Show them you enjoy numbers.
Show them you like this work.
Skills: Case Solving Ability, Number Crunching, Ability To Make Quick Calculations
College Name: IIT Kharagpur
Selected
I applied via Naukri.com and was interviewed before Feb 2022. There were 4 interview rounds.
Basic aptitude questions of quant and reasoning and general english
Case study of varies products asked around 15-20 which were easy to attempt
(2 Questions)
- Q1. About yourself, practical knowledge, family, data related,etc.
- Q2. What is sql. Excel formulas
- Ans.
SQL is a programming language used for managing and manipulating relational databases. Excel formulas are used for performing calculations and data analysis in Microsoft Excel.
SQL is used to retrieve, insert, update, and delete data from databases.
Excel formulas are written using functions and operators to perform calculations and manipulate data.
SQL example: SELECT * FROM customers WHERE age > 30;
Excel formula example...
Interview Preparation Tips
Skills evaluated in this interview
Cians Analytics Interview FAQs
Tell us how to improve this page.
Cians Analytics Interviews By Designations
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
Cians Analytics Senior Analyst Reviews and Ratings
based on 28 reviews
Rating in categories
|
Senior Analyst
251
salaries
|  ₹5 L/yr - ₹10.5 L/yr |
|
Associate
105
salaries
| ₹7.5 L/yr - ₹16 L/yr |
|
Senior Associate
40
salaries
| ₹11.8 L/yr - ₹22 L/yr |
|
Senior Research Analyst
25
salaries
| ₹5 L/yr - ₹9 L/yr |
|
Associate Vice President
7
salaries
| ₹18 L/yr - ₹26 L/yr |
Markelytics Solutions
Jasper Colin
GfK MODE
Grass Roots Research & Creation
- Home >
- Interviews >
- Cians Analytics Interview Questions
