Submit both a horizontal and vertical analysis of starbucks accounts receivable, fixed assets and debt financing

Anonymous
timer Asked: Jun 2nd, 2018
account_balance_wallet $70

Question description

submit both a horizontal and vertical analysis of Starbucks' accounts receivable, fixed assets, and debt financing.Access the most current annual report (10-K).

https://www.sec.gov/Archives/edgar/data/829224/000...

QUESTION Submit both a horizontal and vertical analysis of Starbucks' accounts receivable, fixed assets, and debt financing. Please be sure that you access the most current annual report (10-K), LINK GIVEN ABOVE

also here is some helpful information.

Starbuck's presents A/R net of allowance for doubtful accounts - which is the contra asset that reduces A/R to Net Realizable value. This is the reserve for bad debt which is an estimate to accrue for potential bad debt expense on the Income Statement.

A/R is discussed in Starbuck's 10k in Note 1: Summary of Significant Accounting Policies Under the heading "Receivables, net of Allowance for Doubtful Accounts". Since A/R is presented net of the allowance for doubtful, you will have to refer to the footnote disclosure regarding the amount. It states that the 2017 amount was $9.8 million and the 2016 amount was $9.4 million.

Net A/R for 2017 is $870.4M and 2016 is $768.8M. To get gross A/R (since it is presented net of allowance for doubtful) we will need to add bad the allowance for doubtful figure.

A/R 2017 = $880.2M gross + ($9.8M Allowance for doubtful) = $870.4M Net A/R

A/R 2015 = $729.8M gross + ($10.8M Allowance for doubtful) = $719.0M Net A/R

Remember that the allowance for doubtful reserve is an estimate of expected bad debt and non -collectible A/R. It has increased from 2017 to 2016. Revenues have also increased from 2017 to 2016!

MBA 503 Final Project Guidelines and Rubric Overview There are two summative assessments for this course. For your first assessment, you will be objectively assessed by your completion of a series of MyAccountingLab homework assignments throughout the course. These will measure your understanding of how to communicate the financial performance of companies and how to prepare basic financial statements. For your final project, you will complete a financial analysis of a particular company’s financial statements. You will assume the role of an analyst in a fictional company that is looking to glean what it can from the methods and business decisions used at this company. In determining the overall financial health of the company, you will demonstrate an understanding of both the financial calculations that go into financial statements as well as the meaning behind the numbers. Basic accounting skills and knowledge are critical to effective management in today’s business environment. Future business leaders need an understanding of the process and rules related to creating financial accounting statements and the meanings behind their individual components in order to make informed business decisions. To demonstrate these skills, you will need to analyze this accounting information in terms of a company’s performance and financial health within its industry. This will ultimately help develop your skills as a business leader who is better prepared to manage effectively and make informed management decisions. This final project addresses the following course outcomes:    Analyze the financial condition of companies by accurately interpreting basic financial information used for informing business decisions Determine the importance of accounting regulations and reporting requirements in the preparation of financial reports Conduct basic financial analysis that accurately utilizes horizontal, vertical, and ratio techniques to determine the overall financial health of companies The 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 milestones will be submitted in Modules Four, Six, and Eight. Your final submission, the financial analysis, will be submitted in Module Ten. 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 calculations as an appendix to your analysis. Include all calculations in an Excel document. Specifically discuss the following categories: A. Accounts Receivable: 1. Use basic financial analysis to examine any horizontal changes in Starbucks’ accounts receivable balances over time. 2. Use basic financial analysis to examine any vertical changes in Starbucks’ accounts receivable balances over time. 3. Analyze how Starbucks’ methods for accounting for receivables and evaluating uncollectible receivables impact the recording process and presentation of financial statements. In other words, what are this company’s methods for accounting for receivables and evaluating uncollectible receivables, and how do those affect how financial information is communicated? B. Asset Acquisition, Depreciation, and Amortization: 1. Use basic financial analysis to examine any horizontal changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortization over time. 2. Use basic financial analysis to examine any vertical changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortization over time. 3. Analyze Starbucks’ methods for fixed asset and intangible asset acquisitions as well as depreciation and amortization, including asset categorization. How do these methods affect the balance sheet, income statement, and statement of cash flows? C. Debt Financing 1. Use basic financial analysis to examine any horizontal changes in Starbucks’ short- and long-term debt over time. 2. Use basic financial analysis to examine any vertical changes in Starbucks’ short- and long-term debt over time. 3. Analyze Starbucks’ method of debt financing. In your analysis, you should address both current and long-term liabilities, including the issuance of bonds. III. Ratio Analysis: Analyze and discuss the financial performance of Starbucks using financial ratios. Include your calculations and amounts in a table in the appendix of your paper. Be sure to show your calculation for each ratio. A. Liquidity Ratios 1. Accurately present and calculate two liquidity ratios for Starbucks. 2. Discuss what the liquidity ratios reveal about Starbucks, including any description of benchmarks, standard measurements, or other types of analysis used once the ratio amount is known. B. Solvency Ratios 1. Accurately present and calculate two solvency ratios for Starbucks. 2. Discuss what the solvency ratios reveal about the company, including any description of benchmarks, standard measurements, or other types of analysis used once the ratio amounts are known. C. Profitability Ratios 1. Accurately present and calculate two profitability ratios for Starbucks. 2. Discuss what the profitability ratios reveal about the company, including any description of benchmarks, standard measurements, or other types of analysis used once the ratio amounts are known. IV. Rules of Financial Reporting: Consider the following governmental and GAAP reporting requirements for what is mandated that Starbucks include in its financial statements: A. Why is the reporting of control procedures required, and what information is disclosed about Starbucks’ control procedures? Justify your response. B. Why is the reporting of segment information required, and what information is disclosed about Starbucks’ segment information? Justify your response. C. Why is the reporting of estimates and assumptions required, and what information is disclosed about Starbucks’ reporting of estimates and assumptions? Justify your response. D. Why is the reporting of investments and fair value required, and what information is disclosed about Starbucks’ investments and fair value reporting? Justify your response. E. Why is the reporting of leases required, and what information is disclosed about Starbucks’ lease structure? Justify your response. V. Conclusion: Provide a concise, professional conclusion to your executive detailing the findings of your analysis. What can you learn from Starbucks’ financial statements and performance about determining the overall health of companies? Include general suggestions for financial improvements. Milestones 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, and methods 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. Milestone Two: Ratio Analysis In Module Six, you will submit the Ratio Analysis portion of the final project. For this milestone, you will be analyzing the financial performance of Starbucks using the financial ratios of liquidity, solvency, and profitability (Critical Element III). Include your calculations and amounts in a table in the appendix of your paper. Be sure to show your calculations for each ratio. You will also discuss what each ratio and ratio category tells the user about the financial health of the company, including stating appropriate methods for comparison such as benchmarking and trend analysis. Your analysis should be in the form of a 2–3-page paper. Include all calculations in an Excel document. Note: To calculate the ratio amounts you may use the document Key Financial Ratios Explained and Set Up in Excel. This Excel document may also be used for your final project. This milestone is graded with the Milestone Two Rubric. Milestone Three: Rules of Financial Reporting In Module Eight, you will submit the Rules of Financial Reporting component of your financial analysis (Critical Element IV). In this milestone, you will consider the following governmental and GAAP reporting requirements for what is mandated that Starbucks include in its financial statements: Why is the reporting of control procedures required, and what information is disclosed about Starbucks’ control procedures? Why is the reporting of segment information required, and what information is disclosed about Starbucks’ segment information? Why is the reporting of estimates and assumptions required, and what information is disclosed about Starbucks’ reporting of estimates and assumptions? Why is the reporting of investments and fair value required, and what information is disclosed about Starbucks’ investments and fair value reporting? And last: Why is the reporting of leases required, and what information is disclosed about Starbucks’ lease structure? Justify your response to each question. This milestone should be submitted as a 2–3-page paper. This milestone is graded with the Milestone Three Rubric. Final Submission: Financial Analysis In Module Ten, you will submit your 10–12-page final financial analysis. It should be a complete, polished artifact containing all of the critical elements of the final project, including the Introduction (Critical Element I), which will be a concise, professional introduction explaining the purpose of your analysis to your executive, and the Conclusion (Critical Element V), which will be a concise, professional conclusion to your executive detailing the findings of your analysis. Your conclusion should also answer the following question: What can you learn from Starbucks’ financial statements and performance about determining the overall health of companies? Include general suggestions for financial improvements. Your financial analysis should reflect the incorporation of feedback gained throughout the course. This final submission will be graded using the Final Project Rubric. Deliverables Milestone One Two Three Deliverable Horizontal and Vertical Analysis: Accounts Receivable, Fixed Assets and Debt Financing Ratio Analysis Rules of Financial Reporting Final Submission: Financial Analysis Module Due Four Grading Graded separately; Milestone One Rubric Six Graded separately; Milestone Two Rubric Eight Graded separately; Milestone Three Rubric Ten Graded separately; Final Project Rubric Final Project Rubric Guidelines for Submission: Your financial analysis should adhere to the following formatting requirements: 10–12 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. Critical Elements Introduction Exemplary (100%) Meets “Proficient” criteria, and explanation expertly balances key detail with brevity for corporate audience Proficient (90%) Provides a concise introduction explaining the purposes of analysis for a corporate audience Analysis: Accounts: Horizontal Meets “Proficient” criteria and demonstrates a nuanced understanding of how to interpret horizontal changes in accounts receivable balances over time Meets “Proficient” criteria and demonstrates a nuanced understanding of how to interpret vertical changes in accounts receivable balances over time Meets “Proficient” criteria and demonstrates a nuanced understanding of how financial methods impact the recording process and presentation of financial statements Uses basic financial analysis to examine any horizontal changes in Starbucks’ accounts receivable balances over time Meets “Proficient” criteria and demonstrates a nuanced understanding of how to interpret horizontal changes in fixed assets, intangible assets, depreciation, and amortization over time Uses basic financial analysis to examine any horizontal changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortization over time Analysis: Accounts: Vertical Analysis: Accounts: Methods Analysis: Asset: Horizontal Uses basic financial analysis to examine any vertical changes in Starbucks’ accounts receivable balances over time Analyzes how Starbucks’ methods for accounting for receivables and evaluating uncollectible receivables impact the recording process and financial statement presentation Needs Improvement (70%) Provides an introduction explaining the purposes of analysis for a corporate audience, but presentation is not concise or is missing key details Uses basic financial analysis to examine any horizontal changes in Starbucks’ accounts receivable balances over time, but with gaps in accuracy or relevant detail Uses basic financial analysis to examine any vertical changes in Starbucks’ accounts receivable balances over time, but with gaps in accuracy or relevant detail Analyzes how Starbucks’ methods for accounting for receivables and evaluating uncollectible receivables impact the recording process and financial statement presentation, but with gaps in logic or detail Uses basic financial analysis to examine any horizontal changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortization over time, but with gaps in accuracy or relevant detail Not Evident (0%) Does not provide an introduction explaining the purposes of analysis for a corporate audience Value 5.5 Does not use basic financial analysis to examine any horizontal changes in Starbucks’ accounts receivable balances over time 3.5 Does not use basic financial analysis to examine any vertical changes in Starbucks’ accounts receivable balances over time 3.5 Does not analyze how Starbucks’ methods for accounting for receivables and evaluating uncollectible receivables impact the recording process and financial statement presentation 4 Does not use basic financial analysis to examine any horizontal changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortization over time 3.5 Analysis: Asset: Vertical Analysis: Asset: Methods Analysis: Debt: Horizontal Analysis: Debt: Vertical Analysis: Debt: Method Ratio: Liquidity: Calculate Meets “Proficient” criteria and demonstrates a nuanced understanding of how to interpret vertical changes in fixed assets, intangible assets, depreciation, and amortization over time Meets “Proficient” criteria and demonstrates a nuanced understanding of how financial methods impact the balance sheet, income statement, and statement of cash flows Uses basic financial analysis to examine any vertical changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortization over time Meets “Proficient” criteria and demonstrates a nuanced understanding of how to interpret horizontal changes in short- and long-term debt over time Meets “Proficient” criteria and demonstrates a nuanced understanding of how to interpret vertical changes in short- and long-term debt over time Meets “Proficient” criteria and demonstrates a nuanced understanding of how financial methods impact financial statements Meets “Proficient” criteria and demonstrates a nuanced understanding of ratio techniques used for financial analysis Uses basic financial analysis to examine any horizontal changes in Starbucks’ short- and longterm debt over time Analyzes Starbucks’ methods for fixed asset and intangible asset acquisitions as well as depreciation and amortization for how they affect the balance sheet, income statement, and statement of cash flows Uses basic financial analysis to examine any vertical changes in Starbucks’ short- and long-term debt over time Analyzes Starbucks’ method of debt financing, addressing current and long-term liabilities and the issuance of bonds Accurately presents and calculates two liquidity ratios for Starbucks Uses basic financial analysis to examine any vertical changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortization over time, but with gaps in accuracy or relevant detail Analyzes Starbucks’ methods for fixed asset and intangible asset acquisitions as well as depreciation and amortization for how they affect the balance sheet, income statement, and statement of cash flows, but with gaps in logic or detail Uses basic financial analysis to examine any horizontal changes in Starbucks’ short- and longterm debt over time, but with gaps in accuracy or relevant detail Uses basic financial analysis to examine any vertical changes in Starbucks’ short- and long-term debt over time, but with gaps in accuracy or relevant detail Does not use basic financial analysis to examine any vertical changes in Starbucks’ fixed assets, intangible assets, depreciation, and amortization over time 3.5 Does not analyze Starbucks’ methods for fixed asset and intangible asset acquisitions as well as depreciation and amortization for how they affect the balance sheet, income statement, and statement of cash flows Does not use basic financial analysis to examine any horizontal changes in Starbucks’ short- and long-term debt over time 4 Does not use basic financial analysis to examine any vertical changes in Starbucks’ short- and long-term debt over time 3.5 Analyzes Starbucks’ method of debt financing, addressing current and long-term liabilities and the issuance of bonds, but with gaps in logic or detail Presents and calculates two liquidity ratios for Starbucks, but with gaps in accuracy, or chosen ratios are not appropriate Does not analyze Starbucks’ method of debt financing, addressing current and longterm liabilities and the issuance of bonds Does not present and calculate two liquidity ratios for Starbucks 4 3.5 3.5 Ratio: Liquidity: Discuss Ratio: Solvency: Calculate Ratio: Solvency: Discuss Ratio: Profitability: Calculate Ratio: Profitability: Discuss Rules: Control Procedures Meets “Proficient” criteria and demonstrates a nuanced understanding of what is revealed about the financial condition of companies through key ratios Meets “Proficient” criteria and demonstrates a nuanced understanding of ratio techniques used for financial analysis Meets “Proficient” criteria and demonstrates a nuanced understanding of what is revealed about the financial condition of companies through key ratios Meets “Proficient” criteria and demonstrates a nuanced understanding of ratio techniques used for financial analysis Meets “Proficient” criteria and demonstrates a nuanced understanding of what is revealed about the financial condition of companies through key ratios Meets “Proficient” criteria, and justification demonstrates a nuanced understanding of the importance of rules and regulations in accounting to financial reporting Comprehensively discusses what liquidity ratios reveal about Starbucks Discusses what liquidity ratios reveal about Starbucks, but with gaps in logic or detail Does not discuss what liquidity ratios reveal about Starbucks 4 Accurately presents and calculates two solvency ratios for Starbucks Presents and calculates two solvency ratios for Starbucks, but with gaps in accuracy, or chosen ratios are not appropriate Discusses what solvency ratios reveal about Starbucks, but with gaps in logic or detail Does not present and calculate two solvency ratios for Starbucks 3.5 Does not discuss what solvency ratios reveal about Starbucks 4 Presents and calculates two profitability ratios for Starbucks, but with gaps in accuracy, or chosen ratios are not appropriate Discusses what profitability ratios reveal about Starbucks, but with gaps in logic or detail Does not present and calculate two profitability ratios for Starbucks 3.5 Does not discuss what profitability ratios reveal about Starbucks 4 Determines why reporting of control procedures is required and what information is disclosed, justifying response, but determination contains inaccuracies or justification is lacking in logic or key details Does not determine why reporting of control procedures is required and what information is disclosed, justifying response 6 Comprehensively discusses what solvency ratios reveal about Starbucks Accurately presents and calculates two profitability ratios for Starbucks Comprehensively discusses what profitability ratios reveal about Starbucks Determines why reporting of control procedures is required and what information is disclosed, justifying response Rules: Segment Information Meets “Proficient” criteria, and justification demonstrates a nuanced understanding of the importance of rules and regulations in accounting to financial reporting Determines why reporting of segment information is required and what information is disclosed, justifying response Rules: Estimates Meets “Proficient” criteria, and justification demonstrates a nuanced understanding of the importance of rules and regulations in accounting to financial reporting Determines why reporting of estimates and assumptions is required and what information is disclosed, justifying response Rules: Investments and Fair Value Meets “Proficient” criteria, and justification demonstrates a nuanced understanding of the importance of rules and regulations in accounting to financial reporting Determines why reporting of investments and fair value is required and what information is disclosed, justifying response Rules: Leases Meets “Proficient” criteria and justification demonstrates a nuanced understanding of the importance of rules and regulations in accounting to financial reporting Determines why reporting of leases is required and what information is disclosed, justifying response Meets “Proficient” criteria and demonstrates a nuanced understanding of how financial analysis leads to determinations of the overall financial health of companies Provides a concise, professional conclusion detailing what can be learned from Starbucks’ financial statements and performance based on financial analysis Conclusion Determines why reporting of segment information is required and what information is disclosed, justifying response, but determination contains inaccuracies or justification is lacking in logic or key details Determines why reporting of estimates and assumptions is required and what information is disclosed, justifying response, but determination contains inaccuracies or justification is lacking in logic or key details Determines why reporting of investments and fair value is required and what information is disclosed, justifying response, but determination contains inaccuracies or justification is lacking in logic or key details Determines why reporting of leases is required and what information is disclosed, justifying response, but determination contains inaccuracies or justification is lacking in logic or key details Provides a conclusion detailing what can be learned from Starbucks’ financial statements and performance based on financial analysis, but is lacking key details or is not concise or professional Does not determine why reporting of segment information is required and what information is disclosed, justifying response 6 Does not determine why reporting of estimates and assumptions is required and what information is disclosed, justifying response 6 Does not determine why reporting of investments and fair value is required and what information is disclosed, justifying response 6 Does not determine why reporting of leases is required and what information is disclosed, justifying response 6 Does not provide a conclusion detailing what can be learned from Starbucks’ financial statements and performance based on financial analysis 4 Articulation of Response Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy-to-read format Submission has no major errors related to citations, grammar, spelling, syntax, or organization Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas Total 5 100%

Tutor Answer

Emilyprofessor
School: Duke University

flag Report DMCA
Review

Anonymous
Wow this is really good.... didn't expect it. Sweet!!!!

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors