Required:

In $2020,$ Natural Selection, a nationwide computer dating service, had $\backslash (\backslash$$ $500\backslash )$ million of assets and $\backslash (\backslash$$ $200\backslash )$ million of liabilities. Earnings before interest and taxes were $\backslash (\backslash$$ $120\backslash )$ million, interest expense was $\backslash (\backslash$$ $28\backslash )$ million, the tax rate was $40$ percent, principal repayment requirements were $\backslash (\backslash$$ $24\backslash )$ million, and annual dividends were $30$ cents per share on $20$ million shares outstanding.

a$.$ Calculate the given ratios for Natural Selection.

$-$ Liabilities$-$to$-$equity ratio

$-$ Times$-$interest$-$earned ratio

$-$ Times burden covered

b$.$ What percentage decline in earnings before interest and taxes could Natural Selection have sustained before failing to cover the given items?

$-$ Interest payments requirements

$-$ Principal and interest requirements

$-$ Principal, interest, and common dividend payments

Note: Round your percentage answer to whole number $($i$.$e$.,0\mathrm{.}1234$ should be considered as $12.)$

Navigation:

$1.$ Use the Open Excel in New Tab button to launch this question.

$2.$ When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.