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

In A1 put 500
In A2 put
=a1*1.1 and copy down to see:

500
550
605
665.5
732.05
805.255
885.7805
974.35855
1071.794405
1178.973846
1296.87123
1426.558353
1569.214188
1726.135607
1898.749168
2088.624085
2297.486493
2527.235142
2779.958657
3057.954522

So in three years - 666
so in five years - 805
--
Gary''s Student - gsnu200811


"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

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

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

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