Nick David / Getty Images There is no specific formula in Excel or other ... to the bottom of the sheet and enter: Debt as % of Total Capital (Debt>Weight) Equity as % of Total Capital (Equity ...