Acc-04
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.
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