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?
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.