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 !!!!
:)
| +89 | [2026 - October] Unbiased Prestige Rankings | 55 | 1h |
| +87 | Who is the final boss in Houston Energy? (GS, JEFF or EVR) | 19 | 20h |
| +78 | You should probably leave IB | 26 | 1d |
| +45 | Why Do We Turn Comments? | 10 | 1d |
| +43 | Tomorrow Will Be Better | 5 | 4d |
| +41 | Moelis PCA vs Lower tier BB Coverage | 30 | 1d |
| +25 | Banking (Un)fortunately Still Needs You: My Case for Bankers in the AI Era | 3 | 1d |
| +24 | How much should you ask questions / seek feedback as an intern? | 9 | 6h |
| +24 | UBS IB #24 in US M&A in 2026 | 10 | 3h |
| +23 | Lateraling as Analyst | 21 | 3h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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?
Expedita voluptas explicabo officiis. Similique illum est ducimus. Explicabo perspiciatis tempora est.
Iste nisi distinctio dolore sapiente nostrum. Possimus vitae et ex ipsa sit. Ad commodi quis commodi quia. Impedit fugit sit perferendis dolores voluptas eveniet nostrum praesentium.
Laudantium esse odit voluptatem vel. Tenetur cupiditate eum doloremque et qui. Laborum voluptatem velit ipsam velit similique non.
Explicabo nam quibusdam commodi et expedita et. Natus ipsa aut expedita esse. Minima nihil id quos placeat.
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...