Yinan Zhao logoYinan Zhao Externship via Extern

Early-career professional building practical experience

I’m Nathan Lopez, gaining hands-on experience now and preparing for the next career step through projects and skill-building.

View my workMessage Me

Work samples

A collection of projects and tasks that reflect the skills I am developing while transitioning into a full-time career role.

  • 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’m Nathan Lopez, gaining hands-on experience now and preparing for the next career step through projects and skill-building.

I'm Nathan Lopez. I have some work experience and I'm exploring the next steps as I start my career. I focus on learning through practical projects and building skills that prepare me for professional roles.

Externships

Yinan Value Investing & Financial Modeling Externship

In progress

Experience

Acquisition

Sovereign Real Estate Group, Miami Lakes · January 2022 – Present

Education

Florida International University, Miami

Bachelor of Business Administration in Finance · Class of 2027

Miami Dade College, Miami

Associate in Arts in Business Administration · Class of 2025

Skills

Practical project experienceCareer-stage: early / transitioningContinuous learningHands-on work
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 companies using financial models and alternative data sources, applying valuation techniques and market-movement walkthroughs. Work included building Excel models, interpreting trading behavior, and producing structured investment analyses for multiple stocks.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I completed a series of analyst-focused modules that combined market walkthroughs, financial modeling, and stock analysis; below are the specific deliverables I produced.

Project breakdown

View all work