Calculation guide
Count delivered days to the reporting date.
Inputs
Prepaid contract consideration
Example entry 9000 (in the selected currency).
Total service days
Example entry 90. Use whole numbers.
Delivered days to date
Example entry 36. Use whole numbers.
Revenue in earlier periods
Example entry 2100 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Prepaid contract consideration | 9,000 |
| Total service days | 90 |
| Delivered days to date | 36 |
| Revenue in earlier periods | 2,100 |
| Result | Value |
|---|---|
| Current-period recognized revenue | 1,500 |
| Closing deferred revenue | 5,400 |
| Cumulative earned revenue | 3,600 |
Calculation steps
Current-period recognized revenue = (((Prepaid contract consideration × Delivered days to date) ÷ Total service days) − Revenue in earlier periods)
(((9,000 × 36) ÷ 90) − 2,100) = 1,500
Closing deferred revenue = (Prepaid contract consideration × (1 − (Delivered days to date ÷ Total service days)))
(9,000 × (1 − (36 ÷ 90))) = 5,400
Cumulative earned revenue = ((Prepaid contract consideration × Delivered days to date) ÷ Total service days)
((9,000 × 36) ÷ 90) = 3,600
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Prepaid contract consideration | 9,000 | 9,900 | Current-period recognized revenue | 1,500 | 1,860 |
| Total service days | 90 | 99 | Current-period recognized revenue | 1,500 | 1,172.727273 |
| Delivered days to date | 36 | 40 | Current-period recognized revenue | 1,500 | 1,900 |
| Revenue in earlier periods | 2,100 | 2,310 | Current-period recognized revenue | 1,500 | 1,290 |
