gaj104
Well-known Member
- Joined
- Nov 9, 2002
- Messages
- 864
Hi.
I'm thinking theres a simple formula to work out my growth rate (in my case negative growth) in the last 9 months (assumed straight line) so I can forecast for a year. Can anyone help? Example shown below.
Many thanks
I'm thinking theres a simple formula to work out my growth rate (in my case negative growth) in the last 9 months (assumed straight line) so I can forecast for a year. Can anyone help? Example shown below.
Many thanks
Book2 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Growth rate | |||
2 | 5,229,605 | 5,170,498 | 4,375,780 | 4,474,410 | 4,954,709 | 4,186,153 | 3,553,213 | 4,508,134 | 3,450,296 | ? | |||
Sheet1 |