Cash Flow Spreadsheet
Quarterly Resolution — 10-Year Horizon
Phased deployment of 10 sites; CAPEX front-loaded, benefit ramps as sites energize.
Lifecycle Modeling ActiveSolar degradation: −0.5%/yrBattery fade: −2%/yr capacityMid-life augmentation: Year 6 · 15% of BESS CAPEX
Hard CAPEX
₪268.4MInterest During Construction
₪2.3M12-month build · 6.0% on debt
Working Capital (Ramp)
₪12.9M24-month ramp · break-even ~M9
Total Funding Required
₪283.6M| Period | Sites Live | CAPEX | Augment | OPEX | Gas O&M | Benefit | Net Cash | Cumulative |
|---|---|---|---|---|---|---|---|---|
| Y1 Q1 | 1 | (₪27,069,250) | — | (₪40,138) | (₪964,800) | ₪1,896,797 | ₪-26,177,392 | ₪-26,177,392 |
| Y1 Q2 | 2 | (₪27,069,250) | — | (₪120,415) | (₪2,894,400) | ₪5,690,391 | ₪-24,393,674 | ₪-50,571,065 |
| Y1 Q3 | 4 | (₪54,138,501) | — | (₪240,829) | (₪5,788,800) | ₪11,380,782 | ₪-48,787,348 | ₪-99,358,413 |
| Y1 Q4 | 5 | (₪27,069,250) | — | (₪361,244) | (₪8,683,200) | ₪17,071,173 | ₪-19,042,521 | ₪-118,400,935 |
| Y2 Q1 | 6 | (₪27,069,250) | — | (₪441,520) | (₪10,612,800) | ₪20,603,565 | ₪-17,520,006 | ₪-135,920,940 |
| Y2 Q2 | 8 | (₪54,138,501) | — | (₪561,935) | (₪13,507,200) | ₪26,222,719 | ₪-41,984,916 | ₪-177,905,857 |
| Y2 Q3 | 9 | (₪27,069,250) | — | (₪682,349) | (₪16,401,600) | ₪31,841,873 | ₪-12,311,327 | ₪-190,217,183 |
| Y2 Q4 | 10 | (₪27,069,250) | — | (₪762,626) | (₪18,331,200) | ₪35,587,976 | ₪-10,575,100 | ₪-200,792,284 |
| Y3 Q1 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,986,588 | ₪16,887,824 | ₪-183,904,460 |
| Y3 Q2 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,986,588 | ₪16,887,824 | ₪-167,016,636 |
| Y3 Q3 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,986,588 | ₪16,887,824 | ₪-150,128,812 |
| Y3 Q4 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,986,588 | ₪16,887,824 | ₪-133,240,988 |
| Y4 Q1 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,512,619 | ₪16,413,855 | ₪-116,827,133 |
| Y4 Q2 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,512,619 | ₪16,413,855 | ₪-100,413,278 |
| Y4 Q3 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,512,619 | ₪16,413,855 | ₪-83,999,423 |
| Y4 Q4 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,512,619 | ₪16,413,855 | ₪-67,585,568 |
| Y5 Q1 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,039,119 | ₪15,940,355 | ₪-51,645,213 |
| Y5 Q2 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,039,119 | ₪15,940,355 | ₪-35,704,858 |
| Y5 Q3 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,039,119 | ₪15,940,355 | ₪-19,764,504 |
| Y5 Q4 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪36,039,119 | ₪15,940,355 | ₪-3,824,149 |
| Y6 Q1 | 10 | (₪0) | (₪8,700,000) | (₪802,764) | (₪19,296,000) | ₪35,566,084 | ₪6,767,320 | ₪2,943,172 |
| Y6 Q2 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪35,566,084 | ₪15,467,320 | ₪18,410,492 |
| Y6 Q3 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪35,566,084 | ₪15,467,320 | ₪33,877,812 |
| Y6 Q4 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪35,566,084 | ₪15,467,320 | ₪49,345,133 |
| Y7 Q1 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪35,093,514 | ₪14,994,750 | ₪64,339,882 |
| Y7 Q2 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪35,093,514 | ₪14,994,750 | ₪79,334,632 |
| Y7 Q3 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪35,093,514 | ₪14,994,750 | ₪94,329,381 |
| Y7 Q4 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪35,093,514 | ₪14,994,750 | ₪109,324,131 |
| Y8 Q1 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪34,621,404 | ₪14,522,640 | ₪123,846,771 |
| Y8 Q2 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪34,621,404 | ₪14,522,640 | ₪138,369,411 |
| Y8 Q3 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪34,621,404 | ₪14,522,640 | ₪152,892,051 |
| Y8 Q4 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪34,621,404 | ₪14,522,640 | ₪167,414,691 |
| Y9 Q1 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪34,149,754 | ₪14,050,990 | ₪181,465,681 |
| Y9 Q2 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪34,149,754 | ₪14,050,990 | ₪195,516,670 |
| Y9 Q3 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪34,149,754 | ₪14,050,990 | ₪209,567,660 |
| Y9 Q4 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪34,149,754 | ₪14,050,990 | ₪223,618,649 |
| Y10 Q1 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪33,678,560 | ₪13,579,796 | ₪237,198,445 |
| Y10 Q2 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪33,678,560 | ₪13,579,796 | ₪250,778,241 |
| Y10 Q3 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪33,678,560 | ₪13,579,796 | ₪264,358,036 |
| Y10 Q4 | 10 | (₪0) | — | (₪802,764) | (₪19,296,000) | ₪33,678,560 | ₪13,579,796 | ₪277,937,832 |
| TOTAL | (₪270,692,503) | (₪8,700,000) | (₪28,899,504) | (₪694,656,000) | ₪1,280,885,839 | ₪277,937,832 | ₪277,937,832 | |
Three-Tier Roll-Up: Project → SPV → Holdco
| Entity | CAPEX | EBITDA | Net Income | ROE |
|---|---|---|---|---|
| Solar + BESS + DC (SPV) | ₪81.9M | ₪21.9M | ₪15.8M | 27% |
| ↳ Tel Aviv (Logistics) | ₪20.1M | ₪5.4M | ₪3.9M | 29.3% |
| ↳ Kannot (Red 36) | ₪16.1M | ₪4.3M | ₪3.1M | 29.3% |
| ↳ Kannot (Blue 7 Secondary) | ₪14.8M | ₪3.9M | ₪2.8M | 29.3% |
| ↳ Kannot (Green 79) | ₪13.4M | ₪3.6M | ₪2.6M | 29.3% |
| ↳ Kannot (Blue 7 Sub) | ₪10.7M | ₪2.9M | ₪2.1M | 29.3% |
| ↳ Ein Carmel (Logistics Center) | ₪6.7M | ₪1.8M | ₪1.3M | 29.3% |
| Gas Generation (CCGT) (SPV) | ₪85.9M | ₪23.0M | ₪16.5M | 27% |
| ↳ Kiryat Gat (HaBarzel 16b) | ₪26.8M | ₪7.2M | ₪5.2M | 29.3% |
| ↳ Kiryat Gat (HaBarzel 11) | ₪22.8M | ₪6.1M | ₪4.4M | 29.3% |
| ↳ Kannot (Blue 7 Main) | ₪18.8M | ₪5.0M | ₪3.6M | 29.3% |
| ↳ Karmiel (Gazit 3) | ₪17.4M | ₪4.7M | ₪3.4M | 29.3% |
| V2G Fleet (SPV) | ₪8.9M | ₪12.6M | ₪9.6M | 150.4% |
| ↳ V2G Fleet (Portfolio) | ₪8.9M | ₪12.6M | ₪9.6M | — |
| HOLDCO (Consolidated) | ₪268.4M | ₪71.7M | ₪50.2M | 24.2% |
| ↳ Less: Holdco Overhead | (₪10.1M) | |||
| ↳ Less: Management Fee | (₪4.3M) |
Monthly Break-Even
Cumulative Cash Flow Timeline
Break-Even
Not reached Construction (M1–M12) Ramp (M13–M36) Steady-State
Trough
₪-285.2M
Peak
₪-22.6M
Months to B/E
—
Per-Project PV Ranking
| # | Site | CAPEX | Net Benefit | IRR | NPV | Relative |
|---|---|---|---|---|---|---|
| ★ | Kiryat Gat (HaBarzel 16b) | ₪26.8M | ₪7.2M | 29.3% | ₪21.2M | |
| 2 | Kiryat Gat (HaBarzel 11) | ₪22.8M | ₪6.1M | 29.3% | ₪18.0M | |
| 3 | Tel Aviv (Logistics) | ₪20.1M | ₪5.4M | 29.3% | ₪15.9M | |
| 4 | Kannot (Blue 7 Main) | ₪18.8M | ₪5.0M | 29.3% | ₪14.8M | |
| 5 | Karmiel (Gazit 3) | ₪17.4M | ₪4.7M | 29.3% | ₪13.8M | |
| 6 | Kannot (Red 36) | ₪16.1M | ₪4.3M | 29.3% | ₪12.7M | |
| 7 | Kannot (Blue 7 Secondary) | ₪14.8M | ₪3.9M | 29.3% | ₪11.7M | |
| 8 | Kannot (Green 79) | ₪13.4M | ₪3.6M | 29.3% | ₪10.6M | |
| 9 | Kannot (Blue 7 Sub) | ₪10.7M | ₪2.9M | 29.3% | ₪8.5M | |
| 10 | Ein Carmel (Logistics Center) | ₪6.7M | ₪1.8M | 29.3% | ₪5.3M |