Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Growth Rate
Hello: Apologizes for this is probably more of a math question, but
since this is such a great group wanted to try. Here is my issue. I'm performing a growth rate calculation and then applying that growth to project a full-year estimate. Everything looks good. However, if I try to add up the parts, I get a different answer than if I do the calculation against the whole. Any thoughts? Example Data Below: Neighborhood A Year 1 105YTD 245Full-Year Year 2 120 ? YTD Growth = (120/105)-1 = 14% Applying the 14% to 245 I get 280 for a full-year estimate. Neighborhood B Year 1 73YTD 197Full-Year Year 2 112 ? YTD Growth (112/73)-1=53% Applying the 53% I get a full-year estimate of 302 TOTAL Year 1 178YTD 442 Year 2 232 ? YTD Growth (232/178)-1=30% Applying the 30% to 442 I get 575. My issue is 280 + 302 does not equal 575. Any thoughts? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solve for rate of growth on an investment | Excel Worksheet Functions | |||
growth rate but not average | Excel Discussion (Misc queries) | |||
annual growth rate from monthly data | Excel Discussion (Misc queries) | |||
monthly growth rate | Excel Worksheet Functions | |||
Graphing Database Growth Rate | Charts and Charting in Excel |