Yinan Zhao logoYinan Zhao Externship via Extern

UC Santa Barbara sophomore building practical skills

I am a second-year undergraduate at UCSB, learning technical and professional skills as I prepare to start my career.

View my workMessage Me

Work samples

A selection of coursework and early projects that show my current skills and the areas I am exploring as I prepare for professional work.

  • 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

I am a second-year undergraduate at UCSB, learning technical and professional skills as I prepare to start my career.

I am Cole Bryant, a sophomore at UC Santa Barbara pursuing a bachelors degree. I have limited formal work experience and am early in my career exploration, focused on learning and building practical skills while I study.

Externships

Yinan Value Investing & Financial Modeling Externship

In progress

Experience

Greens Crew

Lake Merced Golf Club · Jun 2024 – Aug 2024

Ski Instructor

Achieve Tahoe · Dec 2023 – Apr 2024

Education

University of California, Santa Barbara

Bachelor of Arts in Economics and Accounting · Class of 2029

Skills

Undergraduate courseworkLearning and researchAcademic project workCareer exploration
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 analyzed public equities using financial models and alternative data, applying Excel valuation techniques and market-movement analysis. The work included hands-on modelling and stock-level analysis guided by an experienced investor.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I worked through a sequence of analyst-focused tasks that combined market walkthroughs, financial modelling, and evidence-based stock analysis.

Project breakdown

View all work