Question
Need help to do a proforma balance sheet and proforma income statement from a downloaded file (last 10Q from Starbucks). Assume the following: Sales will
Need help to do a proforma balance sheet and proforma income statement from a downloaded file (last 10Q from Starbucks). Assume the following: Sales will increase for the next quarter by the same percentage increase from the previous quarter to the last reported quarter. For example, if sales increased 8% from the last quarter to the current reported quarter, you will use 8% as the sales increase for your pro formas. Calculate the expenses to determine what will change and what will remain the same. Note: Not all costs are associated with the cost of sales. It will be up to you to determine which line items need to be increased and which ones need to be left alone. This will require you to distinguish between fixed and variable costs.
Revenues | $ 5,995.7 |
Cost of Goods and Services Sold | 1,997.7 |
Store operating expenses | 2,721.4 |
Other operating expenses | 95 |
Depreciation and amortization expenses | 356.3 |
General and administrative expenses | 406.5 |
Restructuring, Settlement and Impairment Provisions | (0.7) |
Total operating expenses | 5,576.2 |
Income from equity investees | 67.9 |
Operating income | 487.4 |
Gain (Loss) on Disposition of Business | 0 |
Interest income and other, net | 2 |
Interest expense | (99.2) |
Earnings before income taxes | 390.2 |
Income Tax Expense (Benefit) | 65.4 |
Net earnings including noncontrolling interests | 324.8 |
Net earnings/(loss) attributable to noncontrolling interests | (3.6) |
Net earnings attributable to Starbucks | $ 328.4 |
Earnings per share - basic | $ 0.28 |
Earnings per share - diluted | $ 0.28 |
Weighted average shares outstanding: | |
Basic | 1,171.8 |
Diluted | 1,180.7 |
Company-operated stores [Member] | |
Revenues | $ 4,766 |
Licensed stores [Member] | |
Revenues | 689.8 |
Product and Service, Other [Member] | |
Revenues | $ 539.9 |
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