Refund versus store credit value · Calculation guide

Compare immediate cash with the usable present value of store credit.

Calculation guide

Enter the share of credit you expect to use and a discount rate for the waiting time. A positive difference favors store credit.

pv = credit*used/100/(1+discount/100)^(months/12); edge = pv-cash

Inputs

Cash refund now

Example entry 90 (in the selected currency).

Store credit face value

Example entry 100 (in the selected currency).

Expected usable share

Example entry 90 %. Allowed range 0 to 100.

Annual discount rate

Example entry 0 %. Allowed range 0 to 100.

Months to redemption

Example entry 6.

Worked example

InputValue
Cash refund now90
Store credit face value100
Expected usable share90%
Annual discount rate0%
Months to redemption6
ResultValue
Present value of usable credit90
Credit advantage over cash0

Calculation steps

Present value of usable credit = (((Store credit face value × Expected usable share) ÷ 100) ÷ ((1 + (Annual discount rate ÷ 100)) ^ (Months to redemption ÷ 12)))

(((100 × 90) ÷ 100) ÷ ((1 + (0 ÷ 100)) ^ (6 ÷ 12))) = 90

Credit advantage over cash = (Present value of usable credit − Cash refund now)

(90 − 90) = 0

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Cash refund now9099Credit advantage over cash0-9
Store credit face value100110Present value of usable credit9099
Expected usable share90%99%Present value of usable credit9099
Annual discount rate0%1%Present value of usable credit9089.553347
Refund versus store credit value →