Yinan Zhao logoYinan Zhao Externship via Extern

Finance student at Virginia Tech, building practical skills

Sophomore Finance major focused on learning financial analysis, corporate finance, and preparing for early-career opportunities.

View my workMessage Me

Work samples

Select class projects, financial models, and coursework that reflect my developing skills in analysis, valuation, and Excel while I prepare for internships and entry-level roles.

  • 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 Finance major focused on learning financial analysis, corporate finance, and preparing for early-career opportunities.

I am Noemi Flowers, a sophomore Finance major at Virginia Tech (Virginia Polytechnic Institute and State University). I am early in my career journey, building foundational skills in finance while exploring opportunities to apply classroom learning to real projects and internships.

Externships

Yinan Value Investing & Financial Modeling Externship

In progress

Experience

Kennel Assistant

Hayfield Animal Hospital, Alexandria, VA (seasonal) · August 2024 - Present

Swim Instructor

Northern Lights Swim Club, Anchorage, AK · Nov 2020 - June 2022

Education

Virginia Polytechnic Institute and State University (Virginia Tech), Blacksburg, VA

BS in Business: Finance Major · Class of 2029

Skills

Financial analysis (coursework)Corporate finance conceptsExcel for financeBasic valuation methodsAcademic research and reporting
Back to work
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 student in a value investing program with guidance from investor Yinan Zhao, focused on financial modeling in Excel, alternative data interpretation, and equity analysis. The work reviewed market behavior and applied analyst workflows to evaluate leading stocks over a 12-week cycle.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I selected AEO, compiled a five-year price chart and timeline, wrote a three-sentence growth thesis highlighting margin recovery and Aerie strength, and published a locked Stock Card with a $24 12–24 month price target.

Project breakdown

During Project 1 I selected AEO, compiled a 5-year price chart and timeline, wrote a 3-sentence growth thesis noting margin recovery and Aerie strength, and published a locked Stock Card with a $24 12–24 month price target.

I located the company 10-K, extracted Business Overview, Risk Factors, and MD&A notes, and compiled them into a single spreadsheet. The work organized qualitative findings and line-item references for later financial analysis.

Google Sheets
Access
View all work