Yinan Zhao logoYinan Zhao Externship via Extern
Michael Gonzalez portrait

Sophomore Preparing CCC Students For High Finance.

I am a second-year finance student at Pasadena City College, focused on building a career in investment banking.

View my work

Work samples

Coursework and class projects in finance and management, documenting foundational analysis, spreadsheets, and business planning as I develop practical skills.

  • 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
  • Fall 2026 Equity Research Internship Program [PENDING]

    Lancer Finance Society · Oct 2026

    Fall 2026 Equity Research Internship Program [PENDING]

    Training eight students in an eight-module intern-to-analyst program focused on equity research fundamentals. This program will conclude with a comprehensive stock presentation, which will receive critique and support from a professional at BMO Bank.

About me

I am a second-year finance student at Pasadena City College, focused on building a career in investment banking.

I am Michael Gonzalez, an equity research extern and consultant studying Business Administration and Economics at Pasadena City College. I work on valuation and financial modeling, run GNZO Media, tutor accounting, and lead equity research at the Lancer Finance Society. I am an FMVA candidate, have completed externships and programs in value investing, private equity, and accounting, and I am open to work in finance.

Externships

Yinan Value Investing & Financial Modeling Externship

In progress

Experience

Consultant

PCC Core Consulting Group · September 2026 - Present (2 months)

Participant, Forward Program

McKinsey & Company · October 2026 - Present (1 month)

Director, Equity Research

Lancer Finance Society · September 2026 - Present (2 months)

Analyst, Equity Research

Lancer Finance Society · August 2026 - September 2026 (2 months)

Equity Research Intern

Lancer Finance Society · June 2026 - August 2026 (3 months)

Embedded Tutor, Accounting

Pasadena City College · August 2026 - Present (3 months)

Owner

GNZO Media · February 2025 - Present (1 year 9 months)

Real Estate Private Equity Intern

Project Destined · September 2026 - October 2026 (2 months)

Pathways 2 Accounting

Deloitte · July 2026 - July 2026 (1 month)

Competitor, The Stock Market Game

SIFMA Foundation · January 2025 - April 2025 (4 months)

Competitor, NFTE National Youth Entrepreneurship Challenge

Network for Teaching Entrepreneurship (NFTE) · October 2024 - October 2024 (1 month)

Education

Pasadena City College

AS-T, Business Administration

Pasadena City College

AA-T, Economics

Skills

Commercial Real Estate InvestmentsCommercial Real Estate Financial ModelingPrivate EquityFinancial Modeling & ValuationExcel Crash Course
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 examined public equities through the lens of value investing and hands-on financial modeling in Excel alongside guidance from Yinan Zhao. Work combined market-movement walkthroughs, alternative data interpretation, and company-level valuation to produce investment analyses and model-driven recommendations.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I produced a Stock Card for PJT Partners that summarized valuation metrics, ownership signals, and a three-sentence growth thesis.

Project breakdown

I selected PJT Partners as the stock to analyze, applied the course lens to finalize the pick, and produced a Stock Card artifact summarizing valuation, ownership signals, and a three-sentence growth thesis.

Open Link
View all work
Back to work

Lancer Finance Society · Oct 2026

Fall 2026 Equity Research Internship Program [PENDING]

Training eight students in an eight-module intern-to-analyst program focused on equity research fundamentals. This program will conclude with a comprehensive stock presentation, which will receive critique and support from a professional at BMO Bank.

Overview

Training eight students in an eight-module intern-to-analyst program focused on equity research fundamentals. This program will conclude with a comprehensive stock presentation, which will receive critique and support from a professional at BMO Bank.

Fall 2026 Equity Research Internship Program [PENDING]

What I've accomplished

Program Plan & Curriculum: https://canva.link/6nw3mi8qzljxbx8

View all work
Back to work

Lancer Finance Society · Sep 2026

Equity Research Report | Robinhood (NASDAQ: HOOD) [PENDING]

Constructing Lancer Finance Society's first equity research report with an analysis of Robinhood (NASDAQ: HOOD).

Equity ResearchFinancial ModelingFinancial Analysis

Overview

Constructing Lancer Finance Society's first equity research report with an analysis of Robinhood (NASDAQ: HOOD).

Equity Research Report | Robinhood (NASDAQ: HOOD) [PENDING]
View all work
Back to work

Forage · Oct 2026

Bank of America - Investment Banking Job Simulation [PENDING]

Applied analytical and communication skills to advise clients while working with Bank of America's Technology, Telecom & Media Investment Banking team during a job simulation on Forage.

Overview

Applied analytical and communication skills to advise clients while working with Bank of America's Technology, Telecom & Media Investment Banking team during a job simulation on Forage.

Bank of America - Investment Banking Job Simulation [PENDING]
View all work
Back to work

Forage · Sep 2026

PGIM - Public & Private Credit Job Simulation

Learned how credit research and portfolio analysis come together to generate alpha for PGIM's clients through their hands-on job simulation via Forage, completing tasks on credit analysis, portfolio analysis, private credit deal triage, and client advisory.

Credit AnalysisPortfolio AnalysisFinancial ModelingFinancial AnalysisPrivate Credit

Overview

Learned how credit research and portfolio analysis come together to generate alpha for PGIM's clients through their hands-on job simulation via Forage, completing tasks on credit analysis, portfolio analysis, private credit deal triage, and client advisory.

PGIM - Public & Private Credit Job Simulation

What I've accomplished

- Built a 3-statement credit analysis of Scotts Miracle-Gro from its 10-K, calculating 20+ credit metrics including adjusted EBITDA, gross/net leverage, interest coverage, and FCF-to-debt - Modeled a 20% reallocation from Oil & Gas to Renewables in a 6-sector portfolio using covariance and correlation matrices - Drafted a client communication after Moody’s downgrade (Caa2 → Caa3) on Tesla bonds

View all work