Senior analyst financial planning analysis Interview Questions

72

Senior Analyst Financial Planning Analysis interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Live Nation Entertainment
Senior Financial Analyst - FP&A - IT Department was asked...July 22, 2014

How to account for accrued expense?

2 Answers

Debit expense account, credit accrued expense account

Expense accrued but unpaid. Duh! Accounting 101.

Stratasys

What are the most important aspects to being a successful analyst?

1 Answers

I emphasized the importance of understanding how the business works and building relationships with department heads, as well as my ability to model my ideas in Excel. Less

GSK

Most technical questions and analytical skills questions mostly found in GSK web site. It took 1 hours for questions and answers

1 Answers

Went through past experience in each questions with specific tasks

Orfium

describe a conflict with a manager and how you dealt with it

1 Answers

described a personal occasion

Ross Stores

Overall questions about the experience and projects. Some case study questions, for example: Director came to you that he needs to spend $X Mill to replace all department signs in all Ross Stores. How do you answer this request?

1 Answers

1. Work on analysis of the potential revenue of introducing new department signs. 2. Select a small testing group of stores Group A: with introduced new signed Group B: comparable stores to group A, no new signs 3. Check results and make decision A: Introduce new signs to a few selected stores (group A of testing). 3. Compare revenue of group A stores to group B ( Less

Paycom

What is your best quality? What is a quality you are working on? What is your Excel skill from 1 to 10 and what is your favorite Excel function?

1 Answers

Building and modeling process I tend to say "Yes" a lot and overfill my schedule 7, Index Match Match Less

US Airways

What are the advantages of a hub-and-spoke system?

1 Answers

You can research this online but the general direction you want to go is to express that traditional airline systems worked passengers from one point to another and passengers often had to switch airlines and things like that in the middle of their trip to get somewhere. A hub and spoke system is more efficient and allows for the same airline to manage each leg of a complex trip. Airlines can offer many flights each day between the hub and another city as sort of a shuttle service. Hubs can service more regional airports rather than focusing on big cities as in the past. Airlines can offer benefits to frequent travelers because travelers can be loyal to one airline that reaches everywhere they need to travel. Downside to hub-and-spoke system is concentration of risk in hubs. They are less diversified. For example, a hurricane that affects the Charlotte hub of US Airways will mess up a larger percentage of flights throughout the system than it would have under older point-to-point systems. Less

US Airways

Tell me a financial model you have built before. What was it for and how did structure the model?

1 Answers

I just gave them a project I did to forecast the market size and NPV for a new product development. Less

Stratasys

If I contacted your references, what is one negative trait they would say you have?

1 Answers

I mentioned my tendency to get caught up in the data, or hyper-analytical. Said I have responded by recognizing this trait and learning how to take a step back and address my work from the perspective of others. Less

Stratasys

Have I ever received push-back on an idea, even when I know I am right? How did you handle this?

1 Answers

I gave an example of a time when this happened, and the outcome as a result. I initially gave an example where no matter how much I pushed back my supervisor didn't break, and then offered another example where I pushed back and was able to avoid a costly mistake. Less

Viewing 1 - 10 of 72 Interview Questions