fbrumbaugh@fulbright.com
direct dial: (214) 855-7177
|
telephone: (214) 855-8000
facsimile: (214) 855-8200
|
Re:
|
Response to Comments Received from the Staff of the Commission with respect to
|
Amendment No. 1 to Form 10-K/A and Form 10 –K for Fiscal Year Ended January 31,
2010, filed on April 12, 2010 and March 25, 2010; |
|
File No. 0-5042
|
1.
|
We note you fully impaired goodwill during the three month period ended October 31, 2009. Please provide us the valuation report, or a detailed summary, that served as the basis for performing step one of the goodwill impairment test. Show us how you performed step one of the test including whether it was done on an entity wide basis or by segment or reporting unit. Please also provide us the purchase allocation that you performed in step two of the analysis and tell us how you determined the fair value of assets and liabilities used in the purchase allocation. Please be detailed in your explanation indicating whether and where you used an outside consultant. To the extent step two indicated that carrying value exceeded fair value for any long-lived asset or group of assets, advise us whether you considered this an event necessitatin
g an impairment test of long-lived assets. If so, show us the results of such test. Please reconcile your total valuation of the company to the then most recent market capitalization. Please summarize the reason(s) for any large differences between your derived value and your market capitalization. We may have further substantive comment.
|
·
|
For the Company’s accounts receivables, interests in securitized assets (recorded at fair value) and non-current long–term debt, the Company is required to estimate the fair value of those balances and the valuation of those balances is determined using acceptable valuation methodologies. The Company is assisted in developing several of its fair value valuation assumptions for these amounts by third-party providers. Given the regular quarterly valuation, the estimated fair values of these items at September 30, 2009 were determined to not be materially different than their respective carrying values.
|
·
|
The Company’s inventories consist mainly of durable consumer goods held for sale, which turn over approximately six times each year. The Company continually monitors the carrying value of its inventories through information gathered from actual sales in stores, and writes down its inventory values when it is deemed that the carrying value is not recoverable. Given this approach, the fair values of the Company’s inventories were considered to not be materially different than their respective carrying values at September 30, 2009.
|
·
|
The Company’s deferred income taxes arise on timing differences from items such as depreciation and amortization. Any deferred income tax balance sheet item is an estimate of the future tax that will be received (asset), or the future tax that will have to be paid (liability). The Company’s calculation of the deferred income tax asset was reviewed at a high level by the third-party consultants and was not deemed to be unreasonable. Given this, the fair values of the Company’s deferred income taxes values were considered to not be materially different than their carrying values at September 30, 2009.
|
·
|
The Company’s property, plant and equipment consist mainly of leasehold improvements, fixtures and fittings. The nature of these items is such that their respective carrying value will often approximate fair value. Given this, the fair value of the Company’s property, plant and equipment was considered to not be materially different than their respective carrying value at September 30, 2009.
|
·
|
The Company’s accounts payable and accrued expenses balances consist of short-term liabilities which are generally due for settlement in the near term, for example, employee salaries, payments to suppliers, etc. The nature of these balances is such that their respective carrying value will often approximate fair value. Given this, the fair values of these balance sheet items were considered to not be materially different than their respective carrying values at September 30, 2009.
|
·
|
The Company’s deferred revenue arises from two sources. Firstly, from the sale of service and maintenance agreements that are sold with merchandise at the date of sale. Secondly, from vendor allowances received from vendors for price protection, product rebates, marketing, training and promotion programs. Since payment has already been received for these services still to be rendered, and since it is the value of these payments that is reflected on the balance sheet, the fair values of the deferred revenue balances were considered to not be materially different than their respective carrying values at September 30, 2009.
|
·
|
The third-party consultants also assisted in determining the valuation of any intangible assets not currently carried on the books of the Company. The most significant of those assets was the fair value of the Company’s trade name, which was concluded to have an estimated fair value of between approximately $31 million and $63 million. The Company used the $31 million valuation for this intangible in its allocation of the concluded fair value in its step 2 allocation procedures.
|
Step 2 Allocation of Fair Value
|
||||
at September 30, 2009
|
||||
(dollars in millions)
|
||||
Fair
|
||||
Value
|
||||
Net working capital
|
432.5 | |||
Property, plant & equipment, net
|
61.5 | |||
Other non-current assets
|
6.3 | |||
Other intangibles
|
31.0 | |||
Long-term debt
|
(149.3 | ) | ||
Other non-current liabilities
|
(8.5 | ) | ||
Value of Equity
|
(266.0 | ) | ||
Net assets in excess of concluded fair value
|
(107.5 | ) |
Reserve Analysis
|
||||||||||||||||||||||||
(dollars in thousands)
|
||||||||||||||||||||||||
1/31/09
|
4/30/09
|
7/31/09
|
10/31/09
|
1/31/10
|
3/31/10
|
|||||||||||||||||||
Primary Portfolio
|
||||||||||||||||||||||||
Trailing 12-month charge-offs, net of recoveries - combined
|
14,505 | 15,637 | 16,728 | 18,741 | 20,963 | 22,568 | ||||||||||||||||||
Average portfolio balance - combined
|
543,559 | 548,068 | 562,187 | 569,866 | 594,063 | 579,101 | ||||||||||||||||||
Trailing 12-month loss rate - combined
|
2.7 | % | 2.9 | % | 3.0 | % | 3.3 | % | 3.5 | % | 3.9 | % | ||||||||||||
Receivable balance at period end - Not Sold
|
81,926 | 119,846 | 167,942 | 196,377 | 180,654 | 178,206 | ||||||||||||||||||
Calculated reserve at period end, based on actual loss rate
|
2,186 | 3,419 | 4,997 | 6,458 | 6,375 | 6,945 | ||||||||||||||||||
Adjusted reserve at period end
|
2,186 | 3,419 | 4,997 | 6,850 | 6,466 | 6,455 | ||||||||||||||||||
Adjusted reserve as percent of ending balance
|
2.7 | % | 2.9 | % | 3.0 | % | 3.5 | % | 3.6 | % | 3.6 | % | ||||||||||||
Secondary Portfolio
|
||||||||||||||||||||||||
Trailing 12-month charge-offs, net of recoveries - combined
|
7,171 | 7,167 | 7,858 | 8,095 | 8,352 | 9,086 | ||||||||||||||||||
Average portfolio balance - combined
|
153,010 | 154,177 | 158,198 | 152,328 | 150,711 | 144,904 | ||||||||||||||||||
Trailing 12-month loss rate - combined
|
4.7 | % | 4.6 | % | 5.0 | % | 5.3 | % | 5.5 | % | 6.3 | % | ||||||||||||
Receivable balance at period end - Not Sold
|
19,648 | 25,019 | 32,051 | 35,037 | 33,468 | 33,988 | ||||||||||||||||||
Calculated reserve at period end, based on actual loss rate
|
921 | 1,163 | 1,592 | 1,862 | 1,855 | 2,131 | ||||||||||||||||||
Adjusted reserve at period end
|
921 | 1,163 | 1,592 | 1,932 | 1,871 | 1,942 | ||||||||||||||||||
Adjusted reserve as percent of ending balance
|
4.7 | % | 4.6 | % | 5.0 | % | 5.5 | % | 5.6 | % | 5.7 | % | ||||||||||||
Legacy Portfolio
|
||||||||||||||||||||||||
Trailing 12-month charge-offs, net of recoveries - combined
|
789 |
Combined with Primary and Secondary Portfolio receivables
|
||||||||||||||||||||||
Average portfolio balance - combined
|
7,614 |
subsequent to 1/31/09.
|
||||||||||||||||||||||
Trailing 12-month loss rate - combined
|
10.4 | % | ||||||||||||||||||||||
Receivable balance at period end - Not Sold
|
6,224 | |||||||||||||||||||||||
Calculated reserve at period end, based on actual loss rate
|
645 | |||||||||||||||||||||||
Adjusted reserve at period end
|
645 | |||||||||||||||||||||||
Adjusted reserve as percent of ending balance
|
10.4 | % | ||||||||||||||||||||||
Combined Portfolio
|
||||||||||||||||||||||||
Trailing 12-month charge-offs, net of recoveries - combined
|
22,465 | 22,804 | 24,586 | 26,836 | 29,315 | 31,654 | ||||||||||||||||||
Average portfolio balance - combined
|
704,183 | 702,245 | 720,385 | 722,194 | 744,774 | 724,005 | ||||||||||||||||||
Trailing 12-month loss rate - combined
|
3.2 | % | 3.2 | % | 3.4 | % | 3.7 | % | 3.9 | % | 4.4 | % | ||||||||||||
3-month loss rate - combined (2-months as of 3/31/10)
|
3.4 | % | 3.0 | % | 3.4 | % | 4.3 | % | 4.8 | % | 4.7 | % | ||||||||||||
Receivable balance at period end - Not Sold
|
107,798 | 144,865 | 199,993 | 231,414 | 214,122 | 212,194 | ||||||||||||||||||
Calculated reserve at period end, based on actual loss rate
|
3,439 | 4,704 | 6,826 | 8,599 | 8,428 | 9,277 | ||||||||||||||||||
Adjusted reserve at period end
|
3,752 | 4,582 | 6,589 | 8,782 | 8,337 | 8,397 | ||||||||||||||||||
Adjusted reserve as percent of ending balance
|
3.5 | % | 3.2 | % | 3.3 | % | 3.8 | % | 3.9 | % | 4.0 | % | ||||||||||||
Change in reserve percentage
|
-0.3 | % | 0.1 | % | 0.5 | % | 0.1 | % | 0.1 | % | ||||||||||||||
Uncollectible interest reserve
|
161 | 333 | 662 | 1,058 | 1,233 | 1,236 | ||||||||||||||||||
As percent of ending balance
|
0.1 | % | 0.2 | % | 0.3 | % | 0.5 | % | 0.6 | % | 0.6 | % | ||||||||||||
Total reserve
|
3,913 | 4,915 | 7,251 | 9,840 | 9,570 | 9,633 | ||||||||||||||||||
As percent of ending balance
|
3.6 | % | 3.4 | % | 3.6 | % | 4.3 | % | 4.5 | % | 4.5 | % | ||||||||||||
Change in reserve percentage
|
-0.2 | % | 0.2 | % | 0.6 | % | 0.2 | % | 0.1 | % | ||||||||||||||
Receivable Aging
|
||||||||||||||||||||||||
Current
|
95,142 | 126,907 | 175,304 | 194,427 | 171,439 | 174,537 | ||||||||||||||||||
1-30 days
|
8,176 | 12,038 | 15,744 | 21,690 | 23,398 | 20,042 | ||||||||||||||||||
31-60 days
|
1,551 | 2,192 | 3,085 | 5,656 | 5,734 | 5,155 | ||||||||||||||||||
61-90 days
|
1,005 | 1,283 | 1,883 | 3,140 | 3,760 | 3,121 | ||||||||||||||||||
91-120 days
|
780 | 730 | 1,352 | 2,163 | 3,138 | 2,521 | ||||||||||||||||||
121-150 days
|
439 | 586 | 1,028 | 1,559 | 2,501 | 2,150 | ||||||||||||||||||
151-180 days
|
189 | 519 | 720 | 1,253 | 1,778 | 2,142 | ||||||||||||||||||
181-209 days
|
93 | 199 | 244 | 583 | 878 | 939 | ||||||||||||||||||
210+ days
|
422 | 411 | 633 | 943 | 1,496 | 1,587 | ||||||||||||||||||
Total
|
107,797 | 144,865 | 199,993 | 231,414 | 214,122 | 212,194 |
Sincerely,
|
/s/ D. Forrest Brumbaugh
|
D. Forrest Brumbaugh
|
DFB:pl
|
|
Enclosures
|
|
cc:
|
Anthony Watson, Staff Accountant, Securities and Exchange Commission
|
Timothy L. Frank, Conn’s, Inc.
|
|
Sydney K. Boone, Conn’s, Inc.
|
|
Michael J. Poppe, Conn’s, Inc.
|
Mr. Al Davis
|
Audit – Tax – Advisory |
Controller
|
|
Conn’s, Inc.
|
Grant Thornton LLP |
3295 College Street
|
1717 Main Street, Suite 1500 |
Beaumont, TX 77701
|
Dallas, TX 75201 |
T 214.561.2300 | |
F 214.561.2370 | |
www.GrantThornton.com |
EQUITY
FAIR VALUE |
EQUITY
CARRYING VALUE1 |
INDICATION
OF IMPAIRMENT
|
|
Conn’s, Inc.
|
$ 266,000,000
|
$352,113,000
|
YES
|
Page
|
|
Nomenclature
|
1
|
Engagement Overview
|
2
|
Business Overview
|
7
|
Economic and Industry Outlook
|
13
|
Valuation Methodology
|
24
|
Step II Limited Procedures
|
33
|
Appraiser Representation/Certification
|
36
|
Assumptions and Limiting Conditions
|
41
|
Schedules
|
43
|
STRUCTURE OF THE CLASSIFICATION SYSTEM
|
Topics –ASC XXX
|
Subtopics –ASC XXX-YY
|
Sections –ASC XXX-YY-ZZ
|
Paragraph –ASC XXX-YY-ZZ-PP
|
Subparagraph –ASC XXX-YY-ZZ-PP(a)
|
Codification Section
|
Name of Topic
|
Original Standard
|
ASC 350
|
Intangibles – Goodwill and Other
|
Statement of Financial
Accounting Standards No. (“SFAS”) 142
|
ASC 805
|
Business Combinations
|
SFAS 141(R)
|
ASC 820
|
Fair Value Measurements and
Disclosures |
SFAS 157
|
ASC 820-10-20
|
Fair Value Definition
|
Paragraph 5 of SFAS 157
|
ASC 350-20-35
|
Subsequent Measurement Sections
of Intangibles – Goodwill and Other |
· Emerging Issues Task Force (“EITF”) 02-13
· EITF 02-07
|
a.
|
Quoted prices for similar assets or liabilities in active markets.
|
b.
|
Quoted prices for identical or similar assets or liabilities in markets that are not active, that is, markets in which there are few transactions for the asset or liability, the prices are not current, or price quotations vary substantially either over time or among market makers (for example, some brokered markets), or in which little information is released publicly (for example, a principal-to-principal market).
|
c.
|
Inputs other than quoted prices that are observable for the asset or liability (for example, interest rates and yield curves observable at commonly quoted intervals, volatilities, prepayment speeds, loss severities, credit risks, and default rates).
|
d.
|
Inputs that are derived principally from or corroborated by observable market data by correlation or other means (market-corroborated inputs).”
|
1
|
Financial analysis of Conn’s historical performance, utilizing historical financial statements for the periods ended January 31, 2005 through January 31, 2009, and trailing twelve months (“TTM”) financial statements ended September 30, 2009, as well as other pertinent financial documentation relating to operations;
|
2
|
Analysis of the financial and market performance of publicly-traded companies engaged in the same or a similar line of business;
|
3
|
Testing and analysis of the reporting unit’s forecasted future operating performance to ascertain the reasonableness of the prospective financial information, particularly in light of what a market participant would anticipate;
|
4
|
Discussions with management regarding the business operations, competitive environment, financial forecasts and outlook for the Company;
|
5
|
Examination and analysis of other information deemed relevant to this valuation report and its underlying purpose;
|
6
|
Financial modeling and analysis; and
|
7
|
Independent research and analysis concerning the economic environment and industry segment in which the Company operates.
|
· | Authoritative Guidance |
o
|
Topic 350 of ASC, Intangibles – Goodwill and Other
|
o
|
ASC Section 350-20-35, Intangibles – Goodwill and Other – Goodwill – Subsequent Measurement
|
o
|
ASC Section 350-30-35, Intangibles – Goodwill and Other – Intangibles other than Goodwill – Subsequent Measurement
|
o
|
Topic 805 of ASC, Business Combinations
|
o
|
Topic 730 of ASC, Research and Development
|
o
|
Topic 820 of the ASC, Fair Value Measurements and Disclosures
|
·
|
Related Guidance
|
o
|
Statement of Financial Accounting Concepts No. 7 (“CON 7”), Using Cash Flow Information and Present Value in Accounting Measurements
|
o
|
FASB Interpretation No. 4 (“FIN 4”), Applicability of FASB Statement No. 2 to Business Combinations Accounted for by the Purchase Method
|
o
|
FIN 86, Accounting for the Costs of Computer Software to be Sold, Leased, or Otherwise Marketed
|
o
|
Statement of Position 98-1, Accounting for the Costs of Computer Software Developed and Obtained for Internal Use
|
·
|
a high level of customer service;
|
·
|
highly trained and knowledgeable sales personnel;
|
·
|
a broad range of competitively priced, customer-driven, brand name products;
|
·
|
flexible financing alternatives through proprietary credit programs;
|
·
|
next day delivery capabilities; and
|
·
|
outstanding product repair service.
|
Category
|
Products
|
Selected Brands
|
Home appliances
|
Refrigerators, freezers, washers,
dryers, ranges, dishwashers, built-ins, air conditioners and vacuum cleaners |
General Electric, Frigidaire,
Whirlpool, Maytag, LG, KitchenAid, Sharp, Friedrich, Roper, Hoover and Eureka |
Consumer electronics
|
LCD, plasma, and DLP
televisions, and home theater systems |
Sony, Samsung, Mitsubishi, LG,
Toshiba, Yamaha and Bose |
Track
|
Computers, computer
peripherals, camcorders, digital cameras, DVD players, audio components, compact disc players, GPS devices, video game equipment, speakers and portable electronics
|
Hewlett Packard, Compaq,
Sony, Canon, Garmin, Nintendo, Microsoft and Yamaha |
Other
|
Lawn and garden, furniture and
mattresses |
Poulan, Husqvarna, Toro,
Weedeater, Ashley, Broyhill, Lane, Franklin, Spring Air, Simmons and Serta |
NBER Business Cycle Reference Dates (1929 - Present) | ||||||||||
Month & Year of Economic
|
Duration in Months of | |||||||||
Peak | Trough | Contraction | Prior Expansion | |||||||
August 1929 | March 1933 | 43 | 21 | |||||||
May 1937 | June 1938 | 13 | 50 | |||||||
February 1945 | October 1945 | 8 | 80 | |||||||
November 1948 | October 1949 | 11 | 37 | |||||||
July 1953 | May 1954 | 10 | 45 | |||||||
August 1957 | April 1958 | 8 | 39 | |||||||
April 1960 | February 1961 | 10 | 24 | |||||||
December 1969 | November 1970 | 11 | 106 | |||||||
November 1973 | March 1975 | 16 | 36 | |||||||
January 1980 | July 1980 | 6 | 58 | |||||||
July 1981 | November 1982 | 16 | 12 | |||||||
July 1990 | March 1991 | 8 | 92 | |||||||
March 2001 | November 2001 | 8 | 120 | |||||||
December 2007 | 73 |
·
|
having a wide and expanding product range;
|
·
|
proximity to key markets;
|
·
|
ability to control stock on hand;
|
·
|
experienced work force;
|
·
|
close monitoring of competition; and
|
·
|
attractive product presentation.
|
·
|
The subject interest is tangible-asset intensive; and/or
|
·
|
The highest-and-best value for the subject interest would be obtained by liquidating its net assets.
|
·
|
Reference to transactions in the subject’s equity securities;
|
·
|
The publicly-traded guideline company method; and
|
·
|
The guideline company transaction method.
|
·
|
Capitalization of the earnings or cash flows of a single representative year; and
|
·
|
Discounting the earnings or cash flows of multiple future periods.
|
1.
|
Conn’s, Inc. (NasdaqGS: CONN)
|
2.
|
Best Buy Co., Inc. (NYSE: BBY)
|
3.
|
Aaron’s, Inc. (NYSE: AAN)
|
4.
|
Rent-A-Center, Inc. (NasdaqGS: RCII)
|
5.
|
RadioShack Corporation (NYSE: RSH)
|
6.
|
hhgregg, Inc. (NYSE: HGG)
|
·
|
Revenue multiple – 0.4x
|
·
|
EBITDA multiple – 5.9x
|
·
|
EBIT multiple – 7.4x.
|
·
|
Date
|
·
|
Size
|
·
|
Business description.
|
·
|
EBIT was reduced by a blended income tax expense based on the rates paid by public guideline companies;
|
·
|
The non-cash depreciation and amortization expenses were added back;
|
·
|
The cash flow was adjusted for capital expenditures since management considers that these are necessary to support future revenue growth; and
|
·
|
The cash flow was adjusted for changes in working capital as the Company requires a certain level of working capital to support future revenue growth.
|
WACC
|
=
|
(ke x We) + (kd x [1 - t] x Wd)
|
Where:
|
||
WACC
|
=
|
Weighted average cost of capital
|
ke
|
=
|
Company’s cost of equity capital
|
kd
|
=
|
Company’s cost of debt capital
|
We
|
=
|
Percentage of equity in the capital structure
|
Wd
|
=
|
Percentage of debt in the capital structure
|
t
|
=
|
Company’s effective income tax rate
|
ER
|
=
|
RFR + ß x (MRP) + SSRP + SCRP
|
|
Where:
|
|||
ER
|
=
|
The security’s expected return
|
|
RFR
|
=
|
An appropriate risk-free rate
|
|
ß
|
=
|
The security’s beta statistic
|
|
MRP
|
=
|
The market’s return premium over the risk free return
|
|
SSRP
|
=
|
The small stock risk premium
|
|
SCRP
|
=
|
The specific company risk premium
|
Adjusted Equity Risk Premium
|
5.75 | % | ||
Selected Industry Beta (Re-levered to Market Capital Structure)
|
x 1.14 | |||
Required Industry Risk Premium
|
6.5 | % | ||
Risk-Free Rate (Long-Term Government Bonds)
|
4.0 | % | ||
Required Industry Equity Return
|
10.5 | % | ||
Small Company Risk Premium (9th Decile)
|
2.7 | % | ||
Specific Company Risk Premium
|
1.0 | % | ||
Required Return for Investment in Company (rounded)
|
14.0 | % |
Pre-Tax Cost of Debt Capital
|
6.2 | % | ||
Less: Effective Blended Federal and State Tax Rate (38.7%)
|
(2.4 | )% | ||
After-Tax Cost of Debt
|
3.8 | % | ||
Multiplied by Proportion of Debt
|
19.3 | % | ||
Debt Portion of WACC
|
0.7 | % | ||
Cost of Equity Capital (page 35)
|
14.0 | % | ||
Multiplied by Proportion of Equity
|
80.7 | % | ||
Equity Portion of WACC
|
11.3 | % | ||
Weighted Average Cost of Capital (rounded)
|
12.0 | % |
·
|
A 3.0 percent long-term growth rate that reflects the Company’s long-term earnings growth prospects was considered reasonable, as well as consistent, with overall Company growth expectations; and
|
·
|
Depreciation will be adequate to fund capital expenditure needs over the long term.
|
Concluded WACC
|
12.0 | % | ||
Conn’s Estimated Long-Term Growth Rate
|
(3.0) | % | ||
Capitalization Rate Applicable to Debt-Free Cash Flow
|
9.0 | % |
INCOME
APPROACH |
MARKET
APPROACH |
CONCLUDED
VALUE |
|||
Conn’s, Inc.
|
410,000,000
|
428,000,000
|
415,000,000
|
||
EQUITY
FAIR VALUE
|
EQUITY
CARRYING VALUE10 |
INDICATION
OF IMPAIRMENT |
|
Conn’s, Inc.
|
$ 266,000,000
|
$352,113,000
|
YES
|
·
|
Accounts receivable of $247,298,000, interest in securitized asset of $153,836,000, and long term debt, noncurrent of $149,333,000 – As part of its quarterly reporting, the Company is required to fair value its accounts receivable, its interest in securitized asset and its long term debt. Per the Company’s 10-K and 10-Q, the valuation of these account balances is arrived at using acceptable valuation methodologies, and is assisted in its valuation assumptions by a third party provider. Given this regular quarterly valuation, the fair values of these balance sheet items are not considered to be materially less than the carrying values as of the valuation date.
|
·
|
Inventories $92,914,000 – The Company’s inventories consist mainly of electronic goods held for sale. The Company continually monitors the carrying value of its inventories through information gathered from actual sales in stores, and adopts a conservative approach of writing down inventory where it is deemed that the carrying value is not recoverable. Given this conservative approach, the fair values of the Company’s inventories are not considered to be materially less than the carrying values as of the valuation date.
|
·
|
Deferred income taxes $16,272,000 – The Company’s deferred income taxes arise on timing differences from items such as depreciation and amortization. Any deferred income tax balance sheet item is an estimate of the future tax that will be received (asset), or the future tax that will have to be paid (liability). Management’s calculation of the deferred income tax asset has been reviewed at a high level and is not deemed to be unreasonable. Given this, the fair values of the Company’s deferred income taxes are not considered to be materially less than the carrying values as of the valuation date.
|
·
|
Net property, plant and equipment $61,541,000 – The Company’s property, plant and equipment consists mainly of leasehold improvements, fixtures and fittings. The nature of these items is such that carrying value will often approximate fair value. Given this, the fair value of the Company’s property, plant and equipment is not considered to be materially less than the carrying value as of the valuation date.
|
·
|
Accounts payable of $46,649,000 and accrued expenses of $28,129,000 – A company’s accounts payable and accrued expenses balances are made up of short-term liabilities which are generally due for settlement in the near term, for example, employee salaries, payments to suppliers, etc. The nature of these balances is such that carrying value will often approximate fair value. Given this, the fair values of these balance sheet items are not considered to be materially less than the carrying values as of the valuation date.
|
·
|
Deferred revenue, current and noncurrent $19,982,000 – Deferred revenue arises from two sources. Firstly, from the sale of service and maintenance agreements that are sold with merchandise at the date of sale. Secondly, from vendor allowances received from vendors for price protection, product rebates, marketing, training and promotion programs. Since payment has already been received for these services still to be rendered, and since it is the value of these payments that is reflected on the balance sheet, the fair values of the deferred revenue balances are not considered to be materially less than the carrying values as of the valuation date.
|
·
|
Conn’s trade name
|
·
|
Customer lists
|
·
|
Non-competition agreements
|
Royalty rate
|
0.5%
|
1%
|
Revenue
|
$922,000,000
|
$922,000,000
|
Estimated royalty rate saving
|
$4,610,000
|
$9,220,000
|
Estimate royalty rate saving after taxes
|
$2,825,930
|
$5,651,860
|
Capitalization rate
|
9%
|
9%
|
Estimated value of Conn’s trade name (rounded)
|
$31,400,000
|
$62,800,000
|
·
|
The statements of fact contained in this detailed appraisal report are true and correct.
|
·
|
The reported analyses, opinions, and conclusions are limited only by the reported assumptions and limiting conditions, and are our personal, impartial, independent, unbiased, objective professional analyses, opinions, and conclusions.
|
·
|
We have no present or prospective financial or other interest in the business or property that is the subject of this report, and we have no personal financial or other interest with respect to the business, property or parties involved.
|
·
|
We have no bias with respect to the business or property that is the subject of this report or to the parties involved with this assignment.
|
·
|
Our engagement in this assignment was not contingent upon developing or reporting predetermined results.
|
·
|
Our compensation for completing this assignment is fee-based and is not contingent upon the development or reporting of a predetermined value or direction in value that favors the cause of the client, the outcome of this valuation, the amount of the value opinion, the attainment of a stipulated result, or the occurrence of a subsequent event directly related to the intended use of this appraisal.
|
·
|
The economic and industry data included in the valuation report have been obtained from various printed or electronic reference sources that the valuation analyst believes to be reliable. The valuation analyst has not performed any corroborating procedures to substantiate that data.
|
·
|
Our analyses, opinions, conclusions and this comprehensive appraisal report were developed in conformity with the 2008 American Institute of Certified Public Accountants Statement on Standards for Valuation Services No. 1 and the 2008-2009 Uniform Standards of Professional Appraisal Practice as promulgated by the Appraisal Foundation.
|
·
|
The parties for which the information and use of the valuation report is restricted are identified; the valuation report is not intended to be and should not be used by anyone other than such parties.
|
·
|
The valuation analyst has no obligation to update the report or the opinion of value for information that comes to his/her attention after the date of the report.
|
·
|
This report and analysis were prepared under the direction of Todd Patrick with significant professional assistance from Tina Patel.
|
·
|
No one other than the staff of Grant Thornton LLP provided significant professional assistance to the individual(s) signing this report. Biographies of the undersigned follow this certification.
|
_______________________________
|
______________________________
|
Todd Patrick
|
Tina Patel
|
Director, Advisory Services – Valuation
|
Manager, Advisory Services – Valuation
|
·
|
Valuation of an interest of an Oil and Gas Corporation. Performed a valuation of certain partnership units of an 18% interest in a Pennsylvania company. The company was a natural gas producer and unregulated gas distribution company and the valuation was done for estate planning purposes.
|
·
|
SFAS 142 Impairment Testing of Goodwill and Indefinite Lived Intangibles. Valued two reporting units for a publicly held oil and gas corporation for financial reporting purposes. The reporting units consisted of a midstream group and an oil and gas exploration and production division.
|
·
|
SFAS 141 Valuation of Intangible Assets. Assisted a multi-billion dollar semiconductor company with the valuation of intangible assets in relation to its acquisition of a start-up technology
company for financial reporting purposes. The intangible assets valued included patented technology and customer relationships.
|
·
|
SFAS 141 Valuation of Assets. Assisted in international electronics company with the valuation of certain assets in relation to a large acquisition of a data storage technology company for financial reporting purposes. The assets and liabilities valued included in-process research and development, patented technology, trade names, equipment, inventory and deferred revenue.
|
·
|
Compliance with ICA 1940. Assisted an international company that designs and manufactures bar code printers with compliance related to the Investment Company Act of 1940. Valued the company’s patent and trade name portfolio.
|
·
|
Valuation of Intellectual Property. Worked with a large electronics client to identify and value certain acquired intangible assets including in-process research and development, patents and trade names for financial reporting purposes. The team also did a remaining useful life study for each intangible as part of the analysis.
|
·
|
Quest Software, Inc. v. Insite Objects, Inc.; Superior Court of the State of California for the County of Orange (Civil Action No. 01CC00910); deposition testimony May 7, 2002; testified as to the value of Insite Objects proprietary software.
|
·
|
Jin K. Song v. Wise Tech. Co., LTD and Henry B. Shim; American Arbitration Association (Arbitration No. 50T1330006803), Dallas, Texas; hearing testimony May 22, 2003; testified as to the economic damages resulting from product infringement.
|
·
|
Master of Business Administration, Finance and Accounting, University of Chicago Graduate School of Business
|
·
|
Bachelor of Arts, Economics, Baylor University
|
·
|
CFA – Chartered Financial Analyst, Association for Investment Management & Research (AIMR)
|
·
|
Investment Analysts Society of Dallas
|
·
|
Association for Investment Management & Research (AIMR)
|
·
|
“Valuing In-Process Research and Development” American Society of Appraisers (Milwaukee Chapter) – October 2000
|
·
|
“Fairness Opinions: The Final Expert’s View” – Jenkins& Gilchrist P.C., Continuing Legal Education Program – August 2002
|
·
|
“Employee Stock Options” – Horn, Muroch and Cole, Continuing Professional Education Program – October 2003
|
·
|
“Valuing Privately-Held Securities” – Wilson Sonsini Goodrich & Rosati – September 2007
|
·
|
“Valuing a Closely-Held Business in Challenging Economic Times” – University of Houston CLE Seminar – January 2009
|
·
|
“The Biggest Valuation Mistakes Made During an Economic Downturn” – Grant Thornton LLP Perfect Storm Seminar – March 2009
|
Contact details
|
1717 Main Street, Suite # 1500
|
Dallas, Texas 75201
|
T: 214.283.8195
|
F: 214.561.2370
|
E: Todd.Patrick@gt.com
|
·
|
Equity valuations of a secondary private equity firm and a wind farm energy company
|
·
|
Intellectual property valuations of two publishing brands
|
·
|
Fairness opinion for a transfer of private equity investments between two listed entities
|
·
|
Intangible asset valuations for financial reporting purposes of a financial services company and three consulting companies
|
·
|
ACA, Institute of Chartered Accountants in England & Wales (ICAEW)
|
·
|
Member of the Valuation Special Interest Group of the ICAEW
|
·
|
Candidate Member, American Society of Appraisers
|
Contact details
|
175 West Jackson Blvd., 20th Floor
|
Chicago, IL 60604
|
T: 312.602.9130
|
F: 312.602.8025
|
E: Tina.Patel@gt.com
|
1.
|
The conclusion/opinion of value arrived at herein pertains only to the subject business, the stated value standard (fair market value), as of the stated valuation date, and only for the stated valuation purpose(s).
|
2.
|
Financial statements and other related information provided by the Company or its representatives, in the course of this engagement, have been accepted without any verification as fully and correctly reflecting the enterprise’s business conditions and operating results for the respective periods, except as specifically noted herein. Grant Thornton has not audited, reviewed, or compiled the financial information provided to us and, accordingly, we express no audit opinion or any other form of assurance on this information.
|
3.
|
Public information and industry and statistical information have been obtained from sources we believe to be reliable. However, we make no representation as to the accuracy or completeness of such information and have performed no procedures to corroborate the information.
|
4.
|
If prospective financial information approved by management has been used in our work, we have not examined or compiled the prospective financial information and therefore, do not express an audit opinion or any other form of assurance on the prospective financial information or the related assumptions. Events and circumstances frequently do not occur as expected; achievement of the forecast results is dependent on actions, plans, and assumptions of management.
|
5.
|
The conclusion of value arrived at herein is based on the assumption that the current level of management expertise and effectiveness would continue to be maintained and that the character and integrity of the enterprise through any sale, reorganization, exchange, or diminution of the owners’ participation would not be materially or significantly changed.
|
6.
|
This report and the conclusion of value arrived at herein are for the exclusive use of our client for the sole and specific purposes as noted herein. The report may be used internally by Company management and may be made available to the Company’s legal advisors, tax advisors, or regulatory authorities consistent with the purpose of this engagement. The report is not to be used for other purposes or be shared with other parties without our prior written consent.
|
7.
|
Grant Thornton LLP will not provide consent to be a named expert in any filings, including, without limitation, any filings with the U.S. Securities and Exchange Commission under the Securities Act of 1933 or the Securities Exchange Act of 1934, as amended.
|
8.
|
The report and conclusion of value are not intended by the author and should not be construed by the reader to be investment advice in any manner whatsoever. The conclusion of value represents the considered opinion of Grant Thornton, based on information furnished to them by the Company and other sources.
|
9.
|
Neither all nor any part of the contents of this report (especially the conclusion of value, the identity of any valuation specialist(s), or the firm with which such valuation specialists are connected or any reference to any of their professional designations) should be disseminated to the public through advertising media, public relations, news media, sales media, mail, direct transmittal, or any other means of communication, including but not limited to the SEC or other governmental agency, without the prior written consent and approval of Grant Thornton.
|
10.
|
Future services regarding the subject matter of this report, including, but not limited to testimony or attendance in court, shall not be required of Grant Thornton unless previous arrangements have been made in writing.
|
11.
|
Grant Thornton is not an environmental consultant or auditor, and it takes no responsibility for any actual or potential environmental liabilities. Any person entitled to rely on this report, wishing to know whether such liabilities exist, or the scope and their effect on the value of the property, is encouraged to obtain a professional environmental assessment. Grant Thornton does not conduct or provide environmental assessments and has not performed one for the subject property.
|
12.
|
Grant Thornton has not determined independently whether the Company is subject to any present or future liability relating to environmental matters (including, but not limited to CERCLA/Superfund liability) or the scope of any such liabilities. Grant Thornton’s valuation takes no such liabilities into account, except as they have been reported to Grant Thornton by the Company or by an environmental consultant working for the Company, and then only to the extent that the liability was reported to us in an actual or estimated dollar amount. Such matters, if any, are noted in the report. To the extent such information has been reported to us, Grant Thornton has relied on it without verification and offers no warranty or representation as to its accuracy or completeness.
|
13.
|
Grant Thornton has not made a specific compliance survey or analysis of the subject property to determine whether it is subject to, or in compliance with, the American Disabilities Act of 1990, and this valuation does not consider the effect, if any, of noncompliance.
|
14.
|
No change of any item in this appraisal report shall be made by anyone other than Grant Thornton, and we shall have no responsibility for any such unauthorized change.
|
15.
|
Unless otherwise stated, no effort has been made to determine the possible effect, if any, on the subject business due to future Federal, state, or local legislation, including any environmental or ecological matters or interpretations thereof.
|
16.
|
We have conducted interviews with the current management of the Company concerning the past, present, and prospective operating results of the company.
|
17.
|
Except as noted, we have relied on the representations of the owners, management, and other third parties concerning the value and useful condition of all equipment, real estate, investments used in the business, and any other assets or liabilities, except as specifically stated to the contrary in this report. We have not attempted to confirm whether or not all assets of the business are free and clear of liens and encumbrances or that the entity has good title to all assets.
|
18.
|
Unless otherwise stated in the appraisal, the valuation of the business has not considered or incorporated the potential economic gain or loss resulting from contingent assets, liabilities or events existing as of the valuation date.
|
19.
|
We have no responsibility or obligation to update this report for events or circumstances occurring subsequent to the date of this report.
|
20.
|
Unless stated otherwise in this report, we express no opinion as to: 1) the tax consequences of any transaction which may result, 2) the effect of the tax consequences of any net value received or to be received as a result of a transaction, and 3) the possible impact on the market value resulting from any need to effect a transaction to pay taxes.
|
21.
|
Our work was performed and this letter/report is in compliance with the reporting standards under the AICPA’s Statement on Standards for Valuation Services No. 1.
|
Conn's, Inc.
|
Schedule 1 | ||
Impairment Analysis, Step 1
|
Final
|
||
Valuation Summary
|
Valuation Date: September 30, 2009 |
US$ in $000s
|
||||
Fair Value
|
||||
Indication of
|
||||
Invested Capital
|
||||
Market Approach:
|
||||
Guideline Public Company Method - Control, Marketable Basis (1)
|
$ | 428,000 | ||
Income Approach:
|
||||
Discounted Cash Flow Method - Control, Marketable Basis (2)
|
410,000 | |||
Indicated Fair Value of Invested Capital
|
415,000 | |||
Less: Interest Bearing Debt
|
(149,374 | ) | ||
Indicated Fair Value of Equity
|
$ | 266,000 | ||
Market Capitalization as of Valuation Date
|
$ | 254,000 | ||
Implied Control Premium
|
4.7 | % | ||
Footnotes:
|
|||||||
(1)
|
Per Schedule 4.
|
||||||
(2)
|
Per Schedule 2.
|
Conn's, Inc.
|
Schedule 2 | |
Impairment Analysis, Step 1
|
Final | |
Income Approach: Discounted Debt-Free Cash Flow ("DCF") Method - Stock Transaction
|
Valuation Date: September 30, 2009 |
US$ in $000s
|
||||||||||||||||||||||||||||
4.0 Months
|
||||||||||||||||||||||||||||
Jan 31, '10
|
Jan 31, '11
|
Jan 31, '12
|
Jan 31, '13
|
Jan 31, '14
|
Terminal
|
|||||||||||||||||||||||
% Revenue Growth Rate
|
(2.4 | %) | 4.1 | % | 4.2 | % | 6.3 | % | 6.6 | % | 3.0 | % | ||||||||||||||||
Net Revenue
|
$ | 287,175 | $ | 905,405 | $ | 943,466 | $ | 1,002,758 | $ | 1,068,659 | $ | 1,100,719 | ||||||||||||||||
Cost of Goods Sold
|
187,717 | 588,916 | 610,218 | 638,362 | 673,318 | 693,518 | ||||||||||||||||||||||
Gross Profit
|
99,458 | 316,489 | 333,247 | 364,395 | 395,341 | 407,201 | ||||||||||||||||||||||
Gross Profit Margin
|
34.6 | % | 35.0 | % | 35.3 | % | 36.3 | % | 37.0 | % | 37.0 | % | ||||||||||||||||
Operating Expenses:
|
||||||||||||||||||||||||||||
Selling General & Admin Exp.
|
90,114 | 246,165 | 254,414 | 265,793 | 280,818 | 289,243 | ||||||||||||||||||||||
Provision for Bad Debts
|
1,743 | 6,428 | 12,656 | 30,745 | 25,778 | 26,551 | ||||||||||||||||||||||
Depreciation
|
4,933 | 14,935 | 15,383 | 15,845 | 16,320 | 12,360 | ||||||||||||||||||||||
Amortization
|
221 | 656 | 656 | 656 | 365 | - | ||||||||||||||||||||||
Total Operating Expenses
|
97,011 | 268,184 | 283,109 | 313,039 | 323,281 | 328,154 | ||||||||||||||||||||||
Operating Expense Margin
|
33.8 | % | 29.6 | % | 30.0 | % | 31.2 | % | 30.3 | % | 29.8 | % | ||||||||||||||||
Earnings Before Interest & Taxes (EBIT)
|
$ | 2,448 | $ | 48,305 | $ | 50,138 | $ | 51,357 | $ | 72,060 | $ | 79,047 | ||||||||||||||||
EBIT Margin
|
0.9 | % | 5.3 | % | 5.3 | % | 5.1 | % | 6.7 | % | 7.2 | % | ||||||||||||||||
Blended Income Taxes
|
(946 | ) | (18,679 | ) | (19,388 | ) | (19,859 | ) | (27,865 | ) | (30,567 | ) | ||||||||||||||||
Blended Income Tax Rate
|
38.7 | % | 38.7 | % | 38.7 | % | 38.7 | % | 38.7 | % | 38.7 | % | ||||||||||||||||
Debt-Free Net Income
|
$ | 1,501 | $ | 29,626 | $ | 30,750 | $ | 31,497 | $ | 44,195 | $ | 48,480 | ||||||||||||||||
Cash Flow Adjustments (1):
|
||||||||||||||||||||||||||||
Depreciation
|
4,933 | 14,935 | 15,383 | 15,845 | 16,320 | 12,360 | ||||||||||||||||||||||
Amortization
|
221 | 656 | 656 | 656 | 365 | - | ||||||||||||||||||||||
Capital Expenditures
|
(4,044 | ) | (10,000 | ) | (12,000 | ) | (12,000 | ) | (12,000 | ) | (12,360 | ) | ||||||||||||||||
Net Change in Non-Cash Working Capital
|
1,704 | 1,285 | (1,599 | ) | (4,164 | ) | (8,904 | ) | (8,160 | ) | ||||||||||||||||||
Debt-Free Cash Flow
|
$ | 4,315 | $ | 36,502 | $ | 33,190 | $ | 31,834 | $ | 39,976 | $ | 40,320 | ||||||||||||||||
Partial Period Factor
|
1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |||||||||||||||||||||||
Discount Period
|
0.17 | 0.84 | 1.84 | 2.84 | 3.84 | |||||||||||||||||||||||
Present Value Factor
|
12.0 | % | 0.9811 | 0.9095 | 0.8121 | 0.7251 | 0.6474 | |||||||||||||||||||||
Present Value of Debt-Free Cash Flows
|
$ | 4,233 | $ | 33,199 | $ | 26,952 | $ | 23,081 | $ | 25,879 | ||||||||||||||||||
Terminal Growth Rate
|
3.0 | % | ||||||||||||||||||||||||||
Sum of the Present Value of Discrete Year Cash Flows
|
$ | 113,345 |
Residual Value at Terminal Year
|
$ | 448,005 | |||||||||||||||||||||||
Present Value of Terminal Cash Flow
|
290,024 |
Present Value Factor
|
0.6474 | |||||||||||||||||||||||||
Indicated Enterprise Value from Operations
|
$ | 403,369 |
Present Value of Terminal Cash Flow
|
$ | 290,024 | |||||||||||||||||||||||
Add: Cash & Cash Equivalents
|
6,226 |
Implied Exit Multiple of EBITDA
|
5.1 | x | ||||||||||||||||||||||||
Indicated Enterprise Value - Control, Marketable Basis
|
$ | 410,000 | ||||||||||||||||||||||||||
Footnote:
|
|||||||||||||||
(1)
|
Source: Conn's management.
|
Schedule 3
|
|
Impairment Analysis, Step 1
|
Final
|
Beta, Capital Asset Pricing Model ("CAPM") & Weighted Average Cost of Capital ("WACC") Analyses
|
Valuation Date: September 30, 2009
|
US$ in $000s, except per share amounts
|
||||||||||||||||||||||||||||||||||||||||||||
5 Year
|
||||||||||||||||||||||||||||||||||||||||||||
Market
|
Market
|
Market
|
Effective
|
5 Year
|
Monthly
|
|||||||||||||||||||||||||||||||||||||||
Total
|
Month End
|
Total
|
Value of
|
Value of
|
Value of
|
Income
|
Monthly
|
Asset
|
||||||||||||||||||||||||||||||||||||
Selected Public
|
Total
|
Preferred
|
Stock
|
Shares
|
Common
|
Total
|
Debt to
|
Debt to
|
Tax
|
Equity
|
Raw Beta
|
|||||||||||||||||||||||||||||||||
Guideline Companies (1)
|
Debt
|
Equity
|
Price
|
Outstanding
|
Equity
|
Capital
|
Equity
|
Capital (Wd)
|
Rate
|
Raw Beta
|
(Ba)
|
|||||||||||||||||||||||||||||||||
Conns Inc.
|
$ | 130,526 | $ | - | $ | 11.29 | 22,457 | $ | 253,540 | $ | 384,066 | 51.5 | % | 34.0 | % | 39.2 | % | 1.02 | 0.77 | |||||||||||||||||||||||||
Best Buy Co. Inc.
|
2,247,000 | - | 37.52 | 416,359 | 15,621,790 | 17,868,790 | 14.4 | % | 12.6 | % | 41.8 | % | 1.33 | 1.22 | ||||||||||||||||||||||||||||||
Aaron's, Inc.
|
81,113 | - | 26.40 | 54,244 | 1,432,036 | 1,513,149 | 5.7 | % | 5.4 | % | 38.1 | % | 0.60 | 0.58 | ||||||||||||||||||||||||||||||
Rent-A-Center Inc.
|
776,144 | - | 18.88 | 66,041 | 1,246,854 | 2,022,998 | 62.2 | % | 38.4 | % | 37.2 | % | 0.72 | 0.52 | ||||||||||||||||||||||||||||||
RadioShack Corp.
|
720,100 | - | 16.57 | 125,174 | 2,074,133 | 2,794,233 | 34.7 | % | 25.8 | % | 37.4 | % | 1.85 | 1.52 | ||||||||||||||||||||||||||||||
hhgregg, Inc.
|
92,381 | - | 16.94 | 37,218 | 630,473 | 722,854 | 14.7 | % | 12.8 | % | 41.7 | % | 1.30 | 1.20 | ||||||||||||||||||||||||||||||
High
|
$ | 2,247,000 | $ | - | $ | 37.52 | 416,359 | $ | 15,621,790 | $ | 17,868,790 | 62.2 | % | 38.4 | % | 41.8 | % | 1.85 | 1.52 | |||||||||||||||||||||||||
Low
|
$ | 81,113 | $ | - | $ | 11.29 | 22,457 | $ | 253,540 | $ | 384,066 | 5.7 | % | 5.4 | % | 37.2 | % | 0.60 | 0.52 | |||||||||||||||||||||||||
Mean
|
$ | 674,544 | $ | - | $ | 21.27 | 120,249 | $ | 3,543,138 | $ | 4,217,682 | 30.5 | % | 21.5 | % | 39.2 | % | 1.13 | 0.97 | |||||||||||||||||||||||||
Median
|
$ | 425,313 | $ | - | $ | 17.91 | 60,142 | $ | 1,339,445 | $ | 1,768,074 | 24.7 | % | 19.3 | % | 38.7 | % | 1.16 | 0.99 | |||||||||||||||||||||||||
Selected as Most Comparable to Subject Company
|
23.9 | % | 19.3 | % | 38.7 | % | 0.99 |
Cost of Equity Calculation:
|
Source:
|
||||||||
Risk-Free Rate (Rf)
|
4.0%
|
Risk-free rate of return (20-year Treasury Bond yield) as of September 30, 2009 as published in Federal Reserve Statistical Release, H.15.
|
|||||||
Plus Equity Premiums:
|
|||||||||
Equity Risk Premium (Rm-Rf)
|
5.75%
|
The expected return of the market in excess of the risk-free rate (2)
|
|||||||
Relevered Equity Beta (Be)
|
1.14
|
Be = Ba x [ 1 + (Wd / We) x ( 1 - T )]
|
|||||||
Industry - Adjusted Equity Risk Premium
|
6.5%
|
Be (Rm - Rf)
|
|||||||
Size Premium (SP)
|
2.7%
|
2009 Ibbotson SBBI Valuation Yearbook, Morningstar, Inc.: 9th decile
|
|||||||
Additional Risk Premium (ARP)
|
1.0%
|
Additional risk premium based on perceived uncertainties associated with operating forecast
|
|||||||
Cost of Equity (Re) Discount Rate (rounded)
|
14.0%
|
Re = Rf + Be (Rm - Rf) + SP + ARP + CRP
|
|||||||
Cost of Debt Calculation:
|
|||||||||
Pre-Tax Weighted Cost of Debt
|
6.2%
|
Moody's Baa Interest Rate as of September 30, 2009
|
|||||||
Estimated Tax Rate
|
38.7%
|
||||||||
After-Tax Cost of Debt (Rd)
|
3.8%
|
Rd = Rd (1 - T)
|
|||||||
Weighted Average Cost Of Capital Calculation:
|
|||||||||
Debt % of Capital
|
19.3%
|
Wd
|
|||||||
Cost of Debt
|
3.8%
|
Rd
|
|||||||
Weighted Cost of Debt
|
0.7%
|
Wd x Rd
|
|||||||
Equity % of Capital
|
80.7%
|
We
|
|||||||
Cost of Equity
|
14.0%
|
Re
|
|||||||
Weighted Cost of Equity
|
11.3%
|
We x Re
|
|||||||
Weighted Average Cost of Capital (rounded)
|
12.0%
|
||||||||
Less Long-term Sustainable Growth Rate (G)
|
(3.0%)
|
Based on a combination of the Company's and its Industry's historical and potential growth rates, and the overall economic environment in which it competes.
|
|||||||
Capitalization Rate (rounded)
|
9.0%
|
||||||||
Footnotes:
|
|||
(1) |
Source: Capital IQ.
|
||
(2) |
The estimated Equity Risk Premium (ERP) of 5.75 percent, which equals Rm - Rf, incorporates perspective provided by recent long-term market return studies and historical data compiled by Morningstar (formerly Ibbotson Associates).
|
||
Please refer to the narrative report for additional detail.
|
Schedule 4
|
|
Impairment Analysis, Step 1
|
Final
|
Market Approach: Guideline Public Company Method - Indication of Value
|
Valuation Date: September 30, 2009
|
US$ in
$000s |
|||||||||||||||||||||||||||||||||
Cash
|
Cash
|
||||||||||||||||||||||||||||||||
|
|
Add:
|
-Adjusted
|
|
-Adjusted
|
||||||||||||||||||||||||||||
Selected
|
Conn's
Financial |
Preliminary
Enterprise |
Cash
& Cash |
Enterprise
Value |
Less: Interest-
Bearing |
Equity
Value |
|||||||||||||||||||||||||||
Valuation Multiples
|
Weighting
|
Multiple
|
Statistic (1) (2)
|
Value (3)
|
Equivalents
|
(Minority)
|
Debt
|
(Minority)
|
|||||||||||||||||||||||||
Trailing Twelve Months:
|
|||||||||||||||||||||||||||||||||
Cash-Adjusted Enterprise Value / Revenue
|
33.3 | % | 0.4 | x | $ | 921,771 | $ | 396,688 | $ | 6,226 | $ | 402,914 | $ | 149,374 | $ | 253,540 | |||||||||||||||||
Cash-Adjusted Enterprise Value / EBITDA
|
33.3 | % | 5.9 | x | $ | 67,373 | $ | 396,688 | $ | 6,226 | $ | 402,914 | $ | 149,374 | $ | 253,540 | |||||||||||||||||
Cash-Adjusted Enterprise Value / EBIT
|
33.3 | % | 7.4 | x | $ | 53,913 | $ | 396,688 | $ | 6,226 | $ | 402,914 | $ | 149,374 | $ | 253,540 | |||||||||||||||||
Weighted Indicated Fair Value - Minority, Marketable Basis
|
$ | 397,000 | $ | 403,000 | $ | 254,000 | |||||||||||||||||||||||||||
Add: Control Premium
|
10.0 | % | 24,763 | ||||||||||||||||||||||||||||||
Weighted Adjusted Fair Value of Equity - Control, Marketable Basis
|
$ | 279,000 | |||||||||||||||||||||||||||||||
Add: Interest-Bearing Debt
|
149,374 | ||||||||||||||||||||||||||||||||
Weighted Adjusted Fair Value of Invested Capital - Control, Marketable Basis
|
$ | 428,000 | |||||||||||||||||||||||||||||||
Footnotes:
|
|||
(1) |
Income statement items are taken from Income Statement as of September 30, 2009 for the trailing twelve months.
|
||
(2) |
The non-cash fair value adjustment to "interests in securitized assets" was added back to Conn's financial statistics.
|
||
(3) |
Valuation Multiple x Financial Statistic.
|
Schedule 5
|
|||
Impairment Analysis, Step 1
|
Final
|
||
Market Approach: Guideline Public Company Method - Comparative Valuation Multiples
|
Valuation Date: September 30, 2009 |
US$ in $000s,
except per share |
|||||||||||||||||||||||||||||||||||||||
Company Name:
|
Conns Inc.
|
Best Buy
Co. Inc. |
Aaron's, Inc.
|
Rent-A-
Center Inc. |
RadioShack Corp.
|
hhgregg, Inc.
|
|||||||||||||||||||||||||||||||||
Ticker Symbol:
|
NasdaqGS:
CONN |
NYSE:
BBY |
NYSE:
AAN |
NasdaqGS:
RCII |
NYSE:
RSH |
NYSE:
HGG |
|||||||||||||||||||||||||||||||||
Last Fiscal Year End:
|
Coefficient
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||
Trailing Twelve Months:
|
High
|
75th
Percentile |
25th
Percentile |
Low
|
Mean
|
Median
|
of
Variation |
Jan 31, '09
Jul 31, '09 |
Feb 28, '09
Aug 29, '09 |
Dec 31, '08
Jun 30, '09 |
Dec 31, '08
Jun 30, '09 |
Dec 31, '08
Jun 30, '09 |
Mar 31, '09
Jun 30, '09 |
||||||||||||||||||||||||||
Select Market Data:
|
|||||||||||||||||||||||||||||||||||||||
Market Price (1)
|
NM
|
NM
|
NM
|
NM
|
NM
|
NM
|
NM
|
$ | 11.29 | $ | 37.52 | $ | 26.40 | $ | 18.88 | $ | 16.57 | $ | 16.94 | ||||||||||||||||||||
x Shares Outstanding (000s)
|
NM
|
NM
|
NM
|
NM
|
NM
|
NM
|
NM
|
22,457 | 416,359 | 54,244 | 66,041 | 125,174 | 37,218 | ||||||||||||||||||||||||||
= Market Value of Common Equity
|
$ | 15,621,790 | $ | 1,913,609 | $ | 784,568 | $ | 253,540 | $ | 3,543,138 | $ | 1,339,445 | 1.7 | $ | 253,540 | $ | 15,621,790 | $ | 1,432,036 | $ | 1,246,854 | $ | 2,074,133 | $ | 630,473 | ||||||||||||||
+ Preferred Stock
|
NM
|
NM
|
NM
|
NM
|
NM
|
NM
|
NM
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
||||||||||||||||||||||||||
= Adjusted Market Value of Stockholders' Equity
|
$ | 15,621,790 | $ | 1,913,609 | $ | 784,568 | $ | 253,540 | $ | 3,543,138 | $ | 1,339,445 | 1.7 | $ | 253,540 | $ | 15,621,790 | $ | 1,432,036 | $ | 1,246,854 | $ | 2,074,133 | $ | 630,473 | ||||||||||||||
+ Minority Interest
|
$ | - |
NA
|
NA
|
$ | - |
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
||||||||||||||||||||||||
+ Total Interest-Bearing Debt
|
$ | 2,247,000 | $ | 762,133 | $ | 101,917 | $ | 81,113 | $ | 674,544 | $ | 425,313 | 1.2 | $ | 130,526 | $ | 2,247,000 | $ | 81,113 | $ | 776,144 | $ | 720,100 | $ | 92,381 | ||||||||||||||
- Cash & Cash Equivalents
|
$ | 930,800 | $ | 527,899 | $ | 27,941 | $ | 4,852 | $ | 299,337 | $ | 89,437 | 1.3 | $ | 4,852 | $ | 672,000 | $ | 83,279 | $ | 95,595 | $ | 930,800 | $ | 9,495 | ||||||||||||||
= Market Value of Cash-Adjusted Enterprise Value
|
$ | 17,196,790 | $ | 1,911,411 | $ | 892,487 | $ | 379,214 | $ | 3,918,345 | $ | 1,646,652 | 1.7 | $ | 379,214 | $ | 17,196,790 | $ | 1,429,870 | $ | 1,927,403 | $ | 1,863,433 | $ | 713,359 | ||||||||||||||
Beta - 5 Year, Monthly
|
1.85 | 1.32 | 0.79 | 0.60 | 1.13 | 1.16 | 0.40 | 1.02 | 1.33 | 0.60 | 0.72 | 1.85 | 1.30 | ||||||||||||||||||||||||||
Beta - 2 Year, Weekly
|
1.82 | 1.06 | 0.87 | 0.75 | 1.01 | 0.95 | 0.26 | 1.33 | 1.40 | 1.00 | 1.15 | 1.24 | 1.17 | ||||||||||||||||||||||||||
Price Multiples:
|
|||||||||||||||||||||||||||||||||||||||
Cash-Adjusted Enterprise Value / Revenue
|
|||||||||||||||||||||||||||||||||||||||
NTM Consensus
|
0.8 | x | 0.6 | x | 0.4 | x | 0.3 | x | 0.5 | x | 0.5 | x | 0.3 | 0.4 | x | 0.3 | x | 0.8 | x | 0.7 | x | 0.4 | x | 0.5 | x | ||||||||||||||
TTM
|
0.9 | x | 0.6 | x | 0.4 | x | 0.4 | x | 0.5 | x | 0.5 | x | 0.3 | 0.4 | x | 0.4 | x | 0.9 | x | 0.7 | x | 0.4 | x | 0.5 | x | ||||||||||||||
Cash-Adjusted Enterprise Value / EBITDA
|
|||||||||||||||||||||||||||||||||||||||
NTM Consensus
|
8.3 | x | 6.1 | x | 4.9 | x | 4.5 | x | 5.8 | x | 5.5 | x | 0.2 | 4.8 | x | 5.7 | x | 6.2 | x | 5.4 | x | 4.5 | x | 8.3 | x | ||||||||||||||
TTM
|
8.4 | x | 7.2 | x | 5.6 | x | 4.1 | x | 6.3 | x | 6.4 | x | 0.2 | 7.3 | x | 5.8 | x | 6.9 | x | 5.5 | x | 4.1 | x | 8.4 | x | ||||||||||||||
Cash-Adjusted Enterprise Value / EBIT
|
|||||||||||||||||||||||||||||||||||||||
NTM Consensus
|
10.8 | x | 7.9 | x | 5.9 | x | 5.6 | x | 7.4 | x | 7.2 | x | 0.3 | 5.6 | x | 7.9 | x | 7.7 | x | 6.7 | x | 5.6 | x | 10.8 | x | ||||||||||||||
TTM
|
10.4 | x | 9.7 | x | 7.4 | x | 5.2 | x | 8.3 | x | 8.6 | x | 0.2 | 10.1 | x | 8.5 | x | 8.6 | x | 7.1 | x | 5.2 | x | 10.4 | x |
Footnotes:
|
|||||||||||||||
(1)
|
As of September 30, 2009
|
||||||||||||||
(2)
|
Source: Capital IQ
|
Schedule 6
|
|
Impairment Analysis, Step 1
|
Final
|
Market Approach: Guideline Public Company Method - Comparative Historical Financial Ratios
|
Valuation Date: September 30, 2009 |
Company Name:
|
Conns Inc.
|
Best Buy
Co. Inc. |
Aaron's, Inc.
|
Rent-A-
Center Inc. |
RadioShack Corp.
|
hhgregg, Inc.
|
|||||||
Ticker Symbol:
|
NasdaqGS:
CONN |
NYSE:
BBY |
NYSE:
AAN |
NasdaqGS:
RCII |
NYSE:
RSH |
NYSE:
HGG |
|||||||
Last Fiscal Year End:
|
75th
|
25th
|
Jan 31, '09
|
Feb 28, '09
|
Dec 31, '08
|
Dec 31, '08
|
Dec 31, '08
|
Mar 31, '09
|
|||||
Trailing Twelve Months:
|
High
|
Percentile
|
Percentile
|
Low
|
Mean
|
Median
|
Jul 31, '09
|
Aug 29, '09
|
Jun 30, '09
|
Jun 30, '09
|
Jun 30, '09
|
Jun 30, '09
|
|
Liquidity Ratios:
|
|||||||||||||
Current Ratio
|
4.2
|
3.0
|
1.0
|
0.5
|
2.0
|
1.4
|
4.2
|
1.0
|
1.1
|
0.5
|
3.4
|
1.7
|
|
Quick Ratio
|
2.2
|
1.1
|
0.3
|
0.1
|
0.8
|
0.6
|
1.2
|
0.3
|
0.8
|
0.4
|
2.2
|
0.1
|
|
Leverage Ratios:
|
|||||||||||||
Interest Coverage Before Tax
|
(4.3)
|
(7.6)
|
(14.2)
|
(27.5)
|
(12.5)
|
(10.4)
|
(12.6)
|
(14.8)
|
(27.5)
|
(4.3)
|
(7.4)
|
(8.3)
|
|
Interest Coverage After Tax
|
(2.3)
|
(4.3)
|
(7.7)
|
(16.6)
|
(7.1)
|
(5.8)
|
(7.2)
|
(7.9)
|
(16.6)
|
(2.3)
|
(4.3)
|
(4.4)
|
|
Long-Term Debt / Equity
|
0.7
|
0.7
|
0.2
|
0.1
|
0.4
|
0.5
|
0.4
|
0.2
|
0.1
|
0.7
|
0.7
|
0.7
|
|
Total Debt / Invested Capital
|
-
|
NA
|
NA
|
-
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
Total Debt / Total Assets
|
0.3
|
0.3
|
0.2
|
0.1
|
0.2
|
0.2
|
0.2
|
0.1
|
0.1
|
0.3
|
0.3
|
0.3
|
|
Total Liabilities / Equity
|
1.9
|
1.7
|
0.8
|
0.5
|
1.2
|
1.2
|
0.7
|
1.9
|
0.5
|
1.1
|
1.3
|
1.8
|
|
Total Debt / Total Capitalization
|
0.4
|
0.4
|
0.3
|
0.1
|
0.3
|
0.3
|
0.3
|
0.3
|
0.1
|
0.4
|
0.4
|
0.4
|
|
Total Debt / Total Market Capitalization
|
0.4
|
0.4
|
0.1
|
0.1
|
0.2
|
0.2
|
0.3
|
0.1
|
0.1
|
0.4
|
0.4
|
0.1
|
|
Operating Efficiency Ratios:
|
|||||||||||||
Revenue / Total Assets
|
3.8
|
2.5
|
1.4
|
1.2
|
2.1
|
1.7
|
1.5
|
2.8
|
1.3
|
1.2
|
1.9
|
3.8
|
|
Revenue / Receivables
|
213.9
|
46.0
|
22.2
|
7.8
|
59.0
|
30.9
|
7.8
|
26.7
|
35.1
|
49.7
|
20.7
|
213.9
|
|
Receivable Turnover (Days)
|
46.7
|
16.6
|
8.1
|
1.7
|
16.2
|
12.0
|
46.7
|
13.6
|
10.4
|
7.3
|
17.6
|
1.7
|
|
NCDFWC as % of Revenue
|
35.9%
|
8.4%
|
(1.7%)
|
(9.2%)
|
6.7%
|
3.4%
|
35.9%
|
1.5%
|
(2.8%)
|
(9.2%)
|
9.5%
|
5.3%
|
|
COGS / Inventory
|
579.6
|
6.2
|
6.0
|
4.1
|
120.4
|
6.0
|
6.0
|
6.2
|
NA
|
579.6
|
4.1
|
6.0
|
|
Inventory Turnover (Days)
|
90.1
|
61.2
|
58.8
|
0.6
|
54.4
|
61.2
|
61.2
|
58.8
|
NA
|
0.6
|
90.1
|
61.2
|
|
COGS / Payables
|
25.3
|
13.2
|
8.0
|
5.7
|
12.7
|
12.5
|
12.6
|
6.6
|
5.7
|
25.3
|
12.3
|
13.4
|
|
Payable Turnover (Days)
|
64.5
|
49.0
|
27.7
|
14.4
|
36.7
|
29.3
|
28.9
|
55.4
|
64.5
|
14.4
|
29.6
|
27.2
|
|
Profitability Ratios:
|
|||||||||||||
Return on Assets
|
9.8%
|
8.9%
|
5.6%
|
3.6%
|
7.1%
|
7.3%
|
3.6%
|
5.4%
|
8.4%
|
6.3%
|
9.1%
|
9.8%
|
|
Return on Equity
|
27.3%
|
19.9%
|
12.7%
|
6.1%
|
16.0%
|
14.4%
|
6.1%
|
15.8%
|
12.6%
|
13.1%
|
21.2%
|
27.3%
|
|
Return on Invested Capital
|
16.0%
|
12.0%
|
8.8%
|
4.4%
|
10.6%
|
11.5%
|
4.4%
|
11.5%
|
11.5%
|
7.8%
|
12.1%
|
16.0%
|
|
Return on Market Value of Equity
|
12.3%
|
9.5%
|
6.3%
|
5.7%
|
8.3%
|
7.9%
|
8.4%
|
6.0%
|
7.3%
|
12.3%
|
9.8%
|
5.7%
|
|
Return on Market Value of Invested Capital
|
11.0%
|
7.8%
|
5.5%
|
5.0%
|
7.1%
|
6.5%
|
5.6%
|
5.4%
|
7.3%
|
7.9%
|
11.0%
|
5.0%
|
|
EBITDA Margin
|
12.5%
|
12.0%
|
6.1%
|
5.7%
|
8.9%
|
8.4%
|
5.7%
|
6.2%
|
12.4%
|
12.5%
|
10.7%
|
6.1%
|
|
EBIT Margin
|
9.9%
|
9.4%
|
4.4%
|
4.2%
|
6.9%
|
6.7%
|
4.2%
|
4.3%
|
9.9%
|
9.7%
|
8.4%
|
5.0%
|
|
Pretax Profit Margin
|
10.0%
|
8.4%
|
4.0%
|
3.5%
|
6.4%
|
6.1%
|
3.9%
|
3.5%
|
10.0%
|
8.6%
|
7.7%
|
4.4%
|
|
Net Profit Margin
|
6.2%
|
5.3%
|
2.4%
|
2.0%
|
3.9%
|
3.7%
|
2.4%
|
2.0%
|
6.2%
|
5.4%
|
4.8%
|
2.6%
|
|
Revenue Growth:
|
|||||||||||||
Trailing Twelve Months
|
5.8%
|
4.3%
|
(0.5%)
|
(2.4%)
|
1.7%
|
1.1%
|
1.6%
|
5.2%
|
5.8%
|
(2.4%)
|
0.6%
|
(0.8%)
|
|
Latest Fiscal Year
|
14.2%
|
12.1%
|
1.5%
|
(0.8%)
|
7.4%
|
9.6%
|
8.1%
|
12.5%
|
14.2%
|
(0.8%)
|
(0.6%)
|
11.1%
|
|
Five-year CAGR
|
11.4%
|
11.1%
|
5.2%
|
(4.4%)
|
6.7%
|
8.5%
|
6.6%
|
11.3%
|
10.5%
|
4.8%
|
(4.4%)
|
11.4%
|
|
Net Income Growth:
|
|||||||||||||
Trailing Twelve Months
|
16.5%
|
8.6%
|
(5.7%)
|
(16.9%)
|
1.1%
|
2.2%
|
(16.9%)
|
(7.0%)
|
16.5%
|
9.5%
|
6.1%
|
(1.7%)
|
|
Latest Fiscal Year
|
83.1%
|
56.0%
|
(26.2%)
|
(35.3%)
|
13.9%
|
(3.2%)
|
(35.3%)
|
(28.7%)
|
12.4%
|
83.1%
|
(18.8%)
|
70.5%
|
|
Five-year CAGR
|
16.0%
|
10.3%
|
(6.1%)
|
(15.1%)
|
0.9%
|
(0.9%)
|
(15.1%)
|
(4.9%)
|
16.0%
|
3.0%
|
(6.5%)
|
12.7%
|
|
EBITDA Growth:
|
|||||||||||||
Trailing Twelve Months
|
15.3%
|
6.4%
|
(2.2%)
|
(6.4%)
|
2.8%
|
1.5%
|
(6.4%)
|
4.8%
|
15.3%
|
(2.4%)
|
6.9%
|
(1.7%)
|
|
Latest Fiscal Year
|
16.4%
|
5.5%
|
(14.2%)
|
(23.4%)
|
(3.8%)
|
(3.0%)
|
(23.4%)
|
2.4%
|
16.4%
|
(8.3%)
|
(16.2%)
|
6.6%
|
|
Five-year CAGR
|
17.4%
|
11.6%
|
(2.8%)
|
(8.9%)
|
4.5%
|
5.3%
|
(8.9%)
|
8.8%
|
12.5%
|
1.8%
|
(4.3%)
|
17.4%
|
|
Equity Growth:
|
|||||||||||||
Trailing Twelve Months
|
27.1%
|
15.7%
|
6.1%
|
4.9%
|
12.2%
|
9.2%
|
5.3%
|
27.1%
|
9.8%
|
8.5%
|
17.7%
|
4.9%
|
|
Latest Fiscal Year
|
53.2%
|
13.7%
|
7.1%
|
3.5%
|
16.6%
|
11.4%
|
9.8%
|
3.5%
|
13.1%
|
13.9%
|
6.2%
|
53.2%
|
|
Five-year CAGR
|
17.8%
|
13.0%
|
8.3%
|
2.9%
|
10.3%
|
9.2%
|
8.3%
|
2.9%
|
17.8%
|
9.2%
|
13.0%
|
NA
|
|
Footnote:
|
|||||||||||||
(1)
|
Source: Capital IQ
|
Schedule 7
|
||
Impairment Analysis, Step 1
|
Final
|
|
Market Approach: Guideline Public Company Method - Comparative Common Size Analysis
|
Valuation Date: September 30, 2009 | |
US$ in $000s
|
||
Company Name:
|
Conns Inc.
|
Best Buy
Co. Inc. |
Aaron's, Inc.
|
Rent-A-
Center Inc. |
RadioShack Corp.
|
hhgregg, Inc.
|
||||||||||||||||||||||||||||||
Ticker Symbol:
|
NasdaqGS:
CONN |
NYSE:
BBY |
NYSE:
AAN |
NasdaqGS:
RCII |
NYSE:
RSH |
NYSE:
HGG |
||||||||||||||||||||||||||||||
Last Fiscal Year End:
|
75th
|
25th
|
Jan 31, '09
|
Feb 28, '09
|
Dec 31, '08
|
Dec 31, '08
|
Dec 31, '08
|
Mar 31, '09
|
||||||||||||||||||||||||||||
Trailing Twelve Months:
|
HIGH
|
Percentile
|
Percentile
|
Low
|
Mean
|
Median
|
Jul 31, '09
|
Aug 29, '09
|
Jun 30, '09
|
Jun 30, '09
|
Jun 30, '09
|
Jun 30, '09
|
||||||||||||||||||||||||
Balance Sheet:
|
||||||||||||||||||||||||||||||||||||
Total Assets $
|
$ | 17,191,000 | $ | 2,381,558 | $ | 754,142 | $ | 366,777 | $ | 4,012,058 | $ | 1,750,228 | $ | 586,371 | $ | 17,191,000 | $ | 1,257,455 | $ | 2,427,744 | $ | 2,243,000 | $ | 366,777 | ||||||||||||
Total Assets %
|
100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | ||||||||||||
Cash & Cash Equivalents
|
41.5 | % | 6.0 | % | 2.9 | % | 0.8 | % | 9.9 | % | 3.9 | % | 0.8 | % | 3.9 | % | 6.6 | % | 3.9 | % | 41.5 | % | 2.6 | % | ||||||||||||
Accounts Receivable
|
19.7 | % | 10.0 | % | 2.7 | % | 1.8 | % | 7.8 | % | 6.5 | % | 19.7 | % | 10.3 | % | 3.8 | % | 2.3 | % | 9.1 | % | 1.8 | % | ||||||||||||
Inventory
|
43.7 | % | 33.4 | % | 17.2 | % | 0.2 | % | 24.1 | % | 25.8 | % | 17.2 | % | 33.4 | % |
NA
|
0.2 | % | 25.8 | % | 43.7 | % | |||||||||||||
Total Current Assets
|
80.5 | % | 69.1 | % | 24.2 | % | 8.6 | % | 47.6 | % | 54.1 | % | 73.9 | % | 53.6 | % | 14.4 | % | 8.6 | % | 80.5 | % | 54.6 | % | ||||||||||||
Net Fixed Assets
|
24.2 | % | 22.1 | % | 11.3 | % | 8.2 | % | 16.1 | % | 14.7 | % | 10.7 | % | 24.2 | % | 16.5 | % | 8.2 | % | 13.0 | % | 24.0 | % | ||||||||||||
Accounts Payable
|
31.5 | % | 17.4 | % | 8.2 | % | 3.9 | % | 13.8 | % | 9.9 | % | 8.1 | % | 31.5 | % | 11.4 | % | 3.9 | % | 8.5 | % | 19.5 | % | ||||||||||||
Current Portion Long-Term Debt
|
6.6 | % | 2.4 | % | 0.3 | % | 0.0 | % | 2.0 | % | 1.3 | % | 0.0 | % | 6.6 | % | 2.0 | % | 0.6 | % | 2.5 | % | 0.2 | % | ||||||||||||
Total Current Liabilities
|
52.1 | % | 30.0 | % | 16.3 | % | 13.5 | % | 25.8 | % | 20.6 | % | 17.6 | % | 52.1 | % | 13.5 | % | 15.9 | % | 23.5 | % | 32.2 | % | ||||||||||||
Long-Term Debt
|
31.4 | % | 28.5 | % | 10.4 | % | 4.4 | % | 19.8 | % | 23.6 | % | 22.2 | % | 6.5 | % | 4.4 | % | 31.4 | % | 29.6 | % | 24.9 | % | ||||||||||||
Total Liabilities
|
65.7 | % | 62.4 | % | 42.9 | % | 33.5 | % | 52.0 | % | 54.4 | % | 40.0 | % | 65.7 | % | 33.5 | % | 51.8 | % | 57.1 | % | 64.2 | % | ||||||||||||
Net Worth
|
66.5 | % | 57.1 | % | 37.6 | % | 34.3 | % | 48.0 | % | 45.6 | % | 60.0 | % | 34.3 | % | 66.5 | % | 48.2 | % | 42.9 | % | 35.8 | % | ||||||||||||
Debt-Free Working Capital
|
59.4 | % | 47.9 | % | 4.2 | % | (6.7 | %) | 23.8 | % | 15.4 | % | 56.3 | % | 8.1 | % | 3.0 | % | (6.7 | %) | 59.4 | % | 22.7 | % | ||||||||||||
NCDFWC Working Capital
|
55.5 | % | 19.6 | % | (1.7 | %) | (10.7 | %) | 13.9 | % | 11.0 | % | 55.5 | % | 4.2 | % | (3.7 | %) | (10.7 | %) | 17.9 | % | 20.1 | % | ||||||||||||
Income Statement:
|
||||||||||||||||||||||||||||||||||||
Revenue $
|
$ | 47,341,000 | $ | 3,890,374 | $ | 1,458,076 | $ | 905,197 | $ | 9,728,649 | $ | 2,245,821 | $ | 905,197 | $ | 47,341,000 | $ | 1,675,344 | $ | 2,816,297 | $ | 4,248,400 | $ | 1,385,653 | ||||||||||||
Revenue %
|
100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | ||||||||||||
Gross Profit
|
51.6 | % | 42.0 | % | 26.3 | % | 14.7 | % | 33.4 | % | 32.3 | % | 33.5 | % | 24.8 | % | 51.6 | % | 14.7 | % | 44.8 | % | 31.0 | % | ||||||||||||
Operating Income
|
9.9 | % | 9.4 | % | 4.4 | % | 4.2 | % | 6.9 | % | 6.7 | % | 4.2 | % | 4.3 | % | 9.9 | % | 9.7 | % | 8.4 | % | 5.0 | % | ||||||||||||
Net Income
|
6.3 | % | 5.3 | % | 2.4 | % | 2.0 | % | 3.9 | % | 3.7 | % | 2.4 | % | 2.0 | % | 6.3 | % | 5.4 | % | 4.8 | % | 2.6 | % | ||||||||||||
FYE -1
|
5.7 | % | 4.8 | % | 2.7 | % | 2.2 | % | 3.8 | % | 3.7 | % | 2.9 | % | 2.2 | % | 5.7 | % | 4.8 | % | 4.6 | % | 2.6 | % | ||||||||||||
FYE -2
|
5.8 | % | 5.4 | % | 2.8 | % | 1.7 | % | 4.0 | % | 4.2 | % | 4.8 | % | 3.5 | % | 5.8 | % | 2.6 | % | 5.6 | % | 1.7 | % | ||||||||||||
EBITDA
|
12.5 | % | 12.0 | % | 6.1 | % | 5.7 | % | 8.9 | % | 8.4 | % | 5.7 | % | 6.2 | % | 12.4 | % | 12.5 | % | 10.7 | % | 6.1 | % | ||||||||||||
FYE -1
|
12.5 | % | 11.1 | % | 6.2 | % | 6.2 | % | 8.8 | % | 8.1 | % | 6.2 | % | 6.2 | % | 11.4 | % | 12.5 | % | 10.0 | % | 6.2 | % | ||||||||||||
FYE -2
|
13.5 | % | 11.7 | % | 7.3 | % | 6.4 | % | 9.8 | % | 10.0 | % | 8.8 | % | 6.9 | % | 11.2 | % | 13.5 | % | 11.9 | % | 6.4 | % | ||||||||||||
Depreciation & Amortization
|
2.8 | % | 2.5 | % | 1.6 | % | 1.2 | % | 2.1 | % | 2.3 | % | 1.6 | % |
NA
|
2.5 | % | 2.8 | % | 2.3 | % | 1.2 | % | |||||||||||||
Non-Operating Income / (Expense)
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % |
NA
|
NA
|
0.0 | % |
NA
|
|||||||||||||||
Capital Expenditures
|
(1.5 | %) | (2.2 | %) | (2.5 | %) | (4.5 | %) | (2.6 | %) | (2.3 | %) | (1.5 | %) |
NA
|
(4.5 | %) | (2.2 | %) | (2.5 | %) | (2.3 | %) |
Footnote:
|
|||
(1) |
Source: Capital IQ
|
Conn's, Inc.
|
|||||
Impairment Analysis, Step 1
|
|||||
Market Approach: Guideline Public Company Method - Business Descriptions
|
Conns Inc.
|
|||||
Ticker:
|
NasdaqGS:CONN
|
||||
Exchange:
|
NasdaqGS
|
||||
Industry:
|
Computer and Electronics Retail
|
Best Buy Co. Inc.
|
|||||
Ticker:
|
NYSE:BBY
|
||||
Exchange:
|
NYSE
|
||||
Industry:
|
Computer and Electronics Retail
|
Conn's, Inc.
|
|||||
Impairment Analysis, Step 1
|
|||||
Market Approach: Guideline Public Company Method - Business Descriptions
|
Aaron's, Inc.
|
||||
Ticker:
|
NYSE:AAN
|
|||
Exchange:
|
NYSE
|
|||
Industry:
|
Home Furnishing Retail
|
Rent-A-Center Inc.
|
|||||
Ticker:
|
NasdaqGS:RCII
|
||||
Exchange:
|
NasdaqGS
|
||||
Industry:
|
Computer and Electronics Retail
|
Conn's, Inc.
|
|||||
Impairment Analysis, Step 1
|
|||||
Market Approach: Guideline Public Company Method - Business Descriptions
|
RadioShack Corp.
|
||||
Ticker:
|
NYSE:RSH
|
|||
Exchange:
|
NYSE
|
|||
Industry:
|
Computer and Electronics Retail
|
hhgregg, Inc.
|
|||||
Ticker:
|
NYSE:HGG
|
||||
Exchange:
|
NYSE
|
||||
Industry:
|
Computer and Electronics Retail
|
Conn's, Inc.
|
Schedule 9
|
||
Impairment Analysis, Step 1
|
Final
|
||
Historical Balance Sheets
|
Valuation Date: September 30, 2009
|
||
US$ in $000s
|
Page 1 of 2
|
||
Audited
|
Audited
|
Audited
|
Audited
|
Audited
|
Internal As Of
|
|||||||||||||||||||
Jan 31, '05
|
Jan 31, '06
|
Jan 31, '07
|
Jan 31, '08
|
Jan 31, '09
|
Sep 30, '09
|
|||||||||||||||||||
Assets
|
||||||||||||||||||||||||
Cash & Equivalents
|
$ | 7,027 | $ | 45,176 | $ | 56,570 | $ | 11,015 | $ | 11,798 | $ | 6,226 | ||||||||||||
Accounts Receivable, Net
|
||||||||||||||||||||||||
Trade & Other
|
26,728 | 26,904 | 31,737 | 33,110 | 94,003 | 247,298 | ||||||||||||||||||
Interest in Securitized Assets
|
117,159 | 139,282 | 136,848 | 178,150 | 176,543 | 153,836 | ||||||||||||||||||
Inventories
|
62,346 | 73,987 | 87,098 | 81,495 | 95,971 | 92,914 | ||||||||||||||||||
Deferred Income Taxes
|
825 | - | 551 | 2,619 | 13,354 | 16,272 | ||||||||||||||||||
Prepaid Expenses & Other
|
3,552 | 4,004 | 4,958 | 4,449 | 5,933 | 6,820 | ||||||||||||||||||
Total Current Assets
|
217,637 | 289,353 | 317,762 | 310,838 | 397,602 | 523,366 | ||||||||||||||||||
Property, Plant & Equipment
|
||||||||||||||||||||||||
Gross Property, Plant & Equipment
|
82,368 | 92,158 | 106,431 | 116,448 | 127,370 | 134,845 | ||||||||||||||||||
Less: Depreciation
|
(34,658 | ) | (37,332 | ) | (46,991 | ) | (57,195 | ) | (64,819 | ) | (73,304 | ) | ||||||||||||
Net Property, Plant & Equipment
|
47,710 | 54,826 | 59,440 | 59,253 | 62,551 | 61,541 | ||||||||||||||||||
Other Assets
|
||||||||||||||||||||||||
Debt issuance and other costs
|
- | - | - | - | - | 1,764 | ||||||||||||||||||
Investments
|
- | - | - | - | - | (0 | ) | |||||||||||||||||
Non-current tax asset
|
- | - | - | - | - | 2,895 | ||||||||||||||||||
Non-current accounts receivable
|
- | - | - | 2,990 | 41,172 | 1,351 | ||||||||||||||||||
Goodwill
|
9,617 | 9,617 | 9,617 | 9,617 | 9,617 | 9,617 | ||||||||||||||||||
Deferred Income Taxes
|
1,523 | 1,561 | 2,920 | - | 2,035 | - | ||||||||||||||||||
Other
|
229 | 260 | 208 | 154 | 3,652 | 267 | ||||||||||||||||||
Total Other Assets
|
11,369 | 11,438 | 12,745 | 12,761 | 56,476 | 15,894 | ||||||||||||||||||
Total Assets
|
$ | 276,716 | $ | 355,617 | $ | 389,947 | $ | 382,852 | $ | 516,629 | $ | 600,801 | ||||||||||||
Liabilities & Equity
|
||||||||||||||||||||||||
Current Installments of Long-Term Debt
|
$ | 29 | $ | 136 | $ | 110 | $ | 102 | $ | 5 | $ | 41 | ||||||||||||
Accounts Payable
|
27,108 | 44,282 | 51,028 | 28,179 | 57,809 | 46,649 | ||||||||||||||||||
Accrued Salaries and Wages
|
- | - | - | - | - | 5,595 | ||||||||||||||||||
Accrued Expenses
|
20,476 | 36,227 | 29,658 | 31,235 | 35,176 | 28,129 | ||||||||||||||||||
Income Taxes Payable
|
- | 8,794 | 3,693 | 600 | 4,334 | (6,331 | ) | |||||||||||||||||
Deferred Income Taxes
|
958 | 1,343 | - | - | - | 2,016 | ||||||||||||||||||
Short-term Borrowings
|
5,500 | - | - | - | - | - | ||||||||||||||||||
Other Current Liabilities
|
177 | - | - | - | - | - | ||||||||||||||||||
Deferred Revenue, Current
|
7,383 | 8,498 | 12,533 | 16,949 | 21,207 | 14,796 | ||||||||||||||||||
Total Current Liabilities
|
61,631 | 99,280 | 97,022 | 77,065 | 118,531 | 90,893 | ||||||||||||||||||
Long-Term Liabilities
|
||||||||||||||||||||||||
Long Term Debt, Noncurrent
|
5,003 | - | 88 | 17 | 62,912 | 149,333 | ||||||||||||||||||
Deferred Income Taxes
|
704 | - | - | 131 | - | 2,098 | ||||||||||||||||||
Deferred Gain on Sale of Property
|
- | - | - | - | - | 947 | ||||||||||||||||||
Fair Value of Derivatives
|
- | - | - | - | - | 231 | ||||||||||||||||||
Deferred Revenue, Noncurrent
|
644 | 476 | 309 | 1,221 | 1,036 | 5,186 | ||||||||||||||||||
Total Long-Term Liabilities
|
6,351 | 476 | 397 | 1,369 | 63,948 | 157,795 | ||||||||||||||||||
Total Liabilities
|
67,982 | 99,756 | 97,419 | 78,434 | 182,479 | 248,689 | ||||||||||||||||||
Shareholders' Equity
|
||||||||||||||||||||||||
Common Stock
|
233 | 236 | 238 | 241 | 242 | 242 | ||||||||||||||||||
Treasury Stock
|
- | - | (3,797 | ) | (37,071 | ) | (37,071 | ) | (37,071 | ) | ||||||||||||||
Additional Paid in Capital
|
85,090 | 89,027 | 93,365 | 99,514 | 103,553 | 105,393 | ||||||||||||||||||
Accumulated Other Comprehensive Income
|
8,408 | 10,492 | 6,305 | - | - | (150 | ) | |||||||||||||||||
Retained Earnings
|
115,003 | 156,106 | 196,417 | 241,734 | 267,426 | 283,698 | ||||||||||||||||||
Total Shareholders' Equity
|
208,734 | 255,861 | 292,528 | 304,418 | 334,150 | 352,113 | ||||||||||||||||||
Total Liabilities & Equity
|
$ | 276,716 | $ | 355,617 | $ | 389,947 | $ | 382,852 | $ | 516,629 | $ | 600,801 |
Conn's, Inc.
|
Schedule 9
|
|||
Impairment Analysis, Step 1
|
FINAL
|
|||
Historical Balance Sheets: Common Size
|
Valuation Date: September 30, 2009
|
|||
Page 2 of 2
|
Jan 31, '05
|
Jan 31, '06
|
Jan 31, '07
|
Jan 31, '08
|
Jan 31, '09
|
Sep 30, '09
|
|||||||||||||||||||
Assets
|
||||||||||||||||||||||||
Cash & Equivalents
|
2.5 | % | 12.7 | % | 14.5 | % | 2.9 | % | 2.3 | % | 1.0 | % | ||||||||||||
Accounts Receivable, Net
|
||||||||||||||||||||||||
Trade & Other
|
9.7 | % | 7.6 | % | 8.1 | % | 8.6 | % | 18.2 | % | 41.2 | % | ||||||||||||
Interest in Securitized Assets
|
42.3 | % | 39.2 | % | 35.1 | % | 46.5 | % | 34.2 | % | 25.6 | % | ||||||||||||
Inventories
|
22.5 | % | 20.8 | % | 22.3 | % | 21.3 | % | 18.6 | % | 15.5 | % | ||||||||||||
Deferred Income Taxes
|
0.3 | % | 0.0 | % | 0.1 | % | 0.7 | % | 2.6 | % | 2.7 | % | ||||||||||||
Prepaid Expenses & Other
|
1.3 | % | 1.1 | % | 1.3 | % | 1.2 | % | 1.1 | % | 1.1 | % | ||||||||||||
Total Current Assets
|
78.6 | % | 81.4 | % | 81.5 | % | 81.2 | % | 77.0 | % | 87.1 | % | ||||||||||||
Property, Plant & Equipment
|
||||||||||||||||||||||||
Gross Property, Plant & Equipment
|
29.8 | % | 25.9 | % | 27.3 | % | 30.4 | % | 24.7 | % | 22.4 | % | ||||||||||||
Less: Depreciation
|
(12.5 | %) | (10.5 | %) | (12.1 | %) | (14.9 | %) | (12.5 | %) | (12.2 | %) | ||||||||||||
Net Property, Plant & Equipment
|
17.2 | % | 15.4 | % | 15.2 | % | 15.5 | % | 12.1 | % | 10.2 | % | ||||||||||||
Other Assets
|
||||||||||||||||||||||||
Debt issuance and other costs
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.3 | % | ||||||||||||
Investments
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | (0.0 | %) | ||||||||||||
Non-current tax asset
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.5 | % | ||||||||||||
Non-current accounts receivable
|
0.0 | % | 0.0 | % | 0.0 | % | 0.8 | % | 8.0 | % | 0.2 | % | ||||||||||||
Goodwill
|
3.5 | % | 2.7 | % | 2.5 | % | 2.5 | % | 1.9 | % | 1.6 | % | ||||||||||||
Deferred Income Taxes
|
0.6 | % | 0.4 | % | 0.7 | % | 0.0 | % | 0.4 | % | 0.0 | % | ||||||||||||
Other
|
0.1 | % | 0.1 | % | 0.1 | % | 0.0 | % | 0.7 | % | 0.0 | % | ||||||||||||
Total Other Assets
|
4.1 | % | 3.2 | % | 3.3 | % | 3.3 | % | 10.9 | % | 2.6 | % | ||||||||||||
Total Assets
|
100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | ||||||||||||
Liabilities & Equity
|
||||||||||||||||||||||||
Current Installments of Long-Term Debt
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | ||||||||||||
Accounts Payable
|
9.8 | % | 12.5 | % | 13.1 | % | 7.4 | % | 11.2 | % | 7.8 | % | ||||||||||||
Accrued Salaries and Wages
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.9 | % | ||||||||||||
Accrued Expenses
|
7.4 | % | 10.2 | % | 7.6 | % | 8.2 | % | 6.8 | % | 4.7 | % | ||||||||||||
Income Taxes Payable
|
NA
|
2.5 | % | 0.9 | % | 0.2 | % | 0.8 | % | (1.1 | %) | |||||||||||||
Deferred Income Taxes
|
0.3 | % | 0.4 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.3 | % | ||||||||||||
Short-term Borrowings
|
2.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | ||||||||||||
Other Current Liabilities
|
0.1 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | ||||||||||||
Deferred Revenue, Current
|
2.7 | % | 2.4 | % | 3.2 | % | 4.4 | % | 4.1 | % | 2.5 | % | ||||||||||||
Total Current Liabilities
|
22.3 | % | 27.9 | % | 24.9 | % | 20.1 | % | 22.9 | % | 15.1 | % | ||||||||||||
Long-Term Liabilities
|
||||||||||||||||||||||||
Long Term Debt, Noncurrent
|
1.8 | % | 0.0 | % | 0.0 | % | 0.0 | % | 12.2 | % | 24.9 | % | ||||||||||||
Deferred Income Taxes
|
0.3 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.3 | % | ||||||||||||
Deferred Gain on Sale of Property
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.2 | % | ||||||||||||
Fair Value of Derivatives
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | ||||||||||||
Deferred Revenue, Noncurrent
|
0.2 | % | 0.1 | % | 0.1 | % | 0.3 | % | 0.2 | % | 0.9 | % | ||||||||||||
Total Long-Term Liabilities
|
2.3 | % | 0.1 | % | 0.1 | % | 0.4 | % | 12.4 | % | 26.3 | % | ||||||||||||
Total Liabilities
|
24.6 | % | 28.1 | % | 25.0 | % | 20.5 | % | 35.3 | % | 41.4 | % | ||||||||||||
Shareholders' Equity
|
||||||||||||||||||||||||
Common Stock
|
0.1 | % | 0.1 | % | 0.1 | % | 0.1 | % | 0.0 | % | 0.0 | % | ||||||||||||
Treasury Stock
|
0.0 | % | 0.0 | % | (1.0 | %) | (9.7 | %) | (7.2 | %) | (6.2 | %) | ||||||||||||
Additional Paid in Capital
|
30.7 | % | 25.0 | % | 23.9 | % | 26.0 | % | 20.0 | % | 17.5 | % | ||||||||||||
Accumulated Other Comprehensive Income
|
3.0 | % | 3.0 | % | 1.6 | % | 0.0 | % | 0.0 | % | (0.0 | %) | ||||||||||||
Retained Earnings
|
41.6 | % | 43.9 | % | 50.4 | % | 63.1 | % | 51.8 | % | 47.2 | % | ||||||||||||
Total Shareholders' Equity
|
75.4 | % | 71.9 | % | 75.0 | % | 79.5 | % | 64.7 | % | 58.6 | % | ||||||||||||
Total Liabilities & Equity
|
100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | ||||||||||||
Conn's, Inc.
|
Schedule 10
|
|||
Impairment Analysis, Step 1
|
Final
|
|||
Historical & Forecast Income Statements
|
Valuation Date: September 30, 2009
|
|||
US$ in $000s
|
Page 1 of 2
|
|||
Internal | ||||||||||||||||||||||||||||||||||||||||||||
Audited
|
Audited
|
Audited
|
Audited
|
Audited
|
TTM
|
Forecast
|
||||||||||||||||||||||||||||||||||||||
Jan 31, '05
|
Jan 31, '06
|
Jan 31, '07
|
Jan 31, '08
|
Jan 31, '09
|
Sep 30, '09
|
Jan 31, '10
|
Jan 31, '11
|
Jan 31, '12
|
Jan 31, '13
|
Jan 31, '14
|
||||||||||||||||||||||||||||||||||
% Revenue Growth
|
NA
|
23.9 | % | 8.5 | % | 8.3 | % | 8.1 | % | 1.4 | % | (2.4 | %) | 4.1 | % | 4.2 | % | 6.3 | % | 6.6 | % | |||||||||||||||||||||||
Net Revenue
|
$ | 565,821 | $ | 701,148 | $ | 760,657 | $ | 824,128 | $ | 890,750 | $ | 902,910 | $ | 869,687 | $ | 905,405 | $ | 943,466 | $ | 1,002,758 | $ | 1,068,659 | ||||||||||||||||||||||
Total Cost Of Goods Sold
|
359,710 | 427,843 | 473,064 | 517,166 | 590,061 | 603,094 | 566,664 | 588,916 | 610,218 | 638,362 | 673,318 | |||||||||||||||||||||||||||||||||
Gross Profit
|
206,111 | 273,305 | 287,593 | 306,962 | 300,689 | 299,816 | 303,023 | 316,489 | 333,247 | 364,395 | 395,341 | |||||||||||||||||||||||||||||||||
Operating Expenses:
|
||||||||||||||||||||||||||||||||||||||||||||
Selling General & Admin Exp.
|
144,749 | 196,988 | 212,459 | 232,876 | 241,141 | 243,595 | 248,893 | 246,165 | 254,414 | 265,793 | 280,818 | |||||||||||||||||||||||||||||||||
Provision for Bad Debts
|
2,589 | 1,133 | 1,476 | 1,908 | 4,273 | 7,709 | 8,227 | 6,428 | 12,656 | 30,745 | 25,778 | |||||||||||||||||||||||||||||||||
Depreciation
|
8,777 | 11,271 | 12,520 | 12,441 | 12,672 | 13,460 | 14,500 | 14,935 | 15,383 | 15,845 | 16,320 | |||||||||||||||||||||||||||||||||
Total Operating Expenses
|
156,115 | 209,392 | 226,455 | 247,225 | 258,086 | 264,764 | 271,620 | 267,528 | 282,453 | 312,383 | 322,916 | |||||||||||||||||||||||||||||||||
Operating Income (Loss)
|
49,996 | 63,913 | 61,138 | 59,737 | 42,603 | 35,052 | 31,403 | 48,961 | 50,794 | 52,013 | 72,425 | |||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||
Other Income (Expense):
|
||||||||||||||||||||||||||||||||||||||||||||
Net Gain (Loss) on Dispositions of Assets
|
(126 | ) | (69 | ) | 772 | 943 | (117 | ) | (117 | ) | - | - | - | - | - | |||||||||||||||||||||||||||||
Interest Expense
|
(2,359 | ) | (400 | ) | - | - | (961 | ) | (3,244 | ) | (4,127 | ) | (3,628 | ) | (4,844 | ) | (9,213 | ) | (12,520 | ) | ||||||||||||||||||||||||
Interest and Invest. Income
|
- | - | 676 | 515 | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||||||
Other Expense
|
- | - | - | - | - | 140 | 42 | - | - | - | - | |||||||||||||||||||||||||||||||||
Total Other Income (Expense)
|
(2,485 | ) | (469 | ) | 1,448 | 1,458 | (1,078 | ) | (3,221 | ) | (4,085 | ) | (3,628 | ) | (4,844 | ) | (9,213 | ) | (12,520 | ) | ||||||||||||||||||||||||
Earnings (Loss) Before Income Taxes
|
47,511 | 63,444 | 62,586 | 61,195 | 41,525 | 31,831 | 27,319 | 45,333 | 45,951 | 42,799 | 59,904 | |||||||||||||||||||||||||||||||||
Provision for Income Taxes (Benefit)
|
16,706 | 22,341 | 22,275 | 21,509 | 15,833 | 12,553 | 10,783 | 17,000 | 17,231 | 16,050 | 22,464 | |||||||||||||||||||||||||||||||||
Minority Interest
|
118 | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||||||||||||||
Net Income (Loss)
|
$ | 30,687 | $ | 41,103 | $ | 40,311 | $ | 39,686 | $ | 25,692 | $ | 19,278 | $ | 16,536 | $ | 28,333 | $ | 28,719 | $ | 26,750 | $ | 37,440 | ||||||||||||||||||||||
EBIT
|
49,996 | 63,913 | 61,138 | 59,737 | 42,603 | 35,052 | 31,403 | 48,961 | 50,794 | 52,013 | 72,425 | |||||||||||||||||||||||||||||||||
EBITDA
|
58,773 | 75,184 | 73,658 | 72,178 | 55,275 | 48,512 | 45,903 | 63,896 | 66,177 | 67,857 | 88,745 | |||||||||||||||||||||||||||||||||
Supplemental Data:
|
||||||||||||||||||||||||||||||||||||||||||||
Interest Expense
|
2,359 | 400 | - | - | 961 | 3,244 | 4,127 | 3,628 | 4,844 | 9,213 | 12,520 | |||||||||||||||||||||||||||||||||
Depreciation Expense
|
8,777 | 11,271 | 12,520 | 12,441 | 12,672 | 13,460 | 14,500 | 14,935 | 15,383 | 15,845 | 16,320 | |||||||||||||||||||||||||||||||||
Total Capital Expenditures
|
19,619 | 18,490 | 18,425 | 18,955 | 17,597 | N/A | 12,000 | 10,000 | 12,000 | 12,000 | 12,000 | |||||||||||||||||||||||||||||||||
Conn's, Inc. | Schedule 10 | |||||||||||||||||||||||||||||||||||||||||||
Impairment Analysis, Step 1 | Final | |||||||||||||||||||||||||||||||||||||||||||
Historical & Forecast Income Statements: Common Size | Valuation Date: September 30, 2009 | |||||||||||||||||||||||||||||||||||||||||||
Page 2 of 2 | ||||||||||||||||||||||||||||||||||||||||||||
Jan 31, '05
|
Jan 31, '06
|
Jan 31, '07
|
Jan 31, '08
|
Jan 31, '09
|
Sep 30, '09
|
Jan 31, '10
|
Jan 31, '11
|
Jan 31, '12
|
Jan 31, '13
|
Jan 31, '14
|
||||||||||||||||||||||||||||||||||
Net Revenue
|
100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | 100.0 | % | ||||||||||||||||||||||
Total Cost Of Goods Sold
|
63.6 | % | 61.0 | % | 62.2 | % | 62.8 | % | 66.2 | % | 66.8 | % | 65.2 | % | 65.0 | % | 64.7 | % | 63.7 | % | 63.0 | % | ||||||||||||||||||||||
Gross Profit
|
36.4 | % | 39.0 | % | 37.8 | % | 37.2 | % | 33.8 | % | 33.2 | % | 34.8 | % | 35.0 | % | 35.3 | % | 36.3 | % | 37.0 | % | ||||||||||||||||||||||
Operating Expenses:
|
||||||||||||||||||||||||||||||||||||||||||||
Selling General & Admin Exp.
|
25.6 | % | 28.1 | % | 27.9 | % | 28.3 | % | 27.1 | % | 27.0 | % | 28.6 | % | 27.2 | % | 27.0 | % | 26.5 | % | 26.3 | % | ||||||||||||||||||||||
Provision for Bad Debts
|
0.5 | % | 0.2 | % | 0.2 | % | 0.2 | % | 0.5 | % | 0.9 | % | 0.9 | % | 0.7 | % | 1.3 | % | 3.1 | % | 2.4 | % | ||||||||||||||||||||||
Depreciation
|
1.6 | % | 1.6 | % | 1.6 | % | 1.5 | % | 1.4 | % | 1.5 | % | 1.7 | % | 1.6 | % | 1.6 | % | 1.6 | % | 1.5 | % | ||||||||||||||||||||||
Total Operating Expenses
|
27.6 | % | 29.9 | % | 29.8 | % | 30.0 | % | 29.0 | % | 29.3 | % | 31.2 | % | 29.5 | % | 29.9 | % | 31.2 | % | 30.2 | % | ||||||||||||||||||||||
Operating Income (Loss)
|
8.8 | % | 9.1 | % | 8.0 | % | 7.2 | % | 4.8 | % | 3.9 | % | 3.6 | % | 5.4 | % | 5.4 | % | 5.2 | % | 6.8 | % | ||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||
Other Income (Expense):
|
||||||||||||||||||||||||||||||||||||||||||||
Net Gain (Loss) on Dispositions of Assets
|
(0.0 | %) | (0.0 | %) | 0.1 | % | 0.1 | % | (0.0 | %) | (0.0 | %) | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | ||||||||||||||||||||||
Interest Expense
|
(0.4 | %) | (0.1 | %) | 0.0 | % | 0.0 | % | (0.1 | %) | (0.4 | %) | (0.5 | %) | (0.4 | %) | (0.5 | %) | (0.9 | %) | (1.2 | %) | ||||||||||||||||||||||
Interest and Invest. Income
|
0.0 | % | 0.0 | % | 0.1 | % | 0.1 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | ||||||||||||||||||||||
Other Expense
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | ||||||||||||||||||||||
Total Other Income (Expense)
|
(0.4 | %) | (0.1 | %) | 0.2 | % | 0.2 | % | (0.1 | %) | (0.4 | %) | (0.5 | %) | (0.4 | %) | (0.5 | %) | (0.9 | %) | (1.2 | %) | ||||||||||||||||||||||
Earnings (Loss) Before Income Taxes
|
8.4 | % | 9.0 | % | 8.2 | % | 7.4 | % | 4.7 | % | 3.5 | % | 3.1 | % | 5.0 | % | 4.9 | % | 4.3 | % | 5.6 | % | ||||||||||||||||||||||
Provision for Income Taxes (Benefit)
|
3.0 | % | 3.2 | % | 2.9 | % | 2.6 | % | 1.8 | % | 1.4 | % | 1.2 | % | 1.9 | % | 1.8 | % | 1.6 | % | 2.1 | % | ||||||||||||||||||||||
Minority Interest
|
0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | 0.0 | % | ||||||||||||||||||||||
Net Income (Loss)
|
5.4 | % | 5.9 | % | 5.3 | % | 4.8 | % | 2.9 | % | 2.1 | % | 1.9 | % | 3.1 | % | 3.0 | % | 2.7 | % | 3.5 | % | ||||||||||||||||||||||
EBIT
|
8.8 | % | 9.1 | % | 8.0 | % | 7.2 | % | 4.8 | % | 3.9 | % | 3.6 | % | 5.4 | % | 5.4 | % | 5.2 | % | 6.8 | % | ||||||||||||||||||||||
EBITDA
|
10.4 | % | 10.7 | % | 9.7 | % | 8.8 | % | 6.2 | % | 5.4 | % | 5.3 | % | 7.1 | % | 7.0 | % | 6.8 | % | 8.3 | % | ||||||||||||||||||||||
Supplemental Data:
|
||||||||||||||||||||||||||||||||||||||||||||
Interest Expense
|
0.4 | % | 0.1 | % | 0.0 | % | 0.0 | % | 0.1 | % | 0.4 | % | 0.5 | % | 0.4 | % | 0.5 | % | 0.9 | % | 1.2 | % | ||||||||||||||||||||||
Depreciation Expense
|
1.6 | % | 1.6 | % | 1.6 | % | 1.5 | % | 1.4 | % | 1.5 | % | 1.7 | % | 1.6 | % | 1.6 | % | 1.6 | % | 1.5 | % | ||||||||||||||||||||||
Total Capital Expenditures
|
3.5 | % | 2.6 | % | 2.4 | % | 2.3 | % | 2.0 | % | N/A | 1.4 | % | 1.1 | % | 1.3 | % | 1.2 | % | 1.1 | % |