Spreadsheet: jim_schwieger__14305__Paymentdetail
Sheet: Jan01

 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value |  | Comment
ST-ASSUMPTION | N24318.2 | F | ANNUITY | 01-JAN-2001 | 0 | 0 | 1 | 9.98 | 0 | -82325 | 0 | -82325 | [NAME] [NAME] 99-Mar02
ST-ASSUMPTION | N24318.3 | F | ANNUITY | 01-JAN-2001 | 0 | 0 | 1 | 9.98 | 0 | -258870 | 0 | -258870 | [NAME]
ST-ASSUMPTION | N29716.3 | F | ANNUITY | 01-JAN-2001 | 0 | 0 | 1 | 9.98 | 0 | -5709 | 0 | -5709 | Ad Valorem for Greatwood
ST-ASSUMPTION | N34416.3 | F | ANNUITY | 01-JAN-2001 | 0 | 0 | 1 | 9.98 | 0 | -3824 | 0 | -3824 | Ad Valorem Charge for Spring
ST-ASSUMPTION | QC4014.3 | F | ANNUITY | 01-JAN-2001 | 0 | 0 | 1 | 9.98 | 0 | -417500 | 0 | -417500 | Ad Valorem
ST-ASSUMPTION | QI4976.1 | F | ANNUITY | 01-JAN-2001 | 0 | 0 | 1 | 9.98 | 0 | 2155000 | 0 | 2155000 | Additional Ad Valorem Tax Annuity due to the run up in high prices
EGM | N31485.4 | F | NX3 | 01-JAN-2001 | -436495 | 0 | 1 | 9.788 | 2.921 | 0 | -2997411.165 | -2997411.165 | Ad Valorem Tax - Do not confirm
EGM | N85399.6 | F | NX3 | 01-JAN-2001 | -123250 | 0 | 1 | 9.788 | 1e-07 | 0 | -1206370.9877 | -1206370.9877 | Ad Valorem Tax - Do not confirm
EGM | NA9035.5 | F | NX3 | 01-JAN-2001 | -78300 | 0 | 1 | 9.788 | 1e-07 | 0 | -766400.3922 | -766400.3922 | Ad Valorem Tax - Do not confirm
EGM | NH1175.6 | F | NX3 | 01-JAN-2001 | 26100 | 0 | 1 | 9.788 | 1e-07 | 0 | 255466.7974 | 255466.7974 | Ad Valorem Tax - Do not confirm
EGM | NL2680.3 | F | NX3 | 01-JAN-2001 | 13050 | 0 | 1 | 9.788 | 1e-07 | 0 | 127733.3987 | 127733.3987 | Ad Valorem Tax - Do not Confirm
EGM | NM6199.6 | F | NX3 | 01-JAN-2001 | 20670 | 0 | 1 | 9.788 | 1e-07 | 0 | 202317.9579 | 202317.9579 | Ad Valorem Tax - Do not confirm
EGM | NO9767.5 | F | NX3 | 01-JAN-2001 | 52200 | 0 | 1 | 9.788 | 1e-07 | 0 | 510933.5948 | 510933.5948 | Ad Valorem Tax - Do not confirm
EGM | NR9968.5 | F | NX3 | 01-JAN-2001 | 80910 | 0 | 1 | 9.788 | 1e-07 | 0 | 791947.0719 | 791947.0719 | Ad Valorem Tax - Do not confirm
EGM | NS1748.5 | F | NX3 | 01-JAN-2001 | -2866 | 0 | 1 | 9.788 | 1e-07 | 0 | -28052.4077 | -28052.4077 | Ad Valorem Tax - Do not confirm
EGM | NY5284.5 | F | NX3 | 01-JAN-2001 | 32625 | 0 | 1 | 9.788 | 1e-07 | 0 | 319333.4967 | 319333.4967 | Ad Valorem Tax - Do not confirm
EGM | QH7023.5 | F | NX3 | 01-JAN-2001 | 44000 | 0 | 1 | 9.788 | 1e-07 | 0 | 430671.9956 | 430671.9956 | Ad Valorem Tax - Do not confirm
ST-ASSUMPTION | N24318.5 | F | ANNUITY | 01-JAN-2001 | 0 | 0 | 1 | 9.98 | 0 | -17675 | 0 | AV | [NAME] [NAME] 99-Mar02 for [NAME]
EGM | N31523.4 | F | NX3 | 01-JAN-2001 | -231175 | 0 | 1 | 9.788 | 2.921 | 0 | -1587478.725 | AV | Ad Valorem Tax - do not confirm
Basis
EGM | N31485.4 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | -436495 | 0 | 1 | 0.052 | -0.075 | 0 | -55434.86500000001 | AV | Ad Valorem Tax - Do not confirm |  | TP | 3rd party | 0
EGM | N85399.6 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | -123250 | 0 | 1 | 0.052 | 0.005 | 0 | -5792.75 | AV | Ad Valorem Tax - Do not confirm |  | PA | phy assum | 2590881.5696
EGM | NA9035.5 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | -78300 | 0 | 1 | 0.052 | 0.005 | 0 | -3680.1 | AV | Ad Valorem Tax - Do not confirm |  |  | total | 3289962.4371
EGM | NH1175.6 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | 26100 | 0 | 1 | 0.052 | 0.0075 | 0 | 1161.45 | AV | Ad Valorem Tax - Do not confirm
EGM | NL2680.3 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | 13050 | 0 | 1 | 0.052 | 0.0025 | 0 | 645.975 | AV | Ad Valorem Tax - Do not Confirm
EGM | NM6199.6 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | 20670 | 0 | 1 | 0.052 | 0.0025 | 0 | 1023.165 | AV | Ad Valorem Tax - Do not confirm
EGM | NO9767.5 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | 52200 | 0 | 1 | 0.052 | 0.0025 | 0 | 2583.9 | AV | Ad Valorem Tax - Do not confirm
EGM | NR9968.5 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | 80910 | 0 | 1 | 0.052 | 0.0025 | 0 | 4005.045 | AV | Ad Valorem Tax - Do not confirm
EGM | NS1748.5 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | -2866 | 0 | 1 | 0.052 | 0.0025 | 0 | -141.867 | AV | Ad Valorem Tax - Do not confirm
EGM | NY5284.5 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | 32625 | 0 | 1 | 0.052 | 0.01 | 0 | 1370.25 | AV | Ad Valorem Tax - Do not confirm
EGM | QH7023.5 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | 44000 | 0 | 1 | 0.052 | 0.02 | 0 | 1408 | AV | Ad Valorem Tax - Do not confirm
EGM | N31523.4 | F | IF-HPL/SHPCHAN | 01-JAN-2001 | -231175 | 0 | 1 | 0.052 | -0.075 | 0 | -29359.225 | AV | Ad Valorem Tax - do not confirm
 |  |  |  | Volume
 |  |  |  |  |  |  |  |  |  | Total