Project

Author
Affiliation

Yuxuan Chen

Boston University

Modified

June 22, 2025

Business Running Case: Evaluating Personal Job Market Prospects in 2024

Lobster Land: Cruise Industry Expansion Consulting

Worked in a consulting team hired by “Lobster Land” to evaluate potential expansion into the cruise industry. Leveraged analytics and business insights to provide strategic recommendations across multiple domains:

  • Market Analysis & Segmentation: Clustered Caribbean cruise-port data to define segments and recommend tailored itineraries and marketing.
  • Conjoint Analysis: Used ratings-based conjoint modeling to identify the most appealing and cost-effective onboard experience bundles for overnight voyages; selected combinations within budget constraints.
  • Predictive Modeling: Built a classification model to predict customer cancellation risk; translated model insights into actionable retention strategies.
  • Forecasting & A/B Testing: Forecasted 2025 EPS for major cruise lines (Carnival & NCLH); performed A/B testing on cruise-themed marketing visuals to guide creative selection.
  • Data Visualization: Created an interactive Tableau dashboard highlighting key insights from cruise industry datasets.
  • Strategic Case Analysis: Developed a customer segmentation-based cruise product proposal inspired by Royal Caribbean’s Icon of the Seas.

Repository: GitHub

Domestic(U.S.) and International Equity Portfolio research

Domestic Equity Portfolio Project

  • Constructed a diversified 3-stock U.S. equity portfolio based on historical return and sectoral diversification from 2000 to 2025, using S&P500 and Dow30 as benchmarks.
  • Performed time-series and cross-sectional analysis of monthly holding period yields (HPYs), including mean returns, volatility, Sharpe ratio, and systematic risk (Beta).
  • Estimated expected returns using both CAPM and Dividend Discount Model (DDM) for dividend-paying stocks.
  • Visualized portfolio growth and comparative performance using Excel-based index plots, efficient frontiers, and return-risk plots.

International Equity Portfolio Project

  • Designed a 6-country international ETF portfolio (including U.S., China, and four additional markets), incorporating both developed and emerging economies to ensure geographical and structural diversification.
  • Computed returns in USD as the Reporting Currency, accounting for foreign exchange rates and using aligned monthly data from 2000 to 2025.
  • Conducted return analysis, risk assessment, and correlation studies across markets to evaluate diversification benefits.
  • Created and interpreted capital base index (CBI) plots, correlation matrices, and international portfolio efficient frontiers.

Repository: AD717-Domestic_n_International_Equity_Portfolio_Project