I want to use the excel to simulate the next 5 years revenue using year
2005 sales volume and pricing model as the base year.

In order to simulate the next 5 years result, I would like to make a
parameter "Estimated growth in sales volume". So that I can see the
result in case the sales increase or decrease.

In attached worksheet 1, I created the summary sheets which shows the
revenue figure from 2005 - 2010 and the simulation parameter.

This worksheet referencing sheet 4, which contains the revenue
breakdown on Product A and B.

While Sheet 2 has the pricing model and Sheet 3 has got the actual
sales volume in year 2005.

Could anyone please teach me how to work out the 2006 - 2010 revenue
figure when I change the "Estimated growth in sales volume" parameter
i.e. D6 in sheet 1.

Thanks a lot.


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://forums.yourdomain.com.au/attachment.php?attachmentid=695|
+-------------------------------------------------------------------+

--
garfield

The link to the zip is not useful, is this the same post as was answered
in OzGrid?

garfield Wrote:
I want to use the excel to simulate the next 5 years revenue using year
2005 sales volume and pricing model as the base year.

In order to simulate the next 5 years result, I would like to make a
parameter "Estimated growth in sales volume". So that I can see the
result in case the sales increase or decrease.

In attached worksheet 1, I created the summary sheets which shows the
revenue figure from 2005 - 2010 and the simulation parameter.

This worksheet referencing sheet 4, which contains the revenue
breakdown on Product A and B.

While Sheet 2 has the pricing model and Sheet 3 has got the actual
sales volume in year 2005.

Could anyone please teach me how to work out the 2006 - 2010 revenue
figure when I change the "Estimated growth in sales volume" parameter
i.e. D6 in sheet 1.

Thanks a lot.


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download:
http://forums.yourdomain.com.au/attachment.php?attachmentid=695|
+-------------------------------------------------------------------+

--
garfield


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486634