Debt data collection and visualization

  • Posted:
  • Proposals: 12
  • Remote
  • #2260958
  • Awarded
Kumail R.
Jon G.Ramz A.Vijay P.Andres S. + 7 others have already sent a proposal.
  • 12


Experience Level: Intermediate

I need help collected and presenting debt information for a number of companies. National Grid (NG.L) Severn Trent, United Utilities, Pennon and SSE. I have access to Capital IQ and can share this with you if you need to use it to collect the information. I need a long period of history (from 1990 onwards) and a number of variants of the data (Gross debt, net debt, market value, book value, Operating company debt, mid-co debt, hold-co debt).

Ideally this could all be reproduced and verified by someone else so I would like to be able to verify the source of the data (weblinks or capital IQ references).

Excel format is best for me with plugins as necessary to help visualize and represent. Eg Crystal Ball, Power Query, Power Pivot, Power BI outputs are all good for me.

I am happy to pay 10 hours of your time and to get your output within 2 weeks or sooner if possible.

Best wishes


New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

  • Gari W.


    Just to confirm, is the data that you need already in Excel (after the download from Capital IQ? (and essentially just needs tidying up and making in to a presentation?). Is it possible that you could post a sample of the data, please?


    PJ M.08 Jan 2019

    Hi Gari, no the data is not yet collected. I need it found and extracted using Capital IQ