Excel - Foundations and Fundamentals - "Job Market Comparison" Case Assignment
john_promo
JobMarket.xlsxSheet1
| Location | Starting Annual Salary | Cost of Living Adjustment | Adjusted Starting Salary | Bonus | Monthly Car Expenses | Net Adjusted Year 1 Financial Package | Net Adjusted 2 Year Financial Package | Initial Annual Adjusted Salary Rank | Rank of Year 1 Adjusted Net Compensation | Rank of Net Adjusted 2 Year Financial Package |
| Atlanta | $68,000 | 1.1 | $400 | |||||||
| Chicago | $78,000 | 1.3 | $2,500 | $410 | ||||||
| Dallas | $67,000 | 1.1 | $390 | |||||||
| Indianapolis | $60,000 | 0.95 | $380 | |||||||
| Nashville | $63,000 | 1 | $375 | |||||||
| New York | $97,000 | 1.75 | $6,000 | $0 | ||||||
| # Locations with Bonus | ||||||||||
| Assumptions | Adjusted Salary Summary | |||||||||
| Raise % | Average Salary | |||||||||
| Low Salary | ||||||||||
| High Salary | ||||||||||
