2

I want to compute the adjusted debt-to-equity ratio. The formula is simple: ADE ratio = Total Liabilities divided by Total Equity and Treasury Stock. When I look for Treasury Stock for MSFT (https://seekingalpha.com/symbol/MSFT/income-statement), it seems not being provided while it is for KO (https://seekingalpha.com/symbol/KO/income-statement). Is there a way to efficiently compute the Treasury Stock so that I can compute de ADE ratio?

RonJohn
  • 50,786
  • 10
  • 107
  • 170
J.Doe
  • 41
  • 6

1 Answers1

1

Not all companies must have any treasury stock so just assume 0 if it is not present. You might search for it in official annual report if you have doubts.

Also, notice that in the Coca Cola data, treasury stock is provided as a negative number. I guess you should add treasury stock as a positive number. So that more treasury stock means lower ratio.

ePortfel
  • 302
  • 1
  • 4