ACG2021 Group Project Spring16 – Online


Question Description:

30

I need help with my final accounting project, requirements 2-11 ACG2021 Group Project Spring16 – Online(1) (1).xlsx ACG2021 Spring 2016 Comprehensive Financial Statement Analysis Project Group Members Last Name First Name #REF! #REF! #REF! #REF! Instructions: You will need the annual report for Kohl’s Corporation for fiscal years 2015 and 2014. Also, the annual report for Ross Companies for fiscal year 2015. They will be provided to you in pdf format. Note that the Kohl’s and Ross’ fiscal years are referenced one year back, so, for example, the 2015 fiscal year relates to the fiscal year which ended on January 30, 2016 and the 2014 fiscal year relates to the year which ended January 31, 2015. Requirement 1: Basic Questions Answer the questions for Kohl’s fiscal 2015 year in the shaded input box. The location (source) where you can find the answer is provided for you above the shaded input box. Use only that source to answer the question. The Index on the second page of the annual report PDF file gives you a table of contents which allows you to quickly find the sources of the information. Requirement 2 – 6: Ratio and Financial Analysis For the Kohl’s ratios in requirements 2 and 3, provide the formula of the ratio, the amounts used to calculate the ratio and what the ratio measures. Enter your answers in the shaded input boxes. The first one (a.) was completed as an illustration. The ratio formulas are listed in pages 775 – 777 in chapter 13 of your textbook. I have added the number of the ratio listed in pages 775 – 777 to each ratio so that you know exactly how to calculate them. When calculating the ratios, only use the amounts included in the audited financial statements (Item 8. Financial Statements and Supplementary Data); do not just enter those that may be shown in other sections of the annual report. All other sections of the annual report except for the financial statements are not audited and as such the preparer can calculate any other ratios or financial indicators are they wish, not necessarily as the textbook prescribes. If you pick up amounts in other sections you risk getting the question wrong. Since the fiscal 2015 financial statements are comparative, they include info for both fiscal years 2015 and 2014. Use those financial statements to answer the questions about 2014 as well. However, some ratios for the 2014 year will require you go to back an additional year because some of the 2014 ratios use averages which are calculated using the 2014 + 2013 balances. For example, the inventory turnover for 2014 uses average inventory calculated by using the 2014 ending inventory balance + the 2014 beginning inventory balance (which is the ending balance in 2013). You need to obtain the fiscal 2013 ending inventory balance included in the 2014 financial statements which have been provided to you. For ratios that include averages, use a simple average calculation (beginning + ending balance / 2). Requirement 7 – 11: Ratio and Financial Analysis (Kohl’s versus competitor Ross Companies) Copy the ratio formula from the "Requirement 2 – 6" sheet to column A on the left-hand side of the spreadsheet. In this sheet, you only need to calculate the 2015 ratio for the Ross Companies on column H on the right-hand side of the spreadsheet (the actual ratio answer for Kohl’s 2015 fiscal year will be populated in column D automatically). Other: Several questions have multiple parts. Make sure you answer every part in order to receive full credit. Please do not add columns or rows to this file. I will be using this file to grade and my grading template is in this same format. The points assigned to each question are included in the boxes highlighted in pink on the right-hand side of the question. There are 207 points which is equivalent to 100%. Requirement 1 Answer BASIC INFORMATION about company operations and financial results for the Kohl’s Corp 2015 fiscal yea NOTE: Use amounts

Answer

30