Australian (ASX) Stock Market Forum

ASX listed company financial statements in Excel

Joined
Sep 29, 2019
Posts
5
Reaction score
0
Hi, I've just signed up. I'm studying and have an assignment where I have to select any ASX listed company and create a spreadsheet of 5 years financial statements (Income statement, Balance Sheet, Cash Flows and Carbon footprint (if available)). I've searched and can't see how to do this. I've seen software to do this for US exchanges but not ASX. Any suggestions gratefully received.
Thanks
 
Joined
Sep 29, 2019
Posts
5
Reaction score
0
Sorry to hear that, not helpful if people aren't appreciative of other people taking the time to answer a question they asked for help on. I'm here and would be really grateful for any help. A friend has put me on to signing up to Comm Sec and that's looking hopeful but not returning 5 year's data. From the financials I need to report profit after tax, cash flow from operations, return on assets. Then also carbon emissions (if poss). Thanks
 
Joined
Sep 29, 2019
Posts
5
Reaction score
0
Thanks, I followed the thread and am signing up to the FT.com website as that looks like it has 5 year's data
 

greggles

I'll be back!
Joined
Jul 28, 2004
Posts
2,588
Reaction score
1,544
Hi, I've just signed up. I'm studying and have an assignment where I have to select any ASX listed company and create a spreadsheet of 5 years financial statements (Income statement, Balance Sheet, Cash Flows and Carbon footprint (if available)). I've searched and can't see how to do this. I've seen software to do this for US exchanges but not ASX. Any suggestions gratefully received.
Thanks
These links may be able to assist you:

https://libraryguides.vu.edu.au/eco_financial_data
https://guides.library.unisa.edu.au/companyinfo
 

So_Cynical

The Contrarian Averager
Joined
Aug 31, 2007
Posts
7,048
Reaction score
698
I would suggest you look at a small company that way less complex, the ASX site has all previous company announcements, the info needed would be found in the annual report i imagine.
 
Joined
Sep 29, 2019
Posts
5
Reaction score
0
Thanks, I was looking at BHP but there were anomalies, so am looking at JB Hi-fi now. It's difficult to get back up for the Return on Assets as it's calculated on average assets and I only have the year-end balance sheet figures. Any suggestions for a small, simpler company?
 

rnr

Joined
Jul 1, 2007
Posts
544
Reaction score
298
Thanks, I was looking at BHP but there were anomalies, so am looking at JB Hi-fi now. It's difficult to get back up for the Return on Assets as it's calculated on average assets and I only have the year-end balance sheet figures. Any suggestions for a small, simpler company?
Return on Assets or Invested Capital?
 

rnr

Joined
Jul 1, 2007
Posts
544
Reaction score
298
Thanks, I was looking at BHP but there were anomalies, so am looking at JB Hi-fi now. It's difficult to get back up for the Return on Assets as it's calculated on average assets and I only have the year-end balance sheet figures. Any suggestions for a small, simpler company?
Average Assets = (Assets (2018) + Assets (2019))/2

All info available from the 2019 Annual Accounts.
 
Joined
May 30, 2017
Posts
1,662
Reaction score
2,129
Unlike a diversified miner that has both AU$ and US$ earnings such as BHP, it may be better to use a simpler company like JB Hi-Fi Limited (JBH) as you suggested. It has also been stable in the last 5 years in terms of no major business re-structures or mergers or acquisitions or stock splits or consolidations which makes year-on-year (YOY) analysis difficult. Here's the financial stats:

upload_2019-9-29_23-54-48.png
 
Top