Best Response

http://www.exinfm.com/free_spreadsheets.html

www.focusinvestor.com/DiscountedCashFlows.xls

http://www.independent-stock-investing.com/Discounted-Cash-Flow.html

http://www.macabacus.com/valuation/enterprise-value (in the 'Topics' tab drop down menu check 'Valuation' and there is a DCF template in the LBO tab as well .. i know it will be different due to its purpose being entirely different .. but you can modify it to suit your needs)

I have a model but it is very very raw in its formatting and manner of valuation (pathetic at best).. plus the assumptions are weak at best for example the assumptions for debt structure were not made in any detail just used a horizontal analysis and vertical analysis in conjunction with the SGR (sustainable growth rate) to forecast the debt structure.. the revenue projections were based upon inflation and population growth ... no independent industry analysis/data was available since data collection in my country is pretty much non existent for most manufacturing concerns' products and consumer consumption patterns

I do not remember clearly but i think the valuation's DCF model was made into a 3 stage model with an exponential decay for the growth rate but there was a problem with the calculation of the WACC because the Required Market Return was not sourced nor was it calculated... a team member just put it in there but when I asked the source or the calculation method there was no answer (so yes it was a mess) and the cost of debt was not calculated properly (i think so - can't remember clearly)... plus the company we were analyzing (as students) just had its IPO done, so we could not use p/e multiples for its valuation nor could we use the peer group multiples.. since the other businesses within the industry were substantially different and the EV/EBITDA multiple was not used either, cannot remember the reason but I think it had something to do with the fact that the Parent company was going to assume the debt ...however if you still want that crappy model I do not mind giving it to you .. i also have the PPT and the report if you want em

some extra advice and links for interview questions:-

http://blogs.cfainstitute.org/investor/2013/09/12/advice-on-how-to-become-a-research-analyst/

webuser.bus.umich.edu/.../Equity_Research_Interview_Questions.doc‎

also the modelling is a small part of the ER job .. some of the interview questions in the links below will help http://www.lbsimc.org/content/index_5_2145523323.pdf ---- (i have summarized and categorized the questions in this link to make them more suitable for ER .. let me know if you want them)

http://myfinanceinterview.com/category/equity-research-interview-questions/

webuser.bus.umich.edu/Organizations/.../Equity_Research_Ins_Outs.ppt‎

this is an excellent description of equity research //www.wallstreetoasis.com/forums/here-is-how-equity-research-works

questions/ideas just the top of my head

the reasoning behind the:- 1. Valuation method you like or don't 2. Industry/sector you prefer 3. Your stock pick 4. Investment philosophy/style if you have one 5. Global stock picks

understanding how a company works and why should you invest questions you would ask during a site visit your enthusiasm for investing and stocks in particular why the sell side

add your personal view about how to analyze and valuate companies

do read a lot on valuation

there are a lot of questions in the links above check them if you want to

 

there is no actual "practice model" people could send you becuase each ER firm has their own proprietary built model with different types of drivers and calculations, formulas, links, etc.... Here is what I will tell you though, review different types of press releases (the GAAP and non-gaap numbers on those press releases). Understand everyone on the income statement and how to calculate the FCF using the press release because those are all things that would be involved in a post press release type email to clients or into the research note on earnings. Make sure you are very comfortable with a financial model and how the income statement works (very basic) but probably going to be the main determinant on if you pass. I actually had to do this same exam and I aced it.. the hardest part about this entire task is you dont know 1) the model you're going to get (so you'll be kinda shaky about th entire thing), and 2) where to get the data to fill out the entire model... remember, sometimes you need the Press Release, the earnings presentation and other data points to complete/update the entire model... so make sure you know where to get all those things before your exam.

.
 

Is it possible that the press release will not give enough information to fill out the most recent period on the three-statement model? As in, you would only get enough information to fill out the income statement but not the entirety of the balance sheet / cash flow statement? What to do in this situation? Or will a 10q/10k most likely be provided? Really appreciate the advice.

 

Is it possible that the press release will not give enough information to fill out the most recent period on the three-statement model? As in, you would only get enough information to fill out the income statement but not the entirety of the balance sheet / cash flow statement? What to do in this situation? Or will a 10q/10k most likely be provided? Really appreciate the advice.

 

adding to @quattroblanc 's updating existing model using a quarterly earnings release, also updating forecast of next quarter and full FY, as well as writing a list of questions to company's management in terms of new guidence, new development, & corporate strategy etc.

 

if you spent 7 months as an associate.

I had to take a 3 hour modeling test for my current position so I'm sure yours will be similar. They will probably give you a current model and a company's press release, and you will be responsible for keying in the results, getting the model to balance, and then adjust drivers in future periods based on past results and commentary from the press release.

Should be cake if you've done anything like this before. If not I would spend some time practicing and reacquainting yourself with how the financial statements interact.

 

On 3, you'd probably have to update the model for the latest quarter and make the necessary adjustments to get to their adjusted EPS number. Also, you'd probably have to forecast the rest of the year, as well as the out years, and every other line item in addition to revenue. See http://www.treetis.com/blog/2015/3/6/modeling-home-depot for my blog post on how to forecast some of those things. Hopefully it wouldn't be too complicated of a model.

I don't think many places would have you build out a model from scratch in 3 hours, but I suppose it's not out of the realm of possibility. You would just need to practice building out simple models, and you'll get the hang of it. It might take some time at first, but after awhile it's not too bad because many of the line items have similar drivers.

I was also part of a team that gave out an excel file with industry-specific data to interview applicants. They had to update it with the latest data and write a research report on the results. Fairly straight forward but many applicants struggled to describe the data accurately. They missed out on a couple things: 1) the most important thing was that there were certain trends in the data that they failed to notice. In addition to writing about what the absolute number was, you always have to kind of step back from the factual reporting of it, and also talk a little bit about the significance of it and the context of it. 2) there's a certain language/tone to ER writing that people did not write in. Not a huge deal since this is something you can pick up on as you read and write more ER reports, but it's something that would stand out if you could get it right.

 

I’m not working in ER, but when I interviewed for ER positions, I had these two kinds of tests:

  1. Write a full initiation report on a company. This would take a few weeks.
  2. Update a model and write an earnings note based on a transcript, press release, and previous notes (for use as templates). I had 3 hours for this, and it took just under that.
"There's nothing you can do if you're too scared to try." - Nickel Creek
 

I did a modeling test for ER recently, they gave a model with highlighted cells to populate the quarterly earning results into the spreadsheet using the company's press release. And then link the formulas.

You said you are solid with IB technical, then I assume you know how three statements link together. Make sure you know to model both on annual and quarterly basis. Why not just pick a simple company (preferably one that does not do business in multiple industries, so avoid companies like GE, P&G, they are too big anyways) and build a three-statement model, take out one quarter of data, and then update it using the quarterly press release.

 

Sequi odit sit et inventore hic dolor. Sit odio eligendi id sapiente. Sint corporis aspernatur atque enim qui. Sed qui dolor sed consectetur.

Ut maxime aspernatur et nemo vel assumenda culpa quod. Corrupti aut sunt perspiciatis sequi est deserunt. In quas cumque magni reprehenderit unde.

Enim sed exercitationem ratione accusamus perspiciatis et. Aut nisi reprehenderit harum magni quasi provident ullam qui. Consequatur ipsum optio voluptatem optio voluptas placeat non.

 

Sequi et sed dolorem optio reiciendis hic. Sint aut dolore deleniti sed officia. Quisquam laboriosam blanditiis non labore qui voluptate odio deleniti. Vel magnam laudantium facilis ab molestias. Voluptatum inventore eaque voluptatem beatae sequi corrupti et. Deleniti qui id consectetur.

Quisquam hic veniam dicta voluptatum fugiat nobis sint. Aut consequatur et deleniti excepturi eaque.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
kanon's picture
kanon
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”