Growth Assumptions on a consolidated level

Options
Megha27
Megha27
in Modeling

Hi Experts,

What is the best way to make a growth assuption at a consolidated level and have the same % growth apply to GLs underneath? For example - I need to grow my Salary & wages by 3% and have that 3% apply to all the 10 different S&W GLs underneath it instead of breaking back like 0.3% per GL to get the total of 3% on Salary & Wages consolidation? I am not interested in inserting 30% at the consolidated level to get 3% per GL . Hope that makes sense.

Thanks,

Megha

Answers

  • Sai_Bharadwaj_Venati
    Sai_Bharadwaj_Venati
    Options

    Hi Megha,

    You can use Lookup to get your % applied to Salary & Wages GL's. In order to use lookup you should have mapping between GL and GL group.

    V.Sai Bharadwaj

    Connect on LinkedIn

  • HimanshuRaj
    HimanshuRaj
    edited March 2023
    Options

    Hi @Megha27

    As Sai also mentioned, you can follow the below steps:

    1. In Parent module, store the percentages as input
      1.PNG
    2. In second module with Child list as dimension, use the formula as attached below
      3.PNG
      2.PNG

    Hope, this resolves your issue

Categories