Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
Period to Period percentage change? | Excel Discussion (Misc queries) | |||
a function giving the interest rate for inv x for period y & bal z | Excel Worksheet Functions |