MyInternships.in
Career Advice

Financial Analyst Internship Guide: 403 List Tally, Only 63 List Modelling

On MyInternships.in, Tally is listed by 403 candidates and Accounting by 310, but Financial Modeling by only 63. What finance interns do and how commerce students can show analytical skill.

M
MyInternships.in Research Desk
4 min read854 words
Share this:
Financial Analyst Internship Guide: 403 List Tally, Only 63 List Modelling

Commerce students on MyInternships.in are far more likely to list bookkeeping skills than analytical ones. Tally appears on 403 profiles and Accounting on 310. Financial Analysis appears on 156, Valuation on 85 and Financial Modeling on 63.

These are counts from 55,557 skill-listing profiles on our platform on 1 October 2026. They reflect what candidates write, not what they have been examined on, and a small count simply means few list the skill here.

What a financial analyst intern spends time on

The work depends on the team. In a company's finance department you might help with monthly reporting: pulling figures from the accounting system, comparing actuals with budget, and explaining the differences. In a research or advisory team you might gather data from annual reports, update a spreadsheet model and draft part of a note.

In both, a great deal of time goes on getting numbers to agree. Two reports that should match do not, and you trace why. It is detailed, sometimes tedious work, and accuracy is the whole point.

You will also format. Tables that a senior person will present must be clean, consistently labelled and free of errors. An intern whose spreadsheets can be trusted without rechecking becomes useful quickly.

The skills tested

  • Accounting fundamentals: how the income statement, balance sheet and cash flow statement link together. This is asked almost every time.
  • Excel: lookups, pivot tables, nested conditions, absolute and relative references, and working without the mouse.
  • Ratio analysis: margins, returns, liquidity and leverage, and what a change in each suggests.
  • Basic modelling: building a simple forecast from assumptions.
  • Valuation concepts: the idea of discounting future cash, and comparing similar companies.
  • Attention to detail: often tested with a spreadsheet seeded with errors.

A classic question: "If depreciation rises by ten, what happens to each of the three statements?" Prepare it until you can answer without hesitation.

Bookkeeping is listed; analysis mostly is not

Skill listedIndiaBengaluruHyderabadPuneChennaiDelhiMumbai
Excel16,1531,5491,2391,3641,0281,074839
Tally403272125262530
Accounting310321722192125
Financial Analysis1562211582120
Valuation8511under 5under 5under 52311
Financial Modeling63under 5under 57885

Excel is everywhere, at 16,153. Tally and Accounting are in the hundreds. The three analytical skills together are listed by roughly three hundred candidates.

Among the metros, Mumbai has the most Tally profiles at 30 and Delhi the most Valuation profiles at 23. Financial Modeling does not reach double digits in any metro shown, and is under five in Bengaluru and Hyderabad.

What does that mean for you? Tally and accounting knowledge is a sound base, and plenty of roles need exactly that. But if you are aiming at analyst work, the modelling and analysis skills are barely represented among profiles on our platform. Having them, and being able to demonstrate them, would make your profile unusual here.

Build a three-statement model

This is the standard proof, and it is within reach of a second-year commerce student.

  • Choose a listed company in a simple business, such as a consumer goods maker.
  • Enter several years of its published financial statements into Excel by hand.
  • Compute the main ratios and write three observations.
  • Forecast the next few years from clearly stated assumptions, keeping the balance sheet balanced.
  • Put all assumptions on one sheet, coloured differently from formulas.

Typing the statements in yourself teaches more than downloading them. Add a half-page note on what you would want to know before trusting your own forecast. Do not present it as investment advice; it is a learning exercise.

Listings that are really sales roles

Finance has a well-known mislabelling problem. Look out for:

  • "Financial analyst" or "financial advisor" internships that involve selling insurance, loans or investment products, often starting with your own relatives.
  • Roles where earnings depend entirely on commission, described as an internship.
  • Programmes that charge a fee and promise a certificate.

Selling financial products may itself be subject to licensing or registration rules, which vary, so be cautious about any role that asks an intern to do it.

A real analyst listing mentions reporting, modelling, research or accounting work, names the team and tells you who supervises you. For articleship-style or accounting roles, the listing should be clear about the nature of the engagement.

Applying with numbers that tie

Attach or link your model, and make sure it balances; reviewers do check. On your résumé, be specific: "built a three-statement model with a five-year forecast" says more than "knowledge of financial modelling". Use the resume builder to keep it to one page.

Proofread everything twice. In a field that prizes accuracy, a typing error in a finance application is costly.

Look across corporate finance, research, audit support and accounts roles, and at finance teams in startups, where interns often see the whole set of books. Our blog has more guides for commerce students.

When your model balances and your note is written, browse current finance internships and apply where the listed work is analysis.

#financialanalystinternship#financeinternship#financialmodelling#Excelforfinance#accountinginternship#BCominternship#MBAfinanceinternship

Ready to land your internship?

Create a free profile and get AI-matched with verified internships & fresher jobs across India.

Share this:
Financial Analyst Internship Guide: Excel to Modelling | MyInternships.in