• Skip to main content
  • Skip to footer

R/S

Ryan Serebro

  • Home
  • Key Skills
  • Portfolio
  • Contact

02Boeing Investment Opportunities

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.

Footer

Contact

Ryan Serebro on LinkedIn

Copyright © 2023 · Ryan Serebro · Back to Top