Spreadsheet: 806721d1669514069-auto-calc-doesnt-work-f2-individually-only-does-cannot-figure-out-why-joe-example
Sheet: Distributions

Non-Confi Version
Distributions
CONFIDENTIAL - FOR INTERNAL USE ONLY
Distributions worksheet
 |  |  |  |  | 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
 |  | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | 2026-01-31 00:00:00 | 2026-02-28 00:00:00 | 2026-03-31 00:00:00 | 2026-04-30 00:00:00 | 2026-05-31 00:00:00 | 2026-06-30 00:00:00 | 2026-07-31 00:00:00 | 2026-08-31 00:00:00 | 2026-09-30 00:00:00 | 2026-10-31 00:00:00 | 2026-11-30 00:00:00 | 2026-12-31 00:00:00 | 2027-01-31 00:00:00 | 2027-02-28 00:00:00 | 2027-03-31 00:00:00 | 2027-04-30 00:00:00 | 2027-05-31 00:00:00 | 2027-06-30 00:00:00 | 2027-07-31 00:00:00 | 2027-08-31 00:00:00 | 2027-09-30 00:00:00 | 2027-10-31 00:00:00 | 2027-11-30 00:00:00 | 2027-12-31 00:00:00 | 2028-01-31 00:00:00 | 2028-02-29 00:00:00 | 2028-03-31 00:00:00 | 2028-04-30 00:00:00 | 2028-05-31 00:00:00 | 2028-06-30 00:00:00
 | Payout calculations
 | Tier 1 amount to payout
 | Distribution hurdle % | 0
 | Prior balance | 68089031.70914859 |  | 68089031.70914859 | 68089031.70914859 | 104331837.1491274 | 110337634.8496738 | 116343487.4902886 | 122379580.7987116 | 128415729.0472031 | 134451932.2357631 | 140857324.2171314 | 147262771.1385681 | 153696733.7278131 | 160143286.2571265 | 166589893.7265084 | 173036552.5914383 | 180446391.3964367 | 187281283.3692433 | 194121314.7196184 | 200961399.2378017 | 207801538.6960535 | 214641733.0943738 | 222177615.6605023 | 229426053.1666993 | 236674543.8407045 | 243923089.4547782 | 251173381.7681704 | 258423723.7048503 | 265674120.5815987 | 272924570.6261553 | 280175075.6107804 | 287425633.7632136 | 295052470.739644 | 296436033.5756181 | 294177748.4556293 | 293202612.5174533 | 292252029.3955036 | 291326233.770623 | 290408072.9260456 | 289491068.7644649 | 288575192.6391525 | 287660439.534146 | 286746807.4489399 | 285834291.2761858 | 284922888.9375235 | 284369861.7491831 | 283819576.9820839 | 283270394.9744155 | 282722310.4204125 | 282175321.0417704 | 281635922.8372982 | 281097637.2351791 | 280560435.1105205 | 280024310.9655151 | 279489262.3141045 | 278955283.5596518 | 278422372.1307455 | 277890523.8858362 | 277359733.0917155 | 276829997.0464696 | 276301309.9359499 | 275773668.9695646 | 275253569.6299028 | 274734534.3660619 | 274216531.9949437 | 273699556.483484 | 273183604.8133807
 | EBITDA |  |  | 0 | -22492535.57390742 | -126652.8344748859 | -126707.774543379 | -156948.4423515982 | -157003.3824200913 | -157058.3224885845 | -526247.1152968036 | -526302.0553652968 | -554817.723173516 | -567407.6632420091 | -567462.6033105023 | -567513.9988584475 | -1530693.938926941 | -955747.1067351599 | -960886.484303653 | -960939.6521118721 | -960994.5921803652 | -961049.5322488584 | -1656737.700057078 | -1369292.640125571 | -1369345.80793379 | -1369400.748002283 | -1371147.447320777 | -1371197.070608448 | -1371252.010676941 | -1371305.17848516 | -1371360.118553653 | -1371413.286361872 | -6535211.976430366 | -1371523.166498858 | 2264571.267835331 | 2262703.232246517 | 2260834.689959276 | 2258962.556478057 | 2250588.525592391 | 2248716.908280994 | 2246838.610656971 | 2244959.794789731 | 2243077.376170735 | 2241194.434672403 | 2239307.885780982 | 2237419.268267776 | 2235530.120901478 | 2233637.359160489 | 2231744.062904151 | 2229847.14760562 | 2221448.307023097 | 2219551.852103935 | 2217648.688929838 | 2215744.97953878 | 2213837.639390752 | 2211929.748326668 | 2210018.221801232 | 2208104.598554173 | 2206190.417322573 | 2204272.593553182 | 2202354.207073661 | 2200432.173325446 | 2192008.186034983 | 2190085.015021943 | 2188156.648527986 | 2186227.707463334 | 2184295.10725608 | 2182361.927715201
 | Interest paid |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12039.66947530584 | 6286.147846453101 | 1287567.294070546 | 1310251.568009614 | 1333166.931597413 | 1332427.681015019 | 1331712.746700305 | 1330962.485344584 | 1330206.689783218 | 1329445.290964679 | 1328678.261918327 | 1327905.547118651 | 1327127.118989907 | 1327980.392864694 | 1327190.390554595 | 1326394.547963763 | 1325592.80802597 | 1324785.141613451 | 1324001.289047361 | 1323181.603333799 | 1322355.873595883 | 1321524.02704262 | 1320686.032936482 | 1319841.831957442 | 1318991.392707416 | 1318134.662264333 | 1317271.587369759 | 1316402.135616499 | 1315526.246002615 | 1314643.885435776 | 1313784.790243493 | 1312889.316472289 | 1311987.235066135 | 1311078.476215245 | 1310163.005069999
 | Capital expenditures |  |  | 0 | 13750269.86607143 | 5879144.866071431 | 5879144.866071429 | 5879144.866071429 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071418 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 1091625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375
 | Project payout balance |  | 68089031.70914859 | 68089031.70914859 | 104331837.1491274 | 110337634.8496738 | 116343487.4902886 | 122379580.7987116 | 128415729.0472031 | 134451932.2357631 | 140857324.2171314 | 147262771.1385681 | 153696733.7278131 | 160143286.2571265 | 166589893.7265084 | 173036552.5914383 | 180446391.3964367 | 187281283.3692433 | 194121314.7196184 | 200961399.2378017 | 207801538.6960535 | 214641733.0943738 | 222177615.6605023 | 229426053.1666993 | 236674543.8407045 | 243923089.4547782 | 251173381.7681704 | 258423723.7048503 | 265674120.5815987 | 272924570.6261553 | 280175075.6107804 | 287425633.7632136 | 295052470.739644 | 296436033.5756181 | 294177748.4556293 | 293202612.5174533 | 292252029.3955036 | 291326233.770623 | 290408072.9260456 | 289491068.7644649 | 288575192.6391525 | 287660439.534146 | 286746807.4489399 | 285834291.2761858 | 284922888.9375235 | 284369861.7491831 | 283819576.9820839 | 283270394.9744155 | 282722310.4204125 | 282175321.0417704 | 281635922.8372982 | 281097637.2351791 | 280560435.1105205 | 280024310.9655151 | 279489262.3141045 | 278955283.5596518 | 278422372.1307455 | 277890523.8858362 | 277359733.0917155 | 276829997.0464696 | 276301309.9359499 | 275773668.9695646 | 275253569.6299028 | 274734534.3660619 | 274216531.9949437 | 273699556.483484 | 273183604.8133807 | 272668670.851673
 | [NAME] amount to payout
 | Distribution hurdle % | 0
 |  | 0.08
 | Prior balance | 0 |  | 0 | 0 | 36242805.43997885 | 42248603.14052517 | 48254455.78113998 | 54290549.08956301 | 60326697.33805454 | 66362900.52661455 | 72768292.50798279 | 79173739.42941952 | 85607702.01866446 | 92054254.54797791 | 98500862.01735984 | 104947520.8822897 | 112357359.6872881 | 119192251.6600947 | 126032283.0104698 | 132872367.5286531 | 139712506.9869049 | 146552701.3852251 | 154088583.9513537 | 161337021.4575507 | 168585512.1315559 | 175834057.7456296 | 183084350.0590218 | 190334691.9957017 | 197585088.8724501 | 204835538.9170067 | 212086043.9016317 | 219336602.054065 | 226963439.0304954 | 228347001.8664696 | 226088716.7464807 | 225113580.8083048 | 224162997.6863551 | 223237202.0614744 | 222319041.2168971 | 221402037.0553164 | 220486160.930004 | 219571407.8249975 | 218657775.7397915 | 217745259.5670374 | 216833857.228375 | 216280830.0400347 | 215730545.2729354 | 215181363.265267 | 214633278.7112642 | 214086289.332622 | 213546891.1281498 | 213008605.5260307 | 212471403.4013722 | 211935279.2563668 | 211400230.6049562 | 210866251.8505035 | 210333340.4215972 | 209801492.176688 | 209270701.3825673 | 208740965.3373213 | 208212278.2268017 | 207684637.2604164 | 207164537.9207547 | 206645502.6569137 | 206127500.2857955 | 205610524.7743359 | 205094573.1042325
 | EBITDA |  |  | 0 | -22492535.57390742 | -126652.8344748859 | -126707.774543379 | -156948.4423515982 | -157003.3824200913 | -157058.3224885845 | -526247.1152968036 | -526302.0553652968 | -554817.723173516 | -567407.6632420091 | -567462.6033105023 | -567513.9988584475 | -1530693.938926941 | -955747.1067351599 | -960886.484303653 | -960939.6521118721 | -960994.5921803652 | -961049.5322488584 | -1656737.700057078 | -1369292.640125571 | -1369345.80793379 | -1369400.748002283 | -1371147.447320777 | -1371197.070608448 | -1371252.010676941 | -1371305.17848516 | -1371360.118553653 | -1371413.286361872 | -6535211.976430366 | -1371523.166498858 | 2264571.267835331 | 2262703.232246517 | 2260834.689959276 | 2258962.556478057 | 2250588.525592391 | 2248716.908280994 | 2246838.610656971 | 2244959.794789731 | 2243077.376170735 | 2241194.434672403 | 2239307.885780982 | 2237419.268267776 | 2235530.120901478 | 2233637.359160489 | 2231744.062904151 | 2229847.14760562 | 2221448.307023097 | 2219551.852103935 | 2217648.688929838 | 2215744.97953878 | 2213837.639390752 | 2211929.748326668 | 2210018.221801232 | 2208104.598554173 | 2206190.417322573 | 2204272.593553182 | 2202354.207073661 | 2200432.173325446 | 2192008.186034983 | 2190085.015021943 | 2188156.648527986 | 2186227.707463334 | 2184295.10725608 | 2182361.927715201
 | Interest paid |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12039.66947530584 | 6286.147846453101 | 1287567.294070546 | 1310251.568009614 | 1333166.931597413 | 1332427.681015019 | 1331712.746700305 | 1330962.485344584 | 1330206.689783218 | 1329445.290964679 | 1328678.261918327 | 1327905.547118651 | 1327127.118989907 | 1327980.392864694 | 1327190.390554595 | 1326394.547963763 | 1325592.80802597 | 1324785.141613451 | 1324001.289047361 | 1323181.603333799 | 1322355.873595883 | 1321524.02704262 | 1320686.032936482 | 1319841.831957442 | 1318991.392707416 | 1318134.662264333 | 1317271.587369759 | 1316402.135616499 | 1315526.246002615 | 1314643.885435776 | 1313784.790243493 | 1312889.316472289 | 1311987.235066135 | 1311078.476215245 | 1310163.005069999
 | Capital expenditures |  |  | 0 | 13750269.86607143 | 5879144.866071431 | 5879144.866071429 | 5879144.866071429 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071418 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 1091625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375
 | Project payout balance |  | 0 | 0 | 36242805.43997885 | 42248603.14052517 | 48254455.78113998 | 54290549.08956301 | 60326697.33805454 | 66362900.52661455 | 72768292.50798279 | 79173739.42941952 | 85607702.01866446 | 92054254.54797791 | 98500862.01735984 | 104947520.8822897 | 112357359.6872881 | 119192251.6600947 | 126032283.0104698 | 132872367.5286531 | 139712506.9869049 | 146552701.3852251 | 154088583.9513537 | 161337021.4575507 | 168585512.1315559 | 175834057.7456296 | 183084350.0590218 | 190334691.9957017 | 197585088.8724501 | 204835538.9170067 | 212086043.9016317 | 219336602.054065 | 226963439.0304954 | 228347001.8664696 | 226088716.7464807 | 225113580.8083048 | 224162997.6863551 | 223237202.0614744 | 222319041.2168971 | 221402037.0553164 | 220486160.930004 | 219571407.8249975 | 218657775.7397915 | 217745259.5670374 | 216833857.228375 | 216280830.0400347 | 215730545.2729354 | 215181363.265267 | 214633278.7112642 | 214086289.332622 | 213546891.1281498 | 213008605.5260307 | 212471403.4013722 | 211935279.2563668 | 211400230.6049562 | 210866251.8505035 | 210333340.4215972 | 209801492.176688 | 209270701.3825673 | 208740965.3373213 | 208212278.2268017 | 207684637.2604164 | 207164537.9207547 | 206645502.6569137 | 206127500.2857955 | 205610524.7743359 | 205094573.1042325 | 204579639.1425248
 | Tier 3 amount to payout
 | Distribution hurdle % | 0
 |  | 0.15
 | Prior balance | 0 |  | 0 | 0 | 36242805.43997885 | 42248603.14052517 | 48254455.78113998 | 54290549.08956301 | 60326697.33805454 | 66362900.52661455 | 72768292.50798279 | 79173739.42941952 | 85607702.01866446 | 92054254.54797791 | 98500862.01735984 | 104947520.8822897 | 112357359.6872881 | 119192251.6600947 | 126032283.0104698 | 132872367.5286531 | 139712506.9869049 | 146552701.3852251 | 154088583.9513537 | 161337021.4575507 | 168585512.1315559 | 175834057.7456296 | 183084350.0590218 | 190334691.9957017 | 197585088.8724501 | 204835538.9170067 | 212086043.9016317 | 219336602.054065 | 226963439.0304954 | 228347001.8664696 | 226088716.7464807 | 225113580.8083048 | 224162997.6863551 | 223237202.0614744 | 222319041.2168971 | 221402037.0553164 | 220486160.930004 | 219571407.8249975 | 218657775.7397915 | 217745259.5670374 | 216833857.228375 | 216280830.0400347 | 215730545.2729354 | 215181363.265267 | 214633278.7112642 | 214086289.332622 | 213546891.1281498 | 213008605.5260307 | 212471403.4013722 | 211935279.2563668 | 211400230.6049562 | 210866251.8505035 | 210333340.4215972 | 209801492.176688 | 209270701.3825673 | 208740965.3373213 | 208212278.2268017 | 207684637.2604164 | 207164537.9207547 | 206645502.6569137 | 206127500.2857955 | 205610524.7743359 | 205094573.1042325
 | EBITDA |  |  | 0 | -22492535.57390742 | -126652.8344748859 | -126707.774543379 | -156948.4423515982 | -157003.3824200913 | -157058.3224885845 | -526247.1152968036 | -526302.0553652968 | -554817.723173516 | -567407.6632420091 | -567462.6033105023 | -567513.9988584475 | -1530693.938926941 | -955747.1067351599 | -960886.484303653 | -960939.6521118721 | -960994.5921803652 | -961049.5322488584 | -1656737.700057078 | -1369292.640125571 | -1369345.80793379 | -1369400.748002283 | -1371147.447320777 | -1371197.070608448 | -1371252.010676941 | -1371305.17848516 | -1371360.118553653 | -1371413.286361872 | -6535211.976430366 | -1371523.166498858 | 2264571.267835331 | 2262703.232246517 | 2260834.689959276 | 2258962.556478057 | 2250588.525592391 | 2248716.908280994 | 2246838.610656971 | 2244959.794789731 | 2243077.376170735 | 2241194.434672403 | 2239307.885780982 | 2237419.268267776 | 2235530.120901478 | 2233637.359160489 | 2231744.062904151 | 2229847.14760562 | 2221448.307023097 | 2219551.852103935 | 2217648.688929838 | 2215744.97953878 | 2213837.639390752 | 2211929.748326668 | 2210018.221801232 | 2208104.598554173 | 2206190.417322573 | 2204272.593553182 | 2202354.207073661 | 2200432.173325446 | 2192008.186034983 | 2190085.015021943 | 2188156.648527986 | 2186227.707463334 | 2184295.10725608 | 2182361.927715201
 | Interest paid |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12039.66947530584 | 6286.147846453101 | 1287567.294070546 | 1310251.568009614 | 1333166.931597413 | 1332427.681015019 | 1331712.746700305 | 1330962.485344584 | 1330206.689783218 | 1329445.290964679 | 1328678.261918327 | 1327905.547118651 | 1327127.118989907 | 1327980.392864694 | 1327190.390554595 | 1326394.547963763 | 1325592.80802597 | 1324785.141613451 | 1324001.289047361 | 1323181.603333799 | 1322355.873595883 | 1321524.02704262 | 1320686.032936482 | 1319841.831957442 | 1318991.392707416 | 1318134.662264333 | 1317271.587369759 | 1316402.135616499 | 1315526.246002615 | 1314643.885435776 | 1313784.790243493 | 1312889.316472289 | 1311987.235066135 | 1311078.476215245 | 1310163.005069999
 | Capital expenditures |  |  | 0 | 13750269.86607143 | 5879144.866071431 | 5879144.866071429 | 5879144.866071429 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071418 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 5879144.866071433 | 1091625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375 | 357264.9609375
 | Project payout balance |  | 0 | 0 | 36242805.43997885 | 42248603.14052517 | 48254455.78113998 | 54290549.08956301 | 60326697.33805454 | 66362900.52661455 | 72768292.50798279 | 79173739.42941952 | 85607702.01866446 | 92054254.54797791 | 98500862.01735984 | 104947520.8822897 | 112357359.6872881 | 119192251.6600947 | 126032283.0104698 | 132872367.5286531 | 139712506.9869049 | 146552701.3852251 | 154088583.9513537 | 161337021.4575507 | 168585512.1315559 | 175834057.7456296 | 183084350.0590218 | 190334691.9957017 | 197585088.8724501 | 204835538.9170067 | 212086043.9016317 | 219336602.054065 | 226963439.0304954 | 228347001.8664696 | 226088716.7464807 | 225113580.8083048 | 224162997.6863551 | 223237202.0614744 | 222319041.2168971 | 221402037.0553164 | 220486160.930004 | 219571407.8249975 | 218657775.7397915 | 217745259.5670374 | 216833857.228375 | 216280830.0400347 | 215730545.2729354 | 215181363.265267 | 214633278.7112642 | 214086289.332622 | 213546891.1281498 | 213008605.5260307 | 212471403.4013722 | 211935279.2563668 | 211400230.6049562 | 210866251.8505035 | 210333340.4215972 | 209801492.176688 | 209270701.3825673 | 208740965.3373213 | 208212278.2268017 | 207684637.2604164 | 207164537.9207547 | 206645502.6569137 | 206127500.2857955 | 205610524.7743359 | 205094573.1042325 | 204579639.1425248
Distributions:
 | Calculation of amounts available for distribution
 | CF from Operations |  |  | 0 | -21365935.90724076 | -1126599.666666667 | -126652.8344748859 | -126707.7745433789 | -156948.4423515982 | -157003.3824200913 | -157058.3224885846 | -526247.1152968036 | -526302.0553652969 | -554817.723173516 | -567407.6632420091 | -567462.603310502 | -567513.9988584477 | -1530693.938926941 | -955747.1067351599 | -960886.484303653 | -960939.6521118721 | -960994.5921803652 | -961049.5322488584 | -1656737.700057078 | -1369292.640125571 | -1369345.80793379 | -1369400.748002283 | -1371147.447320777 | -1371197.070608447 | -1371252.010676941 | -1371305.17848516 | -1371360.118553653 | -5279788.286361873 | -2614797.30695506 | -1377276.688127711 | -1377276.688127711 | -1377276.688127711 | 2283750.053547076 | 2258223.305895662 | 2249873.591277676 | 2247966.646925273 | 2246082.815095602 | 2244198.395971193 | 2242310.347124381 | 2240421.719872727 | 2595794.418589738 | 2238272.542142564 | 2234740.118591378 | 2232841.516569656 | 2230942.322966357 | 2229039.481193101 | 2220664.454457008 | 2218732.166390373 | 2216822.95919192 | 2214913.132985517 | 2212999.645284614 | 2211085.547347626 | 2209167.782551204 | 2207247.868111091 | 2205327.342427998 | 2203403.141799921 | 2201478.317459777 | 2199549.812758607 | 2191149.0908427 | 2189189.541250736 | 2187254.567121832 | 2185318.948612446 | 2183379.636110833
 | Debt service |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1374558.512243029 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -111079.3725462766 | -106052.1420732776 | -1388064.905588367 | -1411486.162011899 | -1435143.912622382 | -1435152.493234171 | -1435190.874209064 | -1435199.452455074 | -1435208.061319184 | -1435216.672558576 | -1435225.30031058 | -1435233.930459114 | -1435242.577141532 | -1436888.697709432 | -1436897.356301527 | -1436906.031459507 | -1436914.709067348 | -1436923.403262466 | -1436961.89794847 | -1436970.590033516 | -1436979.312864731 | -1436988.038199439 | -1436996.780175118 | -1437005.524675828 | -1437014.28583907 | -1437023.056612286 | -1437031.82994293 | -1437040.61996854 | -1437049.412573238 | -1437058.221894584 | -1437096.831836332 | -1437105.646370142 | -1437114.484716572 | -1437123.325696452 | -1437132.183447402
 | Capital expenditures |  | 0 | 0 | -13750269.86607143 | -5879144.866071431 | -5879144.866071429 | -5879144.866071429 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071418 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -5879144.866071433 | -1091625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375 | -357264.9609375
 | Amount available to distribute |  | 0 | 0 | -35116205.77331218 | -7005744.532738098 | -6005797.700546315 | -6005852.640614808 | -6036093.308423031 | -7410706.760734553 | -6036203.188560017 | -6405391.981368236 | -6405446.92143673 | -6433962.589244949 | -6446552.529313442 | -6446607.469381935 | -6446658.864929881 | -7409838.804998374 | -6834891.972806592 | -6840031.350375086 | -6840084.518183305 | -6840139.458251799 | -6840194.398320291 | -7535882.566128511 | -7248437.506197004 | -7248490.674005208 | -7248545.614073716 | -7250292.31339221 | -7250341.93667988 | -7250396.876748374 | -7250450.044556593 | -7250504.984625086 | -6371413.286361873 | -2725876.679501336 | -1483328.830200989 | -2765341.593716078 | -2788762.85013961 | 848606.140924694 | 823070.8126614909 | 814682.7170686126 | 812767.1944701993 | 810874.7537764178 | 808981.7234126171 | 807085.0468138019 | 805187.789413613 | 803286.8805107058 | 444118.8834956323 | 440577.8013523503 | 438670.5241726497 | 436762.6529615086 | 434851.1169931341 | 426437.5955710381 | 424496.6154193571 | 422578.6853896892 | 420660.1338485775 | 418737.9041719961 | 416815.0617342978 | 414888.5357746345 | 412959.8505613056 | 411030.5515475678 | 409097.5608938804 | 407163.9439490386 | 405226.629926523 | 89251907.24928753 | 394818.9339430942 | 392875.1214677598 | 390930.6619784939 | 388982.4917259309
Equity distribution calculations
 | Cumulative Tier 1 distributions
 | Tier 1 distributions
 | [NAME] distribution deduct
 | Tier 3 distribution deduct
 | Net distributions to Equity
 | Projected distributions to Mgmt
 | Tier 1 | 0
 | [NAME] | 0.25
 | Tier 3 | 0.4
 | Total distribution
 | EQUITY IRR Net of Waterfall
 |  | -68089031.70914859
 | Asset Sale
 | [NAME] | 10
 | Gross proceeds
 | Cell B59 is not dynamic if you change period ranges of model
 | IRR Calculations on this row |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly cash flows starting first month of production >>>>>>>>>>>>>>>>>>>>