please help complete highlighted areas and show formulas and ratio calculations in excel

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. Challware 2000 2019 Ly Kalina Curreno JO Rails EN inctory Turnoveratie Rati ART 14.00 Average Piet Rate :00 day Fred As Turn S.R Total Aant le Ratio Laget Tool Ratio Long Term Duben Ralle LTDT Capital Rain Ratin Du Ratio Rutin Le Tomb Ratio B 4.00 Timot med Ratin 3.00 Pre R GoPro Mugim Rati Dating Pool Marin Ratio NetMargin Rati Roman Total Asics 4. Matumly Rati Betawm tsunam Tauty Katie R Rati 3. Ratio 12. Ratio Chall Cristal Im Statemat For the Year Ended Dec. 31.2830 Asal D. 1.2 MM 2008 sale Katie alais Kate 20.000 eur Hati Gw |Paraal untary GRAE2017. Par Hair Other 115.000 Frete 495.00 Der Hata Raticate Decorate JEBIT 13. Rated Poster Inime4,00 Retet Hulle ERT Free Porn Tandheer' TAN Form Foreca Nude 8.50 Form Pytle 201.00 ure 12.10 - Ratin De Formulari Radar el. RE 199,00 Share Rate Toute la and OE Fermer 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 (Identify and Access Needed Information & Cristal Clear, Inc. Ratios Current Ratio Quick Ratio Inventory Turnover Ratio Accounts Receivable Turnover Ratio Average Collection Period Fixed Asset Turnover Total Asset Turnover Total Debt Ratio Long-Term Debt Ratio LTD to Total Capitalization Debt to Equity Long-Term Debt to Equity 2020 2019 Liquidity Ratios For th 2.35x Ratio Ratio 0.80x Efficiency Ratios Ratio 3.50x 14.00x Ratio Ratio 40.00 days 15.00x Ratio Ratio Ratio Leverage Ratios 60.00% Ratio Ratio 35.00% Ratio Ratio Ratio Ratio Ratio Ratio Coverage Ratios Ratio 4.00x 3.00x 3.63x) Profitability Ratios Ratio Ratio Ratio Ratio Ratio 3.00% 4.20% Ratio Ratio 12.00% Ratio Ratio Times Interest Earned Cash Coverage Ratio Gross Profit Margin Operating Proft Margin Net Proft Margin Return on Total Assets Return on Equity Return on Common Equity Cristal Clear, Inc. Income Statement he Year Ended Dec. 31, 2020 Sales Cost of Goods Sold Gross Profit G&A Expenses Other Expenses Depreciation EBIT Interest Expense Earnings Before Tuxes Taxes Net Income Notes Tax Rate 2020 2019 Ratio Ratio 3,005,089 2,466,000 1,324,910.937 Formula Formula 207,000 115,000 Formula Ratio Ratio 173,000 Ratio Formula 54,000 Formula Formula Formula Formula 59,500 Formula Cristal Clear, Inc. Balance Sheet As of Dec. 31, 2020 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 Current Liabilities Long-term Debt Total Liabilities Common Stock Retained Earnings Total Shareholder's Equity Total Liabilities and Owners' Equity 2020 2019 46,000 50,000 Ratio Ratio Formula Ratio Ratio Formula Formula 435.000 146,000 Formula Formula Formula Ratio 1,490,000 40% Formula 131,000 201,000 Formula 121,000 117,000 480,000 Ratio Formula Formula Ratio Formula Formula 408,000 199,000 Formula Formula Ratio Formula Formula 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. Challware 2000 2019 Ly Kalina Curreno JO Rails EN inctory Turnoveratie Rati ART 14.00 Average Piet Rate :00 day Fred As Turn S.R Total Aant le Ratio Laget Tool Ratio Long Term Duben Ralle LTDT Capital Rain Ratin Du Ratio Rutin Le Tomb Ratio B 4.00 Timot med Ratin 3.00 Pre R GoPro Mugim Rati Dating Pool Marin Ratio NetMargin Rati Roman Total Asics 4. Matumly Rati Betawm tsunam Tauty Katie R Rati 3. Ratio 12. Ratio Chall Cristal Im Statemat For the Year Ended Dec. 31.2830 Asal D. 1.2 MM 2008 sale Katie alais Kate 20.000 eur Hati Gw |Paraal untary GRAE2017. Par Hair Other 115.000 Frete 495.00 Der Hata Raticate Decorate JEBIT 13. Rated Poster Inime4,00 Retet Hulle ERT Free Porn Tandheer' TAN Form Foreca Nude 8.50 Form Pytle 201.00 ure 12.10 - Ratin De Formulari Radar el. RE 199,00 Share Rate Toute la and OE Fermer 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 (Identify and Access Needed Information & Cristal Clear, Inc. Ratios Current Ratio Quick Ratio Inventory Turnover Ratio Accounts Receivable Turnover Ratio Average Collection Period Fixed Asset Turnover Total Asset Turnover Total Debt Ratio Long-Term Debt Ratio LTD to Total Capitalization Debt to Equity Long-Term Debt to Equity 2020 2019 Liquidity Ratios For th 2.35x Ratio Ratio 0.80x Efficiency Ratios Ratio 3.50x 14.00x Ratio Ratio 40.00 days 15.00x Ratio Ratio Ratio Leverage Ratios 60.00% Ratio Ratio 35.00% Ratio Ratio Ratio Ratio Ratio Ratio Coverage Ratios Ratio 4.00x 3.00x 3.63x) Profitability Ratios Ratio Ratio Ratio Ratio Ratio 3.00% 4.20% Ratio Ratio 12.00% Ratio Ratio Times Interest Earned Cash Coverage Ratio Gross Profit Margin Operating Proft Margin Net Proft Margin Return on Total Assets Return on Equity Return on Common Equity Cristal Clear, Inc. Income Statement he Year Ended Dec. 31, 2020 Sales Cost of Goods Sold Gross Profit G&A Expenses Other Expenses Depreciation EBIT Interest Expense Earnings Before Tuxes Taxes Net Income Notes Tax Rate 2020 2019 Ratio Ratio 3,005,089 2,466,000 1,324,910.937 Formula Formula 207,000 115,000 Formula Ratio Ratio 173,000 Ratio Formula 54,000 Formula Formula Formula Formula 59,500 Formula Cristal Clear, Inc. Balance Sheet As of Dec. 31, 2020 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 Current Liabilities Long-term Debt Total Liabilities Common Stock Retained Earnings Total Shareholder's Equity Total Liabilities and Owners' Equity 2020 2019 46,000 50,000 Ratio Ratio Formula Ratio Ratio Formula Formula 435.000 146,000 Formula Formula Formula Ratio 1,490,000 40% Formula 131,000 201,000 Formula 121,000 117,000 480,000 Ratio Formula Formula Ratio Formula Formula 408,000 199,000 Formula Formula Ratio Formula Formula