Calendarization : logic behind the formula
Hello,
I used the following formula to calendarize :CY sales = (Month #)(Actual Fiscal Year Sales)/12 + (12 - Month #)(Estimated Fiscal Year Sales)/12)
But I dont understand the formula, could someone explain to me the logic behind it ?
thanks a lot !!!!
:)
It's a simple weighted average. For example, if you measure at month 8 then you are weighting actual at 8/12 and estimated at 4/12.
thanks :) why estimated and not actual?
Because the estimated sales haven't occurred yet...so the sales are estimated...
okay thanks a lot !! But, i dont understand why we take Month/12 .... I am sorry i know there is a strong and obvious logic behind it but still...
thanks :) why estimated and not actual?
Possimus voluptate et voluptatem et. Aliquam ea sit voluptas quod vel ut. Perspiciatis voluptatem veritatis dolore distinctio. Ut dolores sed non voluptatem non inventore mollitia quidem. Dolor sit nemo molestiae maxime enim nam.
Libero facere sed sit. Dolor reprehenderit minima dolores sapiente incidunt deleniti et.
Ea velit et a asperiores. Deserunt quod omnis iusto quod mollitia ab aut et.
Ipsa voluptas et sed ut. Soluta rem aspernatur sint accusamus nemo velit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...