I want the equation for this leverage on excel, it should be If formula between 0 and 1
A B C G 1 J L M 1 2 id num at dic ditt invt pi 3 4 ceq 42.99 79.345 0 9.6 14.987 1 5 94.104 61.994 0 0 9.645 1 6 9.922 79.16 36.486 170.406 2039.417 7 0 0 496.495 33 8 976.554 0 153.789 11.2 18 9 1136.126 1.755 14.1 27 10 1139.963 conml 1 CECO Environmental Corp. 2 CECO Environmental Corp. 3 CECO Environmental Corp. 4 AVX Corp. 5 Aaron's Inc 6 Aaron's Inc 7 Aaron's Inc 8 Abbott Laboratories 9 Abbott Laboratories 10 Abbott Laboratories 11 Aceto Corp 12 Aceto Corp 13 Acme United Corp 14 Acme United Corp 15 Acme United Corp 27.529 gvkey 001050 001050 001050 001072 001076 001076 001076 001078 001078 001078 001094 001094 001104 001104 001104 ppent 5.651 4.885 21.665 235.659 1077.695 1180.565 1087.018 7873.955 8063.047 5905 12.095 11.41 2.506 348.536 2319.482 1735.149 1812.929 1827.176 60276.893 67234.944 42953 311.665 323.43 55.222 11 1 520 627 12 13 24439.833 26720.961 25171 160.821 194.64 27.775 139.773 115.175 12039.822 18085.302 3388 48.75 20.355 17.568 24.32 22.912 3374.755 2390.662 3173 6.247 11.714 0 14 3284.249 3792.313 2693 77.433 83.849 24.495 14 1 15 16 17 30.866 0 2.353 67.828 68.079 30.292 28.219 18 35.005 0 5.936 Leverage Long-Term Debt divided by total assets The sum of debt in current liabilities (DLC) plus long-term Debt (DLTT) scaled by total assets (AT). Leverage should be between 0 and 1, use if then formula to adjust accordingly A B C G 1 J L M 1 2 id num at dic ditt invt pi 3 4 ceq 42.99 79.345 0 9.6 14.987 1 5 94.104 61.994 0 0 9.645 1 6 9.922 79.16 36.486 170.406 2039.417 7 0 0 496.495 33 8 976.554 0 153.789 11.2 18 9 1136.126 1.755 14.1 27 10 1139.963 conml 1 CECO Environmental Corp. 2 CECO Environmental Corp. 3 CECO Environmental Corp. 4 AVX Corp. 5 Aaron's Inc 6 Aaron's Inc 7 Aaron's Inc 8 Abbott Laboratories 9 Abbott Laboratories 10 Abbott Laboratories 11 Aceto Corp 12 Aceto Corp 13 Acme United Corp 14 Acme United Corp 15 Acme United Corp 27.529 gvkey 001050 001050 001050 001072 001076 001076 001076 001078 001078 001078 001094 001094 001104 001104 001104 ppent 5.651 4.885 21.665 235.659 1077.695 1180.565 1087.018 7873.955 8063.047 5905 12.095 11.41 2.506 348.536 2319.482 1735.149 1812.929 1827.176 60276.893 67234.944 42953 311.665 323.43 55.222 11 1 520 627 12 13 24439.833 26720.961 25171 160.821 194.64 27.775 139.773 115.175 12039.822 18085.302 3388 48.75 20.355 17.568 24.32 22.912 3374.755 2390.662 3173 6.247 11.714 0 14 3284.249 3792.313 2693 77.433 83.849 24.495 14 1 15 16 17 30.866 0 2.353 67.828 68.079 30.292 28.219 18 35.005 0 5.936 Leverage Long-Term Debt divided by total assets The sum of debt in current liabilities (DLC) plus long-term Debt (DLTT) scaled by total assets (AT). Leverage should be between 0 and 1, use if then formula to adjust accordingly
