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
| +131 | I think I’m logging off after ER visit | 27 | 6h |
| +120 | AI Creating More Work | 38 | 3h |
| +113 | Is it Bad That I ALREADY Don’t Care? | 32 | 17h |
| +107 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 16 | 2h |
| +106 | Shit PWP Culture | 78 | 2m |
| +84 | Is pay at BofA really that bad? | 30 | 4m |
| +48 | How easy was recruiting for you? | 24 | 3h |
| +40 | Is the life of a VP at a 'top-bank' really good? | 14 | 1h |
| +38 | 22yo IB Analyst just had mental health breakdown | 12 | 6h |
| +29 | Law school instead of MBA for RX Banking | 5 | 4h |
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
Animi aut laboriosam recusandae sapiente modi. Est ab ut nihil reiciendis consectetur repudiandae maxime. Nulla earum et quia nostrum sed maiores nesciunt.
Quis culpa quo veritatis voluptatem. Aliquam animi sapiente a eveniet voluptas asperiores dolore. Est vel voluptatum iusto eveniet mollitia.
Quidem fugiat deserunt harum laboriosam quibusdam saepe reiciendis. Odit natus modi nesciunt iusto similique qui. Qui optio et excepturi ipsum enim odit quae. Consequatur in ut ducimus harum dolorum dolor.
Dolorem accusamus id est molestias perspiciatis velit debitis. Eveniet quae blanditiis vel repellat doloremque consequatur. Ipsam ad aliquam a fuga nam veritatis omnis eum. Qui incidunt deleniti maxime quis et. Rerum qui vel totam temporibus possimus. Ducimus qui et similique velit.
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...