Debt-to-Equity Ratio worksheet

1. Debt-to-equity ratio: 1.22

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$550,000.00}}{\mathrm{\$450,000.00}}$$=1.222222$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$550,000.00}+\mathrm{\$450,000.00}$$=\mathrm{\$1,000,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$550,000.00}}{\mathrm{\$1,000,000.00}}\times 100$$=\mathrm{55\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$1,000,000.00}}{\mathrm{\$450,000.00}}$$=2.222222$

2. Debt-to-equity ratio: 2.26

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$700,000.00}}{\mathrm{\$310,000.00}}$$=2.258065$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$700,000.00}+\mathrm{\$310,000.00}$$=\mathrm{\$1,010,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$700,000.00}}{\mathrm{\$1,010,000.00}}\times 100$$=\mathrm{69.3069\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$1,010,000.00}}{\mathrm{\$310,000.00}}$$=3.258065$

3. Debt-to-equity ratio: 1.92

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$500,000.00}}{\mathrm{\$260,000.00}}$$=1.923077$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$500,000.00}+\mathrm{\$260,000.00}$$=\mathrm{\$760,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$500,000.00}}{\mathrm{\$760,000.00}}\times 100$$=\mathrm{65.7895\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$760,000.00}}{\mathrm{\$260,000.00}}$$=2.923077$

4. Debt-to-equity ratio: 1.33

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$640,000.00}}{\mathrm{\$480,000.00}}$$=1.333333$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$640,000.00}+\mathrm{\$480,000.00}$$=\mathrm{\$1,120,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$640,000.00}}{\mathrm{\$1,120,000.00}}\times 100$$=\mathrm{57.1429\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$1,120,000.00}}{\mathrm{\$480,000.00}}$$=2.333333$

5. Debt-to-equity ratio: 1.94

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$700,000.00}}{\mathrm{\$360,000.00}}$$=1.944444$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$700,000.00}+\mathrm{\$360,000.00}$$=\mathrm{\$1,060,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$700,000.00}}{\mathrm{\$1,060,000.00}}\times 100$$=\mathrm{66.0377\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$1,060,000.00}}{\mathrm{\$360,000.00}}$$=2.944444$

6. Debt-to-equity ratio: 1.36

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$450,000.00}}{\mathrm{\$330,000.00}}$$=1.363636$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$450,000.00}+\mathrm{\$330,000.00}$$=\mathrm{\$780,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$450,000.00}}{\mathrm{\$780,000.00}}\times 100$$=\mathrm{57.6923\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$780,000.00}}{\mathrm{\$330,000.00}}$$=2.363636$

7. Debt-to-equity ratio: 1.63

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$650,000.00}}{\mathrm{\$400,000.00}}$$=1.625$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$650,000.00}+\mathrm{\$400,000.00}$$=\mathrm{\$1,050,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$650,000.00}}{\mathrm{\$1,050,000.00}}\times 100$$=\mathrm{61.9048\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$1,050,000.00}}{\mathrm{\$400,000.00}}$$=2.625$

8. Debt-to-equity ratio: 1.96

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$900,000.00}}{\mathrm{\$460,000.00}}$$=1.956522$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$900,000.00}+\mathrm{\$460,000.00}$$=\mathrm{\$1,360,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$900,000.00}}{\mathrm{\$1,360,000.00}}\times 100$$=\mathrm{66.1765\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$1,360,000.00}}{\mathrm{\$460,000.00}}$$=2.956522$

9. Debt-to-equity ratio: 1.61

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$725,000.00}}{\mathrm{\$450,000.00}}$$=1.611111$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$725,000.00}+\mathrm{\$450,000.00}$$=\mathrm{\$1,175,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$725,000.00}}{\mathrm{\$1,175,000.00}}\times 100$$=\mathrm{61.7021\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$1,175,000.00}}{\mathrm{\$450,000.00}}$$=2.611111$

10. Debt-to-equity ratio: 2.31

1. Divide what the company owes by the owners' stake to see how much is owed per dollar of equity

   $\frac{\mathrm{\$740,000.00}}{\mathrm{\$320,000.00}}$$=2.3125$

2. Add the two to get total assets, since everything owned is paid for by lenders or owners

   $\mathrm{\$740,000.00}+\mathrm{\$320,000.00}$$=\mathrm{\$1,060,000.00}$

3. Divide what is owed by total assets to see the share of assets paid for with debt

   $\frac{\mathrm{\$740,000.00}}{\mathrm{\$1,060,000.00}}\times 100$$=\mathrm{69.8113\%}$

4. Divide total assets by equity to see how many dollars of assets each owner dollar supports

   $\frac{\mathrm{\$1,060,000.00}}{\mathrm{\$320,000.00}}$$=3.3125$