solve please step by step please.
3. Cristal Clear, Inc., a manufacturer of water purification systems, has accidentally erased parts of its 2017 and 2016 financial statements. Help the company fill in the missing data using your knowledge of financial ratios. Cristal Clear, Inc. 2016 Liquidity Ratis Current Ratio Quick Ratio 2.35 Ratio Ratio OOK Emclens Ratio Inventory Turnover Ratio AR Tamover Ratio Average Collection Period Fixed Asset Turner Total Astra Ratio 14.00 Ratio 15.00 Ratio 3.50 Ratio 40.00 days Ratio Ratio Leverage Rates Total Debt Ratio Long-Term Debt Ratio LTD 0 Total Capital Debt to Equity Lone Detto Equity 60.00% Ratio Ratie Ratio Ratio Ratio Ratio Ratio Ratio Ratio Coverage Ratio Times Interest Earned Cash Coverare Ratio Ratio 3.00 4.00 Ratio Profitability Ratios Gross Profit Margin Operating Profit margin Net Profit Margin Return on Total Assets Ramon Equity Rrhum an Common Equity Ratio Ratio Ratio 4.20% Ratie Ratio Ratio Ratio 3.00% Ratio 12.00% Ratio Cristal Clear, Ine. Income Statement For the Year Ended Des. 11. 2017 2017 2016 Sales Rate Ratio Cost of Goods 2456.000 Grow Preli Formula Formel G&A Expenses Formula 207.000 Other Expenses 115,000 Formula Depreciation Ratio Ratio ERIT 175.000 Ratio Internet Expense Formula $4.000 ERT Formula Formel Taxes Formula Formula Nelleme 59.500 Formula Cristal Clear, Inc. Balance Sheet As of Dec. 31, 2017 A Cash and Equivalents 46,000 Accounts Receivable Ratio Inventory Formula Total Cross Ratio Plant & Equipment Formula Accumulated Depreciation 14.000 Net Food Formula Total Assets Lies and Equity Accounts Payable Formula Short-term Notes Payable 201.000 Other Current Liabilities 121.000 Total Carrer Liai 480.000 Long-term Debt Formula Total Liabile Ratio Common Stock Formula Retained Earnings 199,000 Total Shareholder's Equity Formula Total Liah and OE Formula 2016 50,000 Ratio Ratio Formula 435,000 Formula Formula 1.190.000 Rate 131.000 Formula 117.000 Ratio Formula Formula 408.000 Formal Ratio Formula a) Using the ratios provided, recreate the financial statements as shown using formulas. b) Complete the financial statements using formulas that refer to existing data to fill in the remaining cells. Assume tax rates for both years at 40%, depreciation for 2016 is negative $20,000, and, inventory turnover ratio for 2016 to be 3.88900415x. 3. Cristal Clear, Inc., a manufacturer of water purification systems, has accidentally erased parts of its 2017 an 2016 financial statements. Help the company fill in the missing data using your knowledge of financial ratios. Cristal Clear, Inc. Ratios 2017 2016 Liquidity Ratios Current Ratio Quick Ratio 2.35% Ratio Ratio 0.80x Efficiency Ratios Inventory Turnover Ratio AR Turnover Ratio Average Collection Period Fixed Asset Turnover Total Asset Turnover Ratio 14.00 Ratio 15.00 Ratio 3.50% 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 Ratio Ratio Ratio Ratio Coverage Ratios Times Interest Earned Cash Coverage Ratio Ratio 3.00 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 Ratio Cristal Clear, Inc. Cristal Clear, Inc. Income Statement Balance Sheet For the Year Ended Dec. 31, 2017 As of Dec. 31, 2017 2017 2016 Assets 2017 2016 Sales Ratio Ratio Cash and Equivalents 46,000 50,000 Cost of Goods 2.466.000 Accounts Receivable Ratio Ratio Gross Profit Formula Formula Inventory Formula Ratio G&A Expenses Formula 207.000 Total Current Assets Ratio Formula Other Expenses 115,000 Formula Plant & Equipment Formula 435.000 Depreciation Ratio Ratio Accumulated Depreciation 146,000 Formula EBIT 173,000 Ratio Net Fixed Assets Formula Formula Interest Expense Formula 54,000 Toral Assets Ratio 1.490,000 EBT Formula Formula Liabilities and Owners' Equity Taxes Formula Formula Accounts Payable Formula 131,000 Net Income 59.500 Formula Short-term Notes Payable 201.000 Formula Other Current Liabilities 121.000 117000 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 Liab. and OE Formula Formula a) Using the ratios provided, recreate the financial statements as shown using formulas. b) Complete the financial statements using formulas that refer to existing data to fill in the remaining cells. Assume tax rates for both years at 40%, depreciation for 2016 is negative $20,000, and, inventory turnover ratio for 2016 to be 3.88900415x. 3. Cristal Clear, Inc., a manufacturer of water purification systems, has accidentally erased parts of its 2017 and 2016 financial statements. Help the company fill in the missing data using your knowledge of financial ratios. Cristal Clear, Inc. 2016 Liquidity Ratis Current Ratio Quick Ratio 2.35 Ratio Ratio OOK Emclens Ratio Inventory Turnover Ratio AR Tamover Ratio Average Collection Period Fixed Asset Turner Total Astra Ratio 14.00 Ratio 15.00 Ratio 3.50 Ratio 40.00 days Ratio Ratio Leverage Rates Total Debt Ratio Long-Term Debt Ratio LTD 0 Total Capital Debt to Equity Lone Detto Equity 60.00% Ratio Ratie Ratio Ratio Ratio Ratio Ratio Ratio Ratio Coverage Ratio Times Interest Earned Cash Coverare Ratio Ratio 3.00 4.00 Ratio Profitability Ratios Gross Profit Margin Operating Profit margin Net Profit Margin Return on Total Assets Ramon Equity Rrhum an Common Equity Ratio Ratio Ratio 4.20% Ratie Ratio Ratio Ratio 3.00% Ratio 12.00% Ratio Cristal Clear, Ine. Income Statement For the Year Ended Des. 11. 2017 2017 2016 Sales Rate Ratio Cost of Goods 2456.000 Grow Preli Formula Formel G&A Expenses Formula 207.000 Other Expenses 115,000 Formula Depreciation Ratio Ratio ERIT 175.000 Ratio Internet Expense Formula $4.000 ERT Formula Formel Taxes Formula Formula Nelleme 59.500 Formula Cristal Clear, Inc. Balance Sheet As of Dec. 31, 2017 A Cash and Equivalents 46,000 Accounts Receivable Ratio Inventory Formula Total Cross Ratio Plant & Equipment Formula Accumulated Depreciation 14.000 Net Food Formula Total Assets Lies and Equity Accounts Payable Formula Short-term Notes Payable 201.000 Other Current Liabilities 121.000 Total Carrer Liai 480.000 Long-term Debt Formula Total Liabile Ratio Common Stock Formula Retained Earnings 199,000 Total Shareholder's Equity Formula Total Liah and OE Formula 2016 50,000 Ratio Ratio Formula 435,000 Formula Formula 1.190.000 Rate 131.000 Formula 117.000 Ratio Formula Formula 408.000 Formal Ratio Formula a) Using the ratios provided, recreate the financial statements as shown using formulas. b) Complete the financial statements using formulas that refer to existing data to fill in the remaining cells. Assume tax rates for both years at 40%, depreciation for 2016 is negative $20,000, and, inventory turnover ratio for 2016 to be 3.88900415x. 3. Cristal Clear, Inc., a manufacturer of water purification systems, has accidentally erased parts of its 2017 an 2016 financial statements. Help the company fill in the missing data using your knowledge of financial ratios. Cristal Clear, Inc. Ratios 2017 2016 Liquidity Ratios Current Ratio Quick Ratio 2.35% Ratio Ratio 0.80x Efficiency Ratios Inventory Turnover Ratio AR Turnover Ratio Average Collection Period Fixed Asset Turnover Total Asset Turnover Ratio 14.00 Ratio 15.00 Ratio 3.50% 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 Ratio Ratio Ratio Ratio Coverage Ratios Times Interest Earned Cash Coverage Ratio Ratio 3.00 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 Ratio Cristal Clear, Inc. Cristal Clear, Inc. Income Statement Balance Sheet For the Year Ended Dec. 31, 2017 As of Dec. 31, 2017 2017 2016 Assets 2017 2016 Sales Ratio Ratio Cash and Equivalents 46,000 50,000 Cost of Goods 2.466.000 Accounts Receivable Ratio Ratio Gross Profit Formula Formula Inventory Formula Ratio G&A Expenses Formula 207.000 Total Current Assets Ratio Formula Other Expenses 115,000 Formula Plant & Equipment Formula 435.000 Depreciation Ratio Ratio Accumulated Depreciation 146,000 Formula EBIT 173,000 Ratio Net Fixed Assets Formula Formula Interest Expense Formula 54,000 Toral Assets Ratio 1.490,000 EBT Formula Formula Liabilities and Owners' Equity Taxes Formula Formula Accounts Payable Formula 131,000 Net Income 59.500 Formula Short-term Notes Payable 201.000 Formula Other Current Liabilities 121.000 117000 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 Liab. and OE Formula Formula a) Using the ratios provided, recreate the financial statements as shown using formulas. b) Complete the financial statements using formulas that refer to existing data to fill in the remaining cells. Assume tax rates for both years at 40%, depreciation for 2016 is negative $20,000, and, inventory turnover ratio for 2016 to be 3.88900415x