Discounted Payback Schedule

Discounted investment recovery schedule online

Discount periodic flows, track cumulative value and estimate the payback crossing. Use this for the specific transformation described above. Start with the fixed sample and compare its result before replacing it with your own representative input.

How to use it

Paste JSON matching the structure in the example. Set period discount rate (%). Choose Calculate. Review the output, then copy or download it.

Options and example settings

Worked examples

Use this for the specific transformation described above. Start with the fixed sample and compare its result before replacing it with your own representative input.

Reproducible worked example

Settings: Period discount rate (%): 10

Input:

[-1000,400,400,400,400]

With the input and settings above, the tool produces:

Output:

{
  "fractionalPaybackPeriod": 3.0192500000000004,
  "schedule": [
    {
      "period": 0,
      "flow": -1000,
      "discounted": -1000,
      "cumulative": -1000
    },
    {
      "period": 1,
      "flow": 400,
      "discounted": 363.6363636363636,
      "cumulative": -636.3636363636364
    },
    {
      "period": 2,
      "flow": 400,
      "discounted": 330.5785123966942,
      "cumulative": -305.7851239669422
    },
    {
      "period": 3,
      "flow": 400,
      "discounted": 300.525920360631,
      "cumulative": -5.259203606311189
    },
    {
      "period": 4,
      "flow": 400,
      "discounted": 273.2053821460282,
      "cumulative": 267.94617853971704
    }
  ]
}

For this input, “fractionalPaybackPeriod” is 3.0192500000000004. These are the named fields in the example output.

Limitations and common mistakes

• Calculations use your supplied assumptions and floating-point arithmetic. Check input order, units and the worked example before relying on a result.
• Combined input is bounded to 150,000 characters; output text is bounded to 1.2 million characters. Some algorithms impose smaller limits, stated in their error messages.

Frequently asked questions

What format should I enter?

Paste JSON matching the structure in the example. The worked example shows the supported structure and actual output.

How can I create a discounted payback schedule online?

Paste JSON matching the structure in the example. Set period discount rate (%). Choose Calculate. Review the output, then copy or download it.

Technical references

• Microsoft — NPV and IRR timing conventions

Where is my input processed?

The bundled tool processes input in your browser. It does not upload tool input to a conversion service. Other site plugins, analytics, advertising and browser extensions may have separate behavior.

Useful next tools

• Loan Amortization Schedule
• Simple Payback Period Calculator
• Asset Depreciation Schedule
• Customer Acquisition Payback