For research I need the next variabele of the S&P 500 en FTSE350 for the years 2004 until 2012 (see attachment, sheet 1):
Total current assets (CA)
Total Assets (A)
Cash/Cash equavilents (CASH)
Debt in current liabilities (DCL)
Depreciation/amortization (DEP)
Current liabilities (Cl)
Property and plant equipment (PPE)
Total receivables (REC)
Total revenue (REV)
Total assets (ACT)
Long term liabilities
Operating Activities - Net Cash Flow
Book value per share
Book value per share
Common shares outstanding
I've already more than 95% of the data, only there is still missing some data. Someone has to fill in the missing values and has the to take a sample of the already founded data. You can find the data by using a financial database (datastream, Bloomberg, Compustat etc) or by using the annual report of the company that's published on the internet. As well you can work with macro’s (formulas), because you have to check sheet 2, 3, 4 and 5 if the formulas are right.
I think it's between 10 and 20 hours work, depends if you've experience. I want to know what's the price of a freelancer. If you're going to bid more than 125 USD I'm going to do this job by myself.
Hi i am a CPA , working from home. I have vast experience in collecting data of companies using various sites. Looking forward to hear from you on this. Thanks.