{"summary":{"engine":"fix-flip","engine_version":"fix-flip-1.1.0","passed":2,"failed":0,"pending":0,"all_passing":true,"workbook_sha256":"f691296d995865d3dbb00f14314e1328d77040def825700ed02b9705c9bbdbd2","checked_at":"2026-08-17T19:33:31.020367+00:00"},"conventions":{"arv":"After-repair value = equal-weighted average of 2-5 comparable sales.","loan_sizing":"loan = min(arv_cap x ARV, ltc_cap x purchase + repairs). Either cap may be null. The binding cap is reported as loan_basis.","backward_solve":"Max purchase price is solved so net profit equals the target; the more conservative (lower) of the two cap cases is selected.","cost_waterfall":"Repairs x (1+contingency); financing = points + interest x (hold_months/12) on the loan; carry = monthly_expenses x hold_months; buy closing on purchase; sell closing on ARV.","irr":"Annualised via the composed XIRR engine (ACT/365) on the actual close date and EOMONTH(close, hold_months) exit date — identical convention to the standalone XIRR agent."},"tolerances":{"cash":0.5,"irr":0.01,"moic":0.01},"cases":[{"id":"fixflip_ltc_binds","status":"pass","source":{"workbook":"fix_flip.xlsx","sha256":"f691296d995865d3dbb00f14314e1328d77040def825700ed02b9705c9bbdbd2","cells":"E13 ARV, E28 max PP (=(E13-E23)/(1+D26)), G7 loan (MIN of caps), K30 equity, cost cells; K27 XIRR, K28/K29 MOIC/CoC","note":"Max PP and loan use the exact backward-solve convention (divide by 1+buy_closing); profit reconciles to 30,000 exactly."}},{"id":"fixflip_arv_binds","status":"pass","source":{"workbook":"fix_flip_arv.xlsx","sha256":"e7038f2cd95bee0fc146dc5514bc44870df2f22a1ce3c873caf5b007775f7bc2","cells":"same layout as base; F5 (% ARV) = 0.65 so G5 (ARV cap) < G6 (LTC cap) and G7 = ARV cap","note":"ARV binds; loan = 65% of ARV. Confirms the binding-constraint selection and label on the ARV branch."}}]}