QL QuarterLens DCF boards

Nifty 50

DCF valuation board

Sort the board. Open a worksheet. Test the assumptions.

HDFC BankNSE:HDFCBANKLoading₹674.74—Sign in to open
ICICI BankNSE:ICICIBANKLoading₹1,007.11—Sign in to open
Reliance IndustriesNSE:RELIANCELoading₹1,205.99—Sign in to open
Bharti AirtelNSE:BHARTIARTLLoading₹808.04—Sign in to open
Larsen & ToubroNSE:LTLoading₹1,064.96—Sign in to open
State Bank of IndiaNSE:SBINLoading₹949.24—Sign in to open
InfosysNSE:INFYLoading₹1,599.22—Sign in to open
Axis BankNSE:AXISBANKLoading₹1,402.29—Sign in to open
Bajaj FinanceNSE:BAJFINANCELoading₹348.28—Sign in to open
Mahindra & MahindraNSE:M&MLoading₹2,414.43—Sign in to open
Kotak Mahindra BankNSE:KOTAKBANKLoading₹431.04—Sign in to open
ITCNSE:ITCLoading₹260.11—Sign in to open
Tata Consultancy ServicesNSE:TCSLoading₹2,276.13—Sign in to open
EternalNSE:ETERNALLoading₹92.8—Sign in to open
Sun Pharmaceutical IndustriesNSE:SUNPHARMALoading₹1,253.82—Sign in to open
Titan CompanyNSE:TITANLoading₹2,012.17—Sign in to open
Hindustan UnileverNSE:HINDUNILVRLoading₹1,273.61—Sign in to open
Maruti Suzuki IndiaNSE:MARUTILoading₹6,590.64—Sign in to open
NTPCNSE:NTPCLoading₹336.54—Sign in to open
Tata SteelNSE:TATASTEELLoading₹193.4—Sign in to open
Shriram FinanceNSE:SHRIRAMFINLoading₹1,147.65—Sign in to open
HCL TechnologiesNSE:HCLTECHLoading₹1,174.07—Sign in to open
Hindalco IndustriesNSE:HINDALCOLoading₹1,206.62—Sign in to open
UltraTech CementNSE:ULTRACEMCOLoading₹8,792.06—Sign in to open
Bharat ElectronicsNSE:BELLoading₹187.46—Sign in to open
Power Grid Corporation of IndiaNSE:POWERGRIDLoading₹400.64—Sign in to open
Bajaj AutoNSE:BAJAJ-AUTOLoading₹6,389.32—Sign in to open
Adani Ports and Special Economic ZoneNSE:ADANIPORTSLoading₹546.93—Sign in to open
Asian PaintsNSE:ASIANPAINTLoading₹1,485.59—Sign in to open
JSW SteelNSE:JSWSTEELLoading₹160.37—Sign in to open
Bajaj FinservNSE:BAJAJFINSVLoading₹2,405.81—Sign in to open
Grasim IndustriesNSE:GRASIMLoading₹3,806.9—Sign in to open
InterGlobe AviationNSE:INDIGOLoading₹1,536.78—Sign in to open
Eicher MotorsNSE:EICHERMOTLoading₹3,168.64—Sign in to open
Nestle IndiaNSE:NESTLEINDLoading₹828.69—Sign in to open
Tech MahindraNSE:TECHMLoading₹1,316.33—Sign in to open
TrentNSE:TRENTLoading₹849.84—Sign in to open
Coal IndiaNSE:COALINDIALoading₹569.4—Sign in to open
Oil & Natural Gas CorporationNSE:ONGCLoading₹355.57—Sign in to open
Apollo Hospitals EnterpriseNSE:APOLLOHOSPLoading₹2,185.48—Sign in to open
Adani EnterprisesNSE:ADANIENTLoading₹2,335.51—Sign in to open
SBI Life InsuranceNSE:SBILIFELoading₹1,663.04—Sign in to open
Jio Financial ServicesNSE:JIOFINLoading₹275.13—Sign in to open
CiplaNSE:CIPLALoading₹687.43—Sign in to open
Max Healthcare InstituteNSE:MAXHEALTHLoading₹681.47—Sign in to open
Tata Motors Passenger VehiclesNSE:TMPVLoading₹345.35—Sign in to open
Dr. Reddy's LaboratoriesNSE:DRREDDYLoading₹688.51—Sign in to open
Tata Consumer ProductsNSE:TATACONSUMLoading₹808.71—Sign in to open
HDFC Life InsuranceNSE:HDFCLIFELoading₹572.14—Sign in to open
WiproNSE:WIPROLoading₹281.05—Sign in to open

Inside every worksheet

A living valuation, refreshed with the business.

Start with our model, then make the assumptions yours.

Read the DCF guide

01

Updated after results

Get a refreshed DCF after every quarterly result, so the model keeps pace with the company.

02

Change the assumptions

Tweak growth, operating margins and WACC to see how your own view changes the valuation.

03

See the reverse DCF

Understand what growth and margin expectations may already be embedded in the market price.

04

Track management guidance

Keep the company’s forward guidance beside the model and compare the story with your assumptions.

Use the model. Question the model.

Valuation is sensitive to assumptions, and worksheets can contain mistakes. Double-check the inputs, source filings and calculations before relying on any output.

Access

The complete valuation toolkit.

One subscription gives you the model, the context and the checks behind the valuation.

  • Quarterly DCF updatesRefreshed after company results.
  • Editable assumptionsChange growth, margins and WACC to test your own view.
  • Reverse DCFSee what expectations may already be priced into the stock.
  • Management guidanceCompare forward commentary with the model assumptions.
  • Financial shenanigans checksReview earnings quality, cash-flow inconsistencies and aggressive-accounting red flags.
Launch offer · 67% off
USD 15 USD 5 / month
Get the complete Nifty 50 valuation toolkit at the founding-member price.