ACG
ACG2021.xlsx

# ACG2021.xlsx - ACG2021 Comprehensive Financial Statement...

• Lab Report
• 56
• 100% (2) 2 out of 2 people found this document helpful

This preview shows pages 1–5. Sign up to view the full content.

ACG2021 Comprehensive Financial Statement Analysis Fall 2017 Group Members Last Name First Name Slastukhina Yulia Instructions: You will need the annual reports for Walgreens for fiscal y Requirement 1: Basic Questions Answer the questions for Walgreens for the fiscal 2015 ye Requirement 2 - 6: Ratio and Financial Analysis Note that neither Walgreens nor CVS have calendar year e on August 31, 2015 and the 2014 fiscal year relates to the The location (source) where you can find the answer is pro PDF file allows you to quickly find the pages where the diff For the ratios in requirements 2 and 3, provide the formul The first one (a.) was completed as an illustration. The ratio formulas are listed in pages 786-787 in chapter calculate them.

This preview has intentionally blurred sections. Sign up to view the full version.

For ratios that include averages, use a simple average calc Requirement 7 - 11: Ratio and Financial Analysis (Walgreen's v Copy the following from the "Requirement 2 - 6" sheet to Other: Note the denomination of the amounts reported since the Certain terminology may be a bit different than what you amount reported on the Income Statement (which they ca Several questions have multiple parts. Make sure you answ Please do not add columns or rows to this file. I will be us The points assigned to each question are included in the b When calculating the ratios, only use the amounts include shown in other sections of the annual report. All other se ratios or financial indicators are they wish, not necessarily Since the fiscal 2015 financial statements are comparative However, some ratios for the 2014 year will require you go example, the inventory turnover for 2014 uses average inv in 2013). You need to obtain the fiscal 2013 ending invent You only need to calculate the 2015 ratio for CVS on the c

This preview has intentionally blurred sections. Sign up to view the full version.

culation (beginning + ending balance / 2). versus competitor CVS) o the columns on the left-hand side of the spreadsheet: Ratio formula and actual ratio answer for Walgreens 2015 ey are in millions. So, the Cash and Cash Equivalents balance of "\$3,000" means 3,000 million, or \$3 billion. learned in the textbook. For example, instead of Net Income, Walgreens reports "Net Earnings" as the final all the "Statement of Earnings"). If you have any questions on the terminology, please contact me.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern