A formula-driven three-statement financial model built in Microsoft Excel, integrating the Income Statement, Balance Sheet, Cash Flow Statement, and Capex & Depreciation Schedule.
-
Updated
Jul 8, 2026
A formula-driven three-statement financial model built in Microsoft Excel, integrating the Income Statement, Balance Sheet, Cash Flow Statement, and Capex & Depreciation Schedule.
Integrated 3-statement financial model, DCF & relative valuation, and scenario analysis for Larsen & Toubro — built entirely from public data (audited filings, exchange disclosures, credit ratings). 14 tabs, 855 formulas, fully linked.
Developed a corporate finance dashboard analyzing $127.9M revenue, budget variance, profitability trends, COGS behavior, and segment-level KPIs using MySQL, Power BI and Excel. Performed budget vs actual analysis, variance reporting, MoM revenue tracking, and executive-level FP&A insights.
Excel model showing how input costs and FX exposure translate into unit cost and PPV impact using scenario-based forecasting.
A 5-year integrated model DCF Valuation Model featuring Beta unlevering/re-levering and WACC analysis.
A comprehensive financial forecasting model built in Excel and Power BI, enabling long-term revenue and expense projections with dynamic scenario planning for enterprise-level decision-making.
A multi-weighted analytical model evaluating NFL QB greatness using era-adjusted metrics and z-score normalization.
Healthcare analytics project analyzing Medicare inpatient billing data to identify revenue leakage, visualize provider and DRG exposure, and model recovery scenarios using Python, SQL, Tableau, and Excel.
"Intrinsic valuation of Unilever PLC using a 5-year Unlevered Discounted Cash Flow (DCF) model. Includes WACC analysis, NWC requirements, and terminal value triangulation (Perpetual Growth & Exit Multiple) to derive an implied share price and investment recommendation."
End-to-End CLV, Churn risk and revenue retention analytics pipeline using SQL, Excel scenario modeling and Power BI decision dashboards
Add a description, image, and links to the excel-modeling topic page so that developers can more easily learn about it.
To associate your repository with the excel-modeling topic, visit your repo's landing page and select "manage topics."