Yinan Zhao logoYinan Zhao Externship via Extern

Biomedical engineering student exploring healthcare tech

Sophomore focused on learning biomedical engineering fundamentals and building practical skills for healthcare applications.

Work samples

A collection of coursework, lab exercises, and early projects that show technical foundations in biomedical engineering and growing practical experience.

  • 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

About me

Sophomore focused on learning biomedical engineering fundamentals and building practical skills for healthcare applications.

I am Charlotte Chan, a sophomore pursuing a Bachelor’s in Biomedical Engineering. I have limited professional experience and am exploring projects and learning opportunities that connect engineering principles with healthcare applications.

Externships

Yinan Value Investing & Financial Modeling Externship

In progress

Skills

Biomedical engineering fundamentalsCircuit basics and electronicsBiomechanics conceptsLab techniques and safetyTechnical writing and reporting

✅ 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 program centered on stock analysis and financial modeling alongside Yinan Zhao. Work combined Excel-based valuation, interpretation of alternative data, and market-movement walkthroughs. Deliverables included financial models and investment writeups.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I produced a Stock Card for Kohl's Corporation (KSS) that recorded analysis using a four-part analyst framework, documented two ownership signals, and included a three-sentence growth thesis.

Project breakdown

I selected Kohl's Corporation (KSS) from the Russell 2000 Value set, applied the four-part analyst lens, noted two ownership signals, and wrote a three-sentence growth thesis to seed the Stock Card for later analysis.

I found the company 10-K and read its Business Overview, Risk Factors, MD&A, and Financial Statements. I summarized key passages, decoded dense language into concise paragraphs, and consolidated findings into a clear analyst-style summary.

I compiled a locked qualitative template that summarized Kohl’s business segments, competitor map, downside risks (inventory, tariffs, credit-card exposure), catalysts, and a timeline of recent leadership changes, producing a single spreadsheet deliverable.

Google Sheets
Access

Situation: I built a historical three-statement model for Kohl's. Task: I locked the projection drivers and calculated values from 10-K data. Action: I recorded each driver, formulas, and rationale. Result: I produced a driver table and defended forecasts by line.

During the Project Five Years of Financials step I projected income statement, balance sheet, and cash flow for five years, linked all statements to driver formulas, and produced a spreadsheet with historical data plus the five-year forecasts.

View all work