THE BETTER MOUSE TRAP CO. · COMPLETED METHOD RECORD

Receivables aging — isolated accounting exercise

DocumentBMT-RECEIVABLES-AGING-AND-WORKING-CAPITAL-D1
Revision / review dateD1 · 2027-06-30
Accountable ownerAlex Meadow

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 / customerDue dateAmount USDDays overdue / bucketAction / owner
EX-101 / Sample Retail AJune 3020000 / currentAlex: confirm receipt July 01
EX-102 / Sample Retail BJune 15150015 / 1–30Alex: reminder sent June 30
EX-103 / Sample Retail CMay 15100046 / 31–60Alex: dispute reconciled June 30; revised statement
EX-104 / Sample Retail DApril 1550076 / 61–90Alex: payment plan agreed June 30
EX-105 / Sample Retail EMarch 01500121 / over 90Alex: hold further credit June 30

Aging and capital

MeasureCompleted calculation
Total / buckets$5500 = current 2000 + 1–30 1500 + 31–60 1000 + 61–90 500 + over90 500
Allowance illustration1%×2000 + 3%×1500 + 10%×1000 + 25%×500 + 50%×500 = $540
Working capitalCurrent assets $15000 − current liabilities $6000 = $9000; $5500 receivables included once, not added again.
ReviewIra reconciled total; Alex signed June 30. Separate teaching ledger, not historical BMT cash or orders.

Cash conversion cycle · separate synthetic teaching ledger

Input / formulaCalculation / decision
Period / bases365 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.
DSO6000 / 73000 ×365 = 30 days
DIO3600 / 43800 ×365 = 30 days
DPO2400 / 43800 ×365 = 20 days
Input / formulaCalculation / decision
CCCDIO 30 + DSO 30 − DPO 20 = 40 days. Reduce collection and stock days while honoring supplier terms; no company cash forecast or actual financing claim.
ReviewIra 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.