Question
Directions: Item 1 is to be completed in Excel, following the instructions below. Note that Excel formulas must be used for all computations. Credit cannot
Directions:
- Item 1 is to be completed in Excel, following the instructions below. Note that Excel formulas must be used for all computations. Credit cannot be awarded for manually-entered amounts.
- For items 2 through 10, enter your responses into this document, directly under each question. Referenced financial information can be found in the StarbucksFinancials PDF.
- Present your answers in complete, well-constructed sentences, and be concise and to the point in your responses
1. Follow directions on p. 1-27 in textbook, or on the last few slides in the Module 1 PPT to download Starbucks income statement and balance sheet for fiscal 2013 (the year ended September 29, 2013). Financial statements for public companies are reported to shareholders in their annual reports, also called Form 10-K.
Use the downloaded Excel spreadsheets to construct common-size income statements (Starbucks calls them statements of earnings) and balance sheets for both 2013 and 2012. (Information for both years will be found on the fiscal 2013 statements.)
Common-size income statements scale each income statement line item by total net revenues (sales).
Common-size balance sheets are created by dividing each figure on a given years balance sheet by that years total assets, thereby creating a balance sheet on a percent of assets basis. Note that event liability and stockholders equity items are to be presented/computed on a percent of assets basis.
Refer to the fiscal 2013 balance sheet (for the year ended September 29, 2013) to respond to the following items.
2. (a) Write out the Accounting Equation and (b) demonstrate that the accounting equation holds true for Starbucks.
3. Using the common-size information you computed, (a) identify Starbucks major assets and list them below. (b) Explain how you identified the major assets. (c) Why are these major assets appropriate for a company like Starbucks?
4. Explain, in your own words, (a) intangible assets and (b) goodwill. (c) What specific intangible assets might Starbucks have?
5. Show relevant computations. (a) How is Starbucks financed? (b) What proportion of total financing comes from non-owners for fiscal 2013? For fiscal 2012? (c) Explain why the financing side of Starbucks balance changed from fiscal 2012 to fiscal 2013.
Refer to the fiscal 2013 statement of earnings (for the year ended September 29, 2013) to respond to the following items.
6. Review the revenue recognition policies of Starbucks discussed in Note 1 (Summary of Significant Accounting Policies). (a) Does Starbucks record revenue when they receive cash from customers? (b) How does Starbucks record revenue on stored value cards (gift cards)? (c) What significant judgments does management need to make in order to measure and record sales revenue at Starbucks? (d) Briefly explain the concept of accrual accounting as it relates to revenue recognition. Provide one relevant example from Starbucks Note 1.
7. Using the common-size information you computed in the common-size statement of earnings (a) Identify Starbucks major expenses and list them below. (b) Explain how you identified the major expenses. (c) Explain any changes in cost structure that you observe from fiscal 2012 to fiscal 2013.
8. Regarding Starbucks large litigation charge in fiscal 2013, (a) explain why Starbucks included this as part of operating income. (b) why do you think Starbucks reported the charge as a separate line item rather than include it in total general and administrative expenses?
9. Was Starbucks profitable in fiscal 2013? In fiscal 2012? Explain your definition of profitable.
Refer to the fiscal 2013 statement of cash flows (for the year ended September 29, 2013) to respond to the following items.
10. (a) In general, explain why Starbucks net earnings would be different from net cash provided by operating activities. (b) How much cash did Starbucks use during fiscal 2013 for expenditures for property, plant and equipment? (c) What amount of dividends did Starbucks pay during fiscal 2013? (d) Why does the amount of dividends paid during the year differ from the amount of dividends declared as show in the statement of equity?
Please send me your email so I can send you the balance sheet it is 15 pages long.
Step 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