Does anyone know how to automatically increment the formula as shown above according to each interest rate column ( column F2 to column F98) without manually typing for each one?

- fx =B2+NPV(F4, B3:35) A B D E F G H J K Year B c Rate 0 -20000 - 15000 6400 1 -25000 12600 12600 2 3 6400 9400 21% 8100 8100 12600 NPVA NPVB NPVC 0% $7,200.00 $18,800.00 1% $6.734.08 $17,879.95 2% $6,283.82 $ $16,990.86 3% $5,848.54 $16,131.35 4% $5,427.57 $15,300.13 5% $8,800.00 $8,189.64 $7,599.91 $7,029.89 $6.478.72 18600 IRR 32% 19% 6% 7% . 8% 9% - 10% 11% : - 12% 13% - 14% 15% - $1,585.19 $7,713.73 $1,452.95 . . 16% 17% 18% 19% 20% 21% 22%