ASX listed company financial statements in Excel

[Shand]

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

 

[Gringotts Bank]

lol, is that you Joe?

https://www.aussiestockforums.com/t...for-asx-sourcing-screening-backtesting.23925/

 

[Shand]

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

 

[Shand]

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]

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]

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.

 

[Shand]

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]

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?

 

[Shand]

Return on Assets

 

[rnr]

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.

 

[aus_trader]

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:

 

[antjamescox]

QuickFs.net has ten years free financial data on all companies listed on the ASX. Even better, you can download and use their excel plug in for free. You can create your own spreadsheets and calculations.

In addition, if you have Office 365 you can now pull in real-time stock information, like price and market cap, through Data > Data Types > Stock.