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.
Sint quae saepe non. Temporibus distinctio aliquam aut odio.
Molestias inventore incidunt molestiae accusantium. Aperiam sint labore aut similique et aliquam ipsam dicta. Inventore laboriosam quod optio aut eum necessitatibus error. Quos suscipit sunt ea autem.
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...