Describe the results of the ratio analysis Walgreens boot alliance and CVS from 2016 t0...
60.1K
Verified Solution
Link Copied!
Question
Finance
Describe the results of the ratio analysis Walgreens boot alliance and CVS from 2016 t0 2020 focusing on the key ratios. A good way to do this is using graphs but I leave it up to each team to determine how they feel they can most effectively show these. Focus on trends, which company is performing stronger than the other, etc. Obviously the ratios need to be calculated correctly and equally important is your analysis of how you interpret these trends. In other words, what conclusions can you draw from them. To repeat what I stated in the project instructions, I do not want this to simply be a regurgitation of the ratio numbers but rather what did you see in the results that you liked or didnt like
Walgreens Boots Alliance
Year
2016
2017
2018
2019
2020
Average Accounts Receivable
$6,554.50
$6,394
$6,551
$6,900
$7,179
Average Inventory
$8,817
$8,928
$9,232
$9,449
$9,392
Sales
$117,351
$118,214
$131,537
$136,866
$139,537
Cost of Sales
$87,477
$89,052
$100,745
$106,790
$111,520
Days of Sales Outstanding
20.39
19.74
18.18
18.40
18.78
Days of Inventory Outstanding
36.79
36.59
33.45
32.30
30.74
CVS
Year
2016
2017
2018
2019
2020
Accounts Receivable
$12,164
$13,181
$17,631
$19,617
$21,742
Average Inventory
$14,381
$15,028
$15,873
$16,983
$18,006
Net Sales
$177,526
$184,765
$194,579
$256,776
$268,706
COGS
$148,669
$156,220
$190,558
$244,789
$254,795
Days of Sales Outstanding
25.01
26.04
33.07
27.89
29.53
Days of Inventory Outstanding
35.31
35.11
30.40
25.32
25.79
Return on investment (ROI) performance:
Return on investment (ROI) is a way to tell the profitability of an investment. ROI is a regularly used calculation to see the return/profit from an investment relative to the investment cost. If the ROI calculation returns a positive value then the investment will yield a worthy return. If the ROI value is negative then the investment will lose money.
Return on Investment = Income Generated/ 2-point Average Total Assets
Return on Equity = Income Generated/ 2-point Average Stockholders Equity
Walgreens Boots Alliance
Year
2016
2017
2018
2019
2020
Income
$4,191
$4,101
$5,024
$3,982
$456
Total Assets
$72,688
$66,009
$68,124
$76,598
$87,174
Average total Assets
$70,735
$69,349
$67,067
$72,361
$81,886
Stockholders Equity
$30,281
$28,274
$26,689
$67,598
$87,174
Average Stockholders Equity
$30,790.5
$29,278
$27,482
$47,144
$77,386
Return on Investment
0.0592
0.0591
0.0749
0.0550
0.0056
Return on Equity
0.1361
0.1401
0.1828
0.0845
0.0059
%Return on Investment
5.92 %
5.91 %
7.49 %
5.50 %
0.55 %
%Return on Equity
13.61 %
14.01 %
18.28 %
8.45 %
0.589 %
CVS
Year
2016
2017
2018
2019
2020
Income
$5,319
$6,623
-$594
$6,631
$7,192
Total Assets
$94,462
$95,131
$196,456
$222,449
$230,715
Average total Assets
$30,100
$94,797
$145,794
$209,453
$226,582
Stockholders Equity
$36,834
$37,695
$58,543
$64,170
$69,701
Average Stockholders Equity
$37,018.50
$37,265
$48,119
$61,357
$66,936
Return on Investment
0.1767
0.0699
-0.0041
0.0317
0.0317
Return on Equity
0.1437
0.1778
-0.0123
0.1081
0.1074
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!