Opening Finance Studio…
Opening Finance Studio…
A transparent solar operating model, from first power to the final operating year.
Explore a demonstration locally in your browser. Sign in to connect projects and save versions.
Insurance: explicit manual budget and escalation. No market quote or coverage adequacy is inferred.
Geographic context unavailable: no immutable physical site selected.
Design Optimization: pending. Catastrophe losses, deductibles, insurance recoveries and mitigation economics: not yet modeled.
Gross generation and net sellable output after losses.
| Operating year | Gross | Net sellable |
|---|---|---|
| 1 | 280,000.000 | 268,912.000 |
| 2 | 278,600.000 | 267,567.440 |
| 3 | 277,207.000 | 266,229.603 |
| 4 | 275,820.965 | 264,898.455 |
| 5 | 274,441.860 | 263,573.962 |
| 6 | 273,069.651 | 262,256.093 |
| 7 | 271,704.303 | 260,944.813 |
| 8 | 270,345.781 | 259,640.088 |
| 9 | 268,994.052 | 258,341.888 |
| 10 | 267,649.082 | 257,050.178 |
| 11 | 266,310.837 | 255,764.928 |
| 12 | 264,979.282 | 254,486.102 |
| 13 | 263,654.386 | 253,213.672 |
| 14 | 262,336.114 | 251,947.604 |
| 15 | 261,024.433 | 250,687.865 |
| 16 | 259,719.311 | 249,434.426 |
| 17 | 258,420.715 | 248,187.255 |
| 18 | 257,128.611 | 246,946.318 |
| 19 | 255,842.968 | 245,711.586 |
| 20 | 254,563.753 | 244,483.028 |
| 21 | 253,290.934 | 243,260.613 |
| 22 | 252,024.480 | 242,044.311 |
| 23 | 250,764.357 | 240,834.088 |
| 24 | 249,510.536 | 239,629.919 |
| 25 | 248,262.983 | 238,431.769 |
| 26 | 247,021.668 | 237,239.610 |
| 27 | 245,786.560 | 236,053.412 |
| 28 | 244,557.627 | 234,873.145 |
| 29 | 243,334.839 | 233,698.779 |
| 30 | 242,118.165 | 232,530.286 |
| 31 | 240,907.574 | 231,367.634 |
| 32 | 239,703.036 | 230,210.796 |
| 33 | 238,504.521 | 229,059.742 |
| 34 | 237,311.998 | 227,914.443 |
| 35 | 236,125.438 | 226,774.871 |
PPA revenue ends at the selected PPA duration. Merchant prices escalate from COD-year dollars.
| Operating year | Contracted | Merchant | Other revenue |
|---|---|---|---|
| 1 | 12,101,040.00 | 0.00 | 0.00 |
| 2 | 12,160,940.15 | 0.00 | 0.00 |
| 3 | 12,219,938.78 | 0.00 | 0.00 |
| 4 | 12,280,692.37 | 0.00 | 0.00 |
| 5 | 12,343,168.64 | 0.00 | 0.00 |
| 6 | 12,404,713.20 | 0.00 | 0.00 |
| 7 | 12,465,333.72 | 0.00 | 0.00 |
| 8 | 12,527,634.25 | 0.00 | 0.00 |
| 9 | 12,589,000.20 | 0.00 | 0.00 |
| 10 | 12,652,009.76 | 0.00 | 0.00 |
| 11 | 12,714,074.57 | 0.00 | 0.00 |
| 12 | 12,777,747.18 | 0.00 | 0.00 |
| 13 | 12,840,465.31 | 0.00 | 0.00 |
| 14 | 12,902,236.80 | 0.00 | 0.00 |
| 15 | 12,968,083.26 | 0.00 | 0.00 |
| 16 | 13,030,454.41 | 0.00 | 0.00 |
| 17 | 13,096,841.45 | 0.00 | 0.00 |
| 18 | 13,159,769.29 | 0.00 | 0.00 |
| 19 | 13,226,654.67 | 0.00 | 0.00 |
| 20 | 13,290,097.40 | 0.00 | 0.00 |
| 21 | 0.00 | 14,459,410.84 | 0.00 |
| 22 | 0.00 | 14,675,146.58 | 0.00 |
| 23 | 0.00 | 14,893,180.00 | 0.00 |
| 24 | 0.00 | 15,115,855.29 | 0.00 |
| 25 | 0.00 | 15,340,700.02 | 0.00 |
| 26 | 0.00 | 15,567,663.21 | 0.00 |
| 27 | 0.00 | 15,801,415.40 | 0.00 |
| 28 | 0.00 | 16,037,138.34 | 0.00 |
| 29 | 0.00 | 16,274,782.97 | 0.00 |
| 30 | 0.00 | 16,516,626.21 | 0.00 |
| 31 | 0.00 | 16,762,585.08 | 0.00 |
| 32 | 0.00 | 17,012,577.82 | 0.00 |
| 33 | 0.00 | 17,266,523.35 | 0.00 |
| 34 | 0.00 | 17,524,341.52 | 0.00 |
| 35 | 0.00 | 17,785,953.13 | 0.00 |
Nominal operating expenses, including property tax and insurance.
| Category | Year 1 expense |
|---|---|
| 1. Fixed O&M | 1,500,000.00 |
| 2. Variable O&M | 537,824.00 |
| 3. Land lease | 250,000.00 |
| 4. Property tax | 400,000.00 |
| 5. Asset management | 150,000.00 |
| 6. Other costs | 0.00 |
| 7. Insurance | 350,000.00 |
EBITDA, operating cash flow after working capital, and preliminary CFADS after reserves.
| Operating year | EBITDA | Operating CF | Preliminary CFADS |
|---|---|---|---|
| 1 | 8,913,216.00 | 8,308,164.00 | 7,808,164.00 |
| 2 | 8,908,602.57 | 8,905,607.56 | 8,905,607.56 |
| 3 | 8,901,733.22 | 8,898,783.29 | 8,898,783.29 |
| 4 | 8,895,234.80 | 8,892,197.12 | 8,892,197.12 |
| 5 | 8,889,044.73 | 8,885,920.92 | 8,885,920.92 |
| 6 | 8,880,477.59 | 8,877,400.36 | 8,877,400.36 |
| 7 | 8,869,509.38 | 8,866,478.35 | 8,866,478.35 |
| 8 | 8,858,711.66 | 8,855,596.64 | 8,855,596.64 |
| 9 | 8,845,436.70 | 8,842,368.40 | 8,842,368.40 |
| 10 | 8,832,228.73 | 8,829,078.25 | 8,829,078.25 |
| 11 | 8,816,464.64 | 8,813,361.40 | 8,813,361.40 |
| 12 | 8,800,661.46 | 8,797,477.83 | 8,797,477.83 |
| 13 | 8,782,220.55 | 8,779,084.64 | 8,779,084.64 |
| 14 | 8,761,112.57 | 8,758,024.00 | 8,758,024.00 |
| 15 | 8,742,321.08 | 8,739,028.76 | 8,739,028.76 |
| 16 | 8,718,256.84 | 8,715,138.28 | 8,715,138.28 |
| 17 | 8,696,371.24 | 8,693,051.89 | 8,693,051.89 |
| 18 | 8,669,148.43 | 8,666,002.04 | 8,666,002.04 |
| 19 | 8,643,963.43 | 8,640,619.16 | 8,640,619.16 |
| 20 | 8,613,373.37 | 8,610,201.23 | 8,610,201.23 |
| 21 | 9,686,647.95 | 9,628,182.28 | 9,628,182.28 |
| 22 | 9,804,294.05 | 9,793,507.26 | 9,793,507.26 |
| 23 | 9,922,141.35 | 9,911,239.68 | 9,911,239.68 |
| 24 | 10,042,487.20 | 10,031,353.44 | 10,031,353.44 |
| 25 | 10,162,811.33 | 10,151,569.09 | 10,151,569.09 |
| 26 | 10,283,013.69 | 10,271,665.53 | 10,271,665.53 |
| 27 | 10,407,714.68 | 10,396,027.07 | 10,396,027.07 |
| 28 | 10,532,044.71 | 10,520,258.56 | 10,520,258.56 |
| 29 | 10,655,902.15 | 10,644,019.92 | 10,644,019.92 |
| 30 | 10,781,510.14 | 10,769,417.98 | 10,769,417.98 |
| 31 | 10,908,730.68 | 10,896,432.74 | 10,896,432.74 |
| 32 | 11,037,425.65 | 11,024,926.01 | 11,024,926.01 |
| 33 | 11,167,456.26 | 11,154,758.98 | 11,154,758.98 |
| 34 | 11,298,683.36 | 11,285,792.45 | 11,285,792.45 |
| 35 | 11,430,967.30 | 12,307,184.38 | 12,807,184.38 |
Undiscounted operating cash flow. Excludes construction capex; this is not project payback or investment return.
| Operating year | Cumulative operating CF |
|---|---|
| 1 | 8,308,164.00 |
| 2 | 17,213,771.56 |
| 3 | 26,112,554.85 |
| 4 | 35,004,751.97 |
| 5 | 43,890,672.89 |
| 6 | 52,768,073.25 |
| 7 | 61,634,551.60 |
| 8 | 70,490,148.24 |
| 9 | 79,332,516.64 |
| 10 | 88,161,594.89 |
| 11 | 96,974,956.29 |
| 12 | 105,772,434.12 |
| 13 | 114,551,518.76 |
| 14 | 123,309,542.76 |
| 15 | 132,048,571.52 |
| 16 | 140,763,709.80 |
| 17 | 149,456,761.69 |
| 18 | 158,122,763.73 |
| 19 | 166,763,382.89 |
| 20 | 175,373,584.12 |
| 21 | 185,001,766.40 |
| 22 | 194,795,273.66 |
| 23 | 204,706,513.34 |
| 24 | 214,737,866.78 |
| 25 | 224,889,435.87 |
| 26 | 235,161,101.40 |
| 27 | 245,557,128.47 |
| 28 | 256,077,387.03 |
| 29 | 266,721,406.95 |
| 30 | 277,490,824.93 |
| 31 | 288,387,257.67 |
| 32 | 299,412,183.68 |
| 33 | 310,566,942.66 |
| 34 | 321,852,735.11 |
| 35 | 334,159,919.49 |
Lifetime operating cash flow. Neutral cases remain equal until you enter scenario adjustments.
| Category | Lifetime operating CF |
|---|---|
| 1. base | 334,159,919.49 |
| 2. downside | 334,159,919.49 |
| 3. upside | 334,159,919.49 |
Modeled annual budget with explicit escalation and scenario adjustment; no claims or coverage simulation.
| Operating year | Insurance expense |
|---|---|
| 1 | 350,000.00 |
| 2 | 360,500.00 |
| 3 | 371,315.00 |
| 4 | 382,454.45 |
| 5 | 393,928.08 |
| 6 | 405,745.93 |
| 7 | 417,918.30 |
| 8 | 430,455.85 |
| 9 | 443,369.53 |
| 10 | 456,670.61 |
| 11 | 470,370.73 |
| 12 | 484,481.85 |
| 13 | 499,016.31 |
| 14 | 513,986.80 |
| 15 | 529,406.40 |
| 16 | 545,288.60 |
| 17 | 561,647.25 |
| 18 | 578,496.67 |
| 19 | 595,851.57 |
| 20 | 613,727.12 |
| 21 | 632,138.93 |
| 22 | 651,103.10 |
| 23 | 670,636.19 |
| 24 | 690,755.28 |
| 25 | 711,477.94 |
| 26 | 732,822.28 |
| 27 | 754,806.94 |
| 28 | 777,451.15 |
| 29 | 800,774.69 |
| 30 | 824,797.93 |
| 31 | 849,541.86 |
| 32 | 875,028.12 |
| 33 | 901,278.96 |
| 34 | 928,317.33 |
| 35 | 956,166.85 |
One input group increased 10% against unadjusted base; capped at validation bounds. Shows change in lifetime operating CF. Capex affects funding, not operating CF; degradation has no effect when annual forecasts replace it.
| Category | Change from base operating CF |
|---|---|
| 1. PPA price +10% | 25,373,268.23 |
| 2. Gross generation +10% | 47,030,894.70 |
| 3. Degradation +10% | -4,283,741.07 |
| 4. Construction capex +10% | 0.00 |
| 5. Non-insurance OPEX +10% | -13,946,314.69 |
| 6. Insurance +10% | -2,116,172.92 |
| Year | Period start | Gross MWh | Net MWh | Revenue | Operating expenses | EBITDA | Working capital movement | Reserve movement | Operating cash flow | Preliminary CFADS | Cumulative operating CF |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2028-01-01 | 280,000.000 | 268,912.000 | 12,101,040.00 | 3,187,824.00 | 8,913,216.00 | 605,052.00 | 500,000.00 | 8,308,164.00 | 7,808,164.00 | 8,308,164.00 |
| 2 | 2029-01-01 | 278,600.000 | 267,567.440 | 12,160,940.15 | 3,252,337.58 | 8,908,602.57 | 2,995.01 | 0.00 | 8,905,607.56 | 8,905,607.56 | 17,213,771.56 |
| 3 | 2030-01-01 | 277,207.000 | 266,229.603 | 12,219,938.78 | 3,318,205.56 | 8,901,733.22 | 2,949.93 | 0.00 | 8,898,783.29 | 8,898,783.29 | 26,112,554.85 |
| 4 | 2031-01-01 | 275,820.965 | 264,898.455 | 12,280,692.37 | 3,385,457.57 | 8,895,234.80 | 3,037.68 | 0.00 | 8,892,197.12 | 8,892,197.12 | 35,004,751.97 |
| 5 | 2032-01-01 | 274,441.860 | 263,573.962 | 12,343,168.64 | 3,454,123.91 | 8,889,044.73 | 3,123.81 | 0.00 | 8,885,920.92 | 8,885,920.92 | 43,890,672.89 |
| 6 | 2033-01-01 | 273,069.651 | 262,256.093 | 12,404,713.20 | 3,524,235.61 | 8,880,477.59 | 3,077.23 | 0.00 | 8,877,400.36 | 8,877,400.36 | 52,768,073.25 |
| 7 | 2034-01-01 | 271,704.303 | 260,944.813 | 12,465,333.72 | 3,595,824.34 | 8,869,509.38 | 3,031.03 | 0.00 | 8,866,478.35 | 8,866,478.35 | 61,634,551.60 |
| 8 | 2035-01-01 | 270,345.781 | 259,640.088 | 12,527,634.25 | 3,668,922.59 | 8,858,711.66 | 3,115.02 | 0.00 | 8,855,596.64 | 8,855,596.64 | 70,490,148.24 |
| 9 | 2036-01-01 | 268,994.052 | 258,341.888 | 12,589,000.20 | 3,743,563.50 | 8,845,436.70 | 3,068.30 | 0.00 | 8,842,368.40 | 8,842,368.40 | 79,332,516.64 |
| 10 | 2037-01-01 | 267,649.082 | 257,050.178 | 12,652,009.76 | 3,819,781.03 | 8,832,228.73 | 3,150.48 | 0.00 | 8,829,078.25 | 8,829,078.25 | 88,161,594.89 |
| 11 | 2038-01-01 | 266,310.837 | 255,764.928 | 12,714,074.57 | 3,897,609.93 | 8,816,464.64 | 3,103.24 | 0.00 | 8,813,361.40 | 8,813,361.40 | 96,974,956.29 |
| 12 | 2039-01-01 | 264,979.282 | 254,486.102 | 12,777,747.18 | 3,977,085.72 | 8,800,661.46 | 3,183.63 | 0.00 | 8,797,477.83 | 8,797,477.83 | 105,772,434.12 |
| 13 | 2040-01-01 | 263,654.386 | 253,213.672 | 12,840,465.31 | 4,058,244.76 | 8,782,220.55 | 3,135.91 | 0.00 | 8,779,084.64 | 8,779,084.64 | 114,551,518.76 |
| 14 | 2041-01-01 | 262,336.114 | 251,947.604 | 12,902,236.80 | 4,141,124.23 | 8,761,112.57 | 3,088.57 | 0.00 | 8,758,024.00 | 8,758,024.00 | 123,309,542.76 |
| 15 | 2042-01-01 | 261,024.433 | 250,687.865 | 12,968,083.26 | 4,225,762.18 | 8,742,321.08 | 3,292.32 | 0.00 | 8,739,028.76 | 8,739,028.76 | 132,048,571.52 |
| 16 | 2043-01-01 | 259,719.311 | 249,434.426 | 13,030,454.41 | 4,312,197.57 | 8,718,256.84 | 3,118.56 | 0.00 | 8,715,138.28 | 8,715,138.28 | 140,763,709.80 |
| 17 | 2044-01-01 | 258,420.715 | 248,187.255 | 13,096,841.45 | 4,400,470.21 | 8,696,371.24 | 3,319.35 | 0.00 | 8,693,051.89 | 8,693,051.89 | 149,456,761.69 |
| 18 | 2045-01-01 | 257,128.611 | 246,946.318 | 13,159,769.29 | 4,490,620.86 | 8,669,148.43 | 3,146.39 | 0.00 | 8,666,002.04 | 8,666,002.04 | 158,122,763.73 |
| 19 | 2046-01-01 | 255,842.968 | 245,711.586 | 13,226,654.67 | 4,582,691.24 | 8,643,963.43 | 3,344.27 | 0.00 | 8,640,619.16 | 8,640,619.16 | 166,763,382.89 |
| 20 | 2047-01-01 | 254,563.753 | 244,483.028 | 13,290,097.40 | 4,676,724.03 | 8,613,373.37 | 3,172.14 | 0.00 | 8,610,201.23 | 8,610,201.23 | 175,373,584.12 |
| 21 | 2048-01-01 | 253,290.934 | 243,260.613 | 14,459,410.84 | 4,772,762.89 | 9,686,647.95 | 58,465.67 | 0.00 | 9,628,182.28 | 9,628,182.28 | 185,001,766.40 |
| 22 | 2049-01-01 | 252,024.480 | 242,044.311 | 14,675,146.58 | 4,870,852.53 | 9,804,294.05 | 10,786.79 | 0.00 | 9,793,507.26 | 9,793,507.26 | 194,795,273.66 |
| 23 | 2050-01-01 | 250,764.357 | 240,834.088 | 14,893,180.00 | 4,971,038.65 | 9,922,141.35 | 10,901.67 | 0.00 | 9,911,239.68 | 9,911,239.68 | 204,706,513.34 |
| 24 | 2051-01-01 | 249,510.536 | 239,629.919 | 15,115,855.29 | 5,073,368.09 | 10,042,487.20 | 11,133.76 | 0.00 | 10,031,353.44 | 10,031,353.44 | 214,737,866.78 |
| 25 | 2052-01-01 | 248,262.983 | 238,431.769 | 15,340,700.02 | 5,177,888.69 | 10,162,811.33 | 11,242.24 | 0.00 | 10,151,569.09 | 10,151,569.09 | 224,889,435.87 |
| 26 | 2053-01-01 | 247,021.668 | 237,239.610 | 15,567,663.21 | 5,284,649.52 | 10,283,013.69 | 11,348.16 | 0.00 | 10,271,665.53 | 10,271,665.53 | 235,161,101.40 |
| 27 | 2054-01-01 | 245,786.560 | 236,053.412 | 15,801,415.40 | 5,393,700.72 | 10,407,714.68 | 11,687.61 | 0.00 | 10,396,027.07 | 10,396,027.07 | 245,557,128.47 |
| 28 | 2055-01-01 | 244,557.627 | 234,873.145 | 16,037,138.34 | 5,505,093.63 | 10,532,044.71 | 11,786.15 | 0.00 | 10,520,258.56 | 10,520,258.56 | 256,077,387.03 |
| 29 | 2056-01-01 | 243,334.839 | 233,698.779 | 16,274,782.97 | 5,618,880.82 | 10,655,902.15 | 11,882.23 | 0.00 | 10,644,019.92 | 10,644,019.92 | 266,721,406.95 |
| 30 | 2057-01-01 | 242,118.165 | 232,530.286 | 16,516,626.21 | 5,735,116.07 | 10,781,510.14 | 12,092.16 | 0.00 | 10,769,417.98 | 10,769,417.98 | 277,490,824.93 |
| 31 | 2058-01-01 | 240,907.574 | 231,367.634 | 16,762,585.08 | 5,853,854.40 | 10,908,730.68 | 12,297.94 | 0.00 | 10,896,432.74 | 10,896,432.74 | 288,387,257.67 |
| 32 | 2059-01-01 | 239,703.036 | 230,210.796 | 17,012,577.82 | 5,975,152.17 | 11,037,425.65 | 12,499.64 | 0.00 | 11,024,926.01 | 11,024,926.01 | 299,412,183.68 |
| 33 | 2060-01-01 | 238,504.521 | 229,059.742 | 17,266,523.35 | 6,099,067.09 | 11,167,456.26 | 12,697.28 | 0.00 | 11,154,758.98 | 11,154,758.98 | 310,566,942.66 |
| 34 | 2061-01-01 | 237,311.998 | 227,914.443 | 17,524,341.52 | 6,225,658.16 | 11,298,683.36 | 12,890.91 | 0.00 | 11,285,792.45 | 11,285,792.45 | 321,852,735.11 |
| 35 | 2062-01-01 | 236,125.438 | 226,774.871 | 17,785,953.13 | 6,354,985.83 | 11,430,967.30 | -876,217.08 | -500,000.00 | 12,307,184.38 | 12,807,184.38 | 334,159,919.49 |
Each change uses the unadjusted base case and the same engine. Construction capex changes funding needs without changing operating cash flow. Sensitivities are exploratory derived views; saved scenarios are the three explicit cases.
| Assumption | Total capex | Lifetime operating CF | Change in operating CF |
|---|---|---|---|
| PPA price +10% | $130,000,000 | $359,533,188 | $25,373,268 |
| Gross generation +10% | $130,000,000 | $381,190,814 | $47,030,895 |
| Degradation +10% | $130,000,000 | $329,876,178 | -$4,283,741 |
| Construction capex +10% | $142,000,000 | $334,159,919 | $0 |
| Non-insurance OPEX +10% | $130,000,000 | $320,213,605 | -$13,946,315 |
| Insurance +10% | $130,000,000 | $332,043,747 | -$2,116,173 |
Engine solar-operating-0.4.1. Full operating years start at COD anniversaries; no partial calendar-year proration. Gross MWh rounds to 0.001 MWh; net MWh also rounds to 0.001; annual unit prices, costs and cash flows round to cents. Reported rows are the calculation inputs for totals.
Net MWh = gross MWh × (1 − curtailment) × availability. Fixed OPEX and variable cost per net MWh share the explicit non-insurance escalator. Insurance has its own escalator. EBITDA = total revenue − total OPEX. Working-capital movement = closing balance − prior balance; initial balance is zero, the target is a percentage of annual revenue, and the balance releases in the final operating year. Operating cash flow = EBITDA − working-capital movement. Operating reserve is funded in year 1, held at a fixed nominal amount and released in the final year. Preliminary pre-financing CFADS = operating CF − reserve movement. This is an operating proxy before income tax, debt, sustaining capex and lender-specific adjustments.
Construction period: 2027-01-01 to 2028-01-01. Development $10,000,000 + construction $120,000,000 = $130,000,000. Aggregate pre-COD capex; no annual construction draw profile or financing modeled. No recurring replacement capex, decommissioning or terminal sale value is modeled. No grant, credit or income-tax assumption is embedded.
Ownership is descriptive only. No financing, partnership allocation, tax, IRR, NPV, DSCR or investment-return calculation is available. Manual or synthetic insurance budgets are planning inputs only.
Each saved version includes all three scenarios, inputs, engine version, full schedules and selected insurance/site snapshots.
No stored versions loaded. Database persistence is unavailable until the reviewed finance migration is installed.