Q&ACategory: Dividend StocksDebt Servicing Ratio for Keppel Ltd BN4
Eric Yuen asked 1 year ago

Hi Rusmin,
I have just done the Debt Servicing Ratio module on the course, I then check it up using Keppel Ltd FY23 data, the following are my calculation:-

From AR FY23      Interest received 70,231.     Interest paid (364,290).     Net cash from operating activities 58,429.

FY23    364,290-70,231/58,429=503%

FY22 68%

FY21 negative Debt Servicing Ratio

FY20 125%

FY19 negative Debt Servicing Ratio

Assuming my calculations are correct, does it mean Keppel Ltd is not a good dividend company?

Kindest regards,
Eric

3 Answers
Chee Hoi Shak Staff answered 1 year ago

Hi Eric,

To calculate Keppel’s debt serving ratio, I actually used operating cash flow before working capital less tax paid instead of the usual operating cash flow. This is to take out the short-term fluctuations in working capital (like accounts receivable, payable, and inventory) after tax payments.

Their debt servicing ratio was actually below or closed to 30% most of the times except for 2o20, 2021, and 2022. The company was going through a restructuring period to make the business more asset-light and rely more on recurring income. I won’t penalise them too much and will still give them a pass based on its debt servicing ratio alone.

 

Actually for most other companies, I will just use the usual operating cash flow to calculate this ratio like what you did. Keppel is an uncommon exception, we realised the operating cash flow was sometimes affected a lot by the account receivables, payables, and so on, so we used this kind of adjusted operating cash flow to see its 'true' money flowing in.

Attachments
Eric Yuen replied 1 year ago

Chee Hoi, thank you so much for the clarification.

Chee Hoi Shak Staff answered 1 year ago
Your interest paid and interest received are correct. Alternatively, you can also use the Interest Expenses and the Interest Income in the Profit and Loss Statements. Both figures are similar, so stick to either one is fine.   For Interest Expenses, I will usually go to the notes and remove the lease liabilities interest payment in order to see the actual interest payments to banks that could make a company bankrupt.
Attachments
JT answered 1 year ago
Hi Hoi Shak, As mentioned above, it calculate as such
operating cash flow bf working capital less tax paid = 866260-116,086 =750174
interest paid – interest received / 750174
364290-70,231/750174 = 39.20%
Am I right ? it above 30%, still a good dividend company ?
Thank you and have a great day ! Jac
Chee Hoi Shak Staff replied 1 year ago

Yes, your calculation is correct. This company will still pass this step because most of the years, its interest income is more than its interest expenses or its debt servicing ratio is around 30% except for 2020, 2021, and 2022 because of the ongoing restructuring to make the business more asset-light. In 2023, they were already slowly bringing the debt servicing ratio back closer to 30%. So, I will still give them a pass here.

JT replied 1 year ago

Thanks for the clarification. Have a great day !

By the way what is the purpose of up & down arrow below your profile picture?  I accidentally press it 🙂