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
Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
May 31, 2024
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
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
Consequatur magnam molestiae voluptatem nam non. Ullam maxime praesentium rem aperiam ea voluptatem. Eius rerum aut vitae et. Voluptates repellendus et aut quidem omnis. Id quam accusantium porro laudantium aliquam unde.
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...