5 Years Planning
I am trying to build this kind of P&L view :
where 2023 FY figures come from another module where the line items are planned on a monthly basis.
The idea is to forecast every year after 2023 based on Y-1. Meaning that the revenues of FY 2024 will be = Revenue FY 2023 * x%, Revenues of 2025 = Revenue FY 2024 * x% etc...
I initially prepared a list where am storing all my growth % for each line item but I am a bit struggling as we have different projects and each of those has a different %, which makes me create too many different lists. Ultimately, the sum of each project makes it to the group view.
I was wondering if someone ever build something similar and what would be the best practice here as it feels wrong to use a list for FY23 to FY28 as I can not build formula this way.
Thanks for your help;)