Calculating Capitalization Ratio in Excel

Capitalization ratio compares total borrowings to total capitalization. To calculate capitalization ratio open your balance sheet and divide long term debt with sum of long term debt and shareholder’s equity