Question: USING THE FINANCIAL STATMENT FOR Walgreens vs. CVS financial analysis: Questions : 1) Ratios: Walgreens 8/31/20 CVS 12/31/19 EXPLAIN A Net Working Capital B Current







USING THE FINANCIAL STATMENT FOR Walgreens vs. CVS financial analysis:
Questions :
1) Ratios:
|
|
| Walgreens 8/31/20 | CVS 12/31/19 | EXPLAIN |
|
A | Net Working Capital |
|
|
|
|
B | Current ratio |
|
|
|
|
C | Quick ratio |
|
|
|
|
D | Gross Profit ($ and %) |
|
|
|
|
E | Debt ratio |
|
|
|
|
F | Accounts Receivable Turnover |
|
|
|
|
G | Inventory Turnover |
|
|
|
|
H | EPS |
|
|
|
|
I | ROE |
|
|
|
|
J | Market cap |
|
|
|
|
K | Free Cash Flow |
|
|
|
2. Using Walgreens financials, calculate a horizontal analysis ($ and %) on the income statement including gross profit (you will have to calculate). I recommend using EXCEL spreadsheet to do this question.
2a. Using Walgreens financials, then do the vertical analysis for the balance sheet for 2018 and 2017). I recommend using EXCEL spreadsheet to do this question.
2b. What do you notice about the change from year to year on income statement and the change in the balances compared to the prior year? Be as specific as possible.
3. Which company would you invest, Walgreens or CVS, based on the financial statement analysis? Give me at least two sentences on how much and why.
W:ALAREFNS BOOTS AL.1AVCE, INC- AND SA HSIDLARIES CONSOL.IDATED SIATEMLEVS QF CASH FLGWS Foe the years ended A ugust 51 . 2020,2019 and 2018 i= madinasion WA1RERFENS BOOTS A1.11A VCF, INC-A ND S1 HSIDLARIFS CONSOL.IDATED STATEMINTS OF COMPHEHENSIVE. INCOME: For the years ended August 31, 2020, 2019 and 2018 (ie milliots) The accompaming zotes to Cousolidated Financial Stalements are an integral part of these suriements. 45 stbegecasse: WAIGRFFNS BOOTS A1.1 1A VCF, INC- AVD SI HSIDIARIFS CONSOIMATFD STATFMENTS OF CASH FIABWS For the years cuded Augunt 31, 2021, 2019 and 2018 (i. milliond) Cash thows from operating activities! Net eirnitgs Depreciation and amertication G Gin on provesly had equity interts Dedented income taves SIIYNGTSI 15 0NV"JNI'TJNVTTTV SIOOA SNITMYTV'M WALGREENS DOOTS ALLANCE, INC. AVD SLDSDLRRES CONSOLMATED STATEMIEVTS OF EQUTT For the years ended August 31,2020,2019 and 2018 fin milline encent shanoi 63. WALGREENS DOOTS ALLIAVCE, INC. AND SLUSDLRIES CONSOLIDATED STNTEUILNTS OF EARVINGS For the years ended August 31 , z620, 2019 and 2018 (in millions, except per share amounts) 8:30 Walgreens 10K 201... Tee accompaming sotes to Consolidated Finanial stwemems are an inte-nal part of these Smements. 5. (0. Dashboard Calendar To Do Notifications Inbox Canvulitatou Statenknts of Shartholders' Fquity earaigsaf \$? niliee, esch drieg the par endad Ihaceriber 11,3114 . Sec acoampuanying taves ta can*alidaned firtancial stanementx. Censulidated Slatements of Shareholders' Fquity Consolidated Statements of Cash Flous 94 Index to Consolidated Finangial Statemsits fa. iminn Keoceciliation of net asame (lase) to ner eash provided by aperarigg activities: Net income (loss) Adjustmems recuir al to recovicile tact income (lass) wo thet each provided by cperating aktivities: Deprecsation and artiortizatien Goodwill impainsents Lass ce sentement af defined benefit pensien plans W:ALAREFNS BOOTS AL.1AVCE, INC- AND SA HSIDLARIES CONSOL.IDATED SIATEMLEVS QF CASH FLGWS Foe the years ended A ugust 51 . 2020,2019 and 2018 i= madinasion WA1RERFENS BOOTS A1.11A VCF, INC-A ND S1 HSIDLARIFS CONSOL.IDATED STATEMINTS OF COMPHEHENSIVE. INCOME: For the years ended August 31, 2020, 2019 and 2018 (ie milliots) The accompaming zotes to Cousolidated Financial Stalements are an integral part of these suriements. 45 stbegecasse: WAIGRFFNS BOOTS A1.1 1A VCF, INC- AVD SI HSIDIARIFS CONSOIMATFD STATFMENTS OF CASH FIABWS For the years cuded Augunt 31, 2021, 2019 and 2018 (i. milliond) Cash thows from operating activities! Net eirnitgs Depreciation and amertication G Gin on provesly had equity interts Dedented income taves SIIYNGTSI 15 0NV"JNI'TJNVTTTV SIOOA SNITMYTV'M WALGREENS DOOTS ALLANCE, INC. AVD SLDSDLRRES CONSOLMATED STATEMIEVTS OF EQUTT For the years ended August 31,2020,2019 and 2018 fin milline encent shanoi 63. WALGREENS DOOTS ALLIAVCE, INC. AND SLUSDLRIES CONSOLIDATED STNTEUILNTS OF EARVINGS For the years ended August 31 , z620, 2019 and 2018 (in millions, except per share amounts) 8:30 Walgreens 10K 201... Tee accompaming sotes to Consolidated Finanial stwemems are an inte-nal part of these Smements. 5. (0. Dashboard Calendar To Do Notifications Inbox Canvulitatou Statenknts of Shartholders' Fquity earaigsaf \$? niliee, esch drieg the par endad Ihaceriber 11,3114 . Sec acoampuanying taves ta can*alidaned firtancial stanementx. Censulidated Slatements of Shareholders' Fquity Consolidated Statements of Cash Flous 94 Index to Consolidated Finangial Statemsits fa. iminn Keoceciliation of net asame (lase) to ner eash provided by aperarigg activities: Net income (loss) Adjustmems recuir al to recovicile tact income (lass) wo thet each provided by cperating aktivities: Deprecsation and artiortizatien Goodwill impainsents Lass ce sentement af defined benefit pensien plans
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
