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

HW3-3 (20 POINTS) Cristal Clear, Inc., a manufacturer of water purification systems, has accidentally erased parts of its 2020 and 2019 financial statements. Help the company fill in the missing data using your knowledge of financial ratios. Cristal Clear, Inc. Liquidity Ratios Ratios 2020 2019 Current Ratio Quick Ratio 2.35x Ratio Ratio 0.80x Efficiency Ratios Inventory Tumover atio AR Turnover Ratio Average Collection Period Fixed Asset Tumover Total Asset Turnover Ratic 14.00x Ratio 15.00x Ratio 3.50x Ratio 40.00 days Ratio Ratio Leverage Ratios Total Debt Ratio Long-Term Debt Ratio LTD to Total Capitalization Debt to Equity Long-Term Debt to Equity 60.00% Ratio Ratio Ratio Ratio Ratio 35.00% Ratio Ratio Ratio Coverage Ratios Times Interest Earned Cash Coverage Ratio Ratio 3.00x 4.00 Ratio Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Total Assets Return on Equity Return on Common Equity Ratio Ratio Ratio 4.20% Ratio Ratio Ratio Ratio 3.00% Ratio 12.00% Ratio Cristal Clear, Inc. Balance Sheet As of Dec. 31, 2020 Sales Cost of Goods Gross Profit G&A Expenses Other Expenses Depreciation EBIT Interest Expense Taxes Net Income Notes Tax Rate Cristal Clear, Inc. Income Statement For the Year Ended Dec. 31, 2020 2020 Ratio Ratio Formula Formula 115,000 Ratio 173,000 Formula Formula Formula 59,500 2019 Ratio 2,466,000 Formula 207.000 Formula Ratio Ratio 54.000 Formula Formula Formula 2020 46,000 Ratio Formula Ratio Formula 146,000 Formula Ratio 2019 50,000 Ratio Ratio Formula 435,000 Formula Formula 1,490,000 Assets Cash and Equivalents Accounts Receivable Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Net Fixed Assets Total Assets Liabilities and Owners' Equity Accounts Payable Short-term Notes Payable Other Current Liabilities Total Curent Liabilities Long-term Debt Total Liabilities Common Stock Retained Earnings Total Shareholder's Equity Total Liab. and OE 40% Formula 201,000 121,000 480,000 Formula Ratio Formula 199.000 Formula Formula 131.000 Formula 117,000 Ratio Formula Formula 408,000 Formula Ratio Formula a) Using the ratios provided, recreate the financial statements as shown using formulas, and complete the financial statements using formulas that refer to existing data to fill in the remaining cells (Iden- tify and Access Needed Information & Analysis). Each ratio and formula is worth 0.30 point; total 19 pts. K B D E G 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. 4 Ratios 2020 2019 Income Statement 5 Liquidity Ratios For the Year Ended Dec. 31, 2020 6 Current Ratio 2.35x Ratio 2020 2019 7 Quick Ratio Ratio 0.80x Sales Ratio Ratio 8 Efficiency Ratios Cost of Goods Sold 3,005,089 2.466,000 9 Inventory Turnover Ratio Ratio 3.50x Gross Profit 1,324,911 Formula 10 Accounts Receivable Turnover Ratio 14.00x Ratio G&A Expenses Formula 207,000 11 Average Collection Period Ratio 40.00 days Other Expenses 115,000 Formula 12 Fixed Asset Turnover 15.00x Ratio Depreciation Ratio Ratio 13 Total Asset Turnover Ratio Ratio EBIT 173,000 Ratio 14 Leverage Ratios Interest Expense Formula 54,000 15 Total Debt Ratio 60.00% Ratio Earnings Before Taxes Formula Formula 16 Long-Term Debt Ratio Ratio 35.00% Taxes Formula Formula 17 LTD to Total Capitalization Ratio Ratio Net Income 59,500 Formula 18 Debt to Equity Ratio Ratio Notes 19 Long-Term Debt to Equity Ratio Ratio Tax Rate 40% 20 Coverage Ratios 21 Times Interest Earned Ratio 4.00x 22 Cash Coverage Ratio 3.00x 3.63x 23 Profitability Ratios 24 Gross Profit Margin Ratio Ratio 25 Operating Proft Margin Ratio Ratio 26 Net Proft Margin Ratio 3.00% 27 Return on Total Assets 4.20% Ratio 28 Return on Equity Ratio 12.00% 29 Return on Common Equity Ratio Ratio 30 Cristal Clear, Inc. Balance Sheet As of Dec. 31, 2020 Assets 2020 2019 Cash and Equivalents 46,000 50,000 Accounts Receivable Ratio Ratio Inventory Formula Ratio Total Current Assets Ratio Formula Plant & Equipment Formula 435,000 Accumulated Depreciation 146,000 Formula Net Fixed Assets Formula Formula Total Assets Ratio 1,490,000 Liabilities and Owners' Equity Accounts Payable Formula 131,000 Short-term Notes Payable 201,000 Formula Other Current Liabilities 121,000 117,000 Total Current Liabilities 480,000 Ratio Long-term Debt Formula Formula Total Liabilities Ratio Formula Common Stock Formula 408,000 Retained Earnings 199,000 Formula Total Shareholder's Equity Formula Ratio Total Liabilities and Owners' Equity Formula Formula HW3-3 (20 POINTS) Cristal Clear, Inc., a manufacturer of water purification systems, has accidentally erased parts of its 2020 and 2019 financial statements. Help the company fill in the missing data using your knowledge of financial ratios. Cristal Clear, Inc. Liquidity Ratios Ratios 2020 2019 Current Ratio Quick Ratio 2.35x Ratio Ratio 0.80x Efficiency Ratios Inventory Tumover atio AR Turnover Ratio Average Collection Period Fixed Asset Tumover Total Asset Turnover Ratic 14.00x Ratio 15.00x Ratio 3.50x Ratio 40.00 days Ratio Ratio Leverage Ratios Total Debt Ratio Long-Term Debt Ratio LTD to Total Capitalization Debt to Equity Long-Term Debt to Equity 60.00% Ratio Ratio Ratio Ratio Ratio 35.00% Ratio Ratio Ratio Coverage Ratios Times Interest Earned Cash Coverage Ratio Ratio 3.00x 4.00 Ratio Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Total Assets Return on Equity Return on Common Equity Ratio Ratio Ratio 4.20% Ratio Ratio Ratio Ratio 3.00% Ratio 12.00% Ratio Cristal Clear, Inc. Balance Sheet As of Dec. 31, 2020 Sales Cost of Goods Gross Profit G&A Expenses Other Expenses Depreciation EBIT Interest Expense Taxes Net Income Notes Tax Rate Cristal Clear, Inc. Income Statement For the Year Ended Dec. 31, 2020 2020 Ratio Ratio Formula Formula 115,000 Ratio 173,000 Formula Formula Formula 59,500 2019 Ratio 2,466,000 Formula 207.000 Formula Ratio Ratio 54.000 Formula Formula Formula 2020 46,000 Ratio Formula Ratio Formula 146,000 Formula Ratio 2019 50,000 Ratio Ratio Formula 435,000 Formula Formula 1,490,000 Assets Cash and Equivalents Accounts Receivable Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Net Fixed Assets Total Assets Liabilities and Owners' Equity Accounts Payable Short-term Notes Payable Other Current Liabilities Total Curent Liabilities Long-term Debt Total Liabilities Common Stock Retained Earnings Total Shareholder's Equity Total Liab. and OE 40% Formula 201,000 121,000 480,000 Formula Ratio Formula 199.000 Formula Formula 131.000 Formula 117,000 Ratio Formula Formula 408,000 Formula Ratio Formula a) Using the ratios provided, recreate the financial statements as shown using formulas, and complete the financial statements using formulas that refer to existing data to fill in the remaining cells (Iden- tify and Access Needed Information & Analysis). Each ratio and formula is worth 0.30 point; total 19 pts. K B D E G 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. 4 Ratios 2020 2019 Income Statement 5 Liquidity Ratios For the Year Ended Dec. 31, 2020 6 Current Ratio 2.35x Ratio 2020 2019 7 Quick Ratio Ratio 0.80x Sales Ratio Ratio 8 Efficiency Ratios Cost of Goods Sold 3,005,089 2.466,000 9 Inventory Turnover Ratio Ratio 3.50x Gross Profit 1,324,911 Formula 10 Accounts Receivable Turnover Ratio 14.00x Ratio G&A Expenses Formula 207,000 11 Average Collection Period Ratio 40.00 days Other Expenses 115,000 Formula 12 Fixed Asset Turnover 15.00x Ratio Depreciation Ratio Ratio 13 Total Asset Turnover Ratio Ratio EBIT 173,000 Ratio 14 Leverage Ratios Interest Expense Formula 54,000 15 Total Debt Ratio 60.00% Ratio Earnings Before Taxes Formula Formula 16 Long-Term Debt Ratio Ratio 35.00% Taxes Formula Formula 17 LTD to Total Capitalization Ratio Ratio Net Income 59,500 Formula 18 Debt to Equity Ratio Ratio Notes 19 Long-Term Debt to Equity Ratio Ratio Tax Rate 40% 20 Coverage Ratios 21 Times Interest Earned Ratio 4.00x 22 Cash Coverage Ratio 3.00x 3.63x 23 Profitability Ratios 24 Gross Profit Margin Ratio Ratio 25 Operating Proft Margin Ratio Ratio 26 Net Proft Margin Ratio 3.00% 27 Return on Total Assets 4.20% Ratio 28 Return on Equity Ratio 12.00% 29 Return on Common Equity Ratio Ratio 30 Cristal Clear, Inc. Balance Sheet As of Dec. 31, 2020 Assets 2020 2019 Cash and Equivalents 46,000 50,000 Accounts Receivable Ratio Ratio Inventory Formula Ratio Total Current Assets Ratio Formula Plant & Equipment Formula 435,000 Accumulated Depreciation 146,000 Formula Net Fixed Assets Formula Formula Total Assets Ratio 1,490,000 Liabilities and Owners' Equity Accounts Payable Formula 131,000 Short-term Notes Payable 201,000 Formula Other Current Liabilities 121,000 117,000 Total Current Liabilities 480,000 Ratio Long-term Debt Formula Formula Total Liabilities Ratio Formula Common Stock Formula 408,000 Retained Earnings 199,000 Formula Total Shareholder's Equity Formula Ratio Total Liabilities and Owners' Equity Formula Formula