Пікірлер
@joeblow9284
@joeblow9284 51 минут бұрын
After 10 years in Finance, I’ve learned that accounting is the tool that poor performing companies use to make themselves look good. It’s completely arbitrary. The only reason to learn accounting is to find out what a company is hiding. There’s such a huge difference between financials and cash flow based on bank accounts, that financial reporting by accrual accounting is virtually useless.
@financialmodeling
@financialmodeling 7 сағат бұрын
Files & Resources: breakingintowallstreet.com/kb/accounting/income-statement/ Table of Contents: 0:00 Introduction 0:39 The Short Version 5:43 Part 1: More Advanced Line Items 7:24 Part 2: Why Does Item X Appear on the IS? 9:50 Part 3: Income Statement Forecasting 11:46 Part 4: The Income Statement in Interviews 14:10 Recap and Summary
@quintondouse7237
@quintondouse7237 2 күн бұрын
Hey Brian, hope you are doing well. I have a question for you regarding the specific multiple that should be used for valuing a private company in an LBO scenario. If you're tasked with finding the entry multiple to pay for LTM EBITDA for a private company and you're given an output of comps (trading or precedents), should you always use the median multiple?
@financialmodeling
@financialmodeling 7 сағат бұрын
You could use higher or lower multiples (e.g., 25th or 75th percentile) if the company is performing better/worse than the median of the set. But you would need some pretty good justification for this because most people just expect to see the median used.
@minakh4814
@minakh4814 2 күн бұрын
What is the difference between book value and market value in Equity Value?
@financialmodeling
@financialmodeling 7 сағат бұрын
Book Value is Common Shareholders' Equity on the Balance Sheet. Market Value of Equity is the company's market cap or Share Price * Shares Outstanding, which is usually much higher because the market value of most companies' Assets - Liabilities far exceeds the historical numbers shown on the Balance Sheet.
@ursdipanshu
@ursdipanshu 4 күн бұрын
Can you please send me the solved excel file
@financialmodeling
@financialmodeling 7 сағат бұрын
Please follow the links in the video description.
@stanleylozinski6431
@stanleylozinski6431 5 күн бұрын
why do we NEED to accelerate the amortization of OID, and if it benefits the bottom line can you just do the whole thing? thank you in advance\
@financialmodeling
@financialmodeling 7 сағат бұрын
OID amortization should, in theory, be straight-line, but if there are early/optional principal repayments, it will be accelerated in proportion to those repayments. None of this really matters in models because OID amortization is non-cash and barely affects the taxes. So in practice, most people just simplify and assume straight-line amortization if it is required at all.
@gaurav2019
@gaurav2019 8 күн бұрын
Can you explain when the concept of EO comes into play in bargain purchase? I recently came across a bargain purchase transaction in my firm where a hospital was acquired at less than its book and fair value of assets. My manager’s view was that this is a case of EO, so we had the fixed assets (FA) of the target revalued at their post EO values which basically meant that the capital asset team revalued the FA to such a number where the total of FA + NWC reconciled with the purchase price paid (BEV) for the target. In short, we recorded zero goodwill and no intangibles while reducing the FA numbers. But I’m confused whether this method is correct or not and how the acquirer would actually record this in its books because we didn’t show any gain on bargain purchase in our valuation report. Thanks!
@financialmodeling
@financialmodeling 7 сағат бұрын
Sorry, not familiar with the topic, so I don't have an answer for you on that one.
@ashankar
@ashankar 8 күн бұрын
Thank you the video. You mention that SaaS cos often have positive change in NWC. But is not also the case that they have a negative WC dynamic (low inventory, high deferred revenue etc.).? As revenue grows would you not expect the change in NWC to also be negative?
@financialmodeling
@financialmodeling 7 сағат бұрын
Working Capital and the Change in Working Capital are different. Working Capital can be positive or negative, and the Change can also be positive or negative. If a SaaS company's current/operating liabilities are growing by more than its current/operating assets, the Change in WC could easily be positive even if WC itself is negative.
@LoveStudio3388
@LoveStudio3388 11 күн бұрын
What happens if dividend income received is already greater than the investment account. How to account for the excess?
@financialmodeling
@financialmodeling 10 күн бұрын
Equity Investments would turn negative in this case if the associated Dividends exceed the entire amount on the Balance Sheet and there is no corresponding Net Income to boost the line item. It doesn't mean much because the book values of many Balance Sheet items could be negative, even if the market values are not.
@LoveStudio3388
@LoveStudio3388 10 күн бұрын
@@financialmodeling i actually found the answer. The standard doesnt say much of “dividends in excess of the carrying amount of investment” if there is no obligation to make additional investment, the excess is recorded in profit or loss as regular dividend income
@saifulisfree
@saifulisfree 11 күн бұрын
I got this question recently never intuitively understood the answer. LBO companies look for targets with large excess cash balances because it lowers the cost of acquisition. I get acquiring it grants you access to the cash but it seems like a wash at best and more expensive at worst. For example an extra $10M of cash on balance sheet you would need to finance through equity or debt. All equity would be a wash dollar for dollar and all debt would be more expensive than the cash cause of interest. How do you make heads or tails of this?
@financialmodeling
@financialmodeling 10 күн бұрын
That is not really a key attribute that PE firms look for because Excess Cash does not really "do" anything - if the company distributes it, yes, its Equity Value goes down, but if the company keeps it, the PE firm can then take the Excess Cash for itself. So either way, the effective price is the same. But Excess Cash itself is not inherently good or bad - what matters is what the company's core business is worth and how that might change (i.e., the Enterprise Value). An interviewer asking this question or making this claim doesn't understand LBOs.
@saifulisfree
@saifulisfree 11 күн бұрын
Question on interest expense if it increases by $10 is there a difference if it’s paid in cash? how does it flow? Like this?: income statement down 10, cash flow statement net income down 10 and then cash flow overall down by $10, balance sheet: cash and retained earnings both down by 10. I guess round about way of asking is there an additional impact of $10 on cash from financing activity if it’s paid in cash on top of the $10 hit to net income?
@financialmodeling
@financialmodeling 10 күн бұрын
You are ignoring taxes, but that is otherwise correct. There is no additional impact in CFF if you record the Interest as a deduction on the IS and make it reduce Net Income.
@johnfoo8400
@johnfoo8400 13 күн бұрын
V useful
@financialmodeling
@financialmodeling 13 күн бұрын
Thanks for watching!
@user-rc7qn9lj9h
@user-rc7qn9lj9h 14 күн бұрын
Awesome ❤
@financialmodeling
@financialmodeling 13 күн бұрын
Thanks for watching!
@ksenianesterenko4
@ksenianesterenko4 14 күн бұрын
Why are we getting avarage in 2 years and after calculating only 1?
@financialmodeling
@financialmodeling 13 күн бұрын
I'm not quite sure what you mean. We almost always look at the average Balance Sheet metrics because in the CCC calculation, we are comparing Balance Sheet line items to Income Statement metrics such as Revenue and COGS, which correspond to a period of time. We can't compare a snapshot-in-time metric (AR, AP, Inventory, etc.) to a "period of time" metric like Revenue, so the normal approach is to use the average for the Balance Sheet metrics.
@financialmodeling
@financialmodeling 14 күн бұрын
Files & Resources: breakingintowallstreet.com/kb/project-finance/debt-sculpting-vs-debt-sizing/ Table of Contents: 0:00 Introduction 1:09 Part 1: The TL;DW of Debt Sculpting and Sizing 3:07 Part 2: Simple Debt Sculpting Example 4:49 Part 3: DSCR-Based Debt Sizing 7:10 Part 4: LLCR-Based Debt Sizing 9:25 Part 5: VBA to Automate Debt Sizing and Avoid Circ Ref’s 17:24 Recap and Summary
@fatemeazizi1863
@fatemeazizi1863 15 күн бұрын
Why is understanding the total debt and market cap crucial in EBITDA?
@financialmodeling
@financialmodeling 15 күн бұрын
Not sure I understand your question. EBITDA is independent of capital structure and corresponds to all the investors in the company. Market Cap and Total Debt only matter in terms of the valuation multiples based on EBITDA, EBIT, and related metrics and making sure that the numerator and denominator are consistent.
@ShannonCatalano-h7r
@ShannonCatalano-h7r 16 күн бұрын
Thanks for the content! Super helpful. When you say discount rate, are you referring to the average discount from list? Or cost of capital?
@financialmodeling
@financialmodeling 15 күн бұрын
The Cost of Capital or WACC, which changes based on the company's stage and maturity.
@saifulisfree
@saifulisfree 16 күн бұрын
1) If the earn out if pegged for year 5 do you adjust the income statement and the corresponding entry cash flow from ops section every year 2) if it’s paid out in year 5 you see a cash flow from financing impact but will there be a cash flow from operations impact that year as well?
@financialmodeling
@financialmodeling 15 күн бұрын
If it's a 5-year earnout, yes, potentially there could be an adjustment on the statements every single year between Year 1 and Year 5. But there could also be nothing if the payout probability does not change in that year. If there is a payout in Year 5, it should appear within Cash Flow from Financing, not Cash Flow from Operations.
@ro5252
@ro5252 17 күн бұрын
Hello hello, thank you very much for your video. You provide crazy value! I bought your courses and they are super great 👍🏼 Any chance you could prepare a deep and detailed valuation of Qurate Retail (QRTEA). I think it would provide tremendous value for the community!!
@AlexKwong-q7k
@AlexKwong-q7k 19 күн бұрын
how do you calculate the purchase price per share of either alfheim capital or asgard capital using both a conversion discount rate and a valuation cap? For example, if we look at Asgard Capital, would it be the valuation cap (10,000,000) divided by the total shares in the post-seed round table (1,333,333) multiplied by a given conversion rate (for example, 20%)? It would look like (10,000,000/1,333,333)*0.8 Does this work or did i get it completely wrong?
@financialmodeling
@financialmodeling 15 күн бұрын
If there's both a conversion discount and a valuation cap, you calculate the share price under both methods and then take whichever one is lower, as the lower price is better for the investors. So in this example, if these firms were a single investor, we would just use the $6.00 share price from the 20% conversion discount since that's a better deal than the $7.50 share price from the valuation cap.
@Retumn98716
@Retumn98716 21 күн бұрын
great video. is most of this informatoin still up to date (I am europe based) ?
@financialmodeling
@financialmodeling 15 күн бұрын
Lease accounting has not changed since IFRS 16 went into effect in 2019.
@ibadrehman5305
@ibadrehman5305 21 күн бұрын
goat shit
@financialmodeling
@financialmodeling 15 күн бұрын
Thanks for watching!
@JFCotman
@JFCotman 21 күн бұрын
Hideous! I thought they were going to color code the columns and cells Color coding the numbers only looks tacky 😩
@financialmodeling
@financialmodeling 15 күн бұрын
This is a very old video from 10+ years ago. Not even sure why it's still listed here. Suffice to say that we now use different formatting in spreadsheets.
@JFCotman
@JFCotman 15 күн бұрын
@@financialmodeling sweet! 👌🏽
@Jack-w4t
@Jack-w4t 23 күн бұрын
This one video beats WSP's ENTIRE course. Definitely going to purchase the whole thing from you guys. Great video.
@financialmodeling
@financialmodeling 15 күн бұрын
Thanks for watching!
@wahidalishah2785
@wahidalishah2785 25 күн бұрын
useful video
@financialmodeling
@financialmodeling 25 күн бұрын
Thanks for watching!
@wahidalishah2785
@wahidalishah2785 25 күн бұрын
thanks for your detailed explanation of the M&A
@financialmodeling
@financialmodeling 25 күн бұрын
Thanks for watching!
@markgonzalez85
@markgonzalez85 25 күн бұрын
Great content. Really well done. Balances accuracy, speed and function.
@financialmodeling
@financialmodeling 25 күн бұрын
Thanks for watching!
@kevinblack6721
@kevinblack6721 25 күн бұрын
How can the ROU asset and liability not balance? What am I missing here?
@financialmodeling
@financialmodeling 25 күн бұрын
They don't necessarily equal each other because of different start and end dates for leases and the way items like termination fees, sign-up fees, and other fees outside of lease payments are recorded.
@Latin_American_Economic
@Latin_American_Economic 25 күн бұрын
The revenue growth rate was in line with what I seen in SaaS firms pre-revenue to pre-IPO covering the venture debt space. Pretty spot on about how SaaS metrics are used to analysis firms. Generally speaking, we use many of those things mentioned to figure out whether something is right, if not, we use it to figure where to start looking at.
@financialmodeling
@financialmodeling 15 күн бұрын
Thanks for watching!
@xhesitase9729
@xhesitase9729 26 күн бұрын
Great Video. Thanks Brian!
@financialmodeling
@financialmodeling 26 күн бұрын
Thanks for watching!
@xhesitase9729
@xhesitase9729 26 күн бұрын
Thanks Bryan. Love it when you post.
@financialmodeling
@financialmodeling 26 күн бұрын
Thanks for watching!
@wahidalishah2785
@wahidalishah2785 27 күн бұрын
great content
@financialmodeling
@financialmodeling 26 күн бұрын
Thanks for watching!
@ytube9118
@ytube9118 28 күн бұрын
Why don't we integrate the 2% ($24m) advisory & management fees? I assumed that I should at least subtract that figure our return calculation (from the Equity Value). Thank you very much!
@financialmodeling
@financialmodeling 27 күн бұрын
The Investor Equity is higher due to these fees, so it is reflected in the model. Delete the fees, and the Investor Equity in D20 goes down, so the IRR and multiple increase.
@ytube9118
@ytube9118 28 күн бұрын
Why is the CapEx (factory maintenance expense) based on last year's number of factories and not the number of factories we have this year? Thank you very much
@financialmodeling
@financialmodeling 28 күн бұрын
Maintenance CapEx relates to existing factories that have been operating for at least a year. New factories constructed in the current year do not yet need maintenance.
@ytube9118
@ytube9118 28 күн бұрын
@@financialmodeling That makes sense, thank you
@financialmodeling
@financialmodeling 28 күн бұрын
Files & Resources: breakingintowallstreet.com/kb/venture-capital/rule-of-40/ Table of Contents: 0:00 Introduction 1:14 The Rule of 40 in a Nutshell 3:58 Part 1: How to Calculate the Rule of 40 7:27 Part 2: Valuation Implications 9:09 Part 3: The Rule of 40 as an Operational Metric 10:25 Part 4: The Rule of X and Other Variations/Improvements 11:42 Recap and Summary
@jesusalbertoperezdet3771
@jesusalbertoperezdet3771 28 күн бұрын
sorry i´m confused. in your webpage you mention that a you can also create a Net DTA (DTL-DTA). Does that play when calculating Enterprise Value (subtracting or adding)? also, inside DTA you find NOL, in order not to double count, should I consider Net DTA without NOL, and treat NOL at the end considering it a non-operating asset? thanks
@financialmodeling
@financialmodeling 28 күн бұрын
DTAs and DTLs do not factor into Enterprise Value directly. Only the NOL component of DTAs does. The Net DTA is created as a way to simplify the projections and linking of the statements.
@jesusalbertoperezdet3771
@jesusalbertoperezdet3771 28 күн бұрын
@@financialmodeling ok so DTA and DTL are treated as non recurring?
@financialmodeling
@financialmodeling 27 күн бұрын
@@jesusalbertoperezdet3771 You are mixing up different concepts. Balance Sheet line items cannot be "non-recurring," only IS and CFS line items are recurring or non-recurring. The DTA and DTL are treated as core-business assets/liabilities except for the NOL portion of the DTA, so they are not adjusted for in Enterprise Value except for the NOLs.
@jesusalbertoperezdet3771
@jesusalbertoperezdet3771 12 күн бұрын
@@financialmodeling mmm, so you just simply ignore the amounts of DTA and DTL in the BS when calculating DCF?
@financialmodeling
@financialmodeling 10 күн бұрын
@@jesusalbertoperezdet3771 In a DCF, all that matters are the company *cash flows* in each period. DTAs and DTLs matter to the extent that they affect cash flows by changing the company's Cash Taxes in each period. But in general, for a quick analysis, the Deferred Tax assumption and line on the CFS is more important than these Balance Sheet line items.
@user-sn2gf8ne2i
@user-sn2gf8ne2i Ай бұрын
Sir, Do banks have working capital? How does the concept of Working Capital apply to a bank? Is the Liquidity Coverage Ratio (LCR) the same as Current Ratio/Working Capital Ratio? It is difficult to calculate the working capital of a bank because a bank's balance sheet does not include typical current assets and liabilities.
@financialmodeling
@financialmodeling Ай бұрын
Banks have Working Capital, but it's not something you look at or pay much attention to in analyses. The Liquidity Coverage Ratio is completely different and deals with the bank's liquid assets vs. the possible cash outflows in a "stressed" period, and it's calculated based on different assumptions and metrics. Working Capital does not factor in.
@AishaAlbinali
@AishaAlbinali Ай бұрын
Can it used in a nonprofit semi government medical organization?
@financialmodeling
@financialmodeling Ай бұрын
I'm not sure I understand your question. Non-profit accounting has some differences, but the principles here for SaaS and subscription models still apply.
@LuisFranciscoZaldivar
@LuisFranciscoZaldivar Ай бұрын
Great teaching and video Brian
@financialmodeling
@financialmodeling Ай бұрын
Thanks for watching!
@saifulisfree
@saifulisfree Ай бұрын
Hey Brian thanks for the video. I checked for the file and didn’t see it on the site. Kindly can you provide and updated link?
@financialmodeling
@financialmodeling Ай бұрын
This one is not available because it uses an old version of the model. We may eventually create a new one.
@user-gw9yk4eu2z
@user-gw9yk4eu2z Ай бұрын
Bro, thank you for the good stuff. cheers!
@financialmodeling
@financialmodeling Ай бұрын
Thanks for watching!
@JonathanHadwen
@JonathanHadwen Ай бұрын
where can I find this Excel?
@financialmodeling
@financialmodeling Ай бұрын
Click "More" or "Show More" and scroll to the links at the bottom.
@madebyzona
@madebyzona Ай бұрын
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 Ай бұрын
Also, why not include mandatory principal repayments in the interest line in the P&L? Are they not treated the same?
@financialmodeling
@financialmodeling Ай бұрын
For LBO model purposes, the entire interest expense, including both Cash and PIK Interest, is tax-deductible unless otherwise specified. There are some special cases where this is not true, and some regions limit the % of Interest that is tax-deductible, but in a 60-minute case study, you can't really think about these points. See the PIK Interest tutorial for more.
@financialmodeling
@financialmodeling Ай бұрын
Debt principal repayments are never tax-deductible in any region or industry. They appear on the Cash Flow Statement and are not a tax deduction because they represent the simple repayment of borrowed capital, not the expenses of using that capital over time.
@melakukg7354
@melakukg7354 Ай бұрын
Thank you.
@financialmodeling
@financialmodeling Ай бұрын
Thanks for watching!
@zenyujin_
@zenyujin_ Ай бұрын
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 Ай бұрын
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_ Ай бұрын
@@financialmodeling perfect Thanks!
@urielgaribay2880
@urielgaribay2880 Ай бұрын
Thank you! Most of the banking videos are usually super long or not detailed enough, so this 15 min vid strikes a great balance!
@financialmodeling
@financialmodeling Ай бұрын
Thanks for watching!
@10xleverage
@10xleverage Ай бұрын
Do investors usually prefer to see a negative or positive change in NWC?
@financialmodeling
@financialmodeling Ай бұрын
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 Ай бұрын
This was great, could you make more complex videos of solving and explaining interview type questions - thanks!
@financialmodeling
@financialmodeling Ай бұрын
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 Ай бұрын
Awesome, please share a detailed video on the cash flow statement as well. Thanks
@financialmodeling
@financialmodeling Ай бұрын
Thanks. We will cover the other statements soon.
@saifulisfree
@saifulisfree Ай бұрын
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 Ай бұрын
Total Return to Equity Investors = Exit Equity Proceeds - Equity Contribution = 1484 - 500 = 984.