Modelling Coronavirus

Since IB bankers always make a big deal about how fantastic they are at modelling and that it is one of the best things you learn from IB. Can bankers actually model the epidemy to forecast peak and mortality rate? Maybe given that they have some medical/epidemiology knowledge.

16 Comments
 

you cannot even find the raw excel data. so good luck. if you have a higher math and biology background, you can model some of the curves with basic assumptions but there are so many exogenous factors driving the curvature and variables like social distancing / masks that you cannot model. however if you get the data, you can get a sense what a logical curve may look like. try to get historical data by geography, you won’t find much.

 

OP- here

kinda knew that was a stupid question but really wanted to extend to what extend the modelling skills are transferable outside of finance since they are so talked about.

 

I suppose I see what you're trying to ask, but I think it is worth recognizing that the financial models used in banking are not terribly complex in the grand scheme of things. A simple epidemiological model like an SIR model could definitely be created in excel, but for anything of legitimate scientific value you're going to want to work with a general-purpose programming language. At that point, you're well beyond the skillset that IB equips you with, and that's only considering the "tools" for creating your model. The math is a whole different challenge. That's not to say that there aren't bankers who are capable of that type of work – just that they didn't learn it from banking.

 

Wasn't a stupid question at all. All of the sheep who are falling over themselves to tell you how stupid you are to question experts, haven't read the experts' work. The experts come to wildly different conclusions and use logic that is in direct conflict with one another. Its exposed the fact that they can be experts in a narrow field and still not have the critical thinking and analytical abilities to properly assess a once-in-a-lifetime situation.

Anytime someone speaks up on this, the protests are immediate and aggressive. "Who do you think you are questioning the experts?!". Methinks the lady doth protest too much. I think we've got a lot of bankers out there who lack the courage and analytical ability to build their own model, so they shout down others who try. If you tell yourself that only degreed experts can have a view, you don't have to acknowledge that other finance professionals are smarter than you are.

The sharpest expert on this, in the minds of many, has been Dr. Scott Gottlieb. Who worked in IB before med school and barely practiced medicine before becoming a VC where he's spent most of his career. Gee I wonder what he'd say if we asked him whether a finance skillset has been relevant to forming his projections on Covid?

Consensus epidemiology said 500k-1m US deaths, and that's after our mitigations began. The expert predictions were several million deaths without mitigations, although one has to question why even bother making such a prediction.

You'll notice, the new number is now 100k-250k deaths in the US.

Watch it come down further, and watch all the sheep come out and say "yeah that's just because of the mitigation." No sheep, the mitigation was already built in.

Its takes time to build a good model. But if someone has the time, they should try. The experts models are rife with unreasonable assumptions, which is why they have to keep publishing new work to correct bad assumptions made by others.

 

Not sure why there are so many people dumping on this question. Epidemiologists are social scientists, so their papers and models are similar to what you might find in Econ or public policy circles.

Certainly different from financial modeling but not something that is so far removed as to be unrecognizable. I’d suggest the op simply google “covid-19 models” and take a look. Assumptions will focus on infection fatality rate, case fatality rate, rate of spread, icu beds per 1000 people, population demographics etc.

 

Know this is a quasi-troll post, but yes; most good analysts could probably build a decent (excel) framework to project viral spread, especially if they have some sort of econometric background. However, any model is only as good as its A) input data and B) assumptions, and those are both — to put it kindly — all over the place right now. So no, some bored kid at Citi isn’t going to produce a spot-on forecast, unless he gets really lucky with guesses for “A” and “B.”

 

Heads up to anyone in NYC who may have gotten overly optimistic after hearing governor's report today.

He reported a slight reduction in deaths, which is a good thing.

He also reported a very misleading hospitalization figure, that unfortunately is being read very incorrectly.

He reported that there were 574 new hospitalizations in NY yesterday, compared to 1,709 discharges. This number is NOT at all what it sounds.

574 is the net new additions to the hospital rolls. That's after accounting for anyone who's no longer a patient (including deaths and discharges).

So the true number of hospitalizations is 574 + 1,709 + however many people died in the hospital, which is probably damn near all of the 594 deaths. Grand total: over 2,800 people checked into the hospital with coronavirus.

I don't believe Cuomo did this on purpose; he clued me into the error with his own comment that "new hospital admissions were affected by discharges" which obviously makes no sense intuitively. I investigated further and am confident in the 2,800 figure after going through the official data.

So hospitalization grew by a net 574, which is a drop in pace and a good thing. Overall, plenty to be optimistic about in his report. Just want to clarify the hospitalization point, which is pretty far off.

 

Consequatur similique error sit incidunt omnis quis dolorem. Qui qui recusandae qui. Hic similique consequatur iste quia molestias quia voluptatem nisi.

Enim tenetur debitis mollitia eveniet reiciendis harum perferendis dolorem. Nihil eveniet corrupti molestias. Adipisci sunt dicta eaque quis consequatur quo voluptatum. Natus sed velit aperiam hic quis quia tenetur.

Dolores recusandae modi similique ut et aliquam. Ea dolorum natus a asperiores similique. Laudantium est molestiae neque molestiae vero quos. Labore ut dignissimos veritatis et quia deserunt velit.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (65) $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
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
DrApeman's picture
DrApeman
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
CompBanker's picture
CompBanker
98.9
8
dosk17's picture
dosk17
98.9
9
GameTheory's picture
GameTheory
98.9
10
Jamoldo's picture
Jamoldo
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...”