Yinan Zhao logoCurrently an Extern @Yinan Zhao
Nicholas Sieber portrait

Finance student building value investing and modeling skills

Junior finance major at CU Boulder, training in value investing and financial modeling through an externship to prepare for entry-level finance roles.

View my workMessage Me

Work samples

Portfolio of projects from the Yinan Value Investing & Financial Modeling externship and related finance coursework, showing valuation, modeling, and investment research tasks.

  • 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

Junior finance major at CU Boulder, training in value investing and financial modeling through an externship to prepare for entry-level finance roles.

I am Nicholas Sieber, a junior at the University of Colorado Boulder pursuing a Bachelors in Finance. I have limited professional experience and I completed the Yinan Value Investing & Financial Modeling externship to build practical investing and modeling skills as I prepare to launch my career.

Externships

Yinan Value Investing & Financial Modeling Externship

Yinan Zhao

Skills

Value investing conceptsFinancial modelingValuation techniquesInvestment researchFinancial statement 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 involved hands-on value investing and financial modeling alongside Yinan Zhao, analyzing public equities with Excel models and alternative data. The work produced financial models, stock analyses, and written investment recommendations based on valuation and market-trend review.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I produced an initial Stock Card and a concise growth thesis for Cracker Barrel (CBRL), applying a four-part investment lens and summarizing ownership signals, valuation checks, and key risks.

Project breakdown

I picked Cracker Barrel (CBRL) for analysis, ran the course's four-part investment lens, wrote a three‑sentence growth thesis, and built an initial Stock Card summarizing ownership signals, valuation checks, and key risks.

Open Link
View all work