FinModel Simulator — Enterprise Simulation & Costing

Demo · Fictional Sava group data — not real business figures.

Hoàng Quân (Mr Quân) — Finance · Accounting · FP&A · IC · AI · Savafinlab savafinlab.com.vn

Project Finance

Demo #10 — Sava LogPark Phase 2 SPV: 2-year construction, 18-year operations, senior debt sized via DSCR/LLCR/gearing, sculpted debt service, and covenant headroom (USD $M).

Training scope — SPV vs operating company

Fictional greenfield logistics SPV aligned with Excel Demo #10. Separate from the four industry simulators (Sava Industrial parent P&L) and from Demo #9 LBO buyout mechanics. Construction draws use gearing on capex; sized debt at COD may differ from construction balance — educational only, no live term sheets or DSRA.

Project snapshot

TPC incl. capitalized IDC; binding constraint from debt sizing tab.

Total project cost ($M)

148.9

Senior debt sized ($M)

42.5

Sponsor equity required ($M)

106.4

Binding constraint

DSCR

Debt sizing (MIN of three)

LLCR, DSCR PV, and 70% gearing cap — same logic as the Excel Debt Sizing sheet.

Max debt — LLCR ($M)44.2
Max debt — DSCR PV ($M)42.5
Max debt — gearing cap ($M)104.2
Implied LLCR at selected debt1.35×

Covenants & sponsor

Sculpted to 1.35× target DSCR after 1-year principal grace.

Minimum DSCR (ops)1.35×
Minimum LLCR (ops)1.35×
Equity multiple (undisc.)1.44×
IDC capitalized ($M)3.8

Operations — CFADS & sculpted debt service

First eight operating years; DSCR equals sculpt target when debt service is active.

PeriodCFADS ($M)Debt service ($M)DSCRDebt closing ($M)
Op Y13.70.042.5
Op Y25.33.91.35×41.5
Op Y36.44.81.35×39.5
Op Y46.74.91.35×37.3
Op Y56.85.11.35×34.7
Op Y67.05.21.35×31.9
Op Y77.25.31.35×28.7
Op Y87.35.41.35×25.2

Construction phase funds capex at 2 years with 70% senior debt draws; debt at COD (construction schedule) was 101.6 $M before ops-sized debt replaces the opening balance.

Link greenfield SPV cash flows here with the construction industry 3-statement template; contrast DSCR/LLCR with corporate debt schedule (#11) and PE returns (#9).