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 !!!!
:)
| +374 | Which Offer to Accept: UBS Analyst Role or Part Time Cashier at the Local Taco Bell | 44 | 5h |
| +291 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 31 | 5h |
| +272 | TPH V.S. Mizuho [HOU] | 33 | 1h |
| +270 | AI is insane | 38 | 1h |
| +264 | I Snuck Into UBS Office And Took A Shit On The Floor | 26 | 8h |
| +220 | Best Power/Renewables/Energy Teams? | 35 | 3h |
| +202 | Useless associates | 36 | 4h |
| +184 | Differences in Restructuring Teams? | 33 | 5h |
| +182 | Actual EB List | 26 | 2h |
| +177 | Centerview HC group falling off? | 28 | 5h |
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?
Placeat blanditiis dolorem doloremque consequatur ut quibusdam dicta quo. Neque ipsa molestiae qui molestias molestiae unde dignissimos doloremque. Harum quam iure qui. Consectetur quo molestias aut quae occaecati amet modi.
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...