Senior business analyst Interview Questions in United States | Glassdoor

# Senior business analyst Interview Questions in United States

"As a senior business analyst, you are being hired for your years as a business analyst, providing you with the experience and guidance that other business analysts need. Interviewers want to see that you are capable of taking on more complex projects by testing your Excel skills, ability to perform an analysis, and leadership in a team setting. Be prepared to focus on your previous experiences with data, multi-tasking, and organizations and how it has all culminated to help you make sound decisions for the company."

## Top Interview Questions

Sort: RelevancePopular Date

May 23, 2012
 How do you manage project timelines with change requests?1 AnswerTo do time estimations on the change request and then you swap something that is in scope for the change being requested.

Aug 1, 2017
 The company is losing 1 million subscribers every month. What are the possible reasons for losing subscribers? Given the company is losing subscribers at this pace, how long can the company continue, until it starts making loss?10 Answers25 MonthsApproximately 70 monthsHi, I actually interviewed for this case and I also got 70 months, whereas the interviewer said I was wrong and said the correct answer is 25 months.Show More Responses25 monthsSupposing number of customers at break-even be x. (36x + 46x) = 9 billion. This gives 75 million as the number of customers. That says it lost 25 million customers which implies 25 years.12Bn Rev Per year 9BN cost per year Customer Loss per year = 1million *12 months = 12 million customers Revenue per customer per year = 36 + 7*12 = \$120 Each year, company looses 1.44BN. = (12 million *120) To make a loss, company must loose 3BN 3BN/1.44BN = 2.083 years 2.083 years = 25 months.25 months doesn't sound right... Revenue: \$12 billion Costs: \$9 billion Profit: \$3 billion Customer lost/month = 1 million Revenue lost/month = (36/12 + 7) = \$10 * 1 million = \$10 million Break even = \$3 billion / \$10 million = 300 months 300 months / 12 = 25 years The only way I can see 25 months is if we assumed Ad Revenue is Annual and CANNOT be broken down to month average/customer. In that case Annual Revenue/Customer = 36 + (7 *12) = \$120/customer Total lost revenue/month = 120 * 1 million = 120 million Breakeven = 3 billion / 120 million = 25 monthsUnfortunately, the answer is 25 months and I failed to come up with that figure as well. The calculation posted by anonymous listed below is the right approach: 12Bn Rev Per year 9BN cost per year Customer Loss per year = 1million *12 months = 12 million customers Revenue per customer per year = 36 + 7*12 = \$120 Each year, company looses 1.44BN. = (12 million *120) To make a loss, company must loose 3BN 3BN/1.44BN = 2.083 years 2.083 years = 25 months.36X+84X=9Bn 120X=9Bn ____ ___ 120 120 X= 75,000,000 36(75M)+84(75M)= 2.7Bn+6.3Bn=9Bn So, with 75M customers they would make 9Bn in revenue Since they currently have 100M customers, at 25 months their number of subscribers will be 75 million. 9Bn in costs/12= 750M in costs per month 3X+7X= subscription revenue per month 3(75)+7(75)= 225M+525M= 750M Costs to revenue would be 750M to 750M, so they would break even. In the 26th month, they would start having a loss 3(74)+7(74)= 222+518= 740M So 740M in revenue vs. 750 M in costsIf they're asking for a loss, it's 26 months. If they are asking when the venture is no longer profitable it is 25 months. From the verbiage it is not exactly clear

Aug 1, 2017

Dec 5, 2011
 Cap One is usually collects default accts by calling these customers. Usually 15% of customers pay their accounts off. Now, they are consdering giving an offer to the customers for paying 60% amount. Should we do that or not. Abg balance is \$2000. This offer will impact now, that only 10% customers will pay in full and 10% will pay 60% offer. part(b)- since we are stealing our own customers by giving an offer, what is the cannibalization rate? and what is the max. cannibalization rate that Capital One can do to break even?4 Answersi don't understand. what is the base of 15% to pay accounts off? how much off? what offer is it? what's the motivation? what does 10% pay in full and 10% pay in offer mean? why are we stealing our own customers?Assume that the base is 100. Initial scenario: a) 15% pay off @ 2000 (USD) => 15%*100*2000 =>30000 New scenario a) 10% pay off @ 2000 (USD), and 10% pay off @ 60% => 10%*100*2000 + 60%*10%*100*2000 =>32000 The firm stands to make more money with the revised scenario. I am not sure what the cannibalization has to do here, but the firm needs to get a rate of 50% paying under the scheme to be breaking even. (Assuming that the original 10% will stay).Assume we have 100 people as base cannibalization rate= Unit Loss of old product / unit sales of new product In our case = (15%100-10%100)/10%*100 = 5/10=50% Break-even Cannibalization Rate Profit from sales of new product = profit stolen from old (In our case, we do not have a cost, we only have revenue, let's assume revenue is our profit) Assume we still X number of ppl from old plan 10%*60%*2000*100=10%*X*2000 12000=200*X X=6 So when we steal 6 people from old plan, we will break even. Thus the maximum cannibalization rate will be 6/10=60%Show More Responses One or more comments have been removed. Please see our Community Guidelines or Terms of Service for more information.

Dec 5, 2011
 Anti-freeze: planning to buy a company with 12.5 in cash, 10% bonds for the remaining amount. Total worth of the company \$137.5. assuming there is no discount rate. When will u break-even. And is it a good buy? Part(2) - Anti-freeze is currently priced at \$8, with 60% market share; there are other products in the market(A) priced at \$7 with 15% market share, (B) at \$7 with 7% market share and (c) with \$5 and 10% market share. Should we consider decreasing our price by \$1 or NOT?3 AnswersHi, do you mind post the answer as well? Appreciate it.What are we breaking even with ? The 12.5 cash investment ? How much cash flow does the new product generate ?breakeven: you paid 12.5 today, and 137.5 in future, and no interest rate, so you have to make 150 to break-even. pricing: have to have cost and volume, and historical data of price elasticity. If not, use breakeven analysis. assuming total market volume remains as price drops, and that this price elasticity takes into consideration of all factors including dynamics of market share rebalance and volume change to this company only, set price elasticity to be x, cost to be c, total volume to be V, we have (8-c)*0.6V = (7-c)*0.6V*(1-x/8), x=(c-7)/8, if absolute value of price volatility is larger than this, we decrease price.

Mar 18, 2009

### Senior Business Analyst at Blue Cross Blue Shield of Michigan was asked...

May 13, 2011

Oct 12, 2012
 What if we offered you lower than market rate Business Analyst?2 AnswersSAY YES BECAUSE THE COMPANY IS GREAT AND YOU WILL EVENTUALLY GROW!ditto