0
   

solving an exponential growth equation using excel

 
 
duramax
 
Reply Tue 3 Apr, 2012 03:35 pm
I am trying to write an equation which solves for the amount of years remaining of natural gas resources, based on total proved reserves and annual consumption rates. I need to solve for potential annual growth rates of 0,1,2,3, and 5 percents. 0 is easy, just divide the total reserves by the annual consumption. But when I write an equation to solve the rest of them I get more years remaining, even though the annual consumption rate is increasing.
I tried by using the equation:
t=(ln(R/A))/(ln(1+i))
where t=time remaining in years, R=total reserves,A=annual consumption,and i=annual growth rate as a decimal.
I believe that the problem is that it isn't including the annual consumption for every year, but I'm not sure how to make it do that.

Any help would be awesome.
Thanks
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 2,339 • Replies: 1
No top replies

 
duramax
 
  0  
Reply Tue 10 Apr, 2012 05:03 pm
@duramax,
bump
0 Replies
 
 

Related Topics

 
  1. Forums
  2. » solving an exponential growth equation using excel
Copyright © 2020 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.04 seconds on 10/24/2020 at 04:57:15