Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Module 8 CLC I need both number 5's completed. One in Excel and the other I need in a APA format. . Analyze Starbucks financial
Module 8 CLC I need both number 5's completed. One in Excel and the other I need in a APA format.
. Analyze Starbucks financial statements for the prior five years. Include the following items as supplemental schedules to the analysis, prepared as individual worksheets within an Excel spreadsheet: 1. Horizontal analysis of the prior five years' income statement and balance sheet. 2. Vertical analysis of the prior five years' income statement and balance sheet. 3. Calculation of at least five significant liquidity ratios for each of the five years analyzed. 4. Calculation of at least five significant profitability ratios for each of the five years analyzed. 5. Calculation of at least five significant long-term debt-paying ratios for each of the five years analyzed. 6. Calculation of at least five significant investor ratios for each of the five years analyzed. Prepare a paper (10-15 pages) that analyzes the financial strengths and weaknesses of the company examined. 1. Reference significant items found on the income statement, balance sheet, and statement of cash flows (2 pages min.) 2. Reference significant items found in the horizontal analysis and vertical analysis (2 pages min.) 3. Reference significant items found in the ratio analysis (2 pages min.) 4. Competitor analysis and comparison to industry averages (2 pages min.) 5. Summary identifying whether the company would be attractive to investors and/or creditors (2 pages min.) There are five of us in the group and I do not mind taking responsibility for items 1 & 2 for our Excel Spreadsheet, which leaves 3-6 for each of you to take responsibility for one item for Excel. I have broken down minimum page requirements for each of the topics that we must cover in our paper to get us to the minimum page requirement. Remember that is double-spaced Times New Roman 12 pt font. I will let everyone else choose what portions they want to be responsible for in regards to our paper and will take what is left over. I do not mind compiling the project, but we need to make sure we get started soon so that we can all have a chance to look over and verify everyone's contributions. Proposed schedule for completion: Submit Excel portions to forum by 9/19 (next Saturday) Finalize Excel spreadsheets (edited by everyone) by 9/23 Submit paper portions to forum by 10/1 Finalize paper (suggested edits done) by 10/3 Final submission by myself by 10/3 - 10/4 This is a lot of information, please review it all and let me know if this division of responsibilities and timeline works for everyoneStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started