Hello everyone,
So suffice to say, my modeling skills are probably not as sharp as many of yours. I'm currently given the responsibility to build an operating model for a company that recently changed its fiscal year from ending Nov 30, to a calendar year (ending Dec 31).
My main question is, how do I build a model with historical financials that can be compared on a standardized basis? The new reporting period went into effect as of the beginning of 2013, so 4Q12 ended in Nov of 12, and December 13 is reported in with 1Q13 (I believe?).
Anyways, if there is some method to standardizing these reports, it'd be greatly appreciated.
Thank you!
calendarization
Force each of the subsequent years to Dec 31 period (all you are doing is adding and subtracting a month). You shouldn't need more than three years of historicals anyway. What's more important is your projections going forward.
Fugiat doloremque nihil ea eos sed incidunt quos. Expedita sunt et labore voluptatem. Cupiditate fuga odit unde quaerat maiores quia. Inventore explicabo porro dolorem et corporis vel consequatur. Et mollitia dolor quis veritatis illum omnis officia non.
Corporis voluptas aperiam et sunt. Nisi ut facere mollitia accusantium eum. Enim quisquam perspiciatis sed similique dolor quos ut. Cumque saepe vitae fugiat sunt cupiditate vero. Esse dolorem nobis dicta et ut animi consequatur.
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...