THE BETTER MOUSE TRAP CO. · COMPLETED METHOD RECORD
Receivables aging — isolated accounting exercise
Scope: standalone synthetic teaching exercise for Receivables aging. All monetary inputs are invented example figures; no own-product offer, company finances or real transaction is asserted.
As of June 30 · synthetic invoices; no real sales implied
| Invoice / customer | Due date | Amount USD | Days overdue / bucket | Action / owner |
|---|---|---|---|---|
| EX-101 / Sample Retail A | June 30 | 2000 | 0 / current | Alex: confirm receipt July 01 |
| EX-102 / Sample Retail B | June 15 | 1500 | 15 / 1–30 | Alex: reminder sent June 30 |
| EX-103 / Sample Retail C | May 15 | 1000 | 46 / 31–60 | Alex: dispute reconciled June 30; revised statement |
| EX-104 / Sample Retail D | April 15 | 500 | 76 / 61–90 | Alex: payment plan agreed June 30 |
| EX-105 / Sample Retail E | March 01 | 500 | 121 / over 90 | Alex: hold further credit June 30 |
Aging and capital
| Measure | Completed calculation |
|---|---|
| Total / buckets | $5500 = current 2000 + 1–30 1500 + 31–60 1000 + 61–90 500 + over90 500 |
| Allowance illustration | 1%×2000 + 3%×1500 + 10%×1000 + 25%×500 + 50%×500 = $540 |
| Working capital | Current assets $15000 − current liabilities $6000 = $9000; $5500 receivables included once, not added again. |
| Review | Ira reconciled total; Alex signed June 30. Separate teaching ledger, not historical BMT cash or orders. |
Cash conversion cycle · separate synthetic teaching ledger
| Input / formula | Calculation / decision |
|---|---|
| Period / bases | 365 days; annual credit sales 73000; annual cost of sales 43800; average receivables 6000, inventory 3600, payables 2400. Averages differ from the June 30 point-in-time aging balance. All figures invented for this exercise. |
| DSO | 6000 / 73000 ×365 = 30 days |
| DIO | 3600 / 43800 ×365 = 30 days |
| DPO | 2400 / 43800 ×365 = 20 days |
| Input / formula | Calculation / decision |
|---|---|
| CCC | DIO 30 + DSO 30 − DPO 20 = 40 days. Reduce collection and stock days while honoring supplier terms; no company cash forecast or actual financing claim. |
| Review | Ira recomputed June 20; Alex signed June 25. An aging snapshot cannot substitute for average balances in CCC. |
Arithmetic and assumptions checked: Ira Bell, 2027-06-20. Exercise reviewed and signed: Alex Meadow, 2027-06-30. Disposition: teaching example accepted; no spending, credit or commercial authority.
Compare the reference example. Teaching data and signed dispositions: D1 scenario register.