Pinned Loading

1. EA-LBO-analysis EA-LBO-analysis Public

   LBO analysis of the $55bn EA take-private: sources and uses, the six-tranche debt package, cash sweep, sponsor returns and ability to pay, in Python and Excel.

   Jupyter Notebook

2. Monte-Carlo-dcf-valuation Monte-Carlo-dcf-valuation Public

   Probabilistic DCF in Excel: six assumptions as distributions, 50,000 simulations, investment memo and a live browser simulator.

   Jupyter Notebook

3. SP500-hedging-analysis SP500-hedging-analysis Public

   Arbitrage-free S&P 500 volatility surface rebuilt daily from real SPY option quotes (Jan to Jun 2025), used to price and judge a collar hedge ahead of the April 2025 tariff shock.

   HTML

4. Spacex-IPO-valuation Spacex-IPO-valuation Public

   SpaceX IPO case study: sum-of-the-parts of Starlink, Space and xAI, offering analysis and back-test against the $135 IPO price, in Python and Excel.

   Jupyter Notebook

5. Boeing-spirit-merger-analysis Boeing-spirit-merger-analysis Public

   Boeing–Spirit collar priced as options on Boeing's real implied vol surface: value at signing, a better band, merger-arbitrage spread and the check at the December 2025 closing. Interactive page, C…

   Jupyter Notebook

6. Mergers-and-acquisitions-long-run-performance Mergers-and-acquisitions-long-run-performance Public

   Does M&A create value? Long-run performance of 786 US acquisitions completed from 2012 to 2021: buy-and-hold abnormal returns, Fama-French calendar-time alphas, operating performance and goodwill i…

   HTML