An end-to-end financial analysis on potential Boeing Investments for 2017 based on 2016 delivery data provided by Boeing. Excel was used for the entirety of this project, from data cleaning to analysis and visualizations.
- Constructed a financial model that pulled data from 2016 delivery list of Boeing’s Commercial Airplanes segment to simulate operating margin of 5 product families (737, 747, 767, 777, 787)
- Cleaned 700+ rows of 2016 Delivery data to ensure data integrity and consistent product naming conventions
- Estimated market penetration of Boeing’s portfolio of 5 product families to determine organization strengths and weaknesses
Please fill out this form in order to gain access to project files.