A curated portfolio of applied finance projects demonstrating hands-on experience in financial modeling, valuation, and market risk analysis. Each project is built using real company data and focuses on translating financial analysis into structured, decision-relevant insights.
-
Value at Risk (JPM)
Historical and Monte Carlo Value at Risk (VaR) analysis on JPMorgan Chase to quantify downside risk and tail-risk exposure using return distributions. -
Coca-Cola Co — Full Financial Model & DCF Valuation
A complete integrated 3-statement financial model for The Coca-Cola Company, including revenue forecasting, financial projections, and intrinsic valuation using the Discounted Cash Flow (DCF) approach. -
Comparable Company Analysis — Microsoft (MSFT)
Relative valuation of Microsoft using trading comparables, peer benchmarking, and market-based valuation multiples to derive an implied valuation range. -
TCS — DuPont Analysis (Part 1)
Decomposition of Return on Equity (ROE) using the DuPont framework to analyze profitability, efficiency, and leverage drivers.
-
Advanced DCF Valuation — Technology Company (e.g., NVIDIA)
Detailed intrinsic valuation incorporating multi-stage growth assumptions, reinvestment analysis, and value driver decomposition. -
Precedent Transactions Analysis
Transaction-based valuation using historical M&A deals, deal multiples, control premiums, and acquisition rationale. -
Leveraged Buyout (LBO) Model — Real-World Company
End-to-end LBO model covering capital structure, debt schedules, cash flow waterfalls, and sponsor IRR analysis.
- Financial Modeling: 3-Statement Modeling, Forecasting, Scenario Analysis
- Valuation: DCF Valuation, Comparable Company Analysis, DuPont Analysis, Precedent Transactions
- Risk & Markets: Historical VaR, Monte Carlo Simulation VaR, Return Distribution & Tail-Risk Analysis
- Excel for Finance: Advanced Formulas (XLOOKUP, PMT, IPMT, PPMT), Pivot Tables, Structured Models
- Core Finance Skills: Corporate Finance, Financial Statement Analysis, Data Interpretation, Report Presentation
📄 This repository is actively updated and reflects my progression in applied finance, valuation, and risk analytics through real-world company case studies.