Calculation guide
Cap at total coverage.
Inputs
Prepayment
Example entry 1200 (in the selected currency).
Total coverage days
Example entry 360. Use whole numbers.
Elapsed days at period start
Example entry 30. Use whole numbers.
Elapsed days at period end
Example entry 90. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Prepayment | 1,200 |
| Total coverage days | 360 |
| Elapsed days at period start | 30 |
| Elapsed days at period end | 90 |
| Result | Value |
|---|---|
| Expense for reporting period | 200 |
| Closing prepaid asset | 900 |
Calculation steps
Expense for reporting period = ((Prepayment × (min(Total coverage days, Elapsed days at period end) − min(Total coverage days, Elapsed days at period start))) ÷ Total coverage days)
((1,200 × (min(360, 90) − min(360, 30))) ÷ 360) = 200
Closing prepaid asset = (Prepayment × (1 − (min(Total coverage days, Elapsed days at period end) ÷ Total coverage days)))
(1,200 × (1 − (min(360, 90) ÷ 360))) = 900
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 |
|---|---|---|---|---|---|
| Prepayment | 1,200 | 1,320 | Expense for reporting period | 200 | 220 |
| Total coverage days | 360 | 396 | Expense for reporting period | 200 | 181.818182 |
| Elapsed days at period start | 30 | 33 | Expense for reporting period | 200 | 190 |
| Elapsed days at period end | 90 | 99 | Expense for reporting period | 200 | 230 |
