Interview Questions
Barksdale Control Products
Excel Analyst Intern

What experience do you have completing high level excel analysis?
I’m currently taking a Financial Modeling course where we’re covering topics like WACC, CAPM, forecasting, valuation techniques, and scenario analysis. It’s helped me strengthen my ability to think critically about how financial data connects across income statements, balance sheets, and cash flows. Outside the classroom, I’ve also worked at financial firms including a private equity advisory firm, where I applied Excel in real business settings. That’s where I first learned how to use VLOOKUPs, macros, and other functions to manage and analyze large datasets
Barksdale Control Products
Excel Analyst Intern

What do you know about out Barksdale product line ( So in summary someone who know FLOW, PRESSURE, TEMPERATURE & LEVEL instrumentation)?
To be honest, I was unfamiliar with Barksdale and its product line. But, after doing some research, I learned that Barksdale is a subsidiary of Crane Co. and specializes in making tools that contribute to safety, efficiency, and system control. I found it interesting that these tools are essential in sectors like energy, manufacturing, and transportation. I'm be excited to learn more about how that kind of data is managed, reported, and used to support operations
Barksdale Control Products
Excel Analyst Intern

Can you provide an example of a report you created using Excel?
Yes! During my on-campus internship as an accounting intern for a university café that serves Starbucks products, I created a variety of Excel reports including balance sheets, income statements, and pricing analyses. One of my main responsibilities was preparing monthly income statements by tracking sales, cost of goods sold, and operating expenses. I used Excel formulas to automate profit calculations and formatted the reports to highlight key financial metrics for easier decision-making. I also developed a pricing model that broke down ingredient and supply costs per item to assess margins and make recommendations on price adjustments.