I'm doing a model. Since we have 3Q07 data, how do we present the income statement for 2007 in a model? SO far, i have 2004, 2005, and 2006 for my historical side of the model. For 2007, should i show the sum of the first three quarters and do an estimate starting with 4Q07E, 2008E, 2009E, etc.?
thanks.
| +166 | Return Rates For Interns Are Falling? | 51 | 1h |
| +129 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 14h |
| +96 | I am a drunk MD AMA | 36 | 10h |
| +74 | London IB BB is a challenge | 41 | 10h |
| +62 | VP Lifestyle at Top BB Coverage Groups | 39 | 20h |
| +56 | An Outsider’s View of RX Banking Out of College | 7 | 3m |
| +48 | SharePoint makes IB hours HELL | 15 | 2d |
| +46 | KISSED MY VP… HELP!!! | 11 | 3m |
| +42 | momentum of Rx groups | 16 | 4h |
| +39 | Fired during interview | 8 | 1d |
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.
Take first three quarters' actual results and then use analyst/company estimates for 4Q07E and label the whole column 2007E since that's what it technically is even if just one quarter is an estimate. Then use analyst estimates for 2008, 2009E, etc.
Probably best to do 2004A, 2005A, 2006A, 1Q07A, 2Q07A, 3Q07A, 4Q07E, 2007E, 2008E, 2009E, etc., and group/hide the quarter columns for ease of use and presentation.
At the end of the day, it is a matter of preference whether you have the quarters broken out or if you have 2007, but for purposes of making it dynamic, you would want the 4Q estimates separated from 1Q to 3Q, and for purposes of comparing across years you would want the full 2007 sum.
Ratione vel aut voluptatem eos accusamus a aut. Sit consectetur necessitatibus non quasi aliquam et laborum dolor. Et est nobis voluptatem officia.
Itaque repellat aspernatur repellendus natus. Doloremque iste ipsam perferendis saepe amet. Et magnam a iste sequi corrupti. Reiciendis consequatur quo quo minima. Assumenda ducimus voluptatem blanditiis quidem. Ea incidunt fuga esse facere dolor earum.
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...