Extern Externship via Extern·🟢 Open to work
I am passionate about sourcing deals and analyzing startups in the venture capital space, ready to make an impact from day one.
Discover my journey through various projects, including externships in deal sourcing and financial modeling.
Mangusta Capital · Apr 2026 · ✅ Verified by Extern
Join a new VC fund launched by a former SoftBank Vision Fund leader and backed by the Ray-Ban/Oakley family to identify high-potential Vertical AI startups. Gain hands-on experience sourcing deals, analyzing markets, and writing compelling investment memos.
.jpg)
Yinan Zhao · Oct 2026 · ✅ Verified by Extern
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.
I am passionate about sourcing deals and analyzing startups in the venture capital space, ready to make an impact from day one.
I am Bill Lin, a Baruch College finance student graduating in 2027. I have hands-on experience in equity research and deal sourcing through externships with Yinan Value Investing and Mangusta Capital, where I built financial models, forecasted cash flows, and wrote investment memos and stock pitches. I am learning to analyze markets, evaluate startups, and communicate investment recommendations. I am open to work and seeking opportunities to apply my financial analysis skills.
Externships
Excel & AI Financial-Modeling Sprint
In progress
Experience
Equity Research
Yinan Value Investing & Financial Modeling · April 2026-present
Deal Sourcing & Startup Analyst
Mangusta Capital · January 2026 - April 2026
Education
Baruch College, CUNY
B.A. Major: Finance · Class of 2027
Skills
✅ Verified by Extern
Join a new VC fund launched by a former SoftBank Vision Fund leader and backed by the Ray-Ban/Oakley family to identify high-potential Vertical AI startups. Gain hands-on experience sourcing deals, analyzing markets, and writing compelling investment memos.
The externship centered on sourcing, diligencing, synthesizing, and memoizing investment opportunities aligned with a Vertical AI thesis. Work included a sourced list of five candidate startups, a due diligence dossier on Salt AI, synthesis reports for Vitro3D, and a 3-slide investment memo for Salt.ai detailing TAM and ARR upside estimates.
I produced a linked pipeline of five sourced startups, full due diligence notes for Salt AI, synthesis reports for Vitro3D, and a 3-slide investment memo for Salt.ai with TAM and ARR upside estimates.
✅ Verified by Extern
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.
The externship analyzed public equities using financial models and alternative datasets, guided by Yinan Zhao. Work combined Excel valuation models, market-movement walkthroughs, and investment write-ups. Deliverables included worked models and documented investment analyses.
I selected Navitas Semiconductor (NVTS), applied a four-part investment lens, and produced an interactive Stock Card that documented the investment analysis.
Conducted market research and analysis on industry trends and financial performance under the guidance of faculty and industry professionals. Developed stock pitches involving forecasting earnings, evaluating cash flows, and assessing investment risks. Presented insights to a review panel to inform investment recommendations, strengthening skills in financial reporting, performance evaluation, and professional communication.
✅ Verified by Extern · ⏱️ In progress
Build a three-statement model, forecast with drivers, run a DCF, and pitch a company like a pro. In this 3-week sprint, GPT helps you work faster—so you can walk away with real valuation skills and a polished investor deck.
The project built a three-statement financial model with driver-based forecasts, performed a discounted cash flow valuation, and assembled an investor deck. Work incorporated AI-assisted workflows to accelerate model construction and produced a DCF valuation alongside supporting schedules and presentation slides.
.png)
I built a three-statement forecast, constructed valuation schedules, and prepared an investor-style pitch, using Excel and AI tools to speed model assembly and analysis.
