0001363851-12-000013.txt : 20120314 0001363851-12-000013.hdr.sgml : 20120314 20120314164016 ACCESSION NUMBER: 0001363851-12-000013 CONFORMED SUBMISSION TYPE: 8-K/A PUBLIC DOCUMENT COUNT: 5 CONFORMED PERIOD OF REPORT: 20120314 ITEM INFORMATION: Financial Statements and Exhibits FILED AS OF DATE: 20120314 DATE AS OF CHANGE: 20120314 FILER: COMPANY DATA: COMPANY CONFORMED NAME: SXC Health Solutions Corp. CENTRAL INDEX KEY: 0001363851 STANDARD INDUSTRIAL CLASSIFICATION: INSURANCE AGENTS BROKERS & SERVICES [6411] IRS NUMBER: 752578509 STATE OF INCORPORATION: A6 FISCAL YEAR END: 1231 FILING VALUES: FORM TYPE: 8-K/A SEC ACT: 1934 Act SEC FILE NUMBER: 000-52073 FILM NUMBER: 12690748 BUSINESS ADDRESS: STREET 1: 2441 WARRENVILLE ROAD STREET 2: SUITE 610 CITY: LISLE STATE: IL ZIP: 60532 BUSINESS PHONE: 630-577-3100 MAIL ADDRESS: STREET 1: 2441 WARRENVILLE ROAD STREET 2: SUITE 610 CITY: LISLE STATE: IL ZIP: 60532 FORMER COMPANY: FORMER CONFORMED NAME: SXC Health Solutions Inc. DATE OF NAME CHANGE: 20090324 FORMER COMPANY: FORMER CONFORMED NAME: SXC Health Solutions Corp. DATE OF NAME CHANGE: 20070712 FORMER COMPANY: FORMER CONFORMED NAME: Systems Xcellence Inc. DATE OF NAME CHANGE: 20060524 8-K/A 1 a8-kaform.htm 8-k/a form

UNITED STATES
SECURITIES AND EXCHANGE COMMISSION
WASHINGTON, D.C. 20549
  

FORM 8-K/A
 

 
CURRENT REPORT
Pursuant to Section 13 or 15(d) of the Securities Exchange Act of 1934
Date of Report (Date of earliest event reported): January 1, 2012
 

 
SXC HEALTH SOLUTIONS CORP.
(Exact name of registrant as specified in charter)
 

 
000-52073
(Commission File Number)

 
 
 
 
 
Yukon Territory, Canada
 
 
 
75-2578509
(State or Other Jurisdiction of Incorporation)
 
 
 
(IRS Employer Identification Number)

2441 Warrenville Road, Suite 610
Lisle, Illinois 60532-3246
(Address of principal executive offices, including zip code)
Registrant's telephone number, including area code: (800) 282-3232 

Check the appropriate box below if the Form 8-K filing is intended to simultaneously satisfy the filing obligation of the registrant under any of the following provisions (see General Instruction A.2. below):
 
o
Written communications pursuant to Rule 425 under the Securities Act (17 CFR 230.425)
o
Soliciting material pursuant to Rule 14a-12 under the Exchange Act (17 CFR 240.14a-12)
o
Pre-commencement communications pursuant to Rule 14d-2(b) under the Exchange Act (17 CFR 240.14d-2(b))
o
Pre-commencement communications pursuant to Rule 13e-4(c) under the Exchange Act (17 CFR 240.13e-4(c))










Explanatory Note

On January 5, 2012, SXC Health Solutions Corp. (“SXC”) filed with the Securities and Exchange Commission a Current Report on Form 8-K (the “January 5 Form 8-K”) in connection with the completion of SXC's acquisition (the “Acquisition”), through a wholly-owned subsidiary, of all of the outstanding equity interests of HealthTran LLC (“HealthTran”), effective as of 12:01 a.m. Central Standard Time on January 1, 2012, in exchange for $250.0 million in cash, subject to certain customary post-closing adjustments. Effective immediately prior to the completion of the Acquisition, HealthTran sold, assigned, transferred, conveyed and delivered to Innovante Benefit Administrators, LLC (“Innovante”), a wholly-owned subsidiary of HealthTrans Data Services, LLC, a former significant equity interest holder of HealthTran, all of HealthTran's right, title and interest in and to all assets exclusively used in the operation of its business of providing third party administration (TPA) services (the “TPA Business”) for both medical and prescription drug claim processing and adjudication and general benefit plan administration, in consideration for the payment of $1 and the assumption by Innovante of all of the liabilities of the TPA Business.

In accordance with the Instruction to Item 9.01 of Form 8-K, this Current Report on Form 8-K/A amends Item 9.01 of the January 5 Form 8-K to present certain historical financial statements of HealthTran and certain unaudited pro forma financial information in connection with the Acquisition required under Item 9.01(a) and (b) of Form 8-K, which historical financial statements and unaudited pro forma information are filed as exhibits hereto. Except as set forth herein, the January 5 Form 8-K remains unchanged.
Item 9.01
Financial Statements and Exhibits.
 
(a)
Financial Statements of Business Acquired

1.  The audited consolidated balance sheets of HealthTran as of May 31, 2011 and May 31, 2010 and related audited consolidated statements of earnings, changes in members' deficit and cash flows for the fiscal years ended May 31, 2011 and May 31, 2010, including the notes thereto, are attached hereto as Exhibit 99.2 and incorporated by reference herein.

2.  The unaudited consolidated balance sheet of HealthTran as of November 30, 2011 and related unaudited consolidated statements of earnings, changes in members' deficit and cash flows for the six months ended November 30, 2011 and 2010, including the notes thereto, are attached hereto as Exhibit 99.3 and incorporated by reference herein.

(b)
Pro Forma Financial Information

The unaudited pro forma combined balance sheet of SXC and HealthTran (excluding the TPA Business) as of December 31, 2011 and the unaudited pro forma combined statement of operations of SXC and HealthTran (excluding the TPA Business) for the year ended December 31, 2011, including the notes thereto, are attached hereto as Exhibit 99.4 and incorporated by reference herein.





















(d)
Exhibits
Exhibit No.
 
Description
2.1
 
Unit Purchase Agreement, dated November 16, 2011, by and among SXC Health Solutions, Inc., HealthTran LLC, HealthTrans Data Services, LLC, ABRY Senior Equity II, L.P., ASE II-A HealthTran, L.P., ABRY Senior Equity Co-Investment, L.P., The Jack and Mary McClurg Exempt Trust, The Hutchison Family Exempt Trust, Jack W. McClurg, both in his individual capacity and in his capacity as the trustee of The Jack and Mary McClurg Exempt Trust, Louis W. Hutchison, Jr., both in his individual capacity and in his capacity as the trustee of The Hutchison Family Exempt Trust, and HealthTrans Data Services, LLC, in its capacity as the Sellers' Agent thereunder* (incorporated by reference to Exhibit 2.1 to the January 5 Form 8-K)
23.1
 
Consent of Grant Thornton LLP
99.1
 
Press release of SXC Health Solutions Corp. issued January 4, 2012 (incorporated by reference to Exhibit 99.1 to the January 5 Form 8-K)
99.2
 
Audited consolidated balance sheets of HealthTran as of May 31, 2011 and May 31, 2010 and related audited consolidated statements of earnings, changes in members' deficit and cash flows for the fiscal years ended May 31, 2011 and May 31, 2010, including the notes thereto
99.3
 
Unaudited consolidated balance sheet of HealthTran as of November 30, 2011, and related unaudited consolidated statements of earnings, changes in members' deficit and cash flows for the six months ended November 30, 2011 and 2010, including the notes thereto
99.4
 
Unaudited pro forma combined balance sheet of SXC and HealthTran (excluding the TPA Business) as of December 31, 2011 and the unaudited pro forma combined statement of operations of SXC and HealthTran (excluding the TPA Business) for the year ended December 31, 2011, including the notes thereto
__________________
*
The registrant agrees to furnish supplementally to the Securities and Exchange Commission a copy of any omitted schedule or exhibit upon the request of the Securities and Exchange Commission in accordance with Item 601(b)(2) of Regulation S-K.
























SIGNATURE
Pursuant to the requirement of the Securities Exchange Act of 1934, the Registrant has duly caused this report to be signed on its behalf by the undersigned hereunto duly authorized.
Dated: March 14, 2012
 
 
 
 
SXC HEALTH SOLUTIONS CORP.
 
 
By:
 
/s/ Jeffrey Park
 
 
Name: Jeffrey Park
Title: Executive Vice President and
           Chief Financial Officer










EXHIBIT INDEX

Exhibit No.
 
Description
2.1
 
Unit Purchase Agreement, dated November 16, 2011, by and among SXC Health Solutions, Inc., HealthTran LLC, HealthTrans Data Services, LLC, ABRY Senior Equity II, L.P., ASE II-A HealthTran, L.P., ABRY Senior Equity Co-Investment, L.P., The Jack and Mary McClurg Exempt Trust, The Hutchison Family Exempt Trust, Jack W. McClurg, both in his individual capacity and in his capacity as the trustee of The Jack and Mary McClurg Exempt Trust, Louis W. Hutchison, Jr., both in his individual capacity and in his capacity as the trustee of The Hutchison Family Exempt Trust, and HealthTrans Data Services, LLC, in its capacity as the Sellers' Agent thereunder* (incorporated by reference to Exhibit 2.1 to the January 5 Form 8-K)
23.1
 
Consent of Grant Thornton LLP
99.1
 
Press release of SXC Health Solutions Corp. issued January 4, 2012 (incorporated by reference to Exhibit 99.1 to the January 5 Form 8-K)
99.2
 
Audited consolidated balance sheets of HealthTran as of May 31, 2011 and May 31, 2010 and related audited consolidated statements of earnings, changes in members' deficit and cash flows for the fiscal years ended May 31, 2011 and May 31, 2010, including the notes thereto
99.3
 
Unaudited consolidated balance sheet of HealthTran as of November 30, 201, and related unaudited consolidated statements of earnings, changes in members' deficit and cash flows for the six months ended November 30, 2011 and 2010, including the notes thereto
99.4
 
Unaudited pro forma combined balance sheet of SXC and HealthTran (excluding the TPA Business) as of December 31, 2011 and the unaudited pro forma combined statement of operations of SXC and HealthTran (excluding the TPA Business) for the year ended December 31, 2011, including the notes thereto
__________________
*
The registrant agrees to furnish supplementally to the Securities and Exchange Commission a copy of any omitted schedule or exhibit upon the request of the Securities and Exchange Commission in accordance with Item 601(b)(2) of Regulation S-K.




EX-23.1 2 ex231gtconsent.htm EX 23.1 GT consent
EX 23.1

Consent of Independent Certified Public Accountants


The Board of Directors
SXC Health Solutions Corp.:

We have issued our report dated August 31, 2011 with respect to the consolidated financial statements of HealthTran LLC for the years ended May 31, 2011 and 2010 included in the Current Report on Form 8-K/A dated March 14, 2012 of SXC Health Solutions Corp.  We hereby consent to the incorporation by reference of said report in the Registration Statements of SXC Health Solutions Corp. on Form S-3 (File No. 333-161237) and on Form S-8 (File Nos. 333,174671, 333-164021, 333-159733, 333-145450, 333-145449 and 333-136402).

/s/ Grant Thornton LLP

Denver, Colorado
March 14, 2012



EX-99.2 3 ex992ht2011auditedfinancia.htm EX 99.2 HT2011auditedfinancials
EX 99.2
















HEALTHTRAN LLC

FINANCIAL STATEMENTS AND REPORT OF INDEPENDENT CERTIFIED PUBLIC ACCOUNTANTS

PREPARED FOR THE YEARS ENDED MAY 31, 2011 AND 2010







Contents

    




Report of Independent Certified Public Accountants


The Management Committee and Members of Management
HealthTran LLC
We have audited the accompanying balance sheets of HealthTran LLC (the “Company”) as of May 31, 2011 and 2010, and the related statements of earnings, changes in members' deficit, and cash flows for the years then ended. These financial statements are the responsibility of the Company's management. Our responsibility is to express an opinion on these financial statements based on our audits.
We conducted our audits in accordance with auditing standards generally accepted in the United States of America as established by the Auditing Standards Board of the American Institute of Certified Public Accountants. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes consideration of internal control over financial reporting as a basis for designing audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the Company's internal control over financial reporting. Accordingly, we express no such opinion. An audit also includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements, assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audits provide a reasonable basis for our opinion.
In our opinion, the financial statements referred to above present fairly, in all material respects, the financial position of HealthTran LLC as of May 31, 2011 and 2010, and the results of its operations and its cash flows for the years then ended, in conformity with accounting principles generally accepted in the United States of America.
Our audits were conducted for the purpose of forming an opinion on the basic financial statements taken as a whole. The schedule of adjusted EBITDA on page 20 is presented for purposes of additional analysis and is not a required part of the basic financial statements. Such information has not been subjected to the auditing procedures applied in the audits of the basic financial statements and, accordingly, we express no opinion on it.
/s/Grant Thornton LLP
Denver, Colorado
August 31, 2011


3

HealthTran LLC

Balance sheets

 
As of May 31,
 
2011
 
2010
Assets
 
 
 
Current assets
 
 
 
Cash and cash equivalents
$
11,475,245

 
$
13,933,725

Restricted cash
663,954

 
722,211

Trade accounts receivable, less allowances for doubtful accounts of $404,693 and $289,000, respectively
22,896,251

 
24,813,110

Other current assets
1,713,657

 
1,600,270

Total current assets
36,749,107

 
41,069,316

 
 
 
 
Property and equipment, net
6,598,507

 
6,437,092

Goodwill
4,403,815

 
4,403,815

Intangibles, net
13,814,520

 
17,204,716

Customer acquisition costs, net
204,781

 
371,827

Debt issuance costs, net
1,411,156

 
1,842,509

Total assets
$
63,181,886

 
$
71,329,275

 
 
 
 
Liabilities and members' deficit
 
 
 
Current liabilities
 
 
 
Accounts payable
$
1,052,883

 
$
1,031,272

Current portion of revolving loan

 
605,118

Current portion of long-term debt
2,523,945

 
6,679,430

Current portion of capital leases
270,299

 
312,788

Current portion of deferred revenue
219,044

 
497,834

Current portion of deferred rent and landlord incentives
336,146

 
302,864

Deposits received
7,613,430

 
6,773,820

Pharmacy network payable
10,665,081

 
18,655,859

Rebates payable
4,949,260

 
6,766,643

Accrued expenses
9,820,131

 
6,683,968

Other liabilities – current
3,691,492

 
2,859,105

Total current liabilities
41,141,711

 
51,168,701

 
 
 
 
Capital leases, less current portion
146,671

 
163,249

Revolving loan, net of current portion

 
8,094,882

Long-term debt, net of current portion and discount
13,246,125

 
8,124,998

Class C preferred units dividends payable (Note E)
5,046,483

 
655,890

Class C preferred units subject to mandatory redemption, net of discount (Notes D and E)
24,983,539

 
24,081,083

Class A warrants subject to put (Note D)
6,693,539

 
6,317,193

Deferred revenue, less current portion
5,594

 
15,368

Deferred rent and landlord incentives, less current portion
560,724

 
920,499

Other liabilities, less current portion

 
997,251

Total liabilities
91,824,386

 
100,539,114

 
 
 
 
Members’ deficit
(28,642,500
)
 
(29,209,839
)
Total liabilities and members’ deficit
$
63,181,886

 
$
71,329,275



The accompanying notes are an integral part of these financial statements

4

HealthTran LLC

Statements of earnings
 
Years ended May 31,
 
2011
 
2010
 
 
 
 
Revenue
 
 
 
Pharmacy benefit administration
$
250,418,554

 
$
280,244,472

Service revenue
15,171,657

 
15,381,628

Total revenue
265,590,211

 
295,626,100

 
 
 
 
Direct pharmacy benefit administration expenses, excluding depreciation and amortization
215,409,047

 
250,747,277

Gross profit
50,181,164

 
44,878,823

 
 
 
 
Operating expenses
 
 
 
Selling, general and administrative expenses
33,613,760

 
32,106,095

Depreciation and amortization
6,543,263

 
7,783,881

Total operating expenses
40,157,023

 
39,889,976

 
 
 
 
Earnings from operations
10,024,141

 
4,988,847

 
 
 
 
Interest income
1,400

 
25,771

Interest expense
(1,916,134
)
 
(1,531,329
)
Dividends on Class C preferred units
(4,519,815
)
 
(1,851,600
)
Accretion of Class C preferred units discount
(902,456
)
 
(398,276
)
Net earnings
$
2,687,136

 
$
1,233,413


The accompanying notes are an integral part of these financial statements







5

HealthTran LLC

Statements of changes in members’ deficit
 
 
 
 
 
 
 
Member Interests
 
Warrants
 
Total
 
 
 
 
 
 
Balances at June 1, 2009
$
1,911,338

 
$
746,898

 
$
2,658,236

 
 
 
 
 
 
Net earnings
1,233,413

 

 
1,233,413

Distributions (Note D)
(31,262,860
)
 

 
(31,262,860
)
Stock-based compensation expense (Note E)
1,602,000

 

 
1,602,000

Redemption of Class B units (Note E)
(1,602,000
)
 

 
(1,602,000
)
Exercise of warrants for Class A units (Note D)
1,398,622

 
(198,622
)
 
1,200,000

Redemption of Class A units (Note D)
(3,000,000
)
 

 
(3,000,000
)
Cumulative effect of adoption of accounting for
  uncertain tax positions (Note B)
(38,628
)
 

 
(38,628
)
Balances at May 31, 2010
(29,758,115
)
 
548,276

 
(29,209,839
)
 
 
 
 
 
 
Net earnings
2,687,136

 

 
2,687,136

Distributions
(2,119,797
)
 

 
(2,119,797
)
Balances at May 31, 2011
$
(29,190,776
)
 
$
548,276

 
$
(28,642,500
)


The accompanying notes are an integral part of these financial statements




6

HealthTran LLC

Statements of cash flows
 
Years ended May 31,
 
2011
 
2010
Operating activities
 
 
 
Net earnings
$
2,687,136

 
$
1,233,413

Adjustments to reconcile net earnings to net cash provided by operating activities
 
 
 
Depreciation expense
2,830,371

 
3,973,278

Amortization on customer acquisition costs
329,424

 
443,881

Amortization on purchased intangible assets
3,383,468

 
3,366,722

Amortization of debt issuance costs and debt discount
705,489

 
292,066

Amortization of landlord incentives
220,625

 
220,625

Accretion of Class C preferred units discount
902,456

 
398,276

Accretion of dividend on Class C preferred units
4,519,815

 
1,851,600

Interest expense due to change in fair value of Class A warrants subject to put
376,346

 

Stock-based compensation expense

 
1,602,000

Provision for bad debts
235,363

 
96,703

(Gain) Loss on disposal of property and equipment
6,072

 
(944
)
Net change in operating assets and liabilities
 
 
 
Decrease in restricted cash
58,258

 
213,569

Decrease in trade accounts receivable
1,681,496

 
4,777,440

Decrease (increase) in other current assets
(113,387
)
 
344,426

(Decrease) Increase in accounts payable
21,611

 
(1,206,999
)
Increase (decrease) in accrued expenses, deposits received, pharmacy network and rebates payable
(5,806,260
)
 
129,111

Decrease in deferred revenue
(288,564
)
 
(471,393
)
Decrease in deferred rent
(547,118
)
 
(479,194
)
Decrease in other liabilities
(164,864
)
 
(615,858
)
Net cash provided by operating activities
11,037,737

 
16,168,722

 
 
 
 
Investing activities
 
 
 
Purchases of property and equipment
(2,674,146
)
 
(2,079,082
)
Purchase of intangible assets
(19,400
)
 

Customer acquisition costs
(162,378
)
 
(15,846
)
Proceeds from disposal of assets

 
944

Net cash used in investing activities
(2,855,924
)
 
(2,093,984
)
 
 
 
 
Financing activities
 
 
 
Payments on long-term debt
(14,846,705
)
 
(7,276,724
)
Payments on revolving loan
(13,200,000
)
 
(8,000,000
)
Proceeds from revolving loan
4,500,000

 
8,700,000

Proceeds from new debt
15,538,211

 

Payments on capital leases
(382,780
)
 
(417,409
)
Proceeds from issuance of Class C preferred units

 
30,000,000

Exercise of warrants for Class A units

 
1,200,000

Distributions
(2,119,797
)
 
(31,262,860
)
Redemption of Class A units

 
(3,000,000
)
Redemption of Class B units

 
(1,602,000
)
Debt issuance costs incurred

 
(1,776,280
)
Dividend distributions on Class C preferred units
(129,222
)
 
(1,195,710
)
Net cash used in financing activities
(10,640,293
)
 
(14,630,983
)
Net decrease in cash and cash equivalents
(2,458,480
)
 
(556,245
)
 
 
 
 
Cash and cash equivalents at beginning of year
13,933,725

 
14,489,970

Cash and cash equivalents at end of year
$
11,475,245

 
$
13,933,725

 
 
 
 
Supplemental disclosure of cash flow information
 
 
 
Cash paid during the period for interest
$
756,517

 
$
1,093,664

 
 
 
 
Noncash investing and financing activities
 
 
 
Adjustments to installment payments for purchase of business (Note I)
$
26,128

 
$
535,100

Property and equipment acquired with capital leases
$
323,713

 
$


The accompanying notes are an integral part of these financial statements

7

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements


Note A – Organization and basis of presentation

HealthTran LLC (the “Company”), a limited liability company registered in the state of Delaware, was established on September 18, 2000. The Company provides benefit administration services, including claims processing, benefit plan design, plan implementation, pharmacy networks, mail service, eligibility management, customer services, data reporting, drug utilization management, formulary management and contracting, communication and enforcing therapy guidelines to physicians, pharmacists, and patients, as well as consulting services.
Note B – Summary of accounting policies
Cash and cash equivalents
The Company considers all highly liquid cash investments with original maturity dates of three months or less to be cash equivalents. Cash subject to restrictions that prevents its use for current purposes is segregated in the balance sheets and discussed further in Note H.
Income taxes
Limited liability companies are not taxable entities under provisions of the Internal Revenue Code and, accordingly, the accompanying financial statements do not reflect a provision for federal or state income taxes. The tax effects of the Company’s earnings are the responsibility of the members.
The Company adopted policies to account for unrecognized tax benefits on June 1, 2009. The Company recognizes the financial statement benefit of a tax position only after determining that the relevant tax authority would more likely than not sustain the position following an audit. For tax positions meeting the more-likely-than-not threshold, the amount recognized in the financial statements is the largest benefit that has a greater than 50 percent likelihood of being realized upon ultimate settlement with the relevant tax authority. The adoption of these policies did not have a material effect on the Company’s financial statements.
As a result of the Company’s adoption of these policies, the Company recorded $38,628 as a liability for unrecognized tax benefits as of June 1, 2009. The reconciliation of the beginning and ending amount of unrecognized tax benefits is as follows:
 
Years ended May 31, 2010 and 2011
Balance at June 1, 2009
$
38,628

Additions for tax positions of prior years
-

Additions for tax positions of current year
44,755

Balance at May 31, 2010
83,383

Additions for tax positions of prior years
105,393

Additions for tax positions of current year
52,730

Settlements
(61,309
)
Balance at May 31, 2011
$
180,197

The Company recognizes interest and penalties accrued related to unrecognized tax benefits, if any, in operating expenses for all periods presented.
Use of estimates
The preparation of financial statements in conformity with accounting principles generally accepted in the United States requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at the date of the financial statements and the reported amounts of revenues and expenses during the reporting period. Actual results could differ from those estimates.









8

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

Property and equipment
Property and equipment, including property and equipment under capital leases, are recorded at cost. Maintenance and repairs are expensed as incurred. Improvements that extend the useful lives of the assets or provide improved efficiency are capitalized. Leasehold improvements are amortized using the straight-line method, over the shorter of the useful life or the lease term. Depreciation of property and equipment is computed using the straight-line method, over the estimated useful lives of the assets:
Computer equipment
3 to 5 years
Computer equipment – acquired assets
1 to 3 years
Furniture, fixtures and equipment
5 to 7 years
Software
1.5 to 5 years
Building
39 years

External direct costs of materials and services consumed in developing or obtaining internal use computer software, and payroll and payroll-related costs for employees who are directly associated with and who devote time to an internal use computer software project, to the extent of the time spent directly on the project, are capitalized.
Goodwill
Goodwill represents the excess of the purchase price over the fair value of identifiable tangible and intangible net assets relating to business acquisitions. Goodwill and intangible assets with indefinite useful lives are not amortized but instead are tested for impairment annually. For purposes of testing for goodwill impairment, the Company has determined that it has multiple reporting units with goodwill only assigned to one reporting unit.
For the periods presented, the Company does not have any indefinite-lived intangible assets, other than goodwill. Impairment testing is performed in two steps: (i) the Company assesses goodwill for potential impairment by comparing the fair value of the reporting unit with its carrying value, and (ii) if potential impairment is indicated because the reporting unit’s fair value is less than its carrying amount, the Company measures the amount of impairment loss by comparing the implied fair value of goodwill with the carrying amount of that goodwill. As of May 31, 2011 and 2010, no impairment losses were recognized on the Company’s goodwill.
During the year ended May 31, 2010, the Company reduced goodwill by $101,931, related to a reduction in the estimated future installment payments associated with its acquisition of a U.S. based prescription benefit management company. See Note I for further discussion.
Impairment of long-lived assets
The Company evaluates long-lived assets, such as property and equipment and purchased intangible assets with finite lives, for impairment whenever events or changes in circumstances indicate the carrying value of an asset may not be recoverable. The fair value of the asset(s) is assessed based on the undiscounted future cash flows the asset(s) is expected to generate and the Company recognizes an impairment loss when estimated undiscounted future cash flows expected to result from the use of the asset(s) plus net proceeds expected from disposition of the asset(s), if any, are less than the carrying value of the asset(s). When an impairment is identified, the carrying amount of the asset(s) is reduced to its estimated fair value based on a discounted cash flow approach or, when available and appropriate, to comparable market values.
Identifiable intangible assets include amounts paid to acquire non-compete agreements and customer relationships. These costs are capitalized and amortized on a straight-line basis over their estimated useful lives that range from 3–13 years. These assets are reviewed for impairment whenever events or circumstances indicate that their carrying amount may not be recoverable.
During 2011 and 2010, there was no indication that the carrying amounts of the Company’s long-lived assets may not be recoverable.
Debt issuance costs
Costs incurred to arrange financing, including advisory fees, legal fees, and loan origination fees, are capitalized as debt issuance costs. Such costs are amortized over the life of the related financing on a straight-line basis. The amortization of debt issuance costs is included in interest expense in the statements of earnings. Unamortized debt issuance costs related to a previous credit agreement were charged to interest expense during the year when the previous credit agreement ended.
Revenue recognition
Pharmacy benefit administration
Revenue from sales of prescription drugs by pharmacies in the Company’s third-party networks is recognized when the claims are adjudicated (approved or denied). When the Company bills/collects from its customers and pays its pharmacy network providers under

9

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

separate contracts, the Company records amounts due from its customers as revenue and amounts due to its pharmacy network providers as expense. Revenues and expenses are inclusive of any member co-payments collected by the pharmacy network providers.
Management has determined that the Company acts as the principal in its network transactions. The Company acts as a principal due to its: having separate contractual relationships with customers and with pharmacies; performing part of the service and responsibility to validate and economically manage a claim through its claims adjudication process; setting prescription prices for the pharmacy, including instructing the pharmacy as to how that price is to be settled (co-payment requirements); having discretion in supplier selection; having credit risk for the price due from the customer; and involvement in the determination of product or service specifications.
The Company also performs rebate-processing services for which it earns revenue. Amounts received and amounts paid by the Company are recorded on a gross basis and separately presented as a component of revenues and expenses, respectively. Management has determined that the Company acts as the principal in its rebate transactions. The Company acts as a principal due to its: responsibility for collections of amounts due from pharmaceutical companies and aggregators; independent contracts entered into with the pharmaceutical companies, aggregators and suppliers; performing part of the service including the responsibility to validate and manage claims through the billing, collection, reporting and payment processes.
When rebates originate from the sale of prescription drugs by pharmacy network providers filling prescriptions under the Company’s pharmacy network contracts, the Company reduces expenses by the amount of the rebate earned and deducts from its revenues any rebates paid to its customers.
Service revenue
The Company’s service revenue consists of claims processing and consulting services. The Company recognizes claims processing revenue on a per transaction basis upon the completion of processing the claim transaction. Consulting services revenue is recognized as services are performed.
Deferred revenue and customer acquisition costs
The Company typically enters into multiple year contracts with customers and may receive fees from customers at the beginning of a contract generally referred to as implementation fees. When received, the Company records these fees as deferred revenue and amortizes the balance on a straight-line basis over the contract term.
As of May 31, 2011 and 2010, the Company recorded deferred revenue totaling $224,638 and $513,202 respectively, of which $219,044 and $497,834 respectively, are included in current liabilities and $5,594 and $15,368 respectively, are reported as long-term deferred revenue.
The Company is capitalizing certain incremental direct costs related to the acquisition of customer contracts, and capitalizes setup and other direct installation activities performed at the inception of a specific arrangement with a specific customer enabling performance under the terms of a specific arrangement with the customer. These costs are collectively referred to as “customer acquisition costs.” Customer acquisition costs are amortized on a straight-line basis over the contract term.
As of May 31, 2011 and 2010, customer acquisition costs, net of accumulated amortization, totaled $204,781 and $371,827, respectively. Amortization expense for the years ended May 31, 2011 and 2010 was $329,424 and $443,881 respectively, and is included in operating expenses.
Receivables
All of the Company’s trade receivables are due from customers. Credit is extended based on an evaluation of a potential customer’s financial condition and collateral is not required. Amounts billed to customer accounts are generally due within 30 days, and become past due after such time. Accounts considered past due are subject to additional interest charges and penalties at the discretion of Company management.
The Company presents its receivables due from customers net of an allowance for doubtful accounts. The Company determines its allowance by considering a number of factors, including length of time the account is past due, the Company’s previous history with the customer, the customer’s current ability to pay its obligation, and the condition of the general economy and industry as a whole.
When the Company earns revenue before billing its customers, due to minimum invoice thresholds or other criteria determined by management, the Company reports the revenue in the relevant revenue category described previously. The aggregate unbilled amount is recorded as unbilled receivables.

10

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

Deferred rent and landlord incentives
The Company recognizes rent expense on a straight-line basis under non-cancelable operating lease agreements conveying the right to use property or equipment for a stated period of time. As of May 31, 2011 and 2010, the Company had $326,922 and $432,790 of deferred rent which is included in deferred rent and landlord incentives on the balance sheets which reflects the difference between cash payments to the landlord and the amount recorded as rent expense during the years ended May 31, 2011 and 2010, respectively.
When the Company receives allowances or incentives from a landlord for leasehold improvements (“LHI”), the LHI allowance received from the landlord is recorded as deferred rent and amortized as a reduction to rent expense on a straight-line basis over the lease term. During the years ended May 31, 2011 and 2010, the Company amortized $220,625 and $220,625, respectively, of the allowance as a reduction to rent expense. As of May 31, 2011 and 2010, the Company had $569,948 and $790,573, respectively, of unamortized LHI allowances which was recorded as deferred rent and landlord incentives on the balance sheets.
Advertising expense
The Company expenses advertising costs, as incurred. Advertising costs for the years ended May 31, 2011 and 2010 was $699,867 and $139,491, respectively.
Reclassifications
Certain prior period balances have been reclassified to conform to the current year’s presentation. In the prior year balance sheets, customer prepayments relating to a United States-based prescription benefit management company acquired by the Company in December 2007 were presented as part of trade accounts receivable. In the current year’s presentation, it was determined appropriate to reclassify such prepayments as deposits received in the accompanying balance sheets.
Note C – Property and equipment

Property and equipment, including owned equipment and equipment under capital leases, consists of the following:
 
As of May 31, 2011
 
Owned
Leased
Total
Buildings and land
$
281,177

$

$
281,177

Computer equipment
6,182,893

289,071

6,471,964

Furniture, fixtures and equipment
957,196

957,200

1,914,396

Software
14,305,644

13,787

14,319,431

Leasehold improvements
1,963,233

-

1,963,233

 
23,690,143

1,260,058

24,950,201

Less accumulated depreciation
(17,669,049
)
(682,645
)
(18,351,694
)
Total property and equipment
$
6,021,094

$
577,413

$
6,598,507


 
As of May 31, 2010
 
Owned
Leased
Total
Buildings and land
$
281,174

$

$
281,174

Computer equipment
5,729,728

155,916

5,885,644

Furniture, fixtures and equipment
761,795

957,200

1,718,995

Software
11,847,489

322,874

12,170,363

Leasehold improvements
1,953,395

-

1,953,395

 
20,573,581

1,435,990

22,009,571

Less accumulated depreciation
(14,710,140
)
(862,339
)
(15,572,479
)
Total property and equipment
$
5,863,441

$
573,651

$
6,437,092


Depreciation expense includes depreciation on owned assets in addition to assets recorded under capital leases. Depreciation expense for the years ended May 31, 2011 and 2010 was $2,830,371 and $3,973,278, respectively.

11

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

Note D – Debt

Long-term debt consists of the following:
 
As of May 31,
 
2011
2010
Term Note
$
14,843,750

$
14,113,833

Term Note discount

(274,136
)
Key Note payable 1

7,399

Key Note payable 3
425,645

957,332

Key Note payable 4
383,433


Key Note payable 5
117,242


Class C preferred units subject to mandatory redemption
30,000,000

30,000,000

Class C preferred units discount
(5,016,461
)
(5,918,917
)
Class A warrants subject to put
6,693,539

6,317,193

Total debt
47,447,148

45,202,704

Less current portion
(2,523,945
)
(6,679,430
)
Total long-term debt
$
44,923,203

$
38,523,274


Credit Agreement
In May 2011, the Company entered into a new debt agreement (the “Credit Agreement”) with a finance company to refinance its Senior Debt Facility and provide additional working capital. The Credit Agreement includes both a revolving line of credit (the “Revolver”) and a term note (the “Term Note”). The Revolver of $10,000,000 and Term Note of $15,000,000 are secured by substantially all the assets of the Company and require the Company to comply with certain financial covenants including a fixed charge coverage ratio and senior debt leverage ratio, as determined on a quarterly basis, and to comply with certain non-financial covenants. As of May 31, 2011 and 2010, the Company was in compliance with the covenant requirements under the Credit Agreement and previous Senior Debt Facility, respectively.
Under the Credit Agreement, the Revolver and Term Note bear interest at rates equal to the Prime Rate plus the Applicable Margin. As of May 31, 2011, the interest rates for the Revolver and Term Note were 3.25% and 3.25%, respectively. As of May 31, 2010, the interest rates under the Company’s previous Senior Debt Facility’s term note and revolving line of credit were 3.25% and 4.25%, respectively.
Revolver
The Company may borrow up to the lesser of $10,000,000 or 80% of the Company’s eligible non-rebate accounts receivable and 70% of the Company’s eligible rebate accounts receivable, as reduced by certain letters of credit, corporate credit card, and merchant credit card processing reserves. Revolving loans may be borrowed, repaid and reborrowed, until May 3, 2016 (the term loan maturity date), on which date the entire unpaid principal balance of the revolving loan and all accrued and unpaid interest thereon shall be due and payable. After the term loan maturity date, no further revolving loans shall be made. As of May 31, 2011, $7,614,456 was available for borrowing under the revolver based on eligible accounts receivable.
The balance outstanding on the Revolver at May 31, 2011 was $0. Under the Company’s prior Senior Debt Facility revolver, the outstanding line was $8,700,000 as of May 31, 2010. Interest is due and payable monthly.
Term Note
The Term Note matures on May 3, 2016, and bears interest on the outstanding principal, payable monthly. Principal payments on the note are due in 60 monthly installments commencing on May 31, 2011. The first 12 monthly installments are in the amount of $156,250; the next 36 monthly installments are in the amount of $250,000; and the last 12 installments are in the amount of $343,750. Of the $15,000,000 of net proceeds from the new Term Note, $9,830,059 was used to repay all amounts outstanding under the Senior Debt Facility with the remaining $5,169,941 retained by the Company for working capital purposes. All unamortized related debt discount relating to the former Senior Debt Facility was expensed as interest expense. The amortized debt discount as of May 31, 2010 was $274,136, relating to the former Senior Debt Facility.

12

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

Warrants
In conjunction with the Company’s previous Senior Debt Facility, the finance company received multiple warrants:
In conjunction with the previous Senior Debt Facility agreement, a warrant was issued in March 2005 which expires in 2012, to purchase 300,000 Class A membership units of the Company for $4 per unit (aggregate of $1,200,000). The warrant was allocated a value of $198,622, based on the relative fair values of the debt and the warrant. The Company has the option to purchase the warrant for $4,800,000 at any time.
In conjunction with the revised previous Senior Debt Facility agreement, a warrant was issued in December 2007, which expires in 2014, to purchase 104,667 Class A membership units of the Company for $11.46 per unit (aggregate of $1,200,000). The warrant was allocated a value of $548,276, based on the relative fair values of the debt and the warrant. The Company has the option to purchase the warrant for $4,800,000 at any time.
Upon the close of the securities purchase agreement in December 2009, the previous finance company exercised its warrant to purchase Class A units which were issued in 2005 as part of the original Credit Agreement. The previous finance company purchased 300,000 Class A units at $4 per unit (aggregate of $1,200,000). The Class A units relating to the exercise of this warrant were subsequently redeemed by the Company for $3,000,000 (at $10 per unit).
In conjunction with the securities purchase agreement executed in December 2009, the warrant issued in 2007 was amended as follows: (1) the number of units was amended to 113,270 from 104,667, and (2) the warrant price was amended to $7.65 from $11.46. These adjustments were made pursuant to an antidilution agreement entered into in conjunction with the warrant agreement that allowed for adjustments to the warrant price and number of shares for diluting issuances such as the securities purchase transaction completed in December 2009.
Key Notes payable
In September 2005, the Company borrowed $125,243 under Key Note payable 1 to finance equipment purchases. The Key Note payable 1 matured on September 30, 2010. Monthly principal and interest payments were due in sixty equal installments of $2,496 beginning September 30, 2005. The effective interest rate on the Key Note payable 1 was 7.54%. The balance of the payable at May 31, 2011 and 2010 was $0 and $7,399, respectively.
In February 2007, the Company borrowed $2,450,262 under Key Note payable 3 to finance equipment purchases. The Key Note payable 3 matures on March 6, 2012. Monthly principal and interest payments are due in sixty equal installments of $48,782 beginning March 6, 2007. The effective interest rate on the Key Note payable 3 is 7.49%. The balance of the payable at May 31, 2011 and 2010 was $425,645 and $957,332, respectively.
In February 2011, the Company borrowed $416,180 under Key Note payable 4 to finance equipment purchases. The Key Note payable 4 matures on February 24, 2015. Monthly principal and interest payments are due in forty-eight equal installments of $9,230 beginning March 24, 2011. The effective interest rate on the Key Note payable 4 is 3.10%. The balance of the payable at May 31, 2011 and 2010 was $383,433 and $0, respectively.
In April 2011, the Company borrowed $122,031 under Key Note payable 5 to finance equipment purchases. The Key Note payable 5 matures on April 29, 2015. Monthly principal and interest payments are due in forty-eight equal installments of $2,706 beginning May 29, 2011. The effective interest rate on the Key Note payable 5 is 3.10%. The balance of the payable at May 31, 2011 and 2010 was $117,242 and $0, respectively.
Class C preferred units subject to mandatory redemption and Class A warrants subject to put
In December 2009, the Company entered into a securities purchase agreement (the “Agreement”) with an investing party as part of a minority recapitalization transaction. Under this Agreement, in exchange for $30,000,000 in net proceeds received, the Company issued 30,000 units of a newly created equity class designated Class C preferred units (the “Class C preferred”), as well as warrants to purchase 860,114 units of the Company’s Class A units (the “Class A warrants”). In conjunction with this transaction, the Company incurred approximately $1.8 million in transaction costs. Of the $30,000,000 in proceeds received, $28,398,000 was distributed to the sole holder of the Company’s Class A units, and $1,602,000 was used to redeem certain Class B units (refer to Note E).
Refer to Note E for the key features of the Class C preferred.
Key features of the Class A warrants issued include:

13

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

Immediately exercisable into 860,114 Class A units, representing an approximate 7.5% common equity interest in the Company, at an exercise price of $.001 per unit;
Fully detachable from the Agreement and Class C preferred units;
Put rights granted to the investing party are exercisable at any time on or after (i) an uncured or non-waived event of default, (ii) a change of control or any redemption of the Class C preferred, or (iii) December 22, 2016 (the mandatory redemption date for the Class C preferred).
Put rights granted include both the Class A warrants and the underlying Class A units issuable under the warrants upon exercise by the investing party;
Put price to be paid by the Company equal to:
For Class A units – liquidation value per unit calculated assuming all outstanding options/warrants of the Company exercised
For Class A warrants – liquidation value per unit calculated assuming all outstanding options/warrants of the Company exercised, less exercise price payable under Warrant.
The Company may call all of the warrants/underlying Class A units held upon first anniversary of the redemption of the Class C preferred.
Class C preferred units subject to mandatory redemption and Class A warrants subject to put (continued)
The fair value of the Class A warrants subject to put was determined to be $6,317,193 on the date of issuance. As of the end of each reporting period, management is required to re-measure the estimated value of the Company’s Class A units to determine any change in the fair value of the Class A warrants subject to put, and will record any change in such value to interest expense. As of May 31, 2010, management believed the Class A warrants’ carrying value of $6,317,193 still fairly approximated the estimated fair value of these warrants. Based on a revaluation analysis conducted as of May 31, 2011, the fair value of the Class A warrants subject to put was re-measured at $6,693,539, with the resulting increase in fair value of $376,346 recognized as interest expense for the year ended May 31, 2011.
Because of the mandatory redemption features of the Class C preferred units and the put rights of the Class A warrants, both are required to be recorded as debt rather than equity. Furthermore, the initial value of the Class A warrants has been recorded as a discount against the Class C preferred units and this discount will be accreted to a non-operating expense account on a straight line basis through December 22, 2016, the mandatory redemption date of the Class C preferred units.
The transaction costs incurred relating to the Agreement have been treated as a deferred charge and are being amortized to interest expense from the date of issuance through the mandatory redemption date of the Class C preferred (i.e. through December 22, 2016).
Maturities of total debt are as follows:
 
As of May 31, 2011
Year ending May 31,
 
2012
$
2,523,945

2013
3,133,624

2014
3,137,826

2015
3,193,425

2016
3,781,250

Thereafter
31,677,078

Total debt
$
47,447,148








14

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

Note E – Membership units

The Company has three classes of membership units: Class A units, Class B units and Class C preferred units.
Class A units
At May 31, 2011 and 2010, the Company had 9,700,000 Class A units authorized, issued and outstanding. Holders of Class A units are entitled to one vote for each share held and generally vote as a single class. Class A units are entitled to allocation of earnings or losses generated by the Company’s operations, subject to limitations relating to the Class C preferred units.
Class B units
At May 31, 2011 and 2010, the Company had 794,800 Class B units authorized with 496,000 and 416,800 units issued and outstanding, respectively. Key features of the Class B units include:
The Class B units are granted to key employees, officers, directors and other service providers of the Company and do not have an exercise price, vest immediately, do not expire, are non-transferable, do not have any voting rights with respect to the Company, and do not have allocation rights to net income or net loss generated by the Company’s operations;
Holders of the Class B units only have the right to receive distributions from the Company in connection with the sale of all or substantially all of the Company’s assets (i.e. upon a qualifying “change of control event”) provided the holder is still employed by the Company at the time of the change of control event (i.e. the units are immediately forfeited upon the voluntary or involuntary termination of the employee’s employment with the Company prior to a change of control event);
The Company has the right to call the Class B units upon a change of control event.
In December 2009, in conjunction with the closing of the securities purchase agreement (see Note D), the owners of the Company elected to redeem 160,200 Class B units at a purchase price of $10 per unit ($1,602,000 in aggregate). The Company recorded this transaction as stock-based compensation within the statements of earnings.
In the event a qualifying change of control event was to occur as of May 31, 2011, the Company estimates the redemption value of the outstanding Class B units would be approximately $3,900,000. As of May 31, 2011, a qualifying change of control event was not considered probable; therefore, no stock-based compensation has been recorded in the accompanying consolidated financial statements relating to Class B units outstanding as of May 31, 2011.
Class C preferred units subject to mandatory redemption
At May 31, 2011 and 2010, the Company had 30,000 and 30,000 Class C preferred units (the “Class C preferred”) authorized, respectively, with 30,000 and 30,000 units issued and outstanding, respectively. Key features of the Class C preferred units include:
14% annual preferred yield, compounded quarterly. Prior to redemption, dividends may be paid at the discretion of the Company subject to restrictions under the Credit Agreement (as described below);
Liquidation value equal to unpaid Class C preferred capital plus unpaid Class C preferred dividends;
Mandatory redemption on December 22, 2016 at the liquidation value;
Redemption or payment of dividends related to Class C preferred is subject to compliance with all covenants of the Credit Agreement with the Company’s finance company;
Pursuant to the Agreement and the Company’s amended limited liability company agreement, tax distributions are permitted to be paid to the holders of Class A units and Class C preferred, subject to limits placed by the Credit Agreement.
Class C preferred units subject to mandatory redemption (continued)
Class C preferred unit dividends were $4,519,815 and $1,851,600, for the years ended May 31, 2011 and 2010, respectively. As of May 31, 2011 and 2010, $5,046,483 and $655,890, respectively, in Class C preferred unit dividends payable is included in long-term debt within the accompanying balance sheets. Prior to redemption of the Class C preferred units, dividends may be paid at the discretion of the Company.


15

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

Note F – Commitments and contingencies
Operating leases
The Company leases its office space as well as equipment under non-cancelable agreements. Rent expense was $1,201,393 and $1,210,909, respectively, for the years ended May 31, 2011 and 2010.
Future minimum lease payments under operating leases are as follows:
 
As of May 31, 2011
Year ending May 31,
 
2012
$
1,375,577

2013
1,338,448

2014
745,655

2015
87,273

2016
16,793

Thereafter

Total future minimum operating lease payments
$
3,563,746


Capital leases
The Company leases certain equipment under capital lease agreements. Future minimum lease payments under capital leases are as follows:
 
As of May 31, 2011
Year ending May 31,
 
2012
$
280,054

2013
111,831

2014
37,277

Total future minimum capital lease payments
429,162

Less amounts representing interest
(12,192
)
Present value of minimum capital lease payments
416,970

Less current portion
(270,299
)
Future minimum rental payments, net
$
146,671


Litigation
During the year ended May 31, 2009, a former client filed a lawsuit in the district Court of Arapahoe County, Colorado against the Company. The complaint alleged, among other things, breach of contract. The Company answered the former client’s claims and brought counterclaims alleging, among other things, breach of contract and unjust enrichment. In January 2011, the former client’s receivership agent and the Company entered into a settlement agreement for all claims of both parties. In accordance with the terms of the settlement agreement, the Company made a payment totaling $200,000 to the former client in January 2011.
During the year ended May 31, 2010, a former client alleged damages suffered by it due to actions or inactions of the Company over the last several years, and elected to pursue arbitration against the Company. An arbitration hearing was held in May 2011 and closing briefs were submitted by both parties to the arbitrator in July 2011. The Company expects a decision in the fall of 2011.
The Company is subject to other legal proceedings and claims that arise in the ordinary course of business. In the opinion of management, these other actions are unlikely to materially affect the Company’s financial position.






HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

Note G – Affiliate and related party transactions

The Company entered into a service agreement with J&L Management Services, LLC, related through common ownership, to receive various management services. J&L Management Services, LLC has billed the Company $500,004 and $628,335, respectively, for the years ended May 31, 2011 and 2010, related to this service agreement. As of both May 31, 2011 and 2010, there were no amounts due from or to J&L Management Services, LLC.
Note H – Restricted cash
On September 5, 2006, in connection with the Company’s office space lease, the Company issued a $640,000 letter of credit (“LOC”) to its landlord as security for performance of the Company’s obligations under the office space lease. The LOC was secured by a certificate of deposit (“CD”). The Company is only obligated to keep value of the LOC deposited in the CD. Provided the Company is not in default under its office space lease, it has the right to decrease the letter of credit to $577,700 on December 1, 2007, $379,300 on December 1, 2008, $162,200 on December 1, 2009 and $0 on December 1, 2010. As of May 31, 2011 and May 3, 2010, the CD balance was $0 and $162,448, respectively. The account was closed on May 22, 2011.
Periodically the Company establishes CDs with monies received from the Company’s customers (“Security CDs”). Proceeds from the Security CDs’ are available to the Company, in the event of a customer default, to secure its customers’ payment obligations under the Company’s service agreements. As of May 31, 2011 and 2010, the company held $563,766 and $559,763 respectively in a Security CD which is included in restricted cash on the balance sheet.
The Company also maintains a LOC CD account as part of their compliance with States’ requirements for their Discount Healthcare (“DHC”) line of business. As of May 31, 2011, the company held $100,188 in an LOC CD which is included in restricted cash on the balance sheet.

Note I – Intangibles

On October 1, 2008, the Company purchased certain assets and assumed certain liabilities from a U.S based prescription benefit management company (“Seller”) for $4,958,272.  The results of the operations for the Seller have been included in the Company’s statements of earnings since the acquisition date. During fiscal year ended May 31, 2010 and 2011, post closing purchase price adjustments were made, reducing the estimated future installment payments in the amount of $535,100 and $26,128, respectively. As a result of these reductions, goodwill was reduced from $101,931 to $-0- during the year ended May 31, 2010 and intangible assets acquired were reduced to $4,379,831 and $4,353,703, at May 31, 2010 and 2011, respectively. Estimated future installment payments are $3,691,492 as of May 31, 2011. Intangible assets were as follows:
 
 
As of May 31, 2011
 
Estimated life
Gross carrying value
Accumulated amortization
Net intangibles
 
 
 
 
 
Customer relationships
9.7
$
18,697,998

$
(6,562,686
)
$
12,135,312

Non-compete agreements
5
7,865,000

(6,204,653
)
1,660,347

Branding
3
19,400

(539
)
18,861

 
 
$
26,582,398

$
(12,767,878
)
$
13,814,520


 
 
As of May 31, 2010
 
Estimated life
Gross carrying value
Accumulated amortization
Net intangibles
 
 
 
 
 
Customer relationships
9.7
$
18,724,126

$
(4,752,764
)
$
13,971,362

Non-compete agreements
5
7,865,000

(4,631,646
)
3,233,354

 
 
$
26,589,126

$
(9,384,410
)
$
17,204,716


Amortization expense for the years ended May 31, 2011 and 2010 was $3,383,468 and $3,366,722 respectively.



HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

The future estimated aggregate amortization expense for intangible assets is as follows:
 
As of May 31, 2011
Year ending May 31,
 
2012
$
2,557,868

2013
1,847,410

2014
1,318,195

2015
1,307,934

2016
1,307,934

Thereafter
5,475,179

 
$
13,814,520


Note J – Employee benefit plan

The Company provides a 401(k) plan for substantially all employees. Effective January 2009, the Company matches 100% of employee contributions up to a 3% maximum of compensation, as well as 50% of the next 2% contributed. Employee contributions in excess of 5% of compensation are not matched by the Company. The plan expense for the years ended May 31, 2011 and 2010 was approximately $589,653 and $500,013, respectively.
Note K – Concentrations of credit risk and significant customers

The Company is subject to concentration of credit risk with respect to its cash and cash equivalents, which the Company attempts to minimize by maintaining its cash and cash equivalents with institutions of sound financial quality. At times, cash balances may exceed limits federally insured by the Federal Deposit Insurance Corporation (“FDIC”). No losses related to such balances have been incurred to date. In October 2008, through the temporary Transaction Account Guarantee Program, full coverage is offered for non-interest bearing deposit accounts at FDIC-insured institutions that agree to participate in the program and remained in effect for participating institutions until December 31, 2010. Effective December 31, 2010, the Federal Deposit Insurance Act was amended to provide unlimited insurance coverage of non-interest bearing accounts; therefore, the Company does not have funds which are not federally insured.
Revenues from major customers
During the year ended May 31, 2011, the top four customers of the Company from a revenue perspective accounted for 41% of the Company’s total revenue, 40% of gross profit, and represented 14% of accounts receivable as of May 31, 2011. One of these customers, representing 6.9% of revenue and 1% of gross profit during the year ended May 31, 2011, terminated its services agreement with the Company in March 2011. During the year ended May 31, 2010, the top five customers of the Company from a revenue perspective accounted for 44% of the Company’s total revenue, 35% of gross profit, and represented 26% of accounts receivable as of May 31, 2010. Two of these customers, representing 18% of revenue and 1% of gross profit during the year ended May 31, 2010, subsequently terminated their services agreements with the Company during the year ended May 31, 2011.
Note L – Fair value measurements
The Company records the Class A warrants at fair value. The Company follows a framework for measuring fair value. That framework provides a fair value hierarchy that prioritizes the inputs to valuation techniques used to measure fair value. The hierarchy gives the highest priority to unadjusted quoted prices in active markets for identical assets or liabilities (level 1 measurements) and the lowest priority to unobservable inputs (level 3 measurements). The three levels of the fair value hierarchy are described below:
Level 1
Inputs to the valuation methodology are unadjusted quoted prices for identical assets or liabilities in active markets.
Level 2
Inputs to the valuaftion methodology include:
Quoted prices for similar assets or liabilities in active markets;


HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)

Quoted prices for identical or similar assets or liabilities in inactive markets;
Inputs other than quoted prices that are observable for the asset or liability;
Level 3
Inputs to the valuation methodology are unobservable and significant to the fair value measurement. The asset’s or liability’s fair value measurement level within the fair value hierarchy is based on the lowest level of any input that is significant to the fair value measurement. Valuation techniques used need to maximize the use of observable inputs and minimize the use of unobservable inputs.
The Company has the option to measure financial instruments and certain other assets and liabilities at fair value on an instrument-by-instrument basis. The Company has not elected the fair value option for all financial assets and liabilities.
Class A warrants
The fair value of the Company’s Class A warrants is measured using level 3 inputs are based on unobservable and significant fair value measurements.
The method described above may produce a fair value calculation that may not be indicative of net realizable value or reflective of future fair values. Furthermore, while the Company believes its valuation method is appropriate and consistent with other market participants, the use of different methodologies or assumptions could result in a different fair value measurement at the reporting date.
Note M – Subsequent events

Subsequent events have been evaluated and disclosed through August 31, 2011, the date of issuance of these consolidated financial statements.


































19

HealthTran LLC
May 31, 2011 and 2010
Notes to the financial statements (Continued)


Schedule of Adjusted EBITDA

Reconciliation of net income to adjusted EBITDA
 
 
 
The Company’s primary evaluation of business performance is adjusted EBITDA. The Company defines adjusted EBITDA as net earnings before net interest expense, income taxes, depreciation and amortization, stock-based compensation expense, dividends on Class C preferred units, and accretion of Class C preferred units discount. Management acknowledges that adjusted EBITDA is not a measure of performance or liquidity calculated in accordance with accounting principles generally accepted in the United States of America (“US GAAP)”. However, EBITDA or similar measures are widely used by analysts and investors in the Pharmacy Benefit Management (or “PBM”) industry to determine a company’s operating performance and ability to incur and service debt. The following table provides a reconciliation of net earnings to adjusted EBITDA for the specified periods:
 
Years ended May 31,
 
2011
 
2010
 
 
 
 
Net earnings
$
2,687,136

 
$
1,233,413

 
 
 
 
Depreciation and amortization
6,543,263

 
7,783,881

Interest income
(1,400
)
 
(25,771
)
Interest expense
1,916,134

 
1,531,329

Stock-based compensation expense

 
1,602,000

Dividends on Class C preferred units
4,519,815

 
1,851,600

Accretion of Class C preferred units discount
902,456

 
398,276

 
 
 
 
Adjusted EBITDA
$
16,567,404

 
$
14,374,728




20
EX-99.3 4 ex993ht11-30x11interimstat.htm EX 99.3 HT 11-30-11 Interim Statements
EX 99.3
















HEALTHTRAN LLC

UNAUDITED FINANCIAL STATEMENTS

FOR THE SIX MONTHS ENDED

NOVEMBER 30, 2011 AND 2010




HealthTran LLC


Contents

Balance sheets
Statements of earnings    
Statements of changes in members' deficit
Statements of cash flows
Notes to financial statements
 
 
 
 
 
 
 
 
 
 




HealthTran LLC

Balance sheets

 
November 30, 2011
 
May 31, 2011
Assets
(unaudited)
 
 
Current assets
 
 
 
Cash and cash equivalents
$
9,007,991

 
$
11,475,245

Restricted cash
664,973

 
663,954

Trade accounts receivable, less allowances for doubtful accounts of $426,736 and $404,693, respectively
21,736,933

 
22,896,251

Other current assets
1,926,526

 
1,713,657

Total current assets
33,336,423

 
36,749,107

 
 
 
 
Property and equipment, net
6,754,780

 
6,598,507

Goodwill
4,403,815

 
4,403,815

Intangibles, net
12,400,357

 
13,814,520

Customer acquisition costs, net
181,377

 
204,781

Debt issuance costs, net
1,295,660

 
1,411,156

Total assets
$
58,372,412

 
$
63,181,886

 
 
 
 
Liabilities and members' deficit
 
 
 
Current liabilities
 
 
 
Accounts payable
$
1,882,864

 
$
1,052,883

Current portion of long-term debt
2,807,360

 
2,523,945

Current portion of capital leases
161,110

 
270,299

Current portion of deferred revenue
117,891

 
219,044

Current portion of deferred rent and landlord incentives
365,542

 
336,146

Deposits received
7,601,753

 
7,613,430

Pharmacy network payable
9,582,970

 
10,665,081

Rebates payable
2,817,791

 
4,949,260

Accrued expenses
13,490,841

 
9,820,131

Other liabilities – current
3,720,087

 
3,691,492

Total current liabilities
42,548,209

 
41,141,711

 
 
 
 
Revolving loan, net of current portion

 

Long-term debt, net of current portion and discount
11,679,830

 
13,246,125

Capital leases, less current portion
92,203

 
146,671

Deferred revenue, less current portion
17,200

 
5,594

Deferred rent and landlord incentives, less current portion
395,962

 
560,724

Class C preferred units dividends payable (Note E)
345,205

 
5,046,483

Class C preferred units subject to mandatory redemption, net of discount (Notes D and E)
25,434,767

 
24,983,539

Class A warrants subject to put (Note D)
14,817,198

 
6,693,539

Total liabilities
95,330,574

 
91,824,386

 
 
 
 
Members’ deficit
(36,958,162
)
 
(28,642,500
)
Total liabilities and members’ deficit
$
58,372,412

 
$
63,181,886




The accompanying notes are an integral part of these financial statements







1

HealthTran LLC

Statements of operations

 
Six months ended November 30,
 
2011
 
2010
 
(unaudited)
Revenue
 
 
 
Pharmacy benefit administration
$
119,220,808

 
$
130,871,061

Service revenue
7,859,675

 
7,688,684

Total revenue
127,080,483

 
138,559,745

 
 
 
 
Direct pharmacy benefit administration expenses, excluding depreciation and amortization
99,230,658

 
114,587,252

Gross profit
27,849,825

 
23,972,493

 
 
 
 
Operating expenses
 
 
 
Selling, general and administrative expenses
19,001,860

 
15,772,695

Stock-based compensation expense (Note E)
9,604,619

 

Settlement expense (Note F)
3,149,990

 

Depreciation and amortization
2,883,324

 
3,333,949

Total operating expenses
34,639,793

 
19,106,644

 
 
 
 
(Loss) earnings from operations
(6,789,968
)
 
4,865,849

 
 
 
 
Interest income
309

 
749

Interest expense
(8,546,891
)
 
(669,153
)
Dividends on Class C preferred units
(2,132,503
)
 
(2,189,550
)
Accretion of Class C preferred units discount
(451,228
)
 
(451,228
)
Net (loss) earnings
$
(17,920,281
)
 
$
1,556,667



The accompanying notes are an integral part of these financial statements

2

HealthTran LLC

Statements of changes in members' deficit

 
 
 
 
 
 
 
Member Interests
 
Warrants
 
Total
 
 
 
 
 
 
Balances at June 1, 2010
$
(29,758,115
)
 
$
548,276

 
$
(29,209,839
)
Net earnings
1,556,667

 

 
1,556,667

Distributions (Note D)
(1,051,591
)
 

 
(1,051,591
)
Balances at November 30, 2010 (unaudited)
$
(29,253,039
)
 
$
548,276

 
$
(28,704,763
)
 
 
 
 
 
 
Balances at June 1, 2011
$
(29,190,776
)
 
$
548,276

 
$
(28,642,500
)
Net loss
(17,920,281
)
 

 
(17,920,281
)
Stock-based compensation expense (Note E)
9,604,619

 

 
9,604,619

Balances at November 30, 2011 (unaudited)
$
(37,506,438
)
 
$
548,276

 
$
(36,958,162
)


The accompanying notes are an integral part of these financial statements

3

HealthTran LLC

Statements of cash flows
 
Six months ended November 30,
 
2011
 
2010
Operating activities
(unaudited)
Net (loss) earnings
$
(17,920,281
)
 
$
1,556,667

Adjustments to reconcile net (loss) earnings to net cash provided by operating activities
 
 
 
Depreciation expense
1,422,495

 
1,417,555

Amortization on customer acquisition costs
46,666

 
214,858

Amortization on purchased intangible assets
1,414,163

 
1,701,536

Amortization of debt issuance costs and debt discount
128,380

 
217,226

Amortization of landlord incentives
110,313

 
110,313

Accretion of Class C preferred units discount
451,228

 
451,228

Accretion of dividend on Class C preferred units
2,132,503

 
2,189,550

Interest expense due to change in fair value of Class A warrants subject to put
8,123,659

 

Stock-based compensation expense
9,604,619

 

Provision for (recovery of) bad debts
(26,120
)
 
121,998

Loss on disposal of property and equipment
407

 
6,073

Net change in operating assets and liabilities
 
 
 
(Increase) decrease in restricted cash
(1,019
)
 
60,181

(Increase) decrease in trade accounts receivable
1,185,438

 
(234,633
)
Increase in other current assets
(212,869
)
 
(145,858
)
Increase in accounts payable
829,981

 
491,677

Increase (decrease) in accrued expenses, deposits received, pharmacy network and rebates payable
445,453

 
(7,501,824
)
Decrease in deferred revenue
(89,547
)
 
(309,909
)
Decrease in deferred rent
(245,679
)
 
(284,377
)
Increase in other liabilities
28,595

 
61,866

Net cash provided by operating activities
7,428,385

 
124,127

 
 
 
 
Investing activities
 
 
 
Purchases of property and equipment
(1,579,175
)
 
(1,076,816
)
Customer acquisition costs
(23,262
)
 

Proceeds from disposal of assets

 
150

Net cash used in investing activities
(1,602,437
)
 
(1,076,666
)
 
 
 
 
Financing activities
 
 
 
Payments on long-term debt
(1,282,880
)
 
(3,659,281
)
Payments on revolving loan

 
(7,500,000
)
Proceeds from revolving loan

 
2,500,000

Payments on capital leases
(163,657
)
 
(185,494
)
Distributions

 
(1,051,591
)
Debt issuance costs incurred
(12,884
)
 

Dividend distributions on Class C preferred units
(6,833,781
)
 

Net cash used in financing activities
(8,293,202
)
 
(9,896,366
)
 
 
 
 
Net decrease in cash and cash equivalents
(2,467,254
)
 
(10,848,905
)
 
 
 
 
Cash and cash equivalents at beginning of period
11,475,245

 
13,933,725

Cash and cash equivalents at end of period
$
9,007,991

 
$
3,084,820

 
 
 
 
Supplemental disclosure of cash flow information
 
 
 
Cash paid during the period for interest
$
264,052

 
$
370,565

 
 
 
 
Noncash investing and financing activities
 
 
 
Adjustments to installment payments for purchase of business (Note I)
$

 
$
26,128

Property and equipment acquired with capital leases
$

 
$
343,950


The accompanying notes are an integral part of these financial statements

4

HealthTran LLC
Notes to the unaudited financial statements



Note A - Organization and basis of presentation
HealthTran LLC (the “Company”), a limited liability company registered in the state of Delaware, was established on September 18, 2000. The Company provides benefit administration services, including claims processing, benefit plan design, plan implementation, pharmacy networks, mail service, eligibility management, customer services, data reporting, drug utilization management, formulary management and contracting, communication and enforcing therapy guidelines to physicians, pharmacists, and patients, as well as consulting services.
Basis of Presentation
The accompanying financial statements of the Company have been prepared in accordance with accounting principles generally accepted in the United States of America (“GAAP”). In the opinion of management, these statements include all adjustments (consisting of normal recurring accruals) considered necessary for a fair presentation of the results of the period reported herein for the Company as a standalone entity prior to the acquisition of HealthTran LLC by SXC Health Solutions, Inc. (“SXC”) on January 1, 2012.
Please refer to Note M, Subsequent Events, for more details related to the acquisition of the Company by SXC.
Note B - Summary of accounting policies
Cash and cash equivalents
The Company considers all highly liquid cash investments with original maturity dates of three months or less to be cash equivalents. Cash subject to restrictions that prevents its use for current purposes is segregated in the balance sheets and discussed further in Note H.
Income taxes
Limited liability companies are not taxable entities under provisions of the Internal Revenue Code and, accordingly, the accompanying financial statements do not reflect a provision for federal or state income taxes. The tax effects of the Company's earnings are the responsibility of the members.
The Company adopted policies to account for unrecognized tax benefits on June 1, 2009. The Company recognizes the financial statement benefit of a tax position only after determining that the relevant tax authority would more likely than not sustain the position following an audit. For tax positions meeting the more-likely-than-not threshold, the amount recognized in the financial statements is the largest benefit that has a greater than 50 percent likelihood of being realized upon ultimate settlement with the relevant tax authority. The adoption of these policies did not have a material effect on the Company's financial statements.
As a result of the Company's adoption of these policies, the Company recorded $38,628 as a liability for unrecognized tax benefits as of June 1, 2009. The reconciliation of the beginning and ending amount of unrecognized tax benefits is as follows:
 
Six months ended November 30,
 
2011
2010
Balance at June 1
$
180,197

$
83,383

Additions for tax positions of prior years
57,370


Settlements

(61,309
)
Balance at November 30
$
237,567

$
22,074


The Company recognizes interest and penalties accrued related to unrecognized tax benefits, if any, in operating expenses for all periods presented.
Use of estimates
The preparation of financial statements in conformity with accounting principles generally accepted in the United States requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at the date of the financial statements and the reported amounts of revenues and expenses during the reporting period. Actual results could differ from those estimates.
Property and equipment
Property and equipment, including property and equipment under capital leases, are recorded at cost. Maintenance and repairs are expensed as incurred. Improvements that extend the useful lives of the assets or provide improved efficiency are capitalized. Leasehold improvements are amortized using the straight-line method, over the shorter of the useful life or the lease term.



5

Health Tran LLC
Notes to the unaudited financial statements, continued

Depreciation of property and equipment is computed using the straight-line method over the estimated useful lives of the assets:
Computer equipment
3 to 5 years
Computer equipment - acquired assets
1 to 3 years
Furniture, fixtures and equipment
5 to 7 years
Software
1.5 to 5 years
Building
39 years

External direct costs of materials and services consumed in developing or obtaining internal use computer software, and payroll and payroll-related costs for employees who are directly associated with and who devote time to an internal use computer software project, to the extent of the time spent directly on the project, are capitalized.
Goodwill
Goodwill represents the excess of the purchase price over the fair value of identifiable tangible and intangible net assets relating to business acquisitions. Goodwill and intangible assets with indefinite useful lives are not amortized but instead are tested for impairment annually. For purposes of testing for goodwill impairment, the Company has determined that it has multiple reporting units with goodwill only assigned to one reporting unit.
For the periods presented, the Company does not have any indefinite-lived intangible assets, other than goodwill. Impairment testing is performed in two steps: (i) the Company assesses goodwill for potential impairment by comparing the fair value of the reporting unit with its carrying value, and (ii) if potential impairment is indicated because the reporting unit's fair value is less than its carrying amount, the Company measures the amount of impairment loss by comparing the implied fair value of goodwill with the carrying amount of that goodwill. The Company has performed its annual impairment test for goodwill as of May 31, 2011 and 2010, no impairment losses were recognized.
Impairment of long-lived assets
The Company evaluates long-lived assets, such as property and equipment and purchased intangible assets with finite lives, for impairment whenever events or changes in circumstances indicate the carrying value of an asset may not be recoverable. The fair value of the asset(s) is assessed based on the undiscounted future cash flows the asset(s) is expected to generate and the Company recognizes an impairment loss when estimated undiscounted future cash flows expected to result from the use of the asset(s) plus net proceeds expected from disposition of the asset(s), if any, are less than the carrying value of the asset(s). When an impairment is identified, the carrying amount of the asset(s) is reduced to its estimated fair value based on a discounted cash flow approach or, when available and appropriate, to comparable market values.
Identifiable intangible assets include amounts paid to acquire non-compete agreements and customer relationships. These costs are capitalized and amortized on a straight-line basis over their estimated useful lives that range from 3-13 years. These assets are reviewed for impairment whenever events or circumstances indicate that their carrying amount may not be recoverable.
During the six months ended November 30, 2011 and the twelve-months ended May 31, 2011, there were no indications that the carrying amounts of the Company's long-lived assets may not be recoverable.
Debt issuance costs
Costs incurred to arrange financing, including advisory fees, legal fees, and loan origination fees, are capitalized as debt issuance costs. Such costs are amortized over the life of the related financing on a straight-line basis. The amortization of debt issuance costs is included in interest expense in the statements of earnings. Unamortized debt issuance costs related to a previous credit agreement were charged to interest expense during the year when the previous credit agreement ended.
Revenue recognition
Pharmacy benefit administration
Revenue from sales of prescription drugs by pharmacies in the Company's third-party networks is recognized when the claims are adjudicated (approved or denied). When the Company bills/collects from its customers and pays its pharmacy network providers under separate contracts, the Company records amounts due from its customers as revenue and amounts due to its pharmacy network providers as expense. Revenues and expenses are inclusive of any member co-payments collected by the pharmacy network providers.
Management has determined that the Company acts as the principal in its network transactions. The Company acts as a principal due to its: having separate contractual relationships with customers and with pharmacies; performing part of the service and responsibility to validate and economically manage a claim through its claims adjudication process; setting prescription prices for the pharmacy, including instructing the pharmacy as to how that price is to be settled (co-payment requirements); having discretion in supplier selection; having credit risk for the price due from the customer; and involvement in the determination of product or service specifications.

6

Health Tran LLC
Notes to the unaudited financial statements, continued

The Company also performs rebate-processing services for which it earns revenue. Amounts received and amounts paid by the Company are recorded on a gross basis and separately presented as a component of revenues and expenses, respectively. Management has determined that the Company acts as the principal in its rebate transactions. The Company acts as a principal due to its: responsibility for collections of amounts due from pharmaceutical companies and aggregators; independent contracts entered into with the pharmaceutical companies, aggregators and suppliers; performing part of the service including the responsibility to validate and manage claims through the billing, collection, reporting and payment processes.
When rebates originate from the sale of prescription drugs by pharmacy network providers filling prescriptions under the Company's pharmacy network contracts, the Company reduces expenses by the amount of the rebate earned and deducts from its revenues any rebates paid to its customers.
Service revenue
The Company's service revenue consists of claims processing and consulting services. The Company recognizes claims processing revenue on a per transaction basis upon the completion of processing the claim transaction. Consulting services revenue is recognized as services are performed.
Deferred revenue and customer acquisition costs
The Company typically enters into multiple year contracts with customers and may receive fees from customers at the beginning of a contract generally referred to as implementation fees. When received, the Company records these fees as deferred revenue and amortizes the balance on a straight-line basis over the contract term.
As of November 30, 2011 and May 31, 2011, the Company recorded deferred revenue totaling $135,091 and $224,638, respectively, of which $117,891 and $219,044, respectively, are included in current liabilities and $17,200 and $5,594 respectively, are reported as long-term deferred revenue.
The Company is capitalizing certain incremental direct costs related to the acquisition of customer contracts, and is capitalizing setup and other direct installation activities performed at the inception of a specific arrangement with a specific customer enabling performance under the terms of a specific arrangement with the customer. These costs are collectively referred to as “customer acquisition costs.” Customer acquisition costs are amortized on a straight-line basis over the contract term.
As of November 30, 2011 and May 31, 2011, customer acquisition costs, net of accumulated amortization, totaled $181,377 and $204,781, respectively. Amortization expense for the six months ended November 30, 2011 and 2010 was $46,666 and $214,858 respectively, and is included in operating expenses.
Receivables
All of the Company's trade receivables are due from customers. Credit is extended based on an evaluation of a potential customer's financial condition and collateral is not required. Amounts billed to customer accounts are generally due within 30 days, and become past due after such time. Accounts considered past due are subject to additional interest charges and penalties at the discretion of Company management.
The Company presents its receivables due from customers net of an allowance for doubtful accounts. The Company determines its allowance by considering a number of factors, including length of time the account is past due, the Company's previous history with the customer, the customer's current ability to pay its obligation, and the condition of the general economy and industry as a whole.
When the Company earns revenue before billing its customers, due to minimum invoice thresholds or other criteria determined by management, the Company reports the revenue in the relevant revenue category described previously. The aggregate unbilled amount is recorded as unbilled receivables.
Deferred rent and landlord incentives
The Company recognizes rent expense on a straight-line basis under non-cancelable operating lease agreements conveying the right to use property or equipment for a stated period of time. As of November 30, 2011 and May 31, 2011, the Company had $301,869 and $326,922 of deferred rent which is included in deferred rent and landlord incentives on the balance sheets which reflects the difference between cash payments to the landlord and the amount recorded as rent expense during the six months ended November 30, 2011 and 2010, respectively.
When the Company receives allowances or incentives from a landlord for leasehold improvements (“LHI”), the LHI allowance received from the landlord is recorded as deferred rent and amortized as a reduction to rent expense on a straight-line basis over the lease term. During the six months ended November 30, 2011 and 2010, the Company amortized $110,313 of the allowance as a reduction to rent expense. As of November 30, 2011 and May 31, 2011, the Company had $459,635 and $569,948, respectively, of unamortized LHI allowances which was recorded as deferred rent and landlord incentives on the balance sheets.
Advertising expense
The Company expenses advertising costs, as incurred. Advertising costs for the six months ended November 30, 2011 and 2010 was $718,389 and $75,029, respectively.

7

Health Tran LLC
Notes to the unaudited financial statements, continued



Note C - Property and equipment

Property and equipment, including owned equipment and equipment under capital leases, consists of the following:
 
As of November 30, 2011
 
Owned
Leased
Total
 
 
 
 
Buildings and land
$
281,176

$

$
281,176

Computer equipment
6,131,987

289,071

6,421,058

Furniture, fixtures and equipment
954,227

957,200

1,911,427

Software
15,694,975

13,787

15,708,762

Leasehold improvements
1,986,835


1,986,835

 
25,049,200

1,260,058

26,309,258

Less accumulated depreciation
(18,752,986
)
(801,492
)
(19,554,478
)
Total property and equipment
$
6,296,214

$
458,566

$
6,754,780


 
As of May 31, 2011
 
Owned
Leased
Total
Buildings and land
$
281,177

$

$
281,177

Computer equipment
6,182,893

289,071

6,471,964

Furniture, fixtures and equipment
957,196

957,200

1,914,396

Software
14,305,644

13,787

14,319,431

Leasehold improvements
1,963,233

-

1,963,233

 
23,690,143

1,260,058

24,950,201

Less accumulated depreciation
(17,669,049
)
(682,645
)
(18,351,694
)
Total property and equipment
$
6,021,094

$
577,413

$
6,598,507


Depreciation expense includes depreciation on owned assets in addition to assets recorded under capital leases. Depreciation expense for the six months ended November 30, 2011 and 2010 was $1,422,495 and $1,417,555, respectively.
Note D - Debt

Long-term debt consists of the following:
 
November 30, 2011
May 31, 2011
 
 
 
Term Note
$
13,906,250

$
14,843,750

Term Note discount


Key Note payable 3
144,538

425,645

Key Note payable 4
333,674

383,433

Key Note payable 5
102,728

117,242

Class C preferred units subject to mandatory redemption
30,000,000

30,000,000

Class C preferred units discount
(4,565,233
)
(5,016,461
)
Class A warrants subject to put
14,817,198

6,693,539

Total debt
54,739,155

47,447,148

Less current portion
(2,807,360
)
(2,523,945
)
Total long-term debt
$
51,931,795

$
44,923,203


Credit agreement
In May 2011, the Company entered into a new debt agreement (the “Credit Agreement”) with a finance company to refinance its Senior Debt Facility and provide additional working capital. The Credit Agreement includes both a revolving line of credit (the “Revolver”) and a term note (the “Term Note”). The Revolver of $10,000,000 and Term Note of $15,000,000 are secured by substantially all the assets of the Company, and require the Company to comply with certain financial covenants including a fixed charge coverage ratio and senior debt leverage ratio, as determined on a quarterly basis, and to comply with certain non-financial covenants. As of November 30, 2011 and 2010, the Company was in compliance with the covenant requirements under the Credit Agreement and previous Senior Debt Facility, respectively.

8

HealthTran LLC

Under the Credit Agreement, the Revolver and Term Note bear interest at rates equal to the Prime Rate plus the Applicable Margin. As of November 30, 2011, the interest rates for the Revolver and Term Note were 3.25% and 3.25%, respectively. As of May 31, 2011, the interest rate under the Company's previous Senior Debt Facility's term note and revolving line of credit was 3.25%, respectively.
Revolver
The Company may borrow up to the lesser of $10,000,000 or 80% of the Company's eligible non-rebate accounts receivable and 70% of the Company's eligible rebate accounts receivable, as reduced by certain letters of credit, corporate credit card, and merchant credit card processing reserves. Revolving loans may be borrowed, repaid and reborrowed, until May 3, 2016 (the term loan maturity date), on which date the entire unpaid principal balance of the revolving loan and all accrued and unpaid interest thereon shall be due and payable. After the term loan maturity date, no further revolving loans shall be made. As of November 30, 2011, $8,414,917 was available for borrowing under the revolver based on eligible accounts receivable.
 
There was no balance outstanding on the Revolver at November 30, 2011 or May 31, 2011.

Term Note
The Term Note matures on May 3, 2016, and bears interest on the outstanding principal, payable monthly. Principal payments on the note are due in 60 monthly installments commencing on May 31, 2011. The first 12 monthly installments are in the amount of $156,250; the next 36 monthly installments are in the amount of $250,000; and the last 12 installments are in the amount of $343,750. Of the $15,000,000 of net proceeds from the new Term Note, $9,830,059 was used to repay all amounts outstanding under the Senior Debt Facility with the remaining $5,169,941 retained by the Company for working capital purposes. All unamortized related debt discount relating to the former Senior Debt Facility was expensed as interest expense.

Warrants
In conjunction with the Company's previous Senior Debt Facility, the finance company received multiple warrants:
In conjunction with the previous Senior Debt Facility agreement, a warrant was issued in March 2005 which expires in 2012, to purchase 300,000 Class A membership units of the Company for $4 per unit (aggregate of $1,200,000). The warrant was allocated a value of $198,622, based on the relative fair values of the debt and the warrant. The Company has the option to purchase the warrant for $4,800,000 at any time.
In conjunction with the revised previous Senior Debt Facility agreement, a warrant was issued in December 2007, which expires in 2014, to purchase 104,667 Class A membership units of the Company for $11.46 per unit (aggregate of $1,200,000). The warrant was allocated a value of $548,276, based on the relative fair values of the debt and the warrant. The Company has the option to purchase the warrant for $4,800,000 at any time.

Upon the close of the securities purchase agreement in December 2009, the previous finance company exercised its warrant to purchase Class A units which were issued in 2005 as part of the original Credit Agreement. The previous finance company purchased 300,000 Class A units at $4 per unit (aggregate of $1,200,000). The Class A units relating to the exercise of this warrant were subsequently redeemed by the Company for $3,000,000 (at $10 per unit).

In conjunction with the securities purchase agreement executed in December 2009, the warrant issued in 2007 was amended as follows: (1) the number of units was amended to 113,270 from 104,667, and (2) the warrant price was amended to $7.65 from $11.46. These adjustments were made pursuant to an anti-dilution agreement entered into in conjunction with the warrant agreement that allowed for adjustments to the warrant price and number of shares for diluting issuances such as the securities purchase transaction completed in December 2009.
Key notes payable
In February 2007, the Company borrowed $2,450,262 under Key Note payable 3 to finance equipment purchases. The Key Note payable 3 matures on March 6, 2012. Monthly principal and interest payments are due in sixty equal installments of $48,782 beginning March 6, 2007. The effective interest rate on the Key Note payable 3 is 7.49%. The balance of the payable at November 30, 2011 and May 31, 2011 was $144,538 and $425,645, respectively.
In February 2011, the Company borrowed $416,180 under Key Note payable 4 to finance equipment purchases. The Key Note payable 4 matures on February 24, 2015. Monthly principal and interest payments are due in forty-eight equal installments of $9,230 beginning March 24, 2011. The effective interest rate on the Key Note payable 4 is 3.10%. The balance of the payable at November 30, 2011 and May 31, 2011 was $333,674 and $383,433, respectively.

In April 2011, the Company borrowed $122,031 under Key Note payable 5 to finance equipment purchases. The Key Note payable 5 matures on April 29, 2015. Monthly principal and interest payments are due in forty-eight equal installments of $2,706 beginning May 29, 2011. The effective interest rate on the Key Note payable 5 is 3.10%. The balance of the payable at November 30, 2011 and May 31, 2011 was $102,728 and $117,242, respectively.
Class C preferred units subject to mandatory redemption and Class A warrants subject to put
In December 2009, the Company entered into a securities purchase agreement (the “Agreement”) with an investing party as part of a minority recapitalization transaction. Under this Agreement, in exchange for $30,000,000 in net proceeds received, the Company issued 30,000 units of a newly created equity class designated Class C preferred units (the “Class C preferred”), as well as warrants to purchase 860,114 units of

9

HealthTran LLC

the Company's Class A units (the “Class A warrants”). In conjunction with this transaction, the Company incurred approximately $1.8 million in transaction costs. Of the $30,000,000 in proceeds received, $28,398,000 was distributed to the sole holder of the Company's Class A units, and $1,602,000 was used to redeem certain Class B units (refer to Note E).
Refer to Note E for the key features of the Class C preferred.
Key features of the Class A warrants issued include:
Immediately exercisable into 860,114 Class A units, representing an approximate 7.5% common equity interest in the Company, at an exercise price of $.001 per unit;
Fully detachable from the Agreement and Class C preferred units;
Put rights granted to the investing party are exercisable at any time on or after (i) an uncured or non-waived event of default, (ii) a change of control or any redemption of the Class C preferred, or (iii) December 22, 2016 (the mandatory redemption date for the Class C preferred);
Put rights granted include both the Class A warrants and the underlying Class A units issuable under the warrants upon exercise by the investing party; and
Put price to be paid by the Company equal to:
-For Class A units - liquidation value per unit calculated assuming all outstanding options/warrants of the Company exercised
-For Class A warrants - liquidation value per unit calculated assuming all outstanding options/warrants of the Company exercised, less exercise price payable under Warrant.
The Company may call all of the warrants/underlying Class A units held upon first anniversary of the redemption of the Class C preferred.

The fair value of the Class A warrants subject to put was determined to be $6,317,193 on the date of issuance. As of the end of each reporting period, management is required to re-measure the estimated value of the Company's Class A units to determine any change in the fair value of the Class A warrants subject to put, and will record any change in such value to interest expense. Based on a revaluation analysis conducted as of May 31, 2011 the fair value of Class A warrants subject to put was re-measured at $ 6,693,539. Based on a revaluation analysis conducted as of November 30, 2011, the fair value of the Class A warrants subject to put was re-measured at $14,817,198, with the resulting increase in fair value of $8,123,659 recognized as interest expense for the six months ended November 30, 2011.
Because of the mandatory redemption features of the Class C preferred units and the put rights of the Class A warrants, both are required to be recorded as debt rather than equity. Furthermore, the initial value of the Class A warrants has been recorded as a discount against the Class C preferred units and this discount will be accreted to a non-operating expense account on a straight line basis through December 22, 2016, the mandatory redemption date of the Class C preferred units.

The transaction costs incurred relating to the Agreement have been treated as a deferred charge and are being amortized to interest expense from the date of issuance through the mandatory redemption date of the Class C preferred (i.e. through December 22, 2016).
Maturities of total debt are as follows:
 
As of November 30, 2011
Year ending May 31,
 
2012 (six months)
$
1,241,065

2013
3,133,624

2014
3,137,826

2015
3,193,425

2016
3,781,250

Thereafter
40,251,965

Total debt
$
54,739,155



Note E - Membership units

The Company has three classes of membership units: Class A units, Class B units and Class C preferred units.
Class A units
At November 30, 2011 and May 31, 2011, the Company had 9,700,000 Class A units authorized, issued and outstanding. Holders of Class A units are entitled to one vote for each share held and generally vote as a single class. Class A units are entitled to allocation of earnings or losses generated by the Company's operations, subject to limitations relating to the Class C preferred units.






10

HealthTran LLC

Class B units
At November 30, 2011 and May 31, 2011, the Company had 794,800 Class B units authorized with 557,500 and 496,000 units issued and outstanding, respectively. Key features of the Class B units include:
The Class B units are granted to key employees, officers, directors and other service providers of the Company and do not have an exercise price, vest immediately, do not expire, are non-transferable, do not have any voting rights with respect to the Company, and do not have allocation rights to net income or net loss generated by the Company's operations;
Holders of the Class B units only have the right to receive distributions from the Company in connection with the sale of all or substantially all of the Company's assets (i.e. upon a qualifying “change of control event”) provided the holder is still employed by the Company at the time of the change of control event (i.e. the units are immediately forfeited upon the voluntary or involuntary termination of the employee's employment with the Company prior to a change of control event);
The Company has the right to call the Class B units upon a change of control event.

In December 2009, in conjunction with the closing of the securities purchase agreement (see Note D), the owners of the Company elected to redeem 160,200 Class B units at a purchase price of $10 per unit ($1,602,000 in aggregate). The Company recorded this transaction as stock-based compensation within the statements of earnings.

As discussed in Note M, on November 16, 2011, the Company entered into a Unit Purchase Agreement with SXC, whereby SXC would acquire all of the Company's equity interests in exchange for $250.0 million in cash, as adjusted for unpaid Company transaction expenses, indebtedness, working capital, and other customary reserves and post-closing adjustments. The closing date for this transaction occurred on January 1, 2012. Based on the net purchase price proceeds projected to be available to the Class A and Class B unit holders on the projected closing date of this transaction, the Company estimated the redemption value of the outstanding Class B units as of November 30, 2011 at approximately $9,604,619. The Company recorded stock-based compensation of $9,604,619 for the six months ended November 30, 2011 relating to the Class B units outstanding.
Class C preferred units subject to mandatory redemption
At November 30, 2011 and May 31, 2011, the Company had 30,000 and 30,000 Class C preferred units (the “Class C preferred”) authorized, respectively, with 30,000 and 30,000 units issued and outstanding, respectively. Key features of the Class C preferred units include:
14% annual preferred yield, compounded quarterly. Prior to redemption, dividends may be paid at the discretion of the Company subject to restrictions under the Credit Agreement (as described below);
Liquidation value equal to unpaid Class C preferred capital plus unpaid Class C preferred dividends;
Mandatory redemption on December 22, 2016 at the liquidation value;
Redemption or payment of dividends related to Class C preferred is subject to compliance with all covenants of the Credit Agreement with the Company's finance company;
Pursuant to the Agreement and the Company's amended limited liability company agreement, tax distributions are permitted to be paid to the holders of Class A units and Class C preferred, subject to limits placed by the Credit Agreement.

Class C preferred unit dividends were $2,132,503 and $2,189,550, for the six months ended November 30, 2011 and 2010, respectively. As of November 30, 2011 and May 31, 2011, $345,205 and $5,046,483, respectively, in Class C preferred unit dividends payable are included in long-term debt within the accompanying balance sheets. Prior to redemption of the Class C preferred units, dividends may be paid at the discretion of the Company.
Note F - Commitments and contingencies
Operating leases
The Company leases its office space as well as equipment under non-cancelable agreements. Rent expense was $554,976 and $567,747, respectively, for the six months ended November 30, 2011 and 2010.
Future minimum lease payments under operating leases are as follows:
 
As of November 30, 2011
Year ending May 31,
 
2012 (six months)
$
686,928

2013
1,338,448

2014
745,655

2015
87,273

2016
16,793

Thereafter

Total future minimum operating lease payments
$
2,875,097




11

HealthTran LLC

Capital leases
The Company leases certain equipment under capital lease agreements. Future minimum lease payments under capital leases are as follows:
 
As of November 30, 2011
Year ending May 31,
 
2012 (six months)
$
109,349

2013
111,831

2014
37,277

Total future minimum capital lease payments
258,457

Less amounts representing interest
(5,144
)
Present value of minimum capital lease payments
253,313

Less current portion
(161,110
)
Future minimum rental payments, net
$
92,203


Litigation
During the year ended May 31, 2009, a former client filed a lawsuit in the district Court of Arapahoe County, Colorado against the Company. The complaint alleged, among other things, breach of contract. The Company answered the former client's claims and brought counterclaims alleging, among other things, breach of contract and unjust enrichment. In January 2011, the former client's receivership agent and the Company entered into a settlement agreement for all claims of both parties. In accordance with the terms of the settlement agreement, the Company made a payment totaling $200,000 to the former client in January 2011.

During the fiscal year ended May 31, 2010, a former client alleged damages suffered by it due to actions or inactions of the Company over the last several years, and elected to pursue arbitration against the Company. An arbitration hearing was held in May 2011 and on November 1, 2011 an interim arbitration award was issued in favor of the former client. On November 30, 2011, both parties entered into a settlement agreement, whereby HealthTran accrued in November 2011 and paid in December 2011 a total of $3,276,727, of which $126,737 related to prior rebates payable to the former client and the remaining $3,149,990 representing full settlement of the arbitration award.

As discussed in Note I, in October 2008, the Company acquired certain assets and assumed certain liabilities from a U.S. based prescription benefit management company (“PBM Seller”) for $4,958,272.  Of this purchase price, the Company paid the PBM Seller $1,224,558 in cash at closing, with the remaining purchase price payable in the form of three annual installment payments that were subject to adjustment based on the gross revenue generated from the acquired assets in the first year following the acquisition relative to certain gross revenue targets defined within the asset purchase agreement.  Following the Company's communication in October 2009 to the PBM Seller of the revised annual installment payments to be paid to the PBM Seller based on the first year gross revenue generated from the acquired assets relative to the gross revenue targets, the PBM Seller notified the Company that it was disputing the calculation of such payments.  On December 21, 2011, the PBM Seller filed a lawsuit in Northern District of Illinois Eastern Division United States District Court against the Company.  The complaint alleges, among other things, breach of contract. No trial date is yet scheduled.
The Company is subject to other legal proceedings and claims that arise in the ordinary course of business. In the opinion of management, these other actions are unlikely to materially affect the Company's financial position.

Note G - Affiliate and related party transactions

The Company entered into a service agreement with J&L Management Services, LLC, related through common ownership, to receive various management services. J&L Management Services, LLC has billed the Company $258,334 and $250,002, respectively, for the six months ended November 30, 2011 and 2010, related to this service agreement. As of November 30, 2011 and May 31, 2011, there were $16,409 and $0, respectively, due from J&L Management Services, LLC.
Note H - Restricted cash

Periodically the Company establishes CDs with monies received from the Company's customers (“Security CDs”). Proceeds from the Security CDs' are available to the Company, in the event of a customer default, to secure its customers' payment obligations under the Company's service agreements. As of November 30, 2011 and May 31, 2011, the company held $564,619 and $563,766 respectively in a Security CD which is included in restricted cash on the balance sheet.
The Company also maintains a LOC CD account as part of their compliance with States' requirements for their Discount Healthcare (“DHC”) line of business. As of November 30, 2011 and May 31, 2011, the Company held $100,354 and $100,188, respectively, in an LOC CD which is included in restricted cash on the balance sheets.
Note I - Intangibles

On October 1, 2008, the Company purchased certain assets and assumed certain liabilities from a U.S based prescription benefit management company (“PBM Seller”) for $4,958,272.  The results of the operations for the PBM Seller have been included in the Company's statements

12

HealthTran LLC

of earnings since the acquisition date. During the six months ended November 30, 2010, post closing purchase price adjustments were made, reducing the estimated future installment payments in the amount of $26,128. As a result of this reduction, during the six months ended November 30, 2010, intangible assets acquired were reduced from $4,379,831 to $4,353,703. Estimated future installment payments are $3,720,087 as of November 30, 2011. Intangible assets were as follows:
 
 
As of November 30, 2011
 
Estimated life
Gross carrying value
Accumulated amortization
Net intangibles
 
 
 
 
 
Customer relationships
9.7
$
18,697,998

$
(7,337,116
)
$
11,360,882

Non-compete agreements
5
7,865,000

(6,841,152
)
1,023,848

Branding
3
19,400

(3,773
)
15,627

 
 
$
26,582,398

$
(14,182,041
)
$
12,400,357


 
 
As of May 31, 2011
 
Estimated life
Gross carrying value
Accumulated amortization
Net intangibles
 
 
 
 
 
Customer relationships
9.7
$
18,697,998

$
(6,562,686
)
$
12,135,312

Non-compete agreements
5
7,865,000

(6,204,653
)
1,660,347

Branding
3
19,400

(539
)
18,861

 
 
$
26,582,398

$
(12,767,878
)
$
13,814,520


Amortization expense for the six months ended November 30, 2011 and 2010 was $1,414,163 and $1,701,536, respectively.
The future estimated aggregate amortization expense for intangible assets is as follows:
 
As of November 30, 2011
Year ending May 31,
 
2012 (six months)
$
1,143,706

2013
1,847,410

2014
1,318,195

2015
1,307,934

2016
1,307,934

Thereafter
5,475,178

 
$
12,400,357


Note J - Employee benefit plan

The Company provides a 401(k) plan for substantially all employees. Effective January 2009, the Company matches 100% of employee contributions up to a 3% maximum of compensation, as well as 50% of the next 2% contributed. Employee contributions in excess of 5% of compensation are not matched by the Company. The plan expense for the six months ended November 30, 2011 and 2010 was approximately $310,300 and $280,477, respectively.

Note K - Concentrations of credit risk and significant customers

The Company is subject to concentration of credit risk with respect to its cash and cash equivalents, which the Company attempts to minimize by maintaining its cash and cash equivalents with institutions of sound financial quality. At times, cash balances may exceed limits federally insured by the Federal Deposit Insurance Corporation (“FDIC”). No losses related to such balances have been incurred to date. In October 2008, through the temporary Transaction Account Guarantee Program, full coverage is offered for non-interest bearing deposit accounts at FDIC-insured institutions that agree to participate in the program and remained in effect for participating institutions until December 31, 2010. Effective December 31, 2010, the Federal Deposit Insurance Act was amended to provide unlimited insurance coverage of non-interest bearing accounts; therefore, the Company does not have funds which are not federally insured.

Revenues from major customers
During the six months ended November 30, 2011, the top four customers of the Company from a revenue perspective accounted for 43% of the Company's total revenue. During the six months ended November 30, 2010, the top five customers of the Company from a revenue perspective accounted for 48% of the Company's total revenue. The top four customers of the Company from a revenue perspective accounted for 13% and 14% of accounts receivable as of November 30, 2011 and May 31, 2011, respectively.

Note L - Fair value measurements

13

HealthTran LLC


The Company records the Class A warrants at fair value. The Company follows a framework for measuring fair value. That framework provides a fair value hierarchy that prioritizes the inputs to valuation techniques used to measure fair value. The hierarchy gives the highest priority to unadjusted quoted prices in active markets for identical assets or liabilities (level 1 measurements) and the lowest priority to unobservable inputs (level 3 measurements). The three levels of the fair value hierarchy are described below:
Level 1
Inputs to the valuation methodology are unadjusted quoted prices for identical assets or liabilities in active markets.
Level 2
Inputs to the valuation methodology include:
Quoted prices for similar assets or liabilities in active markets;
Quoted prices for identical or similar assets or liabilities in inactive markets;
Inputs other than quoted prices that are observable for the asset or liability;
Inputs that are derived principally from or corroborated by observable market data by correlation or other means. If the asset or liability has a specified (contractual) term, the Level 2 input must be observable for substantially the full term of the asset or liability.

Level 3
Inputs to the valuation methodology are unobservable and significant to the fair value measurement. The asset's or liability's fair value measurement level within the fair value hierarchy is based on the lowest level of any input that is significant to the fair value measurement. Valuation techniques used need to maximize the use of observable inputs and minimize the use of unobservable inputs.
The Company has the option to measure financial instruments and certain other assets and liabilities at fair value on an instrument-by-instrument basis. The Company has not elected the fair value option for all financial assets and liabilities.

Class A warrants
The fair value of the Company's Class A warrants is measured using level 3 inputs are based on unobservable and significant fair value measurements.

The method described above may produce a fair value calculation that may not be indicative of net realizable value or reflective of future fair values. Furthermore, while the Company believes its valuation method is appropriate and consistent with other market participants, the use of different methodologies or assumptions could result in a different fair value measurement at the reporting date.

Note M - Subsequent events

Subsequent events have been evaluated and disclosed through March 9, 2012, the date of issuance of these financial statements.

HealthTran LLC acquired by SXC Health Solutions, Inc.
On November 16, 2011, SXC entered into a Unit Purchase Agreement (the “Purchase Agreement”) to acquire all of the equity interests of the Company in exchange for $250.0 million in cash, as adjusted for any unpaid Company transaction expenses, indebtedness, and certain other customary reserves and working capital adjustments as defined in the Purchase Agreement. This acquisition transaction closed effective January 1, 2012. The Purchase Agreement contains customary representations, warranties and covenants.

14
EX-99.4 5 ex994healthtranproforma.htm EX 99.4 HealthTran Proforma
EX 99.4


UNAUDITED PRO FORMA CONDENSED COMBINED FINANCIAL INFORMATION


On November 16, 2011, SXC Health Solutions Corp. (the "Company") entered into a definitive purchase agreement (the "Purchase Agreement") to acquire HealthTran LLC (“HealthTran”), a middle-market Pharmacy Benefit Management ("PBM") service company based in Denver, Colorado, for a purchase price of $250 million in cash, subject to certain customary post-closing adjustments (the acquisition by the Company of HealthTran, the "Acquisition"). The Company completed the Acquisition (the "Closing") on January 3, 2012, effective as of 12:01 a.m. Central Standard Time on January 1, 2012. The Company utilized cash on hand as well as $100 million of cash drawn from a revolving credit line to fund the acquisition.

HealthTran provides PBM and Healthcare Information Technology ("HCIT") services to approximately 260 clients. Its PBM business includes a full suite of PBM offerings including a nationwide retail network, formulary and rebate management, Part D services and mail order operations. HealthTran was an existing HCIT customer of the Company and utilizes a Company platform for its claims adjudication. HealthTran also provides claims adjudication services to a number of other PBMs using the same platform.

The unaudited pro forma condensed combined statement of operations for the twelve months ended December 31, 2011 gives effect to the Acquisition as if it had occurred on January 1, 2011; the unaudited pro forma condensed combined balance sheet as of December 31, 2011 gives effect to the Acquisition as if it had occurred on December 31, 2011 (together the unaudited pro forma condensed combined statement of operations and unaudited pro forma condensed combined balance sheet being referred to herein as the "pro forma financial statements") .

Effective immediately prior to the completion of the Acquisition, HealthTran sold, assigned, transferred, conveyed and delivered to Innovante Benefit Administrators, LLC (“Innovante”), a wholly-owned subsidiary of HealthTrans Data Services, LLC, a former significant equity interest holder of HealthTran, all of HealthTran's right, title and interest in and to all assets exclusively used in the operation of its business of providing third party administration (TPA) services (the “TPA Business”) for both medical and prescription drug claim processing and adjudication and general benefit plan administration, in consideration for the payment of $1 and the assumption by Innovante of all of the liabilities of the TPA Business.  The pro forma financial statements exclude the assets, liabilities and results of operations of the TPA Business, as the TPA Business was not acquired by the Company.

The adjustments to the pro forma financial statements are preliminary and have been made solely for the purpose of developing the pro forma financial statements for illustrative purposes, necessary to comply with the requirements of applicable disclosure and reporting regulations. The pro forma financial statements are not intended to represent what our actual consolidated results of operations or consolidated financial position would have been had the Acquisition occurred on the dates assumed, nor are they necessarily indicative of our future consolidated results of operations or consolidated financial position. The actual results reported in periods following the Closing may differ significantly from the pro forma financial statements for a number of reasons including, but not limited to: differences in the ordinary conduct of the business following the Acquisition; differences between the assumptions used to prepare these pro forma financial statements and actual amounts; cost savings from operating efficiencies; changes to pharmacy network and rebate contracting; potential synergies; and the impact of the incremental costs incurred in integrating HealthTran.

The pro forma adjustments and related assumptions are described in the accompanying notes. The pro forma adjustments are based on assumptions relating to the consideration paid and the allocation thereof to the HealthTran assets acquired and liabilities assumed, based on preliminary estimates of fair value. We believe that the assumptions used to derive the pro forma adjustments are reasonable given the information available; however, as the valuations of acquired assets and liabilities are in process and are not expected to be finalized until later in 2012, and information may become available within the measurement period which indicates a potential change to these valuations, the purchase price allocation may be subject to adjustment.

Furthermore, the unaudited pro forma condensed combined financial statements do not reflect any cost savings from operating efficiencies, synergies or other costs that could result from the Acquisition. The pro forma financial statements are based on the historical financial statements of the Company and HealthTran, as adjusted for the pro forma effect of the Acquisition. The unaudited pro forma financial statements should be read in conjunction with the historical financial statements and the accompanying notes of the Company included in its Annual Report on Form 10-K, filed with the Securities and Exchange Commission (SEC) on February 24, 2012 and the financial statements of HealthTran included in Exhibits 99.2 and 99.3 of the Company's Current Report on Form 8-K/A dated March 14, 2012.




1


SXC Health Solutions Corp.
Unaudited Pro Forma Condensed Combined Balance Sheet
December 31, 2011
(in thousands)
 
 
 
 
 
 
 
 
 
SXC Health Solutions Corp.
 
HealthTran LLC
 
Pro Forma Adjustments
 
Pro Forma Combined
 
 
 
 
 
 
Current assets
 

 
 

 
 
 
 
Cash and cash equivalents
$
341,382

 
$
9,008

 
$
(150,000
)
A
$
200,390

Restricted cash
12,017

 
665

 

 
12,682

Accounts receivable, net
240,425

 
21,737

 

 
262,162

Rebates receivable
33,834

 

 

 
33,834

Prepaid expenses and other current assets
6,409

 
1,927

 

 
8,336

Inventory
19,554

 

 

 
19,554

Deferred income taxes
9,642

 

 

 
9,642

Total current assets
663,263

 
33,336

 
(150,000
)
 
546,599

Property and equipment, net
21,658

 
6,755

 
(3,509
)
B
24,904

Goodwill
291,045

 
4,404

 
170,653

C
466,102

Other intangible assets, net
69,777

 
12,400

 
64,730

C
146,907

Other assets
4,564

 
1,477

 

 
6,041

Total assets
$
1,050,307

 
$
58,372

 
$
81,874


$
1,190,553

LIABILITIES AND SHAREHOLDERS’ EQUITY
 
 
 
 
 
 
 
Current liabilities
 

 
 
 
 
 
 
Accounts payable
$
19,679

 
$
1,883

 
$

 
$
21,562

Accrued expenses and other current liabilities
66,729

 
25,457

 

 
92,186

Current portion of long-term debt
 
 
2,807

 
(2,807
)
D

Pharmacy benefit management rebates payable
59,235

 
2,818

 

 
62,053

Pharmacy benefit claim payments payable
199,701

 
9,583

 

 
209,284

       Total current liabilities
345,344

 
42,548

 
(2,807
)
 
385,085

Deferred income taxes
18,361

 

 
 
 
18,361

Class A warrants

 
14,817

 
(14,817
)
E

Class C preferred units

 
25,780

 
(25,780
)
E

Long-term debt

 
11,680

 
88,320

D
100,000

Other liabilities
15,564

 
505

 

 
16,069

Total liabilities
379,269

 
95,331

 
44,916

 
519,516

 


 
 
 
 
 
 
Shareholders’ equity
 

 
 
 
 
 
 
Common shares
394,769

 

 

 
394,769

Additional paid-in capital
37,936

 

 

 
37,936

Retained earnings
238,333

 

 

 
238,333

Members deficit
 
 
(36,958
)
 
36,958

E

Total shareholders’ equity
671,038

 
(36,958
)
 
 
 
671,038

Total liabilities and shareholders’ equity
$
1,050,307

 
$
58,372

 
$
81,874

 
$
1,190,553










See accompanying notes to unaudited pro forma financial statements

2




SXC Health Solutions Corp.
Unaudited Pro Forma Condensed Combined Statement of Operation
For the Year Ended December 31, 2011
(in thousands)
 
SXC Health Solutions Corp.
 
HealthTran LLC
 
Pro Forma Adjustments
 
Pro Forma Combined
 
 
 
 
 
 
 
 
Revenue
$
4,975,496

 
$
253,044

 
$
(23,505
)
F
$
5,205,035

Cost of revenue
4,666,008

 
199,796

 
(23,505
)
F
4,842,299

Gross profit
309,488

 
53,248

 

 
362,736

Expenses:
 

 
 
 
 
 
 
Product development costs
14,331

 

 

 
14,331

Selling, general and administrative
131,457

 
44,478

 
(9,605
)
G
166,330

Depreciation and amortization
23,129

 
6,093

 
15,100

H
44,322

Settlement expense

 
3,150

 

 
3,150

 
168,917

 
53,721

 
5,495

 
228,133

Operating income (loss)
140,571

 
(473
)
 
(5,495
)
 
134,603

Interest income
(502
)
 
(1
)
 
191

I
(312
)
Interest expense and other expense, net
2,779

 
9,794

 
(7,065
)
I
5,508

Dividends on Class C preferred units

 
4,463

 
(4,463
)
J

Accretion of Class C preferred units discount

 
902

 
(902
)
J

Income (loss) before income taxes
138,294

 
(15,631
)
 
6,744

 
129,407

 
 

 
 
 
 
 
 
Income tax expense (benefit):
46,508

 

 
(8,964
)
K
37,544

Net income (loss)
$
91,786

 
$
(15,631
)
 
$
15,708

 
$
91,863

Earnings per share:
 

 
 
 
 
 
 
Basic
$
1.48

 

 

 
$
1.48

Diluted
$
1.46

 

 

 
$
1.46

Weighted average shares outstanding:
 
 
 
 
 
 
 
Basic
62,126,656

 

 

 
62,126,656

Diluted
62,951,758

 

 

 
62,951,758





















See accompanying notes to unaudited pro forma financial statements

3

SXC Health Solutions Corp.
Notes to Unaudited Pro Forma Condensed Combined Financial Statements


1.    Description of Transaction

Effective as of 12:01 a.m. Central Standard Time on January 1, 2012, the Company completed the acquisition of all of the outstanding equity interests of HealthTran in exchange for $250 million in cash, subject to certain customary post-closing adjustments, in each case upon the terms and subject to the conditions contained in the Purchase Agreement. The cash payment for the Acquisition was funded from a combination of cash on hand and amounts drawn under the Company's revolving credit line. HealthTran was an existing HCIT customer of the Company and utilizes a Company platform for its claims adjudication services. Our initial valuation is preliminary, as we are completing the valuation work required to determine the fair value of the net assets acquired. The Company expects to finalize its accounting for the Acquisitions as soon as practicable, but no later than one year from the acquisition date.
2.    Basis of Presentation

The unaudited pro forma condensed combined balance sheet combines the audited consolidated balance sheet of the Company as of December 31, 2011 and the unaudited balance sheet of HealthTran as of November 30, 2011, and gives effect to the Acquisition as if it had been completed on December 31, 2011, including any adjustments to the fair values of assets acquired and liabilities assumed based on preliminary estimates, in accordance with purchase accounting guidance.

The unaudited pro forma condensed combined statement of operations for the year ended December 31, 2011, combines the consolidated statement of operations of the Company for the year then ended and the unaudited statement of operations of HealthTran for the twelve months ended November 30, 2011, and gives effect to the Acquisition as if it had occurred on January 1, 2011. The unaudited statement of operations of HealthTran for the twelve months ended November 30, 2011 was prepared by taking the audited HealthTran statement of operations for the twelve months ended May 31, 2011, less the results from the unaudited statement of operations of HealthTran for the six months ended November 30, 2010, plus the results from the unaudited statement of operations of HealthTran for the six months ended November 30, 2011. The HealthTran unaudited statement of operations excludes the results of the TPA business line of HealthTran not acquired by the Company.

The pro forma adjustments include the application of the acquisition method of accounting under purchase accounting guidance. Purchase accounting guidance requires, among other things, that identifiable assets acquired and liabilities assumed be recognized at their fair values as of the acquisition date, which is presumed to be the closing of the Acquisition. The transaction fees of approximately $0.9 million for the Acquisition are expensed as incurred and are included in selling, general and administrative expenses in the Company's results for the year ended December 31, 2011.

The pro forma adjustments described herein have been developed based on management's judgment, including estimates relating to the allocation of assets acquired and liabilities assumed of HealthTran based on preliminary estimates of fair value. We believe that the assumptions used to derive the pro forma adjustments are reasonable given the information available; however, as the valuations of acquired assets and liabilities are in process and are not expected to be finalized until later in 2012, and information may become available within the measurement period which indicates a potential change to these valuations, the purchase price allocation may be subject to adjustment. The pro forma financial statements do not reflect any cost savings from potential operating efficiencies, any other potential synergies or any incremental costs which may be incurred in connection with integrating HealthTran.

The pro forma financial statements are provided for illustrative purposes only and are not intended to represent what our actual consolidated results of operations or consolidated financial position would have been had the Acquisition occurred on the dates assumed, nor are they necessarily indicative of our future consolidated results of operations or consolidated financial position.

3.     Unaudited Pro Forma Adjustments

(a) Unaudited Pro Forma Condensed Combined Balance Sheet

A-Cash and cash equivalents    

This adjustments reflects the $250 million purchase price, offset by the $100 million draw on the Company's revolving line of credit (see notes E and I below for a discussion of the adjustments to record the liability for the draw on the revolving credit line and associated interest expense).

B-Property and equipment, net

As part of of the purchase price allocation the Company assessed the fair value of property and equipment assumed. This adjustment brings the HealthTran property and equipment to its estimated fair value of $3.2 million, based on preliminary valuations.

    






4

SXC Health Solutions Corp.
Notes to Unaudited Pro Forma Condensed Combined Financial Statements (continued)

C-Goodwill and other intangible assets

The adjustments to goodwill and intangible assets represent the net amounts for goodwill and other intangible assets recognized from the preliminary purchase price allocation less the amounts of goodwill and intangible assets of HealthTran as of November 30, 2011. The preliminary goodwill acquired from the HealthTran acquisition is $175.1 million. The other identified intangible assets acquired consist of the following (in thousands):
 
 
Fair Value
 
Useful Life
Customer relationships
 
72,400

 
4 to 9 years
Non-compete agreements
 
2,600

 
5 years
Trademarks/Tradenames
 
1,750

 
6 months
Licenses
 
380

 
3 years
 
 
77,130

 
 

D-Debt

These adjustments reflect the $100 million of proceeds drawn from the Company's revolving credit line to partly finance the Acquisition consideration and the elimination of HealthTran's debt that was not assumed by the Company.

E-HealthTran warrants, preferred units and members' deficit

These adjustments remove the associated liabilities of HealthTran from class A warrants and class C preferred units that were not assumed by the Company, as well as eliminating HealthTran's members' deficit account which is not assumed by the Company.

(b) Unaudited Pro Forma Condensed Combined Statements of Operations

F-Pharmacy co-payments

For transactions at the Company's participating pharmacies, under the terms of the customer contracts, the pharmacy is solely obligated to collect the co-payments from the participants. The Company does not assume liability for participant co-payments in non-Company owned pharmacy transactions, and therefore does not include participant co-payments in revenue or cost of revenue. If these amounts were included in the Company’s operating results, its operating income and net income would not have been affected. HealthTran included in revenue and cost of revenues co-payments collected by participating pharmacies. Accordingly, these adjustments remove from revenue and cost of revenue HealthTran's co-payments that are collected by participating pharmacies.

G-Selling, general and administrative expenses

The adjustment to selling, general and administrative expenses ("SG&A") relates to the reversal of $9.6 million in stock-compensation charges recorded by HealthTran related to its class B units as a result of the Acquisition.

H-Depreciation and amortization

The adjustment to depreciation and amortization is driven by the preliminary estimation of first year amortization expense of intangible assets acquired of $19.0 million. This amount is offset by a reduction of depreciation expense of $0.8 million due to the Company's preliminarily fair value assessment of property and equipment acquired, as well a reduction of $3.1 million of amortization expense recorded by HealthTran from its intangible assets.

I-Interest

Interest income was adjusted to reflect the reduction of interest due to using cash on hand to finance the Acquisition. Interest expense was adjusted to remove interest expense from HealthTran's previous debt that was not assumed by the Company, and adding $2.7 million for estimated interest expense related to the Company's draw on its revolving credit line to partially finance the Acquisition.

J-HealthTran warrants and preferred unit expenses

These adjustments remove the associated expenses of HealthTran from class A warrants and class C preferred units that were not assumed by the Company since the pro forma financial statements reflect the debt to partly finance the Acquisition and the related interest expense, as well as the reduction of interest income from the use of cash to fund the purchase price.

K-Income taxes

The adjustment reflects the income tax effect of the pro forma combined effective income tax rate of 28.8% for the year ended December 31, 2011, based on applicable federal and state statutory tax rates and the combined results of the Company and HealthTran.

5