Skip to content
← Rassy’s homeTHE STRUCTURED FINANCE READING ROOM
NAASSET-BACKED
SECURITIES
LEARN BY BUILDING
← Field guide
UNSECURED CONSUMER / GUIDED MODEL BUILDER

The cash-flow lab.

Build the assumptions. Account for every dollar. Explain who gets paid.

0 / 5CHECKPOINTS COMPLETED
ILLUSTRATIVE DEAL · MONTHLY MODEL

Save retains your model and progress in this browser. Exports can be opened in a spreadsheet or text editor.

One model · linked calculations
THE PERIOD-BY-PERIOD WORKSPACE

Every dollar. Every period.

Select a cell to trace its calculation. Play the timeline to watch cash move.

Final net loss7.04%
Class A unpaid$0.00m
Class B unpaid$0.00m
Lifetime residual$22.32m
PAYMENT DATEM01
Pro rata
Performance tests currently pass
Assets!B10ƒx

Interest + scheduled principal + prepayments + received recoveries

Assets cash-flow workbook. Monetary values in millions of dollars. Parentheses denote negative values.
ACash-flow line

Pin a case, change an assumption, and inspect the change in every period. The pinned comparison lasts while this workbook remains open.

FOLLOW THE CASH

From receipts to repayment.

Collections through time

USD MILLIONS
InterestScheduledPrepaidRecovery
0.0m2.3m4.7mMonth 1. Collections $4,680,859.Month 2. Collections $4,587,332.Month 3. Collections $4,495,227.Month 4. Collections $4,404,524.Month 5. Collections $4,315,201.Month 6. Collections $4,227,237.Month 7. Collections $4,197,516.Month 8. Collections $4,110,171.Month 9. Collections $4,024,155.Month 10. Collections $3,939,446.Month 11. Collections $3,856,025.Month 12. Collections $3,773,873.Month 13. Collections $3,692,970.Month 14. Collections $3,613,296.Month 15. Collections $3,534,833.Month 16. Collections $3,457,563.Month 17. Collections $3,381,467.Month 18. Collections $3,306,528.Month 19. Collections $3,232,727.Month 20. Collections $3,160,047.Month 21. Collections $3,088,472.Month 22. Collections $3,017,983.Month 23. Collections $2,948,566.Month 24. Collections $2,880,202.Month 25. Collections $2,812,877.Month 26. Collections $2,746,573.Month 27. Collections $2,681,277.Month 28. Collections $2,616,971.Month 29. Collections $2,553,642.Month 30. Collections $2,491,273.Month 31. Collections $2,429,851.Month 32. Collections $2,369,361.Month 33. Collections $2,309,789.Month 34. Collections $2,251,120.Month 35. Collections $2,193,341.Month 36. Collections $2,136,439.Month 37. Collections $7,464.Month 38. Collections $6,173.Month 39. Collections $4,901.Month 40. Collections $3,648.Month 41. Collections $2,413.Month 42. Collections $1,198.Month 43. Collections $0.Month 44. Collections $0.Month 45. Collections $0.Month 46. Collections $0.Month 47. Collections $0.Month 48. Collections $0.M1M48
M1 · $4.68mUse the timeline to inspect each column.

Collateral & note run-off

USD MILLIONS
Performing poolClass AClass B
0m50m100mM1M48
M1 · OC $10.00mCollateral less outstanding A and B notes.
PAYMENT DATE 1

Where this month’s cash goes

$0 reconciliation difference
+
CASH TO ALLOCATE · M1$4.68m↓ Priority of payments

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.

THREE WAYS TO GO DEEPER

Make a change.
Explain the consequence.

Model conventions are part of the lesson.

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 ↗