Projects

A seven-exhibit LBO reconstruction of the announced Grant Thornton / New Mountain take-private of CBIZ (NYSE: CBZ) at $55.00/share, $5.0bn enterprise value. Base case: 1.91x MOIC, 17.3% sponsor-net IRR over a 4.05-year hold — three-quarters of it from EBITDA growth, 40% from deleveraging, next to nothing from multiple expansion. A three-case toggle also runs a Downside (10.4% IRR) and a Stress case where the deal loses money (0.84x MOIC). The Benefits & Insurance carve-out that’s part of the real deal isn’t in the model at all, and that gap — which the 10-K’s segment data suggests understates rather than overstates the problem — is the most interesting thing about it.

Antitrust and confidentiality rules mean buy-side M&A analysts often can’t legally see a target’s raw financials before close — the standard fix is an expensive, slow outside clean-room engagement. This project replaces it: a self-hosted pipeline that tokenizes a target’s GL, gates analyst access behind a leak scan and a trial-balance check, and renders a one-page diligence tear sheet — EBITDA bridge, DSO/DPO/DIO, customer/vendor HHI — reproducible on the next deal for the cost of a server instead of a consulting engagement.

Two raw CSVs, one silent date-parsing trap that would have corrupted 61% of the data, a star-schema model, and 11 DAX measures — the full build of a Power BI Sales Performance dashboard, end to end, with before/after evidence at every cleaning step.

Un environnement de recherche quantitative pour la Bourse de Casablanca : thèse d’investissement et analyse fondamentale d’Akdital et Attijariwafa Bank, simulation de Monte-Carlo (1000 trajectoires) et Value at Risk à 95 % sur une allocation multi-actifs réelle.

Modèle à trois états financiers entièrement lié et valorisation DCF d’Akdital S.A., premier groupe de santé privée coté au Maroc — avec un audit documenté qui a corrigé les hypothèses de capex, la structure du WACC et l’horizon de valeur terminale.