Two-Year-Ahead Forecasting of Financial Statement Following are the financial statements of Target Corporation from its...
70.2K
Verified Solution
Link Copied!
Question
Accounting
Two-Year-Ahead Forecasting of Financial Statement Following are the financial statements of Target Corporation from its FY2015 annual report.
Target Corporation
Consolidated Statements of Operations
12 Months Ended
$millions
Jan. 30, 2016
Jan. 31, 2015
Feb. 01, 2014
Sales
73,785
72,618
71,279
Cost of sales
51,997
51,278
50,039
Gross margin
21,788
21,340
21,240
Selling, general and administrative expenses
14,665
14,676
14,465
Depreciation and amortization
2,213
2,129
1,996
Gain on sale
(620)
-
(319)
Earnings from continuing operations before interest expense & income taxes
5,530
4,535
5,170
Net interest expense
607
882
1,049
Earnings from continuing operations before income taxes
4,923
3,653
4,121
Provision for income taxes
1,602
1,204
1,427
Net earnings from continuing operations
3,321
2,449
2,694
Discontinued operations, net of tax
42
(4,085)
(723)
Net earnings (loss)
3,363
(1,636)
1,971
Target Corporation
Consolidated Statements of Financial Position
$millions
Jan. 30, 2016
Jan. 31, 2015
Assets
Cash and cash equivalents, inc. short-term investments of $3,008 and $1,520
$4,046
$2,210
Inventory
8,601
8,282
Assets of discontinued operations
322
1,058
Other current assets
1,161
2,074
Total current assets
14,130
13,624
Property and equipment, net
25,217
25,952
Noncurrent assets of discontinued operations
75
717
Other noncurrent assets
840
879
Total assets
$40,262
$41,172
Liabilities and Shareholders' investment
Accounts payable
$7,418
$7,759
Accrued expenses and other current liabilities
4,236
3,783
Current portion of LT debt and other borrowings
815
91
Liabilities of discontinued operations
153
103
Total current liabilities
12,622
11,736
Long-term debt and other borrowings
11,945
12,634
Deferred income taxes
823
1,160
Noncurrent liabilities of discontinued operations
18
193
Other noncurrent liabilities
1,897
1,452
Total noncurrent liabilities
14,683
15,439
Shareholders' investment
Common stock
50
53
Additional paid-in-capital
5,348
4,899
Retained earnings
8,188
9,644
Accumulated other comprehensive loss
Pension and other benefit liabilities
(588)
(561)
Currency translation adjustment and cash flow hedges
(41)
(38)
Total shareholders' investment
12,957
13,997
Total liabilities and shareholders' investment
$40,262
$41,172
Required:
Forecast Target's FY2016 and FY2017 income statements and balance sheets. Use the following assumptions and data:
-Assume that sales grow by 3% each year.
-Forecast income statement and balance sheet relations as a percentage of sales and round to three decimal places. For example, Cost of sales/Sales = 0.70471 or %70.5%). Use the same forecast assumptions for both years.
-Target's long-term debt footnote indicates maturities of $751 million in FY2016, $2,251 million in FY2017, and $201 million in FY2018.
-Assume that in FY2016, CAPEX will be 1.9% of sales and depreciation expense will be 8.4% of the PPE balance at the start of the year.
-Target paid $1,362 million in dividends in FY2015.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!