Tabellab

Bonds and fixed income courses

Bond maths looks intimidating until you build it in a spreadsheet.

Bonds & Fixed Income courses (9)

$9.90Intermediate

Bond Ladders for Income: Building Rungs, Reinvestment & Cash-Flow Matching

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

Corporate Treasury: Cash Pooling, Intercompany Netting & Liquidity Forecasting

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

Credit Spreads & CDS Basics: Hazard Rates, Spreads & Default Probabilities

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

Convertible Bonds: Conversion Value, Premium, Bond Floor & Dilution

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

Inflation-Linked Bonds by Hand: Index Ratios, Adjusted Principal, Real Yields, Breakeven Inflation & Deflation Floors

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

Fixed Income & Bond Analytics

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

Green Bonds & Sustainable Finance: Use of Proceeds, Greenium & Impact Metrics

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

Municipal Bonds: Tax-Equivalent Yield, Credit & Call Risk

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

Treasury, Cash & FX Risk Management

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

Bond maths looks intimidating until you build it in a spreadsheet. These courses cover price and yield, ladders for steady income, tax-equivalent yields on municipal bonds, the floor and dilution of convertibles, real yields on inflation-linked bonds and credit spreads. A treasury course adds the cash and currency side. You calculate everything yourself, so each concept stays visible rather than hidden inside a calculator.

This topic hub gathers 9 Bonds & Fixed Income courses from Finance, Investing: 6 intermediate, 3 advanced. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: bond yield to maturity excel; bond ladder excel; municipal bond tax equivalent yield; convertible bond valuation.

Frequently asked questions

Which Bonds & Fixed Income course should I start with?

Start with “Fixed Income & Bond Analytics”. It is the most central course in this topic at intermediate level. Then move on to the more specialised courses in the list above.

How much do the Bonds & Fixed Income courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the Bonds & Fixed Income courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses