Page 1 of 1

Creating a forecast from Year To Date Values

Posted: Fri Nov 29, 2019 8:32 pm
by Peter079
Hi, I am struggling to solve the following scenario.

I have created a YTD measure that calculates actuals up to the end of a period e.g. November 2019, using the YTD function. My financial year end is March, and I am trying to figure out how I can add a Forecast Measure which is my YTD measure x 12/8 (or just annualising my YTD measure), and to then include this forecast measure in an Income Statement i.e. for the months of December to March, to get an annual value.

Any help will be greatly appreciated

Regards


Peter

Re: Creating a forecast from Year To Date Values

Posted: Mon Dec 02, 2019 9:40 pm
by Bernard Heymans
Hi Forecasting is a different job...

you base it on exisiting results.

then you apply growth ratio on the data.

lets say you are selling cars

marketing say red cars should grow by 3%
Sales say our band is trendy and grow by 2% and that our sales in Germany will not go as good as in the rest of the world by 1%

so if our sales of red cars in germany are 1.748 units,

next year we will have

1.748 *(1+3%) *(1+2%) *(1-1%) = 1.818,08 cars