In this tutorial, you’ll learn how to prepare for “fit” questions in investment banking interviews efficiently and how to use the “Rule of 3” to develop short anecdotes and responses that you can re-use to answer the most common questions. http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Table of Contents: 3:57 Your 3 “Short Stories” 6:22 Your 3 Strengths and 3 Weaknesses 8:36 Your Top 3 Real Weaknesses 12:59 Recap and Summary Lesson Outline: The WORST way to approach “fit” questions is to memorize dozens or hundreds of questions and answers. Instead, you should develop a few stories that you can use and re-use for the most common qualitative questions. Your 3 “Short Stories” should include a Success Story, a Failure Story, and a Leadership Story that demonstrate the qualities bankers are looking for: Analytical skills, ability to work in a team, ability to work long hours, attention to detail, communication skills, and a demonstrated interest in finance. For example, you could discuss an internship where you made several corporate finance processes more efficient, a Treasury internship where you worked with other departments to help the company avoid breaching a Debt covenant, and a math tutoring business you started but ultimately had to shut down. Your 3 Strengths should be easy because you already know the qualities bankers are seeking. Your 3 Weaknesses are tougher because they must be real, but not too real, they can’t be overly personal, and they must be things you could conceivably fix (e.g., don’t say you’re “too short”). You could say that you take too long to make decisions or second-guess yourself, that you’re not always good about speaking up, or that you don’t always follow up on tasks and assignments. For your 3 “Real Weaknesses,” compare yourself to the *ideal* candidate for IB roles (Ivy League school, perfect grades and test scores, accounting/finance major, multiple languages, multiple finance internships, sports, study abroad, and international recognition in some area), and assess how you’re different. Maybe you went to a non-target school or you have low grades; maybe you don’t have much finance experience or you became interested in banking too late; or maybe you haven’t taken any accounting or finance classes. Find your top 3 weaknesses and develop ways to address them. For example, you could say that your family couldn’t afford an Ivy League school or that you attended your university because of a generous scholarship. Or you could explain that you’ve been moving in the direction of finance ever since you became interested in it, despite a late start that precluded you from winning internships. Or you could point to self-study, the CFA, or other courses to explain your accounting/finance skills and how you’ve learned the requirements independently. RESOURCES: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Investment-Banking-Fit-Questions.pdf
Views: 32163 Mergers & Inquisitions / Breaking Into Wall Street
In this lesson, you'll get a quick and easy-to-implement, but still very effective. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" You'll also get tips on how to improve your resume / CV walk-through in investment banking, private equity, and other finance interviews. Your resume walk-through is how you answer the "Tell me about yourself" or "Walk me through your resume" or "Why are you here today?" question when you walk into an interview and first introduce yourself. This is IMPORTANT because it's y our first impression, and interviewers often decide your status within the first 5 minutes of the interview. Come across well, and you can answer other questions poorly but still receive a job offer or move onto the next round; come across poorly, and you won't move to the next round no matter how great your Excel skills are. We recommend this outline for your resume walk-through: 1. The Beginning - Where you went to school, where you started out working, your family background, etc. 2. The Spark - What, specifically, made you interested in finance initially? A person? An event? Your parents day trading or running a business? A professor? An internship? 3. Growing Interest - How did you develop this interest via classes, activities, further internships or jobs, and your networking and self-study efforts? 4. The Future / Why You're Here Today - What's your future goal (advising / investing in companies?) and how will working at this firm allow you to contribute TO that firm while also achieving your long-term goals? THE PROBLEM: Often, the last part - the "Future" / "Why You're Here Today" segment is BORING and what you say sounds identical to everyone else's statement. "I want to become a trusted adviser to companies." "I want to invest in companies in XX sector." THE SOLUTION: Link it back to the FIRST PART of your story - either your Beginning or Spark - to make it more memorable and attention-grabbing. It works in movies (see: Inception and The Usual Suspects), and it works in interviews, too! Example 1: You're in a private equity interview, and your Spark is how you helped a private tech company raise funds; you saw additional expansion opportunities via partnerships and other deals, but in investment banking you just advise on one deal and that's it... so you started looking into PE in more detail. Instead of just saying, "I want to combine my interest in tech with my background in finance and invest in tech companies in the future," say: "So I'm here today because of that original situation with the private company that sparked my interest in the industry - I want to get more opportunities like that, where I can help improve businesses over the long-term via partnerships, acquisitions, and operational changes that you only get to implement in private equity. And in the future, I want to be an investor in the tech sector, and your firm is the best place for that because... [Insert the rest of your reasons here]" Example 2: You're in an investment banking interview, and your Spark was working at a non-profit that merged with another non-profit one summer, after which you started taking more finance classes and learning more about the industry. You have a background in public policy, and your long-term plan is to advise in the Project Finance / Public Finance sectors. Instead of just saying that for the last part of your story, you could say: "I want to advise organizations that may not be as ‘savvy’ about finance, like the merged non-profit I was at a few years ago – and become a trusted adviser to those types of public/private organizations. Your firm is the ideal place to do that because of [And insert references to other deals or clients they've advised here]."
Views: 60586 Mergers & Inquisitions / Breaking Into Wall Street
How to Tell Your Story in Investment Banking Interviews - Updated for 2017. A lot of our advice from past years is still applicable, but a few things have changed over time. Table of Contents: 1:08 Part 1: What’s Different About Your Story Now? 1:47 Part 2: What is Your Story? 2:45 Part 3: How to Tell Your Story in 4 Simple Steps 10:20 Part 4: Mistakes to Avoid in Your Story 12:02 Recap and Summary To get the full written version, templates, and other examples, click on the links below: http://www.mergersandinquisitions.com/how-to-tell-your-story-investment-banking-interviews/
Views: 43730 Mergers & Inquisitions / Breaking Into Wall Street
How to Tell Your "Story" in Investment Banking Interviews in 5 Simple Steps... http://www.mergersandinquisitions.com/how-to-tell-your-story-investment-banking-interviews/ (Get the full article and transcript here) In past tutorials we've talked a lot about your "story" in interviews, how important it is, and the mistakes you could make that will cost you an offer. But now I'm going to go beyond that and actually give you a blueprint that will let you tell your "story" effectively and win offers no matter what level you're at. Why Does This Matter So Much? Three reasons: - Your story sets the tone for the entire interview, and a poor first impression is impossible to overcome.- Interviewers often make offer / no offer decisions subconsciously within the first 2-3 minutes, based 100% on your story. - It's easier to fix your "story" than to "fix" your lack of finance/accounting knowledge. We're talking hours vs. weeks. In this lesson, you'll learn how to craft your story to wow your interviewers and land lucrative investment banking job offers. --- WANT MORE FREE TUTORIALS, TIPS & TEMPLATES? Subscribe to the Banker Blueprint, a complete action plan for getting into Investment Banking, PE and Hedge Funds. www.mergersandinquisitions.com/banker-blueprint
Views: 87091 Mergers & Inquisitions / Breaking Into Wall Street
You’ll learn about the most common merger model questions in this tutorial, as well as what type of “progression” to expect and the key principles you must understand in order to answer ANY math questions on this topic. Table of Contents: 3:26 Question #1: The Basic Rules 5:23 Question #2: With Real Numbers 8:21 Question #3: Equity Value, Enterprise Value, and Valuation Multiples 12:17 Question #4: Ranges for the Multiples 14:26 Question #5: What if the Buyer is Twice as Big? 16:26 Recap, Summary, and Key Principles Question #1: The Basic Rules "A company with a P / E multiple of 25x acquires another company for a purchase P / E multiple of 15x. Will the deal be accretive or dilutive?" ANSWER: You can’t tell unless it’s a 100% Stock deal. If it is, it will be accretive because the Cost of Acquisition is 1 / 25, or 4%, and the Seller’s Yield is 1 / 15, or 6.7%. Since the Seller’s Yield is higher, it will be accretive. For Cash and Debt deals, or deals with a mix of all three, you’d calculate the Weighted Cost of Acquisition by using Foregone Interest Rate on Cash * (1 – Buyer’s Tax Rate) * % Cash + Interest Rate on Debt * (1 – Buyer’s Tax Rate) * % Debt + 1 / (Buyer’s P / E Multiple) * % Stock and compare that to the Seller’s Yield. Question #2: With Real Numbers “Let’s say it is a 100% Stock deal. The Buyer has 10 shares at a share price of $25.00, and its Net Income is $10. It acquires the Seller for a Purchase Equity Value of $150. The Seller has a Net Income of $10 as well. Assume the same tax rates for both companies. How accretive is this deal?” ANSWER: The buyer’s EPS is $10 / 10 = $1.00. It must issue 6 additional shares to do the deal, so the Combined Share Count is 10 + 6 = 16. Since both companies have the same tax rate and since no Cash or Debt is used, Combined Net Income = $10 + $10 = $20, and Combined EPS = $20 / 16 = $1.25, so the deal is 25% accretive. Question #3: Equity Value, Enterprise Value, and Valuation Multiples “What are the Combined Equity Value and Enterprise Value in this same deal? Assume that Equity Value = Enterprise Value for both the Buyer and Seller.” ANSWER: Combined Equity Value = Buyer’s Equity Value + Value of Stock Issued in the Deal = $250 + $150 = $400. Combined Enterprise Value = Buyer’s Enterprise Value + Purchase Enterprise Value of Seller = $250 + $150 = $400. The Combined EV / EBITDA multiple won’t be affected by the mix of Cash, Stock, and Debt, but the P / E multiple will be. It’s 20x here ($400 / $20), but it will change for non-100%-Stock deals. Question #4: Ranges for the Multiples “Without doing any math, what ranges would you expect for the Combined EV / EBITDA and P / E multiples, and why?” ANSWER: They should be somewhere in between the Buyer’s multiples and the Seller’s purchase multiples. It’s almost never a simple average because of the relative sizes of the Buyer and Seller – and for P / E, the purchase method also plays a role. Question #5: What if the Buyer is Twice as Big? "What happens if the Buyer is twice as big, i.e. it has an Equity Value of $500 and Net Income of $20?" ANSWER: The deal becomes *less* accretive because the company making it accretive, the Seller, now has a lower weighting. The Buyer was previously $250 / $400 of the total, but is now only $500 / $650, which is ~63% vs. ~77%, so we’d expect accretion to fall by 10-15%, which it does. The Combined Multiples will all be closer to the Buyer’s multiples now as well. Recap, Summary, and Key Principles Principle #1: If the Seller’s Yield is above the Weighted Cost of Acquisition, it’s accretive; dilutive if the opposite. Principle #2: Combined Equity Value = Buyer’s Equity Value + Value of Stock Issued in the Deal. Principle #3: Combined Enterprise Value = Buyer’s Enterprise Value + Purchase Enterprise Value of Seller. Principle #4: The Combined P / E Multiple is affected by the Cash / Debt / Stock mix, but the Combined EV / EBITDA Multiple is not. Principle #5: The Combined Multiples will be in between the Buyer’s multiples and the Seller’s purchase multiples – exact numbers depend on sizes of the Buyer and Seller. RESOURCES: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/108-11-Merger-Model-Interview-Questions-Slides.pdf https://youtube-breakingintowallstreet-com.s3.amazonaws.com/108-11-Merger-Model-Interview-Questions.xlsx
Views: 26527 Mergers & Inquisitions / Breaking Into Wall Street
In this tutorial, you'll learn about the most common LBO modeling-related questions and some tricks and rules of thumb you can use to approximate the IRR and solve for assumptions like the purchase price and EBITDA growth in leveraged buyouts. Table of Contents: 2:36 Question #1: LBO Model Walkthrough 5:34 Question #2: Ideal LBO Candidates 8:09 Question #3: How to Approximate IRR 11:46 Question #4: How to Solve for EBITDA or the Purchase Price 13:58 Question #5: How to Approximate the IRR in an IPO Exit 16:03 Recap, Summary, and Key Principles Lesson Outline: Will you get LBO-related questions in interviews? Yes, possibly, but full case studies are unlikely unless you're interviewing for PE roles or more advanced IB roles. Interviewers now ask trickier questions about the fundamentals, they ask progressions of questions on the same topic or scenario, and they're more likely to give you *simple* cases and numerical tests rather than complex ones. A typical progression for LBO models might be as follows: Question #1: LBO Model Walkthrough "In a leveraged buyout, a PE firm acquires a company using a combination of Debt and Equity, operates it for several years, and then sells it; the math works because leverage amplifies returns; the PE firm earns a higher return if the deal does well because it uses less of its own money upfront." In Step 1, you make assumptions for the Purchase Price, Debt and Equity, Interest Rate on Debt, and Revenue Growth and Margins. In Step 2, you create a Sources & Uses schedule to calculate the Investor Equity paid by the PE firm. In Step 3, you adjust the Balance Sheet for the effects of the deal, such as the new Debt, Equity, and Goodwill. In Step 4, you project the company's statements, or at least its cash flow, and determine how much Debt it repays each year. Finally, in Step 5, you make assumptions about the exit, usually using an EBITDA multiple, and calculate the MoM multiple and IRR. Question #2: Ideal LBO Candidates Price is the most important factor because almost any deal can work at the right price – but if the price is too high, the chances of failure increase substantially. Beyond that, stable and predictable cash flows are important, there shouldn't be a huge need for ongoing CapEx or other big investments, and there should be a realistic path to exit, with returns driven by EBITDA growth and Debt paydown instead of multiple expansion. Question #3: Approximating IRR "A PE firm acquires a $100 million EBITDA company for a 10x multiple using 60% Debt. The company's EBITDA grows to $150 million by Year 5, but the exit multiple drops to 9x. The company repays $250 million of Debt and generates no extra Cash. What's the IRR?" Initial Investor Equity = $100 million * 10 * 40% = $400 million Exit Enterprise Value = $150 million * 9 = $1,350 million Debt Remaining Upon Exit = $600 million – $250 million = $350 million Exit Equity Proceeds = $1,350 million – $350 million = $1 billion IRR: 2.5x multiple over 5 years; 2x = 15% and 3x = 25%, so it's ~20%. Question #4: Back-Solving for Assumptions "You buy a $100 EBITDA business for a 10x multiple, and you believe that you can sell it again in 5 years for 10x EBITDA. You use 5x Debt / EBITDA to fund the deal, and the company repays 50% of that Debt over 5 years, generating no extra Cash. How much EBITDA growth do you need to realize a 20% IRR?" Initial Investor Equity = $100 * 10 * 50% = $500 20% IRR Over 5 Years = ~2.5x multiple (2x = ~15% and 3x = ~25%) Exit Equity Proceeds = $500 * 2.5 = $1,250 Remaining Debt = $250, so Exit Enterprise Value = $1,500 Required EBITDA = $150, since $1,500 / 10 = $150 Question #5: Approximating IRR in an IPO Exit "A PE firm acquires a $200 EBITDA company for an 8x multiple using 50% Debt. The company's EBITDA increases to $240 in 3 years, and it repays ALL the Debt. The PE firm takes it public and sells off its stake evenly over 3 years at a 10x multiple. What's the IRR?" Initial Investor Equity = $200 * 8 * 50% = $800 Exit Enterprise Value = Exit Equity Proceeds = $240 * 10 = $2,400 "Average Year" to Exit = 1/3 * 3 + 1/3 * 4 + 1/3 * 5 = 4 years IRR: 3x over 3 years = ~45%, and 3x over 5 years = ~25% Approximate IRR: ~35% (This one's a bit off – see Excel.) RESOURCES: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-13-LBO-Model-Interview-Questions-Slides.pdf
Views: 49791 Mergers & Inquisitions / Breaking Into Wall Street
Why You Can't Network Your Way Into Investment Banking -- and What to Do About It http://www.mergersandinquisitions.com/network-investment-banking-mistakes/ (Get the full article here)
Views: 16072 Mergers & Inquisitions / Breaking Into Wall Street
Goldman Sachs only accepts around three percent of job applicants. Who gets hired? How much are they paid? WSJ's Jason Bellini has #TheShortAnswer on what college students considering investment banking should know. Subscribe to the WSJ channel here: http://bit.ly/14Q81Xy Visit the WSJ channel for more video: https://www.youtube.com/wsjdigitalnetwork More from the Wall Street Journal: Visit WSJ.com: http://online.wsj.com/home-page Follow WSJ on Facebook: http://www.facebook.com/wsjlive Follow WSJ on Google+: https://plus.google.com/+wsj/posts Follow WSJ on Twitter: https://twitter.com/WSJLive Follow WSJ on Instagram: http://instagram.com/wsj Follow WSJ on Pinterest: http://www.pinterest.com/wsj/ Follow WSJ on Tumblr: http://www.tumblr.com/tagged/wall-street-journal Don’t miss a WSJ video, subscribe here: http://bit.ly/14Q81Xy More from the Wall Street Journal: Visit WSJ.com: http://www.wsj.com Visit the WSJ Video Center: https://wsj.com/video On Facebook: https://www.facebook.com/pg/wsj/videos/ On Twitter: https://twitter.com/WSJ On Snapchat: https://on.wsj.com/2ratjSM
Views: 529287 Wall Street Journal
Sherjan Husainie, of Leaders Global Network, offers career workshops in ten major cities around the world. He has worked in both investment banking at Morgan Stanley and in private equity at Google Capital. For more info, visit http://www.leadersgn.com/
Views: 236366 Career Insider Business
Dan Sheyner, author of the Wall St Oasis Private Equity Interview Guide discusses the industry trends. Check out the popular guide Private Equity Prep Pack here: http://www.wallstreetoasis.com/guide/the-wso-private-equity-interview-prep-package
Views: 44865 WallStreetOasis
Thanks for visiting my channel - make sure you watch in HD! Here are my insights on how I secured internships in my first year at Goldman Sachs with tips on how you can do the same. Find out more about how to get your foot in the door on my Blog: https://www.angeliculture.com/ambition Harvard Study: https://www.youtube.com/watch?v=zmR2A9TnIso Business and general enquiries: [email protected] CONNECT WITH ME Twitter - angeliculture Instagram - angeliculture Snapchat - laraang In the meantime, let's continue the conversation in the comments section below xo
Views: 13654 Angeliculture
How to Network Your Way Into Investment Banking in 5 Simple Steps http://www.mergersandinquisitions.com/network-investment-banking-5-simple-steps/ (Get the full article right here)
Views: 37267 Mergers & Inquisitions / Breaking Into Wall Street
WSO Video Library (100+ full webinars): http://www.wallstreetoasis.com/wall-street-videos Interview Guides: http://www.wallstreetoasis.com/guide-to-finance-interviews WSO Resume Review: http://www.wallstreetoasis.com/wso-finance-resume-review WSO Mentors: http://www.wallstreetoasis.com/wall-street-mentors-finance-mock-interviews WSO Events: http://www.wallstreetoasis.com/events
Views: 442 WallStreetOasis
In this LBO Model tutorial, you'll learn how to build a very simple LBO model "on paper" that you can use to answer quick questions in PE (and other) interviews. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" This matters because in many cases, they'll ask you to calculate numbers such as IRR and multiple of invested capital very quickly and will not actually ask you to build a more complex model until later in the process. You should always START this exercise by looking at the actual question or set of questions they are asking you: "Calculate the purchase price required for ABC Capital to obtain a 3.0x multiple of invested capital (MOIC) if it plans to sell OpCo after five years at an EV / EBITDA multiple of 6.0x." So they're giving you the exit multiple and the return on investment that the PE firm is targeting, and you have to figure out the initial purchase price by "working backwards." Here's how we interpret each line in this case study and use it in the model: "OpCo currently has EBITDA of $250mm, and ABC believes that the new management team could keep EBITDA flat for the next 5 years." This tells you to make the initial EBITDA $250mm and keep it at that level for 5 years - skip revenue, COGS, OpEx, and everything else because none of that matters if this is all they give you. "ABC Capital has obtained debt financing of $750mm at 10% interest, and OpCo expects working capital to be a source of funds at $6mm per year." The initial debt balance is $750mm and there's a 10% interest rate, so the interest expense will be $75mm per year. In the "Cash Flow Statement Adjustments", since Working Capital is a SOURCE of funds it will add $6mm to cash flow each year. "OpCo requires capital expenditures of $35mm per year, and it has a tax rate of 40%. Assume no transaction fees, zero minimum cash required, and that PP&E on the balance sheet remains constant for the next 5 years." Also in the CFS section, CapEx = $35mm per year, and Depreciation also equals $35mm per year since the PP&E balance does not change at all. So you can also fill in the Depreciation figure on the Income Statement. No transaction fees and no minimum cash requirement simplify the purchase price and debt repayment - although we don't even have debt repayment here. "Assume that excess cash is NOT used to repay debt, and instead simply accumulates on the Balance Sheet." This makes the final numbers easier to calculate, since interest expense will never change and you can simply add up cash generated to get to the final cash number at the end. PROCESS: 1. Start with the Income Statement - EBITDA is $250mm per year. Subtract Depreciation of $35mm per year, and interest of $75mm per year. So EBIT = $140mm. Taxes = $140mm * 40%, so Net Income = $140mm - $56mm = $84mm. 2. On the simplified CFS, Net Income = $84mm, Depreciation = $35mm, Change in Working Capital = $6mm, CapEx = ($35mm), so Cash Generated per year = $90mm. 3. EBITDA Exit Multiple = 6.0x, and final year EBITDA = $250mm, so Exit EV = $1.5B. Subtract the outstanding debt of $750mm and add the cash generated in this period of $450mm, so Equity Proceeds = $1.2B. 4. Targeted MOIC = 3.0x so the PE firm would have to invest $400mm in the beginning. $400mm equity + $750mm debt = $1.150B, so the purchase multiple is $1,150 / $250 = 4.6x. Further Resources http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-04-Simple-LBO-Model.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-04-Simple-LBO-Model.xlsx
Views: 228051 Mergers & Inquisitions / Breaking Into Wall Street
Request Download links on [email protected] Breaking Into Wall Street – IB Networking Toolkit plus IB Interview Guide Download Breaking Into Wall Street – IB Networking Toolkit plus IB Interview Guide Torrent Breaking Into Wall Street – IB Networking Toolkit plus IB Interview Guide Free Breaking Into Wall Street – IB Networking Toolkit plus IB Interview Guide Full Request Download links on [email protected] https://www.youtube.com/watch?v=hjo0M9bINL0&feature=youtu.be https://www.youtube.com/watch?v=hjo0M9bINL0&feature=youtu.be https://www.youtube.com/watch?v=hjo0M9bINL0&feature=youtu.be https://www.youtube.com/watch?v=hjo0M9bINL0&feature=youtu.be https://www.youtube.com/watch?v=hjo0M9bINL0&feature=youtu.be
Views: 172 Lisa Coffman
Learn about rules of thumb you can use to determine whether an acquisition will be accretive or dilutive in advance, based on the P/E multiples of the buyer and seller, the % cash, stock, and debt used, and the prevailing interest rates on cash and debt. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Here's an outline of what we cover in the lesson, and the step-by-step process you can follow to figure this out for yourself: Why Do We Care About Rules of Thumb for M&A Deals / Merger Models? It's a VERY common interview question - "How can you tell whether an M&A deal is accretive or dilutive?" People often believe, incorrectly, that there's no way to tell without building the entire model. But shortcuts always exist! Plus, this shortcut is very useful in real life. You can use it to "sanity check" your model, approximate the impact of a deal in advance, and so on. So it's a time-saver *and* a good way to check your work. Rules of Thumb for Merger Models AKA Accretion / Dilution Models: CONCEPT: An M&A deal is accretive if the combined company's EPS (Earnings Per Share) is higher than the buyer's standalone EPS prior to the transaction. It's dilutive if the combined EPS is lower, and it's neutral if the EPS is the same afterward. The outcome depends on price paid for the seller, the method of payment (cash, stock, or debt), the interest rate on debt and cash, and the buyer's P/E multiple, among other factors. In real life, it's very difficult to tell with high precision whether the deal will be accretive or dilutive without running the whole model - due to added costs, synergies, write-ups, timing differences, the cumulative impact of additional interest on debt and foregone interest on cash, etc... BUT you can approximate the impact with a simple rule of thumb: 1. Calculate the Weighted "Cost" of Acquisition for the Buyer... 2. And compare it to the Seller's "Yield" AT its purchase price. (i.e. Seller's Net Income / Equity Purchase Price) This step is essential - if the seller is currently valued at $900 million and the buyer pays $1 billion for the seller, you NEED to use the $1 billion actually paid for the seller or these yields won't be correct. 3. If the Seller's "Yield" is higher, it's accretive - otherwise, if it's lower, it's dilutive... Think of it as the buyer getting MORE *from* the seller than what it's paying for the seller, vs. getting LESS than what it's paying. 4. How do you calculate the Weighted "Cost" of Acquisition? You need to calculate the after-tax "cost" of each component, since Net Income is also after-tax. After-Tax Cost of Cash = Foregone Cash Interest Rate * (1 - Buyer's Tax Rate) After-Tax Cost of Debt = Interest Rate on Debt * (1 - Buyer's Tax Rate) After-Tax Cost of Issuing Stock = 1 / Buyer's P/E Multiple (i.e. take the reciprocal of the buyer's P/E multiple) That last one is effectively the buyer's "after-tax yield"... For example, if you buy 1 share of the buyer's stock, it's the Net Income you'd be entitled to with that 1 share... So in this example, 1 / Buyer's P/E Multiple = 1 / 11.3 x = 8.9%. That means that for each $1.00 of United stock you buy, you get $0.089 in Net Income. Finally, you calculate the Weighted Average Itself with this formula: Weighted Average Cost of Acquisition = Cost of Cash * % Cash Used + Cost of Stock * % Stock Used + Cost of Debt * % Debt Used And if this weighted average cost of acquisition is greater than the seller's yield, it's dilutive - otherwise, if the weighted average cost of acquisition is lower than the seller's yield, it's accretive. LIMITATIONS: This trick doesn't hold up if the tax rates for the buyer and seller are different, especially if they're VERY different. This also doesn't work if you also factor in write-ups / write-downs, synergies, the cumulative impact of interest paid on debt and foregone interest on cash, merger closing costs, integration costs, etc... And it also doesn't work if the acquisition closes mid-year or in between fiscal years - you need to adjust for that with stub periods and the calendarization of financials... But this is a common interview question, so who cares! It's still very useful to know, and will save you a lot of time in interviews and on the job.
Views: 67383 Mergers & Inquisitions / Breaking Into Wall Street
A walk-through on how to calculate EBITDA (Earnings Before Interest, Taxes, Depreciation & Amortization) for Steel Dynamics. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" EBITDA is important NOT because it is a good "proxy for cash flow" - as is commonly claimed by financiers and some academic sources - but rather because it lets you more easily compare different companies' valuations, especially companies with different capital structures, tax rates, and depreciation policies. To calculate it, you start with Operating Income (EBIT) on the Income Statement, and then add back Depreciation & Amortization (D&A) on the Cash Flow Statement, and then any other one-time or non-recurring charges you find on the financial statements or in the Notes to the Financial Statements. To qualify as an add-back, an item MUST: 1. Actually be non-recurring. A Restructuring Charge that has recurred every year over the past 10 years is NOT "non-recurring" even if the company claims it's just temporary. 2. Impact Operating Income. You would never add back something like Deferred Income Taxes because they're "below the line" and only impact the company's Income Taxes, not its Operating Income. Sometimes, items could go either way; for example, some banks and groups add back Stock-Based Compensation while others do not. We keep things as simple as possible and ONLY add back charges that are truly non-recurring and ones that actually impact Operating Income in this example. You'll learn how to tell whether or not an item meets those criteria above, even when it's a tricky case such as deciding if Gains / (Losses) truly affect the Operating Income line. WANT MORE FREE FINANCIAL MODELLING TUTORIALS? Receive a Free 3-Part Tutorial on How to Build Your First Merger Model based on the $16B United / Goodrich deal. Visit: www.breakingintowallstreet.com/biws
Views: 51595 Mergers & Inquisitions / Breaking Into Wall Street
In this WACC and Cost of Equity tutorial, you'll learn how changes to assumptions in a DCF impact variables like the Cost of Equity, Cost of Debt. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" You'll also learn about WACC (Weighted Average Cost of Capital) - and why it is not always so straightforward to answer these questions in interviews. Table of Contents: 2:22 Why Everything is Interrelated 4:22 Summary of Factors That Impact a DCF 6:37 Changes to Debt Percentages in the Capital Structure 11:38 The Risk-Free Rate, Equity Risk Premium, and Beta 12:49 The Tax Rate 14:55 Recap and Summary Why Do WACC, the Cost of Equity, and the Cost of Debt Matter? This is a VERY common interview question: "If a company goes from 10% debt to 30% debt, does its WACC increase or decrease?" "What if the Risk-Free Rate changes? How is everything else impacted?" "What if the company is bigger / smaller?" Plus, you need to use these concepts on the job all the time when valuing companies… these "costs" represent your opportunity cost from investing in a specific company, and you use them to evaluate that company's cash flows and determine how much the company is worth to you. EX: If you can get a 10% yield by investing in other, similar companies in this market, you'd evaluate this company's cash flows against that 10% "discount rate"… …and if this company's debt, tax rate, or overall size changes, you better know how the discount rate also changes! It could easily change the company's value to you, the investor. The Most Important Concept… Everything is interrelated - in other words, more debt will impact BOTH the equity AND the debt investors! Why? Because additional leverage makes the company riskier for everyone involved. The chance of bankruptcy is higher, so the "cost" even to the equity investors increases. AND: Other variables like the Risk-Free Rate will end up impacting everything, including Cost of Equity and Cost of Debt, because both of them are tied to overall interest rates on "safe" government bonds. Tricky: Some changes only make an impact when a company actually has debt (changes to the tax rate), and you can't always predict how the value derived from a DCF will change in response to this. Changes to the DCF Analysis and the Impact on Cost of Equity, Cost of Debt, WACC, and Implied Value: Smaller Company: Cost of Debt, Equity, and WACC are all higher. Bigger Company: Cost of Debt, Equity, and WACC are all lower. * Assuming the same capital structure percentages - if the capital structure is NOT the same, this could go either way. Emerging Market: Cost of Debt, Equity, and WACC are all higher. No Debt to Some Debt: Cost of Equity and Cost of Debt are higher. WACC is lower at first, but eventually higher. Some Debt to No Debt: Cost of Equity and Cost of Debt are lower. It's impossible to say how WACC changes because it depends on where you are in the "U-shaped curve" - if you're above the debt % that minimizes WACC, WACC will decrease. Otherwise, if you're at that minimum or below it, WACC will increase. Higher Risk-Free Rate: Cost of Equity, Debt, and WACC are all higher; they're all lower with a lower Risk-Free Rate. Higher Equity Risk Premium and Higher Beta: Cost of Equity is higher, and so is WACC; Cost of Debt doesn't change in a predictable way in response to these. When these are lower, Cost of Equity and WACC are both lower. Higher Tax Rate: Cost of Equity, Debt, and WACC are all lower; they're higher when the tax rate is lower. ** Assumes the company has debt - if it does not, taxes don't make an impact because there is no tax benefit to interest paid on debt.
Views: 119276 Mergers & Inquisitions / Breaking Into Wall Street
In this tutorial, you’ll learn how to write a flexible Excel formula that lets you summarize quarterly or monthly data in an annual format using the INDIRECT, MATCH, and SUMIFS functions. This is a common task given in Excel tests and case studies, especially in industries such as real estate. http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Table of Contents: 2:54 Using SUMIFS to Make the Dates Flexible 4:59 Using MATCH and INDIRECT to Make the Entire Function Flexible 11:20 Testing the Formula 13:42 Recap and Summary Resources: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Excel-Test-INDIRECT-Match.pdf https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Excel-Test-INDIRECT-Match-Blank.xlsx https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Excel-Test-INDIRECT-Match-Complete.xlsx Lesson Outline: Some of the most frequently-tested topics in Excel tests include the proper uses of lookup functions (HLOOKUP and VLOOKUP), INDEX/MATCH, INDIRECT, and the SUM, SUMIF, and SUMIFS functions to find and summarize data. Often, interviewers will ask you to write a single function that accomplishes a task elegantly rather than having to modify the function slightly or otherwise change it each time you use it. In many cases, you could write simple SUM formulas to sum up cells manually, but it’s far more robust to use the SUMIFS function so that you can check the dates and include only the matching quarterly or monthly data for the year you’re in. But to make the function truly flexible so that you can copy and paste it down and around and use it to sum up data for different rows, you must use the MATCH and INDIRECT functions. MATCH lets you move down to the appropriate row based on the data you need – for example, if “Profits” is 25 rows down in the monthly spreadsheet, the MATCH function will retrieve 25 when you use it in that spreadsheet with “Profits” as the input. Then, INDIRECT lets you create your own variable references to other spreadsheets. For example, instead of using E9:T9 as the fixed range, you could let the “9” parts vary based on the row or column you’re in or the output of functions. We used INDIRECT and MATCH to rewrite the SUMIFS function with a fixed summation range and make the summation range variable. The function is more flexible because when we copy it down, the summation range reference will change, and the row will match the correct row number of the data we’re seeking.
Views: 11443 Mergers & Inquisitions / Breaking Into Wall Street
What is Accounts Receivable ("AR")? Why This Question Matters? What happens when AR goes up? What happens when it goes down? By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Here's an outline of what we cover in this free tutorial: 1. Why This Question Matters This one is both a "real world" scenario, AND a very common question in interviews. 2. What is Accounts Receivable ("AR")? Line item on Balance Sheet for cash that you still need to collect from customers. Recorded it as revenue, but haven't received the cash payment from them yet (Like an "IOU"). Sent invoice and delivered product, but still waiting on payment from customer. (Standards differ a bit by company and industry, but that's the basic idea) 3. What happens when AR goes up - record revenue and profit, but no cash received yet... so cash goes down! Intuition: Recorded paper profit that you haven't actually gotten in cash yet... But those taxes you pay on that profit ARE in cash! So you're paying extra taxes for profit you don't have yet, which reduces your cash. 4. What happens when AR then goes down after you've collected the cash - no changes on IS, but cash now INCREASES to reflect the collection, AR decreases, and other side balances via Retained Earnings. Intuition: AR "going down" means a cash collection has taken place... but the revenue, profits, and taxes you've recorded don't change. So all you do is REMOVE the cash decrease on the CFS... And cash on the Balance Sheet is now up, with Retained Earnings up on the other side to balance it. 5. Summary & Intuition Behind Each Step. Click the link below and go to "Files & Resources" to get this Excel file for yourself. http://breakingintowallstreet.com/biws/3-statement-excel-model-interview-questions/
Views: 16589 Mergers & Inquisitions / Breaking Into Wall Street
Get the files and resources here: http://www.mergersandinquisitions.com/3-statement-model-case-study/ https://samples-breakingintowallstreet-com.s3.amazonaws.com/IBIG-06-01-Three-Statements-30-Minutes-Blank.xlsx https://samples-breakingintowallstreet-com.s3.amazonaws.com/IBIG-06-01-Three-Statements-30-Minutes-Complete.xlsx Table of Contents: 3:34 Step 1: Fill Out All the Assumptions (if possible) 11:34 Step 2: Fill Out the Entire Income Statement 13:49 Step 3: Fill Out What You Can of the Balance Sheet 16:03 Step 4: Fill Out the Entire Cash Flow Statement 20:35 Step 5: Finish Linking the Balance Sheet 23:25 Step 6: Check Your Work and Answer the Questions 24:42 Recap and Summary
Views: 35689 Mergers & Inquisitions / Breaking Into Wall Street
How to Get Into Investment Banking If You Have a 3.0 GPA, Graduated from an Unknown School, and Only Recently Learned English http://www.mergersandinquisitions.com/break-into-investment-banking-3-0-gpa-unknown-school/ (Get the full article right here) MENTIONED RESOURCES http://www.BreakingIntoWallStreet.com (Financial Modeling Training) http://www.MergersAndInquisitions.com (Investment Banking Blog)
Views: 26296 Mergers & Inquisitions / Breaking Into Wall Street
In this tutorial, you'll learn what goes into an equity research report, including how it differs from a stock pitch in terms of structure and argument, the main sections of the reports, and how you might write your own reports. http://www.mergersandinquisitions.com/equity-research-report/ Table of Contents: 1:43 Part 1: Stock Pitches vs. Equity Research Reports 6:00 Part 2: The 4 Main Differences in Research Reports 12:46 Part 3: Sample Reports and the Typical Sections 20:53 Recap and Summary Part 1: Stock Pitches vs. Equity Research Reports The main difference is that equity research reports are like "watered-down" stock pitches: you still recommend for or against investment in a public company, but your views are weaker, "Sell" recommendations are rare, and you spend a lot more time describing the company and its operations and financials. By contrast, in hedge fund stock pitches you take more extreme views and spend more time explaining how your views differ from those of the market as a whole. Part 2: The 4 Main Differences in Research Reports 1) There's More Emphasis on Recent Results and Announcements 2) Far-Outside-the-Mainstream Views Are Less Common 3) Research Reports Give "Target Prices" Rather Than Target Price Ranges 4) The Investment Thesis, Catalysts, and Risk Factors Are "Looser" Part 3: Sample Reports and the Typical Sections The main sections of a report are as follows: Page 1: Update, Rating, Price Target, and Recent Results The first page of an "Update" report states the bank's recommendation (Buy, Hold, or Sell, sometimes with slightly different terminology), and gives recent updates on the company. A specific "target price" must be based on specific multiples and specific assumptions in a DCF or DDM. So with Jazz, we explain that the $170.00 target is based on 20.7x and 15.3x EV/EBITDA multiples for the comps, and a discount rate of 8.07% and Terminal FCF growth rate of 0.3% in the DCF. Next: Operations and Financial Summary Next, you'll see a section with lots of graphs and charts detailing the company's financial performance, market share, and important metrics and ratios. For a pharmaceutical company like Jazz, you might see revenue by product, pricing and # of patients per product per year, and EBITDA margins. For a commercial bank like Shawbrook, you might see loan growth, interest rates, interest income and net income, and regulatory capital figures such as the Common Equity Tier 1 (CET 1) and Tangible Common Equity (TCE) ratios: This section of the report explains how the research analyst/associate forecast the company's performance and came up with the numbers used in the valuation. Valuation The valuation section is the one that's most similar in a research report and a stock pitch. In both fields, you explain how you arrived at the company's implied value, which usually involves pasting in a DCF or DDM analysis and comparable companies and transactions. The methodologies are the same, but the assumptions might differ substantially. In research, you're also more likely to point to specific multiples, such as the 75th percentile EV/EBITDA multiple, and explain why they are the most meaningful ones. Investment Thesis, Catalysts, and Risks This section is short, and it is more of an afterthought than anything else. We do give reasons for why these companies might be mispriced, but the reasoning isn't that detailed and it's not linked to specific share prices. Banks present Investment Risks mostly so they can say, "Well, we warned you there were risks and that our recommendation might be wrong." http://www.mergersandinquisitions.com/equity-research-report/
Views: 51889 Mergers & Inquisitions / Breaking Into Wall Street
In this Merger Model tutorial, you'll learn how to complete a merger model case study exercise given at an assessment center. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" You will also learn how to set up a simplified model, how to calculate accretion / (dilution) under different scenarios, and how to calculate the pro-forma credit stats and ratios for the combined company. http://youtube-breakingintowallstreet-com.s3.amazonaws.com/108-04-Merger-Model-Assessment-Center-Case-Study.pdf "Before" Excel File: http://youtube-breakingintowallstreet-com.s3.amazonaws.com/108-04-Merger-Model-AC-Case-Study-Before.xlsx "After" Excel File: http://youtube-breakingintowallstreet-com.s3.amazonaws.com/108-04-Merger-Model-AC-Case-Study-After.xlsx Table of Contents: 3:01 How to Interpret the Case Study and Model Requirements 5:18 Financial Information for Companies A and B 5:31 How to Calculate the Missing Information 8:02 Entering the Key Deal Assumptions 10:55 How to Combine the Income Statements 14:36 How to Calculate Accretion / (Dilution) and Credit Stats 16:46 Answering the Case Study Questions 21:06 Key Takeaways from the Case Study 22:39 Recap and Summary Step 1: Read and interpret the instructions... and understand where to cut corners! Requirements: Need to be able to change the purchase price and % debt and stock used... but cash and the foregone interest on cash are unnecessary, which simplifies things. Also, they've given us incomplete information in a few spots and we need to go through and calculate some figures for Company A and Company B, such as the shares outstanding. SKIP the formatting! Step 2: Enter the financial information for Company A and Company B. Fairly straightforward, but remember that we need to calculate a few additional numbers for this to work, such as the shares outstanding for each company and the Net Income and EPS, at least for the buyer. Step 3: Calculate the "missing information" - Net Income, EPS, and Share Counts. Start with Pre-Tax Income, then calculate Net Income based on the tax rates for both companies, and then EPS... not completely necessary for Company B, but definitely need it for Company A. Then, calculate the Share Count for both companies and the Enterprise Value (just for reference). Step 4: Go up to the top and enter the key assumptions, starting with Question #1. To save time, skip the (1 + Premium) * Share Price * # Shares calculation and just calculate the purchase price based on the premium to Company B's Market Cap instead -- same result either way. Calculate %s for debt and stock, then the amount of debt raised, debt interest rate, and shares issued. Then, fill in the information about the synergies -- no information on expenses here, so we leave it out. Step 5: Combine the Income Statements for Company A and Company B. Start with the Synergies, and then combine all the other line items, factoring in those synergies on top. Remember to factor in acquisition effects, such as additional interest expense. Calculate down to EPS, making sure you include the NEW shares issued in the transaction and increase Company A's share count as appropriate. Step 6: Calculate Accretion / (Dilution) and the Pro-Forma Credit Stats. Take the combined company's EPS and divide by the buyer's EPS and subtract 1. For the credit stats, the two key ones are the Leverage Ratio (Net Debt / EBITDA here) and the Coverage Ratio (EBITDA / Interest) - so calculate those each year. Step 7: Create sensitivities... if you have time. Here, we would argue it's pointless since it takes more time and effort to set them up, and they don't save much time beyond the model we already have -- so we're skipping this step. Step 8: What is the POINT of this case study exercise? Takeaway #1: Even if we pay a higher premium for a seller, the deal might be MORE accretive depending on the purchase method... debt tends to be less expensive than stock. Takeaway #2: Company B is a very cheap asset -- MUCH lower P / E and EV / EBITDA multiples than Company A. When a more expensive buyer acquires a much less expensive seller, the deal will almost always be accretive. Company B's significantly higher tax rate also makes a difference -- Company A gets "free money" after the acquisition since it's only paying 25% in taxes rather than 40%. Takeaway #3: Using debt tends to produce more accretion than stock, but it also produces higher leverage ratios and lower coverage ratios -- so there is a trade-off between accretion / (dilution) and the credit stats following the deal.
Views: 37066 Mergers & Inquisitions / Breaking Into Wall Street
Learn the building blocks of a simple one-page discounted cash flow (DCF) model consistent with the best practices you would find in investment banking. If you are preparing for investment banking interviews, know that the DCF is the source of a TON of investment banking interview questions. To download the backup Excel file, go to www.wallstreetprep.com/blog/financial-modeling-quick-lesson-building-a-discounted-cash-flow-dcf-model-part-1/ The DCF modeled here is a simplified version of a fully-integrated DCF model. For a deeper dive into DCF modeling in Excel, please visit www.wallstreetprep.com.
Views: 378968 Wall Street Prep
Joshua Rosenbaum and Joshua Pearl, authors of the highly acclaimed and authoritative textbook, Investment Banking, walk through how to answer technical questions asked during the investment banking interview process. Learn with the pros: https://www.efficientlearning.com/ib Don't guess what it takes to ace your interview and and answer questions including "How do the three main financial statements link together?" Access additional lecture videos and practice questions with a 14 day free trial of Wiley's Investment Banking Prep course: https://www.efficientlearning.com/investment-banking/products/free-trial/
Views: 57172 Wiley Finance
Breaking Into Wall Street is the leading provider of dedicated online training for aspiring investment bankers and ambitious professionals who want to master it as quickly as possible. Our material is different because it's based on real companies and real deals - not boring textbook theory. Rather than just "watching" the lessons, you become an active participant by following our proprietary BASES learning methodology - so you master the material in short order. You also benefit from certifications on all our modeling courses, unlimited lifetime updates, unlimited expert support and an active community of tens of thousands of peers to enhance your results. Learn more at https://breakingintowallstreet.com/
Views: 61096 Mergers & Inquisitions / Breaking Into Wall Street
You’ll get a quick, but very powerful, tip on how to optimize your Excel setup with the Quick Access Toolbar (QAT) and custom shortcuts in this tutorial. These tips will save you a ton of time when creating valuations, organizing data, and doing any formatting exercise. http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Shortcuts Introduced: These are all BUILT-IN shortcuts: Alt, T, O: Options Menu Alt, H, FC: Font Color Alt, H, FS: Font Size Alt, H, H: Fill Color Alt, H, A, C: Center Alt, H, B: Borders Alt, H, O, I: AutoFit Column Width Alt, H, O, W: Column Width Alt, H, 0: Increase Decimal Places Alt, H, 9: Decrease Decimal Places These are the NEW shortcuts you can create via the Quick Access Toolbar: Alt, 1: Font Color Alt, 2: Font Size Alt, 3: Fill Color Alt, 4: Center Alt, 5: Borders Alt, 6: AutoFit Column Width Alt, 7: Column Width Alt, 8: Increase Decimal Places Alt, 9: Decrease Decimal Places Lesson Outline: Many Excel shortcuts that you use repeatedly when creating valuations, models and when formatting data are cumbersome to enter. Something as simple as changing the font color takes 4 keystrokes – Alt, H, F, C – if you use the built-in method for it. Other common commands such as alignment, fill colors, borders, and column widths also take 3-4 keystrokes. A more efficient alternative is to set up the Quick Access Toolbar (QAT) so that you can access the most common commands with shortcuts like Alt, 1 instead. You can either import our file (see the link below under RESOURCES) or go to the Options menu (Alt, T, O) and then the Quick Access Toolbar tab, and create the menu yourself. We recommend setting “Font Color” in position #1, followed by Font Size, Fill Color, Center, Borders, AutoFit Column Width, Column Width, and Increase and Decrease Decimal places. These are some of the most frequently used commands in Excel, and you’ll save a ton of time with the new, shorter versions. A command like AutoFit Column Width that used to take 4 keystrokes now takes only 2 (Alt, 6) with this approach. You might realize 30-40% time savings when working in Excel if you use this full set of shortcuts. They’re especially useful for formatting and analyzing data and doing the initial setup in financial models. RESOURCES: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Excel-QAT-Export.exportedUI https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Excel-Shortcuts-Investment-Banking-Slides.pdf
Views: 51316 Mergers & Inquisitions / Breaking Into Wall Street
WSO Video Library (100+ full webinars): http://www.wallstreetoasis.com/wall-street-videos Interview Guides: http://www.wallstreetoasis.com/guide-to-finance-interviews WSO Resume Review: http://www.wallstreetoasis.com/wso-finance-resume-review WSO Mentors: http://www.wallstreetoasis.com/wall-street-mentors-finance-mock-interviews WSO Events: http://www.wallstreetoasis.com/events
Views: 239 WallStreetOasis
This lesson was prompted by a question that came in from a reader and student of our courses the other day: "When you divide Enterprise Value by Revenue (EV / Revenue), or Price Per Share by Earnings Per Share (P / E), what does that actually mean? By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" In other words, if Enterprise Value / Revenue is 5.8x, what does that number actually mean?" Answer often given in textbooks: How valuable a company is in relation to its sales, profits, and so on... based on those metrics, how does the market value that company? But the real answer: the multiple itself means nothing at all! By itself, a single valuation multiple such as 5.8x or 15.3x or 25.7x means... absolutely nothing. Valuation multiples are ONLY meaningful in relation to the multiples of OTHER, similar companies ("public comps" or "public company comparables"). It's like saying, in real life, "The asking price for that house is $500,000, or around $500 per square foot. What does that mean?" Answer: It depends... on the asking prices of similar houses in the region, also on the location, the type of house, # beds and bathrooms, the condition, the neighborhood, the public school system... Could mean that the house is very expensive, or that it's very cheap, or that it's priced about right. You already know this if you've studied valuation and have valued companies on your own... BUT there are 2 specific points that often go overlooked with valuation multiples: 1. The companies you're comparing should ideally have similar growth and margin profiles, or the comparison is less meaningful. It's NOT enough just to be in the same industry and be about the same size - that's a starting point, but financial profiles should ideally be similar as well. Be very careful - acquisitions often distort these numbers! Very different margins also distort the numbers (ex: 2 companies with similar revenue and 1 has a much higher margin - mathematically speaking, very likely to trade at a LOWER multiple just because the denominator will be bigger). 2. Even if the companies DO have similar financial profiles, a higher or lower multiple doesn't necessarily mean that one company is "overvalued" or "undervalued" because qualitative factors also play a role. For example, did the company just make an acquisition? Did it miss earnings? Did it get sued? Did a new competitor pop up? Think of valuation multiples as "clues" in a detective story... they can guide you in the right direction, but 1 clue is not enough evidence to solve the mystery of whether a company is valued appropriately. We demonstrate both of these points with Ralcorp (a food and beverages company) in the video, and show you how the set of public comps all have very different financial profiles that were impacted by acquisitions in some cases. Key Takeaways: 1. A valuation multiple means nothing on its own - only meaningful when compared to other companies', and ideally the median multiple from a set of other companies. 2. When picking a set of public comps, it's not just about industry and size... even if you do select companies with those criteria, must pay attention to growth and margins as well. If all the companies in your set have very different growth and margins from the company you're valuing, you may want to consider a different set. If there are acquisitions, it's better to pay more attention to forward multiples / growth rates / margins instead - for 1-2 years in the future. The analysis is MOST meaningful if, for example, all the companies have very similar growth and margins but the one you're looking at trades at much different multiples - then it's worth investigating further and seeing what explains that. 3. Just because a multiple is higher or lower than other companies' multiples doesn't mean that the company you're valuing is overvalued or undervalued... it's just one of many factors. Here, the presence of a hostile bidder threw off the numbers. Plus, rumors of the company spinning off divisions... Could be any number of things in real life as well - earnings announcements, changes in strategy, expansion plans, patents, lawsuits, management team changes, etc.
Views: 52356 Mergers & Inquisitions / Breaking Into Wall Street
In this Enterprise Value lesson we take a look at the rules of thumb to figure out what should be added or subtracted when you calculate it. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" This also covers a short case study based on Vivendi (a leading media/telecom conglomerate based in France), Everyone knows the definition of Enterprise Value: Take Equity Value, add Debt and Preferred Stock (and others), and subtract Cash... But WHY do you do any of that? Enterprise Value represents the value of the company's CORE BUSINESS OPERATIONS to ALL THE INVESTORS in the company - equity, debt, preferred stock, etc. So focus on OPERATIONAL ITEMS and ALL INVESTORS when thinking about what to include... and what to exclude! Table of Contents: 1:19 What Enterprise Value Means 2:10 The 3 Key Rules of Thumb 5:15 Walk-Through of Vivendi's Assets and What to Subtract 11:08 How to Determine the Proper Treatment for Certain Assets 12:33 Excel Calculations for Assets Subtracted 13:30 Walk-Through of Vivendi's Liabilities & Equity and What to Add 15:14 How to Determine the Proper Treatment for Certain Liabilities 17:04 Excel Calculations for Liabilities Added 18:57 The Equity Section and Noncontrolling Interests 19:45 Recap and Summary The Three Rules of Thumb: 1. Is this item a *long-term funding source* for the company? In other words, will the funds we raise from this item help fund our business for years to come? If so, you should ADD this item when calculating Enterprise Value! Examples: Debt, Preferred Stock, Noncontrolling Interests (Minority Interests), Capital Leases, Unfunded Pension Obligations, Restructuring/Environmental Liabilities... 2. Will this item cost an acquirer of the company something extra when they go to buy it? And is it NOT something that will be repaid out of the company's normal operating cash flows (e.g., Accounts Payable)? If so, ADD it when calculating Enterprise Value! Examples: Debt, Preferred Stock. 3. Is this item NOT an operating asset? In other words, could the company continue to operate even WITHOUT this particular asset and be fine? If so, SUBTRACT it when calculating Enterprise Value! (These items often "save acquirers money" when buying the company.) Examples: Cash, Liquid Investments, Net Operating Losses, Assets from Discontinued Operations or Assets Held for Sale... How Does Each Item In Our Analysis Satisfy This Criteria? ITEMS THAT YOU SUBTRACT: Cash - Non-operating asset, the company doesn't "need" it to run its business beyond a certain low, minimum level. Liquid Investments - Also non-operating, the company has no need to invest in the stock market if it sells normal products/services. Equity Investments - Non-operating, not recorded in this company's revenue/expenses, doesn't "need" it to run the business. Other Non-Core Assets - Typically items that will be sold off or discontinued soon, so they're the very definition of "non-operating." NOLs - Also non-operating since long-term tax savings from these are not required to run the business. ITEMS THAT YOU ADD: Debt - Long-term funding source, and an acquirer has to repay it. Preferred Stock - Long-term funding source, and an acquirer has to repay it. Noncontrolling Interests - Long-term funding source, but this one's mostly for *comparability*... the company has recorded 100% of revenue and expenses from this company, so we want to capture 100% of its value as well (see our dedicated lesson on this one). Unfunded Pension Obligations - They're a long-term funding source! "Work for us now, we'll pay you a bit less, but we'll take care of you when you retire! Really!" To the company, very much like super-long-term debt.... but owed to employees, not outside investors. Plus, an acquirer has to pay for these somehow... Capital Leases - Also a long-term funding source, sort of like debt used to fund PP&E... these leases are used to fund operations and must be repaid. Restructuring & Legal Liabilities - Increases the cost to an acquirer, and they are also "long-term funding" of a sort - "Instead of paying for these expenses right now, we'll take care of them far into the future and reflect that liability." The Bottom-Line The Enterprise Value calculation is always somewhat subjective, and you'll see it done different ways. Everyone agrees on certain items (Cash, Debt, Preferred Stock), but the treatment of others varies by group, firm, industry, etc. As long as you can justify and explain how you calculated it, you'll be fine - even if someone else wants to change it later. To do that, keep in mind the 3 key rules of thumb above. Further Resources http://youtube-breakingintowallstreet-com.s3.amazonaws.com/106-07-VIV-Equity-Value-Enterprise-Value.xlsx http://youtube-breakingintowallstreet-com.s3.amazonaws.com/106-07-VIV-Annual-Financial-Statements-Notes.pdf
Views: 38171 Mergers & Inquisitions / Breaking Into Wall Street
Investment Banker Resume Tutorial for Students. I get a lot of questions on how to structure your resume, how to write about your experience, what to focus on, and how much to write. By http://www.mergersandinquisitions.com/ "Discover How To Break Into Investment Banking or Private Equity, The Easy Way" Rather than writing a giant Q&A on all these topics, I'm going to give you a resume/CV template that you can just copy and modify for your own experiences. http://www.mergersandinquisitions.com... (Get the full Word and PDF template here) "But I'll Have the Same Resume as Everyone Else!" No, because only 0.1% of those who see this template will actually download it and use it. Don't overestimate the competition. And even though this site is well-known, only a tiny fraction of those interested in investment banking have visited it. If you are worried, just modify the formatting and use different fonts, spacing, or margins. --- WANT MORE FREE TUTORIALS, TIPS & TEMPLATES? Subscribe to the Banker Blueprint, a complete action plan for getting into Investment Banking, PE and Hedge Funds. www.mergersandinquisitions.com/banker-blueprint
Views: 75028 Mergers & Inquisitions / Breaking Into Wall Street
Why Do You Care About This? It's a very common interview question! Q: "How does EBIT differ from EBITDA? What about EV / EBIT vs. EV / EBITDA? When do you use which one? How does P / E compare to those?" By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" And it's very common on the job as well -- you must decide how to value companies and which metrics / multiples to focus on. What are the Differences Between EBIT, EBITDA, and Net Income? These metrics differ in terms of: 1. Who the Money is Available to -- Equity investors, debt investors, and the government? Just equity investors? Someone else? 2. Operating Expenses vs. Capital Expenditures -- Some metrics reflect the impact of both of these, whereas others only reflect the impact of Operating Expenses and ignore spending on long-term assets. 3. Interest, Taxes, and Non-Core Business Activities -- Some metrics include these, and some exclude them. 4. When They're Useful -- Sometimes you WANT to reflect the impact of CapEx, approximating Free Cash Flow, and sometimes you don't. Same for interest and taxes. Here's the summary of differences, by category: How Do You Calculate It? EBIT = Operating Income on the Income Statement EBITDA = Operating Income on the Income Statement + Depreciation & Amortization from the CFS Net Income = Net Income on the Income Statement They Correspond To... EBIT corresponds to Enterprise Value. EV / EBIT is the multiple. EBITDA corresponds to Enterprise Value. EV / EBITDA is the multiple. Net Income corresponds to Equity Value. P / E is the multiple. Who Has a Claim on the Money? For EBIT and EBITDA, equity investors, debt investors, and the government all have a claim. For Net Income, only equity investors have a claim because debt investors have been paid with interest, and the government has been paid with taxes. What Does It Mean? EBIT = Core, recurring business profitability, before the impact of capital structure and taxes. EBITDA = Proxy for core, recurring business cash flow from operations, before the impact of capital structure and taxes. Net Income = Profit after taxes, the impact of capital structure, AND non-core business activities. Which Expenses Does It Reflect? EBIT reflects operating expenses and the impact of CapEx, but EXCLUDES interest, taxes, and non-core business activities. EBITDA is almost the same, but does NOT include the impact of CapEx. Net Income reflects everything -- operating expenses, CapEx, interest, taxes, and non-core business activities. Which Cash Flow-Based Metric Is It Closer To? EBIT is *sometimes* closer to Free Cash Flow, AKA Cash Flow from Operations -- CapEx, because they both reflect CapEx - but really, only *sometimes* is it closer... EBITDA is *sometimes* closer to Cash Flow from Operations because NEITHER one includes CapEx - but really, only *sometimes* is it closer... And Net Income is generally not close to either one. Which One Do You Use And Why? This is a question with a FALSE premise - you're not just picking one or the other! You'll almost always use a variety of metrics and multiples when valuing companies. So, for example, you might look at EV / Revenue, EV / EBITDA, and P / E all for the same company. But generally speaking, if you WANT to reflect the impact of capital expenditures and it's important to do so for the company/industry you're in, EBIT is better than EBITDA. Whereas EBITDA might be better in an industry where CapEx is less important, such as software/Internet/services/anything else where R&D exceeds investments in hard assets. But it also depends on a company's state of development -- CapEx is almost always more important to quickly growing companies, whereas it is less important for mature, stable companies! Regardless of the industry. As for Net Income, you usually look at it as a *supplement* to other metrics and multiples -- on its own, it doesn't necessarily give you a great / accurate view of a company because it's distorted by different tax rates, capital structures, and so on. Further Resources http://youtube-breakingintowallstreet-com.s3.amazonaws.com/STLD-LNKD-EBIT-EBITDA-Net-Income.xlsx
Views: 127149 Mergers & Inquisitions / Breaking Into Wall Street
http://thegatewayonline.com We spoke to Morgan Stanley bankers to find out how to decide whether the sector is right for you, why an internship is so important, and what investment banks – and Morgan Stanley recruiters in particular – are looking for in graduates.
Views: 225790 The Gateway
In this tutorial, you’ll learn what real estate financial modeling is, how we use it to make investment decisions, and you’ll see examples of simple acquisition and development models and the step-by-step process that applies to both of them. https://www.mergersandinquisitions.com/real-estate-pro-forma/ https://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Table of Contents: 1:18 Part 1: What is the Point of Real Estate Financial Modeling? 3:09 Part 2: Types of Deals, Properties, and Models 7:19 Part 3: Example of an Acquisition Model 12:50 Renovation Model Differences 15:42 Part 4: Example of a Development Model 20:19 Recap and Summary In real estate financial modeling, you analyze a property from the perspective of an Equity Investor (owner) or Debt Investor (Lender) and determine whether or not the Equity or Debt Investor should invest, based on the risks and potential returns. For example, if you buy a multifamily property for $50 million and hold it for 5 years, could you earn a 12% annualized return on it? Is that range of returns (10 – 15%) plausible? Types of Deals, Properties, and Models There are three main ways you can invest in properties: Way #1: Acquire an existing property, change little to nothing, and sell it – this is Acquisition Modeling. Way #2: Acquire an existing property, change it significantly, and sell it – this is Renovation Modeling. Way #3: Buy land, pay to develop a new property, find tenants, and then sell the property when it stabilizes – this is Development Modeling. And then there are several different categories of properties. The first category is office, industrial, and retail properties, which have businesses as customers and tend to have long-term leases with highly variable terms. On the opposite end are hotels, where guests only stay a few nights, and where financial modeling is much closer to what you do for normal companies. In the middle are multifamily properties, with 1-year leases that have very similar terms, and condominiums, which are often pre-sold to individuals and owned by individuals. The Step-by-Step Process to Real Estate Financial Modeling Step 1: Set up the Transaction Assumptions, including the property size, price or development costs, and exit details. Step 2: For development models, project the Construction Period and draw on Debt and Equity over time to fund the development. Step 3: Build the Operating Assumptions, which could be high-level or very granular depending on the property type. Step 4: Build the Pro-Forma, including NOI, Adjusted NOI, Debt Service, and Cash Flow to Equity. Step 5: Make the Returns Calculations, including the initial investment(s), cash flows over time, exit, and debt repayment. Step 6: Make an Investment Decision based on your criteria and the model output in different cases. In the acquisition model, we apply these steps by setting the property’s size based on number of units and average square feet per unit and setting a price based on a Cap Rate. Debt is based on the purchase price times the LTV. The operating assumptions are very high-level and linked to per-unit and per-square-foot figures since the individual leases are so similar. We assume rental growth, a reduced discount to market rates, and increases in reimbursement rates and the vacancy rate over time, along with minor upgrades. The Pro-Forma is fairly standard and starts with Base Rental Income, makes deductions and adjustments, deducts expenses, and ends with NOI, Adjusted NOI, and Cash Flow to Equity. We then calculate the IRR and multiple and conclude that we’d need to analyze this in different cases and stress test it a bit more. A 15% IRR is quite good for a stabilized property, but we don’t know how well it holds up in downside scenarios. In the development model example, we purchase land upfront and estimate the construction costs. During the construction period, we distribute the land and construction costs over time, draw on Equity first to pay for them, then switch to Debt, and we capitalize interest and loan fees during the period. The operating assumptions are based on tenant-by-tenant numbers since there are only two tenants. The Pro-Forma is fairly standard, but the refinancing is a bit tricky since we need to get the property’s value a year after it takes place and then discount it back one year based on a 15% Discount Rate to determine the Permanent Loan amount. In the Returns Calculations, we factor in upfront Equity draws, the refinancing, cash flows to equity, excess land sale, and exit and debt repayment at the end. This one is probably a “no” since we just barely reach the 20% IRR in the base case, and we purchase too much land in the beginning. The waterfall structure also works against us.
In this final part, we'll walk you through a presentation template you can use in your own private equity case study interviews. By http://www.mergersandinquisitions.com/ "Discover How To Break Into Investment Banking or Private Equity, The Easy Way" You'll learn the basic structure to use in these presentations, how to combine the Excel work and analysis and channel checks we've performed to create a coherent presentation, and you'll also get a more "generic" template that you can use and apply to deals and companies you're analyzing. http://www.mergersandinquisitions.com/private-equity-case-study-interview/ Please follow the link above to get a ZIP file with all the relevant Excel and PowerPoint files.
Views: 47830 Mergers & Inquisitions / Breaking Into Wall Street
Learn the building blocks of a financial model. In this video, we'll build a cash flow statement given an income statement and balance sheet in Excel. To download the Excel template that goes with this video, go to http://www.wallstreetprep.com/blog/financial-modeling-quick-lesson-cash-flow-statement-part-1/ The accounting here is a simplified presentation of how the three major financial statements are inter-related and lays the foundation of financial statement models in investment banking. Many accounting questions that we see time and again in finance interviews are designed to test the understanding explained in this exercise.
Views: 390113 Wall Street Prep
In this Revenue Models lesson, you'll learn how to build a revenue model for a consumer retail company. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Chuck E. Cheese, a kids' restaurant chain that was acquired by Apollo for $1.3 billion, is used in this example since their data is readily available and easy to use Table of Contents: 0:39 Why Revenue Models Are Important 2:19 How to Set Up Revenue Models - Units Sold and Market Size Methods 3:39 How You Build a Revenue Model - Examples for Different Industries 5:03 Step 1 - Finding Historical Data 5:59 Step 2 - Assumptions for Stores Opened and Closed 8:02 Step 3 - Assumptions for Sales per Store Growth 9:03 Step 4 - Calculating Ending Stores per Year 10:30 Step 5 - Toggle Calculations for Sales per Store 11:08 Step 6 - Splitting Revenue Into Segments 14:20 Step 7 - How to Review and Tweak the Numbers 15:18 Recap and Summary Why Do Revenue Models Matter? It's a very common topic in case studies and interviews in IB, PE, HFs, and anything else in finance. Revenue models can come up in LBO case studies, 3-statement modeling case studies, normal interview questions, and, of course, on the job. Often, you have enough data to make MORE than just a simple % growth rate assumption for revenue... but not enough data to do the same on the expense side. Theoretically, you could just say 2%, 3%, 4%, etc. growth each year and project revenue like that. BUT it's much more credible to say, "We have 50 stores each generating $2 million in annual sales, on average, and we plan to open 5 new stores per year for the next 5 years -- based on that, revenue is expected to be..." rather than "We're assuming 4% revenue growth per year." The numbers you get will NOT necessarily be different or "more accurate" -- you're still predicting the future! But at least your numbers will have more real-world support behind them... What is a Revenue Model? It can be done many different ways, but most revenue models boil down to Units Sold * Average Selling Price, or Total Market Size * % Market Share. The best method depends on the available data, the work and research you've done, and what the company discloses. For this consumer/retail example, it makes the most sense to use a variation on Units Sold * Average Selling Price, since "market share" is almost impossible to establish for a large and fragmented market like restaurants. How Do You Build a Revenue Model? For retailers, you can divide revenue into into existing stores vs. new stores and assume a figure for average Sales per Square Foot/Meter, or Sales per Store, and then make assumptions for new stores opened, stores closed, and how the sales per store figures change over time. Here's what we cover in this example for Chuck E. Cheese: Step 1: Get the historical data you need -- in this case, the # of stores opened and closed in prior years, and the average sales per store type. These are all taken from the company's filings. Step 2: Make assumptions for the # of stores opened and closed each year -- companies often disclose their plans in their filings, or you can extrapolate from historical data. In this case, CEC told us directly how many stores it planned to open over the next 4 years. Step 3: Assume a growth rate in Sales per Comparable (Existing) Store, and Sales per New Store. Step 4: Calculate Ending Stores each year, with support for the sensitivity toggles built in so that we can easily modify the assumptions. Step 5: Now, make similar "post-toggle" calculations for Sales per New Store and Sales per Existing Store. Step 6: Now, divide the revenue into segments, if applicable... it is very much applicable here! There are different margins for entertainment vs. food and beverages, and there's a clear trend in one direction (away from food and beverages). Step 7: Now, go back and check your numbers, fill in the miscellaneous and smaller items, and see how equity research estimates (and other sources) compare to what you've come up with. Go back and tweak your numbers as necessary. What Next? Pick a company you're interested in, in an industry that's relatively easy to analyze, and project revenue based on what's in their filings. It doesn't have to be super-complicated -- for most companies, revenue comes down to less than 5 key drivers. Avoid conglomerates, companies with tons of business lines, or industries that are more complex, such as oil & gas, commercial banking, etc. Suggestions: Airlines, technology, consumer/retail, industrials/manufacturing, healthcare is iffy because it can get very complex to model a company with a huge drug portfolio. Further Resources http://youtube-breakingintowallstreet-com.s3.amazonaws.com/CEC-Revenue-Model.xlsx
Views: 18894 Mergers & Inquisitions / Breaking Into Wall Street
In this tutorial, you’ll learn how REITs operate, how to create simple 3-statement projection models for them, how to extend the projections into a DCF analysis, and how to complete a Net Asset Value (NAV) model and use Public Comps to value a REIT. https://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Table of Contents: 2:14 Part #1: Basic Characteristics of REITs and U.S. GAAP vs. IFRS 6:17 Part #2: Simple Projection Model for a REIT 12:00 Part #3: Extension of the Projection Model into a DCF for a REIT 16:03 Part #4: Net Asset Value (NAV) for REITs and Public Comps 19:40 Recap and Summary Resources: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/REIT-Valuation-Slides.pdf https://youtube-breakingintowallstreet-com.s3.amazonaws.com/REIT-Valuation-Example.xlsx Lesson Outline: To value REITs simply and effectively, you must understand how they operate, their special requirements, and the differences between U.S. GAAP-based and IFRS-based REITs. REITs buy, sell, develop, and operate properties or other real estate assets. They must distribute a high percentage of Net Income in the form of Dividends (90% in the U.S.), and high percentages of their revenue and assets must come from real estate. In exchange, they pay no corporate income taxes (or greatly reduced corporate taxes). REITs are always maintaining, acquiring, developing, renovating, and selling properties, and since they distribute so much Cash, they constantly need to raise Debt and Equity to operate. The Gains and Losses on property sales make Net Income fluctuate, so you look at alternative metrics, such as Funds from Operations (FFO) or EPRA Earnings, when analyzing REITs. Funds from Operations (FFO) = Net Income + RE Depreciation & Amortization + Losses / (Gains) + Impairments. Under U.S. GAAP, REITs depreciate properties and record a huge Depreciation expense on the IS; under IFRS, they revalue properties constantly and record huge Fair Value Gains and Losses instead. Also as a result of that, Book Value is important and meaningful for IFRS-based REITs but must be adjusted significantly for U.S.-based REITs. To project a REIT’s statements, you start by projecting its “same-store” (existing) properties by assuming rental growth and margins. Then, assume acquisition, development/redevelopment spending, a yield on spending, and margins there, and assume something for dispositions and the lost revenue and operating income. Add up all the property-level revenue and expenses, and then project corporate items such as Depreciation, Maintenance CapEx, and SG&A with traditional percentage approaches. Make Dividends a % of FFO, AFFO, or EPRA Earnings, and assume Debt and Equity issued based on the REIT’s Cash before financing vs. its minimum Cash balance. To value a REIT with a DCF, extend these projections, factor in all CapEx and Asset Sales, as well as Stock Issued, and project revenue, margins, D&A, CapEx, and Asset Sales through a 10-year period. Calculate and discount Terminal Value the normal way, discount and sum up the Free Cash Flows, back into the Implied Equity Value and divide by the share count (current + future shares to be issued) to get the Implied Share Price. The DDM is similar, but you use Cost of Equity instead of WACC, Equity Value-based multiples for the Terminal Value, and you discount and sum up Dividends rather than Unlevered FCF. To calculate NAV for U.S.-based REITs, project the 12-month forward Net Operating Income from properties, divide it by an appropriate Cap Rate or Yield (based on similar transactions or companies in the market), and then take the market value of the other assets and add them up. Then, adjust the Liabilities, and subtract them from the market value of Assets to determine Net Asset Value; divide by the share count to get NAV per Share and compare it to the Current Share Price. Public Comps are similar, but the screening criteria are usually Real Estate Assets, Geography, and Sub-Industry. You can use traditional metrics and multiples like EBITDA and EV / EBITDA, but you’ll also use alternative ones such as FFO, P / FFO, NAV, and P / NAV, and, for IFRS-based REITs, Book Value and P / BV. To find the data, you can use “Related Companies” on Google Finance, get the assumed growth rates for the projections from sources like Yahoo Finance, and go from there.
Views: 14675 Mergers & Inquisitions / Breaking Into Wall Street
You'll learn what "Free Cash Flow" (FCF) means, why it's such an important metric when analyzing and valuing companies. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" You'll also learn how to interpret positive vs. negative FCF, and what different numbers over time mean -- using a comparison between Wal-Mart, Amazon, and Salesforce as our example. Table of Contents: 0:54 What Free Cash Flow (FCF) is and Why It's Important 2:26 What Positive FCF Tells You, and What to Do With It 3:56 What Negative FCF Tells You, and What to Do With It 4:38 Why You Exclude Most Investing and Financing Activities in the FCF Calculation 7:55 How to Use and Interpret FCF When Analyzing Companies 11:58 Wal-Mart vs. Amazon vs. Salesforce: Free Cash Flow Across Sectors 19:33 Recap and Summary What is Free Cash Flow? Normally it's defined as Cash Flow from Operations minus Capital Expenditures. Tells you the company's DISCRETIONARY cash flow - after paying for expenses and working capital requirements like inventory and capital expenditures, how much cash flow can it put to use for other purposes? If the company generates a lot of Free Cash Flow, it has many options: hire more employees, spend more on working capital, invest in CapEx, invest in other securities, repay debt, issue dividends or repurchase shares, or even acquire other companies. If FCF is negative, you need to dig in and see if it's a one-time issue or recurring problem, and then figure out why: Are sales declining? Are expenses too high? Is the company spending too much on CapEx? If FCF is consistently negative, the company might have to raise debt or equity eventually, or it might have to restructure itself or cut costs in some other way. Why Do You Exclude Most Investing and Financing Activities Other Than CapEx? Because all other activities are, for the most part, "optional" and non-recurring. A normal company does not NEED to buy stocks or issue dividends or repurchase shares... those are all optional uses of cash. All it NEEDS to do to keep its business running is sell products to customers, pay for expenses, and keep investing in longer-term assets such as buildings and equipment (PP&E). Debt repayment and interest expense are "borderline" because some variations of Free Cash Flow will include them, others will exclude them, and some will include interest expense but not debt principal repayment. How Do You Use Free Cash Flow? It's used in a DCF (or at least, a variation of it) to value a company; it's also used in a leveraged buyout (LBO) model to determine how much debt a company can repay. And you can calculate it on a standalone basis for use when comparing different companies. The key is to DIG IN and see why Free Cash Flow is changing the way it is - Organic sales growth? Artificial cost-cutting? Accounting gimmicks? Different working capital policies? IDEALLY, FCF will be increasing because of higher units sales and/or higher market share, and/or higher margins due to economies of scale. Less Good: FCF is growing due to cost-cutting, CapEx slashing, or FCF is growing in spite of falling sales and profits... because of a company playing games with Working Capital, non-core activities, or CapEx spending. Wal-Mart vs. Amazon vs. Salesforce Comparison Main takeaway here is that Wal-Mart's FCF is all over the place, but Cash Flow from Operations is MOSTLY growing, so that appears to be driven by the also growing organic sales. The company is doing some odd things with CapEx and Working Capital, which led to fluctuations in FCF - not exactly "bad" or "good," just neutral and requires more research. With Amazon, they've increased CapEx spending massively in the past 2 years so that has pushed down CapEx. CFO is growing, driven by organic revenue growth (no "games" with Working Capital), but it's very difficult to assess whether all that CapEx spending will pay off in the long-term. With Salesforce, FCF is definitely growing organically (Revenue growth leads directly to CFO growth, and CapEx varies a bit but not as much as with Amazon), but the company is also spending a ton on acquisitions... will it continue? If CapEx as a % of revenue stays low, it will most likely continue to spend on acquisitions - unlikely to issue dividends, repurchase shares, etc. since it's a growth company. Further Resources http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-10-Free-Cash-Flow.xlsx http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-10-Walmart-Financial-Statements.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-10-Amazon-Financial-Statements.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-10-Salesforce-Financial-Statements.pdf
Views: 145377 Mergers & Inquisitions / Breaking Into Wall Street
Request Download links on [email protected] Breaking Into Wall Street – Bank Modeling Download Breaking Into Wall Street – Bank Modeling Torrent Breaking Into Wall Street – Bank Modeling Free Breaking Into Wall Street – Bank Modeling Full Request Download links on [email protected] https://www.youtube.com/watch?v=61plucpFnUc&feature=youtu.be https://www.youtube.com/watch?v=61plucpFnUc&feature=youtu.be https://www.youtube.com/watch?v=61plucpFnUc&feature=youtu.be https://www.youtube.com/watch?v=61plucpFnUc&feature=youtu.be https://www.youtube.com/watch?v=61plucpFnUc&feature=youtu.be
Views: 36 Joe Baker
Request Download links on [email protected] Breaking Into Wall Street – Platinum Package Download Breaking Into Wall Street – Platinum Package Torrent Breaking Into Wall Street – Platinum Package Free Breaking Into Wall Street – Platinum Package Full Request Download links on [email protected] https://www.youtube.com/watch?v=SuvSnjg-9HY&feature=youtu.be https://www.youtube.com/watch?v=SuvSnjg-9HY&feature=youtu.be https://www.youtube.com/watch?v=SuvSnjg-9HY&feature=youtu.be https://www.youtube.com/watch?v=SuvSnjg-9HY&feature=youtu.be https://www.youtube.com/watch?v=SuvSnjg-9HY&feature=youtu.be
Views: 218 Lisa Coffman
In this tutorial, you will learn how Equity Value and Enterprise Value change after an M&A deal takes place. You will also learn how the combined company’s Equity Value and Enterprise Value relate to the Equity Value and Enterprise Value of the buyer and seller in the deal. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Table of Contents: 1:01 Why Equity Value and Enterprise Value Matter, and the Rules 4:11 Excel Demonstration of Changes in an M&A Deal 9:49 Why the Rules Don’t Work in Real Life How Equity Value and Enterprise Value Change in M&A Deals A common interview question goes something like: “Company A acquires Company B using 100% debt – what is the combined company’s Enterprise Value?” Another common variant is “Company A acquires Company B using 100% stock – what is the combined EV / EBITDA multiple?” Fortunately, there are a few simple rules you can use to determine these answer. First, recall what Enterprise Value MEANS: it’s the value of a company’s core business operations to all investors in the company. So when moving from Equity Value to Enterprise Value, you add Debt and Preferred Stock (and anything else representing other investors) and subtract non-core assets, such as Cash and Investments. The end result is that regardless of how a company finances itself, Enterprise Value does not change and neither do Enterprise Value-based multiples. In the same way, in M&A deals the combined Enterprise Value and combined Enterprise Value-based multiples do not change regardless of how the acquirer buys the seller. Rules for Equity Value and Enterprise Value in M&A Deals Combined Equity Value: Acquirer’s Equity Value, plus the value of stock it issues to buy the Seller. Combined Enterprise Value: Acquirer’s Enterprise Value + the Seller’s Enterprise Value Combined EV / EBITDA: Add both companies’ Enterprise Values and EBITDAs; not impacted by cash/stock/debt mix. Combined P / E: No “shortcut”; impacted by funding mix. Calculate it by determining the Combined Equity Value first, and then the combined Net Income after factoring in foregone interest on cash and interest paid on new debt, and any tax rate differences. Example Calculations: Say that Company A has an Enterprise Value of $100, Equity Value of $80, EBITDA of $10, and Net Income of $4. Its tax rate is 25%. Company B has an Enterprise Value of $40, Equity Value of $40, EBITDA of $8, and Net Income of $2. The foregone interest rate on cash is 2%, and the interest rate on debt is 10%. So if Company A acquires Company B for $40 with 100% debt: Combined Enterprise Value = $100 + $40 = $140 Combined Equity Value = $80 + $40 * 0% Stock Used = $80 Combined EBITDA = $10 + $8 = $18 Combined Net Income = Company A Net Income + Company B Net Income + Acquisition Effects = $4 + $2 – $40 * 100% Debt * 10% Interest Rate * (1 – 25% Tax Rate) – $40 * 100% Cash * 2% Foregone Interest Rate * (1 – 25% Tax Rate) = $3 Combined EV / EBITDA = $140 / $18 = 7.8x Combined P / E = $80 / $3 = 26.7x If you then change around the mix of cash, stock, and debt, the Combined EV / EBITDA, Combined EBITDA, and Combined Enterprise Value will not change at all. However, the Combined Equity Value, Combined Net Income, and Combined P / E will all change depending on the financing mix. In Real Life These rules don’t quite hold up… because: Premium Paid for Seller: Will have to use seller’s Enterprise Value at the share price premium instead. Most sellers are acquired for more than their current market caps! Share Price After-Effects: Does the market like / not like the deal? If so, the buyer’s share price and therefore its Equity Value and Enterprise Value will change after the deal is announced. Synergies, Other Acquisition Effects: Could affect share prices, EBITDA, Net Income, and everything else! RESOURCES: http://youtube-breakingintowallstreet-com.s3.amazonaws.com/106-10-Equity-Value-Enterprise-Value-in-MA-Deals.xlsx http://youtube-breakingintowallstreet-com.s3.amazonaws.com/106-10-Equity-Value-Enterprise-Value-in-MA-Deals.pdf
Views: 20158 Mergers & Inquisitions / Breaking Into Wall Street
In this LBO Model tutorial, we walk through Silver Lake's $24 billion leveraged buyout of Dell and explain the tasks you might have to complete if you were to analyze this deal as part of a case study in a private equity interview. By http://www.mergersandinquisitions.com/ "Break Into Investment Banking or Private Equity, The Easy Way" Among other topics, we cover typical LBO case study questions to expect, why this particular deal was so unusual, and how to begin gathering data from industry reports, equity research, Dell's filings and investor presentations, and other sources. Then, we delve into how the transaction assumptions are set up, why the calculation for debt and equity is somewhat unusual, and how to factor in Michael Dell's equity rollover and cash contribution and the company's own excess cash usage. Finally, we conclude with a discussion of the Sources & Uses schedule and how that works, plus a description of the different types of debt used in the transaction. WANT MORE FREE FINANCIAL MODELING TUTORIALS? Receive a Free 3-Part Tutorial on **How to Build Your First Merger Model** based on the $16B United / Goodrich deal. Visit: www.breakingintowallstreet.com/biws MENTIONED RESOURCES http://www.mergersandinquisitions.com/leveraged-buyout-lbo-model-overview-capital-structure/ (Click to access the full case study and FREE downloadable templates)
Views: 83969 Mergers & Inquisitions / Breaking Into Wall Street
WSO Video Library (100+ full webinars): http://www.wallstreetoasis.com/wall-street-videos Interview Guides: http://www.wallstreetoasis.com/guide-to-finance-interviews WSO Resume Review: http://www.wallstreetoasis.com/wso-finance-resume-review WSO Mentors: http://www.wallstreetoasis.com/wall-street-mentors-finance-mock-interviews WSO Events: http://www.wallstreetoasis.com/events
Views: 933 WallStreetOasis
In this video, we walk you through how an increase in Depreciation affects the 3 financial statements and highlight the specific line items that change on the Income Statement, Balance Sheet, and Cash Flow Statement. More details in http://breakingintowallstreet.com/biws/3-statement-excel-model-interview-questions/ We also go through the *intuition* behind these changes - namely, how Depreciation affects a company's taxes but is not a true cash expense - and why even though this is a somewhat artificial scenario, it's still a very common question that you need to understand in investment banking and other finance interviews. You can grab the Excel file for yourself by clicking on the link at the top of this description.
Views: 53521 Mergers & Inquisitions / Breaking Into Wall Street
In this growth equity lesson, you'll learn how to set up 3-statement projection models for growth equity case studies. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" You will also learn how to calculate the potential IRR and money-on-money multiple at the end, and how to make an investment decision based on the output of the model. For all the Excel files, PDFs, written explanations, etc., please see: http://www.mergersandinquisitions.com/growth-equity-case-study/ Please see the link above to get all the Excel files, the PDFs, and the full written explanation along with the answer key. Table of Contents: 5:49 Model Assumptions 7:20 Revenue Assumptions 9:51 Expense Assumptions 11:22 CapEx, D&A, and BS/CFS Projections 13:25 Financial Statements 17:15 Returns Calculations 21:58 Conclusions
Views: 15023 Mergers & Inquisitions / Breaking Into Wall Street
In this tutorial, part 1 of a 2-part series on LBO case studies, we’ll look at what you might expect in a case study modeling test given at an assessment center or at the end of your internship at a bank or PE firm. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Table of Contents: 1:59 Case Study Overview 5:00 Strategy for Tackling the Case Study 9:39 Step 1: Assumptions and Sources & Uses 12:22 Step 2: Income Statement 13:12 Step 3: Cash Flow Statement and Debt Repayments 16:42 Step 4: Interest Expense and Linking the Statements 21:22 Step 5: IRR and Cash-on-Cash Multiple Lesson Outline: Download the documents linked to under this video to see the case study instructions and understand this lesson (and the follow-up lesson after this one). Key Points: With a time-pressured case study like this, you have to SIMPLIFY and cut corners where needed. Here, for example, we can simplify by only including 3 years of projections, skipping a complex debt schedule and Balance Sheet Projections, and consolidating the assumptions and Sources & Uses schedules. However, there are also a few tricky parts to be aware of – first off, despite the instructions, you do need to assume a purchase EBITDA multiple so that the model works initially. Also, you need to include more of a “real” investor returns calculations area, and you have to go a bit out of order because of the specific assumptions here. Step 1: Assumptions and Sources & Uses Assume a baseline purchase multiple just to get a price to use in the model, and then base the Uses side on this purchase price and the associated fees. Then, fill in Sources using the x EBITDA assumptions given for each tranche of debt, and back into Investor Equity by taking Total Uses and subtracting the debt sources so far. Step 2: Income Statement On the Income Statement, project revenue, EBITDA, and D&A according to the given assumptions, and calculate Pre-Tax Income and Net Income based on the tax rate assumption. Step 3: Cash Flow Statement and Debt Repayments Then, start the CFS with Net Income, add back the non-cash charges (just D&A for now), and factor in the changes in Inventory, AR, and AP. Since you don’t have a Balance Sheet, take a shortcut and just use the change in revenue times the relevant percentages to get these. Inventory and AR increasing will decrease cash flow, and AP increasing will increase cash flow. Calculate FCF by taking all of that and subtracting CapEx, and then include the amortization of Term Loans A, B, and C to determine the Net Change in Cash. At the bottom, the Cash Balance each year equals the Cash Balance from the prior year plus the Net Change in Cash. Step 4: Interest Expense and Linking the Statements First, track how Term Loans A through C change each year by subtracting the annual amortization. Hold the Second Lien constant. Keep the PIK Loan blank for now. Calculate interest expense using the BEGINNING balance (i.e. the one from the end of the previous year), not the average, to avoid circular references. Do this for all the debt tranches, as well as the interest earned on cash. Use LIBOR and the LIBOR spread, or the fixed interest rates for the Second Lien and the PIK Loan, to do this. Then, go back and make the PIK Loan increase by the PIK Interest each year, and then go back and link the Net Interest Expense on the Income Statement (it should be a negative there). Finally, make sure you include the PIK Interest as a non-cash add-back on the Cash Flow Statement now. Step 5: IRR and Cash-on-Cash Multiple Calculate the IRR and cash-on-cash multiple the normal way at the bottom; Investor Equity should always be a negative in Year 0, and you calculate the Exit Enterprise Value in Year 3 using the EBITDA in Year 3 and the EBITDA exit multiple we were instructed to use. Subtract Net Debt to calculate the Exit Equity Value. For now, Investor Equity = Exit Equity Value. Sum up all positives in the Investor Equity line and divide by the sum of all negatives there to calculate the cash-on-cash multiple; use the built-in IRR function in Excel to calculate that. In part 2 of this series, we’ll complete the case study by building sensitivity tables and using Goal Seek to turn the LBO model into a valuation methodology. We will also answer the case study questions. RESOURCES: http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-08-LBO-Model-Assessment-Center-Case.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-09-LBO-Model-Assessment-Center-Case-Answers.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-08-LBO-Model-Assessment-Center-Case-Before.xlsx http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-08-LBO-Model-Assessment-Center-Case-After.xlsx
Views: 32996 Mergers & Inquisitions / Breaking Into Wall Street