How to calculate
Divide future value by principal. Take the root for the period count, subtract one, and convert to a percentage. Repeat for every cell of the table.
Worked example
Use Starting principal (USD) 1 · First future value (USD) 2 · Future value increment (USD) 0.5 · Future value columns 3 · Number of period rows 4 · First period count 10 · Period increment 1. The result is 7.1773%.
Input and result notes
Each rate is per compounding period. A future value below the starting amount gives a negative rate. Copy the result to export the table as comma-separated values.