Financial Data Organization
Hello all. I'm working on a project to analyze financial data (income statements, balance sheets, cash flow statements) for many companies (>100).
I currently have the the data in a very inefficient format in Excel. I have three worksheets, one for each of the three financial statements above. In each of these worksheets, the data is broken down as follows:
Company Year Data1 Data2 Data3
Company1 Year1 x y z
Company1 Year2 x y z
Company1 Year3 x y z
Company2 Year1 x y z
Company2 Year2 x y z
Company3 Year3 x y z
...etc
The size of the file is around 100MB, and as you can imagine, Excel takes way too long to do any useful activity.
Can anyone help me think of a more efficient way of organizing the data? I need to be able to apply statistical formulas to the raw data and to calculated data between the worksheets. For example, I may want to look at the trend of Income_Statement.Company1.YearX.Data1 / Balance_Sheet.Company1.YearX.Data2. I may also want to look at the trend of Income_Statement.Company1.YearX.Data1 over the past 5 years versus the trend of Income_Statement.Company1.YearX.Data2 over the same period.
It seems like Access would be a better choice than Excel, but I don't know if it can handle the data analysis I need to do.
Thanks in advance for your help.
|