Indian Bank Valuation Model

I need a detailed valuation model built for an Indian bank and I already have five years of audited financials ready for you to work with. Your brief is to turn that history into a forward-looking model (5–10-year horizon) that captures the core banking drivers—NIM, loan growth, GNPA movement, provisioning, CAR, fee income, cost-to-income, and any other levers you believe matter. I am open on the exact valuation framework: a straight DCF, an Excess Return (residual income) model, or any other method that is more appropriate for banks, provided the assumptions are transparent and grounded in reality. Please document every key input—growth rates, discount rate, terminal value logic, cost of equity, etc.—so that I can stress-test them later. Deliverables • An Excel model with historical data, dynamic projections, integrated financial statements, ratio analysis, and a valuation summary tab. • A concise written report (PDF or Word) highlighting methodology, major assumptions, sensitivity analysis, and your final valuation conclusion. Timeline I’m working to a hard one-week deadline from the date we kick off. Preferred profile If you have equity research or banking sector experience and a track record of clean, auditable Excel work, you’ll be a perfect fit. Please share one or two samples of comparable models if you can (you may redact sensitive names). I will supply the historical data immediately after award, so you can focus purely on modelling and insight.

Project ID: 40352372