Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For this assignment, due in Module Four, you will 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 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 companys 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?

image text in transcribed

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 companys 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.

2019 2018 $ 2,686.6 70.5 879.2 1,529.4 488.2 5,653.9 220.0 396.0 6,431.7 1,765.8 479.6 781.8 3,490.8 19,219.6 8,756.3 181.5 693.1 1,400.5 1,462.8 12,494.2 267.7 334.7 5,929.1 134.7 412.2 1,042.2 3,541.6 24,156.4 $ $ $ S ASSETS Current assets: Cash and cash equivalents Short-term investments Accounts receivable, net Inventories Prepaid expenses and other current assets Total current assets Long-term investments Equity investments Property, plant and equipment, net Deferred income taxes, net Other long-term assets Other intangible assets Goodwill TOTAL ASSETS LIABILITIES AND SHAREHOLDERS' EQUITY/(DEFICIT) Current liabilities: Accounts payable Accrued liabilities Accrued payroll and benefits Income taxes payable Stored value card liability and current portion of deferred revenue Current portion of long-term debt Total current liabilities Long-term debt Deferred revenue Other long-term liabilities Total liabilities Shareholders' equity/(deficit): Common stock ($0.001 par value) authorized, 2,400.0 shares; issued and outstanding, 1,184.6 and 1,309.1 shares, respectively Additional paid-in capital Retained earnings/(deficit) Accumulated other comprehensive loss Total shareholders' equity/(deficit) Noncontrolling interests Total equity/(deficit) TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY/(DEFICIT) 1,189.7 1,753.7 664.6 1,291.7 1,269.0 1,179.3 1,752.5 656.8 102.8 1,642.9 349.9 5,684.2 9,090.2 6,775.7 1,430.5 22,980.6 6,168.7 11,167.0 6,744.4 1,370.5 25,450.6 1.2 1.3 41.1 (5,771.2) (503.3) (6,232.2) 1.2 (6.231.0) 19,219.6 41.1 1,457.4 (330.3) 1,169.5 6.3 1,175.8 24,156.4 $ S 2019 2018 $ 2,686.6 70.5 879.2 1,529.4 488.2 5,653.9 220.0 396.0 6,431.7 1,765.8 479.6 781.8 3,490.8 19,219.6 8,756.3 181.5 693.1 1,400.5 1,462.8 12,494.2 267.7 334.7 5,929.1 134.7 412.2 1,042.2 3,541.6 24,156.4 $ $ $ S ASSETS Current assets: Cash and cash equivalents Short-term investments Accounts receivable, net Inventories Prepaid expenses and other current assets Total current assets Long-term investments Equity investments Property, plant and equipment, net Deferred income taxes, net Other long-term assets Other intangible assets Goodwill TOTAL ASSETS LIABILITIES AND SHAREHOLDERS' EQUITY/(DEFICIT) Current liabilities: Accounts payable Accrued liabilities Accrued payroll and benefits Income taxes payable Stored value card liability and current portion of deferred revenue Current portion of long-term debt Total current liabilities Long-term debt Deferred revenue Other long-term liabilities Total liabilities Shareholders' equity/(deficit): Common stock ($0.001 par value) authorized, 2,400.0 shares; issued and outstanding, 1,184.6 and 1,309.1 shares, respectively Additional paid-in capital Retained earnings/(deficit) Accumulated other comprehensive loss Total shareholders' equity/(deficit) Noncontrolling interests Total equity/(deficit) TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY/(DEFICIT) 1,189.7 1,753.7 664.6 1,291.7 1,269.0 1,179.3 1,752.5 656.8 102.8 1,642.9 349.9 5,684.2 9,090.2 6,775.7 1,430.5 22,980.6 6,168.7 11,167.0 6,744.4 1,370.5 25,450.6 1.2 1.3 41.1 (5,771.2) (503.3) (6,232.2) 1.2 (6.231.0) 19,219.6 41.1 1,457.4 (330.3) 1,169.5 6.3 1,175.8 24,156.4 $ S

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Committee Essentials

Authors: Curtis C. Verschoor

1st Edition

0471699594, 978-0471699590

More Books

Students also viewed these Accounting questions