Yinan Zhao logoCurrently an Extern @Yinan Zhao
Jacqueline Augugliaro portrait

Junior finance student focused on investment analysis

I build Excel financial models, analyze market and alternative data, and write investment recommendations drawn from a value investing externship.

View my work

Work samples

Project work centers on stock analysis, Excel-based financial modeling, trend evaluation, and investment recommendations developed during the Yinan Value Investing externship.

  • 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.

    Financial Statement AnalysisInvestment AnalysisData AnalysisExcelFinancial Modeling

About me

I build Excel financial models, analyze market and alternative data, and write investment recommendations drawn from a value investing externship.

I am Jacqueline Augugliaro, a junior finance major at Drexel University building practical investment and financial modeling skills. I completed the Yinan Value Investing & Financial Modeling externship, where I analyzed stocks, used Excel models, reviewed alternative data, and wrote investment recommendations to prepare for a career in finance.

Externships

Yinan Value Investing & Financial Modeling Externship

Yinan Zhao

Skills

Financial modeling in ExcelEquity research and stock analysisInterpreting alternative dataWriting investment recommendationsMarket trend evaluationValuation fundamentals
Back to works
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.

Financial Statement AnalysisInvestment AnalysisData AnalysisExcelFinancial Modeling

Overview

The externship covered equity research methods, financial-model construction, and stock selection workflows. The work produced a screening and comparison of candidate companies, tracked price trends and recent drivers, and selected a single publicly traded company to follow for further analysis.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I selected Vishay Intertechnology (VSH) after screening and comparing candidates, and documented its price trends and recent movement drivers as the chosen stock to follow.

Project breakdown

I picked Vishay Intertechnology (VSH) after screening and comparing candidates. I tracked its price trends, investigated recent drivers of movement, and completed a final quick check that resulted in selecting VSH as my stock to follow for the externship.

View all works