At your favorite MM HFs, which of the following do analysts modeling companies have the columns in excel files formatted as?
1. Q1 Q2 Q3 Q4 Y Q1 Q2 Q3 Q4 Y
2. Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 ... YY
| +24 | James Fishback | 9 | 5h |
| +21 | Future of L/S | 5 | 3d |
| +17 | Latest blow up / wind down | 25 | 2d |
| +12 | Looking for Fund to Partner With - LMM Activist | 4 | 15h |
| +10 | SM L/S Compensation? | 3 | 17h |
| +9 | MMHF Central Execution Trajectory/Advice | 1 | 1d |
| +9 | How to prep for credit HF? | 4 | 1d |
| +9 | Moving from credit to equity? | 3 | 4d |
| +4 | Jensen Huang | 1 | 10h |
| +3 | Chefs at Pod Shops | 2 | 3d |
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.
Have seen and do both
Why the fuck would QQQQQQQQYY make sense?
Because less chance to fuck up and more modular in terms of moving things around or adding things.
I do it bc it's good to have yrs's side-by-side and also I think YYYY QQQQQQQQQ better captures Q4->Q1 sequential trends.
I have a separate sheet pull key metrics into QQQQY format for printing purposes if my PM wants to look at it like that
I have a strong suspicion that EliteCaliberTalent has yet to build a model in Excel or, frankly, open the Excel app.
His MS office subscription code may still be catching dust
I personally have a strong suspicion he is still in HS and struggles with google sheets
Q1Q21HQ3Q42HFY lmao
QQHQQFQQHQQFQQHQQFQQHQQFFFF
Have seen both, but qqqqyqqqqy modeling sucks
why?
Can't just pull right the formula to get the growth rates in one go, duh
You can't fast fill right in Excel, and it's most likely to make fx mistakes. It's better to have dedicated quarterly and annual tabs
QQQQQQQQ YY format and everything on 1 tab
I have seen and worked with both. QQQQQQQQ YY is way more practical. I think only an output could be presented QQQQYQQQQY.
Also, all the monthly models i have seen are formatted MMMMMMMMMMMM QQQQ YY, and not the other way.
Personally, I am still having a lot of difficulty to justify the QQQQYQQQQY format.
Working at a pod here but have seen both formats, I think Baird does the qqqqy etc. but it's helpful to just build it modularly so you can do either. As you're modeling, you should always have the quarters together and then for presentation you can change it however you want. I just made a new post here that may help some of you so just flagging some keys I've learned over the years and tools MM's are using to stay ahead: https://www.wallstreetoasis.com/forum/hedge-fund/key-tools-for-hf-analy…
100% agree
my first pod pm made fun of me for doing QQQQQQQQYY but she hadnt built a model in years herself...
QQQQYYQQQQYY here.
q1q2q3q4q1q2q3q4 y1y2
^^ this is the correct answer
Est dolor corrupti exercitationem. Rerum dicta sed quos magni optio accusantium. Sed ratione dignissimos quia et sint nihil quasi. Veritatis numquam adipisci quaerat.
Vitae non dolorem natus odio accusantium qui. Modi ea quia et cumque. Maxime sit et laboriosam eaque sint. Molestiae quasi quaerat consequuntur quas id eveniet temporibus accusamus.
Debitis dolores rerum sit nulla. Accusantium numquam distinctio voluptatem. Est voluptates consequuntur hic minus non recusandae eos. Animi quia voluptas aut quis et quia.
Maxime labore nesciunt laboriosam deserunt eum ut. Qui atque eum consequuntur mollitia et saepe. Magnam perferendis odio omnis harum.
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...
Sed dolorem iure ipsam ullam omnis dignissimos eos et. Voluptatem et vitae in delectus ratione nesciunt. Explicabo voluptates et quia ex expedita eveniet. Enim alias laudantium quidem a. Qui alias quod incidunt sit iusto aspernatur harum.
Praesentium placeat et explicabo voluptate soluta quia ratione quas. Accusantium provident nesciunt impedit. Nemo consequatur hic ipsam cum.