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: 51427 Mergers & Inquisitions / Breaking Into Wall Street
Excel Crash Course for Finance Professionals - FREE | Corporate Finance Institute Enroll in the FREE full course to earn your certification and advance your career: http://courses.corporatefinanceinstitute.com/courses/excel-crash-course-for-finance The ultimate Excel crash course for finance professionals. Learn all the Excel tips, tricks, shortcuts, formulas and functions you need for financial modeling in this free online course. Key concepts include: formatting, ribbon shortcuts, if statements, eomonth, year, paste special, fill right, fill down, auto sum, sumproduct, iferror, today(), concatenate, special numbers, vlookup, index, match, xirr, xnpv, yearfrac, and much more. -- FREE COURSES & CERTIFICATES -- Enroll in our FREE online courses and earn industry-recognized certificates to advance your career: ► Introduction to Corporate Finance: https://courses.corporatefinanceinstitute.com/courses/introduction-to-corporate-finance ► Excel Crash Course: https://courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance ► Accounting Fundamentals: https://courses.corporatefinanceinstitute.com/courses/learn-accounting-fundamentals-corporate-finance ► Reading Financial Statements: https://courses.corporatefinanceinstitute.com/courses/learn-to-read-financial-statements-free-course ► Fixed Income Fundamentals: https://courses.corporatefinanceinstitute.com/courses/introduction-to-fixed-income -- ABOUT CORPORATE FINANCE INSTITUTE -- CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the top universities, investment banks, accounting firms and operating companies in the world. By taking our courses you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical with step-by-step instructions to help you become a first class financial analyst. Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections -- JOIN US ON SOCIAL MEDIA -- LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi- Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute Google+: https://plus.google.com/+Corporatefinanceinstitute-CFI YouTube: https://www.youtube.com/c/Corporatefinanceinstitute-CFI
Views: 367366 Corporate Finance Institute
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: 379345 Wall Street Prep
In this Football Field Chart lesson, you'll learn how to create the infamous chart in investment banking. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" You will also learn how you can use it to assess and compare different valuation methodologies. While it may take some time to *format* the chart, the actual creation of the chart itself isn't too complicated... IF you know the proper tricks to make the process easier. Table of Contents: 2:02 Setting Up the Graph 4:51 Creating and Formatting the Graph 7:52 Interpreting the Graph 12:03 Recap and Summary 1. Setting Up the Graph First, link in the name for each methodology along with the Min, 25th Percentile, Median, 75th Percentile, and Max. Trick: Need to flip this and display them in the reverse order because of how Excel charts and graphs work… so input numbers in the leftmost column and sort by that column to do this quickly. Then, calculate the distance between each point on the right-hand side. "Trick" here is that each bar in the chart will be the length between one point and the next point - NOT that bar's absolute value! 2. Creating and Formatting the Graph Create a Stacked Bar Chart in Excel, with this data range selected, and then start formatting… we're skipping much of this here in the interest of time, and because it's covered in the Excel course in the graph/chart lessons there. Typically, you hide everything below the "Min" point, and you may also hide the Min to 25th and 75th to Max ranges depending on the #s… definitely the case if there are outliers, as there are here. You could also add a legend, axis titles, better labels, text labels of the indicative range of multiples and the company's figures on the right-hand side, and so on - depends on time available and how annoying your bosses want to be. 3. Interpreting the Graph VERY strange results here - first off, Precedent Transactions typically give higher values than Public Comps… ...but it's the reverse here, possibly because the market has radically shifted in the past ~1 year as multiples have soared. P / E and EV / Revenue multiples seem to indicate that the company is appropriately valued if you go by the median to 75th percentile range of the set (which may be appropriate here, given JAZZ's higher growth and margins vs. the comps). …and EV / EBITDA multiples indicate that the company may be undervalued substantially, even if you look at only the median of each set. The M&A comps and multiples may not even be that meaningful because of the problem we cited above - but it would be interesting to look at *premiums paid* for each company in addition to the standard multiples, because premiums often tell a different and more useful story. The DCF gives a much higher value than other methodologies, but this is not unusual because our view differs the MOST strongly from consensus estimates far into the future - so if we were analyzing this as a potential investment, the DCF would arguably be the most meaningful methodology here. On the other hand, if we did NOT put much time/effort into the DCF, then it might be the least meaningful of our methodologies here. Also, the much lower tax rate is more of a factor in the DCF… got tax inversions? Jazz Pharma is incorporated in Ireland, so its ~18% effective tax rate might be a huge draw for potential acquirers.
Views: 40439 Mergers & Inquisitions / Breaking Into Wall Street
In this episode of the financial modelling series Sergey, ex-Goldman Sachs investment banker, will describe how to build an operating model for a start-up company with the step-by-step financial modelling guide. 00:47 income statement assumptions total revenue cost of goods sold research & development sales & marketing general & administrative expenses other expenses 26:00 balance sheet assumptions operating assets operating liabilities capex & depreciation schedule other assumptions 37:35 income statement revenue gross profit operating expenses operating income ( EBIT) prfoit before taxes net income 49:10 balance sheet assets liabilities & shareholders equity 01:04:08 cash flow statement cash flow from operating activities Original Excel file with financial model can be found here: https://goo.gl/QScJgJ Our Investment Banking preparation course https://youtu.be/bBMmN8Cmq3g WANT TO GET INTO INVESTMENT BANKING? Join Sergey's course on Investment Banking Interview Prep https://edu.fless.pro/investment-banking-interview-prep-course SUBSCRIBE AND STAY WITH US! FLESS https://fless.pro Instagram https://www.instagram.com/flesspro Facebook https://www.facebook.com/flesspro VK https://vk.com/flesspro Telegram https://t.me/flesspro
Views: 7046 Fless
About this Course Excel, PowerPoint and Presentations for Investment Bankers covers the soft skill parts of Become an M&A Analyst: The Complete Skillset series. This course offers 41 lectures across 3 sections and everything is done with almost 10 hours of extensive video content. There is also 9 supporting Excel and PowerPoint supporting documents including some first class presentations. In this course, we will be covering all the Excel and Power Point skills necessary become an investment banking analyst. What should you expect from this course? Students/Career Changers - You will be able use Excel like a pro, as if you have been working in the industry for a few years - Deliver first class presentations using the most well-know methods and tricks Junior Employees - You will get better and faster in Excel and PowerPoint, eyeing your promotion Business Owners/ Entrepreneurs - You will develop super useful Excel and PowerPoint skills to make your daily business much more efficient visit https://www.mna-analyst.com/courses/excel-power-point-and-presentations-for-investment-bankers
Views: 1001 M&A Analyst
In this tutorial, you’ll get a quick but very powerful tip on how to optimize your PowerPoint setup and how to use the Quick Access Toolbar (QAT) and custom shortcuts to save a ton of time when creating pitch books, presentations, stock pitches, and more. 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, G, A, L: Align Left Alt, H, G, A, T: Align Top Alt, H, FC: Font Color Shift + Left Click: Select Multiple Shapes Alt, H, G, A, V: Distribute Vertically Alt, H, G, A, H: Distribute Horizontally Alt, H, G, R: Bring to Front Ctrl + G: Group Shapes These are the NEW shortcuts you can create via the Quick Access Toolbar: Alt, 1, L: Align Left Alt, 1, T: Align Top Alt, 1: Alignment Commands Alt, 2: Font Color Alt, 1, L: Align Left Alt, 1, V: Distribute Vertically Alt, 1, H: Distribute Horizontally Alt, 6, R: Bring to Front Lesson Outline: Many PowerPoint shortcuts that you use repeatedly when creating presentations are actually cumbersome to enter. Something as simple as left alignment takes 5 keystrokes – Alt, H, G, A, L – if you use the built-in method for it. Other common commands such as distribution, font color changes, shape fill, shape outline, and shape insertion 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; Alt, 2; Alt, 3; and so on 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 “Align Objects” in position #1, followed by Font Color, Shape Fill, Change Outline Color, More Options, Arrange, and Font Size. Then, you can add the Rectangle command, Draw Horizontal Text Box, Shapes, Straight Connector, and Merge Shapes. These are some of the most frequently used commands in PowerPoint, and you’ll save a ton of time with the new, shorter versions. A command like Align that used to take 5 keystrokes now takes only 3 (Alt, 1, L/R/T/B) with this approach; even a command like Font Color that took 4 keystrokes before now takes only 2 (Alt, 2). You might see anywhere from 30% to 50% time savings when creating slides and manipulating text and objects if you set up these shortcuts properly. They’re especially useful on crowded slides with a lot of objects when you need to align and distribute shapes. RESOURCES: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/PowerPoint-QAT-Export.exportedUI https://youtube-breakingintowallstreet-com.s3.amazonaws.com/PowerPoint-Shortcuts-Investment-Banking.pdf
Views: 27942 Mergers & Inquisitions / Breaking Into Wall Street
In this video, we discuss Investment Banking Front office vs Middle Office vs Back Office. Investment Banking Front Office In investment banking, front office essentially means those roles that interact directly with the clients. For example, sales and trading analysts have to interact with their clients on a daily basis. Investment bankers are in touch with their clients for pitching ideas. Likewise, equity analyst interacts with the client and advise them on BUY/SELL on stocks. Investment Banking Middle Office Investment Banking middle office roles include their interaction with the front office staff and ensures they comply with the rules and risks set by the team. Roles in risk management, process, and controls, strategy all come under Investment Banking Middle office. Investment Banking Back Office Investment Banking back office does all kind of reconciliation work after the trading. Also, the technology team also comes under the back office. You may learn more about this topic here in the article https://www.wallstreetmojo.com/investment-banking-roles-and-responsibilities/
Views: 9153 WallStreetMojo
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: 37295 Mergers & Inquisitions / Breaking Into Wall Street
Excel for Investment Banking - Finance Professionals Learn more: http://bit.ly/2adDz83 Become an Excel "Power User" by learning time-saving keyboard shortcuts and lesser-known Excel functions. The only way to learn Excel is by doing, so you will complete frequently encountered Excel exercises every step of the way. https://www.youtube.com/playlist?list=PLmefszqztJm7BOEcSFNF5_TZuyNz3uygY
Views: 146 Thomas Sander
In this video, we look at 5 Excel features that most financial analysts aren't even aware of. Find out what they are how to use them. (Video 8 of 8 for the course on Financial Modeling using Excel) To get CPD or CPE for this course, visit the Proformative Academy at www.proformative.com and use the COOK10 discount code to get a discount on your subscription. Learn more and become student at EF University for FREE - http://executivefinance.teachable.com/ Like us Facebook- https://www.facebook.com/exfinance/ Linkedin- https://www.linkedin.com/company/executive-finance Twitter- https://twitter.com/exfinance
Views: 58063 Executive Finance
Recorded in April 2015 - Career advice to interns at Citibank Uganda on my experience interning at Citibank and Goldman Sachs. *The views in this video are personal and do no represent the views of any of the companies mentioned* Email: [email protected] to get in touch
Views: 1660 sheSTEMs Network
Throughout the entire deal process, use FactSet to access the tools and information you need to make informed decisions, track the companies and industries that are important to you and your clients, generate better ideas, and identify new opportunities.
Views: 16441 FactSet
(MUST WATCH) There are IMPORTANT lessons about choosing the RIGHT career. 💗 Subscribe, if you don't want to miss future interviews (1-2 new videos/week): https://bit.ly/2U7k4o5 💡 20 questions with Todd Fasanella, Managing Director - Hospitality at Carlton Advisory Todd serves as Managing Director of the Carlton Hospitality Group focusing on originating, structuring and placing of equity and debt capital and advisory for hospitality transactions. Todd has over 20 years of investment banking and capital markets experience for real estate, hospitality and leisure owners and developer / operators, having structured, marketed and advised on over $25 billion of acquisitions, senior / mezzanine debt, preferred / common equity for cash flow and development projects during his career. Todd previously worked for Imperial Capital, Barclays Capital, Credit Suisse and The Prudential Realty Group. Todd received a bachelor of science in economics and mathematics from The Ohio State University and his MBA in finance and strategy from Yale University. -------------------------------------------- 💡 20 Questions with a Professional: 🔹 Chief Legal Officer: https://bit.ly/2XIhOSy 🔹 French and Dance Professor: https://bit.ly/2L2Y7DD 🔹 Head of Fundraising at a non profit: https://bit.ly/2DyY2Bv 🔹 Director of Marketing and Advertising: https://bit.ly/2J2ZKhJ 🔹 Real Estate Economist: https://bit.ly/2DAFoJp 🔹 Violin Teacher: https://bit.ly/2HhD1xl 🔹 Vice President of Merchandising: https://bit.ly/2GTWWC4 👉 Interviews with more professionals are coming in the next few weeks: Historian, Data Analytics Expert, Head of High School, Head of HR, Head of Insurance, Skin Expert, Cartoon Light expert, Sports Reporter, Film Director, Entrepreneur, .... -------------------------------------------- 🎓 Is working in investment banking for you? Todd Fasanella, a professional with over 20 years of experience in investment banking gives answers: 01:27 – Describe your typical working day as an investment banker 02:37 – What do you love most about your job? 03:32 – What is the hardest part about this investment banking profession? 04:35 – Tell us a secret about your investment banking profession that many outsiders will find surprising. 05:59 – What kind of classes should one take if interested in investment banking? 06:44 – What qualities are important to succeed in investment banking? 07:40 – Describe the advancement potential and typical path in the field 09:57 – What developments on the horizon could affect opportunities in your industry? 11:11 – Are there self-employment opportunities within this field? 11:44 – When and how did you first realize you like investment banking? 12:37 – What one world problem do you wish you could solve? 13:20 –Who are you most grateful for in your career? 14:37 – SPEED ROUND 15:38 – INSPIRING MESSAGE 💭 Comment below which part of this interview have you found most exciting. ✔️ If you are working in investment banking, write what do you love the most about your job! ✍️ Contact: [email protected] #investmentbanking #bankinginvestment #bankingjobs #investmentbankinganalyst #careeradvice #selfdevelopment #selfhelp #whatcareershouldichoose -------------------------------------------- Related information: Investment banking - introduction to investment banking. Investment Banking Analyst jobs. NYC GLOBAL INVESTMENT BANKING INTERNSHIP. How Much Does An Investment Banker Earn? The latest investment banking salary. What is Investment Banking in HINDI || Investment Banker? The typical Goldman Sachs Investment Banking Analyst salary is $88,036. investment banking analyst lifestyle, investment banking lifestyle. what is investment banking?. Investment Banking Analyst Lifestyle. what do investment banks actually do? What to expect in an investment banking interview including the format, Superday, technical questions, qualitative questions, and networking advantages. James Donovan Goldman Sachs: the skills needed to work on corporate transactions as a lawyer or investment banker. regulation of investment banking. learn what to expect as an investment banking analyst and investment banking associate... it was the gold standard in investment banking for decades and partners got rich when the company went public. top universities for investment banking. how Goldman Sachs became wall street's most powerful investment bank. learn about what investment bankers do:... that's the exact reason why I went into investment banking and became an investment banker... a day in the life of an investment banking analyst and associate is not glamorous. investment banking - life as an investment banker. 100 stories | the investment banker with a heart of gold. many investment bankers are addicted to drugs and alcohol. Apply to Investment Banking Analyst. Investment banking interview Thank you for watching Investment Banker with 20+ years of experience / INVESTMENT BANKING career // Prof with a Mic.
Views: 2076 Prof with a Mic
Subscribe Now For More Content - Back on the 10th of June 2019 -- In this video we will go over what you can expect during your investment banking interviews, we will cover specific questions as well as ideal answers to help you ace your interviews and land the job. Only 2% of applicants are successful in their investment banking recruitment and a large proportion of candidates fail there interviews over simple questions. In this video I will show you what questions you need to prepare for, most will be surprised by the level of knowledge you will need, hence why only 2% are successful every year. Investment Banking Interviews are broken into two parts Behavioural & technical questions. To be successful you will need to ace both sets of questions regardless of your background. Behavioural / Competency questions are designed to see how you cope under pressure and to see how well you know about the industry and the life of an investment banker. Theses questions are often overlooked but if you get one of these questions wrong then you might as well just walk out of the interview room. Technical questions are broken into the following 1) Basic Accounting 2) Finance 3) Financial Valuation 4) M&A 5) LBO 6) Brain teasers Behavioural questions: Walk me through your resume Why Investment Banking What are your weaknesses What are your strengths Why this firm
Views: 6032 High Finance Graduate
Subscribe Now For More Content - Back on the 10th of June 2019
Views: 32820 High Finance Graduate
Download my new book for free at http://HarounVentures.com ★★★★★ Enroll in this course for just $9.99 (30 day 100% money back guarantee): https://www.udemy.com/the-complete-financial-analyst-training-and-investing-course/?couponCode=YT72218 Course Description: ★★★★★ #1 Best Selling Investing Course on Udemy! Welcome to The COMPLETE Financial Analyst Training and Investing Course by the author of the best selling business course on Udemy, an award winning professor, Columbia MBA graduate, former Goldman, hedge fund founder, venture capitalist, TEDx Talk speaker, author & entrepreneur featured in Forbes, Business Insider, Wired and Venture Beat. I guarantee that this is THE most thorough financial analyst course available ANYWHERE on the market - or your money back. This is the most thorough and longest course I have ever made and anyone can take it and see remarkable improvements in how competitive they are in the finance industry as a financial analyst or as an investor. This course is taught by Chris Haroun who also went through the Goldman Sachs financial analyst training program as well as the new hire training programs of other top finance companies. Chris has also started his own hedge fund and venture capital firms and is an award winning MBA school professor. He teaches based on real life practical experience. Do you have what it takes to complete this 22+ hour comprehensive finance training program? I'll see you on the other side. What Will You Learn in this Finance Bootcamp Course? How to pick stocks. Become an expert in Excel for financial analysts. How an IPO works. How to manage a portfolio. How to build financial models. How to get hired and promoted as a financial analyst. How risk management works. How to use technical analysis. How to value companies. Use and create Excel based templates developed by Chris to help you create financial statements from scratch (meaning income statements, balance sheets, cash flow statements and more). Use and create Excel based templates developed by Chris to help you value companies using several different valuation methodologies, including P/E, P/R and Discounted Cash Flow (DCF). Use and create Excel based templates developed by Chris to help you manage a portfolio. How Monetary Policy works. How Fiscal Policy works. How interest rates are changed and why this is crucial to understand for successful financial analysts. How to pitch long and short ideas to portfolio managers. How to find great venture capital investment ideas. How to come up with mutual fund investment ideas (longs - meaning buys) using an easy to understand top down and bottoms up research process. How to come up with hedge fund investment ideas (longs and shorts) using an easy to understand top down and bottoms up research process. Identify crucial catalysts (timed events) in order to know when the optimal time is to buy or short a stock. Understand how investment banks (the 'Sell Side') can help you be more successful in a hedge fund or mutual fund career. Analyze and understand an income statement (even if you have no experience with income statements). Analyze and understand a balance sheet (even if you have no experience with balance sheets). Analyze and understand a cash flow statement (even if you have no experience with cash flow statements). Understand and use modeling best practices so you can create financial models. Know where to get data in order to build a financial model (in depth understanding of identifying and using/navigating the best free websites and sources to build your financial model)! Create a financial model (projecting the future) for an income statement. Create a financial model (projecting the future) for a balance sheet. Create a financial model (projecting the future) for a cash flow statement. Understand valuation best practices so you can create target prices based on your financial models. How to use Discounted Cash Flow (DCF) and how to create the Weighted Average Cost of Capital and Terminal values in order to pick target prices. How to use P/E in order to pick target prices. How to use P/R in order to pick target prices. Other valuation methodologies, including EV/Sales, EV/EBITDA, P/B, EV/FCF, etc. Come up with a target price based on an average of several different valuation methodologies. Learn about 14 different Financial Analyst jobs and how they overlap and work together (including Investment Banking, Venture Capital, Private Equity, Private Wealth Management etc.). Enroll in this course for just $9.99 (30 day 100% money back guarantee): https://www.udemy.com/the-complete-financial-analyst-training-and-investing-course/?couponCode=YT72218
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: 228364 Mergers & Inquisitions / Breaking Into Wall Street
Welcome to Corporate Bridge YouTube Channel. This Video clearly explains you about Investment Banking Pitch Book using Excel. Visit our website https://www.educba.com/ for FREE Demo. Check out our YouTube Channel for more financial courses video.
Views: 6515 eduCBA
Quant Corporate Finance Advisory Investment Banking
Views: 408 Shivbhakta Joshi
The discount cash flow analysis (DCF) is a fundamental valuation methodology broadly used by investment bankers, corporate officers, and other finance professionals. It is based on the principal that the value of a company can be derived from the PV of its projected free cash flow (FCF). While many videos cover the actual framework and how to build the excel model, the assumptions and thinking behind the model are often left to more “real world” examples. This is that example! Chapter 3 covered topics like; - How do you project revenues for a DCF model? - How many years do you project cashflows for? - What is the exit multiple method? - What is the perpetuity growth method? - How do you project EBITDA for a DCF model? - How do you project EBIT for a DCF model? - How do you project the NWC for a DCF model? - What is the mid-year convention? - How do you calculate unlevered free cash flow? For those who are interested in buying the Investment Banking: Valuation, Leveraged Buyouts, and Mergers and Acquisitions by Joshua Rosenbaum and Joshua Pearl, follow the Amazon link below; https://www.amazon.ca/Investment-Banking-Valuation-Leveraged-Acquisitions/dp/1118656210 If you have any other questions, please comment below. If you enjoyed the video and found it helpful, please like and subscribe to FinanceKid for more videos soon! For those who may be interested in finance and investing, I suggest you check out my Seeking Alpha profile where I write about the market and different investment opportunities. I conduct a full analysis on companies and countries while also commenting on relevant news stories. http://seekingalpha.com/author/robert-bezede/articles#regular_articles Videos referenced; Estimating Cost of Debt For WACC: https://www.youtube.com/watch?v=CSkPlxEe-dY Estimating Cost Of Equity For WACC: https://www.youtube.com/watch?v=ZigyWoDAMrE Projecting NWC; https://www.youtube.com/watch?v=2E1Hca2dVbI Why Is Your DCF Model Incorrect? https://www.youtube.com/watch?v=ByyK0AMuLxc
Views: 9721 FinanceKid
Joshua Rosenbaum and Joshua Pearl, authors of the highly acclaimed and authoritative textbook, Investment Banking, walk you through some common behavioral questions asked during the investment banking interview process. Learn with the pros at http://www.efficientlearning.com/ib. Don't guess what it takes to ace your interview and and answer questions such as "Why investment banking?" 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: 124831 Wiley Finance
SOLUTION LINK: http://libraay.com/downloads/office-2016-myitlab-ms-excel-grader-ex16_xl_ch08_grader_ml1_hw-investment-banking-1-2/ You are an investment banker and you would like to put together a brief statistical report of the most-viewed stock quotes for the day. To complete this task, you will enter stock prices and create a report using the Analysis ToolPak. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open exploring_e08_grader_m1_Stocks.xlsx. 0.000 2 Type Symbol in cell B2, type Last Sale Price in cell C2, and type Rank in cell D2. 12.000 3 Enter the following stock information beginning in cell B3: Click cell B3 and type CTIC. Click cell C3 and type 1.92. Click cell B4 and type AAPL. Click cell C4 and type 130.96. Click cell B5 and type C. Click cell C5 and type 59.19. Click cell B6 and type BAC. Click cell C6 and type 18.12. 8.000 4 Use the RANK.AVG function to calculate the rank of the first stock in cell D3 and copy the formula down to complete the column. 12.000 5 Click cell B8, type Average value, and in cell C8 type 100 . In cell B9, use the AVERAGEIF function to calculate the average value of stocks that sell for less than $100.00 using the criteria in cell C8. 20.000 6 Set column B width to 13, column C to 22, and apply Accounting number format to cell B9. 12.000 7 Create a Descriptive Statistics Summary report using the range C2:C6 as the input range and cell F2 as the output range. Note that the first row of the input range contains labels. 10.000 8 Rename the worksheet Stock Quotes and apply the following formatting: • Apply Accent2 Themed Cell Style format to the ranges B2:D2 and B8:C8. • Apply Top and Bottom Borders to the ranges B8:C8 and B2:D2. • Apply Thick Bottom Border to the range B6:D6. 16.000 9 Create a footer with your name on the left side, the name of the worksheet in the middle, and the file name on the right side.
Views: 309 Libraay Downloads
When you aspire to become an expert investment banker, you need to excel in investment banking operations. The Mergers-and-Acquisitions accompanying raising of capital market through IBO process occupy the top place in the departments of investment banking. Third being STO(Security Traning Organisation) which includes the dealing of brokers in capital markets, i.e. equity and dead market. How does it operate? Clients of investment banking having a lot of capital book a deal with the assistance of an investment banking firm to make more money. Overall, Investment Banking Operation is the process from the initiation of customer booking a deal to the actual settlement of trade. As a responsible banker, have an optimistic attitude. Learning the new trends of the market and linking finance in everyday life can help in broadening concepts. Be in touch with the integrities of upcoming policies. Keep track on stocks. Remember the top and bottom 5 stocks of the day. In-depth knowledge of the flow of money and economy and the entire financial circle will make you gain expertise. Correlating the financial indicator of the country, i.e. index with the economic indicator of the country, i.e. the balance of payment would develop your understanding to a prominent level. Check our complete #ImarticusPrograms playlist here: http://bit.ly/2JP52hM Subscribe to our channel to get video updates. To know more about investment banking certification, please visit here - https://imarticus.org/certified-investment-banking-operations-program/?utm_source=youtube&utm_medium=organic&utm_campaigntype=youtube - - - - - - - - - - - - - - - - - Why Imarticus? Imarticus Learning offers a comprehensive range of professional Financial Services and Analytics programs that are designed to cater to an aspiring group of professionals who want a tailored program on making them career ready. Our programs are driven by a constant need to be job relevant and stimulating, taking into consideration the dynamic nature of the Financial Services and Analytics market, and are taught by world-class professionals with specific domain expertise. Headquartered in Mumbai, Imarticus has classroom and online delivery capabilities across India with dedicated centres located at Mumbai, Bangalore, Chennai, Pune, Hyderabad, Coimbatore and Delhi. For more information, please write back to us at [email protected] Call us at IN: 1-800-267-7679 (toll-free) - - - - - - - - - - - - - - - - - Website: https://imarticus.org/ Facebook: https://bit.ly/2y6UjKW Twitter: https://bit.ly/2J11llx LinkedIn: https://bit.ly/2xwSoPM
Views: 2514 Imarticus Learning
Download File: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/WAATP2017TacomaAccountingExcelConferenceStart.xlsx Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/WAATP2017TacomaAccountingExcelConferenceFinished.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Excel Accounting Seminar: 2017 WAATP Tacoma Accounting Conferences at La Quinta Inn, July 12 This is the first video in a series of two videos. This video will teach you everything you need to know about Excel for your Accounting Job : ) Topics in Video: (00:08) Introduction to video topics and Excel files and how to navigate large workbook and video 1. (02:13) Keyboards Rule Because They Are Fast 2. (04:33) Number Formatting is a Façade 3. (07:01) How to Add Quickly 4. (10:15) Date Calculation Templates 5. (10:50) TODAY and (19:50) EDATE functions 6. (12:24) Angry Rabbit Mouse Copy Trick 7. (14:46) Date Number Formatting 8. (17:05) Formulas for Date Calculations 9. (20:21) Absolute & Relative Cell References 10. (22:15) Excel's Golden Rule 11. (24:46) Payroll Quickly 12. (24:46) ROUND Function Importance 13. (24:46) Formulas Can NOT See Number Formatting 14. (31:40) Create Cosumer Loan Amortization Table 15. (33:13) PMT Function to calculate PMT on Annuity with Regular PMT and Constant Rate 16. (36:44) Fill Series to generate list of numbners from 0 to 360 17. (38:51) Smart Tags to Fill End of Month Only (And it knows Leap Year!!!) 18. (40:01) Borders to enhance Report 19. (42:48) Calculations for Amortization Table with Relative and Absolute Cell References 20. (47:10) Invoice Template 21. (47:24) VLOOKUP Function 22. (52:40) Data Validation, List to add Drop-Down List to Cell 23. (54:32) IF Function 24. (54:32) ISBLANK Function 25. (24:46) ROUND Function (link back to earlier part of video) 26. (01:02:35) FV of Investment Template 27. (01:02:35) Mixed Cell References 28. (01:05:50) F4 Key to cycle through 4 different types of Cell References (Merry Go Round) 29. (01:08:05) FV Function 30. (01:11:00) SUMIFS and COUNTIFS to create Summary Reports. Also: Advantage of Formulas Over PivotTable. 31. (01:18:38) Check Book Register Example 32. (01:19:02) Border Formatting 33. (01:20) Formula with Relative Cell References to calculate Balance 34. (01:21:29) IF Function 35. (01:21:29) ISNUMBER Function 36. (01:23:44) 1) Data Validation For Reconciling Column. 2) Conditional Formatting for whole row using Mixed Cell References 37. (01:29:50) Flash Fill to extract and clean Data Quickly Learn Excel Basics, Learn how to build Accounting Templates, Learn Excel Tricks for your Accounting Job. Event Sponsored by: Puget Sound/Tacoma Chapter WAATP Vice President Darlene Sondergaard Location: La Quinta Inn 1425 E 27th St, Tacoma, WA 98421 Event Details: Wednesday, July 12 at 8 AM
Views: 191552 ExcelIsFun
Sensitivity Analysis for Financial Modeling Course | Corporate Finance Institute Enroll in the full course to earn a certificate and advance your career: http://courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling This advanced financial modeling course will take a deep dive into sensitivity analysis with focus on practical applications for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions. Course agenda includes: Introduction Why perform sensitivity analysis? Model integration - Direct and Indirect methods Analyzing results Gravity sort table Tornado charts Presenting results By the end of this course, you will have a thorough grasp of how to build a robust sensitivity analysis system into your financial model. Form and function are both critical to ensure you can handle quick changes and information requests when you're working on a live transaction.
Views: 178057 Corporate Finance Institute
http://insideinvestmentbanking.com - Learn How To Break Into Investment Banking If you are looking to launch a career in investment banking visit Inside Investment Banking now. Created by 5 bankers it is your one-stop shop for advice on how to get into investment banking. About this Video: This is a quick look at some very common tasks bankers like to assign to investment banking interns.
Views: 24092 BreakIntoBanking
Financial modeling is one of the most highly valued but thinly understood skills in finance. The objective is to combine accounting, finance, and business metrics to create an abstract representation of a company in Excel, forecasted into the future. Click here to learn more about this topic: https://corporatefinanceinstitute.com/resources/knowledge/modeling/financial-modeling-for-beginners/
Views: 25209 Corporate Finance Institute
In this video on Market making, we look at what is market making and how investment bankers help firms to trade by providing liquidity to the market. Market Maker is someone who actually ensures liquidity in the market. As one of the services, Investment banking firms provide liquidity for trading by either buying the shares or selling the shares. This ensures that the trades happen and ensures that the market is less volatile. You can learn more on Market making here - https://www.wallstreetmojo.com/market-makers/
Views: 958 WallStreetMojo
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: 32203 Mergers & Inquisitions / Breaking Into Wall Street
Wall St. Training Self-Study Instructor, Hamilton Lin, CFA illustrates the football field exhibit that summarizes the valuation methodologies and associated reference ranges. For more information of the video courses previewed here, go to: http://www.wstselfstudy.com/modules.html Over 80 hours of online, interactive Self-Study Videos! ***YOUTUBE VISITORS ONLY*** 10% off any online course, use Discount code: youtube http://www.wstselfstudy.com Wall St. Training Self-Study provides online, video-based, self-study financial modeling training solutions to Wall Street. Our interactive course modules are Excel-based and specialize in advanced and complex financial modeling, valuation modeling, investment banking, mergers & acquisitions and leveraged buyout training topics. Enhance your skills and master the content required by Wall Street investment banks, M&A, research, asset management, credit, and private equity firms.
Views: 25020 wstss
Subscribe Now For More Content - Back on the 10th of June 2019
Views: 7541 High Finance Graduate
Please hit ‘like’ and subscribe if you enjoyed this video. TIMESTAMPS 01:16 Sales-Traders (who are they and what do they do?) 02:26 Execution Traders (who are they and what do they do?) 03:39 Structurers (who are they and what do they do?) 05:11 Structurers (what is their background is studying?) 06:06 Quants (who are they and what do they do?) 06:52 Quants (leveraging artificial intelligence, big data and algorithmic trading) Business enquiries: [email protected] Other videos you might like: How to Get an Internship at Goldman Sachs: https://www.youtube.com/watch?v=GJ4p4RvLoTk Front Office vs Back Office in Investment Banking: https://www.youtube.com/watch?v=KLGlzR9a1sg Day in the Life of a Goldman Sachs Analyst: https://www.youtube.com/watch?v=y4luue9VZag What I Learnt From Working at Goldman Sachs: https://www.youtube.com/watch?v=RL5J1mkwgGI 10 Top Tips for Writing a Powerful CV: https://www.youtube.com/watch?v=yepdQYMJntA These 3 Things Will Make Your Cover Letter Stand Out: https://www.youtube.com/watch?v=-nsbNEnMqGw How to Answer the “Tell Me About Yourself” Interview Question: https://www.youtube.com/watch?v=gUR2RJS6xrw What to Wear to a Goldman Sachs or Investment Banking Interviews: https://www.youtube.com/watch?v=VUX9gYjfCz8 10 Reasons University Ranking Doesn’t Matter for Investment Banking: https://www.youtube.com/watch?v=paprYLKd7Kc 15 Ways to Network Like a Pro: https://www.youtube.com/watch?v=WVGuVJ1Svrg Top Universities for Investment Banking – 5 Reasons: https://www.youtube.com/watch?v=AE8wMc0Ok-A What is a Spring (Insight) Week?: https://www.youtube.com/watch?v=wiLy7LphI8Y&t=113s 10 Signs Your Job Interview Went Well: https://www.youtube.com/watch?v=wmAyyqrfIvA Assessment Centres Explained: https://www.youtube.com/watch?v=8q7DKSHeGpc Acing Your Assessment Centres: https://www.youtube.com/watch?v=_mWqvsCC9kM Investment Banking Salary – Analyst: https://www.youtube.com/watch?v=ZX6dz61s-po&t=19s Investment Banking Pay Per Hour: https://www.youtube.com/watch?v=JV9soTTmq0g&t=234s Buy-Side vs Sell-Side – The Main Differences: https://www.youtube.com/watch?v=hxvTXuh7vLE&t=287s Why You Should Start Your Career In Banking & Finance: https://www.youtube.com/watch?v=Ibf210USPwQ&t=2s 8 Reasons Why Your Degree Course Doesn’t Matter: https://www.youtube.com/watch?v=n9Ddp_XX-Ss How To Easily Answer Brainteaser Interview Questions (NEVER WORRY AGAIN!): https://www.youtube.com/watch?v=V-iSKKxOjAg A-Level Subjects for Banking (The SIMPLE TRUTH!): https://www.youtube.com/watch?v=vGvwfL4Hooc Investment Banking Bonuses (& How They're ACTUALLY Determined): https://www.youtube.com/watch?v=USNYfASNVLQ Sales & Trading in an Investment Bank (Part 1 - Banking Roles Explained): https://www.youtube.com/watch?v=NyZ3uS7QyxM&t=401s PLEASE LEAVE VIDEO SUGGESTIONS/IDEAS AND QUESTIONS IN THE COMMENTS BELOW. I like sharing practical, helpful and easy to understand advice on how to get the career of your dreams whether you're a student, graduate or experienced professional. Careers can be tricky. I want to change that. Make sure to hit the subscribe button to watch new videos every Wednesday! My personal website: https://www.afzalhussein.com My career consulting website: https://www.officialcvdoctor.com/ Follow me on social media: Instagram: https://www.instagram.com/afzal_hussein/ LinkedIn: https://www.linkedin.com/in/afzalhussein - please hit ‘follow’ as I’ve used all 30k connections! Twitter: https://twitter.com/Afzal_Hussein_ Intro music: https://goo.gl/qN1M5t Sales-Trading, Structuring and Quant in an Investment Bank (Part 2 - Banking Roles Explained) #InvestmentBanking #Finance #University #Careers #Students
Views: 3721 Afzal Hussein
In this video on Corporate Finance vs Investment Banking career's, we will help you decide which career to choose by comparing its concepts, skills and many more. 𝐈𝐧𝐯𝐞𝐬𝐭𝐦𝐞𝐧𝐭 𝐁𝐚𝐧𝐤𝐢𝐧𝐠 𝐯𝐬 𝐂𝐨𝐫𝐩𝐨𝐫𝐚𝐭𝐞 𝐅𝐢𝐧𝐚𝐧𝐜𝐞 ------------------------------------------------------------------------- Investment Banking and Corporate Finance are the most promising career options for finance students. Both the areas offer highly competitive job roles, and excellent prospects to grow as a professional. 𝐂𝐨𝐧𝐜𝐞𝐩𝐭𝐮𝐚𝐥 𝐃𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐜𝐞𝐬 - 𝐈𝐧𝐯𝐞𝐬𝐭𝐦𝐞𝐧𝐭 𝐛𝐚𝐧𝐤𝐢𝐧𝐠 𝐚𝐧𝐝 𝐂𝐨𝐫𝐩𝐨𝐫𝐚𝐭𝐞 𝐅𝐢𝐧𝐚𝐧𝐜𝐞. ----------------------------------------------------------------------------------------------------------- 𝗜𝗻𝘃𝗲𝘀𝘁𝗺𝗲𝗻𝘁 𝗯𝗮𝗻𝗸𝗶𝗻𝗴 Investment Banking deals with major financing activities including acquiring other businesses, issue of securities, raising capital for a business. 𝗖𝗼𝗿𝗽𝗼𝗿𝗮𝘁𝗲 𝗙𝗶𝗻𝗮𝗻𝗰𝗲 It is basically concerned with the companies financial activities. Decisions for investments or for raising capital fall within its domain. The main objective is to maximize the value of a business by making financial decisions which may include identifying avenues for reinvesting profits, allocation of resources, or raising capital by issuing equity or debt securities. 𝐒𝐤𝐢𝐥𝐥𝐬 𝐍𝐞𝐞𝐝𝐞𝐝 𝐟𝐨𝐫 𝐂𝐨𝐫𝐩𝐨𝐫𝐚𝐭𝐞 𝐅𝐢𝐧𝐚𝐧𝐜𝐞 𝐂𝐚𝐫𝐞𝐞𝐫 ---------------------------------------------------------------------------- 1. Excellent analytical abilities 2. Expert knowledge of financial analysis 3. Broad-based knowledge of corporate finance 4. Excellent communication abilities 5. Good accounting skills 𝐒𝐤𝐢𝐥𝐥𝐬 𝐍𝐞𝐞𝐝𝐞𝐝 𝐟𝐨𝐫 𝐈𝐧𝐯𝐞𝐬𝐭𝐦𝐞𝐧𝐭 𝐁𝐚𝐧𝐤𝐢𝐧𝐠 𝐂𝐚𝐫𝐞𝐞𝐫 ------------------------------------------------------------------------------- 1. Excellent analytical abilities 2. Advanced knowledge of financial concepts 3. Excellent networking abilities 4. Expert at client negotiation 5. Hard skills like Valuations, Financial Modeling, PowerPoint presentations and Excel. To know more about Investment banking vs Corporate Finance, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞: https://www.wallstreetmojo.com/corporate-finance-vs-investment-banking/ Subscribe to our channel to get new updated videos.Click the button above to subscribe or click on link below to subscribe - https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1
Views: 1384 WallStreetMojo
20 Questions you may be asked at an iInvestment bank Interview. http://www.financial-spread-betting.com/course/technical-analysis.html PLEASE LIKE AND SHARE THIS VIDEO SO WE CAN DO MORE! What is the best way to a job at an investment bank? How did you get hired at an investment bank? I know we have some subscribers who are looking to get a job in the trading world - whether at an investment bank or proprietary trading firm. I've done a bit of research for you guys.. Investment banking interview question examples: 1) Which is greater 17% of 34 or 34% of 17. 2) What is going on in the economy? 3) If a specific data is announced (say an increase in interest rates or there is an increase in Non-Farm Payrolls) which 5 trades would you make? 4) Do you think Apple is a good buy? 5) If I gave you a million dollar and asked you to generate some alpha within the next 6 to 12 months how would you go about it? 6) What can a firm accomplish in Chapter 11 that it can't accomplish out of court? 7) What could be the reason for 2 companies operating in the same industries operating at different EBITBA multiples? 8) Why would a creditor elector receive equity via a restructuring process as opposed to debt/ 9) Walk me around the world and tell me about the markets as you go. 10) 4 asset classes - gold, oil, USA 10-year treasury rates and S&P 500 - pick one and tell me where it has been and where do you see it going and why. 11) Tell us about a deal that we've done that interests you and why? 12) Explain quantitative easing to me. 13) Talk me about the shape of the Yield Curve. 14) How do you value a mining company - what multiples are most appropriate? 15) Where is the world headed 16) Describe a few instances where you have failed.. 17) Describe the major transactions that have happened in a specific industry (say retail) 18) Assume you're an investor and you come across a family-owned business for sale - how do you go about valuing that business. 19) Sell me this water bottle... 20) Tell me about something you read about the news that you think will have a positive or negative implication for the USA or equity markets. 21) Once you receive offers from a number of firms - what will be the most important factors for you as you think which one you will which accept? Related Videos 6 Crazy Questions Asked at Prop Trading Job Interviews & Investment Banks 🤪 https://www.youtube.com/watch?v=sXWebDEhCvg Top 6 Trading Job Interview Questions 🙋 https://www.youtube.com/watch?v=DRPtOSJCIbc
Views: 6736 UKspreadbetting
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: 60614 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: 390451 Wall Street Prep
Collecte Investment Banking Master 2 ou IBM2 - Cours Produits Dérivés et VBA Excel : https://fr.ulule.com/investment-banking-master-2/
Views: 199 Tjomb Bell
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: 26321 Mergers & Inquisitions / Breaking Into Wall Street
Modeling,LBO,DCF,Accounting,Investment banking,IB,Merger,Acquisition,Mergers and Acquisiton,Excel shortcuts,Financial modeling,Excel cheat tricks,Excel,Excel tricks,MS Excel,Shortcuts
Views: 89 Modeling Wizards
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: 43772 Mergers & Inquisitions / Breaking Into Wall Street
Investment banks are notorious for their highly competitive working environment and long working hours for junior employees. Nevertheless, they continue to be seen as one of the prime destinations for talented Business and Finance graduates, given the excitement of working on large deals and the high pay scale that comes with this job. Investment banking operations tend to be more sophisticated than traditional “deposit taking, credit giving” retail banking services. Investment banks work closely with corporate clients, pension funds, financial sponsors and governments to structure and execute some of the largest transactions that we see in the news. On Facebook: https://www.facebook.com/365careers/ On the web: http://www.365careers.com/ On Twitter: https://twitter.com/365careers Subscribe to our channel: https://www.youtube.com/365careers
Views: 97007 365 Careers
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: 51616 Mergers & Inquisitions / Breaking Into Wall Street
Global Investment Banking Analyst/Associate Program Location: London or Remote/Web Video Conferencing The Global Investment Banking Program is an exciting opportunity to gain experience of real world transactions and working knowledge for Investment Banking, Private Equity and Hedge Fund careers. The program will give you solid understanding of transaction concepts and robust practical skills for extensive investment banking work experience. The 5-week program provides the following real world experience: • Analysis of London stock exchange and New York stock exchange listed companies • Preparation of buy and sell side transaction pitches, teasers, and writing confidential investment memo • Excel Financial modeling and valuation of public listed companies by using "Comparable comps" method • Excel Financial modeling and valuation of public listed companies by using " Discounted cash flow" method • Excel Financial modeling and determination of the premium paid by buyer of the business by using "Transaction comps" method • Excel Financial modeling and leveraged buyout of the company by a Private Equity sponsor • Preparation of M&A transaction-ready model with Accretion/Dilution analysis of the deal • Board presentation and closing of investment banking transactions Upon completion of the program you will be prepared to carry out responsibilities of a full-time Analyst/Associate in investment banks and private equity firms. The program statement on your CV and your work experience reference report will enable you to stand out from thousands of other candidates and ensure that you are a strong contender in one the most competitive industries in the world. How to apply: Please send your CV to [email protected] Please note that a placement fee applies
Views: 15379 Global Banking School
Truly speaking there is no comparison between fixed deposit and equity as both these investment options are different. However, for better understanding Let’s compare fixed deposit with equity. Bank Fixed Deposit VS Investment in Same Bank Share If you are Intelligent Investor with the ability to understand the business and its growth opportunity in the long term. Stick to stock market instead of a fixed deposit.
Views: 6881 Money Excel Personal Finance Blog