Yinan Zhao logoYinan Zhao Externship via Extern

Early-career finance learner focused on FP&A and valuation

I am gaining hands-on FP&A and private company valuation experience through an Attronica externship while preparing to start my finance career.

View my workMessage Me

Work samples

Work in this portfolio comes from my Attronica externship and shows applied FP&A, financial modeling, and private company valuation work completed during the program.

  • 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 gaining hands-on FP&A and private company valuation experience through an Attronica externship while preparing to start my finance career.

I am Alice Khomski. I am early in my career and exploring finance through an externship focused on financial planning, analysis, and private company valuation with Attronica. I am building practical skills and looking to apply them in real projects.

Externships

Yinan Value Investing & Financial Modeling Externship

In progress

Experience

Finance Program Intern

Community Training and Assistance Center (CTAC) · July 2025-Aug. 2025

Intern

Keeper Systems · Oct. 2023-Aug. 2024

Education

Yale University

BA in Economics · Class of 2026

Skills

Financial planning and analysisPrivate company valuationFinancial modelingFinancial analysis
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 value-investing techniques and financial models. Work included building Excel models, analyzing alternative data and market trends, and producing investment write-ups alongside guidance from Yinan Zhao. Deliverables recorded model outputs and analytic write-ups for evaluated stocks.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I picked Allegiant Travel Company (ALGT) from a Russell 2000 value screen after researching comparable travel firms with Perplexity, and carried ALGT forward as the focal stock for the 12-week analysis.

Project breakdown

During the Russell 2000 value screen, I evaluated candidates, researched comparable travel firms with Perplexity, and finalized Allegiant Travel Company (ALGT) as the stock to carry forward for the 12-week analysis.

View all work