ACG2021.xlsx - ACG2021 Comprehensive Financial Statement...

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

View Full Document Right Arrow Icon
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.
Image of page 1

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

View Full Document Right Arrow Icon
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
Image of page 2
s Project #REF! #REF! #REF! #REF! years 2015 and 2014, along with the annual report for CVS for fiscal year 2015. They will be provided to you in pdf fo ear in the shaded input box. ends, both use fiscal years that end on a date that is not December 31 (e.g. the 2015 fiscal year relates to the fiscal y e year which ended August 31, 2014). ovided for you above the shaded input box. Use only that source to answer the question. The Table of Contents of th fferent Items commence. la of the ratio, the amounts used to calculate the ratio and what the ratio measures. Enter your answers in the shade r 13 of your textbook . I have added the number of the ratio listed in pages 786-787 to each ratio so that you know e
Image of page 3

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

View Full Document Right Arrow Icon
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.
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern