A D E F K 1 Please complete the yellow highlightekd parts. Please show the formulas if the number or figures are not provided in the problem. 2 3 Cristal Clear, Inc. Cristal Clear, Inc. Cristal Clear, Inc. Ratios 2020 2019 Income Statement Balance Sheet Liquidity Ratios For the Year Ended Dec. 31, 2020 As of Dec. 31, 2020 6 Current Ratio 2.35x Ratio 2020 2019 Assets 2020 2019 7 Quick Ratio Ratio 0.80x Sales Ratio Ratio Cash and Equivalents 46.000 50,000 Efficiency Ratios Ratio Cost of Goods Sold 3,005.089 2,466,000 Accounts Receivable Ratio Ratio 9 Inventory Turnover Ratio Gross Profit G&A Expenses Other Expenses Depreciation 3.50x 1,324,911 Formula Inventory Formula Ratio Total Current Assets Plant & Equipment Accumulated Depreciation 10 Accounts Receivable Turnover Ratio 14.00x Ratio Formula 207.000 Ratio Formula 11 Average Collection Period Ratio 40.00 days 115,000 Formula Formula 435,000 12 Fixed Asset Turnover 15.00x Ratio Ratio Ratio 146.000 Formula 13 Total Asset Turnover Ratio Ratio ЕBIT 173,000 Ratio Net Fixed Assets Formula Formula 14 Leverage Ratios Interest Expense Formula 54,000 Total Assets Ratio 1,490,000 Earnings Before Taxes Taxes 15 Total Debt Ratio 60.00% Ratio Formula Formula Liabilities and Owners' Equity 16 Long-Term Debt Ratio 17 LTD to Total Capitalization 18 Debt to Equity 19 Long-Term Debt to Equity Formula Formula 59,500 Formula Accounts Payable Short-term Notes Payable Ratio 35.00% Formula 131.000 Ratio Ratio Net Income 201,000 Formula Ratio Ratio Notes Other Current Liabilities 121,000 117,000 Ratio Ratio Tax Rate 40% Total Current Liabilities 480,000 Ratio Long-term Debt Total Liabilities 20 Coverage Ratios Formula Formula 21 Times Interest Earned Ratio 4.00x Ratio Formula 22 Cash Coverage Ratio 3.00x 3.63x Common Stock Formula 408,000 Retained Earnings Total Shareholder's Equity Total Liabilities and Owners' Equity 23 Profitability Ratios 199.000 Formula 24 Gross Profit Margin 25 Operating Proft Margin 26 Net Proft Margin 27 Return on Total Assets 28 Return on Equity 29 Return on Common Equity Ratio Ratio Formula Ratio Ratio Ratio Formula Formula Ratio 3.00% Ratio 12.00% 4.20% Ratio Ratio Ratio
A D E F K 1 Please complete the yellow highlightekd parts. Please show the formulas if the number or figures are not provided in the problem. 2 3 Cristal Clear, Inc. Cristal Clear, Inc. Cristal Clear, Inc. Ratios 2020 2019 Income Statement Balance Sheet Liquidity Ratios For the Year Ended Dec. 31, 2020 As of Dec. 31, 2020 6 Current Ratio 2.35x Ratio 2020 2019 Assets 2020 2019 7 Quick Ratio Ratio 0.80x Sales Ratio Ratio Cash and Equivalents 46.000 50,000 Efficiency Ratios Ratio Cost of Goods Sold 3,005.089 2,466,000 Accounts Receivable Ratio Ratio 9 Inventory Turnover Ratio Gross Profit G&A Expenses Other Expenses Depreciation 3.50x 1,324,911 Formula Inventory Formula Ratio Total Current Assets Plant & Equipment Accumulated Depreciation 10 Accounts Receivable Turnover Ratio 14.00x Ratio Formula 207.000 Ratio Formula 11 Average Collection Period Ratio 40.00 days 115,000 Formula Formula 435,000 12 Fixed Asset Turnover 15.00x Ratio Ratio Ratio 146.000 Formula 13 Total Asset Turnover Ratio Ratio ЕBIT 173,000 Ratio Net Fixed Assets Formula Formula 14 Leverage Ratios Interest Expense Formula 54,000 Total Assets Ratio 1,490,000 Earnings Before Taxes Taxes 15 Total Debt Ratio 60.00% Ratio Formula Formula Liabilities and Owners' Equity 16 Long-Term Debt Ratio 17 LTD to Total Capitalization 18 Debt to Equity 19 Long-Term Debt to Equity Formula Formula 59,500 Formula Accounts Payable Short-term Notes Payable Ratio 35.00% Formula 131.000 Ratio Ratio Net Income 201,000 Formula Ratio Ratio Notes Other Current Liabilities 121,000 117,000 Ratio Ratio Tax Rate 40% Total Current Liabilities 480,000 Ratio Long-term Debt Total Liabilities 20 Coverage Ratios Formula Formula 21 Times Interest Earned Ratio 4.00x Ratio Formula 22 Cash Coverage Ratio 3.00x 3.63x Common Stock Formula 408,000 Retained Earnings Total Shareholder's Equity Total Liabilities and Owners' Equity 23 Profitability Ratios 199.000 Formula 24 Gross Profit Margin 25 Operating Proft Margin 26 Net Proft Margin 27 Return on Total Assets 28 Return on Equity 29 Return on Common Equity Ratio Ratio Formula Ratio Ratio Ratio Formula Formula Ratio 3.00% Ratio 12.00% 4.20% Ratio Ratio Ratio
Financial Reporting, Financial Statement Analysis and Valuation
8th Edition
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Chapter5: Risk Analysis
Section: Chapter Questions
Problem 18PC
Related questions
Question
I am having trouble with creating ratios or formulas from missing numbers. I need help. Please show formulas
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning