FIND OUT LIQUIDITY RATIO FROM 2018 TO 2021

myCapu - Capilano U X Th Course: BADM 204 41 x | | Results BADM 204-41 X C Get Homework Help Minbox (151) -sukh - capilanou1-my.sharepoint.com/x/g/personal/jessicagiancola my capilanou_ca/EaoKtROPBVVBqA2sxgb-UY8BUJA cel 241 Group Project Excel Template RR- Saved V Search (Alt + 0) le Home Insert Draw Page Layout Formulas Data Review View Help Editing Arial 10 B v v Av... ar ab Merge General Ram.more Thanks for using Office! We've made some updates to the privacy settings to give you more control. Your organization's admin allows you to use several cloud-backed service al cloud-backed services are provided to you under the Microsoft Services Agreement. fr A B D E G H Company Name CLOROX Note: Liqudity Ratios Repla This c Current ratio 2021 2020 2019 2018 Column1 Current assets Your Company 0.88959144 1.424541608 0.90625 1.0925 Current liabilities Competitor 1 Competitor 2 Quick ratio 2021 2020 Column1 2019 2018 1 Quick Assets Current liabilities 2 3 4 Your Company Competitor 1 Competitor 2 5 6 7 8 19 20 21 22 BS IS CF MR CF PR LR AUR DuPont DUR Sample Balance Sheet Sample CF + Calculation Mode: Automatic Workbook Statistics : Type here to search O 99+ 99 a o Documents - Word Product Activation Failed PAGE LAYOUT REFERENCES MAILINGS TABLE TOOLS DESIGN LAYOUT REVIEW VIEW Clorox Balance Sheet As of lune 30 Dollars in millions, except share and per share data $2,484 $301 $834 $67 $3,686 $5,742 $2.780 $278 $767 $ $62 $3,887 $5,305 $2,287 $2.284 $0 $778 $ $780 $78 $50 $0 $3,117 $3,140 $4,557 $4,340 2021 2020 $319 $504 $752 5154 $1.829 $871 5648 $454 $47 $2,020 Asstes Current assets Cash and cash equivalents Receivables, Net inventories, Net Prepaid expenses and other current assets Total current assets Non-current assets Property, plant and equipment, net Operating lease cht-of-use assets Goodwin Trademarks.net Other intangible assets net Other assets Total non-current weats Total assets Long-term debt Long-term operating lease liabilities Other liabilities Deferred income taxes 2019 2018 Total non-current liabilities Total liabilities Commitments and Contingencies $111 $131 Stockholders' equity $631 $600 Perferred stock $312 $506 Common stock $51 $74 Additional paid in capital $1,305 $1,311 Retained Earnings Treasury shares $1,034 $996 Accumulated other comprehensive net loss) income 50 $0 Total Clorox stockholders' equity $1,591 $1.602 Nocontrolling interest $791 $295 Stockholders equity $121 $134 Total liabilities and stockholders' equity $274 $222 53,811 $3,749 $5,116 $5,000 SO $131 $1,186 $1,036 {$1.396) 15546) $411 $181 $592 56,153 SO $159 $1,137 $3.567 (53.315) (5640) $ $908 $0 5908 $6.213 SO $0 $159 $159 $1,046 $975 $3,150 $2,797 ($3,194) $2,658) 5602) 15547) $559 $726 $0 SO $559 $726 $ $5 116 $5,066 $1302 $332 $1.575 $69 $225 $376 S4,SOS $6,334 $1.103 $291 $1.57 $795 $109 Sa 29 $4,193 $6,213 Liabilities and Stockholders' Equity Current liabilities Notes and loan parte Current matures of long-term de Current operating lewat Account Payable and actual incon Tax Payable Tutal current liabilities Noncurrent liabilities $300 581 51.675 30 52,056 30 564 51.325 $25 $1.418 $199 $350 $0 $ 50 $0 $1,035 $1.001 59 SO 51.440 $1200 $ o BE 11C 99+ 3 14 15 16 17 18 19 FO 1122 X O/ X brook el 241 Group Project Excel Template gk - Saved Review View Help Editing Data Draw Formulas Insert Page Layout e Home General ab Merge v v Av v 14 B Calibri Thanks for using Office! We've made some updates to the privacy settings to give you more control. Your organization's admin allows you to use several cloud-backed Learn more al doud-backed services are provided to you under the Microsoft Services Agreement fx D B E A Preferred Stock: $1.00 par value; 5,000,000 shares authorized; non issued or outstanding Common Stock: $1.00 par value; 750,000,000 shares authorized; 158,741,461 shares issued as of June 30, 2020 and 2019, respectively 5 7 Treasury shares, at cost: 32,542,855 and 33,055,136 shares as of June 30, 2020 + 8 and 2019, respectively 69 50 2018 61 Preferred Stock: $1.00 par value; 5,000,000 shares authorized; non issued or outstanding 62 Common Stock: $1.00 par value; 750,000,000 shares authorized; 158,741,461 shares issued as of June 30, 2020 63 Treasury shares, at cost: 30,758,694 and 29,727,289 shares as of June 30, 2020 64 65 66 67 68 69 70 Sample CF + MR CF- BS IS CF Sample Balance Sheet PR LR AUR DuPont DUR Calculation Mode: Automatic Workbook Statistics Type here to search 99+ 1 12 14 16 17 13 15 esc 0 e 4 Documenti Word Product Activation Failed) PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW + Clorox Income Statement Years ended June 30 Dollars in millions, except share, and pre share data Weighted average shares outstanding in thousands) Basic 125,57000 125,828.0 127,734,0 129,293.0 0 o 0 0 127,299.0 127,671.0 129,792.0 131,5810 0 0 0 0 Diluted 2021 2020 2019 2018 Net Sales Cost of products sold Gross profit $2341 $ $4.142 $3,199 $6.721 $3,658 $3,063 $6.214 $3.486 $2,728 $6 124 $3,449 $ $2,675 $ $1,004 $969 $856 $837 Selling and administrative expenses Advertising costs Research and development costs Interest expense Other income) expense net $790 $149 5675 $145 $ $612 $136 $570 $132 $99 (572) $99 ($10) $97 $3 $85 ($3) $1,970 $1,229 $1.878 $1185 $1,704 $1,024 $1,621 $ $1.054 Earnings before income taxes Income taxes Net earnings $181 $1,048 $246 $939 $204 $820 $231 $823 5.66 7.46 6,42 6.37 Net carines per share attributable to Clorox Basicnet earnings per share Diluted net earnings per share 5.58 7.36 6.32 6.26 99+ myCapu - Capilano U X Th Course: BADM 204 41 x | | Results BADM 204-41 X C Get Homework Help Minbox (151) -sukh - capilanou1-my.sharepoint.com/x/g/personal/jessicagiancola my capilanou_ca/EaoKtROPBVVBqA2sxgb-UY8BUJA cel 241 Group Project Excel Template RR- Saved V Search (Alt + 0) le Home Insert Draw Page Layout Formulas Data Review View Help Editing Arial 10 B v v Av... ar ab Merge General Ram.more Thanks for using Office! We've made some updates to the privacy settings to give you more control. Your organization's admin allows you to use several cloud-backed service al cloud-backed services are provided to you under the Microsoft Services Agreement. fr A B D E G H Company Name CLOROX Note: Liqudity Ratios Repla This c Current ratio 2021 2020 2019 2018 Column1 Current assets Your Company 0.88959144 1.424541608 0.90625 1.0925 Current liabilities Competitor 1 Competitor 2 Quick ratio 2021 2020 Column1 2019 2018 1 Quick Assets Current liabilities 2 3 4 Your Company Competitor 1 Competitor 2 5 6 7 8 19 20 21 22 BS IS CF MR CF PR LR AUR DuPont DUR Sample Balance Sheet Sample CF + Calculation Mode: Automatic Workbook Statistics : Type here to search O 99+ 99 a o Documents - Word Product Activation Failed PAGE LAYOUT REFERENCES MAILINGS TABLE TOOLS DESIGN LAYOUT REVIEW VIEW Clorox Balance Sheet As of lune 30 Dollars in millions, except share and per share data $2,484 $301 $834 $67 $3,686 $5,742 $2.780 $278 $767 $ $62 $3,887 $5,305 $2,287 $2.284 $0 $778 $ $780 $78 $50 $0 $3,117 $3,140 $4,557 $4,340 2021 2020 $319 $504 $752 5154 $1.829 $871 5648 $454 $47 $2,020 Asstes Current assets Cash and cash equivalents Receivables, Net inventories, Net Prepaid expenses and other current assets Total current assets Non-current assets Property, plant and equipment, net Operating lease cht-of-use assets Goodwin Trademarks.net Other intangible assets net Other assets Total non-current weats Total assets Long-term debt Long-term operating lease liabilities Other liabilities Deferred income taxes 2019 2018 Total non-current liabilities Total liabilities Commitments and Contingencies $111 $131 Stockholders' equity $631 $600 Perferred stock $312 $506 Common stock $51 $74 Additional paid in capital $1,305 $1,311 Retained Earnings Treasury shares $1,034 $996 Accumulated other comprehensive net loss) income 50 $0 Total Clorox stockholders' equity $1,591 $1.602 Nocontrolling interest $791 $295 Stockholders equity $121 $134 Total liabilities and stockholders' equity $274 $222 53,811 $3,749 $5,116 $5,000 SO $131 $1,186 $1,036 {$1.396) 15546) $411 $181 $592 56,153 SO $159 $1,137 $3.567 (53.315) (5640) $ $908 $0 5908 $6.213 SO $0 $159 $159 $1,046 $975 $3,150 $2,797 ($3,194) $2,658) 5602) 15547) $559 $726 $0 SO $559 $726 $ $5 116 $5,066 $1302 $332 $1.575 $69 $225 $376 S4,SOS $6,334 $1.103 $291 $1.57 $795 $109 Sa 29 $4,193 $6,213 Liabilities and Stockholders' Equity Current liabilities Notes and loan parte Current matures of long-term de Current operating lewat Account Payable and actual incon Tax Payable Tutal current liabilities Noncurrent liabilities $300 581 51.675 30 52,056 30 564 51.325 $25 $1.418 $199 $350 $0 $ 50 $0 $1,035 $1.001 59 SO 51.440 $1200 $ o BE 11C 99+ 3 14 15 16 17 18 19 FO 1122 X O/ X brook el 241 Group Project Excel Template gk - Saved Review View Help Editing Data Draw Formulas Insert Page Layout e Home General ab Merge v v Av v 14 B Calibri Thanks for using Office! We've made some updates to the privacy settings to give you more control. Your organization's admin allows you to use several cloud-backed Learn more al doud-backed services are provided to you under the Microsoft Services Agreement fx D B E A Preferred Stock: $1.00 par value; 5,000,000 shares authorized; non issued or outstanding Common Stock: $1.00 par value; 750,000,000 shares authorized; 158,741,461 shares issued as of June 30, 2020 and 2019, respectively 5 7 Treasury shares, at cost: 32,542,855 and 33,055,136 shares as of June 30, 2020 + 8 and 2019, respectively 69 50 2018 61 Preferred Stock: $1.00 par value; 5,000,000 shares authorized; non issued or outstanding 62 Common Stock: $1.00 par value; 750,000,000 shares authorized; 158,741,461 shares issued as of June 30, 2020 63 Treasury shares, at cost: 30,758,694 and 29,727,289 shares as of June 30, 2020 64 65 66 67 68 69 70 Sample CF + MR CF- BS IS CF Sample Balance Sheet PR LR AUR DuPont DUR Calculation Mode: Automatic Workbook Statistics Type here to search 99+ 1 12 14 16 17 13 15 esc 0 e 4 Documenti Word Product Activation Failed) PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW + Clorox Income Statement Years ended June 30 Dollars in millions, except share, and pre share data Weighted average shares outstanding in thousands) Basic 125,57000 125,828.0 127,734,0 129,293.0 0 o 0 0 127,299.0 127,671.0 129,792.0 131,5810 0 0 0 0 Diluted 2021 2020 2019 2018 Net Sales Cost of products sold Gross profit $2341 $ $4.142 $3,199 $6.721 $3,658 $3,063 $6.214 $3.486 $2,728 $6 124 $3,449 $ $2,675 $ $1,004 $969 $856 $837 Selling and administrative expenses Advertising costs Research and development costs Interest expense Other income) expense net $790 $149 5675 $145 $ $612 $136 $570 $132 $99 (572) $99 ($10) $97 $3 $85 ($3) $1,970 $1,229 $1.878 $1185 $1,704 $1,024 $1,621 $ $1.054 Earnings before income taxes Income taxes Net earnings $181 $1,048 $246 $939 $204 $820 $231 $823 5.66 7.46 6,42 6.37 Net carines per share attributable to Clorox Basicnet earnings per share Diluted net earnings per share 5.58 7.36 6.32 6.26 99+