Yinan Zhao logoCurrently an Extern @Yinan Zhao
eshrat tahsin portrait

Aspiring Finance Professional

I'm an emerging finance enthusiast passionate about investment and financial modeling, eager to connect and grow in the industry.

Work samples

Discover my work in value investing and financial modeling, where I analyze stocks and apply real-world financial skills.

  • Yinan Value Investing & Financial Modeling Externship
    Yinan Value Investing & Financial Modeling Externship
    Yinan Zhao logo

    Yinan Zhao · Aug 2026 · ✅ Verified by Extern

    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 an emerging finance enthusiast passionate about investment and financial modeling, eager to connect and grow in the industry.

I'm at the beginning of my career journey, exploring new paths as I seek to build valuable relationships and expand my professional network. With a Bachelor's degree, I've gained foundational knowledge and am eager to delve deeper into the finance and investment sectors.

Externships

Yinan Value Investing & Financial Modeling Externship

Yinan Zhao

Experience

Retail Sale Associate

Cosmo Canna · Sep 2025

Education

Centennial College

Post graduate diploma in Global Business Management · Class of 2023

Skills

Value InvestingFinancial ModelingExcelMarket AnalysisInvestment Recommendations

✅ Verified by Extern

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 applied value-investing research and Excel financial modeling to Amneal Pharmaceuticals (AMRX). Work verified AMRX's Russell 2000 Value membership, produced a Stock Card HTML, and populated a research spreadsheet with verified 10-K quotes, dates, and three years of financial metrics that highlighted an 80% operating income increase in one year and a net margin decline in 2024. The

Yinan Value Investing & Financial Modeling Externship
Google Docs
Access

What I've accomplished

I verified AMRX's Russell 2000 Value membership from a fund holdings CSV, produced a Stock Card HTML, and compiled a research spreadsheet with verified 10-K quotes, dates, and three years of financial metrics that flagged an 80% operating income increase in one year and a net margin decline in 2024.

Project breakdown

View all works
Back to works

Yinan Value Investing & Financial Modeling Externship!

Competitive AnalysisCorporate FinanceDCF AnalysisForecastingQuantitative Analysis
View all works