Yinan Zhao logoCurrently an Extern @Yinan Zhao·🟢 Open to work
Kimberly Larios portrait

MBA Student, Stevens Institute of Technology | Financial Engineering & Project Management

MBA student at Stevens building toward project management, backed by financial services experience. I bring analytical rigor and client-facing skills to whatever I take on.

About meView my work

Work samples

Portfolio of coursework and externship work focused on company valuation, discounted cash flow models, and financial statement analysis completed during my time at Stevens and various externship.

  • Yinan Value Investing & Financial Modeling Externship
    Yinan Value Investing & Financial Modeling Externship
    Yinan Zhao logo

    Yinan Zhao · ✅ Verified by Extern · ⏱️ In progress

    Yinan Value Investing & Financial Modeling Externship

    Gain insider experience in value investing by analyzing leading stocks alongside seasoned investor Yinan Zhao. Learn how professionals leverage financial modeling in Excel, interpret alternative data, evaluate market trends, and craft persuasive investment recommendations. Build real-world skills essential for careers in finance, equity research, and investment banking.

    Investment AnalysisFinancial Statement AnalysisFinancial ModelingData AnalysisExcel
  • BullBear: Fintech Trading Education Platform
    BullBear: Fintech Trading Education Platform

    Senior Design Capstone Project · May 2026

    BullBear: Fintech Trading Education Platform

    Co-founded BullBear, a fintech trading education platform designed to make investing more approachable through bite-sized lessons, real-time market data, portfolio tracking, and personalized feedback. The platform combines education, simulated trading, and behavioral insights to help users build str

    FintechQuantitative AnalysisData AnalysisFinancial MarketsPortfolio ManagementRisk AnalysisJavaScriptPythonProduct DevelopmentMarket DataBehavioral FinanceAI & Machine LearningEntrepreneurshipProject ManagementUser ExperienceBusiness Strategy

About me

MBA student at Stevens building toward project management, backed by financial services experience. I bring analytical rigor and client-facing skills to whatever I take on.

I graduated from Stevens Institute of Technology with a B.S. in Quantitative Finance, completing my degree in three years with a concentration in Quantitative Methods. I am now pursuing an MBA in Financial Engineering, expected to graduate in May 2028. My experience includes finance and data analytics, nonprofit consulting, and co-founding BullBear, an educational investing platform. My ultimate goal is to make a positive impact through my work, whether it be through innovative research, industry leadership, or community service.

Externships

Yinan Value Investing & Financial Modeling Externship

Yinan Zhao

Experience

Crew Member / Section Leader

Trader Joe's · Jul 2023 - Jul 2026

Finance & Data Analytics Associate

Human Capital Management Group · May 2025 - Sep 2025

Extern PPL x PwC Communication Strategy Consulting Project

Extern · Jan 2025 - Mar 2025

Education

Stevens Institute of Technology University

B.S. Quantitative Finance · Class of 2026

Stevens Institute of Technology University

MBA Financial Engineering Concentration · Class of 2028

Skills

Value investingFinancial modelingCompany valuationDiscounted cash flow (DCF)Financial statement analysisPerformance MarketingCommunicationTeam Leadership
Back to works
Yinan Zhao ↗

✅ Verified by Extern · ⏱️ In progress

Yinan Value Investing & Financial Modeling Externship

Gain insider experience in value investing by analyzing leading stocks alongside seasoned investor Yinan Zhao. Learn how professionals leverage financial modeling in Excel, interpret alternative data, evaluate market trends, and craft persuasive investment recommendations. Build real-world skills essential for careers in finance, equity research, and investment banking.

Investment AnalysisFinancial Statement AnalysisFinancial ModelingData AnalysisExcel

Overview

The externship placed the participant in a value investing workflow mentored by Yinan Zhao, covering financial modeling in Excel, interpretation of alternative data, and sector trend analysis. The work included hands-on stock analysis and model-driven valuation exercises guided by the externship materials.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I built and published an interactive Stock Card for SunCoke Energy, verified its market-cap and Russell 2000 Value membership, and documented ownership signals alongside a concise growth thesis.

Project breakdown

I selected SunCoke Energy for analysis, built an interactive Stock Card and published it to a live URL. I verified market-cap and index membership, documented ownership signals and a short growth thesis, and launched the page.

Open Link

I located the company's 10-K, parsed the Business Overview, Risk Factors, MD&A, and statements, extracted company-specific items versus boilerplate, and recorded quantitative figures sourced directly from the filing.

Google Sheets
Access
View all works
Back to works

Senior Design Capstone Project · May 2026

BullBear: Fintech Trading Education Platform

Co-founded BullBear, a fintech trading education platform designed to make investing more approachable through bite-sized lessons, real-time market data, portfolio tracking, and personalized feedback. The platform combines education, simulated trading, and behavioral insights to help users build str

FintechQuantitative AnalysisData AnalysisFinancial MarketsPortfolio ManagementRisk AnalysisJavaScriptPythonProduct DevelopmentMarket DataBehavioral FinanceAI & Machine LearningEntrepreneurshipProject ManagementUser ExperienceBusiness Strategy

Overview

Co-founded BullBear, a fintech trading education platform designed to make investing more approachable through bite-sized lessons, real-time market data, portfolio tracking, and personalized feedback. The platform combines education, simulated trading, and behavioral insights to help users build stronger investing habits.

BullBear: Fintech Trading Education Platform

What I've accomplished

Led product and quantitative development while helping build BullBear’s trading and portfolio experience. Integrated real-time market data, portfolio analytics, gamified learning, and AI-driven trade feedback. Developed features addressing behavioral patterns such as overtrading, lack of practice, poor execution, and portfolio concentration.

Outcome

BullBear reached 600+ users and achieved a 68.3% retention rate, outperforming the 53.5% industry benchmark by 14.8 percentage points. Users averaged 3-5 sessions per week, each lasting approximately 18 minutes, demonstrating strong engagement with the platform’s educational and gamified features. The project was also recognized as a Best Pitch Runner-Up, highlighting the strength of our product.

View all works
Back to works

Extern · Mar 2025

Extern PPL x PwC Communication Strategy Consulting Project

Completed a consulting externship in collaboration with PwC and PPL, focusing on communication strategies and audience engagement. Our team examined successful organizational approaches and identified opportunities for PPL to adopt more innovative communication strategies to better connect with its

ConsultingStrategic CommunicationMarket ResearchData AnalysisStrategic PlanningProblem SolvingPresentation SkillsBusiness AnalysisClient RelationsBusiness Development

Overview

Completed a consulting externship in collaboration with PwC and PPL, focusing on communication strategies and audience engagement. Our team examined successful organizational approaches and identified opportunities for PPL to adopt more innovative communication strategies to better connect with its audiences.

Extern PPL x PwC Communication Strategy Consulting Project

What I've accomplished

Researched communication practices used by successful organizations and analyzed how their strategies could be applied to PPL. Collaborated with a team to identify opportunities for more innovative and engaging communication approaches and translated our findings into actionable recommendations.

Outcome

Recommended that PPL strengthen its communication efforts by adopting innovative strategies used by successful organizations. Our findings emphasized that effective communication goes beyond reaching an audience—it requires creating meaningful and impactful engagement.

View all works
Back to works

Corporate Finance School Project · May 2025

Pharmaceutical Industry Valuation & Equity Analysis: Johnson & Johnson (2025)

Conducted a comprehensive corporate finance analysis of Johnson & Johnson using 2014–2024 financial data from SEC 10-K filings and market sources. Analyzed profitability, liquidity, capital structure, and shareholder payouts before developing forecasts and valuation assumptions based on historical p

Financial ModelingFinancial Statement AnalysisCorporate FinanceEquity ValuationDCF AnalysisWACCCAPMExcelFinancial ForecastingComparable Company AnalysisSensitivity AnalysisMonte Carlo SimulationInvestment Research

Overview

Conducted a comprehensive corporate finance analysis of Johnson & Johnson using 2014–2024 financial data from SEC 10-K filings and market sources. Analyzed profitability, liquidity, capital structure, and shareholder payouts before developing forecasts and valuation assumptions based on historical performance.

Pharmaceutical Industry Valuation & Equity Analysis: Johnson & Johnson (2025)

What I've accomplished

Built an Excel valuation model using CAPM, Gordon Growth, and payout-based approaches to estimate cost of equity and WACC. Forecasted income statements, balance sheets, and free cash flows, then applied a DCF model, comparable-company multiples, sensitivity analysis, and Monte Carlo simulation.

Outcome

The DCF model produced an implied share price of approximately $261.67 compared with J&J’s $142 market price at the time of analysis. Sensitivity and Monte Carlo analysis tested valuation risk, while peer comparisons with Pfizer, Merck, and Bristol Myers Squibb supported the overall investment assessment.

View all works