FC
Flying Cargo · Energy Sovereignty
Executive Energy Modeler
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.4M
Interest During Construction
₪2.3M
12-month build · 6.0% on debt
Working Capital (Ramp)
₪12.9M
24-month ramp · break-even ~M9
Total Funding Required
₪283.6M
PeriodSites LiveCAPEXAugmentOPEXGas O&MBenefitNet CashCumulative
Y1 Q11(₪27,069,250)—(₪40,138)(₪964,800)₪1,896,797₪-26,177,392₪-26,177,392
Y1 Q22(₪27,069,250)—(₪120,415)(₪2,894,400)₪5,690,391₪-24,393,674₪-50,571,065
Y1 Q34(₪54,138,501)—(₪240,829)(₪5,788,800)₪11,380,782₪-48,787,348₪-99,358,413
Y1 Q45(₪27,069,250)—(₪361,244)(₪8,683,200)₪17,071,173₪-19,042,521₪-118,400,935
Y2 Q16(₪27,069,250)—(₪441,520)(₪10,612,800)₪20,603,565₪-17,520,006₪-135,920,940
Y2 Q28(₪54,138,501)—(₪561,935)(₪13,507,200)₪26,222,719₪-41,984,916₪-177,905,857
Y2 Q39(₪27,069,250)—(₪682,349)(₪16,401,600)₪31,841,873₪-12,311,327₪-190,217,183
Y2 Q410(₪27,069,250)—(₪762,626)(₪18,331,200)₪35,587,976₪-10,575,100₪-200,792,284
Y3 Q110(₪0)—(₪802,764)(₪19,296,000)₪36,986,588₪16,887,824₪-183,904,460
Y3 Q210(₪0)—(₪802,764)(₪19,296,000)₪36,986,588₪16,887,824₪-167,016,636
Y3 Q310(₪0)—(₪802,764)(₪19,296,000)₪36,986,588₪16,887,824₪-150,128,812
Y3 Q410(₪0)—(₪802,764)(₪19,296,000)₪36,986,588₪16,887,824₪-133,240,988
Y4 Q110(₪0)—(₪802,764)(₪19,296,000)₪36,512,619₪16,413,855₪-116,827,133
Y4 Q210(₪0)—(₪802,764)(₪19,296,000)₪36,512,619₪16,413,855₪-100,413,278
Y4 Q310(₪0)—(₪802,764)(₪19,296,000)₪36,512,619₪16,413,855₪-83,999,423
Y4 Q410(₪0)—(₪802,764)(₪19,296,000)₪36,512,619₪16,413,855₪-67,585,568
Y5 Q110(₪0)—(₪802,764)(₪19,296,000)₪36,039,119₪15,940,355₪-51,645,213
Y5 Q210(₪0)—(₪802,764)(₪19,296,000)₪36,039,119₪15,940,355₪-35,704,858
Y5 Q310(₪0)—(₪802,764)(₪19,296,000)₪36,039,119₪15,940,355₪-19,764,504
Y5 Q410(₪0)—(₪802,764)(₪19,296,000)₪36,039,119₪15,940,355₪-3,824,149
Y6 Q110(₪0)(₪8,700,000)(₪802,764)(₪19,296,000)₪35,566,084₪6,767,320₪2,943,172
Y6 Q210(₪0)—(₪802,764)(₪19,296,000)₪35,566,084₪15,467,320₪18,410,492
Y6 Q310(₪0)—(₪802,764)(₪19,296,000)₪35,566,084₪15,467,320₪33,877,812
Y6 Q410(₪0)—(₪802,764)(₪19,296,000)₪35,566,084₪15,467,320₪49,345,133
Y7 Q110(₪0)—(₪802,764)(₪19,296,000)₪35,093,514₪14,994,750₪64,339,882
Y7 Q210(₪0)—(₪802,764)(₪19,296,000)₪35,093,514₪14,994,750₪79,334,632
Y7 Q310(₪0)—(₪802,764)(₪19,296,000)₪35,093,514₪14,994,750₪94,329,381
Y7 Q410(₪0)—(₪802,764)(₪19,296,000)₪35,093,514₪14,994,750₪109,324,131
Y8 Q110(₪0)—(₪802,764)(₪19,296,000)₪34,621,404₪14,522,640₪123,846,771
Y8 Q210(₪0)—(₪802,764)(₪19,296,000)₪34,621,404₪14,522,640₪138,369,411
Y8 Q310(₪0)—(₪802,764)(₪19,296,000)₪34,621,404₪14,522,640₪152,892,051
Y8 Q410(₪0)—(₪802,764)(₪19,296,000)₪34,621,404₪14,522,640₪167,414,691
Y9 Q110(₪0)—(₪802,764)(₪19,296,000)₪34,149,754₪14,050,990₪181,465,681
Y9 Q210(₪0)—(₪802,764)(₪19,296,000)₪34,149,754₪14,050,990₪195,516,670
Y9 Q310(₪0)—(₪802,764)(₪19,296,000)₪34,149,754₪14,050,990₪209,567,660
Y9 Q410(₪0)—(₪802,764)(₪19,296,000)₪34,149,754₪14,050,990₪223,618,649
Y10 Q110(₪0)—(₪802,764)(₪19,296,000)₪33,678,560₪13,579,796₪237,198,445
Y10 Q210(₪0)—(₪802,764)(₪19,296,000)₪33,678,560₪13,579,796₪250,778,241
Y10 Q310(₪0)—(₪802,764)(₪19,296,000)₪33,678,560₪13,579,796₪264,358,036
Y10 Q410(₪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
EntityCAPEXEBITDANet IncomeROE
Solar + BESS + DC (SPV)₪81.9M₪21.9M₪15.8M27%
↳ Tel Aviv (Logistics)₪20.1M₪5.4M₪3.9M29.3%
↳ Kannot (Red 36)₪16.1M₪4.3M₪3.1M29.3%
↳ Kannot (Blue 7 Secondary)₪14.8M₪3.9M₪2.8M29.3%
↳ Kannot (Green 79)₪13.4M₪3.6M₪2.6M29.3%
↳ Kannot (Blue 7 Sub)₪10.7M₪2.9M₪2.1M29.3%
↳ Ein Carmel (Logistics Center)₪6.7M₪1.8M₪1.3M29.3%
Gas Generation (CCGT) (SPV)₪85.9M₪23.0M₪16.5M27%
↳ Kiryat Gat (HaBarzel 16b)₪26.8M₪7.2M₪5.2M29.3%
↳ Kiryat Gat (HaBarzel 11)₪22.8M₪6.1M₪4.4M29.3%
↳ Kannot (Blue 7 Main)₪18.8M₪5.0M₪3.6M29.3%
↳ Karmiel (Gazit 3)₪17.4M₪4.7M₪3.4M29.3%
V2G Fleet (SPV)₪8.9M₪12.6M₪9.6M150.4%
↳ V2G Fleet (Portfolio)₪8.9M₪12.6M₪9.6M—
HOLDCO (Consolidated)₪268.4M₪71.7M₪50.2M24.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
#SiteCAPEXNet BenefitIRRNPVRelative
★Kiryat Gat (HaBarzel 16b)₪26.8M₪7.2M29.3%₪21.2M
2Kiryat Gat (HaBarzel 11)₪22.8M₪6.1M29.3%₪18.0M
3Tel Aviv (Logistics)₪20.1M₪5.4M29.3%₪15.9M
4Kannot (Blue 7 Main)₪18.8M₪5.0M29.3%₪14.8M
5Karmiel (Gazit 3)₪17.4M₪4.7M29.3%₪13.8M
6Kannot (Red 36)₪16.1M₪4.3M29.3%₪12.7M
7Kannot (Blue 7 Secondary)₪14.8M₪3.9M29.3%₪11.7M
8Kannot (Green 79)₪13.4M₪3.6M29.3%₪10.6M
9Kannot (Blue 7 Sub)₪10.7M₪2.9M29.3%₪8.5M
10Ein Carmel (Logistics Center)₪6.7M₪1.8M29.3%₪5.3M
    base44
    Edit with Base44