Tabellab

Loans, credit and debt courses

Whether you are borrowing, lending or pricing risk, the same structures repeat: a payment schedule, an interest rate, a probability of default.

Loans, Credit & Debt courses (19)

$9.90Intermediate

The Effective Interest Method: Amortised Cost Schedules for Loans & Bonds with Fees, Discounts, Premiums and Changed Cash Flows

See why interest in the books differs from the coupon in 20 hands-on labs: effective rates from all cash flows including fees, amortised cost schedules for loans and bonds at a discount or premium, catch-up adjustments, then amortising and half-yearly loans, year-end accruals, XIRR for uneven dates, credit-impaired interest, the 10 % modification test, bond sales, a loan register, an audit re-performance and below-market loans – every cell checked instantly.

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.90Intermediate

Consumer Credit Math: Credit Cards, APR, Minimum Payments & BNPL

Turn APR into daily interest on the average daily balance, test grace periods, build minimum-payment schedules, compare avalanche vs snowball, balance transfers, BNPL and personal loans – then go further with daily compounding, payment allocation, cash advances, deferred interest, penalty APRs, DTI, consolidation, 0% offers, short-term fees, rewards and a final household dashboard. 20 hands-on labs, every cell checked as you go. Educational, illustrative rates, not financial advice.

20 lessons · 20 labs

$9.90Intermediate

Credit & Risk Analysis

Score a borrower, calculate leverage, DSCR and debt capacity, test covenants, build a borrowing base and price the risk, then go further with adjusted EBITDA, peer benchmarks, a 13-week cash forecast, stress tests, maturity ladders, recovery waterfalls, a watchlist, a credit memo, fixed-charge coverage, rate shocks, customer concentration and quarterly LTM covenant tests, in 20 hands-on labs where every cell is checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Credit Card Issuer Economics: Interchange, Revolve Rates, Losses & Rewards Cost

Run the P&L of a fictional card issuer across 20 hands-on labs: active rate and spend per account, interchange by category, revolving balances and net interest margin, fees, charge-offs and provisions, rewards cost with breakage, profit of transactors vs revolvers and the lifetime value of a new account – then balance transfer offers, roll rates and vintage curves, credit line increases, capped rewards and co-brand deals, efficiency and risk-adjusted margin, ROE, APR scenarios, debt sales, a benchmark and a 2027 plan – every cell checked as you go.

20 lessons · 20 labs

$9.90Advanced

Credit Risk Modeling: PD, LGD, EAD & Expected Credit Loss

Expected loss on a loan book, EAD with conversion factors, LGD from collateral and recoveries, migration matrices to cumulative PD, 12-month vs lifetime ECL with scenarios, IFRS 9 staging, a logistic scorecard and portfolio coverage, then forward-looking scenario PDs, amortising EAD with prepayments, survival curves, workout LGD with cure rates, roll rates, vintage curves, PD backtesting, the allowance roll-forward, concentration limits, RAROC pricing, net charge-offs and a final staging dashboard: 20 labs on one bank's book, every cell checked instantly.

20 lessons · 20 labs

$9.90Advanced

Credit Scorecards: Weight of Evidence, Information Value & Points Scaling

Coarse classing, WoE, Information Value, monotonic bins, points with factor/offset and PDO, scoring applicants, cut-off strategy and population stability, then missing and zero-bad classes, categorical grouping, correlation screening, KS and Gini, reject inference, recalibration, reason codes, overrides, profit-based cut-offs, swap sets, an implied-PDO check and a quarterly review dashboard: 20 hands-on labs on one fictional lender's synthetic applications, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Loan Amortization Schedules in Excel: PMT, IPMT, PPMT, Extra Payments & Balloons

Build real amortization schedules step by step: PMT and the sign convention, a full schedule copied down to zero, IPMT/PPMT and CUMIPMT/CUMPRINC, extra payments, lump sums and recasting, balloon and interest-only loans, an APR comparison, then payment dates and calendar-year interest, rounded cents, PV/NPER targets, biweekly plans, actual/365 interest, rate resets, payment holidays, schedule audits, current vs non-current portions, sensitivity grids, prepayment plans and a payoff dashboard. 20 hands-on labs, every cell checked. Educational only, not financial advice.

20 lessons · 20 labs

$9.90Advanced

Mortgage-Backed Securities by Hand: Pool Cash Flows, Prepayment Speeds, Servicing Strips, Weighted Average Life & Price Scenarios

Build a fictional mortgage pool's cash flows month by month across 20 hands-on labs: scheduled payments, prepayment speeds, pass-throughs, average life and price, then loan tapes, defaults and delinquencies, IO/PO strips, yields and spreads, PAC, floater and senior/subordinate tranches and a portfolio dashboard, with every cell checked instantly.

20 lessons · 20 labs

$9.90Advanced

Interest Rate Swaps: Pricing, Valuation, DV01 & Hedging

Swap cash flows and day counts, bootstrapping, forward rates, the par swap rate, mark-to-market, DV01 and hedging with a swap or a cap, then off-grid interpolation, projected floating legs, off-market and seasoned swaps, key-rate DV01, rate shocks, amortising and bond swaps, a swap book, collateral calls and a hedge dashboard: 20 hands-on labs on an illustrative single curve, every cell checked instantly. Educational only, not investment advice.

20 lessons · 20 labs

$9.90Advanced

Bank Loan Pricing: Funding Cost, Expected Loss, Capital & RAROC

Build a loan rate from funding, cost, expected loss, capital and margin, then go further: revolvers, parent support, lifetime and after-tax RAROC, stress grids, diversified capital, ratchets and syndication in 20 hands-on labs, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Microfinance & Small-Loan Math: Flat vs Declining Rates, APR & Portfolio Quality

Price small loans the honest way in 20 hands-on labs: flat vs declining balance, APR and EIR with fees and savings, grace periods, harvest loans with IRR, product comparisons, early payoff, PAR30/PAR90 with restructured loans, provisions, branch and trend views, funding and currency risk, repayment capacity and the yield an MFI needs, every cell checked live.

20 lessons · 20 labs

$9.90Intermediate

Mortgage Refinancing Math: Break-Even, Points, Cash-Out & ARMs

Decide a refinance from the borrower's side, number by number: the remaining balance with CUMPRINC and CUMIPMT, new payments by term, closing costs and the break-even month, points vs lender credits, the term-extension trap, a cash-out refinance with its LTV, ARM resets with 2/2/5 caps and an NPV decision table, then financed closing costs, the effective rate over your stay, recast vs refinance, dropping mortgage insurance, the break-even rate, a break-even heat map, a blended rate with a home-equity line, prepayment penalties, sunk costs, lock-or-wait scenarios, a quote audit and a final decision dashboard – 20 labs on fictional households' loans, every cell checked instantly. Illustrative rates, educational only, not financial advice.

20 lessons · 20 labs

$9.90Intermediate

Mortgage & Loan Underwriting Math

Work through one home loan file and then a whole pipeline: payment and amortization, PITI, LTV, mortgage insurance, qualifying income, DTI, APR and points, refinance, cash to close, bank-statement assets, self-employed and rental income, credit-report debts, stress tests, extra payments, escrow analysis, buydowns and equity build-up, ending in an underwriting summary dashboard – 20 hands-on labs with every cell checked instantly. Educational only, not financial advice.

20 lessons · 20 labs

$9.90Intermediate

P2P Lending & Crowdfunding Returns: Defaults, Diversification & Net Yield

Build a loan-grade rate card, model an amortising note with PMT, price expected loss by grade, get from gross interest to net yield, measure diversification with BINOM.DIST, compute IRR and XIRR, value recoveries, then go further: cash drag, vintage curves, roll rates, secondary-market pricing, prepayments, provision funds, concentration, auto-invest rules, real-estate LTV, stress scenarios and a final dashboard, in 20 hands-on labs, every cell checked live. Fictional platform, educational only, not investment advice.

20 lessons · 20 labs

$9.90Intermediate

Revenue-Based Financing & Venture Debt: Caps, Repayment Rates and True Cost

Model RBF caps and revenue shares, build repayment schedules, find the true annual cost with IRR, test growth, structure venture debt, compare equity and merchant cash advances, then go further: payment floors and true-ups, seasonal burden, remittance checks, early payoff, covenants, stacking, the provider's portfolio, a financing dashboard, MRR forecasts with churn and expansion, CAC payback of RBF-funded marketing, cap pricing for a target return and a cash runway under base and downside revenue. 20 hands-on labs, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Student Loan Repayment Math: Standard, Graduated & Income-Based Plans

20 hands-on labs: accrue and capitalise interest, price the standard plan with PMT, solve a graduated plan, model income-driven payments, household size and forgiveness, count qualifying payments, test extra payments, pauses and avalanche vs snowball, weigh fees, refinancing and variable rates, and finish with a full repayment dashboard, every cell checked. Illustrative rules, check your servicer. Not financial advice.

20 lessons · 20 labs

$9.90Intermediate

Venture Debt: Term Sheets, Warrant Coverage, Runway & Effective Cost

Turn a venture debt term sheet into payments and runway, size warrants, find the all-in cost with IRR and XIRR, compare dilution with equity, test covenants and model a default, then go further: milestone-based Tranche B draws, floating rates with floors, prepayment payoffs, interest by fiscal year, probability-weighted warrant value, quick-ratio covenants, lender sizing rules, a lender's portfolio, runway sensitivity grids, negative carry, sale-of-company payouts and a term-sheet dashboard: 20 hands-on labs with a fictional startup and lender. Educational only, not financial advice.

20 lessons · 20 labs

Whether you are borrowing, lending or pricing risk, the same structures repeat: a payment schedule, an interest rate, a probability of default. These courses range from personal topics such as amortization, mortgage refinancing and student loan repayment, to professional ones such as credit scorecards, expected credit loss, loan pricing and private credit deals. Each lab is a worked spreadsheet so you can see how fees, rates and defaults change the real cost or return.

This topic hub gathers 19 Loans, Credit & Debt courses from Finance, Real Estate, Accounting, Excel: 12 intermediate, 7 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: loan amortization schedule excel; mortgage refinance calculator; student loan repayment excel; credit risk model excel.

Frequently asked questions

Which Loans, Credit & Debt course should I start with?

Start with “Loan Amortization Schedules in Excel”. 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 Loans, Credit & Debt 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 Loans, Credit & Debt 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