need formulas for hreen boxes

Financial Ratios Exercise A) Liquidity Ratios: INPUT DATA SECTION: Year-end stock price Shares outstanding in milions) Tax rate 11 2010 2017 11 2018 $10.5651964 $25.22 300 1770 1.770 28% 24% 24% Current Rabo Quick Ratio Cash Rato INCOME STATEMENTS (Millions 37.341 15.074 B) Solvency! Leverage Debt Ratio Times Teresi Lamed Case Coverage Ratio c) Asset Management Ratios Net sales Cost of Goods Sold ross prott Sales. General and Administrative expenses Depreciation and amortization other Mist expenses Operating Income Other income Earnings Before Interest and Taxes (EBIT) Interest Expense Taxable income 23 Income Expense 26 Nel income 2016 2017 2018 31.509 33,39435.470 13.917 14.09314559 17,592 | 19,301120,911 13,500 13 411 13,252 1:3291 1,374 1,416 1154 156 2,600 4.360 6.079 1 160 164 178 112.7604,0246.257 227 244 234 2.533 4.2806 .023 117090 027 446 1.824 113,25 3 1114,577 21406 Inventory Turnover. Days Sales In Inventory Receivables Tumover Days' Sales Receivables Total Assel Turnover 5,723 D) Profitability Ratios W BALANCE SHEETS (MIT Prote Margin Return on Assets Retum on Equity 1.734 2115 E) Market Value Ratios 2.935 1618 3.105 Assets casm and equivalents 30. Shonen Investments A ccounts recevable 3 Inventories Other Current Assets A L unesse et pand equipment 38 other term Assets 3 TO Long-term Assets Total Assets Earnings Per Share Price Earnings Ratio BA Vi PT A MarketBook Value 10.979 | 8.205 B.740 6,0728 .788 2.101 2054 110,178 10.042 10.30319,582 2213 11,329 22,308 9.589 10.172 2,388 12.560 22.149 Earnings wow Period Revenue Growth for Period 2015-2019usemua orang form Module 3 2018-2019 mua Tor Mindor Y from Module 3) Type here to For Paints B5- Account Other Current Assets Total current 1618 711 1.778 2023 600 Eags Per Share Price Earnings De per Share Market Price Omer Long term Assets Total Long An Total Assets 9,116 102 383 1982 Camings Growth Period L 41 es and Equity Accounts payat Acer and other currenties Tomates Other Long-term L longu cartes grow Copende es es 16 13.076 Free Can 4100 13.45 4302 14.00 303 Common Stock & APC 200 205 2105 2018 FCF a common Total e s and a SOT and comment on one yetish g Matement of Retained Earnings oodepong performance SAN come Type here to search