In Progress

Expense Trend Analysis


Must be expert in MS Excel with regard to all complex functions including pivot tables, custom views, graphs and charts, etc.

Project Description:

We will provide you all the data necessary. You will receive a single .xls containing 24-months of a single line-item expense for 800 separate companies. You will analyze the data and create a report that explains the following:

1. Determine which companies have relevant data for the entire sample period (apples to apples).

2. Develop analytic model using only those companies. Document and explain model.

3. Determine average expense by zip code (month, year, total)

4. Determine average expense by U.S. state (month, year, total)

5. Determine expense trend by company, by zip code, by state, and total for each time period of the sample (monthly, quarterly, annually, total).

Skills: Business Analysis, Excel, Finance

See more: expense trend analysis, excel expense trend analysis, expense trend, expense trend analysis excel, period expense analysis, trend analysis report, expense trend analysis report, expense trend excel, expense trend analysis report excel, excel expense analysis, xls excel expert, total finance, ms companies, excel model expert, description of graphs, custom graphs in excel, create charts and graphs, expense expert analysis, total expense trend, expense trend charts, expense analysis sample, trend analysis excel, data and analysis, trend , single line

About the Employer:
( 0 reviews ) ATLANTA, United States

Project ID: #1273765