Prepaid expense amortization · Calculation guide

Uniform daily coverage. Enter elapsed service days at the start and end of the reporting period measured from the coverage start.

Calculation guide

Cap at total coverage.

expense = amount*(min(term,end)-min(term,start))/term · balance = amount*(1-min(term,end)/term)

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

InputValue
Prepayment1,200
Total coverage days360
Elapsed days at period start30
Elapsed days at period end90
ResultValue
Expense for reporting period200
Closing prepaid asset900

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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Prepayment1,2001,320Expense for reporting period200220
Total coverage days360396Expense for reporting period200181.818182
Elapsed days at period start3033Expense for reporting period200190
Elapsed days at period end9099Expense for reporting period200230
Prepaid expense amortization →