The cash-flow lab.
Build the assumptions. Account for every dollar. Explain who gets paid.
Save retains your model and progress in this browser. Exports can be opened in a spreadsheet or text editor.
Every dollar. Every period.
Select a cell to trace its calculation. Play the timeline to watch cash move.
| ACash-flow line | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
From receipts to repayment.
Collections through time
USD MILLIONSCollateral & note run-off
USD MILLIONSWhere this month’s cash goes
Class A and B share principal pro rata; 5a and 5b have the same priority. Widths show the allocation share. A payoff reserve release is included in total sources and reaches the residual after obligations are settled.
Make a change.
Explain the consequence.
Start with the
borrower.
A homogeneous fixed-rate pool makes each assumption visible. Balances are dollars, rates are annual percentages, and time steps are months.
Convert CPR to SMM.
At 12% annual CPR, enter the monthly prepayment rate as a percentage, to two decimals.
Legal final M48
See the cash evolve.
Payment date 01
PRO-RATA PRINCIPALAsset engine · from assumptions to collections
Opening performing pool$100,000,000
Prior month’s closing performing principal.
Requested defaults$474,208
Opening principal × a calibrated monthly hazard. The hazard scale is solved so total defaults equal the lifetime target under this CPR and timing curve.
Applied defaults$474,208
Monthly conditional default rate 0.47%. Limited to principal still outstanding at the start of this month.
Collected interest$1,575,825
Surviving principal × asset APR ÷ 12. Defaulted loans stop paying immediately in this lab.
Scheduled principal$2,072,394
For monthly rate r and remaining months n, payment = surviving balance × r / [1 − (1 + r)^(-n)]. Scheduled principal = payment − interest. At zero interest, divide surviving principal by n.
Prepayments$1,032,640
SMM × surviving balance after scheduled principal. SMM = 1 − (1 − CPR)^(1/12).
Recovery receipts$0
Defaults from the recovery-lag month × base recovery × (1 − haircut).
Closing performing pool$96,420,758
Opening − applied defaults − scheduled principal − prepayments.
Cash to waterfall$4,680,859
Interest + scheduled principal + prepayments + received recoveries.
Live trigger monitor
0.47% vs 8.00% limit
6.74% vs 0.00% minimum
3.00% vs 8.00% limit
CNL uses original pool balance. Spread uses the sum of opening balances over up to three months. A latched trigger stays active after a test recovers.
Payment waterfall · cash in, cash out
Excess spread · cash, credit cost and release
Cash spread is the interest margin. The test deducts credit losses and annualizes over the observation window. Residual cash also reflects principal, OC, reserve funding and trigger rules, so it can differ from either spread measure.
Credit support · OC, liquidity and note shortfalls
Normal principal requirement = opening notes − max(0, closing pool − fixed OC target), floored at zero. A trigger makes all outstanding note principal eligible for available cash. Reserve replenishment comes first. Class A WAL 1.25 years. Class B WAL 1.25 years.
Full monthly ledger · 48 payment dates
| Month | Pool | Defaults | Recoveries | A principal | B principal | Reserve | Residual |
|---|---|---|---|---|---|---|---|
| $96.42m | $0.47m | $0.00m | $2.98m | $0.60m | $1.00m | $0.56m | |
| $92.90m | $0.46m | $0.00m | $2.94m | $0.59m | $1.00m | $0.54m | |
| $89.42m | $0.44m | $0.00m | $2.89m | $0.58m | $1.00m | $0.53m | |
| $86.00m | $0.42m | $0.00m | $2.85m | $0.57m | $1.00m | $0.51m | |
| $82.64m | $0.41m | $0.00m | $2.81m | $0.56m | $1.00m | $0.49m | |
| $79.32m | $0.39m | $0.00m | $2.76m | $0.55m | $1.00m | $0.47m | |
| $76.05m | $0.38m | $0.06m | $2.72m | $0.54m | $1.00m | $0.51m | |
| $72.84m | $0.36m | $0.05m | $2.68m | $0.54m | $1.00m | $0.49m | |
| $69.67m | $0.35m | $0.05m | $2.64m | $0.53m | $1.00m | $0.48m | |
| $66.55m | $0.33m | $0.05m | $2.60m | $0.52m | $1.00m | $0.46m | |
| $63.47m | $0.32m | $0.05m | $2.56m | $0.51m | $1.00m | $0.44m | |
| $60.44m | $0.30m | $0.05m | $2.52m | $0.50m | $1.00m | $0.42m | |
| $57.46m | $0.29m | $0.05m | $2.48m | $0.50m | $1.00m | $0.40m | |
| $54.52m | $0.27m | $0.04m | $2.45m | $0.49m | $1.00m | $0.39m | |
| $51.63m | $0.26m | $0.04m | $2.41m | $0.48m | $1.00m | $0.37m | |
| $48.78m | $0.24m | $0.04m | $2.37m | $0.47m | $1.00m | $0.35m | |
| $45.98m | $0.23m | $0.04m | $2.34m | $0.47m | $1.00m | $0.34m | |
| $43.21m | $0.22m | $0.04m | $2.30m | $0.46m | $1.00m | $0.32m | |
| $40.49m | $0.20m | $0.03m | $2.27m | $0.45m | $1.00m | $0.31m | |
| $37.81m | $0.19m | $0.03m | $2.23m | $0.45m | $1.00m | $0.29m | |
| $35.17m | $0.18m | $0.03m | $2.20m | $0.44m | $1.00m | $0.28m | |
| $32.57m | $0.17m | $0.03m | $2.17m | $0.43m | $1.00m | $0.26m | |
| $30.00m | $0.15m | $0.03m | $2.14m | $0.43m | $1.00m | $0.24m | |
| $27.48m | $0.14m | $0.03m | $2.10m | $0.42m | $1.00m | $0.23m | |
| $25.00m | $0.13m | $0.02m | $2.07m | $0.41m | $1.00m | $0.22m | |
| $22.55m | $0.12m | $0.02m | $2.04m | $0.41m | $1.00m | $0.20m | |
| $20.14m | $0.11m | $0.02m | $2.01m | $0.40m | $1.00m | $0.19m | |
| $17.76m | $0.10m | $0.02m | $1.98m | $0.40m | $1.00m | $0.17m | |
| $15.42m | $0.08m | $0.02m | $1.95m | $0.39m | $1.00m | $0.16m | |
| $13.12m | $0.07m | $0.02m | $1.92m | $0.38m | $1.00m | $0.15m | |
| $10.85m | $0.06m | $0.02m | $1.89m | $0.38m | $1.00m | $0.13m | |
| $8.61m | $0.05m | $0.01m | $0.71m | $0.14m | $0.00m | $2.51m | |
| $6.41m | $0.04m | $0.01m | $0.00m | $0.00m | $0.00m | $2.30m | |
| $4.24m | $0.03m | $0.01m | $0.00m | $0.00m | $0.00m | $2.25m | |
| $2.10m | $0.02m | $0.01m | $0.00m | $0.00m | $0.00m | $2.19m | |
| $0.00m | $0.01m | $0.01m | $0.00m | $0.00m | $0.00m | $2.13m | |
| $0.00m | $0.00m | $0.01m | $0.00m | $0.00m | $0.00m | $0.01m | |
| $0.00m | $0.00m | $0.01m | $0.00m | $0.00m | $0.00m | $0.01m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | |
| $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m | $0.00m |
Fixed-rate, homogeneous, amortizing pool. Defaults occur before interest and scheduled payments. Recoveries arrive in one delayed receipt. Default timing vectors are illustrative. Notes accrue unpaid interest without interest-on-interest. Legal final is term plus 12 months. See the full methods, trigger catalogue and research trail.
Explore methods & sources ↗