Explain how to get current debt-to-equity ratio and Asset Beta using an excel formula

 

010 Format Painter Clipboard A S BIU fix 1 2 Risk-free Rate (1-year T-bill yield) 3 Market Premium 4 tax rate 5 Equity Beta (BE) 6 Current Debt (MV, USD in mil) 7 Current Equity (MV, USD in mil) 8 Total Assets 9 EBIT 10 11 Current debt-to-equity ratio 12 Asset Beta (BA) 13 14 15 Font $ SSS $ $ A > FS C BE ED 2.42% 7.50% 35% 0.472 4,796 11,903 16,699 878 Alignmen