What is the formula to get projected growth

B

Bret Snipes

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
 
G

Gary''s Student

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
 
B

Brad

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%
 
B

Bret Snipes

you are right.
Thanks

Brad said:
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%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top