Dharmil Mehta
Finance & Investment Research Analyst
Hire this person
Send a job offer directly to this candidate
About
I’m a Computer Engineering student at SPIT with a strong interest in finance and investment research. I've gained practical experience through my research internship at SPJIMR, where I worked on equity research and DCF valuation, and at Eelanos, where I worked on financial benchmarking across 150+ BSE-listed companies. I’ve also built an M&A valuation platform involving comparable companies, precedent transactions and accretion/dilution analysis.
My technical background in Python and SQL complements my finance skills and allows me to approach financial problems in a data-driven way.
Experience
Data Analyst Intern at Eelanos Consulting & Solutions Pvt. Ltd. (2026-06 – 2026-07)
BenchmarkIQ - Financial Benchmarking & Competitive Intelligence Platform
- Built a financial benchmarking platform tracking 150+ BSE-listed companies across 15+ sectors and 10 years of financial history (FastAPI + MySQL + Next.js).
- Designed a proprietary weighted percentile scoring model (Excellence Score, 0-100) across 15 financial ratios - ROE, ROCE, EBITDA Margin, 3Y Revenue CAGR spanning Profitability, Growth, Efficiency, and Safety.
- Engineered a Python ETL pipeline to parse Screener.in financial exports into a 9-table MySQL schema, and developed a FastAPI REST backend with 7+ endpoints for company profiles, peer comparison, and leaderboard rankings.
- Delivered sector-wise Excellence Model rankings in CEO-facing Excel presentations across 10 sectors, with ratio heatmaps and tier classifications for C-suite decision-making.
Research Intern at SP Jain Institute of Management and Research (SPJIMR) (2026-08 – Present)
Equity Research and DCF Valuation Modeling
- Studied equity research fundamentals and analyzed broker reports across multiple firms to build foundational knowledge in valuation methodology under mentor guidance.
- Built a full FCFF DCF model for TCS on 10 years of financials (FY17–FY26), forecasting revenue to ₹3.76 lakh Cr by FY31E and estimating a 13.07% WACC via CAPM (beta 1.13, 5.5% India ERP).
- Derived an enterprise value of ₹5.99 lakh Cr and intrinsic value of ₹1,755/share at 5% terminal growth, stress-tested through a 5×5 WACC-vs-growth sensitivity grid.
Education
B.Tech in Computer Engineering – Sardar Patel Institute of Technology (2024 – present)
Minor in Financial and Strategic Management (Six Ladders) – Sardar Patel Institute of Technology (2024 – present)
HSC – Prakash College (2022-06 – 2024-05)
ICSE – Thakur International School (2010-06 – 2022-05)
