1) Introduce yourself and tell us why you chose finance as a
career path
My name is Tanish Gupta. I am a final-year student of Business Economics
and Finance at Delhi University, and I am also pursuing a Minor in AI from
IIT Ropar. I started training in core finance a few months back and can now
prepare a fully dynamic index valuation model. I have done three
internships in the past, the latest of them being the Vice Chancellor’s
internship at Delhi University offered to only 150 students from over
30,000 applications. The other internships being the junior consultant at
The Purview where I made three business reports and also conduced a
behavioural analysis on the preferences of the GenZ.
Link to my report on Index Valuation:
https://drive.google.com/file/d/1ZsHniICyxIBqqDtMJpFhyyhqfMt20m97/
view?usp=sharing
2) Why are you interested in this finance internship?
I am in my final year of college and will be starting my career in finance in
2026. Cook n Klean is a good brand, and I see this internship as a great
opportunity to learn in a professional setup. It will help me apply my
classroom knowledge to real situations, improve my skills, and understand
how finance works inside a well-run company.
3) What is the difference between profit and cash flow?
Profit can be of different types, but if we talk about net profit it is
calculated as Gross Profit (Sales – Direct Costs) minus Indirect Expenses
(including non-cash expenses). Cash flow is the actual inflow and outflow
of cash from operating, investing, or financing activities.
4) What does ROI (Return on Investment) mean?
Return on Investment (ROI) is a ratio that measures how much return a
person or company gets from investing in an asset. The formula for ROI is
EBITDA divided by Capital Employed.
5) If you are given raw financial data, how would you approach
analyzing it?
First, I would check the authenticity of the data. If it is valid, I would
import it into Excel, apply filters, check for missing values, and arrange it
by dates. Then I would take averages, for example converting daily data
into weekly or monthly data. If the data is skewed, I would prefer using a
trimmed mean, usually 10 percent (5 percent from each side), depending
on the quality. Once the dataset is clean, I would apply tools like central
tendency, percentage change, or regression. From the quantitative
results, I would then draw insights and present them clearly to
stakeholders.
6) How comfortable are you with MS Excel? Which functions do
you use most?
I am very comfortable with MS Excel and can operate 80 to 90 percent of
it without using the mouse. I have been using it for more than three years,
including in my previous internships. I can create a fully dynamic financial
model with industry-standard formatting (Big 4 style) in about three hours.
The functions I use the most are AVERAGEIFS, VLOOKUP, regression,
conditional formatting, and paste special.
7) What do you hope to learn from this internship?
From this internship, I hope to act on my academic learnings in finance in
an actual business world set-up. I want to learn from professionals in the
business and want this internship act as a stepping stone in my career in
finance. I want to see how the real world data looks like, how to operate
on it and how to draw conclusions from it. Apart from this, I want to
improve on my soft skills at your company.
