Hello,
I am working on a forecasting model and have run into some trouble when trying to extend the X-Axis of a 12-month Curve Distribution to a longer time frame. Given a distribution of 12 percentages (one for each month), how can I spread the 12 months or periods to say 18 months while maintaining the integrity of the curve.
Example:
<colgroup><col><col span="4"><col span="2"><col><col><col span="10"></colgroup><tbody>
</tbody>
I am working on a forecasting model and have run into some trouble when trying to extend the X-Axis of a 12-month Curve Distribution to a longer time frame. Given a distribution of 12 percentages (one for each month), how can I spread the 12 months or periods to say 18 months while maintaining the integrity of the curve.
Example:
Distribution Amount | $1,000,000 | |||||||||||||||||
Known Curve | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||||||
Bell Curve | 1.00% | 3.00% | 6.00% | 8.00% | 12.00% | 20.00% | 20.00% | 12.00% | 8.00% | 6.00% | 3.00% | 1.00% | ||||||
Spend Pattern | 10,000 | 30,000 | 60,000 | 80,000 | 120,000 | 200,000 | 200,000 | 120,000 | 80,000 | 60,000 | 30,000 | 10,000 | ||||||
Adjusted Curve | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |
Bell Curve | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
Spend Pattern | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
<colgroup><col><col span="4"><col span="2"><col><col><col span="10"></colgroup><tbody>
</tbody>