FP&A collections forecast case
Turn opening receivables and next-month sales into actual cash collections using bucket-specific assumptions.
Wall Street Playbook ·
Worked case
Opening accounts receivable is $500,000 current, $300,000 at 1–30 days past due, and $200,000 older. Forecast monthly collection rates of 70%, 50%, and 25%. Expect another $600,000 of new invoices, of which 20% will collect before month end. Ignore write-offs and other adjustments.
Opening AR collections are $350,000 + $150,000 + $50,000 = $550,000. New invoices add $120,000 in collections. Forecast cash receipts are $670,000, and ending AR is $1m + $600,000 − $670,000 = $930,000.
Recommendation
Inspect the largest customers behind older buckets before assuming the average applies. A $100,000 receipt shifted by one month raises current month-end AR and cuts current cash receipts by the same $100,000.
FP&A Interview & Case Workbook
Get the complete guide when you’re ready for more practice.
Sale price $50.15 Original price $59