I am looking to take total historical sales and increase them by a YOY growth rate, and then split out the sales to different sales channels using a % split. I am struhggling to modify any of the existing revenue models and wondered if anyone can help. I have attached a spreadsheet with a basic outline of what I am trying to achieve
Attachments:
Hi Guys,
Peter - Is the main issue here that you have a single historical revenue line but want to forecast multiple revenue categories?
In your example, you've provided split % assumptions in every forecast period, as well as % Total Sales YOY growth assumptions. Would it be alright to simplify this by having a single column of split % assumptions which is applied once in the first forecast period, after which the % Total Sales YOY growth assumptions are then applied to the split out revenue categories? I noticed in your example that the split by sales channel % assumptions are currently the same for each category across all periods, so based on your current assumptions this could be simplified.
Personally, I'd recommend doing the one-to-many split/allocation once at the end of the historical data periods, then allow the user to enter forecast YOY growth rate % assumptions for each split out revenue category, as I'd imagine model users are likely to want to enter different YOY growth rate assumptions for different categories.
Let me know if you think this would work, and I can mock up an example for you tomorrow.
M.
This is exactly what I was envisaging, fantastic work Jun. ;-)