EXHIBIT 10(d)
QUARTERLY SERVICER's CERTIFICATE
CONSUMERS FUNDING LLC
$468,592,000 SECURITIZATION BONDS, SERIES 2001-1
Pursuant to Section 3.05 of the Servicing Agreement dated as of November 8, 2001
(the "Consumers Servicing Agreement") between Consumers Energy Company, as
Servicer and Consumers Funding LLC, as Issuer, the Servicer does hereby
certify as follows:
Capitalized terms used in the Quarterly Servicer's Certificate (the "Quarterly
Certificate") have their respective meanings as set forth in the Agreement.
References herein to certain sections and subsections are references to the
respective sections of the Agreement.
Billing Periods: April 2004, May 2004, June 2004
Payment Date: July 20, 2004
1. COLLECTIONS ALLOCABLE AND AGGREGATE AMOUNTS AVAILABLE FOR THE CURRENT PAYMENT DATE:
i. Remittances for the April 2004 Collection Period $ 4,013,407.00
ii. Remittances for the May 2004 Collection Period $ 3,792,600.00
iii. Remittances for the June 2004 Collection Period $ 3,875,738.00
iv. Remittances for the Collection Period $ 0.00
v. Remittances for the Collection Period $ 0.00
vi. Remittances for the Collection Period $ 0.00
vii. Remittances for the Collection Period $ 0.00
viii. Net Earnings on Collection Account $ 17,432.94
ix. Net Earnings on Capital Subaccount $ 5,352.68
x. Net Earnings on Overcollateralization Subaccount $ 893.56
xi. Net Earnings on Reserve Subaccount $ 5,378.74
----------------
GENERAL SUBACCOUNT BALANCE $ 11,710,802.92
xii. Reserve Subaccount Balance $ 2,190,362.58
xiii. Overcollateralization Subaccount Balance $ 418,385.71
xiv. Capital Subaccount Balance (less $100K) $ 2,242,960.00
xv. Capital Reserve Subaccount Balance $ 100,000.00
----------------
xvi. COLLECTION ACCOUNT BALANCE $ 16,662,511.21
2. OUTSTANDING PRINCIPAL BALANCE AND COLLECTION ACCOUNT BALANCE AS OF PRIOR PAYMENT DATE:
i. Class A-1 Principal Balance $ 0.00
ii. Class A-2 Principal Balance $ 53,595,934.22
iii. Class A-3 Principal Balance $ 31,000,000.00
iv. Class A-4 Principal Balance $ 95,000,000.00
v. Class A-5 Principal Balance $ 117,000,000.00
vi. Class A-6 Principal Balance $ 115,592,000.00
----------------
VII. SECURITIZATION BOND PRINCIPAL BALANCE $ 412,187,934.22
viii. Reserve Subaccount Balance $ 2,190,362.58
ix. Overcollateralization Subaccount Balance $ 418,385.71
x. Capital Subaccount Balance $ 2,242,960.00
xi. Capital Reserve Subaccount Balance $ 100,000.00
3. REQUIRED FUNDING/PAYMENTS AS OF CURRENT PAYMENT DATE:
i. Projected Class A-1 Bond Balance $ 0.00
ii. Projected Class A-2 Bond Balance $ 47,370,595.60
iii. Projected Class A-3 Bond Balance $ 31,000,000.00
iv. Projected Class A-4 Bond Balance $ 95,000,000.00
v. Projected Class A-5 Bond Balance $ 117,000,000.00
vi. Projected Class A-6 Bond Balance $ 115,592,000.00
----------------
VII. PROJECTED SECURITIZATION BOND BALANCE $ 405,962,595.60
viii. Required Class A-1 Coupon (2.59% per annum rate) $ 0.00
ix. Required Class A-2 Coupon (3.80% per annum rate) $ 509,161.38
Page 2 of 5
x. Required Class A-3 Coupon (4.55% per annum rate) $ 352,625.00
xi. Required Class A-4 Coupon (4.98% per annum rate) $ 1,182,750.00
xii. Required Class A-5 Coupon (5.43% per annum rate) $ 1,588,275.00
xiii. Required Class A-6 Coupon (5.76% per annum rate) $ 1,664,524.80
xiv. Required Overcollateralization Funding $ 41,838.58
xv. Required Capital Subaccount Funding $ 0.00
4. ALLOCATION OF REMITTANCES AS OF CURRENT PAYMENT DATE PURSUANT TO 8.02 OF THE INDENTURE:
i. Bond Trustee Fees and Expenses $ 0.00
ii. Servicing Fee $ 257,617.46
iii. Cumulative Monthly Administration Fee during Relevant Quarter $ 20,000.00
iv. Independent Managers Fee $ 1,750.00
v. Operating Expenses (subject to cap of $100,000/quarter) $ 8,162.41
VI. QUARTERLY INTEREST $ 5,297,336.18
1.Class A-1 Bond Coupon Payment $ 0.00
2.Class A-2 Bond Coupon Payment $ 509,161.38
3.Class A-3 Bond Coupon Payment $ 352,625.00
4.Class A-4 Bond Coupon Payment $ 1,182,750.00
5.Class A-5 Bond Coupon Payment $ 1,588,275.00
6.Class A-6 Bond Coupon Payment $ 1,664,524.80
vii. Principal Due and Payable as a Result of Event of Default or on Final Maturity Date $ 0.00
VIII. QUARTERLY PRINCIPAL $ 6,225,338.62
1.Class A-1 Bond Principal Payment $ 0.00
2.Class A-2 Bond Principal Payment $ 6,225,338.62
3.Class A-3 Bond Principal Payment $ 0.00
4.Class A-4 Bond Principal Payment $ 0.00
5.Class A-5 Bond Principal Payment $ 0.00
6.Class A-6 Bond Principal Payment $ 0.00
ix. Operating Expenses (in excess of $100,000) $ 0.00
x. Funding of Capital Subaccount (to required level) $ 0.00
xi. Funding of Overcollateralization Subaccount (to required level) $ 41,838.58
xii. Net Earnings on Capital Subaccount Released to Issuer $ 5,352.68
xiii. Deposits to Reserve Subaccount $ 0.00
xiv. Released to Issuer upon Series Retirement: Collection Account $ 0.00
5. OUTSTANDING PRINCIPAL BALANCE AND COLLECTION ACCOUNT BALANCE AS OF CURRENT PAYMENT DATE:
(AFTER GIVING EFFECT TO PAYMENTS TO BE MADE ON SUCH PAYMENT DATE):
i. Class A-1 Principal Balance $ 0.00
ii. Class A-2 Principal Balance $ 47,370,595.60
iii. Class A-3 Principal Balance $ 31,000,000.00
iv. Class A-4 Principal Balance $ 95,000,000.00
v. Class A-5 Principal Balance $ 117,000,000.00
vi. Class A-6 Principal Balance $ 115,592,000.00
VII. SECURITIZATION BOND PRINCIPAL BALANCE $ 405,962,595.60
viii. Reserve Subaccount Balance $ 2,043,769.58
ix. Overcollateralization Subaccount Balance $ 460,224.29
x. Capital Subaccount Balance $ 2,242,960.00
xi. Capital Reserve Subaccount Balance $ 100,000.00
Page 3 of 5
6. SUBACCOUNT DRAWS AS OF CURRENT PAYMENT DATE (IF APPLICABLE, PURSUANT TO
SECTION 8.02 OF THE INDENTURE):
i. Reserve Subaccount $ 146,593.00
ii. Overcollateralization Subaccount $ 0.00
iii. Capital Subaccount $ 0.00
iv. Capital Reserve Subaccount $ 0.00
------------
V. TOTAL DRAWS $ 146,593.00
7. SHORTFALLS IN INTEREST AND PRINCIPAL PAYMENTS AS OF CURRENT PAYMENT DATE:
I. QUARTERLY INTEREST $ 0.00
1. Class A-1 Bond Coupon Payment $ 0.00
2. Class A-2 Bond Coupon Payment $ 0.00
3. Class A-3 Bond Coupon Payment $ 0.00
4. Class A-4 Bond Coupon Payment $ 0.00
5. Class A-5 Bond Coupon Payment $ 0.00
6. Class A-6 Bond Coupon Payment $ 0.00
II. QUARTERLY PRINCIPAL $ 0.00
1. Class A-1 Bond Principal Payment $ 0.00
2. Class A-2 Bond Principal Payment $ 0.00
3. Class A-3 Bond Principal Payment $ 0.00
4. Class A-4 Bond Principal Payment $ 0.00
5. Class A-5 Bond Principal Payment $ 0.00
6. Class A-6 Bond Principal Payment $ 0.00
8. SHORTFALLS IN REQUIRED SUBACCOUNT LEVELS AS OF CURRENT PAYMENT DATE:
i. Overcollateralization Subaccount $ 0.00
ii. Capital Subaccount $ 0.00
IN WITNESS HEREOF, the undersigned has duly executed and delivered this
Quarterly Servicer's Certificate this 13th day of July, 2004.
Consumers Energy Company, as Servicer
by: /s/ Glenn P. Barba
------------------------------------
Glenn P. Barba
Vice President, Controller and Chief Accounting Officer
Page 4 of 5