Nu Ware

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 22

Assignment questions 1.

In general, what types of issues come to mind when you hear analysts question a firm's "earnings quality"? 2. Why is Harry Malone concerned about relying on Nuware's reported performance? If Nuware follows GAA 3. Assume the role of Hereford and restate Nuware's 2003 earnings as if the company had used a similar acco After such restatement, do Nuware's earnings and earnings growth remain superior to that of R. P. Stuart? 4. Would you characterize the accounting discretion applied by Nuware management as aggressive? Do you t

ts question a firm's "earnings quality"? d performance? If Nuware follows GAAP, shouldn't the company's reported financial statements be reliable? if the company had used a similar accounting method and assumptions. main superior to that of R. P. Stuart? re management as aggressive? Do you think the company has been "managing" earnings?

Exhibit 1 NuWare Inc. Consolidated Statement of Operations (in thousands except per share amounts) For the fiscal year ended January 31, 2003 2002 2001 Net sales 1,754,861 1,709,254 1,611,498 Operating costs and expenses Cost of sales (including occupancy costs) 1,001,892 1,009,893 919,871 Selling, general and administrative expenses 586,124 555,508 565,475 Depreciation and amortization 36,356 32,196 30,229 Operating income Non-operating (income) and expenses: Interest and investment income Interest expense Income before income taxes Provision for income taxes Net income Earnings per share: Basic Diluted Dividend declared per share Average shares outstanding during the period: Basic Diluted 130,489 (9,382) 2,508 137,363 50,784 86,579 0.86 0.82 0.16 100,883 105,823 111,657 (5,784) 2,290 115,151 42,576 72,575 0.72 0.70 0.16 100,883 103,972 95,923 (5,014) 3,048 97,889 36,220 61,669 0.62 0.60 0.15 99,631 102,003

Exhibit 2 NuWare Inc. Consolidated Balance Sheets (in thousands except per share amounts) As of January 31, 2003 ASSETS Current assets: Cash, including AFS investments Beneficial interest in securitized receivables Accounts receivable, net of reserves Inventories Prepaid expenses and other current assets

192,114 40,538 295,888 247,502 56,179 832,221 374,493 49,411 1,256,125

Property, net Other noncurrent assets Total Assets LIABILITIES AND SHAREHOLDERS' EQUITY Current liabilities: Current portion of long-term debt Accounts payable Gift cards, gift certificates and merchandise credits outstanding Accrued income taxes payable Other accrued liabilities Total current liabilities Long-term debt Other noncurrent liabilities Shareholders' equity: Common stock, $0.10 par, 500 million authorized 100,883,000 shares issued Paid-in capital Retained earnings Cumulative other comprehensive income (loss) Less: 10,045,000 and 7,362,000 common shares in treasury, at cost Commitments and contingencies Total Liabilities and Shareholders' equity

393 176,702 117,495 35,798 192,348 522,736 25,007 54,962

10,088 479,074 314,124 (11,210) (138,656) 653,420 1,256,125

As of January 31, 2002

2003

2002

55,609 34,620 363,424 230,911 43,286 727,850 370,262 47,985 1,146,097

AFS investments Reserve for doubtful accounts

59,716 9,438

35,076 16,140

356 129,076 139,852 29,738 170,053 469,075 25,356 43,264

10,088 440,190 243,257 (4,702) (80,521) 608,312 1,146,007 Treasury stock No. of treasury shares 138,656,000 1,004,500 80,521,000 7,362,000

Exhibit 3 NuWare Inc. Selected Excerpts from Notes to Financial Statements (Source: Notes to Consolidated Financial Statemet, Nuware, Inc. Annual Report) 2003 Use of Estimates Cash and Receivables 2002

Merchandise Inventories Valued at the lowest of Cost (LIFO method) or market (Retail method) LIFO adjustment to ending inventory: Old method New method Effect of accounting policy change in 2002: Net income lower by basic EPS lower by diluted EPS lower by Cumulative effect of accounting change Total charges to cost of sales include: Occupancy costs If FIFO method of inventory valuation is used, Value of inventories would have been higher by

33,000 35,100 2,100 0.02 0.02 Not ascertainable

45,000 29,500

44,000 35,100

Plant, Property and Equipment Furniture and equipment Buildings Leasehold improvements Accumulated depreciation -

Historic cost Historic cost Historic cost

SLM SLM

3 - 10 30 Min( useful life, term of lease) 268,500

304,500

Depreciation expenses

35,698

31,572

Financial Instruments fair value <-- market data, valuation techniques AFS investments: Unrealized holding gains shown on Balance sheet net realized gains on sale of AFS investments

6,700

4,800

Revenue Recognition

Advertising and marketing costs policy on Promotional costs Advertising costs Marketing and promotional costs of which, portion deferred at end of the fiscal years

62,211 20,527 10,200

67,450 17,561 8,700

Short-term and long-term debt Long-term debt, including current maturities: 7-10% Debentures Medium-term notes Sinking fund debentures less: current maturities Long-term maturities

24,438 785 177 25,400 393 25,007

24,467 1,050 195 25,712 356 25,356

Stock compensation

Effect on net income if fair-value based method has been applied Net income, as reported 86,580 Less: expense under fair value method, net of tax 1,071 Pro forma net income 85,509 Pro forma earnings per share

72,575 707 71,868

Basic Diluted

0.85 0.81

0.71 0.69

2001

Not ascertainable

44,000

years years Min( useful life, term of lease)

26,620

3,700

58,727 19,044

Exhibit 4 Sears, Roebuck and Company Earnings Sensitivity Analysis as example Receivables and inventory source Reported Earnings and non-recurring items Net sales Net income before taxes Tax expense Net income after taxes Average effective tax rate Non-recurring charges before tax Adjusted Net income after tax Accounts Receivable Analysis Reported Values: Gross receivables Reserve for uncollectibles Net receivables Bad debt expense Write-offs Inferred values and computed ratios Reserve / Accounts Receivable Change in reserve / Accounts receivable Accounts receivables turnover Days receivables turnover Effect of 0.73% shift in Reserve / Acc. Rec. As a % of NI (with nonrecurring items) As a % of NI (without nonrecurring items) Inventory Analysis Reported Values: Inventory (LIFO) LIFO Reserve Cost of goods sold (LIFO) I/S I/S I/S I/S computed I/S computed 2001 41,078 1,202 467 735 38.9% 1,064 1,386 2000 40,937 2,174 831 1,343 38.2% 251 1,498 1999 39,484 2,357 904 1,453 38.4% 41 1,478

B/S B/S B/S I/S footnotes

29,321 1,166 28,155 1,866 1,386

21,108 686 20,422 884 958

21,937 760 21,177 871 1,085

3.98% 0.73% 1.69 216 131.00 17.8% 9.5%

3.25% -0.21% 1.97 185 95.00 7.1% 6.3%

3.46% -0.73% 1.82 201 99.00 6.8% 6.7%

B/S footnotes I/S

4,912 591 26,322

5,618 566 26,899

5,069 595 25,627

Inferred values and computed ratios Inventory (FIFO) Cost of goods sold (FIFO) Inventory Turnover (LIFO) Inventory Turnover (FIFO) Days Inventory Turnover (LIFO) Days Inventory Turnover (FIFO) Effect of LIFO on Reported Earnings As a % of NI (with nonrecurring items) As a % of NI (without nonrecurring items)

5,503 26,297 5.00 4.50 73.01 81.11 -15.3 -2.1% -1.1%

6,184 26,928 5.03 4.55 72.51 80.30 17.9 1.3% 1.2%

5,664 25,711 4.93 4.41 74.00 82.80 51.8 3.6% 3.5%

1998 41,575 1,838 766 1,072 41.7%

23,240 974 22,266 1,287

4.19%

5,322 679 27,444

6,001

Exhibit 5 R. P. Stuart Company Consolidated Statement of Operations (in thousands except per share amounts) For the fiscal year ended January 31, 2003 2002 2001 567,411 525,697 502,292 352,682 316,500 305,401 214,729 209,197 196,891 164,550 156,942 149,884 4,603 5,371 4,584 45,576 46,884 42,423

Net sales Cost of sales (including occupancy costs) Gross profit Selling, general and administrative expenses Store preopening expenses Income from operations Non-operating (income) and expenses: Interest and investment income Interest expense Income before income taxes Provision for income taxes Net income Earnings per share: Basic Diluted Dividend declared per share Average shares outstanding during the period: Basic Diluted

(883) 4,884 41,575 16,214 25,361 0.80 0.77

(1,294) 4,999 43,179 16,836 26,343 0.85 0.83

(1,180) 5,238 38,365 14,956 23,409 0.78 0.75

31,649 32,960

31,105 31,876

30,064 31,199

Exhibit 6 R. P. STUART COMPANY Consolidated Balance Sheets (in thousands except per share amounts) As of January 31, 2003 ASSETS Current assets: Cash and Cash equivalents Credit receivables, net of allowances Merchandise inventories Other current assets Total current assets Property and equipment, gross Accumulated depreciation Goodwill Other assets Total Assets LIABILITIES AND SHAREHOLDERS' EQUITY Current liabilities: Current portion of long-term debt Accounts payable Accrued income taxes payable Accrued compensation Other accrued liabilities Total current liabilities Long-term debt Other noncurrent liabilities Shareholders' equity: Preferred stock, $0.01 par value: 6,500,000 shares authorized none issue and outstanding Common stock, $0.01 par, 80 million shares authorized Issued and outstanding: 31,649,743 and 31,105,437 shares Additional Paid-in capital Retained earnings Cumulative other comprehensive income (loss)

45,420 269,115 131,344 16,789 462,668 430,256 (135,692) 4,178 9,287 770,697

4,809 73,990 15,082 8,305 28,986 131,172 13,216 55,091

316 275,089 295,813 -

Less: common shares in treasury, at cost Commitments and contingencies

571,218 571,218 770,697

Total Liabilities and Shareholders' equity

As of January 31, 2002

2003

2002

111,815 217,123 109,829 11,107 449,874 356,096 (116,092) 4,340 10,080 704,298

Allowances for card receivables 12,650

10,327

3,468 81,592 29,993 18,506 18,251 151,810 15,498 44,035

311 220,056 272,588 -

492,955 492,955 704,298

Exhibit 7 R. P. STUART COMPANY Selected Excerpts from Notes to Financial Statements

Exhibit 8 Miscellaneous Profitability Statistics Nuware, Inc. 2002

2003 Net income Net income per diluted share Return on Assets Return on Equity Average effective tax rate EPS growth Sales growth Gross profit margin USD 86,579 USD 0.82 13.72% 37.0% 17.2% 2.7% 42.9%

2001

USD 72,575 USD 61,669 USD 0.70 USD 0.60 11.93% 37.0% 15.5% 6.1% 40.9%

37.0%

42.9%

us Profitability Statistics R. P. Stuart Company 2003 2002 2001 USD 25,361 USD 0.77 4.8% 39.0% -6.9% 7.9% 62.2% USD 26,343 USD 0.83 5.3% 39.0% 10.1% 4.7% 60.2% USD 23,409 USD 0.75

39.0%

60.8%

You might also like