Dear All
I'm building a financial forecast model for the first time having been through the training and I'm looking to build a revenue model which has approximately 10 drivers ultimately to the revenue which all interact in different ways. Having watched the customisation video, the proposed solution seems to be to have all assumptions in the assumption section of the spreadsheet and all logic pertaining to the final revenue figures in the Rev_Exp_Out revenue block. This would cause an extremely long an convoluted formula in the revenue output block which a third party would be unable to follow. What would be better is is the revenue model had all logic built into it (e.g. Average sales per client, expected commission, expected number of clients, expected growth in number of clients ect, ect) in order for a viewer to follow the logic before outputting to the Revenue Output.
Are there any videos or examples of how to do this which go into more depth than the training module and which also show the necessary process with the cell blocks and cell block linking which are available to try and solve this problem?
I would have uploaded my version here but the Upload File button seemed not to be functioning as it should.
Many thanks
Angus
Hi Angus,
You can use modules as categories to facilitate different drivers for different categories. I've attached an example of how this is done.
You can right-click on any of the revenue, COGS or operating expenditure categories (which are in fact separate modules being used as categories) and click Insert Categories (Modano tab, Categories group) to add more categories.
To change the driver of any specific category, select a cell within its row and use the Replace Module tool (Modano tab, Replace menu, From File). We haven't yet built all these modules, so they're not yet in the libraries in the system, but I'm provided 4 operating expenditure modules which you can replace operating expenditure categories with.
This is a very cool, but very sophisticated, way of using Modano. And I'm sorry but it's not yet documented in our user guide or videos, but we're planning on releasing a wide range of more advanced How To videos during early 2022 after we've recorded them over the Christmas period.
So the attached example shows how it's done, but is likely to make your brain explode trying to work out how it works.
If this is an urgent requirement I would recommend purchasing some support credits via the Support section of your Modano account and requesting support from our Services team. They will quite quickly be able to get you going in the right direction.
Hope this helps either way.
P.S. If you're unable to upload files still, please report this via the Support section of your Modano account so our engineers can look into it. Thanks.
Michael Hutchens
Managing Director | Modano