Glad to help!
--
Wag more, bark less


"Bret Snipes" wrote:

you are right.
Thanks

"Brad" wrote:

You have a problem with where the decimal should be
=FV(0.1,3,,-500)
and
=FV(0.1,5,,-500)

Please note
.1 = 10%
you are using
10 = 1,000%
--
Wag more, bark less


"Bret Snipes" wrote:

I am trying to get the formula for projected growth
example
I have a 1 TB hard drive that currently has 500gb in use. The growth rate
is 10% per year. How much data will reside on the drive after 3 years and 5
years.

I looked at using the =fv formula but the answer did not come out correctly
=fv(10,3,,-500) results = 665,500.00 s/b 665.50
=fv(10,5,,-500) results = 80.525,500.00 s/ 805.255

I am not sure if I am using the right formula
Help is greatly appreciated

Bret Snipes