🪜$9.90Intermediate
Design an equal-rung ladder, map coupons and maturities year by year, weight maturity and yield with SUMPRODUCT, roll the ladder at new rates, fund planned expenses by cash-flow matching, compare barbell, ladder and bullet, protect real income, compare a ladder with a bond fund, then go further: a semiannual income calendar, CD APYs and break penalties, gap and concentration audits, premium and discount rungs, curve shapes, rate-path scenarios, early sales, a spending runway, coupon reinvestment, data checks and a dashboard project: 20 hands-on labs, every cell checked live. Fictional bonds and CDs, educational only, not investment advice.
20 lessons · 20 labs
🔄$9.90Advanced
Run the in-house bank of a fictional group with five subsidiaries in USD, EUR and GBP across 20 hands-on labs: stand-alone vs notional pool interest, zero-balancing and target-balance sweeps, IC loan pricing, pool limits and benefit allocation, a multilateral netting matrix with exceptions, currency netting and FX slippage, bank account and counterparty reviews, a payment factory, a 13-week forecast, revolver headroom and a half-year treasury dashboard, every cell checked as you go. Illustrative rates, educational only.
20 lessons · 20 labs
🛡️$9.90Advanced
Yield spreads and the Z-spread, the credit triangle, hazard rates and bootstrapped hazard curves, CDS premium and protection legs with accrued premium, fair spreads and upfronts, mark-to-market, CS01 hedges, jump-to-default, index spreads, auction settlement, carry and roll-down, risky bond pricing and stress tests: 20 labs on fictional issuers. Educational and simplified, not affiliated with ISDA.
20 lessons · 20 labs
🔁$9.90Advanced
Conversion ratio and parity, conversion premium and payback, the bond floor with PV and PRICE, the payoff chart, bond + Black-Scholes valuation, the issuer’s cost and liability/equity split, dilution, calls and puts, then accrued interest, yield to put, delta and gamma, delta-hedged P&L, busted convertibles, anti-dilution adjustments, net share settlement, mandatory convertibles, a binomial tree, a fund screen, make-whole tables and a final dashboard: 20 labs on fictional issuers (educational, not investment advice).
20 lessons · 20 labs
📈$9.90Intermediate
Understand bonds that grow with prices across 20 hands-on labs. You will build index ratios from a fictional price index with a lag, adjust principal and coupons, price the bond from a real yield, compare it with a nominal bond through breakeven inflation, test deflation floors and inflation scenarios, then add accrued interest, inflation rates from the index, projected cash flows, index carry, real duration and DV01, yield beta hedges, forward breakevens, a look back at realised inflation, taxes on the uplift, inflation swaps, capped pension liabilities and a portfolio dashboard, with every cell checked as you go.
20 lessons · 20 labs
🏛$9.90Intermediate
Price bonds from their cash flows, solve yields, accrued interest, spot and forward rates, duration, convexity and immunisation, then go further with price–yield curves, PRICE and YIELD on real dates, bootstrapping, rich/cheap analysis, call and floating-rate features, credit spreads, effective duration, curve scenarios, holding-period returns, pension liabilities and a portfolio risk report, in 20 hands-on labs with every cell checked. Educational only, not investment advice.
20 lessons · 20 labs
🌿$9.90Intermediate
20 hands-on labs: price a green bond against its twin, back out yields with RATE, interpolate a twin yield, track use of proceeds, look-back periods, pool coverage and eligibility screens, compute avoided emissions and negative carry, model sustainability-linked coupons and a loan margin ratchet, measure WACI and financed emissions, and finish with a programme dashboard, every cell checked instantly. Fictional issuers, educational only, not investment advice.
20 lessons · 20 labs
🏙️$9.90Intermediate
Tax-equivalent yield with federal and state rates, the break-even tax bracket, YTM, YTC and yield to worst with RATE, GO vs revenue coverage, credit spreads, the de minimis rule, dollar prices to worst, 30/360 accrued interest, negative convexity, rate shocks, muni fund TEY, revenue bond stress tests, a GO credit screen, effective duration and convexity, credit-loss-adjusted TEY, tax-loss swaps and an income calendar dashboard: 20 hands-on labs, every cell checked live. Fictional issuers, illustrative tax rates, educational only, not investment or tax advice.
20 lessons · 20 labs
🏦$9.90Intermediate
Cash positions, short-term forecasts, working capital, cash pooling, FX exposure, forwards, options and interest-rate swaps, then bank FX quotes, layered hedging, budget FX sensitivity, forecast accuracy, surplus-cash policy, bank limits and fees, receivables financing, revolver costs, debt maturities, covenants and a board dashboard, practised in 20 hands-on labs with every cell checked instantly.
20 lessons · 20 labs