A) Using the ratios provided, recreate tve financial estarements using formulas

B) Complete the financial statements by using formulas that refer to the existing data to fill remaining cells

*** add the formulas for the missing ratios/formulas

1 A.IlE Times New Roma-112 Conditional Format as CellInert De Formatting TableStyles Format Painter | B 1 W- 115000 Cristal Clear, Ine. Balance Sheet La of Dee. 31, 2017 Cristal Clear, Ine Cristal Clear, lne. For the Year Ended Dee. 31,2017 Current Ratio 25% Ratio .80Sales Ratio Rati 1,125,000Formala 146,000Formula Ratio1.490.000 3,005R9 2 466000Accounts Receivable 1-324,911 Formal Formula 207,000Tooal Cuaron As Coat of Goods Sold 3.50x Grom Pro Accounts Receivable Tunover Rat Average Collection Fixed Auset Turnover Ratio 1400x Ratio G&A Expenses Ratio 40 00 daysOther Expenses 1500xRatio Depeeciation Punt &Equipment Accammlated Depreciation Period 173,009Katlo Net Faod A RatieEEIT Interest ExpeniFormula$4,000 Erusp B fer. Tare, Texas Formula formal. Tehilnnadomen, Eg 0 Total Dobt Ratio 4 Loot-Term Debt Ratio 6000% Ratio Ratio 35 00% Ratio Ratio Net Lncome Ratio Ratio Notes Short torm Notes Payable Ochar Current Liablitien 201,000Formula 121,000317,000 59.500 Formula , Debt to Egaity RatioTax Rate Formula Formula 408,000 199,000Formula Ratio Times Interest Eaned Ratained Earning Tetal Sharesolder' Egwity Total Liabilhnes and Onsen Equo orwul Profitsbility Ratios Ratio RatioRatio Form Gross Profit Margin 23 Operating Proft Margin 24.3 Net Proft Marp - Returo on Total Amots 420% Ratio Ratio 12.00% 26 Retorn on Egaity HW33w t y en Windows 1 A.IlE Times New Roma-112 Conditional Format as CellInert De Formatting TableStyles Format Painter | B 1 W- 115000 Cristal Clear, Ine. Balance Sheet La of Dee. 31, 2017 Cristal Clear, Ine Cristal Clear, lne. For the Year Ended Dee. 31,2017 Current Ratio 25% Ratio .80Sales Ratio Rati 1,125,000Formala 146,000Formula Ratio1.490.000 3,005R9 2 466000Accounts Receivable 1-324,911 Formal Formula 207,000Tooal Cuaron As Coat of Goods Sold 3.50x Grom Pro Accounts Receivable Tunover Rat Average Collection Fixed Auset Turnover Ratio 1400x Ratio G&A Expenses Ratio 40 00 daysOther Expenses 1500xRatio Depeeciation Punt &Equipment Accammlated Depreciation Period 173,009Katlo Net Faod A RatieEEIT Interest ExpeniFormula$4,000 Erusp B fer. Tare, Texas Formula formal. Tehilnnadomen, Eg 0 Total Dobt Ratio 4 Loot-Term Debt Ratio 6000% Ratio Ratio 35 00% Ratio Ratio Net Lncome Ratio Ratio Notes Short torm Notes Payable Ochar Current Liablitien 201,000Formula 121,000317,000 59.500 Formula , Debt to Egaity RatioTax Rate Formula Formula 408,000 199,000Formula Ratio Times Interest Eaned Ratained Earning Tetal Sharesolder' Egwity Total Liabilhnes and Onsen Equo orwul Profitsbility Ratios Ratio RatioRatio Form Gross Profit Margin 23 Operating Proft Margin 24.3 Net Proft Marp - Returo on Total Amots 420% Ratio Ratio 12.00% 26 Retorn on Egaity HW33w t y en Windows