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.
| +273 | Looking to raise a Billion Dollar Fund - College Junior | 41 | 5h | |
| +215 | It doesn’t need to be this way | 30 | 3h | |
| +145 | What to expect during your IB summer internship and how to secure the full-time offer | 7 | 22m | |
| +136 | Career Bankers, Was It Worth It? | 45 | 3h | |
| +134 | Biggest gripe in IB: people with no balls | 37 | 6h | |
| +83 | RBC M&A vs PJT RSSG | 14 | 2d | |
| +81 | I FINALLY DID IT, I GOT A FT OFFER! | 14 | 8h | |
| +66 | Vanderbilt ($$$) / Northwestern ($$$) vs UF ($) | 36 | 4h | |
| +66 | MD Can’t Unplug | 20 | 36m | |
| +63 | Did I mess up by correcting my VP Publicly? | 20 | 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.
Fuga qui sit autem enim nesciunt. Enim suscipit consequatur fuga quos. Nisi et eaque reiciendis dolorem at omnis vel. Alias doloremque et illo sint rem rerum. Placeat in quis ut enim nihil placeat.
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...