How to compound a monthly investment at a given rate to show total after 25 years

[SDBoca]

I want to determine the total amount of savings if a monthly deposit is made at a given rate for 25 years. It's the future value of a monthly deposit. For example, if a person deposits $25 per month in a savings account that yields 5%, what is the total in that account after 25 years.

 

[Dave Patton]

T202402a.xlsm
	A	B	C	D
1	Term	Rate	Amount
2	25	5.25%	$25.00	$1,235.14
3d

Cell Formulas
Range	Formula
D2	D2	=FV(B2,A2,-C2)

 

[SDBoca]

T202402a.xlsm
	A	B	C	D
1	Term	Rate	Amount
2	25	5.25%	$25.00	$1,235.14
3d

Cell Formulas
Range	Formula
D2	D2	=FV(B2,A2,-C2)

Hi. Thanks for responding. That is not what I'm looking for. $25 dollars monthly is $300 per year, 25 years would be $7,500 with no interest included.

 

[Dave Patton]

T202402a.xlsm
	A	B	C	D
1	Term	Rate	Amount
2	25	5.25%	$25.00	$15,456.17
3
3d

Cell Formulas
Range	Formula
D2	D2	=FV(B2/12,A2*12,-C2)

 

[SDBoca]

T202402a.xlsm
	A	B	C	D
1	Term	Rate	Amount
2	25	5.25%	$25.00	$15,456.17
3
3d

Cell Formulas
Range	Formula
D2	D2	=FV(B2/12,A2*12,-C2)

Thanks!!!