LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Gradual adoption rate over a period

Hi Guys,

I have a new product for which I'm trying to display both expected
take up and revenue/profit calculations.

The problem I have is that I'm not sure how to weigh out the adoption
rate.

At this point, I want to sell 77 Units per month, over 12 months,
which works out say 6.42 p.month. But we don't expect to reach that
6.42 straight up in the first month and maintain that over the
year.Doing it this way also has an unrealistic effect on revenue, in
that we are 'taking more money' earlier and growing on the subscriber
base earlier than what's realistic.

So, how do I stretch out adoption more gradually? Over the first and
then 2nd and 3rd years.

Please I need some help or to be pointed in the right direction.

Month (No) 1 2 3 4 5 6 7 8 9 10 11 12
Total 6 13 19 26 32 39 45 51 58 64 71 77
New 6 6 6 6 6 6 6 6 6 6 6 6

The 'New' needs to look more like... obviously as the result of a
formula I can put in place for variables to feed into.

1 2 2 2 3 6 6 8 10 11 12 13
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
average rate of change per given time period between 2 moments in time of a value David Virgil Hobbs Excel Worksheet Functions 1 December 19th 06 07:24 AM
drawdown at fixed rate over set period from investment at fixed % jamook New Users to Excel 1 November 28th 05 10:53 PM
Real RATE of return using =RATE illusive, inflation adjusted inflo Pro - Land Excel Worksheet Functions 4 November 1st 05 03:06 AM
Period to Period percentage change? cs120 Excel Discussion (Misc queries) 1 September 18th 05 12:05 PM
a function giving the interest rate for inv x for period y & bal z cal777 Excel Worksheet Functions 1 August 3rd 05 06:16 PM


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"