Yinan Zhao logoYinan Zhao Externship via Extern
Anh Thư Hà portrait

Sales and business development focused on startup and investment analysis

I combine startup deal sourcing and financial modeling experience to identify opportunities and make data-driven recommendations.

Work samples

Portfolio includes an HP Tech Ventures externship on deal sourcing and startup evaluation, and a Yinan Zhao externship focused on value investing, Excel modeling, alternative data, and investment

  • HP Tech Ventures: Deal Sourcing & Startup Analysis Externship
    HP Tech Ventures: Deal Sourcing & Startup Analysis Externship
    HP Tech Ventures logo

    HP Tech Ventures · Feb 2026 · ✅ Verified by Extern

    HP Tech Ventures: Deal Sourcing & Startup Analysis Externship

    An externship in deal sourcing and startup analysis with HP Tech Ventures, focused on techniques for identifying, researching, and evaluating early-stage tech startups.

    Investment AnalysisEntrepreneurship
  • 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.

    ExcelData AnalysisFinancial Statement AnalysisFinancial ModelingInvestment Analysis

About me

I combine startup deal sourcing and financial modeling experience to identify opportunities and make data-driven recommendations.

I am Anh Thư Hà, a graduate student in International Relations focusing my career on sales and business development. I completed externships in deal sourcing and startup analysis with HP Tech Ventures and in value investing and financial modeling with Yinan Zhao, where I practiced startup research, financial modeling in Excel, and investment analysis.

Externships

Yinan Value Investing & Financial Modeling Externship

In progress

Experience

Student Mentor (Freelance)

Student Mentor (Freelance) · 3/2024-Present | Flexible

Family Business Operations Assistant

Joyschool Kindergarten (Family Business) · 3/2021-Present | Flexible

Education

METROPOLITAN UNIVERSITY PRAGUE

Regional Studies & International Business, MA · Class of 2027

METROPOLITAN UNIVERSITY PRAGUE

International Relations, BA

Skills

Deal sourcingStartup research and evaluationFinancial modeling in ExcelValue investing analysisAlternative data interpretationInvestment recommendation writingSales and business development focus

✅ Verified by Extern

HP Tech Ventures: Deal Sourcing & Startup Analysis Externship

An externship in deal sourcing and startup analysis with HP Tech Ventures, focused on techniques for identifying, researching, and evaluating early-stage tech startups.

Investment AnalysisEntrepreneurship

Overview

The externship covered sourcing, diligencing, synthesizing, and memo-writing for early-stage tech startups. Work included a three-company sourcing list with supporting data, a due diligence packet for Frore Systems, synthesis reports and a Synergy Report for Vitro3D, and a 3-slide investment memo plus summary sheet.

HP Tech Ventures: Deal Sourcing & Startup Analysis Externship
Google Sheets
Access

What I've accomplished

I produced a three-company sourcing list, a due diligence packet for Frore Systems, thematic synthesis reports and a Synergy Report for Vitro3D, and a 3-slide investment memo with a summary sheet.

Project breakdown

View all work

✅ 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.

ExcelData AnalysisFinancial Statement AnalysisFinancial ModelingInvestment Analysis

Overview

The externship taught equity research techniques and financial modeling while working alongside investor Yinan Zhao. The work focused on selecting and tracking a public company, building a view of its price movement, and preparing analysis artifacts used later in the program. The deliverable recorded a selection of Microsoft (MSFT) and a documented price and trend observation.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I selected Microsoft (MSFT) as my coverage stock, recorded its price at $407.28, and documented that its price trended upward in the first half of the period and downward in the second half.

Project breakdown

I picked Microsoft (MSFT) on Nasdaq, recorded a price of $407.28, and tracked its trend as upward in the first half of the period, then downward in the second half.

View all work

Cold-chain Transportation Analytics & Carrier Allocation Optimisation (more information)

Analyzed 3,000-row historical transportation dataset in 2024, 2025 across 4 carriers and 24 logistics lanes, identifying key bottlenecks in transit hours, temperature excursions and visibility disrupting the cold chain. Forecasted shipment volumes by lane and product type using time-series models for 2026, enabling proactive capacity planning. Developed a Python-based optimization model to balance forecast shipments across 4 carriers and 2 constraints while minimizing transportation costs, delay costs, and expected incident-related losses. Translated complex analytical outputs into interconnected visual dashboards, presenting strategic recommendations to stakeholders to achieve a modeled 23% cost per shipment reduction compared to 2025.

Python
View all work

Fulfillment Optimization During Supply Chain Disruptions (more information)

Identified a shortage in a product line by analyzing 14 weeks of ERP inventory and demand data. Implemented a new production plan aligned with inventory capacity, enhancing process efficiency and reducing uncovered demand by 31.15%. Engineered a linear programming optimization model in Excel Solver during supply chain disruptions, maximizing demand coverage and revenue to 78% of initial forecast.

Excel Solver
View all work

Suppliers performance analysis and allocation (more information)

Evaluated purchasing and supplier performance across 12-month historical datasets to diagnose root causes of shipment failures and stockouts, driving operational risk mitigation. Predicted delivery risks across 14,737 forecast units and 4 cities by building a logistic regression model on supplier fill rates and incident metrics. Protected $1,842,121 in potential sales losses by delivering a timely action plan for all at-risk orders and dynamically reallocating high-risk shipments based on supplier constraints.

logistic regression
View all work

Private Equity Investment Sourcing & Due Diligence (more information)

Sourced a PC cooling technology startup evaluated against 3 competitors, aligning with the strategic objectives of a venture capital firm and supporting market entry with 20% annual growth. Benchmarked the startup against 14 competitors in the high-density cooling market and highlighted its 2 proprietary IP assets as competitive advantages. Synthesised research reports into an executive-level pitch deck, presenting findings and investment rationale to the program coordinator.

View all work

FedEx Financial Statement Analysis | Financial & Business Performance

Analyzed FY2023–FY2024 annual reports to evaluate profitability, liquidity, leverage, and working-capital efficiency using financial ratios and DuPont analysis. Identified a 9% increase in net income and an improvement in operating margin from 5.45% to 6.34%, despite declining revenue. Translated financial trends into insights on cost efficiency, financial risk, and business performance to develop detailed investment recommendations considering both strengths and weaknesses.

View all work