Anmol Gupta

Built 10-year DCF valuation model for NandaHouse built on a three-statement forecast (Income Statement, Balance Sheet, Cash Flow) driven by a detailed revenue, cost, and asset register engine. The valuation uses WACC to discount FCFF, with terminal value computed via both Gordon Growth and EBITDA Multiple methods, bridging from Enterprise Value to Equity Value and a target share price.

Slashed pricing errors by 30% by building client-specific Excel pricing templates aligned to rate cards and standardizing end-to-end pricing reviews for ~150 sheets/month. Automated multi-template consolidation to eliminate ~8 hours/week of manual effort and surfaced $1.3M in misallocated resource costs via Actual vs. Proposed variance analysis, improving deal-cycle speed by an estimated 20%.

Managed an $800M annual revenue budget across 6 business cohorts, consolidating monthly Revenue & Margin inputs and presenting risk/opportunity assessments to Senior Management. Improved forecast accuracy by 10% with a 4-stage quarterly forecasting model, cut manual reporting effort by 780+ hours/year through advanced Excel automation, and reduced forecasting error by 10% using a structured risk &

Authored an equity research report on Indian macro trends using a top-down framework; insights generated interest from 3 investment firms evaluating India market entry.

Completed an MBA in Finance at IMT Ghaziabad.

Completed a B.Tech in Mechanical Engineering at ABES Engineering College.