How To Enter Financial Statements Faster
Any tips on excel functions or methods to quickly AND ACCURATELY input financial statements into Excel models?
Trending Content - Investment Banking Forum
| +195 | Evercore > Goldman and I don’t think it’s particularly close anymore | 73 | 6h |
| +159 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 18 | 18h |
| +125 | Think Twice before Recruiting for HOUSTON IB!! | 60 | 13h |
| +86 | UBS Offer Day | 36 | 7h |
| +74 | I hate Wells Fargo | 20 | 20h |
| +57 | No return offer - feeling like a failure is an understatement | 24 | 20h |
| +49 | How cooked am I as an incoming WF IB SA 2027? | 17 | 2d |
| +47 | WF Return offers | 32 | 11h |
| +41 | 2026 Investment Banking Return Offer Climate | 25 | 2d |
| +41 | Should I go back into a junior IBD role for comp? | 19 | 14h |
Career Resources
FactSet codes
I've found these are often wrong when spot checking though - shares outstanding will be off, enterprise value won't have minority interest or preferreds, etc etc etc.
Bump
data -> export data -> export from PDF
feel like this would be inaccurate as fcuk
BamSec for public US companies
am I doing someting wrong? That shit still take an hour or 2 to plug in historical financials.
BamSec needs an API
Refinitiv has its own excel extension. Capiq has macros that export data too
The closest I’ve gotten is doing the filing wizard on FactSet to have raw output sheet then linking to my groups spread format. Marginally faster and is more open to errors. Still prefer entering manually.
Download financial statement from BamSEC into Excel -> link / copy + paste what you need
I've been using Quill AI - can ask it to pull out the info you want in csv format. You gotta pay for it tho
Omnis non placeat aut vero. Tenetur aut autem rem possimus voluptatem aperiam. Aut suscipit voluptates accusantium iste perferendis. Et omnis cupiditate ducimus explicabo perferendis quidem. Voluptate hic temporibus ut et. Ipsum ea eum nam totam qui.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...