|
Previous: HOUSEHOLD CONSUMER LOAN TRUST 1997-1, 8-K, 2000-12-26 |
Next: MPEG SUPER SITE INC, 8-K, 2000-12-26 |
Household Consumer Loan Trust, Series 1997-1 Deposit Trust Calculations |
|
|||||||
Previous Due Period Ending |
Oct 31, 2000 |
|||||||
Current Due Period Ending |
Nov 30, 2000 |
|||||||
Prior Distribution Date |
Nov 14, 2000 |
|||||||
Distribution Date |
Dec 14, 2000 |
|||||||
Beginning Trust Principal Receivables |
3,664,583,017.08 |
|||||||
Average Principal Receivables |
3,664,245,575.33 |
|||||||
FC&A Collections (Includes Recoveries) |
60,959,766.01 |
|||||||
Principal Collections |
101,584,967.49 |
|||||||
Additional Balances |
44,547,694.24 |
|||||||
Net Principal Collections |
57,037,273.25 |
|||||||
Defaulted Amount |
20,830,604.69 |
|||||||
Miscellaneous Payments |
0.00 |
|||||||
Principal Recoveries |
1,383,253.00 |
|||||||
|
|
|||||||
Beginning Participation Invested Amount |
323,226,189.00 |
|||||||
Beginning Participation Unpaid Principal Balance |
323,226,189.00 |
|||||||
Ending Participation Invested Amount |
316,115,212.84 |
|||||||
Ending Participation Unpaid Principal Balance |
316,115,212.84 |
|||||||
|
|
|||||||
Accelerated Amortization Date |
Feb 28, 2002 |
|||||||
Is it the Accelerated Amortization Period? 0=No |
0 |
|||||||
OC Balance as % of Ending Participation Invested Amount (3 month average) |
8.521% |
|||||||
Is it Early Amortization? (No, if 3 month OC Average >or=4.25%) |
0 |
|||||||
|
|
|||||||
Investor Finance Charges and Administrative Collections |
|
|||||||
Numerator for Floating Allocation |
323,226,189.00 |
|||||||
Numerator for Fixed Allocation |
330,509,338.77 |
|||||||
Denominator - Max(Sum of Numerators, Principal Receivables) |
3,664,245,575.33 |
|||||||
Applicable Allocation Percentage |
8.8211% |
|||||||
Investor FC&A Collections |
5,377,312.31 |
|||||||
|
|
|||||||
Series Participation Interest Default Amount |
|
|||||||
Numerator for Floating Allocation |
323,226,189.00 |
|||||||
Denominator - Max(Sum of Numerators, Principal Receivables) |
3,664,245,575.33 |
|||||||
Floating Allocation Percentage |
8.8211% |
|||||||
Series Participation Interest Default Amount |
1,837,485.19 |
|||||||
|
|
|||||||
|
|
|||||||
Principal Allocation Components |
|
|||||||
Numerator for Floating Allocation |
323,226,189.00 |
|||||||
Numerator for Fixed Allocation |
330,509,338.77 |
|||||||
Denominator - Max(Sum of Numerators, Principal Receivables) |
3,664,245,575.33 |
|||||||
|
|
|||||||
|
|
|||||||
Series Participation Interest Monthly Interest |
||||||||
(a) Series Participation Interest Pass Through Rate, [Max(b,c)] |
8.0000% |
|||||||
(b) Prime Rate minus 1.50% |
8.0000% |
|||||||
(c) Rate Sufficient to Cover Interest, Yield and Accelerated Principal Pmt Amount |
6.5731% |
|||||||
(d) Series Participation Interest Unpaid Principal Balance |
323,226,189.00 |
|||||||
(e) Actual days in the Interest Period |
30 |
|||||||
Series Participation Monthly Interest, [a*d*e] |
2,154,841.26 |
|||||||
|
|
|||||||
Series Participation Interest Interest Shortfall |
0.00 |
|||||||
Previous Series Participation Interest Interest Shortfall |
0.00 |
|||||||
|
|
|||||||
Additional Interest |
0.00 |
|||||||
|
|
|||||||
Series Participation Interest Monthly Principal |
|
|||||||
Available Investor Principal Collections, [a+m+n] |
7,110,976.16 |
|||||||
|
|
|||||||
(a) Investor Principal Collections, [Max(b,h) or e] |
5,273,490.97 |
|||||||
(b) prior to Accelerated Amort. Date or not Early Amort. Period, [c*d] |
5,031,305.92 |
|||||||
(c) Floating Allocation Percentage |
8.8211% |
|||||||
(d) Net Principal Collections |
57,037,273.25 |
|||||||
(e) after Accelerated Amort Date or Early Amort Period, [f*g] |
9,162,808.48 |
|||||||
(f) Fixed Allocation Percentage |
9.0198% |
|||||||
(g) Collections of Principal |
101,584,967.49 |
|||||||
|
|
|||||||
(h) Minimum Principal Amount, [Min(i,l)] |
5,273,490.97 |
|||||||
(i) Floating Allocation Percentage of Principal Collections |
8,960,895.56 |
|||||||
(j) 2.2% of the Series Participation Interest Invested Amount |
7,110,976.16 |
|||||||
(k) Series Participation Interest Net Default Payment Amount |
1,837,485.19 |
|||||||
(l) the excess of (j) over (k) |
5,273,490.97 |
|||||||
|
|
|||||||
(m) Series Participation Interest Net Default Payment Amount |
1,837,485.19 |
|||||||
|
|
|||||||
(n) Optional Repurchase Amount (principal only) at Sec. 9 |
0.00 |
|||||||
|
|
|||||||
Application of Investor Finance Charges and Admin Collections |
|
|||||||
Investor Finance Charges and Admin. Collections [Sec. 4.11(a)] |
5,377,312.31 |
|||||||
Series Servicing Fee paid if HFC is not the Servicer [Sec. 4.11(a)(i)] |
0.00 |
|||||||
plus any unpaid Series Servicing Fee of other than HFC |
0.00 |
|||||||
Series Participation Interest Monthly Interest [Sec. 4.11(a)(ii)] |
2,154,841.26 |
|||||||
Series Participation Interest Interest Shorfall [Sec. 4.11(a)(ii)] |
0.00 |
|||||||
Additional Interest [Sec. 4.11(a)(ii)] |
0.00 |
|||||||
Series Participation Interest Default Amount [Sec. 4.11(a)(iii)] |
1,837,485.19 |
|||||||
Reimbursed Series Participation Interest Charge-Offs [Sec. 4.11(a)(iv)] |
0.00 |
|||||||
Servicing Fee Paid [Sec. 4.11(a)(v)] |
538,710.32 |
|||||||
Excess [Sec. 4.11(a)(vi)] |
846,275.54 |
|||||||
|
|
|||||||
Series Participation Investor Charge Off [Sec. 4.12(a)] |
0.00 |
|||||||
Seller's Interest |
1,302,984,399.67 |
|||||||
|
||||||||
Series 1997-1 Owner Trust Calculations |
||||||||
Due Period |
November 2000 |
|||||||
Payment Date |
Dec 15, 2000 |
|||||||
Optimum Monthly Principal [a+b+c] |
||||||||
(a) Available Investor Principal Collections |
7,110,976.16 |
|||||||
(b) Series Participation Interest Charge Offs |
0.00 |
|||||||
(c) Lesser of Excess Interest and Carryover Charge offs |
0.00 |
|||||||
Accelerated Principal Payment |
67,338.79 |
|||||||
Series Participation Interest Monthly Interest |
2,154,841.26 |
|||||||
Allocation of Optimum Monthly Principal and Series Part. Interest Monthly Interest |
||||||||
Interest and Yield |
||||||||
Pay Class A-1 Interest Distribution- Sec. 3.05(a)(i)(a) |
944,349.25 |
|||||||
Pay Class A-2 Interest Distribution- Sec. 3.05(a)(i)(b) |
185,046.99 |
|||||||
Pay Class A-3 Interest Distribution- Sec. 3.05(a)(i)(c) |
244,062.71 |
|||||||
Pay Class B Interest Distribution- Sec. 3.05(a)(i)(d) |
186,030.14 |
|||||||
Pay Certificates the Certificate Yield- Sec. 3.05(a)(i)(e) |
143,674.04 |
|||||||
Principal up to Optimum Monthly Principal Balance |
||||||||
Pay Class A-1 to Targeted Principal Balance- Sec. 3.05(a)(ii)(a) |
3,628,851.49 |
|||||||
Pay Class A-2 to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(ii)(b) |
711,097.62 |
|||||||
Pay Class A-3 to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(ii)(c) |
924,426.90 |
|||||||
Pay Class B to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(ii)(d) |
675,542.74 |
|||||||
|
||||||||
Pay Certificate Yield if not paid pursuant to Sec. 3.05 (a)(i)(e) |
0.00 |
|||||||
Principal up to Optimal Monthly Principal |
||||||||
Pay Certificate to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(iii) |
497,768.33 |
|||||||
Pay OC Remaining Optimal Monthly Prin Amt subject to OC Min Bal- Sec. 3.05(a)(iv) |
673,289.08 |
|||||||
Principal up to Accelerated Principal Payment Amout |
||||||||
Pay Class A-1 to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(v)(a) |
0.00 |
|||||||
Pay Class A-2 to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(v)(b) |
0.00 |
|||||||
Pay Class A-3 to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(v)(c) |
0.00 |
|||||||
Pay Class B to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(v)(d) |
0.00 |
|||||||
Pay Class A-1 to zero- Sec. 3.05(a)(v)(e) |
67,338.79 |
|||||||
Pay Class A-2 to zero- Sec. 3.05(a)(v)(f) |
0.00 |
|||||||
Pay Class A-3 to zero- Sec. 3.05(a)(v)(g) |
0.00 |
|||||||
Pay Class B to zero- Sec. 3.05(a)(v)(h) |
0.00 |
|||||||
Principal up to Optimal Monthly Principal |
||||||||
Pay Class A-1 to zero- Sec. 3.05(a)(vi)(a) |
0.00 |
|||||||
Pay Class A-2 to zero- Sec. 3.05(a)(vi)(b) |
0.00 |
|||||||
Pay Class A-3 to zero- Sec. 3.05(a)(vi)(c) |
0.00 |
|||||||
Pay Class B to zero- Sec. 3.05(a)(vi)(d) |
0.00 |
|||||||
Pay Certificates up to Certificate Minimum Balance or zero- Sec. 3.05(a)(vi)(e) |
0.00 |
|||||||
Pay HCLC Optimum Monthly Principal provided OC >0- Sec. 3.05(a)(vi)(f) |
0.00 |
|||||||
Remaining Amounts to Holder of Designated Certificate - Sec. 3.05(a)(vii) |
384,339.34 |
|||||||
Allocations of Distributions to Overcollateralization Amount |
||||||||
Available Distributions |
||||||||
Pay OC Remaining Optimal Monthly Prin Amt subject to OC Min Bal- Sec. 3.05(a)(iv) |
673,289.08 |
|||||||
Pay HCLC Optimum Monthly Principal provided OC >0- Sec. 3.05(a)(vi) |
0.00 |
|||||||
To Designated Certificate Holder up to total Accelerated Principal Payments |
67,338.79 |
|||||||
To Designated Certificate Holder up to Holdback Amount |
605,950.29 |
|||||||
To HCLC any remaining amounts |
0.00 |
|||||||
Principal paid to the Designated Certificate |
4,977.68 |
|||||||
|
||||||||
Household Consumer Loan Trust, 1997-1 |
||||||||
Series 1997-1 Owner Trust Calculations |
||||||||
Due Period Ending |
Nov 30, 2000 |
|||||||
Payment Date |
Dec 15, 2000 |
|||||||
Calculation of Interest Expense |
||||||||
Index (LIBOR) |
6.620000% |
|
||||||
Accrual end date, accrual beginning date and days in Interest Period |
Dec 15, 2000 |
Nov 15, 2000 |
30 |
|||||
Class A-1 |
Class A-2 |
Class A-3 |
Class B |
Certificates |
Overcoll Amount |
|||
Beginning Unpaid Principal Balance |
168,008,762 |
32,322,619 |
42,019,405 |
30,706,488 |
22,625,833 |
27,543,082 |
||
Previously unpaid interest/yield |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|||
Spread to index |
0.125% |
0.250% |
0.350% |
0.650% |
1.000% |
|||
Rate (capped at 12.5%, 14%, 14%, 14%, 15%) |
6.745000% |
6.870000% |
6.970000% |
7.270000% |
7.620000% |
|
||
Interest/Yield Payable on the Principal Balance |
944,349 |
185,047 |
244,063 |
186,030 |
143,674 |
|
||
Interest on previously unpaid interest/yield |
0 |
0 |
0 |
0 |
0 |
|
||
Interest/Yield Due |
944,349 |
185,047 |
244,063 |
186,030 |
143,674 |
|||
Interest/Yield Paid |
944,349 |
185,047 |
244,063 |
186,030 |
143,674 |
|
||
|
||||||||
Summary |
||||||||
Beginning Security Balance |
168,008,762 |
32,322,619 |
42,019,405 |
30,706,488 |
22,625,833 |
27,543,082 |
||
Beginning Adjusted Balance |
168,008,762 |
32,322,619 |
42,019,405 |
30,706,488 |
22,625,833 |
|||
Principal Paid |
3,696,190 |
711,098 |
924,427 |
675,543 |
497,768 |
673,289 |
||
Ending Security Balance |
164,312,572 |
31,611,521 |
41,094,978 |
30,030,945 |
22,128,065 |
26,937,132 |
||
Ending Adjusted Balance |
164,312,572 |
31,611,521 |
41,094,978 |
30,030,945 |
22,128,065 |
|||
Ending Certificate Balance as % Participation Interest Invested Amount |
0 |
|||||||
Targeted Balance |
164,379,911 |
31,611,521 |
41,094,978 |
30,030,945 |
22,128,065 |
|||
Minimum Adjusted Balance |
16,000,000 |
20,800,000 |
15,200,000 |
11,200,000 |
13,600,000 |
|||
Certificate Minimum Balance |
|
3,193,080 |
||||||
Ending OC Amount as Holdback Amount |
18,627,500 |
|||||||
Ending OC Amount as Accelerated Prin Pmts |
8,309,632 |
|||||||
Beginning Net Charge offs |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
||
Reversals |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
||
Charge offs |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
||
Ending Net Charge Offs |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
||
|
|
|
|
|
|
|||
Interest/Yield Paid per $1000 |
$1.2943383 |
$3.8551456 |
$3.9112614 |
$4.0796083 |
$4.2760131 |
|
||
Principal Paid per $1000 |
$5.0660503 |
$14.8145337 |
$14.8145337 |
$14.8145338 |
$14.8145336 |
|
||
|