forked from NatLabRockies/GEOPHIRES-X
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathexample_SAM-single-owner-PPA-7b_chp-cc.out
More file actions
494 lines (423 loc) · 78.7 KB
/
Copy pathexample_SAM-single-owner-PPA-7b_chp-cc.out
File metadata and controls
494 lines (423 loc) · 78.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
*****************
***CASE REPORT***
*****************
Simulation Metadata
----------------------
GEOPHIRES Version: 3.14.0
Simulation Date: 2026-06-11
Simulation Time: 12:32
Calculation Time: 1.837 sec
***SUMMARY OF RESULTS***
End-Use Option: Cogeneration Topping Cycle, Heat sales considered as extra income
Average Net Electricity Production: 45.52 MW
Average Direct-Use Heat Production: 62.20 MW
Electricity breakeven price: 9.56 cents/kWh
Direct-Use heat breakeven price (LCOH): 3.46 USD/MMBTU
Total CAPEX: 283.80 MUSD
Electricity CAPEX ($/kWe): 5304 USD/kW
Heat CAPEX ($/kWth): 658 USD/kW
Number of production wells: 6
Number of injection wells: 4
Flowrate per production well: 100.0 kg/sec
Well depth: 2.7 kilometer
Segment 1 Geothermal gradient: 74 degC/km
Segment 1 Thickness: 2.5 kilometer
Segment 2 Geothermal gradient: 41 degC/km
Segment 2 Thickness: 0.5 kilometer
Segment 3 Geothermal gradient: 39.1 degC/km
Total Avoided Carbon Emissions: 5055.92 kilotonne
***ECONOMIC PARAMETERS***
Economic Model = SAM Single Owner PPA
Real Discount Rate: 12.00 %
Nominal Discount Rate: 15.02 %
WACC: 8.57 %
Investment Tax Credit: 85.14 MUSD
Project lifetime: 30 yr
Capacity factor: 90.0 %
Project NPV: 78.06 MUSD
After-tax IRR: 33.24 %
Project VIR=PI=PIR: 1.95
Project MOIC: 7.48
Project Payback Period: 3.92 yr
CHP: Percent cost allocation for electrical plant: 85.55 %
***ENGINEERING PARAMETERS***
Number of Production Wells: 6
Number of Injection Wells: 4
Well depth: 2.7 kilometer
Water loss rate: 1.0 %
Pump efficiency: 80.0 %
Injection temperature: 50.5 degC
Production Wellbore heat transmission calculated with Ramey's model
Average production well temperature drop: 0.3 degC
Flowrate per production well: 100.0 kg/sec
Injection well casing ID: 8.535 in
Production well casing ID: 8.535 in
Number of times redrilling: 3
Power plant type: Subcritical ORC
***RESOURCE CHARACTERISTICS***
Maximum reservoir temperature: 500.0 degC
Number of segments: 3
Segment 1 Geothermal gradient: 74 degC/km
Segment 1 Thickness: 2.5 kilometer
Segment 2 Geothermal gradient: 41 degC/km
Segment 2 Thickness: 0.5 kilometer
Segment 3 Geothermal gradient: 39.1 degC/km
***RESERVOIR PARAMETERS***
Reservoir Model = Multiple Parallel Fractures Model (Gringarten)
Bottom-hole temperature: 205.38 degC
Fracture model = Rectangular
Well separation: fracture height: 100.00 meter
Fracture width: 305.00 meter
Fracture area: 30500.00 m**2
Reservoir volume calculated with fracture separation and number of fractures as input
Number of fractures: 1500
Fracture separation: 9.83 meter
Reservoir volume: 449216947 m**3
Reservoir hydrostatic pressure: 25324.54 kPa
Plant outlet pressure: 13789.51 kPa
Production wellhead pressure: 2089.11 kPa
Productivity Index: 1.13 kg/sec/bar
Injectivity Index: 1.38 kg/sec/bar
Reservoir density: 2800.00 kg/m**3
Reservoir thermal conductivity: 3.05 W/m/K
Reservoir heat capacity: 790.00 J/kg/K
***RESERVOIR SIMULATION RESULTS***
Maximum Production Temperature: 203.1 degC
Average Production Temperature: 202.8 degC
Minimum Production Temperature: 201.3 degC
Initial Production Temperature: 201.6 degC
Average Reservoir Heat Extraction: 382.08 MW
Production Wellbore Heat Transmission Model = Ramey Model
Average Production Well Temperature Drop: 0.3 degC
Average Injection Well Pump Pressure Drop: -2003.9 kPa
Average Production Well Pump Pressure Drop: 9514.2 kPa
***CAPITAL COSTS (M$)***
Exploration costs: 4.71 MUSD
Drilling and completion costs: 46.49 MUSD
Drilling and completion costs per well: 4.65 MUSD
Stimulation costs: 48.30 MUSD
Stimulation costs per well: 4.83 MUSD
Surface power plant costs: 154.20 MUSD
of which Electrical Plant Cost: 131.92 MUSD
of which Heat Plant Cost: 22.28 MUSD
Field gathering system costs: 3.20 MUSD
Total surface equipment costs: 157.40 MUSD
Overnight Capital Cost: 256.90 MUSD
Inflation costs during construction: 16.45 MUSD
Interest during construction: 10.46 MUSD
Total CAPEX: 283.80 MUSD
***OPERATING AND MAINTENANCE COSTS (M$/yr)***
Wellfield maintenance costs: 1.12 MUSD/yr
Power plant maintenance costs: 4.17 MUSD/yr
Water costs: 0.16 MUSD/yr
Redrilling costs: 9.48 MUSD/yr
Total operating and maintenance costs: 14.92 MUSD/yr
***SURFACE EQUIPMENT SIMULATION RESULTS***
Initial geofluid availability: 0.19 MW/(kg/s)
Maximum Total Electricity Generation: 53.91 MW
Average Total Electricity Generation: 53.66 MW
Minimum Total Electricity Generation: 52.44 MW
Initial Total Electricity Generation: 52.69 MW
Maximum Net Electricity Generation: 45.77 MW
Average Net Electricity Generation: 45.52 MW
Minimum Net Electricity Generation: 44.27 MW
Initial Net Electricity Generation: 44.54 MW
Average Annual Total Electricity Generation: 423.07 GWh
Average Annual Net Electricity Generation: 358.89 GWh
Initial pumping power/net installed power: 18.30 %
Maximum Net Heat Production: 62.26 MW
Average Net Heat Production: 62.20 MW
Minimum Net Heat Production: 61.90 MW
Initial Net Heat Production: 61.96 MW
Average Annual Heat Production: 490.38 GWh
Average Pumping Power: 8.14 MW
Heat to Power Conversion Efficiency: 14.54 %
************************************************************
* HEATING, COOLING AND/OR ELECTRICITY PRODUCTION PROFILE *
************************************************************
YEAR THERMAL GEOFLUID PUMP NET NET FIRST LAW
DRAWDOWN TEMPERATURE POWER POWER HEAT EFFICIENCY
(deg C) (MW) (MW) (MW) (%)
0 1.0000 201.64 8.1512 44.5358 61.9595 14.3548
1 1.0052 202.70 8.1476 45.4006 62.1721 14.5209
2 1.0062 202.89 8.1469 45.5621 62.2116 14.5518
3 1.0067 202.99 8.1466 45.6463 62.2321 14.5679
4 1.0070 203.06 8.1464 45.7020 62.2457 14.5785
5 1.0073 203.11 8.1462 45.7427 62.2556 14.5863
6 1.0074 203.13 8.1463 45.7617 62.2603 14.5899
7 1.0066 202.97 8.1489 45.6249 62.2274 14.5635
8 1.0007 201.78 8.1656 44.6309 61.9867 14.3712
9 1.0048 202.61 8.1453 45.3285 62.1538 14.5075
10 1.0060 202.86 8.1444 45.5355 62.2044 14.5471
11 1.0066 202.97 8.1428 45.6327 62.2279 14.5658
12 1.0070 203.05 8.1408 45.6954 62.2427 14.5780
13 1.0072 203.10 8.1387 45.7412 62.2534 14.5870
14 1.0074 203.13 8.1370 45.7708 62.2602 14.5928
15 1.0070 203.06 8.1373 45.7058 62.2444 14.5804
16 1.0031 202.27 8.1479 45.0504 62.0860 14.4540
17 1.0041 202.47 8.1345 45.2256 62.1259 14.4892
18 1.0058 202.82 8.1344 45.5108 62.1959 14.5436
19 1.0065 202.95 8.1343 45.6217 62.2231 14.5648
20 1.0069 203.03 8.1343 45.6887 62.2395 14.5775
21 1.0072 203.09 8.1343 45.7358 62.2510 14.5865
22 1.0074 203.13 8.1344 45.7692 62.2592 14.5928
23 1.0072 203.10 8.1353 45.7465 62.2539 14.5884
24 1.0048 202.61 8.1426 45.3324 62.1541 14.5086
25 1.0027 202.20 8.1344 45.0033 62.0710 14.4467
26 1.0056 202.76 8.1344 45.4682 62.1855 14.5355
27 1.0063 202.92 8.1344 45.5997 62.2177 14.5606
28 1.0068 203.01 8.1344 45.6742 62.2360 14.5748
29 1.0071 203.08 8.1344 45.7252 62.2485 14.5845
*******************************************************************
* ANNUAL HEATING, COOLING AND/OR ELECTRICITY PRODUCTION PROFILE *
*******************************************************************
YEAR HEAT ELECTRICITY HEAT RESERVOIR PERCENTAGE OF
PROVIDED PROVIDED EXTRACTED HEAT CONTENT TOTAL HEAT MINED
(GWh/year) (GWh/year) (GWh/year) (10^15 J) (%)
1 489.6 355.7 3002.77 143.09 7.02
2 490.3 358.7 3011.81 132.25 14.07
3 490.6 359.6 3014.56 121.39 21.12
4 490.7 360.1 3016.19 110.54 28.18
5 490.8 360.5 3017.33 99.67 35.23
6 490.8 360.7 3018.10 88.81 42.29
7 490.8 360.5 3017.30 77.95 49.35
8 489.9 356.8 3006.30 67.12 56.38
9 489.2 353.9 2997.27 56.33 63.40
10 490.3 358.3 3010.72 45.49 70.44
11 490.5 359.4 3014.03 34.64 77.49
12 490.7 360.0 3015.84 23.79 84.54
13 490.8 360.5 3017.08 12.93 91.60
14 490.8 360.8 3017.96 2.06 98.66
15 490.8 360.7 3017.88 -8.80 105.72
16 490.3 358.5 3011.14 -19.64 112.76
17 489.0 353.1 2994.77 -30.42 119.77
18 490.1 357.9 3009.26 -41.26 126.81
19 490.5 359.3 3013.41 -52.11 133.86
20 490.6 360.0 3015.46 -62.96 140.91
21 490.7 360.4 3016.81 -73.82 147.97
22 490.8 360.7 3017.78 -84.69 155.03
23 490.9 360.8 3018.13 -95.55 162.09
24 490.5 359.5 3014.27 -106.40 169.14
25 489.0 353.3 2995.26 -117.19 176.14
26 490.0 357.2 3007.08 -128.01 183.18
27 490.4 359.1 3012.68 -138.86 190.23
28 490.6 359.8 3015.04 -149.71 197.28
29 490.7 360.3 3016.51 -160.57 204.33
30 490.8 360.6 3017.53 -171.43 211.39
***************************
* SAM CASH FLOW PROFILE *
***************************
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Year -2 Year -1 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 Year 17 Year 18 Year 19 Year 20 Year 21 Year 22 Year 23 Year 24 Year 25 Year 26 Year 27 Year 28 Year 29 Year 30
CONSTRUCTION
Capital expenditure schedule [construction] (%) 7.50 52.50 40.0
Overnight capital expenditure [construction] ($) -19,267,186 -134,870,303 -102,758,326
plus:
Inflation cost [construction] ($) -520,214 -7,381,317 -8,550,179
plus:
Royalty supplemental payments [construction] ($) 0 0 0
equals:
Nominal capital expenditure [construction] ($) -19,787,400 -142,251,620 -111,308,506
Issuance of equity [construction] ($) 19,787,400 42,675,486 33,392,552
Issuance of debt [construction] ($) 0 99,576,134 77,915,954
Debt balance [construction] ($) 0 99,576,134 187,947,582
Debt interest payment [construction] ($) 0 0 10,455,494
Installed cost [construction] ($) -19,787,400 -142,251,620 -121,764,000
After-tax net cash flow [construction] ($) -19,787,400 -42,675,486 -33,392,552
ENERGY
Electricity to grid (kWh) 0.0 355,731,851 358,699,992 359,607,495 360,144,710 360,520,252 360,775,349 360,502,913 356,836,528 353,926,807.0 358,359,695 359,455,496 360,066,943 360,488,977 360,794,715 360,775,190 358,530,827 353,165,503 357,965,313 359,325,916 360,000,341 360,441,906 360,760,853 360,874,419 359,580,200 353,308,448 357,253,043 359,087,573 359,860,409 360,344,429 360,678,540
Electricity from grid (kWh) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Electricity to grid net (kWh) 0.0 355,731,851 358,699,992 359,607,495 360,144,710 360,520,252 360,775,349 360,502,913 356,836,528 353,926,807.0 358,359,695 359,455,496 360,066,943 360,488,977 360,794,715 360,775,190 358,530,827 353,165,503 357,965,313 359,325,916 360,000,341 360,441,906 360,760,853 360,874,419 359,580,200 353,308,448 357,253,043 359,087,573 359,860,409 360,344,429 360,678,540
Saved Carbon Production (pound) 0 368,490,024 371,328,485 372,196,274 372,709,969 373,069,066 373,312,995 373,052,598 369,547,379 366,763,822 371,002,734 372,050,498 372,634,972 373,038,268 373,330,374 373,311,576 371,165,843 366,034,776 370,624,148 371,925,317 372,570,265 372,992,526 373,297,529 373,406,170 372,168,955 366,171,800 369,942,951 371,697,395 372,436,462 372,899,325 373,218,828
Heat provided (kWh) 0 489,614,562 490,342,076 490,563,599 490,694,580 490,786,078 490,848,296 490,783,461 489,898,726 489,171,820 490,254,084 490,520,388 490,666,584 490,765,776 490,836,812 490,830,234 490,288,258 488,970,947 490,137,018 490,470,680 490,635,823 490,743,886 490,821,935 490,850,303 490,539,597 489,010,601 489,961,766 490,412,356 490,601,741 490,720,237 490,801,992
REVENUE
PPA price (cents/kWh) 0.0 9.50 9.50 9.56 9.61 9.67 9.73 9.79 9.84 9.90 9.96 10.01 10.07 10.13 10.18 10.24 10.30 10.36 10.41 10.47 10.53 10.58 10.64 10.70 10.75 10.81 10.87 10.93 10.98 11.04 11.10
PPA revenue ($) 0 33,794,526 34,076,499 34,367,688 34,624,312 34,865,914 35,096,226 35,275,210 35,119,851 35,035,215 35,678,291 35,992,279 36,258,741 36,506,719 36,743,334 36,946,987 36,921,505 36,570,288 37,271,348 37,617,830 37,893,636 38,145,567 38,384,955 38,602,737 38,669,255 38,196,176 38,826,261 39,230,317 39,519,870 39,778,422 40,020,891
Curtailment payment revenue ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Carbon price ($/lb) 0.0 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02
Carbon credits revenue ($) 0 8,357,213 8,421,588 8,441,270 8,452,920 8,461,064 8,466,596 8,460,691 8,381,194 8,318,064 8,414,200 8,437,963 8,451,219 8,460,366 8,466,990 8,466,564 8,417,900 8,301,529 8,405,614 8,435,124 8,449,751 8,459,328 8,466,246 8,468,709 8,440,650 8,304,637 8,390,165 8,429,955 8,446,717 8,457,214 8,464,461
plus:
Heat price ($/kWh) 0.0 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03
Heat revenue ($) 0 12,240,364 12,258,552 12,264,090 12,267,364 12,269,652 12,271,207 12,269,587 12,247,468 12,229,296 12,256,352 12,263,010 12,266,665 12,269,144 12,270,920 12,270,756 12,257,206 12,224,274 12,253,425 12,261,767 12,265,896 12,268,597 12,270,548 12,271,258 12,263,490 12,225,265 12,249,044 12,260,309 12,265,044 12,268,006 12,270,050
equals:
Capacity payment revenue ($) 0 20,597,577 20,680,140 20,705,360 20,720,284 20,730,716 20,737,803 20,730,278 20,628,662 20,547,360 20,670,552 20,700,973 20,717,884 20,729,510 20,737,910 20,737,320 20,675,106 20,525,803 20,659,039 20,696,891 20,715,647 20,727,925 20,736,794 20,739,967 20,704,140 20,529,902 20,639,209 20,690,264 20,711,761 20,725,220 20,734,511
Salvage value ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 141,901,510
Total revenue ($) 0 54,392,103 54,756,639 55,073,048 55,344,596 55,596,630 55,834,029 56,005,488 55,748,513 55,582,575 56,348,843 56,693,252 56,976,625 57,236,229 57,481,244 57,684,307 57,596,611 57,096,091 57,930,387 58,314,721 58,609,283 58,873,492 59,121,749 59,342,704 59,373,395 58,726,078 59,465,470 59,920,581 60,231,631 60,503,642 202,656,912
Property tax net assessed value ($) 0 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020 283,803,020
OPERATING EXPENSES
O&M fixed expense ($) 0 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440 14,922,440
O&M production-based expense ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O&M capacity-based expense ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fuel expense ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Electricity purchase ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Property tax expense ($) 0 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367 624,367
Insurance expense ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total operating expenses ($) 0 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806 15,546,806
EBITDA ($) 0 38,845,297 39,209,833 39,526,242 39,797,790 40,049,823 40,287,223 40,458,682 40,201,707 40,035,768 40,802,037 41,146,446 41,429,819 41,689,422 41,934,437 42,137,501 42,049,804 41,549,284 42,383,581 42,767,915 43,062,477 43,326,686 43,574,942 43,795,897 43,826,588 43,179,272 43,918,663 44,373,775 44,684,825 44,956,835 187,110,106
OPERATING ACTIVITIES
EBITDA ($) 0 38,845,297 39,209,833 39,526,242 39,797,790 40,049,823 40,287,223 40,458,682 40,201,707 40,035,768 40,802,037 41,146,446 41,429,819 41,689,422 41,934,437 42,137,501 42,049,804 41,549,284 42,383,581 42,767,915 43,062,477 43,326,686 43,574,942 43,795,897 43,826,588 43,179,272 43,918,663 44,373,775 44,684,825 44,956,835 187,110,106
Interest earned on reserves ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
plus PBI if not available for debt service:
Federal PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Utility PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Other PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Debt interest payment ($) 0 13,156,331 13,017,053 12,868,025 12,708,565 12,537,943 12,355,378 12,160,033 11,951,014 11,727,364 11,488,058 11,232,000 10,958,019 10,664,859 10,351,178 10,015,539 9,656,405 9,272,132 8,860,960 8,421,006 7,950,255 7,446,551 6,907,589 6,330,898 5,713,840 5,053,587 4,347,117 3,591,194 2,782,356 1,916,900 990,861
Cash flow from operating activities ($) 0 25,688,966 26,192,780 26,658,217 27,089,225 27,511,880 27,931,845 28,298,649 28,250,693 28,308,405 29,313,979 29,914,445 30,471,800 31,024,563 31,583,260 32,121,962 32,393,399 32,277,152 33,522,621 34,346,909 35,112,222 35,880,134 36,667,354 37,464,999 38,112,749 38,125,685 39,571,546 40,782,581 41,902,469 43,039,936 186,119,245
INVESTING ACTIVITIES
Total installed cost ($) -283,803,020
Debt closing costs ($) 0
Debt up-front fee ($) 0
minus:
Total IBI income ($) 0
Total CBI income ($) 0
equals:
Purchase of property ($) -283,803,020
plus:
Reserve (increase)/decrease debt service ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserve (increase)/decrease working capital ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserve (increase)/decrease receivables ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserve (increase)/decrease major equipment 1 ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserve (increase)/decrease major equipment 2 ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserve (increase)/decrease major equipment 3 ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserve capital spending major equipment 1 ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserve capital spending major equipment 2 ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserve capital spending major equipment 3 ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
equals:
Cash flow from investing activities ($) -283,803,020 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FINANCING ACTIVITIES
Issuance of equity ($) 95,855,438
Size of debt ($) 187,947,582
minus:
Debt principal payment ($) 0 1,989,689 2,128,967 2,277,995 2,437,455 2,608,076 2,790,642 2,985,987 3,195,006 3,418,656 3,657,962 3,914,019 4,188,001 4,481,161 4,794,842 5,130,481 5,489,615 5,873,888 6,285,060 6,725,014 7,195,765 7,699,468 8,238,431 8,815,121 9,432,180 10,092,432 10,798,903 11,554,826 12,363,664 13,229,120 14,155,159
equals:
Cash flow from financing activities ($) 283,803,020 -1,989,689 -2,128,967 -2,277,995 -2,437,455 -2,608,076 -2,790,642 -2,985,987 -3,195,006 -3,418,656 -3,657,962 -3,914,019 -4,188,001 -4,481,161 -4,794,842 -5,130,481 -5,489,615 -5,873,888 -6,285,060 -6,725,014 -7,195,765 -7,699,468 -8,238,431 -8,815,121 -9,432,180 -10,092,432 -10,798,903 -11,554,826 -12,363,664 -13,229,120 -14,155,159
PROJECT RETURNS
Pre-tax Cash Flow:
Cash flow from operating activities ($) 0 25,688,966 26,192,780 26,658,217 27,089,225 27,511,880 27,931,845 28,298,649 28,250,693 28,308,405 29,313,979 29,914,445 30,471,800 31,024,563 31,583,260 32,121,962 32,393,399 32,277,152 33,522,621 34,346,909 35,112,222 35,880,134 36,667,354 37,464,999 38,112,749 38,125,685 39,571,546 40,782,581 41,902,469 43,039,936 186,119,245
Cash flow from investing activities ($) -283,803,020 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cash flow from financing activities ($) 283,803,020 -1,989,689 -2,128,967 -2,277,995 -2,437,455 -2,608,076 -2,790,642 -2,985,987 -3,195,006 -3,418,656 -3,657,962 -3,914,019 -4,188,001 -4,481,161 -4,794,842 -5,130,481 -5,489,615 -5,873,888 -6,285,060 -6,725,014 -7,195,765 -7,699,468 -8,238,431 -8,815,121 -9,432,180 -10,092,432 -10,798,903 -11,554,826 -12,363,664 -13,229,120 -14,155,159
Total pre-tax cash flow ($) 0 23,699,277 24,063,813 24,380,222 24,651,770 24,903,804 25,141,203 25,312,662 25,055,687 24,889,749 25,656,017 26,000,426 26,283,799 26,543,403 26,788,418 26,991,481 26,903,785 26,403,265 27,237,561 27,621,895 27,916,457 28,180,666 28,428,923 28,649,878 28,680,569 28,033,252 28,772,644 29,227,755 29,538,805 29,810,815 171,964,086
Pre-tax Returns:
Issuance of equity ($) 95,855,438
Total pre-tax cash flow ($) 0 23,699,277 24,063,813 24,380,222 24,651,770 24,903,804 25,141,203 25,312,662 25,055,687 24,889,749 25,656,017 26,000,426 26,283,799 26,543,403 26,788,418 26,991,481 26,903,785 26,403,265 27,237,561 27,621,895 27,916,457 28,180,666 28,428,923 28,649,878 28,680,569 28,033,252 28,772,644 29,227,755 29,538,805 29,810,815 171,964,086
Total pre-tax returns ($) -95,855,438 23,699,277 24,063,813 24,380,222 24,651,770 24,903,804 25,141,203 25,312,662 25,055,687 24,889,749 25,656,017 26,000,426 26,283,799 26,543,403 26,788,418 26,991,481 26,903,785 26,403,265 27,237,561 27,621,895 27,916,457 28,180,666 28,428,923 28,649,878 28,680,569 28,033,252 28,772,644 29,227,755 29,538,805 29,810,815 171,964,086
After-tax Returns:
Total pre-tax returns ($) -95,855,438 23,699,277 24,063,813 24,380,222 24,651,770 24,903,804 25,141,203 25,312,662 25,055,687 24,889,749 25,656,017 26,000,426 26,283,799 26,543,403 26,788,418 26,991,481 26,903,785 26,403,265 27,237,561 27,621,895 27,916,457 28,180,666 28,428,923 28,649,878 28,680,569 28,033,252 28,772,644 29,227,755 29,538,805 29,810,815 171,964,086
Federal ITC total income ($) 0 85,140,906 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Federal PTC income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Federal tax benefit (liability) ($) 0 -3,940,378 -2,832,519 -2,925,813 -3,012,207 -3,096,926 -3,181,105 -3,254,630 -3,245,017 -3,256,585 -3,458,147 -3,578,508 -3,690,227 -3,801,026 -3,913,013 -4,020,994 -4,075,402 -4,052,101 -4,301,749 -4,466,973 -4,620,376 -5,983,147 -7,349,788 -7,509,672 -7,639,510 -7,642,103 -7,931,919 -8,174,664 -8,399,140 -8,627,140 -37,306,672
State ITC total income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State PTC income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State tax benefit (liability) ($) 0 -894,446 -642,967 -664,145 -683,756 -702,986 -722,095 -738,784 -736,602 -739,228 -784,982 -812,303 -837,663 -862,814 -888,234 -912,745 -925,096 -919,806 -976,475 -1,013,980 -1,048,802 -1,358,144 -1,668,365 -1,704,657 -1,734,130 -1,734,719 -1,800,505 -1,855,607 -1,906,562 -1,958,317 -8,468,426
Total after-tax returns ($) -95,855,438 104,005,359 20,588,327 20,790,264 20,955,808 21,103,891 21,238,003 21,319,248 21,074,068 20,893,935 21,412,888 21,609,615 21,755,909 21,879,564 21,987,170 22,057,742 21,903,287 21,431,358 21,959,337 22,140,942 22,247,279 20,839,375 19,410,770 19,435,548 19,306,929 18,656,431 19,040,220 19,197,483 19,233,102 19,225,358 126,188,988
After-tax net cash flow ($) -19,787,400 -42,675,486 -33,392,552 104,005,359 20,588,327 20,790,264 20,955,808 21,103,891 21,238,003 21,319,248 21,074,068 20,893,935 21,412,888 21,609,615 21,755,909 21,879,564 21,987,170 22,057,742 21,903,287 21,431,358 21,959,337 22,140,942 22,247,279 20,839,375 19,410,770 19,435,548 19,306,929 18,656,431 19,040,220 19,197,483 19,233,102 19,225,358 126,188,988
After-tax cumulative IRR (%) NaN NaN NaN 4.46 13.65 19.96 24.13 26.90 28.77 30.06 30.94 31.56 32.01 32.33 32.57 32.75 32.88 32.97 33.04 33.09 33.13 33.16 33.18 33.20 33.21 33.22 33.22 33.23 33.23 33.23 33.24 33.24 33.25
After-tax cumulative NPV ($) -19,787,400 -56,888,775 -82,127,806 -13,785,392 -2,023,771 8,301,886 17,350,324 25,272,478 32,203,638 38,252,528 43,450,857 47,931,569 51,923,782 55,426,434 58,492,198 61,172,672 63,514,494 65,556,971 67,320,233 68,820,155 70,156,289 71,327,509 72,350,638 73,183,840 73,858,553 74,445,887 74,953,127 75,379,255 75,757,344 76,088,765 76,377,430 76,628,291 78,059,788
AFTER-TAX LCOE AND PPA PRICE
Annual costs ($) -19,787,400 -42,675,486 -33,392,552 49,613,256 -34,168,312 -34,282,784 -34,388,788 -34,492,738 -34,596,026 -34,686,240 -34,674,445 -34,688,639 -34,935,955 -35,083,637 -35,220,716 -35,356,665 -35,494,074 -35,626,565 -35,693,323 -35,664,733 -35,971,050 -36,173,779 -36,362,004 -38,034,117 -39,710,978 -39,907,155 -40,066,466 -40,069,648 -40,425,250 -40,723,098 -40,998,529 -41,278,283 65,433,587
PPA revenue ($) 0 0 0 33,794,526 34,076,499 34,367,688 34,624,312 34,865,914 35,096,226 35,275,210 35,119,851 35,035,215 35,678,291 35,992,279 36,258,741 36,506,719 36,743,334 36,946,987 36,921,505 36,570,288 37,271,348 37,617,830 37,893,636 38,145,567 38,384,955 38,602,737 38,669,255 38,196,176 38,826,261 39,230,317 39,519,870 39,778,422 40,020,891
Electricity to grid (kWh) 0 0 0 355,731,851 358,699,992 359,607,495 360,144,710 360,520,252 360,775,349 360,502,913 356,836,528 353,926,807 358,359,695 359,455,496 360,066,943 360,488,977 360,794,715 360,775,190 358,530,827 353,165,503 357,965,313 359,325,916 360,000,341 360,441,906 360,760,853 360,874,419 359,580,200 353,308,448 357,253,043 359,087,573 359,860,409 360,344,429 360,678,540
Present value of annual costs ($) 198,704,506
Present value of annual energy costs ($) 170,000,152
Present value of annual energy nominal (kWh) 1,777,658,214
LCOE Levelized cost of energy nominal (cents/kWh) 9.56
Present value of PPA revenue ($) 174,283,198
Present value of annual energy nominal (kWh) 1,777,658,214
LPPA Levelized PPA price nominal (cents/kWh) 9.80
Present value of annual heat costs ($) 28,704,354
Present value of annual heat provided (MMBTU) 8,290,884
LCOH Levelized cost of heating nominal ($/MMBTU) 3.46
PROJECT STATE INCOME TAXES
EBITDA ($) 0 38,845,297 39,209,833 39,526,242 39,797,790 40,049,823 40,287,223 40,458,682 40,201,707 40,035,768 40,802,037 41,146,446 41,429,819 41,689,422 41,934,437 42,137,501 42,049,804 41,549,284 42,383,581 42,767,915 43,062,477 43,326,686 43,574,942 43,795,897 43,826,588 43,179,272 43,918,663 44,373,775 44,684,825 44,956,835 187,110,106
State taxable PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Interest earned on reserves ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State taxable IBI income ($) 0
State taxable CBI income ($) 0
minus:
Debt interest payment ($) 0 13,156,331 13,017,053 12,868,025 12,708,565 12,537,943 12,355,378 12,160,033 11,951,014 11,727,364 11,488,058 11,232,000 10,958,019 10,664,859 10,351,178 10,015,539 9,656,405 9,272,132 8,860,960 8,421,006 7,950,255 7,446,551 6,907,589 6,330,898 5,713,840 5,053,587 4,347,117 3,591,194 2,782,356 1,916,900 990,861
Total state tax depreciation ($) 0 6,030,814 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 6,030,814 0 0 0 0 0 0 0 0 0
equals:
State taxable income ($) 0 19,658,152 14,131,152 14,596,589 15,027,596 15,450,252 15,870,216 16,237,020 16,189,064 16,246,776 17,252,351 17,852,817 18,410,171 18,962,935 19,521,631 20,060,334 20,331,771 20,215,524 21,460,993 22,285,281 23,050,593 29,849,320 36,667,354 37,464,999 38,112,749 38,125,685 39,571,546 40,782,581 41,902,469 43,039,936 186,119,245
State income tax rate (frac) 0.0 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05
State tax benefit (liability) ($) 0 -894,446 -642,967 -664,145 -683,756 -702,986 -722,095 -738,784 -736,602 -739,228 -784,982 -812,303 -837,663 -862,814 -888,234 -912,745 -925,096 -919,806 -976,475 -1,013,980 -1,048,802 -1,358,144 -1,668,365 -1,704,657 -1,734,130 -1,734,719 -1,800,505 -1,855,607 -1,906,562 -1,958,317 -8,468,426
PROJECT FEDERAL INCOME TAXES
EBITDA ($) 0 38,845,297 39,209,833 39,526,242 39,797,790 40,049,823 40,287,223 40,458,682 40,201,707 40,035,768 40,802,037 41,146,446 41,429,819 41,689,422 41,934,437 42,137,501 42,049,804 41,549,284 42,383,581 42,767,915 43,062,477 43,326,686 43,574,942 43,795,897 43,826,588 43,179,272 43,918,663 44,373,775 44,684,825 44,956,835 187,110,106
Interest earned on reserves ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State tax benefit (liability) ($) 0 -894,446 -642,967 -664,145 -683,756 -702,986 -722,095 -738,784 -736,602 -739,228 -784,982 -812,303 -837,663 -862,814 -888,234 -912,745 -925,096 -919,806 -976,475 -1,013,980 -1,048,802 -1,358,144 -1,668,365 -1,704,657 -1,734,130 -1,734,719 -1,800,505 -1,855,607 -1,906,562 -1,958,317 -8,468,426
State ITC total income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State PTC income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Federal taxable IBI income ($) 0
Federal taxable CBI income ($) 0
Federal taxable PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
minus:
Debt interest payment ($) 0 13,156,331 13,017,053 12,868,025 12,708,565 12,537,943 12,355,378 12,160,033 11,951,014 11,727,364 11,488,058 11,232,000 10,958,019 10,664,859 10,351,178 10,015,539 9,656,405 9,272,132 8,860,960 8,421,006 7,950,255 7,446,551 6,907,589 6,330,898 5,713,840 5,053,587 4,347,117 3,591,194 2,782,356 1,916,900 990,861
Total federal tax depreciation ($) 0 6,030,814 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 12,061,628 6,030,814 0 0 0 0 0 0 0 0 0
equals:
Federal taxable income ($) 0 18,763,706 13,488,185 13,932,444 14,343,841 14,747,265 15,148,121 15,498,236 15,452,462 15,507,548 16,467,369 17,040,514 17,572,509 18,100,121 18,633,397 19,147,589 19,406,675 19,295,718 20,484,518 21,271,300 22,001,791 28,491,176 34,998,989 35,760,341 36,378,618 36,390,966 37,771,041 38,926,974 39,995,907 41,081,619 177,650,819
Federal income tax rate (frac) 0.0 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21 0.21
Federal tax benefit (liability) ($) 0 -3,940,378 -2,832,519 -2,925,813 -3,012,207 -3,096,926 -3,181,105 -3,254,630 -3,245,017 -3,256,585 -3,458,147 -3,578,508 -3,690,227 -3,801,026 -3,913,013 -4,020,994 -4,075,402 -4,052,101 -4,301,749 -4,466,973 -4,620,376 -5,983,147 -7,349,788 -7,509,672 -7,639,510 -7,642,103 -7,931,919 -8,174,664 -8,399,140 -8,627,140 -37,306,672
CASH INCENTIVES
Federal IBI income ($) 0
State IBI income ($) 0
Utility IBI income ($) 0
Other IBI income ($) 0
Total IBI income ($) 0
Federal CBI income ($) 0
State CBI income ($) 0
Utility CBI income ($) 0
Other CBI income ($) 0
Total CBI income ($) 0
Federal PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Utility PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Other PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total PBI income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TAX CREDITS
Federal PTC income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State PTC income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Federal ITC amount income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Federal ITC percent income ($) 0 85,140,906 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Federal ITC total income ($) 0 85,140,906 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State ITC amount income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State ITC percent income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
State ITC total income ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DEBT REPAYMENT
Debt balance ($) 187,947,582 185,957,893 183,828,926 181,550,931 179,113,477 176,505,401 173,714,759 170,728,772 167,533,767 164,115,111 160,457,149 156,543,129 152,355,129 147,873,968 143,079,126 137,948,645 132,459,030 126,585,143 120,300,083 113,575,069 106,379,304 98,679,836 90,441,405 81,626,284 72,194,104 62,101,671 51,302,768 39,747,943 27,384,279 14,155,159 0
Debt interest payment ($) 0 13,156,331 13,017,053 12,868,025 12,708,565 12,537,943 12,355,378 12,160,033 11,951,014 11,727,364 11,488,058 11,232,000 10,958,019 10,664,859 10,351,178 10,015,539 9,656,405 9,272,132 8,860,960 8,421,006 7,950,255 7,446,551 6,907,589 6,330,898 5,713,840 5,053,587 4,347,117 3,591,194 2,782,356 1,916,900 990,861
Debt principal payment ($) 0 1,989,689 2,128,967 2,277,995 2,437,455 2,608,076 2,790,642 2,985,987 3,195,006 3,418,656 3,657,962 3,914,019 4,188,001 4,481,161 4,794,842 5,130,481 5,489,615 5,873,888 6,285,060 6,725,014 7,195,765 7,699,468 8,238,431 8,815,121 9,432,180 10,092,432 10,798,903 11,554,826 12,363,664 13,229,120 14,155,159
Debt total payment ($) 0 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020
DSCR (DEBT FRACTION)
EBITDA ($) 0 38,845,297 39,209,833 39,526,242 39,797,790 40,049,823 40,287,223 40,458,682 40,201,707 40,035,768 40,802,037 41,146,446 41,429,819 41,689,422 41,934,437 42,137,501 42,049,804 41,549,284 42,383,581 42,767,915 43,062,477 43,326,686 43,574,942 43,795,897 43,826,588 43,179,272 43,918,663 44,373,775 44,684,825 44,956,835 187,110,106
minus:
Reserves major equipment 1 funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 2 funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 3 funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves receivables funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
equals:
Cash available for debt service (CAFDS) ($) 0 38,845,297 39,209,833 39,526,242 39,797,790 40,049,823 40,287,223 40,458,682 40,201,707 40,035,768 40,802,037 41,146,446 41,429,819 41,689,422 41,934,437 42,137,501 42,049,804 41,549,284 42,383,581 42,767,915 43,062,477 43,326,686 43,574,942 43,795,897 43,826,588 43,179,272 43,918,663 44,373,775 44,684,825 44,956,835 187,110,106
Debt total payment ($) 0 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020 15,146,020
DSCR (pre-tax) 0.0 2.56 2.59 2.61 2.63 2.64 2.66 2.67 2.65 2.64 2.69 2.72 2.74 2.75 2.77 2.78 2.78 2.74 2.80 2.82 2.84 2.86 2.88 2.89 2.89 2.85 2.90 2.93 2.95 2.97 12.35
RESERVES
Reserves working capital funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves working capital disbursement ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves working capital balance ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves debt service funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves debt service disbursement ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves debt service balance ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves receivables funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves receivables disbursement ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves receivables balance ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 1 funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 1 disbursement ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 1 balance ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 2 funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 2 disbursement ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 2 balance ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 3 funding ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 3 disbursement ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves major equipment 3 balance ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Reserves total reserves balance ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Interest on reserves (%/year) 1.75
Interest earned on reserves ($) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------