interest calculator - NPV

[brinded]

I'd like to know which function to use for a simple savings account.

rate is 5%
nper is 25 years
pmt is fixed $2,000 per annum

I would like to have a column with current value for each year, 25
cells.

NPV doesn't look right. Any thoughts?

 

[brinded]

Actually, CDs are what I had in mind if anyone can help.

Thanks.

 

[JE McGimpsey]

I'd like to know which function to use for a simple savings account.

rate is 5%
nper is 25 years
pmt is fixed $2,000 per annum

I would like to have a column with current value for each year, 25
cells.

NPV doesn't look right. Any thoughts?

Use FV()

For instance:

A B
1 =FV(5%,A1,-2000,-2000,0)

Copy B1 down to B25.

 

[brinded]

thank you.