HOUSEHOLD CONSUMER LOAN TRUST 1997-1
8-K, EX-99, 2000-11-22
ASSET-BACKED SECURITIES
Previous: HOUSEHOLD CONSUMER LOAN TRUST 1997-1, 8-K, 2000-11-22
Next: U S RESTAURANT PROPERTIES INC, S-3, 2000-11-22

Household Consumer Loan Trust, Series 1997-1 Deposit Trust Calculations

Previous Due Period Ending

Sep 30, 2000

Current Due Period Ending

Oct 31, 2000

Prior Distribution Date

Oct 13, 2000

Distribution Date

Nov 14, 2000

Beginning Trust Principal Receivables

3,747,215,208.00

Average Principal Receivables

3,747,062,935.87

FC&A Collections (Includes Recoveries)

63,208,517.86

Principal Collections

103,775,791.01

Additional Balances

44,214,497.95

Net Principal Collections

59,561,293.06

Defaulted Amount

23,009,507.06

Miscellaneous Payments

0.00

Principal Recoveries

2,155,589.00

Beginning Participation Invested Amount

330,509,338.77

Beginning Participation Unpaid Principal Balance

330,509,338.77

Ending Participation Invested Amount

323,226,189.00

Ending Participation Unpaid Principal Balance

323,226,189.00

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

330,509,338.77

Numerator for Fixed Allocation

338,382,376.94

Denominator - Max(Sum of Numerators, Principal Receivables)

3,747,062,935.87

Applicable Allocation Percentage

8.8205%

Investor FC&A Collections

5,575,301.46

Series Participation Interest Default Amount

Numerator for Floating Allocation

330,509,338.77

Denominator - Max(Sum of Numerators, Principal Receivables)

3,747,062,935.87

Floating Allocation Percentage

8.8205%

Series Participation Interest Default Amount

2,029,551.44

Principal Allocation Components

Numerator for Floating Allocation

330,509,338.77

Numerator for Fixed Allocation

338,382,376.94

Denominator - Max(Sum of Numerators, Principal Receivables)

3,747,062,935.87

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.1623%

(d) Series Participation Interest Unpaid Principal Balance

330,509,338.77

(e) Actual days in the Interest Period

32

Series Participation Monthly Interest, [a*d*e]

2,350,288.63

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,283,149.77

(a) Investor Principal Collections, [Max(b,h) or e]

5,253,598.33

(b) prior to Accelerated Amort. Date or not Early Amort. Period, [c*d]

5,253,598.33

(c) Floating Allocation Percentage

8.8205%

(d) Net Principal Collections

59,561,293.06

(e) after Accelerated Amort Date or Early Amort Period, [f*g]

9,371,579.67

(f) Fixed Allocation Percentage

9.0306%

(g) Collections of Principal

103,775,791.01

(h) Minimum Principal Amount, [Min(i,l)]

5,241,654.01

(i) Floating Allocation Percentage of Principal Collections

9,153,534.02

(j) 2.2% of the Series Participation Interest Invested Amount

7,271,205.45

(k) Series Participation Interest Net Default Payment Amount

2,029,551.44

(l) the excess of (j) over (k)

5,241,654.01

(m) Series Participation Interest Net Default Payment Amount

2,029,551.44

(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,575,301.46

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,350,288.63

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)]

2,029,551.44

Reimbursed Series Participation Interest Charge-Offs [Sec. 4.11(a)(iv)]

0.00

Servicing Fee Paid [Sec. 4.11(a)(v)]

550,848.90

Excess [Sec. 4.11(a)(vi)]

644,612.49

Series Participation Investor Charge Off [Sec. 4.12(a)]

0.00

Seller's Interest

1,322,931,298.30

Series 1997-1 Owner Trust Calculations

Due Period

October 2000

Payment Date

Nov 15, 2000

Optimum Monthly Principal [a+b+c]

(a) Available Investor Principal Collections

7,283,149.77

(b) Series Participation Interest Charge Offs

0.00

(c) Lesser of Excess Interest and Carryover Charge offs

0.00

Accelerated Principal Payment

68,856.11

Series Participation Interest Monthly Interest

2,350,288.63

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)

965,627.46

Pay Class A-2 Interest Distribution- Sec. 3.05(a)(i)(b)

189,216.60

Pay Class A-3 Interest Distribution- Sec. 3.05(a)(i)(c)

249,562.09

Pay Class B Interest Distribution- Sec. 3.05(a)(i)(d)

190,221.90

Pay Certificates the Certificate Yield- Sec. 3.05(a)(i)(e)

146,911.40

Principal up to Optimum Monthly Principal Balance

Pay Class A-1 to Targeted Principal Balance- Sec. 3.05(a)(ii)(a)

3,716,741.55

Pay Class A-2 to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(ii)(b)

728,314.98

Pay Class A-3 to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(ii)(c)

946,809.47

Pay Class B to Targeted Principal Balance subject to Min Adj Bal- Sec. 3.05(a)(ii)(d)

691,899.22

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)

509,820.48

Pay OC Remaining Optimal Monthly Prin Amt subject to OC Min Bal- Sec. 3.05(a)(iv)

689,564.07

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)

68,856.11

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)

539,893.07

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)

689,564.07

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

68,856.11

To Designated Certificate Holder up to Holdback Amount

620,707.96

To HCLC any remaining amounts

0.00

Principal paid to the Designated Certificate

5,098.20



Household Consumer Loan Trust, 1997-1

Series 1997-1 Owner Trust Calculations

Due Period Ending

Oct 31, 2000

Payment Date

Nov 15, 2000

Calculation of Interest Expense

Index (LIBOR)

6.620000%

Accrual end date, accrual beginning date and days in Interest Period

Nov 15, 2000

Oct 16, 2000

30

Class A-1

Class A-2

Class A-3

Class B

Certificates

Overcoll Amount

Beginning Unpaid Principal Balance

171,794,360

33,050,934

42,966,214

31,398,387

23,135,654

28,163,790

Previously unpaid interest/yield

0

0

0

0

0

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

965,627

189,217

249,562

190,222

146,911

Interest on previously unpaid interest/yield

0

0

0

0

0

Interest/Yield Due

965,627

189,217

249,562

190,222

146,911

Interest/Yield Paid

965,627

189,217

249,562

190,222

146,911

Summary

Beginning Security Balance

171,794,360

33,050,934

42,966,214

31,398,387

23,135,654

28,163,790

Beginning Adjusted Balance

171,794,360

33,050,934

42,966,214

31,398,387

23,135,654

Principal Paid

3,785,598

728,315

946,809

691,899

509,820

689,564

Ending Security Balance

168,008,762

32,322,619

42,019,405

30,706,488

22,625,833

27,543,082

Ending Adjusted Balance

168,008,762

32,322,619

42,019,405

30,706,488

22,625,833

Ending Certificate Balance as % Participation Interest Invested Amount

7.0000%

Targeted Balance

168,077,618

32,322,619

42,019,405

30,706,488

22,625,833

Minimum Adjusted Balance

16,000,000

20,800,000

15,200,000

11,200,000

13,600,000

Certificate Minimum Balance

3,264,908

Ending OC Amount as Holdback Amount

19,233,450

Ending OC Amount as Accelerated Prin Pmts

8,309,632

Beginning Net Charge offs

0

0

0

0

0

-

Reversals

0

0

0

0

0

-

Charge offs

0

0

0

0

0

-

Ending Net Charge Offs

0

0

0

0

0

-

Interest/Yield Paid per $1000

1

4

4

4

4

Principal Paid per $1000

5

15

15

15

15



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