Final round interviews - Amazon Intern

Hi,
In 2 weeks I have final round interviews for Financial Analyst Internship 2024 at Amazon in Luxembourg. I will have 2hours straight interviews, first Behavioral and then Case study. For behavioral, I know what to do (STAR). For case study, at yesterday's prep call I found out that I will have to analyze financial data of Prime day by using excel.
Could anyone share some tips with me to how to better prepare for case interview? Which formulas/tools in Excel to look at, what could I specifically get, what to repeat regarding the technical part (accounting)?
Thanks

Add comment

Start Discussion

2 Comments

WSO Monkey Bot

O

5mo

Hey there,

Sounds like you've got an exciting couple of weeks ahead! For the case study, you'll want to be comfortable with a variety of Excel functions. Here are a few that could come in handy:

VLOOKUP and HLOOKUP: These are great for pulling specific data out of a larger dataset.
Pivot Tables: These are fantastic for summarizing and analyzing large datasets. You can quickly calculate sums, averages, counts, and more.
IF, AND, OR: These logical functions can help you make decisions based on certain criteria.
SUMIF, COUNTIF, AVERAGEIF: These are useful for performing calculations on data that meet specific criteria.
INDEX MATCH: This is a powerful combination that can be used as an alternative to VLOOKUP and HLOOKUP.

In terms of accounting, you'll want to be comfortable with the three main financial statements (Income Statement, Balance Sheet, Cash Flow Statement) and how they interact. Understanding concepts like revenue, costs, profit, assets, liabilities, equity, cash flows from operating activities, investing activities, and financing activities will be crucial.

Also, don't forget to brush up on your financial modeling skills. The DCF Modeling Training - Free Guide on the WSO could be a great resource for this.

Remember, the key to a successful case interview is to stay structured, make your thought process clear, and don't panic if you don't know something. It's okay to ask for a moment to think or to ask clarifying questions.

Good luck! You're going to do great.

Sources: What can I do from home to help my chances for an internship next year?, 3 Things to keep in mind for case interview prep: Fall Interview Season is around the corner, What should go on my resume and cover letter in my circumstance for internship applications (RE specific), 1st year analyst - how to prepare for 1st year end review this year?

Reply

Quote

Report

Other

I'm an AI bot trained on the most helpful WSO content across 17+ years.

elseco

O

7d

Aperiam voluptatibus ullam voluptas iusto et repellendus amet nobis. Aut aliquid ex vel dolores sint. Eos in animi reiciendis ea voluptatibus et quis voluptatum.

Quasi sint accusantium quam odit unde ut quidem. Inventore atque ut in vitae. Odit id eaque odio esse quia.

Fuga ipsam qui perferendis eum. Non nostrum quasi et est vitae. Dolor accusantium aperiam saepe aut quo cum. Possimus illum repellendus et consectetur eum.

Fugiat et ea officiis fugiat. Vel est qui non libero ipsum odit. Et quam consequatur nulla fugit pariatur porro. Non illo dignissimos omnis magnam et omnis est. Quia vero laudantium aperiam voluptate deleniti quasi.