Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I project yearly growth rates in Excel?
I'm trying to find a formula (ideally) in Excel that will allow me to take a
constant weekly sales growth rate (based on 2006 actuals), and apply it to the current week's actual sales amount...resulting in a 2007 year-end sales estimate. Is there a way to do this (plug-in, etc) WITHOUT having to manually create a separate tab to calculate, then sum, each projected week's actual? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I project yearly growth rates in Excel?
On Feb 27, 1:20 pm, bobmount
wrote: I'm trying to find a formula (ideally) in Excel that will allow me to take a constant weekly sales growth rate (based on 2006 actuals), and apply it to the current week's actual sales amount...resulting in a 2007 year-end sales estimate. Giving you want I think you asked for: =sum(C1:C8) + fv(A1, 52 - 8, 0, -C8) where C1:C8 are the actual weekly sales amounts for the first 8 weeks of 2007, and A1 is the average weekly sales growth rate based on 2006 actuals. That is certainly not the way that I would estimate year-end sales. So perhaps I misunderstand you. If so, please clarify your question. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I project yearly growth rates in Excel?
Thanks, Joe...And yes--I realize there are much more sophisticated ways of
projecting sales, but I'm actually doing this for a friend who claims that this over-simplified way of projecting sales is, in fact, what he's being asked to do...at this stage. In fact, he's being GIVEN last year's weekly average sales increase (0.40 %), and asked to apply it to the current year's sales totals to extrapolate the remaining 42 weeks of 2007 (cell A1, in your example). Thanks again for the help! "joeu2004" wrote: On Feb 27, 1:20 pm, bobmount wrote: I'm trying to find a formula (ideally) in Excel that will allow me to take a constant weekly sales growth rate (based on 2006 actuals), and apply it to the current week's actual sales amount...resulting in a 2007 year-end sales estimate. Giving you want I think you asked for: =sum(C1:C8) + fv(A1, 52 - 8, 0, -C8) where C1:C8 are the actual weekly sales amounts for the first 8 weeks of 2007, and A1 is the average weekly sales growth rate based on 2006 actuals. That is certainly not the way that I would estimate year-end sales. So perhaps I misunderstand you. If so, please clarify your question. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get compound annual growth rates in pivot tables. | Excel Worksheet Functions | |||
Calculating Compounded Growth Rates | Excel Worksheet Functions | |||
Calculating market growth rates | Excel Worksheet Functions | |||
How can I calculate trend growth rates in Excel? | Excel Discussion (Misc queries) | |||
How do I project 5 year growth pattern of company? | New Users to Excel |