Journey About Knowledge Projects Resume Contact
Aspiring CFA Student  |  Investment Analyst

Om
Kandpal

MBA Finance  ·  Equity Research & Investment Analyst Professional

Finance student building real skills — financial modelling, DCF valuation, derivatives strategy, and Python-powered analysis. Aspiring CFA candidate on a mission to understand how markets price businesses versus what they're actually worth.

CFA
Aspiring Candidate
and MBA Student
5+
Finance Projects
Built from Scratch
Valuation Analyst
DCF and Comparable
IB & ER

Investment Banking / Research
My Story

The Journey

From Physics to finance — a deliberate pivot built on curiosity, real projects, and a drive to understand how markets work.

2016 — SSC · CBSE
Kumaon Public School
Secondary Education — Uttarakhand
Foundation years that built discipline, structured thinking, and a love for numbers.
2018 — HSC · CBSE
Kumaon Public School
Higher Secondary — Science Stream (PCM)
Graduated with 8.8 CGPA in Physics, Chemistry and Mathematics. The quantitative rigour of PCM became the foundation for financial modelling and analytical problem-solving in finance.
Physics Mathematics Chemistry
2021 — B.Sc.
B.Sc. Physics, Chemistry, Mathematics
Undergraduate Degree
Developed a systematic, model-based approach to problem-solving — directly transferable to financial modelling, valuation frameworks, and quantitative risk analysis.
Analytical Rigour Statistical Thinking
2021 – 2022
Advanced Certificate in Digital Marketing & Communication
MICA — The School of Ideas, Ahmedabad
Completed MICA's Advanced Certificate programme covering digital marketing strategy, brand communication, consumer behaviour, social media, content marketing, and campaign analytics.
MICA Certified Digital Marketing Brand Communication
📣
Advanced Certificate in Digital Marketing & Communication
MICA — The School of Ideas · Ahmedabad
2021 – 2022
Jan – Mar 2023
Digital Marketing Intern
H.S.P Consultants
Website analysis, WordPress content management, awareness campaigns, and marketing plan contribution. First real exposure to data-driven business decision-making.
Digital Marketing Analytics
Jun 2023 – Oct 2024 · 16 Months
Marketing Executive
Creative Mind — Dream CAT · Mumbai
Led full-funnel performance marketing campaigns. Achieved an industry-leading 5% CTR and ROAS 4.0x — generating ₹4 lakh revenue on ₹1 lakh spend in 4 months. Managed Meta Ads Manager, Google Analytics, Instagram, and Canva.
5% CTR ROAS 4.0x Meta Ads Google Analytics
Aug 2024
Microsoft SQL Certification
Intellipaat Software Solutions — Verified
Completed structured SQL training — queries, joins, aggregations, subqueries, and database management fundamentals applicable to financial data analysis.
🗄️
Microsoft SQL Certification Training
Intellipaat Software Solutions
Aug 2024 · ID: 31679-2853-254729
SQL Database Querying Data Analysis
2025 – 2027 · Current
PGDM — E-Business (MBA Finance Focus)
S.P. Mandali's WeSchool (Welingkar Institute), Mumbai
Post-Graduate Diploma in Management. Deep focus on financial modelling, equity research, derivatives strategy, and technology. Aspiring CFA candidate working toward Level I.
Financial Modelling Equity Research Derivatives Aspiring CFA
🐍
Python for Data Analysis
Intellipaat Software Solutions
Sep 2025 · ID: 31679-1006142-254729
2025 – Present · Internship
Derivatives Strategy & Market Analysis Intern
Stock Broking Firm · Mumbai
Working on live derivatives strategy, market analysis, and risk-reward setups on NSE options. Exposure to real-time options P&L tracking, butterfly spreads, intraday Greek behaviour (Δ, Γ, Θ, V), and structured trade journaling. Built a Python-based automated system to track 10 Nifty butterfly strategies simultaneously via Dhan API and GitHub Actions.
Live Derivatives Options Strategy Risk-Reward Analysis Python Automation Nifty Options
Who I Am

About Me

"I started in marketing. Then I opened a balance sheet — and never looked back."

Today I'm an MBA Finance student at Welingkar, interning at a stock broking firm where I work on derivatives strategy, market analysis, and risk-reward setups. Along the way I've built DCF models, run sector analyses, and developed a deep curiosity for how businesses are priced by markets versus what they're actually worth.

I'm working toward a career in Equity Research or Investment Banking — roles where analytical rigour and market awareness matter more than anything else. Still learning, but learning fast.

My edge is unusual: a Physics background that trained me to model systems and quantify uncertainty, 16 months of real business experience in performance marketing, a MICA certification in digital marketing, and a genuine obsession with valuation. I'm also an aspiring CFA candidate, building toward the rigour the charter demands.

"The best analysts aren't just good at numbers — they're good at asking the right questions. I've been training myself to do both."
Aspiring CFA Mumbai Open to Opportunities PGDM 2025–27
Finance & Valuation
Financial Modelling90%
DCF & WACC85%
Comparable Analysis80%
Ratio & Risk Analysis82%
Derivatives / Options72%
Technical Skills
Excel / Modelling88%
Python (pandas, scipy)65%
Power BI / DAX62%
Microsoft SQL60%
Finance Knowledge

Knowledge Vault

A structured map of finance learning — from financial statements to derivatives and quantitative risk models.

📊
Level 1 · Foundation
Financial Statements
P&L, Balance Sheet, Cash Flow — built Gujarat Gas's 10-year 3-statement model from annual reports. Full interconnection and cross-checks across all three.
📐
Level 1 · Foundation
Ratio Analysis
25+ ratios across profitability, efficiency, liquidity and solvency over 10 years. ROIC, ROE, Interest Coverage, Cash Conversion Cycle, CFO/Sales.
📋
Level 1 · Foundation
Common Size Statements
Vertical analysis of P&L and Balance Sheet as % of revenue/assets — identified structural margin compression and capital structure shifts at GGL over a decade.
🏗️
Level 1 · Foundation
Corporate Finance Basics
Capital structure, cost of capital, debt vs equity trade-offs, dividend policy — applied in GGL's balance sheet analysis and WACC computation.
🏦
Level 2 · Valuation
DCF Valuation
Full FCFF-based DCF for GGL. WACC: 18.60% via peer beta re-levering (Hamada). Terminal growth from ROIC × Reinvestment Rate. Full WACC–TGR sensitivity table.
🔄
Level 2 · Valuation
WACC & Beta Calculation
Re-levered peer betas across 5 CGD peers. Python automation reduces 2+ hours of Excel work to 2 minutes using live NSE data and OLS regression.
⚖️
Level 2 · Valuation
Comparable Company Analysis
EV/Revenue, EV/EBITDA, P/E comps vs 6 CGD peers. Implied: ₹255 (EV/Rev), ₹174 (EV/EBITDA), ₹235 (P/E). Full football field analysis.
📈
Level 2 · Valuation
Revenue Forecasting
Weighted Average Historical Growth Rate — 10-year history, weights 1–10 (heavier on recent years). Forecast Revenue, EBITDA, Net Profit, EPS through FY2030E.
🔍
Level 3 · Research
Equity Research
Full research report on Gujarat Gas — company profile, investment highlights, financial analysis, all valuation methodologies, SELL recommendation at CMP ₹308.
🏛️
Level 3 · Research
Sector Analysis
India's CGD sector — PNGRB regulation, geographical area licensing, volume dynamics (Morbi ceramics, CNG, PNG domestic), competitive structure and moat.
📉
Level 3 · Research
ROIC & Capital Efficiency
Invested Capital, ROIC trajectory (45.8% FY21 → 20.7% FY25), Reinvestment Rate, intrinsic growth rate. Declining returns identified as key investment risk.
📊
Level 3 · Research
Power BI Dashboards
Built interactive BI dashboards in Power BI — data modelling, DAX measures, KPI cards, slicers. Applicable to financial reporting and deal-room analytics.
🦋
Level 4 · Advanced
Options — Butterfly Spreads
Live automated tracker for 10 butterfly strategies on Nifty 50 options. Real-time Greeks (Δ, Γ, Θ, V), IV, OI, strategy value and running P&L via Dhan API.
📉
Level 4 · Advanced
Value at Risk (VaR)
Historical VaR and Monte Carlo VaR (5,000 replications) for Gujarat Gas. 95% confidence: −3.29% max single-day loss. Both methods statistically validated.
🤖
Level 4 · Advanced
Python in Finance
OLS beta regression via live NSE data, 20-year market return automation, LangChain NLP product search — applying code to solve real finance problems.
🧮
Level 4 · Advanced
Monte Carlo Simulation
5,000-replication MC VaR using historical mean and σ of daily returns. Statistical comparison against historical approach — deviation within 0.08%.
Work & Projects

Projects Showcase

Real projects built with actual data, genuine methodologies, and original conclusions — not textbook exercises.

📊 Financial Modelling · Equity Research · April 2026
Gujarat Gas Ltd — Financial Modelling & Valuation
10-year 3-statement model · DCF · Comps · Monte Carlo VaR · SELL Recommendation
📄 PDF Report
18.60%
WACC
₹193
DCF Base Value
₹308
CMP Apr 2026
−59%
Overvalued By
10 yrs
Historical Data
5,000
MC Simulations
Objective
Complete buy-side style financial analysis of Gujarat Gas Limited (NSE: GUJGASLTD) — India's largest CGD company by volume — to derive an intrinsic value and issue an investment recommendation.
Methodology
1. Historical Analysis — 10-year Income Statement, Balance Sheet & Cash Flow (FY2016–FY2025). Common size + 25+ ratios.

2. Forecasting — Weighted Average Historical Growth Rate, weights 1–10. Revenue, EBITDA, Net Profit, EPS through FY2030E.

3. WACC — Re-levered beta across 5 CGD peers (Hamada). CAPM: Rf 6.93%, ERP 8.21%, β 1.40. WACC: 18.60%.

4. DCF — FCFF-based with ROIC-derived intrinsic growth (27.2%). Sensitivity: WACC (16–22%) × TGR (3–7%).

5. Comps — EV/Rev, EV/EBITDA, P/E vs 6 peers. Football field analysis.

6. VaR — Historical + Monte Carlo (5,000 runs) single-day downside risk.
Key Findings

📌 DCF intrinsic value: ₹193/share — stock overvalued by 59% at CMP ₹308.

📌 EBITDA margin declined 21.3% (FY21) → 11.6% (FY25) — structural compression.

📌 ROIC fell 45.8% (FY21) → 20.7% (FY25) — diminishing returns on new capital.

📌 Near debt-free (₹150 Cr) — strong balance sheet but premium unjustified.

📌 Monte Carlo VaR (95%): max single-day loss of 3.21%.

📌 Football field: ₹139–₹277 — CMP above every methodology.

Valuation Summary
MethodValuevs CMP
DCF Base₹193OV 59%
DCF Bull₹245OV 26%
EV/EBITDA Comps₹174OV 77%
P/E Comps₹235OV 31%
ExcelDCFWACCCompsMonte CarloVaRROIC3-Statement
Files: 📄 Valuation PDF
🐍 Python · Finance Automation · 2025
WACC & Beta Automation Tool
Live NSE data · OLS regression · Peer beta table · 2 hours → 2 minutes
🐍 .ipynb Notebook
2 min
vs 2hr Manual
Live
NSE/BSE Data
OLS
Beta Regression
20 yr
Market Return
Problem Solved
When building the Gujarat Gas valuation, computing peer betas manually in Excel required downloading price histories for 5+ stocks, running regression, re-levering via Hamada, and computing WACC — 2+ hours of repetitive work every time inputs changed.
How It Works
1. Input a list of NSE/BSE tickers

2. Auto-downloads 2 years of weekly prices via yfinance

3. OLS regression (stock vs Nifty 50) → levered beta, R², observations

4. Downloads 20 years of Nifty monthly data → avg annual return + dividend yield → total market return

5. Outputs clean tables ready for any WACC model
Key Learning

💡 First real Python-in-finance workflow — automation eliminates human error in repeated calculations, not just saves time.

💡 OLS via scipy.stats.linregress gives identical results to Excel SLOPE() — validated against GGL beta of 0.90.

💡 Built modularly — change the STOCKS list, full peer beta table regenerates under 2 minutes.

PythonyfinancescipypandasOLS RegressionGoogle Colab
Files: 🐍 wacc_beta_calculator.ipynb
🦋 Derivatives · Options · Python · Live Market · 2025
Butterfly Research System — Live Options Tracker
10 strategies · Real-time Greeks · GitHub Actions · Google Sheets automation
🐍 Python Script
10
Strategies
30 min
Auto-Update
Live
Dhan API
Free
Cloud Hosted
What It Does
Automated cloud system tracking 10 butterfly spread strategies on Nifty 50 options simultaneously — 5 Put Butterflies + 5 Call Butterflies at strike gaps of 100, 200, 300, 400, and 500 points. Runs every 30 minutes during market hours via GitHub Actions. Zero manual intervention.
Architecture
Data: Dhan API → live option chain (nearest Tuesday expiry)

Processing: Strategy Bid/Ask/Mid, Spread, IV, Delta, Gamma, Theta, Vega, OI, Volume

State: Entry price/time/IV persisted in Google Sheets across stateless runs

Output: Section 1 (intraday table) + Section 2 (daily summary, max P&L, IV range)
What I Learned

💡 Butterfly spreads in practice: buy wing1 + wing2 − 2× sell body. Cost = max loss. Strike gap = profit zone width.

💡 State persistence in stateless systems — each GitHub Actions run is fresh, so trade state must be written and re-loaded each cycle.

💡 Real Greeks behave differently from theory — Theta accelerates near expiry, IV spikes inflate strategy costs with flat underlying.

💡 Built with AI assistance — used as a force-multiplier, not a substitute for understanding the strategy logic.

PythonDhan APIgspreadGitHub ActionsOptions GreeksButterfly Spread
Files: 🐍 butterfly_research_system.py
🤖 AI · LangChain · NLP · Academic · 2025
AI Sales Chatbot — Clothing E-Commerce
12,000+ products · Natural language search · Voice input & output · LangChain + OpenAI
🐍 .ipynb Notebook
12K+
Products
NLP
Query Engine
Voice
In & Out
GPT
Powered
Objective
AI-powered conversational sales assistant for a clothing platform that understands natural language, filters 12,000+ products intelligently, and responds with voice output — simulating a real retail AI assistant end-to-end.
How It Works
1. User types or speaks: "Women's blue jeans under ₹1500"

2. LangChain + OpenAI extracts: gender, category, colour, price, occasion, material

3. Pandas filters 12,000+ rows using extracted parameters

4. Results ranked and shown as product cards

5. gTTS converts response to speech — bot talks back
Relevance to Finance

💡 Large dataset handling (12K+ rows) — same skill applies to Bloomberg exports, equity universes and financial databases.

💡 NLP-driven filtering mirrors analyst information processing — extract, filter, rank. Similar to building stock screeners.

💡 Shows cross-domain ability: AI + data engineering + product thinking — differentiates a candidate who can build, not just analyse.

PythonLangChainOpenAI GPTPandasgTTSSpeechRecognition
Files: 🐍 AI_Sales_Chatbot_Clothing.ipynb
📊 Power BI · Data Analytics · Academic · WeSchool
Business Intelligence Dashboard — Power BI
Interactive KPI tracking · DAX measures · Data modelling · Visual storytelling
📊 .pbix File
Power BI
Platform
DAX
Measures
KPI
Tracking
Interactive
Visuals
Objective
Designed and built an interactive business intelligence dashboard in Microsoft Power BI as a WeSchool assignment — transforming raw business data into actionable visual insights for decision-makers.
Skills Demonstrated
— Data import, cleaning & transformation (Power Query)

— Data modelling and relationship management

— DAX formula authoring for calculated measures & KPIs

— Interactive charts, slicers, and card visuals

— Dashboard layout and UX for business reporting
Finance Application

💡 Power BI is widely used in IB and corporate finance for management reporting, financial dashboards, and deal tracking.

💡 Data modelling skills — relationships, calculated fields — map directly to integrated 3-statement modelling.

💡 Visual storytelling is a core IB skill — presenting complex numbers clearly for senior stakeholders in pitch books and CIMs.

Power BIDAXPower QueryData ModellingKPI Design
Files: 📊 Power_BI_Assignment.pbix
🚧 In Progress · 2026
More Projects Coming Soon
Working on: Multi-stock sector screener · Full IB pitch deck · Options P&L simulator
Professional Profile

Resume

MBA Finance student targeting Investment Banking and Equity Research. Aspiring CFA candidate.

Request Full Resume →
Education
PGDM — E-Business (MBA Finance Focus)
WeSchool (Welingkar Institute), Mumbai
2025 – 2027 · Current
Post-Graduate Diploma in Management. Deep focus on financial modelling, equity research, derivatives, and technology. Aspiring CFA candidate.
B.Sc. — Physics, Chemistry, Mathematics
Completed 2021
Strong quantitative foundation. PCM background informs modelling precision and statistical approach to finance problems.
HSC — CBSE Science Stream
2018
Certifications
Advanced Certificate — Digital Marketing & Communication
MICA — The School of Ideas, Ahmedabad
2021 – 2022
Microsoft SQL Certification Training
Intellipaat Software Solutions
Aug 2024 · ID: 31679-2853-254729
Python for Data Analysis
Intellipaat Software Solutions
Sep 2025 · ID: 31679-1006142-254729
Experience
Derivatives & Options Intern
K2J Brokers · Delhi
2025 – Present
Live derivatives strategy, market analysis, risk-reward setups on NSE options. Real-time P&L tracking, butterfly spreads, and Greek behaviour analysis.
Marketing Executive
Creative Mind · Lucknow
Jun 2023 – Oct 2024 · 16 months
5% CTR · 4.0x ROAS · ₹4L revenue on ₹1L spend in 4 months. Meta Ads Manager, Google Analytics, Instagram, Canva.
Digital Marketing Intern
H.S.P Consultants
Jan – Mar 2023
Website analysis, WordPress content management, campaign development, marketing planning.
Finance Skills
Financial ModellingDCF Valuation WACC & BetaComparable Analysis Ratio Analysis3-Statement Model Equity ResearchMonte Carlo VaR Options — ButterflyBeta Re-levering ForecastingFootball Field ROIC AnalysisDerivatives Strategy
Technical Skills
ExcelPython Pandas / NumPySciPy SQLPower BI DAXLangChain GitHub Actionsyfinance Google ColabCanva
Let's Connect

Get In Touch

Open to internship opportunities, IB/ER analyst roles, and finance conversations. Mumbai based.

Whether you're a recruiter, fellow analyst, or someone curious about finance — I'd love to connect. I respond within 24 hours.

Send a Message
✓ Opening your mail client...