Esitmated FY24 Net/EBITDA Ratio mentioned in Q4 presentation, ~2.5 times.
With assumed EBITDA of Rs 1100, and 2.6 time Net Debt/EBITDA ratio, Net Debt would be ~ Rs 2,860 Cr on 31 March 2024, as against Rs 3,121 cr as on 31 March 2023 (Q4FY23 presentation slide 35)
So that would provide Decline in net debt of ~ Rs 261 Cr as against anticipated EBITDA of Rs 1,100 Cr.
Hope this explain what query you had. In case further doubt, feel free to mention.
I am enclosing my working in excel in case you need to check formuals.
Calculation with Excel formula for above sheet enclosed for your reference.
Sterlite Tech Working July 2023.xlsx (9.6 KB)
Subscribe To Our Free Newsletter |