Trusted by 2+ million users, 1000+ happy students everyday
MILESTONE ONEa 2–3-page paper. Include all calculations in an Excel documentMODULE FOUR - DUE ON FRIDAY NOVEMBER 18, 2016The project is divided into three milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final submissions. These milestoneswill be submitted in Modules Four, Six, and Eight. Your final submission, the financial analysis, will be submitted in Module Ten.Milestone One:Horizontal and Vertical Analysis: Accounts Receivable, Fixed Assets, and Debt Financing in Module Four, you will submit both a horizontal and vertical analysis of Starbucks’ accounts receivable, fixed assets, and debt financing. Use basic financial analysis to examine any horizontal and any vertical changes in Starbucks’ accounts receivable, fixed assets, and debt financing balances over time. Be sure also to discuss how Starbucks’ methods for accounting for receivables and evaluating uncollectible receivables, purchase of fixed assets, andmethods of debt financing impact the recording process and presentation of financial statements (Critical Element II). In other words, what are this company’s methods for accounting for receivables and evaluating uncollectible receivables? What types of fixed assets are acquired, and what methods are preferred for debt financing? How do those affect how financial information is communicated?Your analysis should be in the form of a 2–3-page paper. Include all calculations in an Excel document. This milestone is graded with the Milestone One Rubric.Prompt You are an analyst for Coffee Connection, a coffee shop located in the Midwest. You have been marginally successful as a company. You are now tasked with analyzing the competition and developing benchmarks for the purpose of both improving profitability and expanding operations. You have identified Starbucks as your most similar competitor. Your job now is to use multiple tools to analyze Starbucks’ performance and offer well-researched observations concerning the success and challenges faced by Starbucks. You should include an Excel spreadsheet with all calculations.Specifically, the following critical elements must be addressed:I.Introduction:Provide a concise, professional introduction explaining the purpose of your analysis to your executive. II.Horizontal and Vertical Analysis:In this section, you will conduct horizontal and vertical analyses for the balance sheet and income statement accounts and report any significant observations for a two-year period. You should include a table of your
Found this document preview useful?
You are reading a preview Upload your documents to download or Become a Desklib member to get accesss