Yinan Zhao logoYinan Zhao Externship via Extern·🟢 Open to work
Andre McKenna portrait

First-year Finance student at Hofstra University

Finance major, building practical experience and exploring opportunities before launching my career.

Work samples

A collection of early work and learning experiences related to finance as I build skills and clarify my career direction.

  • Business Case Competition — Student Investing Platform Financial Plan
    Business Case Competition — Student Investing Platform Financial Plan

    National Black MBA Association, NY Metro Chapter · Jun 2026

    Business Case Competition — Student Investing Platform Financial Plan

    Built the financial plan for a student investing platform pitched at The Black MBA Business Case Competition. Modeled a PFOF-based revenue structure with 5-year projections, targeting break-even near 312,000 users.

    Business DevelopmentBudgetingBusiness StrategyAccountingCommunicationTime ManagementFinancial Modelingfin
  • 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

Finance major, building practical experience and exploring opportunities before launching my career.

André McKenna is a Finance major at Hofstra University, working toward a career in investment consulting focused on economic equity. He serves as Eastern Regional Co-Chair of the Jack and Jill of America Teen Taskforce, managing 25 members across five subcommittees, and is an Eagle Scout who founded Project Fresh Start, a clothing drive for families at the Jamaica YMCA. As Chief Investment Officer for the Jackie Robinson Foundation's case, his team placed first, and he has spent three years in the Leaders of Tomorrow program.

Externships

Yinan Value Investing & Financial Modeling Externship

In progress

Experience

Real Estate Intern

Keller Williams Realty · Sept 2024 – May 2026

Court Attendant

US Open, US Tennis Association · Aug 2023 – Aug 2025

Work-Based Learning Intern

Andrew Heiskell Braille Library · Sept 2023 – June 2024

Work Based Management Intern

Applebees · Sep 2023 - Jun 2024

Education

Hofstra University

B.B.A. in Finance · Class of 2030

Long Island University Summer Honors College

Artificial Intelligence & Digital Engineering · Class of 2025

The Summit Upper School

Regents Diploma · Class of 2026

Skills

Introductory finance knowledgeCollege-level courseworkWillingness to learnBrand MarketingBudgetingBusiness DevelopmentBusiness StrategyCanvaClaudeCommunicationCommunity ManagementCollaborationDigital MarketingExcelForecasting & PlanningGoogle GeminiGoogle SheetsPerplexityReal EstateSEM
Back to work

Business Case Competition — Student Investing Platform Financial Plan

Built the financial plan for a student investing platform pitched at The Black MBA Business Case Competition. Modeled a PFOF-based revenue structure with 5-year projections, targeting break-even near 312,000 users.

Business DevelopmentBudgetingBusiness StrategyAccountingCommunicationTime ManagementFinancial Modelingfin

Overview

Built the financial plan for a student investing platform pitched at The Black MBA Business Case Competition. Modeled a PFOF-based revenue structure with 5-year projections, targeting break-even near 312,000 users.

Business Case Competition — Student Investing Platform Financial Plan

Outcome

Won The Black MBA Business Case Competition

View all work

✅ 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 analyzing public companies through value-investing techniques and building financial models. Work combined Excel modeling, alternative-data interpretation, and market-movement case analysis under guidance from Yinan Zhao. Deliverables included stock analyses and model outputs.

Yinan Value Investing & Financial Modeling Externship

What I've accomplished

I worked through a focused analyst exercise that combined market behavior review with hands-on modeling and stock analysis tasks.

Project breakdown

View all work