submit both a horizontal and vertical analysis of Starbucks’ accounts receivable, fixed assets, and debt financing

For this assignment, due in Module Four, you will submit both a horizontal and vertical analysis of Starbucks’ accounts receivable, fixed assets, and debtfinancing. Use basic financial analysis to examine any horizontal and any vertical changes in Starbucks’ accounts receivable, fixed assets, and debt financingbalances over time. Be sure also to discuss how Starbucks’ methods for accounting for receivables and evaluating uncollectible receivables, purchase of fixedassets, and methods of debt financing impact the recording process and presentation of financial statements (Critical Element II). In other words, what are thiscompany’s methods for accounting for receivables and evaluating uncollectible receivables? What types of fixed assets are acquired, and what methods arepreferred for debt financing? How do those affect how financial information is communicated?Specifically, the following critical elements must be addressed:II. Horizontal and Vertical Analysis: In this section, you will conduct horizontal and vertical analyses for the balance sheet and income statement accountsand report any significant observations for a two-year period. You should include a table of your calculations as an appendix to your analysis. Include allcalculations in an Excel document. Specifically discuss the following categories:Accounts Receivable:Use basic financial analysis to examine any horizontal changes in Starbucks’ accounts receivable balances over time.Use basic financial analysis to examine any vertical changes in Starbucks’ accounts receivable balances over time.Analyze how Starbucks’ methods for accounting for receivables and evaluating uncollectible receivables impact the recording process andpresentation of financial statements. In other words, what are this company’s methods for accounting for receivables and evaluatinguncollectible receivables, and how do those affect how financial information is communicated?Asset Acquisition, Depreciation, and Amortization:Use basic financial analysis to examine any horizontal changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortizationover time.Use basic financial analysis to examine any vertical changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortizationover time.Analyze Starbucks’ methods for fixed asset and intangible asset acquisitions as well as depreciation and amortization, including assetcategorization. How do these methods affect the balance sheet, income statement, and statement of cash flows?Debt FinancingUse basic financial analysis to examine any horizontal changes in Starbucks’ short- and long-term debt over time.Use basic financial analysis to examine any vertical changes in Starbucks’ short- and long-term debt over time.Analyze Starbucks’ method of debt financing. In your analysis, you should address both current and long-term liabilities, including theissuance of bonds.RubricGuidelines for Submission: Milestone One should adhere to the following formatting requirements: 2–3 pages (not including cover page or appendix), double-spaced, using 12-point Times New Roman font and the most current guidelines for APA formatting. Include all calculations in an Excel document.Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information,review these instructions.Critical ElementsProficient (100%)Needs Improvement (75%)Not Evident (0%)ValueAnalysis: Accounts:HorizontalUses basic financial analysis toexamine any horizontal changes inStarbucks’ accounts receivablebalances over timeUses basic financial analysis toexamine any horizontal changes inStarbucks’ accounts receivablebalances over time, but with gaps inaccuracy or relevant detailDoes not use basic financial analysisto examine any horizontal changes inStarbucks’ accounts receivablebalances over time10Analysis: Accounts:VerticalUses basic financial analysis toexamine any vertical changes inStarbucks’ accounts receivablebalances over timeUses basic financial analysis toexamine any vertical changes inStarbucks’ accounts receivablebalances over time, but with gaps inaccuracy or relevant detailDoes not use basic financial analysisto examine any vertical changes inStarbucks’ accounts receivablebalances over time10Analysis: Accounts:MethodsAnalyzes how Starbucks’ methods foraccounting for receivables andevaluating uncollectible receivablesimpact the recording process andfinancial statement presentationAnalyzes how Starbucks’ methods foraccounting for receivables andevaluating uncollectible receivablesimpact the recording process andfinancial statement presentation, butwith gaps in logic or detailDoes not analyze how Starbucks’methods for accounting forreceivables and evaluatinguncollectible receivables impact therecording process and financialstatement presentation10Analysis: Asset:HorizontalUses basic financial analysis toexamine any horizontal changes inStarbucks’ fixed assets, intangibleassets, depreciation, andamortization over timeUses basic financial analysis toexamine any horizontal changes inStarbucks’ fixed assets, intangibleassets, depreciation, andamortization over time, but with gapsin accuracy or relevant detailDoes not use basic financial analysisto examine any horizontal changes inStarbucks’ fixed assets, intangibleassets, depreciation, andamortization over time10Analysis: Asset: VerticalUses basic financial analysis toexamine any vertical changes inStarbucks’ fixed assets, intangibleassets, depreciation, andamortization over timeUses basic financial analysis toexamine any vertical changes inStarbucks’ fixed assets, intangibleassets, depreciation, andamortization over time, but with gapsin accuracy or relevant detailDoes not use basic financial analysisto examine any vertical changes inStarbucks’ fixed assets, intangibleassets, depreciation, andamortization over time10Analysis: Asset:MethodsAnalyzes Starbucks’ methods for fixedasset and intangible assetacquisitions as well as depreciationand amortization for how they affectthe balance sheet, income statement,and statement of cash flowsAnalyzes Starbucks’ methods for fixedasset and intangible assetacquisitions as well as depreciationand amortization for how they affectthe balance sheet, income statement,and statement of cash flows, but withgaps in logic or detailDoes not analyze Starbucks’ methodsfor fixed asset and intangible assetacquisitions as well as depreciationand amortization for how they affectthe balance sheet, income statement,and statement of cash flows10Analysis: Debt:HorizontalUses basic financial analysis toexamine any horizontal changes inStarbucks’ short- and long-term debtover timeUses basic financial analysis toexamine any horizontal changes inStarbucks’ short- and long-term debtover time, but with gaps in accuracyor relevant detailDoes not use basic financial analysisto examine any horizontal changes inStarbucks’ short- and long-term debtover time10Analysis: Debt: VerticalUses basic financial analysis toexamine any vertical changes inStarbucks’ short- and long-term debtover timeUses basic financial analysis toexamine any vertical changes inStarbucks’ short- and long-term debtover time, but with gaps in accuracyor relevant detailDoes not use basic financial analysisto examine any vertical changes inStarbucks’ short- and long-term debtover time10Analysis: Debt: MethodAnalyzes Starbucks’ method of debtfinancing, addressing current andlong-term liabilities and the issuanceof bondsAnalyzes Starbucks’ method of debtfinancing, addressing current andlong-term liabilities and the issuanceof bonds, but with gaps in logic ordetailDoes not analyze Starbucks’ methodof debt financing, addressing currentand long-term liabilities and theissuance of bonds10Articulation of ResponseSubmission has no major errorsrelated to citations, grammar,spelling, syntax, or organizationSubmission has major errors relatedto citations, grammar, spelling,syntax, or organization thatnegatively impact readability andarticulation of main ideaSubmission has critical errors relatedto citations, grammar, spelling,syntax, or organization that preventunderstanding of ideas10Total100%