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
icon
Related questions
Question

I am having trouble with creating ratios or formulas from missing numbers. I need help. Please show formulas

B
G
K
Please complete the yellow highlighted 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.
4
Ratios
2020
2019
Income Statement
Balance Sheet
5
Liquidity Ratios
For the Year Ended Dec. 31, 2020
As of Dec. 31, 2020
6 Current Ratio
7 Quick Ratio
2.35x
Ratio
2020
2019
Assets
2020
2019
Ratio
0.80x
Sales
Ratio
Ratio
Cash and Equivalents
46,000
50,000
Efficiency Ratios
Ratio
8
Cost of Goods Sold
3,005,089 2,466,000
Accounts Receivable
Ratio
Ratio
Gross Profit
G&A Expenses
Other Expenses
Depreciation
9 Inventory Turnover Ratio
3.50x
1,324,911 Formula
Formula
Inventory
Total Current Assets
Ratio
10 Accounts Receivable Turnover Ratio
14.00x
Ratio
Formula
207.000
Ratio
Formula
11 Average Collection Period
12 Fixed Asset Turnover
Plant & Equipment
Accumulated Depreciation
Net Fixed Assets
Ratio 40.00 days
115,000 Formula
Formula
435,000
15.00x
Ratio
Ratio
Ratio
146,000
Formula
13 Total Asset Turnover
Ratio
Ratio
ЕBIT
173,000
Ratio
Formula
Formula
Leverage Ratios
Interest Expense
Formula
54,000
Total Assets
Ratio
1,490,000
14
15 Total Debt Ratio
60.00%
Ratio
Earnings Before Taxes
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
Accounts Payable
Short-term Notes Payable
Ratio
35.00%
Тахes
Formula Formula
Formula
131,000
Ratio
Ratio
Net Income
59,500 Formula
201,000 Formula
Ratio
Ratio
Notes
Other Current Liabilities
121,000
117,000
Ratio
Ratio
Tax Rate
40%
Total Current Liabilities
480,000
Ratio
20
Coverage Ratios
Long-term Debt
Formula
Formula
21 Times Interest Earned
Ratio
4.00x
Total Liabilities
Ratio
Formula
22 Cash Coverage Ratio
3.00x
3.63х
Common Stock
Formula
408,000
Retained Earnings
Total Shareholder's 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
Total Liabilities and Owners' Equity
Formula
Formula
Ratio
3.00%
4.20%
Ratio
Ratio
12.00%
Ratio
Ratio
30
Transcribed Image Text:B G K Please complete the yellow highlighted 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. 4 Ratios 2020 2019 Income Statement Balance Sheet 5 Liquidity Ratios For the Year Ended Dec. 31, 2020 As of Dec. 31, 2020 6 Current Ratio 7 Quick Ratio 2.35x Ratio 2020 2019 Assets 2020 2019 Ratio 0.80x Sales Ratio Ratio Cash and Equivalents 46,000 50,000 Efficiency Ratios Ratio 8 Cost of Goods Sold 3,005,089 2,466,000 Accounts Receivable Ratio Ratio Gross Profit G&A Expenses Other Expenses Depreciation 9 Inventory Turnover Ratio 3.50x 1,324,911 Formula Formula Inventory Total Current Assets Ratio 10 Accounts Receivable Turnover Ratio 14.00x Ratio Formula 207.000 Ratio Formula 11 Average Collection Period 12 Fixed Asset Turnover Plant & Equipment Accumulated Depreciation Net Fixed Assets Ratio 40.00 days 115,000 Formula Formula 435,000 15.00x Ratio Ratio Ratio 146,000 Formula 13 Total Asset Turnover Ratio Ratio ЕBIT 173,000 Ratio Formula Formula Leverage Ratios Interest Expense Formula 54,000 Total Assets Ratio 1,490,000 14 15 Total Debt Ratio 60.00% Ratio Earnings Before Taxes 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 Accounts Payable Short-term Notes Payable Ratio 35.00% Тахes Formula Formula Formula 131,000 Ratio Ratio Net Income 59,500 Formula 201,000 Formula Ratio Ratio Notes Other Current Liabilities 121,000 117,000 Ratio Ratio Tax Rate 40% Total Current Liabilities 480,000 Ratio 20 Coverage Ratios Long-term Debt Formula Formula 21 Times Interest Earned Ratio 4.00x Total Liabilities Ratio Formula 22 Cash Coverage Ratio 3.00x 3.63х Common Stock Formula 408,000 Retained Earnings Total Shareholder's 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 Total Liabilities and Owners' Equity Formula Formula Ratio 3.00% 4.20% Ratio Ratio 12.00% Ratio Ratio 30
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Ratio Analysis
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
SWFT Comprehensive Volume 2019
SWFT Comprehensive Volume 2019
Accounting
ISBN:
9780357233306
Author:
Maloney
Publisher:
Cengage
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning