adjusting NPV

[Pizzio]

I have records that I've calculated the NPV (as of July 2015) on but now I need the NPV for each month over the next years. The only way I know how to do that is to create new schedules for each month showing one month less payment. Is there a formula that would do this for me so I don't have to recreate the expense?

******** language="JavaScript" ************************************************************************>

HQAFA 332 NTW RAT CricketFAS 146 phase 1 AND 2 vPizzio.xls
	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
1	DiscountRate	NPV	MonthlyLiabRelease	MonthlyRate	CurrentYear	Year2	Year3	Year4	Year5	AllYears>5	GrandTotal
2	0.0422	14,003.01			14,519.04	78.06	NULL	NULL	NULL	NULL	14,597.10
3	0.0422	33,441.97			16,466.06	19,163.10	NULL	NULL	NULL	NULL	35,629.16
4	0.0422	196,374.19			15,113.90	30,527.66	30,267.20	31,142.88	31,454.29	96,175.11	234,681.04
5	0.0422	5,591.35			5,827.31	NULL	NULL	NULL	NULL	NULL	5,827.31
6	0.0422	34,481.06			17,549.00	19,163.10	NULL	NULL	NULL	NULL	36,712.10
7	0.0422	131,113.82			13,961.49	28,085.67	28,366.59	28,650.34	28,936.85	24,326.85	152,327.79
Pizzio Detail