HDFC Bank Valuation & Infosys LBO Model with Power BI Analytics
Comprehensive DCF valuation and Leveraged Buyout model integrated with interactive Power BI visual dashboards for sensitivity analysis.
1. HDFC Bank Limited (NSE: HDFCBANK) — Intrinsic Equity Valuation Model
Framework: Dividend Discount Model (DDM) & Warranted Price-to-Book (P/B) Analysis
Repository File: HDFC_Bank_Valuation.xlsx
Overview & Objective
An institutional-grade equity valuation model built specifically for bank analysis, evaluating the intrinsic valuation, capital adequacy, and return metrics of HDFC Bank Limited post-merger. Because traditional Free Cash Flow to Firm (FCFF) models fail to capture banking operations (where interest is revenue and deposits are operational liabilities), this project leverages banking-specific valuation methodologies.
2. Infosys Limited (NSE: INFY) — Leveraged Buyout (LBO) Model
Framework: 5-Year LBO Analysis, Debt Waterfall Schedule & Sponsor Return Matrix
Repository File: Infosys_LBO_Model.xlsx
Overview & Objective
A dynamic Leveraged Buyout (LBO) financial model evaluating the transaction mechanics, debt paydown capacity, and sponsor return profile (IRR / MoIC) for a hypothetical LBO acquisition of Infosys Limited.
Conclusion & Future Scope
This portfolio demonstrates an end-to-end institutional corporate finance workflow—combining fundamental equity research, multi-scenario financial modeling, and private equity deal structures.
Key Methodology Takeaways
Tailored Banking Models: Standard FCFF models misrepresent financial institutions; applying Dividend Discount Models (DDM) and Gordon Growth Warranted P/B frameworks provides accurate intrinsic valuations for commercial banks like HDFC Bank.
Dynamic LBO De-leveraging: Leveraged buyouts require dynamic cash flow sweeps to track debt paydowns, interest coverage ratios, and overall sponsor IRR/MoIC under volatile exit environments.
Future Modeling Roadmap
[ ] Automated Power BI Dashboards: Integrating live data feeds to visualize model outputs dynamically.
[ ] 3-Statement M&A Merger Models: Expanding coverage to evaluate accretion/dilution mechanics in public cross-border acquisitions.
Connect & Collaborate
I am open to discussions regarding Equity Research, Corporate Finance, Investment Banking, and Financial Analyst roles.
Portfolio Website: royaaditya.framer.website
GitHub Repository: Finance_Project
Email: royaadityawork@gmail.com
Location: New Delhi, India
