Forecasting deferred revenue from billings in a model
Use the roll-forward to keep customer cash timing and revenue recognition on separate schedules.
Wall Street Playbook ·
Work the roll-forward
A business opens the month with $35m of contract liabilities. It recognizes $12m of revenue against those liabilities and adds $18m from new prepaid periods. Closing contract liabilities are $41m. If all $18m of prepaid billings are collected immediately, cash receipts from those billings are $18m.
Find the interruption
If $4m of the billed amount is outstanding, collections from the new billings fall to $14m under that assumption. Review the applicable accounting policy before deciding whether billed amounts are already recorded as receivables and contract liabilities. Keep aging and revenue allocation distinct rather than forcing cash to equal billings.
Finance Technical Interview Guide
Get the complete guide when you’re ready for more practice.
Sale price $67.15 Original price $79