90.2K

Verified Solution

Link Copied!

Solve financial ratios? in Excel?

Common Size Balance Sheet Assets Current Assets Cash and cash equivalents Accounts receivable, less allowances of $5.5 and $3.7 Inventories Other current assets Total Current Assets Liabilities and Stockholders' Equity Current Liabilities Short-term borrowings Current portion of long-term debt Accounts payable and accrued expenses Income taxes payable Total Current Liabilities Long-term Debt Deferred Income Taxes Deferred and Other Long-term Liabilities Business Acquisition Liabilities Total Liabilities Total Stockholders' Equity Total Liabilities and Stockholders' Equity \begin{tabular}{|r|r|r|r|} 252.8 & 3.16% & 351.4 & 4.74% \\ \hline 699.4 & 8.75% & 0 & 0.00% \\ \hline 1,119.70 & 14.00% & 1,024.50 & 13.82% \\ \hline 3.3 & 0.04% & 12.7 & 0.17% \\ \hline 2,075.20 & 25.95% & 1,388.60 & 18.73% \\ \hline 1,610.70 & 20.14% & 1,812.50 & 24.45% \\ \hline 745.1 & 9.32% & 707.3 & 9.54% \\ \hline 298.3 & 3.73% & 367.7 & 4.96% \\ \hline 34 & 0.43% & 118 & 1.59% \\ \hline 4,763.30 & 59.57% & 4,394.10 & 59.26% \\ \hline 3,233.20 & 40.43% & 3,020.40 & 40.74% \\ \hline 7,996.50 & 100.00% & 7,414.50 & 100.00% \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline 252.9 & 3.80% & 1.8 & 0.03% \\ \hline 0 & 0.00% & 596.5 & 9.83% \\ \hline 831.9 & 12.50% & 725.1 & 11.95% \\ \hline 7.50 & 0.11% & 2.9 & 0.05% \\ \hline 1,092.00 & 16.40% & 1,326.30 & 21.85% \\ \hline 1810.2 & 27.19% & 1,508.80 & 24.86% \\ \hline 579.6 & 8.71% & 576.4 & 9.50% \\ \hline 315.5 & 4.74% & 180.9 & 2.98% \\ \hline 192.00 & 2.88% & 23 & 0.38% \\ \hline 3989.6 & 59.93% & 3,615.40 & 59.57% \\ \hline 2,667.80 & 40.07% & 2453.8 & 40.43% \\ \hline 6,657.40 & 100.00% & 6,069.20 & 100.00% \\ \hline \end{tabular} Church\&Dwight co. 202120202019 Profitibility Return on equity Profit Margin 15.94% Gross Margin Asset Turnover 8 Inventory Turnover Earnings Per Share Short term Liquidity Current Ratio Quick Ratio Accounts Recievable Turnover Long term Solvency Debt to Assets Debt to Equity Interest Coverage Times Intrest Earned Common Size income statement Common Size Balance Sheet Assets Current Assets Cash and cash equivalents Accounts receivable, less allowances of $5.5 and $3.7 Inventories Other current assets Total Current Assets Liabilities and Stockholders' Equity Current Liabilities Short-term borrowings Current portion of long-term debt Accounts payable and accrued expenses Income taxes payable Total Current Liabilities Long-term Debt Deferred Income Taxes Deferred and Other Long-term Liabilities Business Acquisition Liabilities Total Liabilities Total Stockholders' Equity Total Liabilities and Stockholders' Equity \begin{tabular}{|r|r|r|r|} 252.8 & 3.16% & 351.4 & 4.74% \\ \hline 699.4 & 8.75% & 0 & 0.00% \\ \hline 1,119.70 & 14.00% & 1,024.50 & 13.82% \\ \hline 3.3 & 0.04% & 12.7 & 0.17% \\ \hline 2,075.20 & 25.95% & 1,388.60 & 18.73% \\ \hline 1,610.70 & 20.14% & 1,812.50 & 24.45% \\ \hline 745.1 & 9.32% & 707.3 & 9.54% \\ \hline 298.3 & 3.73% & 367.7 & 4.96% \\ \hline 34 & 0.43% & 118 & 1.59% \\ \hline 4,763.30 & 59.57% & 4,394.10 & 59.26% \\ \hline 3,233.20 & 40.43% & 3,020.40 & 40.74% \\ \hline 7,996.50 & 100.00% & 7,414.50 & 100.00% \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline 252.9 & 3.80% & 1.8 & 0.03% \\ \hline 0 & 0.00% & 596.5 & 9.83% \\ \hline 831.9 & 12.50% & 725.1 & 11.95% \\ \hline 7.50 & 0.11% & 2.9 & 0.05% \\ \hline 1,092.00 & 16.40% & 1,326.30 & 21.85% \\ \hline 1810.2 & 27.19% & 1,508.80 & 24.86% \\ \hline 579.6 & 8.71% & 576.4 & 9.50% \\ \hline 315.5 & 4.74% & 180.9 & 2.98% \\ \hline 192.00 & 2.88% & 23 & 0.38% \\ \hline 3989.6 & 59.93% & 3,615.40 & 59.57% \\ \hline 2,667.80 & 40.07% & 2453.8 & 40.43% \\ \hline 6,657.40 & 100.00% & 6,069.20 & 100.00% \\ \hline \end{tabular} Church\&Dwight co. 202120202019 Profitibility Return on equity Profit Margin 15.94% Gross Margin Asset Turnover 8 Inventory Turnover Earnings Per Share Short term Liquidity Current Ratio Quick Ratio Accounts Recievable Turnover Long term Solvency Debt to Assets Debt to Equity Interest Coverage Times Intrest Earned Common Size income statement

Answer & Explanation Solved by verified expert

See Answer