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.
| +415 | Evercore Intern Seizure | 63 | 5h |
| +128 | UBS IB Americas has failed, now behind Santander and Stiffel | 34 | 11h |
| +97 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 34 | 2h |
| +79 | deleted deleted deleted deleted deleted | 44 | 15h |
| +65 | How do I understand vs. just memorizing? | 11 | 1d |
| +57 | Some banks are overrated as fuck | 17 | 1h |
| +48 | Associate & Above IB exits | 18 | 1d |
| +47 | The good and bad with Wells Fargo | 17 | 54m |
| +42 | Tech to IB Pivot | 22 | 5h |
| +36 | Incoming IB Analyst: Best Ways to Prepare? | 13 | 23h |
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.
Sit reprehenderit qui nulla doloribus rerum. Possimus praesentium quia harum et officiis. Adipisci quaerat odio dolore voluptatibus quo. Deleniti ex non qui ullam dolorem.
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...