Discounted Cash Flow (DCF) Analysis Unlevered

Likhitha Infrastructure Limited (LIKHITHA.NS)

244.95 ₹

+12.45 (+5.35%)
All numbers are in Millions, Currency in USD
Stock DCF: 119.22 | 244.95 | overvalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 870.781,374.341,612.381,906.222,572.123,397.164,486.865,926.097,826.9810,337.61
Revenue (%)
EBITDA 120.42291.50304.64410.80657.01686.41906.591,197.391,581.472,088.75
EBITDA (%)
EBIT 111.11261.62273.70386.24620.14632.85835.841,103.951,458.061,925.76
EBIT (%)
Depreciation 9.3129.8730.9424.5636.8653.5670.7493.44123.41162.99
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 67.735.1495.39579.50695.99485.99641.87847.771,119.701,478.86
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories 26.51198.14246.82225.05466.09425.98562.62743.09981.451,296.27
Inventories (%)
Accounts Payable 133.82121.19139.3517.9990.56253.38334.66442583.78771.04
Accounts Payable (%)
Capital Expenditure -103.12-31.25-15.28-24.75-102.30-138.20-182.53-241.08-318.41-420.54
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 244.95
Beta 0.665
Diluted Shares Outstanding 157.81
Cost of Debt
Tax Rate 24.98
After-tax Cost of Debt 3.75%
Risk-Free Rate
Market Risk Premium
Cost of Equity 6.638
Total Debt -
Total Equity 38,656.17
Total Capital 38,656.17
Debt Weighting 0.00
Equity Weighting 100.00
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 870.781,374.341,612.381,906.222,572.123,397.164,486.865,926.097,826.9810,337.61
EBITDA 120.42291.50304.64410.80657.01686.41906.591,197.391,581.472,088.75
EBIT 111.11261.62273.70386.24620.14632.85835.841,103.951,458.061,925.76
Tax Rate 34.44%29.43%25.73%24.45%24.98%27.81%27.81%27.81%27.81%27.81%
EBIAT 72.84184.64203.28291.79465.21456.87603.42796.981,052.621,390.27
Depreciation 9.3129.8730.9424.5636.8653.5670.7493.44123.41162.99
Accounts Receivable ----------
Inventories --171.62-48.6921.77-241.0440.11-136.64-180.47-238.36-314.82
Accounts Payable --12.6318.16-121.3572.57162.8281.28107.35141.78187.26
Capital Expenditure -103.12-31.25-15.28-24.75-102.30-138.20-182.53-241.08-318.41-420.54
UFCF -20.97-1188.41192.01231.30575.16436.27576.21761.041,005.16
WACC
PV UFCF 539.35383.63475.14588.48728.84
SUM PV UFCF 2,715.45

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 6.64
Free cash flow (t + 1) 1,025.26
Terminal Value 22,096.20
Present Value of Terminal Value 16,022.01

Intrinsic Value

Enterprise Value 18,737.45
Net Debt -76.28
Equity Value 18,813.73
Shares Outstanding 157.81
Equity Value Per Share 119.22