Question

Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...

Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet
Following are the income statements and balance sheets of Amazon.com Inc.

AMAZON.COM INC.
Consolidated Statement of Operations
$ millions Dec. 31, 2015 Dec. 31, 2014
Net product sales $79,268 $70,080
Net service sales 27,738 18,908
Total net sales 107,006 88,988
Operating expenses
Cost of sales 71,651 62,752
Fulfillment 13,410 10,766
Marketing 5,254 4,332
Technology and content 12,540 9,275
General and administrative 1,747 1,552
Other operating expense (income), net 171 133
Total operating expenses 104,773 88,810
Income from operations 2,233 178
Interest income 50 39
Interest expense (459) (210)
Other income (expense), net (256) (118)
Total non-operating (expense) (665) (289)
Income (loss) before income taxes 1,568 (111)
Provision for income taxes (950) (167)
Equity-method investment activity, net of tax (22) 37
Net income (loss) $596 $(241)
AMAZON.COM INC.
Consolidated Balance Sheets
In millions, except par value Dec. 31, 2015 Dec. 31, 2014
Current Assets
Cash and cash equivalents $15,890 $14,557
Marketable securities 3,918 2,859
Inventories 10,243 8,299
Accounts receivable, net and other 6,423 5,612
Total current assets 36,474 31,327
Property and equipment, net 21,838 16,967
Goodwill 3,759 3,319
Other assets 3,373 2,892
Total assets $65,444 $54,505
Current Liabilities
Accounts payable $20,397 $16,459
Accrued expenses and other 10,384 9,807
Unearned revenue 3,118 1,823
Total current liabilities 33,899 28,089
Long-term debt 8,235 8,265
Other long-term liabilities 9,926 7,410
Stockholders' equity
Preferred stock, $0.01 par value: Authorized shares-500
Issued and outstanding shares-none 0 0
Common stock, $0.01 par value: Authorized shares-5,000
Issued shares-494 and 488 Outstanding shares-471 and 465 5 5
Treasury stock, at cost (1,837) (1,837)
Additional paid-in capital 13,394 11,135
Accumulated other comprehensive loss (723) (511)
Retained earnings 2,545 1,949
Total stockholders' equity 13,384 10,741
Total liabilities and shareholders' equity $65,444 $54,505


Forecast Amazon's 2016 income statement using the forecast assumptions, which are expressed as a percentage of total net sales unless otherwise indicated ($ in millions).

Net product sales growth 15%
Net service sales growth 40%
Cost of sales 67.0%
Fulfillment 12.5%
Marketing 4.9%
Technology and content 11.7%
General and administrative 1.6%
Interest income $60
Interest expense $520
Income tax expense (% pretax income) 38%
  • Forecast no change in the following income statement accounts: Other operating expense, net, Other expense, net; and Equity method investment activity.
  • Do not use negative signs with any of your answers in the income statement.

AMAZON.COM INC.
Forecated Income Statement
$ millions 2016
Net product sales 91,158
Net service sales 38833
Total net sales 129991
Operating expenses
Cost of sales 87094
Fulfillment 16249
Marketing 6370
Technology and content 15209
General and administrative 2080
Other operating expense, net 171
Total operating expenses 127173
Income from operations 2818
Interest income 60
Interest expense -520
Otherexpense, net -256
Total non-operating income -716
Income (loss) before income taxes 2102
Provision for income taxes -799
Equity-method investment activity, net of tax -22
Net income (loss) 1281


Forecast Amazon's 2016 balance sheet using the forecast assumptions, which are expressed as a percentage of total net sales unless otherwise indicated ($ in millions).

Inventories 9.6%
Accounts receivable, net and other 6.0%
Other assets 3.2%
Accounts payable 19.1%
Accrued expenses and other 9.7%
Unearned revenue 2.9%
Other long-term liabilities 9.3%
  • Forecast no change in the following balance sheet accouts: Marketable securities, Goodwill, Preferred stock, Common stock, Treasury stock, APIC, and AOCL.
  • Assume that in 2016, CAPEX will be 4.3% of Sales and depreciation expense will be 28.9% of the PPE balance at the start of the year.
  • The company will repay $238 million of long-term debt in 2016.
  • The company pays no dividends.
  • Round answers to the nearest whole number.

  • Do not use negative signs with any of your answers in the balance sheet.
AMAZON.COM INC.
Forecasted Balance Sheet
in millions 2016
Current Assets
Cash and cash equivalents Answer
Marketable securities Answer
Inventories Answer
Accounts receivable, net and other Answer
Total current assets Answer
Property and equipment, net Answer
Goodwill Answer
Other assets Answer
Total assets Answer
Current Liabilities
Accounts payable Answer
Accrued expenses and other Answer
Unearned revenue Answer
Total current liabilities Answer
Long-term debt Answer
Other long-term liabilities Answer
Total liabilities Answer
Stockholders' equity
Preferred stock, $0.01 par value: Authorized shares-500
Issued and outstanding shares-none Answer
Common stock, $0.01 par value: Authorized shares-5,000
Issued shares-494 and 488 Outstanding shares-471 and 465 Answer
Treasury stock, at cost Answer
Additional paid-in capital Answer
Accumulated other comprehensive loss Answer
Retained earnings Answer
Total stockholders' equity Answer
Total liabilities and shareholders' equity Answer

b. What does the forecasted adjustment to balance the accounting equation from part a reveal to us about the forecasted cash balance and related financing needs of the company? Explain. Check and choose the best answer:

- Amazon will generate sufficient cash for the coming year. The cash balance decreases fairly significantly, we could adjust marketable securities, increasing total assets.

- Amazon will generate sufficient cash for the coming year. The cash balance increases fairly significantly, we could adjust marketable securities, leaving total assets unchanged.

- Amazon will not generate sufficient cash for the coming year. The cash balance decreases fairly significantly, we could adjust marketable securities, leaving total assets unchanged.

- Amazon will not generate sufficient cash for the coming year. The cash balance decreases fairly significantly, we could adjust short-term debt, increasing total assets unchanged.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of Amazon.com Inc. AMAZON.COM INC. Consolidated Statement of Operations $ millions Dec. 31, 2015 Dec. 31, 2014 Net product sales $79,268 $70,080 Net service sales 27,738 18,908 Total net sales 107,006 88,988 Operating expenses Cost of sales 71,651 62,752 Fulfillment 13,410 10,766 Marketing 5,254 4,332 Technology and content 12,540 9,275 General and administrative 1,747 1,552 Other operating expense (income), net 171 133...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement, Fiscal Years Ended ($ millions) May 29, 2011 May 30, 2010 Net Sales $ 14,880.2 $ 14,635.6 Cost of sales 8,926.7 8,835.4 Selling, general and administrative expenses 3,192.0 3,162.7 Divestitures (gain), net (17.4) -- Restructuring, impairment, and other exit costs 4.4 31.4 Operating income 2,774.5 2,606.1 Interest, net 346.3 401.6 Earnings before income tax expense and...
Forecast the Statement of Cash Flows The following are the income statements and balance sheets of...
Forecast the Statement of Cash Flows The following are the income statements and balance sheets of Amazon.com Inc.   AMAZON.COM INC. Consolidated Statement of Operations $ millions 2016 Estimated Dec. 31, 2015 Net product sales $91,158 $79,268 Net service sales 38,833 27,738 Total net sales 129,991 107,006 Operating expenses Cost of sales 87,094 71,651 Fulfillment 16,249 13,410 Marketing 6,370 5,254 Technology and content 15,209 12,540 General and administrative 2,080 1,747 Other operating expense (income), net 171 171 Total operating expenses 127,173...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for...
The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2016. INCOME STATEMENT OF QUICK BURGER CORP., 2016 (Figures in $ millions) Net sales $ 27,584 Costs 17,586 Depreciation 1,419 Earnings before interest and taxes (EBIT) $ 8,579 Interest expense 534 Pretax income 8,045 Taxes 2,816 Net income $ 5,229 BALANCE SHEET OF QUICK BURGER CORP., 2016 (Figures in $ millions)   Assets 2016 2015 Liabilities and Shareholders' Equity 2016 2015 Current assets Current liabilities...
Operating Section of Statement of Cash Flows (Indirect Method) Following are the income statement and balance...
Operating Section of Statement of Cash Flows (Indirect Method) Following are the income statement and balance sheet for Nike Inc. for the year ended May 31, 2016, and a forecasted income statement and balance sheet for 2017. Nike Inc. Income Statement For Year Ended May 31 $ millions 2016 actual 2017 Est. Revenues $ 32,376 $ 34,319 Cost of sales 17,405 18,464 Gross profit 14,971 15,855 Demand creation expense 3,278 3,466 Operating overhead expense 7,191 7,619 Total selling and administrative...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco Sytems Consolidated Statements of Income Years Ended December ($ millions) July 30, 2016 July 25, 2015 Revenue Product $37,254 $37,750 Service 11,993 11,411 Total revenue 49,247 49,161 Cost of sales Product 14,161 15,377 Service 4,126 4,103 Total cost of sales 18,287 19,480 Gross margin 30,960 29,681 Operating expenses Research and development 6,296 6,207 Sales and marketing 9,619 9,821 General and administrative...
The following table shows an abbreviated income statement and balance sheet for McDonald's Corporation for 2012....
The following table shows an abbreviated income statement and balance sheet for McDonald's Corporation for 2012. INCOME STATEMENT OF MCDONALD’S CORP., 2012 (Figures in $ millions)   Net sales 27,572   Costs 17,574   Depreciation 1,407   Earnings before interest and taxes (EBIT) 8,591   Interest expense 522   Pretax income 8,069   Taxes 2,624   Net income 5,445 BALANCE SHEET OF MCDONALD’S CORP., 2012 (Figures in $ millions)   Assets 2012 2011 Liabilities and Shareholders' equity 2012 2011 Current assets Current liabilities   Cash and marketable securities 2,341 2,341...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco Sytems Consolidated Statements of Income Years Ended December ($ millions) July 30, 2016 July 25, 2015 Revenue Product $37,254 $37,750 Service 11,993 11,411 Total revenue 49,247 49,161 Cost of sales Product 14,161 15,377 Service 4,126 4,103 Total cost of sales 18,287 19,480 Gross margin 30,960 29,681 Operating expenses Research and development 6,296 6,207 Sales and marketing 9,619 9,821 General and administrative...
Following are the income statement and balance sheet items for Faison Corporation from the company’s books...
Following are the income statement and balance sheet items for Faison Corporation from the company’s books and records at the end of fiscal year-end 20x1: ($ millions) Contributed capital $1,702 Cost of sales 13,567 Cash 1,393 Long-term liabilities 3,719 Accounts receivable 2,662 Other current assets 604 Other long-term assets 2,079 Other current liabilities 1,299 Other operating expenses 1,212 Other non-operating expenses 161 Inventory 1,093 Accounts payable 2,595 Property, net 3,216 Retained earnings 1,209 Sales 16,463 Tax expense 256 Equity income,...
Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC....
Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income, net (373) Interest...