• Australian (ASX) Stock Market Forum

Hello and welcome to Aussie Stock Forums!

To gain full access you must register. Registration is free and takes only a few seconds to complete.

Already a member? Log in here.

ASX listed company financial statements in Excel

Discussion in 'Beginner's Lounge' started by Shand, Sep 29, 2019.

  1. Shand

    Shand

    Posts:
    5
    Likes Received:
    0
    Joined:
    Sep 29, 2019
    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
     
  2. Gringotts Bank

    Gringotts Bank

    Posts:
    6,133
    Likes Received:
    529
    Joined:
    Jun 30, 2007
  3. Shand

    Shand

    Posts:
    5
    Likes Received:
    0
    Joined:
    Sep 29, 2019
    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
     
  4. Shand

    Shand

    Posts:
    5
    Likes Received:
    0
    Joined:
    Sep 29, 2019
    Thanks, I followed the thread and am signing up to the FT.com website as that looks like it has 5 year's data
     
  5. greggles

    greggles I'll be back!

    Posts:
    2,383
    Likes Received:
    1,116
    Joined:
    Jul 28, 2004
    These links may be able to assist you:

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

    So_Cynical The Contrarian Averager

    Posts:
    6,831
    Likes Received:
    421
    Joined:
    Aug 31, 2007
    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 likes this.
  7. Shand

    Shand

    Posts:
    5
    Likes Received:
    0
    Joined:
    Sep 29, 2019
    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?
     
  8. rnr

    rnr

    Posts:
    432
    Likes Received:
    150
    Joined:
    Jul 1, 2007
    Return on Assets or Invested Capital?
     
  9. Shand

    Shand

    Posts:
    5
    Likes Received:
    0
    Joined:
    Sep 29, 2019
    Return on Assets
     
  10. rnr

    rnr

    Posts:
    432
    Likes Received:
    150
    Joined:
    Jul 1, 2007
    Average Assets = (Assets (2018) + Assets (2019))/2

    All info available from the 2019 Annual Accounts.
     
    aus_trader and Shand like this.
  11. aus_trader

    aus_trader

    Posts:
    881
    Likes Received:
    660
    Joined:
    May 30, 2017
    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
     
    Shand and rnr like this.
Loading...

Share This Page