Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1- Using Walgreens financials, calculate a horizontal analysis ($ and %) on the income statement including gross profit (you will have to calculate). I recommend

1- Using Walgreens financials, calculate a horizontal analysis ($ and %) on the income statement including gross profit (you will have to calculate). I recommend using the EXCEL spreadsheet to do this question.

2- Using Walgreens financials, then do the vertical analysis for the balance sheet for 2018 and 2017). I recommend using the EXCEL spreadsheet to do this question.

3- What do you notice about the change from year to year on the income statement and the change in the balances compared to the prior year? Be as specific as possible.

4- 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.

image text in transcribed

.
Ratios: Walgreens 8/31/18 CVS 12/31/18 A Net Working Capital S-3821 | $1,234 Current ratio 0.82 1.03 Quick ratio 0.78 0.55 Gross Profit ($ and $30,792 23.41% $33,132 17.03% Debt ratio Accounts Receivable Turnover 5.02 0.07 G Inventory Turnover 13,75 9.51 EPS 46.70 32.85 ROE 1,03 2.25 Market cap 195.46 522 Free Cash Flow 17,026 1,499

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance Services

Authors: Timothy Louwers, Robert Ramsay, David Sinason, Jerry Straws

6th edition

978-1259197109, 77632281, 77862341, 1259197107, 9780077632281, 978-0077862343

More Books

Students also viewed these Accounting questions