Where download the balance sheet in excel for the model
Hi all,
i'd like to delevopment my first model, but where i can free download the balance sheet and income statement in excel of 1-2-3-4-5 years ago? maybe even for quarterly
Hi all,
i'd like to delevopment my first model, but where i can free download the balance sheet and income statement in excel of 1-2-3-4-5 years ago? maybe even for quarterly
Career Resources
If I'm understanding your question correctly, go to the Investor Relations section of a company webpage. Some of them have it in Excel, others don't. It really just varies company to company in terms of what format they provide it in. Otherwise, if you have access to a Bloomberg terminal, you can download various metrics into an Excel workbook.
Thank you for your reply, yes you understand correctly, but the problem is that i don't have bloomberg and then I was looking for a free option
Just go to the SEC website and type everything in manually. You'll learn more that way because of some psychology mumbo-jumbo my wife is always going on about.
What Stroh said.
Exporting financials is quick and easy, but most of the time you'll have to reconfigure most of it anyways. A lot of companies report non-gaap financials in their press releases and adjusted metrics which is typically key for ER.
Thank you for your reply, but for example if i want the balance sheet of fiat, i can't find it , this is the link of my research on sec web site https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=00015531… I don't find the balance sheet what i'm doing wrong?
Its the most recent 20-F statement, located here...
https://www.sec.gov/cgi-bin/browse-edgar?CIK=FCAU&owner=exclude&action=…
Yes but not in xls
Buddy...don't know if you just ignored the whole chain from above, but unless you have access to Bloomberg, Factset, SNL, etc, there is no good quality, free source that has the financials in excel for a wide range of companies.
Also, as mentioned above, you really shouldn't be using these sources as 1) the format isn't right, 2) these data aggregators may adjust the figures to standardize across an industry which is bad if you're trying to really understand a company from a bottom up perspective, and 3) in real life, associates and analysts have to manually enter it all the time.
At this point, your line of questioning is no longer productive and is a general waste of other people's time. I'm not trying to put you down, but it's been clearly explained above. Take it from someone in ER, if you were my associate and were this obtuse, I would not consider hiring you or, assuming you already were hired, would consider giving you a poor review.
Contrary to popular sentiment, there are such things as stupid questions. One such example would be repeatedly asking the same thing despite having already received clear and unambiguous answers multiple times.
i'm sorry but i don't understand the above reply (my fault). However now i am financial Analyst in the special situation Sector (distressed opportunities) but my goal is make the swich to equity Analyst (sell/buy side)
So you are currently a special situations analyst but a) have no idea where to find company financials, and b) have no access to any data sources?
Private Sector we have some access to local database where find balance sheet, income statement but we don't have Bloomberg, Reuters or similar to take balancesheet of public company
Dolor recusandae est in quisquam repudiandae ut dolore quis. Quo enim a nam iusto est. Consequatur modi voluptatem rem labore. Autem magnam sit laboriosam dolore saepe qui et et. Dignissimos nisi qui ipsam laudantium perspiciatis.
Expedita libero occaecati deleniti in qui. Assumenda velit sed esse sit distinctio. Qui aut tempore enim hic voluptas quo. Consequatur nemo odit quia quaerat distinctio corrupti.
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...