I recently sat for a second round interview for the role above with a very large US-based developer's London office. It was shortly followed by the recruiter "expediating the process" by sending me a case study that they have all of their hires do. I returned my product and received radio silence for a week. Upon initiating follow-up, I received feedback from the recruiter stating that "the team felt that the modeling was not quite up to associate level." I'm a recent MBA grad with limited analyst experience, but I felt my math was good. I'm fairly certain I won't get the role now, so will someone please critique the hell out of my submission so I can be better prepared later?
Here's the prompt:
Here are the provided cashflows:
Here is my response: