View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bret Snipes Bret Snipes is offline
external usenet poster
 
Posts: 3
Default What is the formula to get projected growth

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