Help

please put excel formulas too for all yellow cells

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. C nstal ciear, ine: Income Statement Balance Sheet For the Year Fnded Dec. 31,2020 As of Dec. 31,2020 Cristal Clear, Inc. Cristal Clear, Inc. Income Statement Balance Sheet Far the Yoar Findod Dor 31. 2020 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 \& Analysis). Each ratio and formula is worth 0.30 point: total 19 pts