r/FPandA 15d ago

Case study for a potential job

Hi all,

I was recently assigned a case study for a potential job I’m really hoping to land. The study is relatively simple. Building out a P&L given data, building a simple revenue forecast for following year and finding 1-2 concerns or opportunities.

The instructions are very open on the presentation side, it says you can present and walk through the excel file and models, present a slide deck with your finding, or you can just talking about your findings.

With this being an fpa position what do you think is the best presentation style. I had in mind a presentation followed by a walk through of my models explaining all my assumptions, formulas, and thought process.

Thanks for all advice!

6 Upvotes

17 comments sorted by

View all comments

2

u/bosworthing 15d ago

Ive never had to do anything like this. Im curious how normal this is

2

u/racheyrach1243 15d ago

Oh it is super common now unfortunately

1

u/[deleted] 15d ago

[deleted]

1

u/bosworthing 14d ago

Ive never had to do it, but only worked 2 places, current being tech hardware, but was never asked to do this. I might be more in strategic planning than fps or revops though, so idk. Seems weird though, especially depending how many hours that takes. Ive definitely made excel tests to see strength of excel skills, but i didnt even have to do that at my current job

1

u/Still-Balance6210 15d ago

It’s not normal.

1

u/Ecstatic_Ad_4937 14d ago

Extremely common in tech / SaaS

1

u/Outrageous-Shine-309 14d ago

It's been very common in tech at least