Mergers & Inquisitions / Breaking Into Wall Street
Mergers & Inquisitions / Breaking Into Wall Street
  • 166
  • 7 462 493
The Balance Sheet: Back to the Future of Corporate Finance
Learn more here: breakingintowallstreet.com/core-financial-modeling/?
You'll learn all about the Balance Sheet in this tutorial, with a focus on how it is used and projected in financial models and how to use it when answering accounting interview questions.
Files & Resources:
breakingintowallstreet.com/kb/accounting/balance-sheet/
Table of Contents:
0:00 Introduction
0:37 The Short Version
5:56 Part 1: Balance Sheet Sample and Example Line Items
7:51 Part 2: Financial Model Projections and Required Links
11:37 Part 3: Why the Balance Sheet is Critical in Interview Questions
13:06 Recap and Summary
zhlédnutí: 2 824

Video

Project Finance vs. Corporate Finance: Deals, Modeling, and Math
zhlédnutí 4,9KPřed 14 dny
Learn more here: breakingintowallstreet.com/project-finance-modeling/? This tutorial will explain the differences between Project Finance and Corporate Finance, focusing on technical analysis, deals, and financial models. Files & Resources: mergersandinquisitions.com/project-finance-vs-corporate-finance/ Table of Contents: 0:00 Introduction 1:22 Part 1: The 2-Minute Summary 3:47 Part 2: Assets ...
Return on Equity (ROE): The Most Industry-Specific “Generalist” Metric
zhlédnutí 1,8KPřed 21 dnem
Learn more here: breakingintowallstreet.com/core-financial-modeling/? This tutorial will explain Return on Equity (ROE), including why it's critical for banks, insurance firms, and regulated utility companies, but less important in other sectors. Files & Resources: breakingintowallstreet.com/kb/financial-statement-analysis/return-on-equity-roe/ Table of Contents: 0:00 Introduction 4:36 Part 1: ...
Convertible Notes for Startups: A Safer Alternative Than the SAFE?
zhlédnutí 1,3KPřed měsícem
Learn more: breakingintowallstreet.com/venture-capital-modeling/? This tutorial will explain Convertible Notes for startup financing, including the mechanics, dilution, and a full comparison to SAFE Notes. Files & Resources: breakingintowallstreet.com/kb/venture-capital/convertible-notes/ Table of Contents: 0:00 Introduction 5:19 Part 1: Convertible Notes in a Seed Round 6:01 Part 2: Conversion...
Funds from Operations (FFO): REIT Analysis 101
zhlédnutí 1,3KPřed měsícem
In this tutorial, you'll learn all about "Funds from Operations" (FFO) for real estate investment trusts (REITs), a key metric used for financial statement analysis and valuation. Files & Resources: breakingintowallstreet.com/kb/reit-modeling/funds-from-operations-ffo/ Table of Contents: 0:00 Introduction 4:20 Part 1: Why We Use FFO for REITs 6:42 Part 2: Using FFO to Value REITs in Real Life 8...
Venture Debt: A Bridge to Survival for Startups, or a Bridge to Nowhere for Lenders?
zhlédnutí 1,7KPřed 2 měsíci
Learn more: breakingintowallstreet.com/venture-capital-modeling/? This tutorial will give you a crash course on venture debt for VC-backed startups, including the key terms, the returns calculations, and the risks. Files & Resources: breakingintowallstreet.com/kb/venture-capital/venture-debt/ Table of Contents: 0:00 Introduction 1:20 Part 1: Venture Debt: The Short Version 3:35 Part 2: How Lend...
Return on Assets (ROA): Niche Metric or Key Value Driver?
zhlédnutí 1,5KPřed 2 měsíci
Learn more: breakingintowallstreet.com/core-financial-modeling/? In this tutorial, you'll learn about Return on Assets (ROA) for both normal companies and banks and understand what it implies about a firm's valuation. Files & Resources: breakingintowallstreet.com/kb/financial-statement-analysis/return-on-assets-roa/ Table of Contents: 0:00 Introduction 0:50 The Short Answer 3:05 Part 1: ROA Cal...
The Capitalization Table: The Lifeblood (and Deathbed?) of Startups
zhlédnutí 2,8KPřed 2 měsíci
Learn more: breakingintowallstreet.com/venture-capital-modeling/? In this tutorial, you'll learn all about capitalization tables ("cap tables") for startups and venture capital-backed companies, and you'll get simple examples of the most important calculations. Files & Resources: breakingintowallstreet.com/kb/venture-capital/capitalization-table/ Table of Contents: 0:00 Introduction 1:07 Part 1...
Return on Invested Capital (ROIC) in Real Life: Beyond the "Investopedia Version"
zhlédnutí 3,8KPřed 3 měsíci
Learn more: breakingintowallstreet.com/core-financial-modeling/? In this tutorial, you'll learn all about Return on Invested Capital (ROIC) and what it tells you about a company's valuation and your assumptions in financial models. Files & Resources: breakingintowallstreet.com/kb/financial-statement-analysis/roic-return-on-invested-capital/ Table of Contents: 0:00 Introduction 0:52 The Short An...
EBITDA: Corporate Finance Lessons from Tony Soprano
zhlédnutí 3,9KPřed 3 měsíci
In this tutorial, you'll learn what EBITDA means, how to calculate it, and why criticism of EBITDA is both deserved and also a bit misplaced. Files & Resources: breakingintowallstreet.com/kb/accounting/ebitda/ Table of Contents: 0:00 Introduction 4:56 Part 1: How to Calculate EBITDA in More Detail 7:06 Part 2: What Does EBITDA Mean? 8:41 Part 3: Is EBITDA Close to Cash Flow from Operations? 10:...
Paid-In-Kind (PIK) Interest: Full Tutorial for LBO Models
zhlédnutí 3,5KPřed 4 měsíci
Learn more: breakingintowallstreet.com/core-financial-modeling/? In this tutorial, you'll learn about PIK (Paid-in-Kind) Interest in leveraged buyouts and LBO models and how it affects the returns for both the lenders and the equity investors. Files & Resources: breakingintowallstreet.com/kb/leveraged-buyouts-and-lbo-models/pik-interest/ Table of Contents: 0:00 Introduction 4:15 Part 1: PIK vs....
Growth Equity Case Study: Real-Life Example and Tutorial
zhlédnutí 5KPřed 4 měsíci
Learn more: breakingintowallstreet.com/venture-capital-modeling/? In this tutorial, you'll learn about growth equity case studies, get a real-life example, and learn the key differences vs. private equity and venture capital case studies. Files & Resources: mergersandinquisitions.com/growth-equity-case-study/ Table of Contents: 0:00 Introduction 1:16 Part 1: What to Expect in a Growth Equity Ca...
The Cash Conversion Cycle (CCC): The King of the Cash Flow Statement?
zhlédnutí 3,8KPřed 5 měsíci
Learn more: breakingintowallstreet.com/core-financial-modeling/? In this tutorial, you'll learn about the Cash Conversion Cycle in financial statement analysis and understand when it's useful vs. not so useful, and what it means for valuations. Files & Resources: breakingintowallstreet.com/kb/financial-statement-analysis/cash-conversion-cycle/ Table of Contents: 0:00 Introduction 3:49 Part 1: C...
SAFE Notes Explained: "Unsafe" for Startups?
zhlédnutí 2KPřed 5 měsíci
In this tutorial, you'll learn about "SAFE Notes" for investing in startups, how they compare to traditional priced equity rounds, and whether they're actually "unsafe" for startups. Files & Resources: breakingintowallstreet.com/kb/venture-capital/safe-notes/ Table of Contents: 0:00 Introduction 1:54 Part 1: SAFE Notes in a Seed Round 3:26 Part 2: Conversions in the Series A (Caps and Discounts...
Days Sales Outstanding (DSO): What’s the Point in Modeling & Valuation?
zhlédnutí 2KPřed 6 měsíci
Learn more: breakingintowallstreet.com/core-financial-modeling/? Files & Resources for This Video: breakingintowallstreet.com/kb/financial-statement-analysis/days-sales-outstanding-dso/ Table of Contents: 0:00 Introduction 0:48 The Short Answer 2:59 Part 1: Why DSO is "Meh" for Big Companies 5:50 Part 2: Why DSO Can Be More Useful for Startups 9:44 Recap and Summary
Liquidity Ratios: Bankers Living in a Credit Analysts’ Paradise?
zhlédnutí 2,9KPřed 6 měsíci
Liquidity Ratios: Bankers Living in a Credit Analysts’ Paradise?
Annual Recurring Revenue (ARR): The One SaaS Metric to Rule Them All?
zhlédnutí 4,2KPřed 7 měsíci
Annual Recurring Revenue (ARR): The One SaaS Metric to Rule Them All?
Enterprise Value vs. Purchase Price: The “True” Price in an M&A Deal
zhlédnutí 6KPřed 7 měsíci
Enterprise Value vs. Purchase Price: The “True” Price in an M&A Deal
SaaS Accounting (Revised): Bookings, Billings, Revenue, Deferred Revenue, and More
zhlédnutí 4,5KPřed 8 měsíci
SaaS Accounting (Revised): Bookings, Billings, Revenue, Deferred Revenue, and More
The Working Capital Adjustment in M&A Deals and Leveraged Buyouts
zhlédnutí 7KPřed 10 měsíci
The Working Capital Adjustment in M&A Deals and Leveraged Buyouts
The Venture Capital Case Study: What to Expect and How to Survive
zhlédnutí 11KPřed 11 měsíci
The Venture Capital Case Study: What to Expect and How to Survive
Investment Banking PowerPoint Shortcuts: 30-Minute Crash Course
zhlédnutí 11KPřed rokem
Investment Banking PowerPoint Shortcuts: 30-Minute Crash Course
The Dividend Discount Model (DDM): The Black Sheep of Valuation?
zhlédnutí 7KPřed rokem
The Dividend Discount Model (DDM): The Black Sheep of Valuation?
Bank Regulatory Capital and the Tragic Tale of Silicon Valley Bank and Credit Suisse
zhlédnutí 6KPřed rokem
Bank Regulatory Capital and the Tragic Tale of Silicon Valley Bank and Credit Suisse
Macros in PowerPoint: How to Use VBA for a "Swap Multiple Shapes" Macro
zhlédnutí 10KPřed rokem
Macros in PowerPoint: How to Use VBA for a "Swap Multiple Shapes" Macro
Is the Risk-Free Rate Really “Risk-Free”? Why U.S. Treasuries Could Trade Like Meme Stocks
zhlédnutí 3,9KPřed rokem
Is the Risk-Free Rate Really “Risk-Free”? Why U.S. Treasuries Could Trade Like Meme Stocks
The Debt Schedule in 3-Statement Models, LBO Models, and Credit Models
zhlédnutí 29KPřed rokem
The Debt Schedule in 3-Statement Models, LBO Models, and Credit Models
Cash-Free Debt-Free Deals in M&A and LBOs (Version 2.0)
zhlédnutí 13KPřed rokem
Cash-Free Debt-Free Deals in M&A and LBOs (Version 2.0)
3-Statement Model: 90-Minute Case Study from a Blank Excel Sheet
zhlédnutí 136KPřed rokem
3-Statement Model: 90-Minute Case Study from a Blank Excel Sheet
Deferred Taxes in Models and Valuations: Interpretation and Projections
zhlédnutí 11KPřed rokem
Deferred Taxes in Models and Valuations: Interpretation and Projections

Komentáře

  • @user-gw9yk4eu2z
    @user-gw9yk4eu2z Před dnem

    Bro, thank you for the good stuff. cheers!

  • @JonathanHadwen
    @JonathanHadwen Před 2 dny

    where can I find this Excel?

  • @madebyzona
    @madebyzona Před 2 dny

    Thanks for your video! When calculating the tax-deductible interest expense on the P&L, you included the entire interest expense (included the interest you didn't pay, like the PIK), not just the coupons you paid out to debt holders. Is this correct? Is the entire interest expense tax deductible?

    • @madebyzona
      @madebyzona Před 2 dny

      Also, why not include mandatory principal repayments in the interest line in the P&L? Are they not treated the same?

  • @melakukg7354
    @melakukg7354 Před 3 dny

    Thank you.

  • @zenyujin_
    @zenyujin_ Před 4 dny

    Can someone please clear this doubt: when Accounts Receivable increases, why won't the cost of goods sold increase? Accounts Receivable increased due to "extra" sell of a product. So, shouldn't have the costs of goods sold also increased? I cant seem to understand why COGS wont increase!?

    • @financialmodeling
      @financialmodeling Před 3 dny

      In real life, when AR goes up, it means the company has delivered a product/service to the customer, which almost always comes with associated COGS. So you would normally see at least a small increase in COGS. In this artificial example intended for interview questions, we do not walk through that scenario because this is intended to be used for a very simple interview question about AR. We do cover more real-world scenarios with added complexities in the courses and guides.

    • @zenyujin_
      @zenyujin_ Před 3 dny

      @@financialmodeling perfect Thanks!

  • @urielgaribay2880
    @urielgaribay2880 Před 4 dny

    Thank you! Most of the banking videos are usually super long or not detailed enough, so this 15 min vid strikes a great balance!

  • @10xleverage
    @10xleverage Před 5 dny

    Do investors usually prefer to see a negative or positive change in NWC?

    • @financialmodeling
      @financialmodeling Před 4 dny

      A positive Change in WC is always better from a cash flow perspective. There's a video on the Change in Working Capital if you search this channel or look in the accounting playlist.

  • @jatinnawani6075
    @jatinnawani6075 Před 5 dny

    This was great, could you make more complex videos of solving and explaining interview type questions - thanks!

    • @financialmodeling
      @financialmodeling Před 4 dny

      There are some older videos in this channel on common accounting interview questions if you do a search. We may do more in the future.

  • @faizankarim5098
    @faizankarim5098 Před 5 dny

    Awesome, please share a detailed video on the cash flow statement as well. Thanks

  • @saifulisfree
    @saifulisfree Před 5 dny

    If equity proceeds are 1484 why does that not tie to the total return to equity investors? It seems like there’s more money unaccounted for

    • @financialmodeling
      @financialmodeling Před 5 dny

      Total Return to Equity Investors = Exit Equity Proceeds - Equity Contribution = 1484 - 500 = 984.

  • @noldy90
    @noldy90 Před 5 dny

    Excellent👍

  • @tayyab9758
    @tayyab9758 Před 5 dny

    Great video, as always Sir, please create more and more videos

  • @joeblow9284
    @joeblow9284 Před 5 dny

    Can you please address the “creative” side of accounting and how Finance professionals can manage the results without having to micromanage every entry? By “creative” I mean how 10 accountants will have 10 different AJE’s for the same scenario and they will all be acceptable under GAAP.

    • @financialmodeling
      @financialmodeling Před 5 dny

      It's an interesting topic but not really a core focus of this channel or something we know much about. As someone working on deals or advising large companies, you need to understand high-level accounting but not the details down to that level. So our coverage focuses more on the main concepts rather than journal entries (can't imagine a banker ever asking about them in a standard interview).

  • @financialmodeling
    @financialmodeling Před 5 dny

    Files & Resources: breakingintowallstreet.com/kb/accounting/balance-sheet/ Table of Contents: 0:00 Introduction 0:37 The Short Version 5:56 Part 1: Balance Sheet Sample and Example Line Items 7:51 Part 2: Financial Model Projections and Required Links 11:37 Part 3: Why the Balance Sheet is Critical in Interview Questions 13:06 Recap and Summary

  • @PoppAlexander
    @PoppAlexander Před 9 dny

    A common error made in the computation of return on capital is using actual taxes paid in the computation of the after-tax operating income. This will result in a double counting of the tax benefit from debt, once in the return on capital (which will be increased because of the interest tax savings) and again in the cost of capital (which will be reduced the reflect the same tax benefit)

  • @mihail4391
    @mihail4391 Před 11 dny

    Top standard!

  • @TheKruiizy
    @TheKruiizy Před 12 dny

    Would like to hear your input on P5: Would it not be prudent as an interview candidate to ask about the considerations of what "evenly over 3 years" means, as the proper interpretation of discount periods is essential and "evenly" could be considered with a continuous compound in theory. Furthermore, I think it would be necessary to ask the interviewer how much of a "stake" the PE firm retained after the IPO, as it is highly unlikely they maintained 100% stake for a full year post IPO, which calls back into question the sell off distribution. This leads into the last consideration that your solution seems to assume the IPO and sell of runs concurrently with the growth, where it is more practical that this IPO and sell off would take place after the EBITDA growth. The problem then would become more interesting on the needed assumptions of its post IPO growth and consequently equity stake value. Thus leading to differing valued cash flows discounted over the total 6 year transaction life. I love your content and thought Id see if what comes to my mind is too nitpicky or it makes sense I Have an IB analyst interview in 3 weeks Thanks for the great video

    • @financialmodeling
      @financialmodeling Před 12 dny

      I think you may be over-thinking this and worrying about things that will never come up in an IB interview. These types of questions are much more common in PE interviews, to start with. Also, frankly, bankers have gotten dumber over time and are less likely to dig into these types of details (we find that many people at the Associate and VP levels now are fairly clueless). You could certainly ask for clarification on all these points, what "continuously" means, how much of a stake the PE firm retains, and in a real interview setting, you might do that. The goal here was to provide a quick/simple walkthrough of this question with certain assumptions in place.

  • @denyagusman155
    @denyagusman155 Před 13 dny

    You are so great! and many thanks for giving it for free :D

  • @csanton3946
    @csanton3946 Před 13 dny

    In all hinesty this isnit a good practice, it only shows how you treat an investment which is a hot potato. By putting so much leverage and always refinancing, you are effectively putting all the risk to the debt holders or debt investors and you dont care what happens in thr business when business conditions change to the worse because your equity investment due to high returns are already recouped or you are derisked already and any additional income is just a bonus. If the business burns, the one who willabsorb those losses is the debt holders. This is corporate america, milk it to the core. I do not know whydebt holders eould even want to be inthat position of assuming all the risk while your equity partner is enjoying, i guess its because refinancing allows the transfer of risk from previous debtholder to a new debtholder while thepotato is still hot

    • @financialmodeling
      @financialmodeling Před 12 dny

      I am not really sure what your argument, question, or comment is. Refinancing is common in all real estate and other asset-level finance deals. Lenders know the risks they are taking going into the deal based on the LTV, coverage ratios, etc.

  • @alexandralyu836
    @alexandralyu836 Před 16 dny

    Always Useful!!!!

  • @maciekm0007
    @maciekm0007 Před 17 dny

    So generally the bigger NPV the better.

    • @financialmodeling
      @financialmodeling Před 16 dny

      NPV is only relevant for the IRR, not the multiple, so... kind of? Not really sure what you're asking or implying.

    • @maciekm0007
      @maciekm0007 Před 16 dny

      I don’t understand why do you care about multiply. You can have +IRR but -NPV and +multiply. Still you will be losing money.

  • @j8306
    @j8306 Před 17 dny

    Not sure if I miss anything, but for the first part (2:32) the Lease Asset and Lease Liability under finance lease and IFRS operating lease seemed to be reduced at different rate each year Lease Asset reduced by depre while Lease Liab reduced by Principal repayment) But under GAAP both are decliend in the same rate as Depre=principal repayment. But under file at 19:38 in Balance sheet, Why under IFRS16, ROU asset=Operating Lease while it is unequal under GAAP (ROU asset=225 while Operating lease=210) where does 225 and 210 comes from? Thank you

    • @financialmodeling
      @financialmodeling Před 16 dny

      Yes, the lease asset and liability may change at different rates under IFRS vs. U.S. GAAP. This is just how it works for a single lease. Over a huge portfolio of leases, these differences diminish. The 210 vs. 225 are arbitrary and don't correspond to any specific rule. Sometimes the Lease Assets and Liabilities do not equal each other exactly, and sometimes they do or are closer. But what really matters for all these calculations is the Lease Liability number, which is the same for both.

  • @russellfernandez57
    @russellfernandez57 Před 19 dny

    Something to add, it's easy to get an R^2 of 0.99 when you have only 3 data points. If you added in more companies, things could change.

    • @financialmodeling
      @financialmodeling Před 18 dny

      That is true, but even if you expand the set of banks here (not done in the interest of time), R^2 is still quite high (over 0.9). It's higher correlation than pretty much any other operational metric / valuation multiple pairing in any industry.

  • @smholding7
    @smholding7 Před 19 dny

    Hi, What are your thoughts on capitalizing for instanse R&D which affects ebit and profit as a whole like professor Aswath suggests? That would also affect in computing ROE and ROIC. I would love to hear your thoughts on that since I'm trying to learn as much as possible. Thank you!

    • @financialmodeling
      @financialmodeling Před 18 dny

      We tend not to do this because it over-complicates the analysis and doesn't change anything as long as you calculate R&D consistently for all companies in the set. Also, R&D in general is not a major expense for banks, insurance firms, and utility companies, which are the only 3 industries where ROE is important. If you do this, ROE will tend to increase because the R&D amortization in the numerator will be less than the normal annual expense (cash outflow), and the denominator will increase due to higher Equity to balance the R&D Asset on the other side - but usually it's a smaller increase, percentage-wise, than the numerator (but large variance by company/industry).

    • @smholding7
      @smholding7 Před 18 dny

      @@financialmodeling Alright. Thanks very much!

  • @financialmodeling
    @financialmodeling Před 19 dny

    Files & Resources: mergersandinquisitions.com/project-finance-vs-corporate-finance/ Table of Contents: 0:00 Introduction 1:22 Part 1: The 2-Minute Summary 3:47 Part 2: Assets and Legal Structures 4:59 Part 3: Time Frame and Model Structure 6:17 Part 4: Debt Usage and Terminal Value 9:25 Part 5: How the “Deal Math” Works 12:21 Recap and Summary

  • @Ihateteenagerstheyrecringe

    Good stuff. If m starting a company, which which agreement should i use? i will using MRR model

  • @mickiasteklu7216
    @mickiasteklu7216 Před 20 dny

    How do I usually know which market I should use for the Equity risk premium? The S&P wouldn’t be useful for a company operating in Europe right ?

    • @financialmodeling
      @financialmodeling Před 19 dny

      You can find the ERP data for other markets/regions by searching online (see Damodaran's data). Or just use the U.S. data and add a premium for the market you're in.

  • @mickiasteklu7216
    @mickiasteklu7216 Před 21 dnem

    Is this just relevant for US GAAP ?

    • @financialmodeling
      @financialmodeling Před 21 dnem

      No. DTLs are created in deals worldwide because D&A on asset write-ups is not deductible in Stock Purchases (i.e., purchases for 100% of the company, including all assets and liabilities). There may be some exceptions in certain countries, but I don't think any large country does this differently.

  • @learning_with_irving4266

    How did you derive the 100 as the value of the other company

    • @financialmodeling
      @financialmodeling Před 21 dnem

      This is just an example for this video. It's not based on a real company. In real life, we would have to look in the company's filings to get this value.

  • @rodctenis
    @rodctenis Před 22 dny

    Great video. I work with startups and the temptation of SAFEs is still high. I'd say that it is addictive as founders don't realize the consequences of dilution at the time of financing, for many SAFEs equal free money. I am also member of a group of investors and we have an investment policy which excludes investments in SAFEs.

    • @financialmodeling
      @financialmodeling Před 21 dnem

      Yes, this is very true. I think SAFEs are actually worse for investors because of their ambiguity in the capital structure.

    • @rodctenis
      @rodctenis Před 20 dny

      @@financialmodeling You put your money against the possibility to convert it in equity if certain events take place in the future (with no limit of time). In the meantime, you have no rights whatsoever, unless you negotiate side letters and the the simple becomes complex. As an investor, no thanks.

  • @jazzinated
    @jazzinated Před 23 dny

    Thanks so much for the video. This helped answer the question I was struggling with for hours!

  • @parkashmagar8468
    @parkashmagar8468 Před 24 dny

    For which job roles is this course mostly focused on

    • @financialmodeling
      @financialmodeling Před 23 dny

      Please see: mergersandinquisitions.com/breaking-into-wall-street-biws/

  • @6toolbaseball
    @6toolbaseball Před 26 dny

    I like comparing it to the Effective Interest Rate on Debt %

    • @financialmodeling
      @financialmodeling Před 26 dny

      Not really sure how that relates, but sure, I guess. I think there are probably more specific metrics that a bank or insurance company would use for analyzing assets/liabilities.

  • @stanmarsh646
    @stanmarsh646 Před 26 dny

    OMG thank you so much great!!!

  • @SilentCareer
    @SilentCareer Před 26 dny

    have you done the same for ROIC?

  • @financialmodeling
    @financialmodeling Před 26 dny

    Files & Resources: breakingintowallstreet.com/kb/financial-statement-analysis/return-on-equity-roe/ Table of Contents: 0:00 Introduction 4:36 Part 1: Why ROE for Banks and Insurance? 5:35 Part 2: ROE for Banks (JPM, Citi, Wells, and BofA) 7:42 Part 3: ROE for Utilities (MGE Energy) 11:40 Recap and Summary

  • @financialmodeling
    @financialmodeling Před 26 dny

    Files & Resources: breakingintowallstreet.com/kb/valuation/comparable-company-analysis-cca/

  • @vidya014
    @vidya014 Před 26 dny

    How about : Net Income ÷ ( Total asset + Total Liabilities )

    • @financialmodeling
      @financialmodeling Před 26 dny

      It doesn't really make sense conceptually because Total Assets + Total Liabilities does not represent any specific concept or sum to any specific number.

    • @vidya014
      @vidya014 Před 26 dny

      @@financialmodeling the concept is: the lowest contrarian price you can get by multiply it by EPS.

  • @bromaro
    @bromaro Před 27 dny

    What discount rate to use for NOLs, and if one company were to buy another company’s NOLs

    • @financialmodeling
      @financialmodeling Před 26 dny

      There is some debate/disagreement about that, but most people would say WACC if you're valuing an NOL on the basis of future tax savings from it. It would normally be the buyer's WACC in an M&A deal.

    • @bromaro
      @bromaro Před 26 dny

      @@financialmodeling why WACC? I’ve heard people say cost of equity, in between cost of equity and cost of debt, and even the RF rate, but never WACC. Interested to hear your perspective

    • @financialmodeling
      @financialmodeling Před 26 dny

      @@bromaro NOLs benefit all investors, not just equity or debt investors, because their future usage increases cash flows and makes it easier to pay for interest/principal on a cash basis and issue dividends. But they are only useful if the core business continues to perform well, i.e., generate positive Taxable Income that NOLs can offset.

    • @bromaro
      @bromaro Před 26 dny

      @@financialmodeling but even if the core business doesn’t do well, wouldn’t you still be able to sell it off (business shuts down) which would only benefit equity investors

    • @financialmodeling
      @financialmodeling Před 26 dny

      @@bromaro If a company sells the entire company, the value of the NOLs will only benefit the shareholders because the lenders just get back their owed principal. But the key question is who benefits from the NOLs while the company is operating as it normally does. You don't normally look at a shutdown scenario to decide on the proper discount rate. And note that NOLs may actually be written down completely in some deals, depending on the structure (especially in asset sales).

  • @MA-yz7ef
    @MA-yz7ef Před 27 dny

    Can you please share the excel template?

  • @LucasLopes-yz6ks
    @LucasLopes-yz6ks Před 29 dny

    Can you explain how it was possible to simulate 50% equity and 50% debt with the EBITDA/debt multiple? it wasn't clear please, tomorrow I have an interview

    • @financialmodeling
      @financialmodeling Před 26 dny

      I do not understand your question. EBITDA / Debt is not a valuation multiple; Debt / EBITDA is the metric, and it's a credit stat, not a valuation multiple. But I'm really not sure what you mean by "simulate 50% equity and 50% debt" because EBITDA never reflects the debt/equity split, as it is capital structure-neutral.

  • @nathanielmontero9444
    @nathanielmontero9444 Před 29 dny

    Hey Brian, this is great work. Thanks for sharing! I was wondering if you could help me figure out the stock value of the NOLs that Contexlogic has (2.7 billion). I am having trouble trying to determine the true value of the NOL, can you help out?

    • @financialmodeling
      @financialmodeling Před 26 dny

      Sorry, but we don't offer 1-on-1 help for company analysis in these CZcams comments. Happy to review Excel files, filings, or your own work and provide feedback if you have previously purchased a course or coaching service.

  • @ericgregorious7047
    @ericgregorious7047 Před měsícem

    Can u get around circular reference. For me personally I calculate revolver based on beginning instead of average...

    • @financialmodeling
      @financialmodeling Před 29 dny

      Yes, just use the beginning balances for fees and interest. Circular references are easy to avoid in standard company models with Debt that's based on a multiple of EBITDA.

  • @rodctenis
    @rodctenis Před měsícem

    It's important to consider transaction costs, SAFE are cheaper (although some law firms still charge expensive fees) thant convertible notes, and much cheaper than a traditional equity round. When startups rise small amounts legal expenses become relevant in deciding the investment vehicle.

    • @financialmodeling
      @financialmodeling Před měsícem

      I don't think SAFE Notes are that much cheaper than traditional equity rounds anymore if you use one of the many template/standardized agreements online. Yes, startups might still save money, but the disadvantages later on may not be worth it. There might be more savings if the priced equity round requires complex / drawn-out negotiation and the SAFE does not.

    • @rodctenis
      @rodctenis Před měsícem

      @@financialmodeling I can tell you from experience, much cheaper, basically because the limited involvement of lawyers. Even using templates, for an equity round you will need lawyers involved substantially in the process as you are modifying your legal corporate structure, SAFE don't do that, not at the time of the issuance, the real total cost of SAFEs is basically postponed to the time of conversion. The advantage is that at conversion time, against a larger financing it is easier to absorb the cost of legal fees. In other words, probably the final cost is quite similar, but the difference is the financial position at which the company must afford them.

  • @financialmodeling
    @financialmodeling Před měsícem

    Files & Resources: breakingintowallstreet.com/kb/venture-capital/convertible-notes/ Table of Contents: 0:00 Introduction 5:19 Part 1: Convertible Notes in a Seed Round 6:01 Part 2: Conversions in the Series A with an Options Pool 10:47 Dollars Invested Method 11:41 Part 3: Side-by-Side: Convertible Note vs. SAFE 12:35 Part 4: Should a Startup Use Either One of These? 13:32 Recap and Summary

  • @jesusalbertoperezdet3771
    @jesusalbertoperezdet3771 Před měsícem

    Thanks for the video, I just have one question. When using the short method all I have to do is take de NOL directly from the DTA breakdown and multiply it by the tax rate (that's how you came out with the 61.1) correct?. This number (61.1) should be the same when doing the long approach and calculate the value of Annual tax savings? thanks

    • @financialmodeling
      @financialmodeling Před měsícem

      The DTA already lists the total amount * the tax rate (roughly). So you don't multiply by the tax rate again. You can just use the amount in the DTA in the bridge directly. It should roughly equal the expected tax savings over time if you model it out, but won't always be the same due to expirations, tax rate changes, etc.

    • @jesusalbertoperezdet3771
      @jesusalbertoperezdet3771 Před 18 dny

      @@financialmodeling I understand, thank you. another question. when doing DCF valuation, what is the correct treatment for DTA and DTL shown in the balance sheet? or is DTA already included when we calculate NOLs? but how about DTL?

    • @financialmodeling
      @financialmodeling Před 17 dny

      @@jesusalbertoperezdet3771 The DTA and DTL do not factor into the analysis directly, only the NOLs do. Either count the NOLs in the Cash Tax calculation directly in the DCF or include the total NOL balance as a bridge item when calculating Implied Equity Value at the end.

  • @sgdsuy
    @sgdsuy Před měsícem

    Hey guys, I have a really basic question. How do you get Q4 data if a company only releases 3 10-Qs followed by a 10-K? Do I need to manually subtract the 10-K figures from the YTD 9 month figures in the Q3 10-Q?

    • @financialmodeling
      @financialmodeling Před měsícem

      Yes, but you do the opposite and take the annual numbers and subtract the 9-month figures to get the Q4 numbers.

  • @MakingaStink
    @MakingaStink Před měsícem

    On one of these more simple tests, would you ever have to do something like limitations on interest expense (30% of EBIT)?

    • @financialmodeling
      @financialmodeling Před měsícem

      Probably not, especially since it's specific to certain regions and not a global rule.

  • @flaviohns1
    @flaviohns1 Před měsícem

    Got an interview question about company A acquiring company B, that has just distributed dividends and how the equity post deal is affected by that. Told that the Equity Value post deal would be the equity value of company A minus dividends, this is correct, and if so why ?

    • @financialmodeling
      @financialmodeling Před měsícem

      Dividends reduce Equity Value, so yes. See the videos on Equity Value and Enterprise Value and how they change after specific events.

    • @flaviohns1
      @flaviohns1 Před měsícem

      @@financialmodeling I Will see It. But i still have a doubt, if the company's B shareholder value gets vanished in the deal and only Company's A Equity stay after the acquisition, the equity value post acquisiton should only be Company's A Equity, because dividends affects only Company's B Equity that gets vanished anyway

    • @financialmodeling
      @financialmodeling Před měsícem

      @@flaviohns1 Company B no longer exists as a standalone entity, but its Equity Value does not exactly "disappear" - it simply becomes a part of the acquirer's Equity Value or Enterprise Value. For example, if the acquirer issues stock to do the deal, now its Equity Value increases to reflect the equity purchase price they just paid for Company B. Of course this may change if the market reacts negatively to the news and doesn't like the price, deal terms, etc., but this is the initial assumption.

    • @flaviohns1
      @flaviohns1 Před měsícem

      @@financialmodeling So in this case Equity post Deal = Equity from Company A - Dividends issued by Company B + issued Stocks from Company A

  • @adamdedelva352
    @adamdedelva352 Před měsícem

    Best description I’ve seen, out there. Thank you.