{"summary":{"engine":"waterfall","engine_version":"waterfall-1.1.0","passed":5,"failed":0,"pending":0,"all_passing":true,"workbook_sha256":"60eb3b6d730b187a5bf92b4a50847ea7f6e66b11838d94c6ad92ae43782c780a","checked_at":"2026-09-05T13:30:28.317673+00:00"},"conventions":{"pooled_lp":"Engine models aggregate LP; expecteds are workbook LP I + LP II summed.","pref_accrual_basis":"Selected day_count, on opening (beginning-of-period) unreturned balance; year-end distributions assumed.","act_act":"Excel YEARFRAC(...,1) / ICMA for periods <= 1yr; NOT ISDA multi-year.","irr_basis":"IRR hurdle solve and reported IRRs discount ACT/365 (Excel XNPV/XIRR), regardless of pref day_count.","catchup_full":"GP grossed up to tier-1 promote on LP preferred: g1/(1-g1) x LP pref. 'none' = hard pref.","catchup_base":"LP preferred only (excludes GP co-invest pref).","clawback":"Out of scope — European, single-project, terminal distribution."},"tolerances":{"cash":0.02,"irr":0.0001,"moic":0.001},"cases":[{"id":"asym_6_3_actact_full","status":"pass","source":{"workbook":"waterfall.xlsx","sha256":"60eb3b6d730b187a5bf92b4a50847ea7f6e66b11838d94c6ad92ae43782c780a","toggle":"I6=ACT/ACT (base)","recalc":"LibreOffice Calc headless (validated to the penny against Excel on the ACT/ACT base case)"}},{"id":"asym_6_3_act365_full","status":"pass","source":{"workbook":"waterfall.xlsx","sha256":"60eb3b6d730b187a5bf92b4a50847ea7f6e66b11838d94c6ad92ae43782c780a","toggle":"I6=ACT/365","recalc":"LibreOffice Calc headless (validated to the penny against Excel on the ACT/ACT base case)"}},{"id":"asym_6_3_30e360_full","status":"pass","source":{"workbook":"waterfall.xlsx","sha256":"60eb3b6d730b187a5bf92b4a50847ea7f6e66b11838d94c6ad92ae43782c780a","toggle":"I6=30E/360","recalc":"LibreOffice Calc headless (validated to the penny against Excel on the ACT/ACT base case)"}},{"id":"asym_6_3_actact_hardpref","status":"pass","source":{"workbook":"waterfall.xlsx","sha256":"60eb3b6d730b187a5bf92b4a50847ea7f6e66b11838d94c6ad92ae43782c780a","toggle":"G11=0 (catch-up none); revert to =+E11 after sourcing","recalc":"LibreOffice Calc headless (validated to the penny against Excel on the ACT/ACT base case)"}},{"id":"asym_6_3_actact_compound","status":"pass","source":{"workbook":"waterfall.xlsx","sha256":"60eb3b6d730b187a5bf92b4a50847ea7f6e66b11838d94c6ad92ae43782c780a","toggle":"G6=Y (annual compounding)","recalc":"LibreOffice Calc headless (validated to the penny against Excel on the ACT/ACT base case)"}}]}