Skip to main content
Hi Aaron,
Like with Excel without Modano, there is no right or wrong way to do this, but here's my personal view...
When you want to include periodic summations within time series sheets - such as quarterly and annual totals in a P&L - I would leave your model calculation outputs alone and add this analysis in a new module (or add a module component to an existing module), locating it within a presentation outputs module component based on a newly-created period titles set which reflects your required summation periodicities.
The issue with trying to include periodic summations in your base P&L is that you'll either need to include inconsistent formulas for months, quarters, years, etc. - which is messy, risky and won't scale when you roll or extend your model time series.
I've demonstrated how to do this in the attached monthly historical & forecast model, in which I've:
I've made some simplifying assumptions for this example - e.g. sheets based on the Monthly All Periods Summation period titles set will always show a whole number of years and the first period on this sheet has assumed to be the first month of a year - but these assumptions could be relaxed to reflect different time series structures.
This is certainly not simple stuff - with or without using Modano - but hopefully the attached example demonstrates a best practice, scalable way of including multi-periodicity summations in the presentation outputs of a model without touching the core model assumptions and outputs.
M.
Hi Michael
Thank you so much for the response.
Regards
Aaron
It's a pleasure Aaron. Our primary challenge is inspiring our new users to they realise that pretty much anything is possible using Modano, it's just a matter of getting up the learning curve, which can be steep at first.
We're working hard to release a lot more content over the next 12 months, thereby making it easier and easier for our users to build a model closely aligned with their requirements.
The great thing is that it's all re-usable due to the modular and scalable nature of the platform, so we only need to do each thing once and we can leverage it forever!
M.
Thanks for sharing useful information. I appreciate you for your work and dedication.