Question 1.Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow.
Income Statement
For Fiscal Years Ended ($ millions)
2008
2007
2006
Sales
$ 61,471
$ 57,878
$ 51,271
Credit card revenues
1,896
1,612
1,349
Total revenues
63,367
59,490
52,620
Cost of sales
41,895
39,399
34,927
Selling, general and administrative expenses
13,704
12,819
11,185
Credit card expenses
837
707
776
Depreciation and amortization
1,659
1,496
1,409
Earnings before interest and income taxes
5,272
5,069
4,323
Net interest expense
647
572
463
Earnings before income taxes
4,625
4,497
3,860
Provisions for income taxes
1,776
1,710
1,452
Net earnings
$ 2,849
$ 2,787
$ 2,408
Balance Sheet
($ millions, except footnotes)
February 2, 2008
February 3, 2007
Assets
Cash and cash equivalents
$ 2,450
$ 813
Credit card receivables
8,054
6,194
Inventory
6,780
6,254
Other current assets
1,622
1,445
Total current assets
18,906
14,706
Property and equipment
Land
5,522
4,934
Buildings and improvements
18,329
16,110
Fixtures and equipment
3,858
3,553
Computer hardware and software
2,421
2,188
Construction-in-progress
1,852
1,596
Accumulated depreciation
(7,887)
(6,950)
Property and equipment, net
24,095
21,431
Other noncurrent assets
1,559
1,212
Total assets
$ 44,560
$ 37,349
Liabilities and shareholders' investment
Accounts payable
$ 6,721
$ 6,575
Accrued and other current liabilities
3,097
3,180
Current portion of long-term debt and notes payable
1,964
1,362
Total current liabilities
11,782
11,117
Long-term debt
15,126
8,675
Deferred income taxes
470
577
Other noncurrent liabilities
1,875
1,347
Shareholders' investment
Common stock
68
72
Additional paid-in-capital
2,656
2,387
Retained earnings
12,761
13,417
Accumulated other comprehensive income (loss)
(178)
(243)
Total shareholders' investment
15,307
15,633
Total liabilities and shareholders' equity
$ 44,560
$ 37,349
(a) Compute net operating profit after tax (NOPAT) for 2008. Assume that the combined federal and statutory rate is: 39%. (Round your answer to the nearest whole number.)
2008 NOPAT = Answer ($ millions) (b) Compute net operating assets (NOA) for 2008 and 2007.
2008 NOA = Answer ($ millions) 2007 NOA = Answer ($ millions)
(c) Compute Target's RNOA, net operating profit margin (NOPM) and net operating asset turnover (NOAT) for 2008. (Do not round until final answer. Round two decimal places. Do not use NOPM x NOAT to calculate RNOA.)
2008 RNOA = Answer% 2008 NOPM = Answer% 2008 NOAT = Answer
(d) Compute net nonoperating obligations (NNO) for 2008 and 2007.
2008 NNO = Answer ($ millions) 2007 NNO = Answer ($ millions) (e) Compute return on equity (ROE) for 2008. (Round your answers to two decimal places. Do not round until your final answer.)
2008 ROE = Answer% (f) Infer the nonoperating return component of ROE for 2008. (Use answers from above to calculate. Round your answer to two decimal places.)
2008 nonoperating return = Answer% (g) Which of the following statements reflects the best inference we can draw from the difference between Target's ROE and RNOA?
ROE > RNOA implies that Target has increased its financial leverage during the period.
ROE > RNOA implies that Target is able to borrow money to fund operating assets that yield a return greater than its cost of debt; the excess accrues to the benefit of Target's stockholders.
ROE > RNOA implies that Target's equity has grown faster than its NOA.
ROE > RNOA implies that Target has taken on too much financial leverage.
Question 2.Top of Form
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow.
Income Statement
For Fiscal Years Ended ($ millions)
2006
2005
2004
Sales
$ 51,271
$ 45,682
$ 40,928
Credit card revenues
1,349
1,157
1,097
Total revenues
52,620
46,839
42,025
Cost of sales
34,927
31,445
28,389
Selling, general and administrative expenses
11,185
9,797
8,657
Credit card expenses
776
737
722
Depreciation and amortization
1,409
1,259
1,098
Earnings before interest and income taxes
4,323
3,601
3,159
Net interest expense
463
570
556
Earnings before income taxes
3,860
3,031
2,603
Provisions for income taxes
1,452
1,146
984
Net earnings
$ 2,408
$ 1,885
$ 1,619
Balance Sheet
($ millions, except footnotes)
January 28, 2006
January 29, 2005
Assets
Cash and cash equivalents
$ 1,648
$ 2,245
Credit card receivables
5,666
5,069
Inventory
5,838
5,384
Other current assets
1,253
1,224
Total current assets
14,405
13,922
Property and equipment
Land
4,449
3,804
Buildings and improvements
14,174
12,518
Fixtures and equipment
3,219
2,990
Computer hardware and software
2,214
1,998
Construction-in-progress
1,158
962
Accumulated depreciation
(6,176)
(5,412)
Property and equipment, net
19,038
16,860
Other noncurrent assets
1,552
1,511
Total assets
$ 34,995
$ 32,293
Liabilities and shareholders' investment
Accounts payable
$ 6,268
$ 5,779
Accrued and other current liabilities
2,567
1,937
Current portion of long-term debt and notes payable
753
504
Total current liabilities
9,588
8,220
Long-term debt
9,119
9,034
Deferred income taxes
851
973
Other noncurrent liabilities
1,232
1,037
Shareholders' investment
Common stock
73
74
Additional paid-in-capital
2,121
1,810
Retained earnings
12,013
11,148
Accumulated other comprehensive income (loss)
(2)
(3)
Total shareholders' investment
14,205
13,029
Total liabilities and shareholders' equity
$ 34,995
$ 32,293
(a) Apply the basic DuPont model and compute the component measures for profit margin, asset turnover, and financial leverage. (Do not round until your final answer. Round your answers to two decimal places.) Net profit margin =Answer% Asset turnover =Answer Financial leverage =Answer (b) Compute ROE using financial information provided in the balance sheet and income statement. Do not use ROE = PM x AT x FL. (Do not round until your final answer. Round your answer to two decimal places.) ROE =Answer% (c) Compute adjusted ROA. Assume a tax rate of: 38.3%. (Do not round until your final answer. Round your answer to two decimal places.) Adjusted ROA =Answer%
Question 3.
Interpreting Accounts Receivable and Its Footnote Disclosure Following is the current asset section from the W.W. Grainger, Inc., balance sheet.
As of December 31 ($ 000s)
2012
2011
2010
Cash and cash equivalents
$ 452,063
$ 335,491
$ 313,454
Accounts receivable (less allowances for doubtful accounts of $19,449, $18,801, $24,552 respectively)
940,020
888,697
762,895
Inventories, net
1,301,935
1,268,647
991,577
Prepaid expenses and other assets
110,414
100,081
87,125
Deferred income taxes
55,967
47,410
44,627
Prepaid income taxes
40,241
54,574
38,393
Total current assets
$ 2,900,640
$ 2,694,900
$ 2,238,071
Grainger reports the following footnote relating to its receivables. Allowance for Doubtful Accounts: The following table shows the activity in the allowance for doubtful accounts.
For Years ended December 31 ($ 000s)
2012
2011
2010
Allowance for doubtful accounts- accounts receivable
Balance at beginning of period
$ 18,801
$ 24,552
$ 25,850
Provision for uncollectable accounts
9,504
4,761
6,718
Write-off of uncollectible accounts, less recoveries
(9,100)
(8,138)
(8,302)
Business acquisitions, foreign currency and other
244
(2,374)
286
Balance at end of period
$ 19,449
$ 18,801
$ 24,552
(a) What amount do customers owe Grainger at each of the year-ends 2010 through 2012?
($ 000s)
2012
2011
2010
Gross accounts receivable
$Answer
$Answer
$Answer
(b) What percentage of its total accounts receivable does Grainger deem uncollectible? Hint: Percentage of uncollectible accounts = Allowance for uncollectible accounts/Gross accounts receivable. Round your answers to two decimal places.
($ 000s)
2012
2011
2010
Percentage of uncollectible accounts to gross accounts receivable
Answer%
Answer%
Answer%
(c) What amount of bad debts expense did Grainger report in its income statement for each of the years 2010 through 2012?
($ 000s)
2012
2011
2010
Bad debts expense (titled Provision for Uncollectible Accounts)
$Answer
$Answer
$Answer
(d) Which of the following statements most closely describes what we observe in our answer to part (b)?
The allowance for uncollectible accounts has decreased as a percentage of gross accounts receivable in 2012. The allowance decreased because the gross accounts receivable has increased and the allowance account has decreased.
The allowance for uncollectible accounts has decreased as a percentage of gross accounts receivable in 2012. This means that Grainger is over-stating its bad debt expense in the current year.
The allowance for uncollectible accounts has increased as a percentage of gross accounts receivable in 2012. The allowance is increasing appropriately because write-offs of uncollectible accounts are also increasing.
The allowance for uncollectible accounts has increased as a percentage of gross accounts receivable in 2012. This means that the allowance was too low in prior years.
(e) If Grainger had kept its 2012 allowance for uncollectible accounts at the same percentage of gross accounts receivable as it was in 2010, by what amount would its profit have changed (ignore taxes)? Answer($ 000s) (f) Which of the following statements about Grainger's allowance for uncollectible accounts and the related bad debts expense is false?
Since 2010, Grainger has decreased its allowance for uncollectible accounts as a percentage of gross receivables.
Grainger's current allowance account appears adequate since it is two times the level of current-year write-offs.
Since 2010 Grainger has decreased it allowance for uncollectible accounts by increasing its write-offs.
Grainger's bad debt expense decreased from 2010 to 2011, but then increased again in 2012.
Question 4
Interpreting and Applying Disclosures on Property and Equipment Following are selected disclosures from the Evett and Sternard Company (a specialty chemical company) 2007 10-K.
Land, Building and Equipment, Net
(in millions)
2007
2006
Land
$ 146
$ 142
Buildings and improvements
2,000
1,900
Machinery and equipment
6,155
5,721
Capitalized interest
352
340
Construction in progress
271
218
Land, Building and Equipment, Gross
8,924
8,321
Less: Accumulated depreciation
5,908
5,481
Total
$ 3,016
$ 2,840
The principal lives (in years) used in determining depreciation rates of various assets are: buildings and improvement (10-50); machinery and equipment (5-20); automobiles, trucks and tank cars (3-10); furniture and fixtures, laboratory equipment and other assets (5-10); capitalized software (5-7). The principal life used in determining the depreciation rate for leasehold improvements is the years remaining in the lease term or the useful life (in years) of the asset, whichever is shorter. IMPAIRMENT OF LONG-LIVED ASSETS Long-lived assets, other than investments, goodwill and indefinite-lived intangible assets, are depreciated over their estimated useful lives, and are reviewed for impairment whenever changes in circumstances indicate the carrying value of the asset may not be recoverable. Such circumstances would include items such as a significant decrease in the market price of a long-lived asset, a significant adverse change in the manner the asset is being used or planned to be used or in its physical condition or a history of operating or cash flow losses associated with the use of the asset ... When such events or changes occur, we assess the recoverability of the asset by comparing the carrying value of the asset to the expected future cash flows associated with the asset's planned future use and eventual disposition of the asset, if applicable ... We utilize marketplace assumptions to calculate the discounted cash flows used in determining the asset's fair value ... For the year ended December 31, 2007, we recognized approximately $24 million of fixed asset impairment charges. (a) Compute the PPE (land, buildings and equipment) turnover for 2007 (Sales in 2007 are $8,897 million). (Round your answer to two decimal places.) Answer If the median PPE turnover rate for all publicly traded companies is approximately 5.03 in 2007, what does Evett and Sternard's turnover rate tell us about the company?
Evett and Sternard is less capital intensive than the median publicly traded company.
Evett and Sternard is the same capital intensive as the median publicly traded company.
The PPE turnover rate does not tell us anything about how capital intensive Evett and Sternard is.
Evett and Sternard is more capital intensive than the median publicly traded company.
(b) Evett and Sternard reported depreciation expense of $412 million in 2007. Estimate the useful life, on average, for its depreciable PPE assets. (Round your answer to two decimal places.) Answeryears (c) By what percentage are Evett and Sternard's assets "used up" at year-end 2007? (Round your answer to two decimal places.) Answer% Which of the following statements best captures the implication that the assets "used up" computation has for forecasting cash flows?
Evett and Sternard's assets are not particularly "used up" according to this computation. We, therefore, do not expect adverse implication for future cash flow.
A percentage "used up" substantially above 50% indicates that the assets are closer to the end of their useful lives. This means that the depreciation expense will decrease and this in turn will have a positive impact on future cash flows.
The assets "used up" computation can not tell us anything about future cash flows.
A percentage "used up" substantially above 50% indicates that the assets are closer to the end of their useful lives and will require replacement. Such a situation would negatively impact future cash flows.
(d) Evett and Sternard reports an asset impairment charge in 2007. Which of the following statements best captures the implications of asset impairment charges (write-offs)?
Plant assets are deemed to be impaired if their market value is less than their book value, even if temporary. We should treat these write-downs as recurring (operating) items because future write-downs are inevitable.
Plant assets are deemed to be impaired if the undiscounted expected future cash flows from those assets are not sufficient to recover their net book value. We should treat these write-downs as recurring (operating) items because future write-downs are inevitable.
Plant assets are deemed to be impaired if the undiscounted expected future cash flows from those assets are not sufficient to recover their net book value. Because assets impairment charges are arguably nonrecurring, one might use this to justify treating them as transitory items for analysis purposes.
Plant assets are deemed to be impaired if their market value is less than their book value, even if temporary. We should treat these write-downs as transitory.
qBottom of Form
Network connection lost. (Autosave failed).
Make a note of any responses entered on this page in the last few minutes, then try to re-connect.
Once connection has been re-established, your responses should be saved and this message will disappear.
Network connection restored. You may continue safely.
Bottom of Form
Network connection lost. (Autosave failed).
Make a note of any responses entered on this page in the last few minutes, then try to re-connect.
Once connection has been re-established, your responses should be saved and this message will disappear.
Network connection restored. You may continue safely.
Check
Next
601051
1
-1
0
ybofCVihQD
2
601064
Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education