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.
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
| Input | Value |
|---|---|
| Cash refund now | 90 |
| Store credit face value | 100 |
| Expected usable share | 90% |
| Annual discount rate | 0% |
| Months to redemption | 6 |
| Result | Value |
|---|---|
| Present value of usable credit | 90 |
| Credit advantage over cash | 0 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Cash refund now | 90 | 99 | Credit advantage over cash | 0 | -9 |
| Store credit face value | 100 | 110 | Present value of usable credit | 90 | 99 |
| Expected usable share | 90% | 99% | Present value of usable credit | 90 | 99 |
| Annual discount rate | 0% | 1% | Present value of usable credit | 90 | 89.553347 |
