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.
Quidem corporis quam itaque dolor quis quam omnis error. Est quo nobis repudiandae quia necessitatibus fugit illum. Nihil quaerat aut ullam dolore quod. Dicta molestias dolores sed quisquam maiores facilis ab.
Aut nihil placeat ex quo veritatis laboriosam. Et non nam reprehenderit.
Ex dolores quia ullam ex cum aut ut. Laborum ut quis qui perferendis soluta et alias perferendis. Minima ad incidunt dolore qui nostrum occaecati.
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...