Anyone have to do a live case study for an interview before? I’ve only done it where they send it to you before and you present it in an interview. This is for a corporate FP&A role if anyone has any tips!

like
Posting as :
works at
You are currently posting as works at

At Analyst level, CorpFin case studies will usually test your Excel abilities (likely to be given a "dirty dataset" to transform), analytical skills, and ability to advise/present. I'll give an example of common onee I've run in to:

Give you a raw data dump with overhead info. You're asked to clean up the dataset, map it, pivot it out, and present KPIs. What does everything mean, what are actualizable points for the org, etc. At analyst level they just expect bare minimum and this was a 30 min exercise tops, maybe an hour with prep time.

The hardest I've run in to:

Given a dataset for a segment the company is considering divesting and putting that capital into expanding another segment. They'll give financials for both segments with expected return KPIs. You'll comb through both to see if the KPIs are correct (usually are, but I've seen them be wrong too...) and define the impact of closing segment 1 (FCF in-flow), rolling the money and manpower into segment 2, future imcome vs expense for segment 2. You'll need to look at not only $, but margin impact and scalability as well.

The latter was for an FP&A/M&A hybrid role. Prob not common to see at all. I wouldn't stress too much over the case study. They're usually pretty light.

like

Related Posts

Any Spotify people here? Noticed there’s an AM role going at the moment in the UK but not sure what experience level it is. For reference I’ve got 6 years in ad sales experience with 3 years management (both in music industry). Would this be comfortable or is it worth holding out for AD?

like

So just starting a new Position. At thia time I was looking for a good base as need to be stable.

Always into sales since childhood but I have 5 years of proper new business development experience with good track record.

I am starting a position at $80k now I just want your thoughts and feedback an the base. There is also comision and bonuses. Which could be something.

Keep in mind this is also in Canada

like

How well does 1 year in a top 4 looks on the resume when trying to look for a software development role?

likefunny

Any one attended an interview with chennai based company IMMO ? Any idea how's the company ?

like

Current Package - 26 Lacs
Expertise- Product Management ( Designation Consultant)
YOE- 14 years 8 months (all relevant)
Already cleared technical and managerial round of Mindtree and salary Final discussion pending for C6 level.
Mindtree Folks please suggest the realistic package figure I should ask for considering I have to relocate frrom Mumbai to Pune for this role and whether C6 level is apt or not for this experience and skillset.

Going for a final round interview with OW Dubai. Can anyone share their experience?

Oracle job status : screening means?

I’m a business/commercial lawyer with 8 years experience looking to relocate to Chicago from NYC area, while also trying to make the jump to in-house after only ever working at a boutique firm. It’s been 5 months and I haven’t had any luck applying to job postings on the usual sites (no calls, no interviews, nothing). I can’t tell if this is due to covid, the market, the fact that I don’t have any in-house experience, the fact that I live out of state, or something else entirely. Any insights??

Looking for a casing buddy! Fairly new to casing and come from a science background not business. 2nd round BCG interview coming up. :)

like

Help!! I am on the job hunt and it’s been more challenging then I anticipated. Are there too many people applying not enough jobs? Any tips ? Insights appreciated

like

Hey all, I’m the founder of Stories Company, a creative agency focused on design for internal/B2B work at Fortune 1000s. Currently hiring a senior designer or AD. 85K-125K. Thanks so much!

like

My psychiatrist today revealed to me that I may have ADHD, still a hypothesis that he is still exploring but from my personal experiences and discussions with therapist, it seems likely.

One example of personal experience is my ongoing prep for case studies as I'm interviewing with a number of firms. I do struggle to keep focus and generally take a bit longer to finish them, specifically the structuring of the case. Does anybody else feel the same way and any recommendations to overcome this?

Is Deloitte hiring on H1B for transfer? Cleared 1st tech interview but recieved email from HR to confirm visa status. My fear is to get ghosted :)..GFS practice if that helps.

Is anyone's agency currently looking for a Senior or ACD position?

Asking for a friend:
My friend received two job offers for Account Executive roles: a Mid-Market role with Confluent and an Enterprise role with ThoughtSpot. He’s conflicted because Confluent is a more established company, ThoughtSpot is Pre-IPO. Confluent is a lucrative product to sell and has established SDR reps so there’s a good blend of inbound and outbound sales. Thoughtspot is more of a startup culture where most of the sales comes from outbound and it’s a tougher sell.

like

I have cleared all my interviews for Visa for the role of Sr Project Analyst which band I6 can someone help me with the seniority level of I6 is it entry or mid level?

like

Hello Friends... How long does it take for the HR to come up for a discussion or offer.... In SAP, SAP labs..

I have cleared all the rounds on 9th June, 2022 and awaiting HR round and offer proposal...

Kindly shed more light...

I was so keen on this position... Now I am worried.... Disheartening after almost 5 rounds...

like
like

I’m brand spanking new to the “official” business analyst role and have my first functional requirements workshop any tips on how to make this a success?

Super anxious, nervous and everything else that’s involved.

Anyone from ACN asked to take a week of vacation in June? I was asked to but the friends I checked with we’re not; afraid I’m being prepped to exit.

like

More Posts

Does Optum United health group UnitedHealth Group provides sponsorship for taking executive management courses?

What was the maximum RRP that we could expect from Optum for an expectational performance?

like

Hi everyone can someone help me with how is the Work from office model being followed at optum..Are they allowing work from home also?

like

How much Gartner offers for a .net full stack , senior software engineer ?
Year of experience: 7 years

Gartner

I'm curious to know how many (and which) tech companies have resumed physical onsite interviews in their offices?

like

Any idea on which IT/application course/platform would be better for someone from BA (English) who has no idea on coding to get into IT domain?

like

Hi All!

I am currently a Senior Software Engineer(Backend) with 4 YOE. My current CTC is 21LPA (All Fixed) with additional Yearly bonus. I got a call from
Google (Pune/Bangalore/Remote) for Software Engineer - Backend. I have the following doubts but any insights are welcome -

1. Does the lower designation offered make any difference?
2. Kinda ambiguous, but what kind of hike or ballpark pay can I expect?
3. Any similar interviews experiences or focus areas I should prepare for?

like

What salary range should I give for Avascent analyst role?

like

I have received offer from Wipro which is little above than the offer that I am holding but fixed pay is less. Thinking of rejecting Wipro offer. Is it better to reject or accept and then not join. Also if I reject, will there be any issue like they won't consider me in future?Tata Consultancy Wipro Cognizant Infosys

like

Anyone in tiger working with pepsiCo client?
Please dm me.

Hello fishes plz unlock my dm

like

Hello all,

Can you change real estate agents after going under contract ?

Context: We want to put earnest money on a house, I am still working on getting my real estate license. Can I put a friends name as the buyers agent and change it to my name Right before closing ? We are based in TX

like

I keep fighting with the product managers on my team, who keep assigning me new features to build without checking first if I had the bandwidth for it. How do I communicate this politely?

like

Are finger tattoos acceptable at work? Really want to get some before return to office

like

Looking for a pulse check. I am thinking about applying next year. I'll be 28 during the application process and 29 at matriculation. Will I be too old? Will it negatively impact my application? Thanks in advance.

like

Hi partners. How confidential is the partner process? I’ve been asked by a partner reviewing a candidate regarding the candidate. This candidate has been manipulative and deceitful to me. I don’t Cont

likefunny

thoughts on “net 30” payment terms? has a company ever not paid on time? what do you do when that happens?

like

Does this job get any better? Been working non stop since I’ve started, having trouble sleeping the limited hours I have outside of work, and seeing my mental health get affected

like

For getting promotion who take the main decision? Manager, Supervisor or HR?

like

Additional Posts in Finance

fishbowl has invited me for there ambassador program, anyone else gets this as well?👶🏻

like

Do you wear a suit to work every day? How formal is your office?

like

Interviewing for a risk role when I’ve barely ever done any risk or ERM lol Please let me know what the heck I can say to be chosen cuz this role is interesting!

How do you deal with a coworker you just simply don't like as a person?

like

Is fishbowl only available on the US App Store?

like

First year analyst here... my manager often asks me to buy coffee for her and never pays me back. What should I do?

like

Are cover letters important if they don’t ask for one? There are so many job postings and applicants I can’t tell if they would be beneficial to show effort or just a waste of time to write with how little time I assume people are looking at applications with the mass hiring going on. If I should be writing one, any advice how to format?

like

At this rate, were headed for the Trump depression...

like

Analysts who continuously complain are the bain of my existence. Shape up or shape out.

like

How long does it take to hear back from a superday at a BB? I was told by HR 2-3 weeks but I hear people get calls within hours. Is this true or should I take HRs word? Scared I got rejected

like

Ever turned down a job bc of the commute?

Differing views at firm...do you wipe existing amortization in acc/dil or is your intangible write up in addition to existing? I always believed the latter.

like

What book has inspired you the most in life principles, or your career in finance?

like

It’s 2020. Is a small dainty nose ring still perceived as unprofessional in the workplace? I work in the finance industry.

like

Can someone please for the love of god help me figure out how I can pay less income taxes? I only make 88k and I put the 12k standard deduction but I’m still getting taxed 27% of my paychecks! My sign on bonus (20 even) a few months ago was taxed nearly 45%! Excuse my ignorance, but am I doing something wrong? Will increasing deductions help or should I increase the withholdings? Is this normal?! Thanks for any help/advice, it’s greatly appreciated.

like

Is retail quant trading on a massive rise?

likehelpful

Khaleesi is coming to Westeros!!!

like

So I jump ship in Hong Kong and make my way over to Tibet...

like

Ezoo this weekend any youngins??

like

Roth vs Traditional 401k, thoughts?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal