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 !!!!
:)
| +156 | Think Twice before Recruiting for HOUSTON IB!! | 65 | 1d |
| +143 | Investment Banks Ranked By Your Divorced Blue Collared Uncle | 14 | 12h |
| +82 | UBS Exits 2026 | 20 | 14m |
| +50 | How cooked am I as an incoming WF IB SA 2027? | 17 | 4d |
| +42 | Congrats on the ROs. I Still Don’t Know Which One You Were | 2 | 15h |
| +40 | Mid-Level UBS Departure for another BB (Grass Isn’t Greener…) | 31 | 2d |
| +36 | IB RO Discussion | 6 | 2d |
| +31 | Did not get a return offer due to headcount, but happy to move on. | 6 | 2d |
| +30 | GS - Low Bonus | 23 | 5h |
| +28 | Early VP promo timeline | 15 | 20h |
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?
Vero magnam doloremque repellendus ex aperiam quo. Voluptas voluptatem numquam at saepe rerum est 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...