Receivables management: a case study.
Amoah, Nana ; Rao, Arundhati
Table 1
Pink Tree's Financial Statements - Balance Sheet
December 31, 2001 and 2000
(Amounts in millions)
2001 2000
Assets
Cash and cash equivalents 394.5 $665.50
Finance receivables 4,168.7 4,214.90
Investments 16,680.7 15,176.90
Goodwill -- 28.8
Other assets 984.1 751.9
Total assets 22,228.0 $20,838.00
Liabilities and Stockholder's Equity
Liabilities
Investor payables 8,918.2 $7,516.90
Other current liabilities 2,356.6 2,457.00
Long-term liabilities 9,003.7 8,774.90
Total liabilities 20,278.5 $18,748.80
Stockholder's Equity
Preferred stock 750.0 $750.00
Common stock and additional paid-in capital 1,209.4 1,209.40
Accumulated other comprehensive loss (108.6) -139.1
Retained earnings 98.7 268.9
Total shareholder's equity 1,949.5 2,089.20
Total liabilities and shareholder's equity 22,228.0 $20,838.00
Table 2
Pink Tree's Financial Statements - Statement of Operations
December 31, 2001, 2000 and 1999
(Amounts in millions)
2001 2000 1999
Revenues:
Net investment income: 2,260.2 $1,945.00 $647.10
Finance receivables and other 51.5 106.6 185.1
Interest-only securities -- -- 550.6
Gain on sale:
Securitization transactions 26.9 7.5 --
Whole-loan sales Servicing income 115.3 108.2 165.3
Fee revenue and other income 229.7 277.5 207.4
Total revenues 2,683.6 2,444.80 1,755.50
Expenses:
Provision for losses 563.6 354.2 128.7
Interest expense 1,234.4 1,152.40 341.3
Other operating costs and expenses 642.4 770.8 697.2
Impairment charges 386.9 515.7 554.3
Special charges 21.5 394.3 --
Total expenses 2,848.8 3,187.40 1721.5
Income (loss) before income taxes (165.2) -742.6 34
Income tax benefit (62.5) -217.3 -13.9
Net income (loss) (102.7) ($525.30) $47.90
Table 3 Pink Tree's Financial Statements - Statement of
Shareholder's Equity
December 31, 2001, 2000 and 1999
(Amounts in millions)
A B
Balance, January 1, 1999 2292.2 $-
Comprehensive income (loss), net of tax:
Net income 47.9 --
Change in minimum pension liability 4.2 --
adjustment (net of taxes $2.6 m)
Change in unrealized depreciation of actively (12.0) --
managed fixed maturity investments and
interest-only securities (net of taxes $7.6m)
Total comprehensive income 40.1 --
Issuance of common stock 299.4 --
Tax benefit related to issuance of shares 3.3 --
under stock option plans
Dividends on common stock (200.0) --
Balance, December 31, 1999 2,435.0 --
Comprehensive loss, net of tax:
Net loss (525.3) --
Change in unrealized depreciation of actively (120.3) --
managed fixed maturity investments and
interest-only securities (net of taxes $70.6
m)
Total comprehensive loss (645.6) --
Issuance of preferred stock 750.0 750
Repurchase of common stock (126.0) --
Return of capital (306.3) --
Dividends on preferred stock (18.6) --
Other 0.7 --
Balance, December 31, 2000 2,089.2 750
Comprehensive income (loss), net of tax:
Net loss (102.7) --
Change in minimum pension liability (3.9) --
adjustment (net of taxes $2.6 m)
Change in unrealized depreciation of actively 34.4 --
managed fixed maturity investments and
interest-only securities (net of taxes $21.7
m)
Total comprehensive loss (72.2) --
Dividends on preferred stock (67.5) --
Balance, December 31, 2001 1,949.5 $750.00
C D
Balance, January 1, 1999 $1,338.30 ($11.00)
Comprehensive income (loss), net of tax:
Net income --
Change in minimum pension liability -- 4.2
adjustment (net of taxes $2.6 m)
Change in unrealized depreciation of actively -- -12
managed fixed maturity investments and
interest-only securities (net of taxes $7.6m)
Total comprehensive income -- --
Issuance of common stock 299.4 --
Tax benefit related to issuance of shares 3.3 --
under stock option plans
Dividends on common stock - --
Balance, December 31, 1999 1641 -18.8
Comprehensive loss, net of tax:
Net loss --
Change in unrealized depreciation of actively -- -120.3
managed fixed maturity investments and
interest-only securities (net of taxes $70.6
m)
Total comprehensive loss -- --
Issuance of preferred stock -- --
Repurchase of common stock -126 --
Return of capital -306.3 --
Dividends on preferred stock -- --
Other 0.7 --
Balance, December 31, 2000 1,209.40 -139.1
Comprehensive income (loss), net of tax:
Net loss -- --
Change in minimum pension liability -- -3.9
adjustment (net of taxes $2.6 m)
Change in unrealized depreciation of actively -- 34.4
managed fixed maturity investments and
interest-only securities (net of taxes $21.7
m)
Total comprehensive loss -- --
Dividends on preferred stock -- --
Balance, December 31, 2001 $1,209.40 ($108.60)
E
Balance, January 1, 1999 $964.90
Comprehensive income (loss), net of tax:
Net income 47.9
Change in minimum pension liability --
adjustment (net of taxes $2.6 m)
Change in unrealized depreciation of actively --
managed fixed maturity investments and
interest-only securities (net of taxes $7.6m)
Total comprehensive income --
Issuance of common stock --
Tax benefit related to issuance of shares --
under stock option plans
Dividends on common stock -200
Balance, December 31, 1999 812.8
Comprehensive loss, net of tax:
Net loss -525.3
Change in unrealized depreciation of actively --
managed fixed maturity investments and
interest-only securities (net of taxes $70.6
m)
Total comprehensive loss --
Issuance of preferred stock --
Repurchase of common stock --
Return of capital --
Dividends on preferred stock -18.6
Other -
Balance, December 31, 2000 268.9
Comprehensive income (loss), net of tax:
Net loss -102.7
Change in minimum pension liability --
adjustment (net of taxes $2.6 m)
Change in unrealized depreciation of actively --
managed fixed maturity investments and
interest-only securities (net of taxes $21.7
m)
Total comprehensive loss --
Dividends on preferred stock -67.5
Balance, December 31, 2001 $98.70
A = Total
B = Preferred Stock
C = Common Stock
D = Accumulated Other Comprehensive Income
E = Retained Earnings
Table 4 Pink Tree's Financial Statements - Statement of Cash Flows
December 31, 2001, 2000 and 1999 (Amounts in millions)
2001 2000
Cash flows from operating activities
Net investment income $2,141.20 $1,994.60
Points and origination fees 3.1 44.8
Fee revenue and other income 301.4 401.3
Interest expense -1,212.30 -1,038.70
Other operating costs -692.8 -846.6
Taxes -23.9 -72.8
Net cash provided by operating activities 516.7 482.6
Cash flows from investing activities
Cash received from the sale of finance 867.2 2,501.20
receivables, net of expenses
Principal payments received on finance 8,611.30 8,490.10
receivables
Finance receivables originated -12,320.30 -18,515.90
Other 295.9 -262.3
Net cash used by investing activities -2,545.90 -7,786.90
Cash flows from financing activities
Cash contributed by parent resulting from -- --
asset transfer
Issuance of liabilities related to deposit 1,872.40 2,168.80
products
Payments on liabilities related to deposit -1,961.10 -1,166.00
products
Issuance of notes payable and commercial 11,755.60 20,452.10
paper
Payments on notes payable and commercial -9,666.90 -13,202.80
paper
Change in cash held in restricted accounts -241.8 -689.7
for settlement of collateralized borrowings
Repurchase of shares of common stock -- -126
Common stock dividends paid -- --
Net cash provided by financing activities 1,758.20 7,436.40
Net increase (decrease) in cash and cash -271 132.1
equivalents
Cash and cash equivalents, beginning of year 665.5 533.4
Cash and cash equivalents, end of year $394.50 $665.50
1999
Cash flows from operating activities
Net investment income $1,009.00
Points and origination fees 390
Fee revenue and other income 383.1
Interest expense -293.5
Other operating costs -676.6
Taxes -188
Net cash provided by operating activities 624
Cash flows from investing activities
Cash received from the sale of finance 9,516.60
receivables, net of expenses
Principal payments received on finance 7,487.20
receivables
Finance receivables originated -24,650.50
Other -120
Net cash used by investing activities -7,766.70
Cash flows from financing activities
Cash contributed by parent resulting from 18.2
asset transfer
Issuance of liabilities related to deposit 1,128.80
products
Payments on liabilities related to deposit -288.3
products
Issuance of notes payable and commercial 22,220.30
paper
Payments on notes payable and commercial -15,321.30
paper
Change in cash held in restricted accounts -76.8
for settlement of collateralized borrowings
Repurchase of shares of common stock --
Common stock dividends paid -200
Net cash provided by financing activities 7,480.90
Net increase (decrease) in cash and cash 338.2
equivalents
Cash and cash equivalents, beginning of year 195.2
Cash and cash equivalents, end of year $533.40
Table 5
Pink Tree's Market Value of Equity
December 31, 2001 and 2000
2000 2001
Market Value of Equity 3965.23 4266.01
Table 6
Delta's Financial Statements - Statement of Financial Condition
For the Years Ended December 31, 2001, 2000, and 1999
2001 2000
Assets
Cash and cash equivalents $84,067 $65,857
Accounts receivable 668,982 359,285
Total current assets 752,999 425,142
Long-term assets 674,181 674,181
Total assets $1,427,180 $1,099,323
Liabilities and Member's Equity:
Accounts payable and accrued liabilities 514,227 380,986
Total current liabilities 514,227 380,986
Other liabilities 430,030 430,030
Total liabilities 944,257 811,016
Member's equity 482,923 288,307
Total liabilities and Member's equity $1,427,180 $1,099,323
1999
Assets
Cash and cash equivalents $48,711
Accounts receivable 63,575
Total current assets 112,286
Long-term assets 674,181
Total assets $786,467
Liabilities and Member's Equity:
Accounts payable and accrued liabilities 195,224
Total current liabilities 195,224
Other liabilities 430,030
Total liabilities 625,254
Member's equity 161,213
Total liabilities and Member's equity $786,467
Table 7
Delta's Financial Statements - Statement of Operations
For the Years Ended December 31, 2001, 2000, and 1999
2001 2000 1999
Revenue:
Brokerage fees $631,054 $426,193 $156,082
Commissions 146,240 77,528 47,528
Other income 42,932 27,896 19,820
Total revenue 820,226 531,617 223,430
Expense:
Compensation and benefits 439,253 250,643 95,225
Professional and other fees 41,511 36,338 22,450
Advertising and promotions 44,961 31,678 13,212
Office operations 51,229 44,013 16,218
Other expense 48,656 41,851 15,112
Total expense 625,610 404,523 162,217
Net Income $194,616 $127,094 $61,213
Table 8 Delta's Financial Statements - Statement of Changes in Member's
For the Years Ended December 31, 2001, 2000, and 1999
Contributed Retained Total
Capital Earnings
Balances at December 31, 1999 $100,000 $61,213 $161,213
Net income -- 127,094 127,094
Balances at December 31, 2000 $100,000 $188,307 $288,307
Net income -- 194,616 194,616
Balances at December 31, 2001 $100,000 $382,923 $482,923
Table 9
Delta's Financial Statements - Statement of Cash Flows
For the Years Ended December 31, 2001, 2000, and 1999
2001
Cash flows from operating activities
Net income $194,616
Adjustments to reconcile net income to net cash provided
by operating activities
less: Increase in accounts receivable -309,647
add: Decrease in accounts payable and accrued liabilities 133,241
Net cash provided by operating activities 18,210
Cash flows from Investing Activities --
Cash flows from Financing Activities --
Net increase in cash and cash equivalents 18,210
Cash and cash equivalents at beginning of year 65,857
Cash and cash equivalents at end of year $84,067
2000
Cash flows from operating activities
Net income $127,094
Adjustments to reconcile net income to net cash provided
by operating activities
less: Increase in accounts receivable -295,710
add: Decrease in accounts payable and accrued liabilities 185,762
Net cash provided by operating activities 17146
Cash flows from Investing Activities --
Cash flows from Financing Activities --
Net increase in cash and cash equivalents 17,416
Cash and cash equivalents at beginning of year 48,711
Cash and cash equivalents at end of year $65,857
1999
Cash flows from operating activities
Net income $61,213
Adjustments to reconcile net income to net cash provided
by operating activities
less: Increase in accounts receivable -87,543
add: Decrease in accounts payable and accrued liabilities 30,041
Net cash provided by operating activities 3,711
Cash flows from Investing Activities --
Cash flows from Financing Activities --
Net increase in cash and cash equivalents 3,711
Cash and cash equivalents at beginning of year 45,000
Cash and cash equivalents at end of year $48,711
Table 10 : Altman's Z-Score
Z-Score Bankruptcy Model
Z = 1.2(T1) + 1.4(T2) + 3.3(T3) + 0.6(T4) + 0.99(T5)
T1 = Working Capital / Total Assets
T2 = Retained Earnings / Total Assets
T3 = Earnings Before Interest and Taxes / Total Assets
T4 = Market Value of Equity / Book Value of Total Liabilities
T5 = Sales / Total Assets
Zones of Discrimination
Z > 2.99 = Safe Zone
1.80 < Z < 2.99 = Grey Zone
Z < 1.80 = Distress Zone
Table 11
Select Industry Financial Ratios
Source: Compustat
Lending
Institutions
1999 2000 2001 1999
Current Ratio -- -- -- 3.22
Current cash debt coverage ratio -- -- -- 0.23
Accounts receivable turnover 2.49 2.57 2.41 5.36
Debt to Asset 4.38 5.56 6.05 0.6
Cash debt coverage ratio 1.37 0.5 0.17 --
Loan Brokers
2000 2001
Current Ratio 3.2 2.27
Current cash debt coverage ratio 0.08 0.15
Accounts receivable turnover 5.86 4.14
Debt to Asset 0.63 0.64
Cash debt coverage ratio 17.67 10.55
Table 12
Feedback from Students
(n=21)
Questions Mean Median Mode
1. The case is a good example of real-world 4.38 4 4
problems of ineffective accounts receivables
management
2. The case is a good demonstration of a 4.14 4 4
real-world application of financial
flexibility.
3. The case is a good illustration of a 4.14 4 4
real-world application of cash management
4. This case provides good practice with ratio 4.29 5 5
analysis
5. The case is interesting 4.19 4 5
6. This case has increased my understanding of 4.05 4 4
accounts receivables management
7. This case has increased my understanding of 3.95 4 5
bankruptcy prediction using Altman's Z score
8. The case has encouraged me to think 4.33 4 5
critically about accounts receivables
management
9. The case has encouraged me to think 4.38 4 4
critically about cash management
10. This case is a good illustration of 3.86 4 4
bankruptcy prediction