Forum Discussion

Just_Jenn's avatar
Just_Jenn
Copper Contributor
Jan 14, 2020
Solved

Percent of growth based on percent of fiscal year?

I'm not really sure what I'm looking for exactly so here is the gist of it.... I have current YTD data and previous YTD data along with a percentage of growth formula.  The growth is currently all n...
excel
Formulas and Functions
  • AshaKantaSharma's avatar
    AshaKantaSharma
    Jan 14, 2020

    Hey Just_Jenn 

     

    Please see the attached sheet if it helps as i have prepared the sheet taking into account start of FY from 1st April to 31st March

     

    Formula =(A6-((DATE(2019,4,1)-TODAY())*AVERAGE(B6/365)*-1))/((DATE(2019,4,1)-TODAY())*AVERAGE(B6/365)*-1)

     

    Hope it is an automated single formula as required by you to give a more realistic view of current status of growths. 

     

    Hope it helps...

     

    Thanks and have a great time ahead....

AshaKantaSharma's avatar
AshaKantaSharma
Iron Contributor
Jan 14, 2020

Hi Just_Jenn 

 

Just find out average monthly turnover of the previous year and multiply the same with number of completed  months for the current FY to check whether you are short/excess of last years monthly average turnover. Divide the short/excess amount with the last year monthly average to find out Percentage Growth/Decline for the current F.Y. 

 

Hope it helps... 

  • Just_Jenn's avatar
    Just_Jenn
    Copper Contributor
    Jan 14, 2020

    That makes sense! So is there an Excel formula that would run these calculations for me automatically so I don't have to every month?  If so, what does that formual look like?

    AshaKantaSharma