Excel Calculators
Swap Breakage Calculator Excel Template
Calculate interest rate swap breakage costs for project finance refinancing. Includes per-period breakdown and bullet/amortizing...
Corporate Finance
Annual Debt Service Cover Ratio (ADSCR) Calculator Excel Template
Calculate period-by-period ADSCR for project finance debt analysis. Includes covenant breach detection and headroom tracking.
Corporate Finance
Debt Average Life Calculator Excel Template
Calculate weighted average life (WAL) for project finance debt. Enter construction draws and repayments to...
Corporate Finance
Debt Sculpting Tool Excel Template
Project finance debt sculpting template with DSCR-targeted principal repayments, grace periods, and balloon analysis.
Excel Calculators
Variance Swap Calculator Excel Template
Educational Excel template for variance swap fair strikes using a simplified approximation. Enter ATM vol,...
Excel Calculators
Binary Option Calculator Excel Template
Calculate cash-or-nothing and asset-or-nothing option prices using Black-Scholes. Includes invariant checks and vanilla option references.
Excel Calculators
Implied Repo Rate Calculator Excel Template
Professional implied repo rate Excel template with editable market rate, scalable P&L, and automatic basis...
Excel Calculators
Sell/Buy-Back Repo Calculator Excel Template
Calculate forward prices, termination proceeds, and nominal amounts for sell/buy-back repo transactions with live Excel...
Excel Calculators
Dollar Roll Calculator Excel Template
Calculate MBS dollar roll implied financing rates, compare roll vs repo costs, and analyze financing...
Excel Calculators
Crush Spread Calculator Excel Template
Crush Spread Calculator Excel template for analyzing soybean processing margins using the board crush formula.
Excel Calculators
FX Cross Rate Calculator Excel Template
Calculate implied FX cross rates via triangulation. Enter two currency quotes sharing a common pivot...
Excel Calculators
Market Concentration and HHI Calculator Excel Template
Calculate HHI, CR4, CR8, and effective firms with live Excel formulas. Uses 2023 DOJ/FTC Merger...