Why don't people working in IB, PE, Corporate finance, etc. not use pandas Dataframes over Microsoft Excel?

I'm currently working on a FinTech related project and I wanted to know why so many people in the finance industry feel the need to use Microsoft Excel over Pandas dataframes for organizing data. I understand that maybe if you want to make a budget or do some simple accounting, Excel is easier on the eyes, but even usability is disputable. I have some experience with both and it surprises me how only data scientists use Python instead of literally anybody who wants to easily organize vast amounts of data and analyze it, because
A.) Python makes functions/formulas easy and repeatable
B.) It makes accessing outside data much easier
So when investment bankers or equity researchers go about analyzing financial statements, why don't they just use Python for valuation techniques and then convert to Excel for ease of viewing? Is it simply because Excel has reputability in the industry, or is there something about Excel VBA and Macros that I'm missing out on?

 

Excel provides all what you need. No need to change the whole system. If you know what you are doing the models will work smooth. If you are doing weird things or trying to flex too much maybe Python would work better. But still this is not rocketscience, xls is more than enough

 

Yes Excel has everything you need but it seems like Python would be faster, and there isn't much of a learning curve either. Idk why, I'm not even a CS lover, but I think python is more practical and faster for doing any numerical analysis

Array
 

Because financial statements aren't complex.

Pandas is great for data analysis, but financial statements isn't data (it's like 15 rows per statement).

How I'm thinking about it would be each row index would be a year, and a column would be revenue, gross profit, etc. Sounds like a pain in the ass to do, especially when you have to start connecting the statements. I guess you could use it to scrape data from the SEC and yahoo finance to automatically calculate EV, but Factset does it already.

 
Most Helpful

That's not what you do in traditional finance. The models are meant to represent an abstract way of how businesses function and how cash flows through said businesses. It's less science and more art. You don't need insane tools to do this, people did this stuff on the back of envelopes over dinner before we had digital spreadsheets.

Python's libraries are great for analysing vast records of data in a systematic way. It's also great for performing non-trivial calculations involving multiple variables and sequential transformations on those variables. It is not great for persisting a representational model of a business that's easily configurable and understandable to most office workers.

It's like suggesting someone who wants to paint a concept they have in mind to use one of these. Maybe it'll get the same result but realistically? That's overkill and a completely unfit tool for the purpose of the task at hand. Don't get me wrong, learning to use Python's data analysis libraries will be useful at some point (especially for things that are beyond the scope of Excel). But, for financial modelling? For business planning? For strategy? It'll just slow you down.

 

Cupiditate modi iste repellat aliquam accusantium reiciendis. Blanditiis placeat fuga id pariatur. Sit at qui asperiores natus. Ducimus tempora quibusdam voluptas quisquam quas.

Array

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
DrApeman's picture
DrApeman
98.9
8
CompBanker's picture
CompBanker
98.9
9
kanon's picture
kanon
98.9
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”