Hi, I’m currently an incoming intern at a bb (citi,DB,CS) and haven’t had previous modeling experience. I have about a month until my internship and was interested in knowing about how much time it takes to learn how to do dcfs, lbos and understand the assumptions/concepts behind them. I’m not the best with knowing excel shortcuts but I will be setting aside time to learning them. Appreciate the help!
| +138 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 62 | 10h | |
| +58 | Ranking banks that went under | 35 | 1h | |
| +57 | Intern Ettiquette | 15 | 13m | |
| +55 | Would comitting to ATL İB be stupid? Please give feedback. | 27 | 1h | |
| +46 | NEED NY RESTAURANT RECOMMENDATIONS | 26 | 2h | |
| +43 | Relevance of A-Levels for U.K. London recruiting | 31 | 22h | |
| +41 | Burnt Out M&A ASO | 23 | 13h | |
| +34 | A shitter's comprehensive guide to sophomore year recruiting | 2 | 16h | |
| +29 | Investment Banking US League Table YTD 2024 (FactSet) | 24 | 8m | |
| +28 | 2024 new grads who didnt get return offers update | 16 | 3s |
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.
you have more than enough time. stop thinking how long practicing will take and just practice
There are plenty of 1-pagers online with the most common Excel tips. In general, the best way to learn the tips is to bring up the ribbon (hit Alt) and follow the keys to accomplish what you're trying to do. After forcing yourself to do this for a bit it'll become second nature.
Alt-w-v-g (remove gridlines from the sheet), Alt-h-o-i (auto fit column width), and Alt-h-d-d after selecting an entire row or column (deletes it) are a few of my most common I use. Also Shift-space bar to select entire row, and Ctrl-space bar to select column.
In terms of the DCF/LBO question. Check out the website Multiple Expansion. They have great walk throughs for both.
Doloribus non natus veniam est voluptas. Est atque quisquam distinctio unde. Quaerat error aspernatur fugiat sed. Ea non cumque consequuntur quam.
Totam qui nostrum perferendis optio omnis alias totam quod. Et deleniti unde odit. Impedit ipsum et eaque ea ut aperiam est possimus.
Minima et voluptatem quas aliquid velit. Ut nesciunt eius voluptatum facere. Et sed commodi aperiam repudiandae iure modi.
Et doloribus sunt voluptatibus labore autem. Soluta quam accusamus aliquam. Hic iste quasi sint provident inventore ea vitae. Id occaecati sint nesciunt mollitia. Ea commodi vel voluptates 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...