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, expense trend excel, xls excel expert, total finance, ms companies, excel model expert, description graphs, custom graphs excel, create charts graphs, total expense trend, expense trend charts, trend , single line, pivot tables, finance excel data, expense, develop excel model, apples, project finance excel model, charts excel, finance data excel, excel finance project, trend following, finance company project, pivot report

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

Project ID: #1273765