TCS Financial Analysis
08 · Inputs

Model Assumptions

Values from the Assumptions sheet (amber = input). Edit any cell — every chart, KPI, scenario, sensitivity and validation check updates instantly. Edited cells are highlighted; reset restores the workbook values.

Custom Growth Override

Dashboard!C6 — uniform growth for FY26–FY28 on the active scenario. Leave blank or 0 to use scenario rates.

%
Active mode: Base Case

Revenue Growth

ParameterBearBaseBullNotes
Revenue Growth FY26
%
%
%
YoY growth applied to FY25 base
Revenue Growth FY27
%
%
%
Continued momentum
Revenue Growth FY28
%
%
%
Long-term projection

EBITDA Margin

ParameterBearBaseBullNotes
EBITDA Margin FY26
%
%
%
Year 1 EBITDA Margin
EBITDA Margin FY27
%
%
%
Year 2 - Operating leverage
EBITDA Margin FY28
%
%
%
Year 3 - Margin expansion/stabilization

Tax, Depreciation & Capex

ParameterBearBaseBullNotes
Tax Rate
%
%
%
Effective tax rate
Depreciation (% of Rev)
%
%
%
Capital intensity
Capex (% of Rev)
%
%
%
Hard-coded as 2.5% of revenue inside Forecast_Model row 28 (not on Assumptions sheet)

Share Count & Reference

ParameterBearBaseBullNotes
Shares Outstanding
Cr
Cr
Cr
Assumed constant
Implied Net Profit Margin (Est.)reference only
%
%
%
ESTIMATE ONLY: Model derives NP from EBIT − Tax. Not used in forecast formulas.
The "Implied Net Profit Margin" row is an estimate recorded in the workbook but is not referenced by any forecast formula; editing it has no effect on outputs. Capex 2.5% is hard-coded in the Forecast_Model formulas and is exposed here as an editable input for transparency.

Historical Data (locked)

FY2025 base year

Revenue
₹2,55,324 Cr
EBITDA
₹71,369 Cr
Net Profit
₹48,797 Cr
EPS (Diluted)
₹134.20

Forecast Outputs

FY2028 · Base

Revenue
₹3,26,116 Cr
EBITDA
₹92,943 Cr
Net Profit
₹64,140 Cr
EPS
₹177.18
FCF
₹62,836 Cr
3Y Revenue CAGR
8.5%