MGJunior Equity Analyst
Mridul Gupta portrait

Graduate student focused on finance and investment analysis

I build financial models, analyze market and alternative data, and evaluate stocks and early-stage startups for investment decisions.

View my workMessage Me

Work samples

Portfolio items include stock analyses with financial modeling and investment writeups, plus startup sourcing and diligence memos from an HP Tech Ventures externship.

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

    Yinan Zhao · Dec 2025 · ✅ 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.

    Financial Statement AnalysisInvestment AnalysisData AnalysisExcelFinancial Modeling
  • HP Tech Ventures: Deal Sourcing & Startup Analysis Externship
    HP Tech Ventures: Deal Sourcing & Startup Analysis Externship
    HP Tech Ventures logo

    HP Tech Ventures · Dec 2025 · ✅ Verified by Extern

    HP Tech Ventures: Deal Sourcing & Startup Analysis Externship

    An HP Tech Ventures externship focused on sourcing, evaluating, and memoizing early-stage technology startups for venture diligence.

    Data AnalysisInvestment AnalysisEntrepreneurship

About me

I build financial models, analyze market and alternative data, and evaluate stocks and early-stage startups for investment decisions.

I am Mridul Gupta, a graduate student focused on finance. I completed externships in value investing, financial modeling, and deal sourcing, learning Excel-based models, alternative data interpretation, market analysis, and early-stage startup evaluation.

Externships

Yinan Value Investing & Financial Modeling Externship

Completed · Dec 2025

Experience

Junior Equity Analyst

KAFK Capital Partners · Jun’26 – Aug’26

Investment Banking Intern

Perigon Consiliario · Apr’26 – Jun’26

Private Equity Apprenticeship

Stator Capital · Jan’26 – Apr’26

HP Tech Ventures: Deal Sourcing & Startup Analysis Externship

Extern · Dec’25 – Jan’26

Equity Research Externship

Extern · Oct’25 – Dec’25

IB Research & Deal Origination Intern

Vault Catalyst · Dec’25

Student Mentor

Student Mentorship Programme – VNIT NAGPUR · Jun’23 – May’24

Education

Indian Institute of Management, Indore

Master of Business Administration

Visvesvaraya National Institute of Technology

Bachelor of Technology – Electrical & Electronics Engineering

Skills

Financial modeling in ExcelValue investing analysisInvestment memo writingAlternative data interpretationMarket trend analysisStartup sourcing and evaluation
Back to work
Yinan Zhao · Dec 2025 ↗

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

Financial Statement AnalysisInvestment AnalysisData AnalysisExcelFinancial Modeling

Overview

The work followed a structured externship in value investing and equity research, centered on a single company case study. Deliverables included a company selection and screening, a 10-K and financial-statement review, a competitor analysis, a multi-year Excel forecast, a DCF valuation producing a per-share estimate, and a final investment memo. The analysis produced a DCF-derived price of

Yinan Value Investing & Financial Modeling Externship
Google Docs
Access

What I've accomplished

I produced a full equity-research package for Silicon Laboratories, including a 3–5 year Excel forecast, a DCF valuation that implied a $289.47 per-share price, and a final memo recommending Hold with a 25–30% upside range.

Project breakdown

View all work
Back to work
HP Tech Ventures · Dec 2025 ↗

✅ Verified by Extern

HP Tech Ventures: Deal Sourcing & Startup Analysis Externship

An HP Tech Ventures externship focused on sourcing, evaluating, and memoizing early-stage technology startups for venture diligence.

Data AnalysisInvestment AnalysisEntrepreneurship

Overview

The externship produced a full deal-sourcing-to-memo workflow for early-stage tech startups. Work included sourcing five target companies with documented profiles, building a diligence-ready company overview from public filings and press, synthesizing findings into market, technology, leadership, competitive, and synergy reports, and producing a three-slide investment memo for a Series A edge AI

HP Tech Ventures: Deal Sourcing & Startup Analysis Externship
Google Slides
Access

What I've accomplished

I produced a complete deal-prep package: five sourced startup profiles, a diligence-ready company overview, synthesized reports on market/technology/leadership/competition/synergy, and a three-slide investment memo for a Series A edge AI SoC company.

Project breakdown

View all work
Back to work

Mergers & Acquisition Program

Performed M&A analysis for ₹330 Cr deal, built comps (₹240–307 Cr) and DCF (₹143 Cr) models with range of ₹240–270 Cr. Delivered IC recommendation and structuring a phased offer with earn-out and founder lock-in terms across 7-point risk register.

View all work
Back to work

Real Estate Private Equity Virtual Intern

Underwrote 2 Real Estate deals ($6.5M & $17M), projecting 12.96% & 10.54% IRR & prepared LP facing investment summary.

View all work
Back to work

Study of Peer-to-Peer Energy Trading Market Using Hyperledger Fabric-Thesis Project

Designed P2P trading platform & developed welfare optimized pricing strategies leading 20-30% improvement in trading flexibility.

Hyperledger Fabric
View all work
Back to work

Pet Care Startup Concept & Financial Modelling-Introduction to Entrepreneurship

Conceptualized a (D2C) vegan pet care brand and targeting 3 million+ urban pet parents with SOM of (₹10,000 CR) in India.

View all work
Back to work

Investment Banking & Markets Program

Modeled 5-year CAC–CLV framework for social media startup, analyzing ₹75,00,000+ marketing spends & 2,00,000 user bases. Projected equity dilution scenarios (2.5% – 12%) through convertible note modelling linked to 5 milestone-based user targets.

View all work