HOUSEHOLD CONSUMER LOAN TRUST 1997-1
8-K, EX-99, 2000-12-26
ASSET-BACKED SECURITIES
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



© 2022 IncJournal is not affiliated with or endorsed by the U.S. Securities and Exchange Commission