17,355 16,538 Gross margin 11,715 11,148 Selling, general and administrative expenses 8,895 8,482 Impairments, store closing costs and (g

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

Forecast the Statement of Cash Flows

Following are the income statements and balance sheets of Macy's, Inc.

Consolidated Statement of Income,
Fiscal Years Ended ($ millions)
2014
Estimated
Feb. 2,
2013
Net sales $29,070 $27,686
Cost of goods sold 17,355 16,538
Gross margin 11,715 11,148
Selling, general and administrative expenses 8,895 8,482
Impairments, store closing costs and (gain) on sale of leases -- 5
Operating income 2,820 2,661
Interest Expense 425 425
Premuim on early retirement debt (loss) -- (137)
Interest income 3 3
Income before income taxes 2,398 2,102
Federal, state and local income tax expense 875 767
Net Income $1,523 $1,335

 

Consolidated Balance Sheets
(millions)
2014
Estimated
Feb. 2,
2013
Assets
Current Assets
Cash and cash equivalents $1,919 $1,836
Short-term investments 1,478 0
Receivables 378 371
Merchandise inventories 5,581 5,308
Prepaid expenses and other current assets 378 361
Total current assets 9,734 7,876
Property and equipment, gross 14,405 14,143
Less accumulated depreciaion 6,979 5,947
Property and equipment, net 7,426 8,196
Goodwill 3,743 3,743
Other intangible assets--net 561 561
Other assets 640 615
Total assets $22,104 $20,991
Liabilities and Shareholders Equity
Current Liabilities
Short-term debt (current portion of long-term debt) $144 $124
Merchandise accounts payable 1,657 1,579
Accounts payable and accrued liabilities 2,733 2,610
Income Taxes 378 355
Deferred income taxes 436 407
Total current liabilites $5,348 $5,075
Long-term debt 6,325 6,806
Deferred income taxes 1,308 1,238
Other liabilites 1,919 1,821
Shareholders' equity
Common stock (387.7 and 414.2 shares outstanding) 4 4
Additional paid-in capital 3,872 3,872
Accumulated Equity 6,261 5,108
Treasury Stock (2,002) (2,002)
Accumulated other comprehensive loss (931) (931)
Total shareholders' equity 7,204 6,051
Total liabilities and shareholders' equity $22,104 $20,991

 

CAPEX (Increase in gross Property and equipment)/Net sales 0.90%
Depreciation expense/Prior year gross PPE 7.30%
Dividends/Net income 24.30%
Long-term debt payments required in fiscal 2014 $461

 

Refer to the financial information above for Macy's, Inc. Prepare a forecast of its financial year 2014 statement of cash flows. 

Round all answers to the nearest whole number. Use negative signs with answers, when appropriate.

Macy's Forecasted Statement of Cash Flows
($ millions) 2014 Estimated
Net income
 
Add: depreciation
 
Change in Receivables
 
Change in Merchandise inventories
 
Change in Other prepaid expenses & other current assets
 
Change in Other long-term assets
 
Change in Merchandise accounts payable
 
Change in Accounts payable & accrued liabilities
 
Change in Income taxes
 
Change in Deferred income taxes
 
Change in Long-term deferred income taxes
 
Change in Other long-term liabilities
 
Net cash from operating activities
 
Capital expenditures
 
Increase in Short-term investments
 
Net cash from investing activities
 
Dividends
 
Payments of LT debt
 
Net cash from financing activities
 
Net change in cash
 
Beginning cash
 
Ending cash  

How do you get dividends and payments of long term debt?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education