LTI DataStudy can be done From below:
GROWTH | LIQUIDITY | SOLVENCY | PROFITABILITY | VALUATIONS | |||||||||||||||||||
SALES GROWTH | P-MARGIN | CUR.RATIO | TRADE CYC | DEBT2EQUITY | DEBTRATIO | ICR | ROE | ROPE | ROA | F-PE_23 | YIELD_23 | BOOKVALUE | PBV | PEG | |||||||||
31% | 14% | 3 | 20% | 0.7% | 27% | 43 | 31% | 164 | 22% | 23.8 | 4.2% | 533 | 7 | 0.8 | |||||||||
Estimate | Year | Sales | Profit | EPS | FairValue | ||||||||||||||||||
2035 | 124,478 | 18,412 | 1,051 | 18912 | |||||||||||||||||||
2030 | 61,888 | 9,154 | 522 | 9403 | TRAIL-EPS | Q2 | Q3 | Q4 | Q1 | TRAIL-EPS | |||||||||||||
2023 | 19,586 | 2,874 | 164 | 2952 | 31.5 | 34.95 | 36.34 | 36.13 | 139 | ||||||||||||||
Expected Growth | Year | Sales | Profit | EPS | Current trend | H1 | 9M | ANNUAL | Q1 | F-2023 | |||||||||||||
LongTerm | 18% | 18% | 18% | SALES | 17% | 22% | 27% | 31% | 25% | ||||||||||||||
2023 | 25% | 25% | 25% | PROFITS | 19% | 20% | 19% | 28% | 25% | ||||||||||||||
Actual Growth | Year | Sales | Profit | Equity | EPS | Margin | HIghPrice | LowPrice | HighPE | LowPE | Q1_23 | FY_Q1_23 | FY_Q1_22 | Growth | MAJORCOST | FY_Q1_23 | FY_Q1_22 | Growth | SHARE | ||||
10 Year | 18% | 20% | 14.6% | 17.8 | Sales | 4523 | 3463 | 31% | OPERATING EXP | 767 | 541 | 42% | 20% | ||||||||||
5 Year | 16% | 18% | 17% | 15.1% | 57.7% | 22.3% | 23.6 | 12.0 | Finance cost | 17 | 18 | -6% | EMPLOYEE | 2872 | 2208 | 30% | 75% | ||||||
Last Year | 26.7% | 18.6% | 18.2% | 14.7% | 69.4% | 163.9% | 57.9 | 26.9 | Expenses | 3816 | 2912 | 31% | OTHERCOST | 53 | 66 | -20% | 1% | ||||||
Profit | 634 | 497 | 28% | D&A | 107 | 80 | 34% | 3% | |||||||||||||||
Actual Data | Year | Sales | Profit | Equity | EPS | Margin% | HIghPrice | LowPrice | HighPE | LowPE | Equity | 18 | 18 | 0% | FINANCE COST | 17 | 18 | -6% | 0% | ||||
2022 | 15669 | 2299 | 18 | 131 | 14.7% | 7595 | 3526 | 57.9 | 26.9 | EPS | 36.13 | 28.4 | 27% | ||||||||||
2021 | 12370 | 1938 | 17 | 111 | 15.7% | 4483 | 1336 | 40.4 | 12.0 | Margin | 14% | 14% | -2% | TOTAL | 3,816 | 2,913 | 31% | 100% | |||||
2020 | 10879 | 1521 | 17 | 87 | 14.0% | 2050 | 1210 | 23.6 | 13.9 | I.C.R | 43 | 32 | 35% | ||||||||||
2019 | 9446 | 1515 | 17 | 88 | 16.0% | 1987 | 1335 | 22.6 | 15.2 | ||||||||||||||
2018 | 7306 | 1112 | 17 | 65 | 15.2% | 1549 | 694 | 23.8 | 10.7 | SEGMENTAL | FY_Q1_23 | FY_Q1_22 | Growth | SHARE | SHARE HOLDING | 2023 | 2016 | Growth | |||||
IPO | 2017 | 6501 | 971 | 17 | 57 | 14.9% | 725 | 598 | 12.7 | 10.5 | BFSI | 2162 | 1612 | 34% | 48% | PROMOTER | 74.05 | 84.6 | -12% | ||||
2016 | 5846 | 837 | 17 | 51 | 14.3% | CPG, RETAIL, PHARMA | 787 | 576 | 37% | 17% | FPI | 8.42 | 4.75 | 77% | |||||||||
2015 | 4978 | 761 | 16 | 15.3% | MANUFACTURING | 651 | 520 | 25% | 14% | MF,AIF, INSURANCE | 8.12 | 1.88 | 332% | ||||||||||
2014 | 4920 | 696 | 16 | 14.1% | HITECH MEDIA | 525 | 440 | 19% | 12% | INDIVIDUAL | 6.61 | 7.82 | -15% | ||||||||||
2013 | 3851 | 562 | 16 | 14.6% | ENERGY & UTILITIES | 398 | 315 | 26% | 9% | ||||||||||||||
2012 | 3182 | 419 | 16 | 13.2% | |||||||||||||||||||
2011 | 2391 | 316 | 16 | 13.2% | TOTAL | 4,523 | 3,463 | 31% | 100% | ||||||||||||||