Forum Discussion
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 negative because we are only 54% through our current fiscal year and the previous YTD data is based off a full 12 months. I think I'm looking for a formula that would allow me to calculate the current year percentage of the previous YTD data to in turn use that number to more accurately reflect current growth for the year?
I've attached an image of the current information that I have.
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....
11 Replies
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...
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?
I could take the current YTD data and simply compare it to the totals through January of last year, but then I would have to do that again in Feb, Mar, Apr, etc. I has hoping there was some type of dynamic formula that could just use the percentage of the current year to estimate the growth. PReagan
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....
