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.
@financialmodeling7 сағат бұрын
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
@quintondouse72372 күн бұрын
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?
@financialmodeling7 сағат бұрын
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.
@minakh48142 күн бұрын
What is the difference between book value and market value in Equity Value?
@financialmodeling7 сағат бұрын
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.
@ursdipanshu4 күн бұрын
Can you please send me the solved excel file
@financialmodeling7 сағат бұрын
Please follow the links in the video description.
@stanleylozinski64315 күн бұрын
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\
@financialmodeling7 сағат бұрын
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.
@gaurav20198 күн бұрын
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!
@financialmodeling7 сағат бұрын
Sorry, not familiar with the topic, so I don't have an answer for you on that one.
@ashankar8 күн бұрын
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?
@financialmodeling7 сағат бұрын
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.
@LoveStudio338811 күн бұрын
What happens if dividend income received is already greater than the investment account. How to account for the excess?
@financialmodeling10 күн бұрын
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.
@LoveStudio338810 күн бұрын
@@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
@saifulisfree11 күн бұрын
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?
@financialmodeling10 күн бұрын
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.
@saifulisfree11 күн бұрын
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?
@financialmodeling10 күн бұрын
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.
@johnfoo840013 күн бұрын
V useful
@financialmodeling13 күн бұрын
Thanks for watching!
@user-rc7qn9lj9h14 күн бұрын
Awesome ❤
@financialmodeling13 күн бұрын
Thanks for watching!
@ksenianesterenko414 күн бұрын
Why are we getting avarage in 2 years and after calculating only 1?
@financialmodeling13 күн бұрын
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.
@financialmodeling14 күн бұрын
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
@fatemeazizi186315 күн бұрын
Why is understanding the total debt and market cap crucial in EBITDA?
@financialmodeling15 күн бұрын
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-h7r16 күн бұрын
Thanks for the content! Super helpful. When you say discount rate, are you referring to the average discount from list? Or cost of capital?
@financialmodeling15 күн бұрын
The Cost of Capital or WACC, which changes based on the company's stage and maturity.
@saifulisfree16 күн бұрын
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?
@financialmodeling15 күн бұрын
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.
@ro525217 күн бұрын
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-q7k19 күн бұрын
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?
@financialmodeling15 күн бұрын
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.
@Retumn9871621 күн бұрын
great video. is most of this informatoin still up to date (I am europe based) ?
@financialmodeling15 күн бұрын
Lease accounting has not changed since IFRS 16 went into effect in 2019.
@ibadrehman530521 күн бұрын
goat shit
@financialmodeling15 күн бұрын
Thanks for watching!
@JFCotman21 күн бұрын
Hideous! I thought they were going to color code the columns and cells Color coding the numbers only looks tacky 😩
@financialmodeling15 күн бұрын
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.
@JFCotman15 күн бұрын
@@financialmodeling sweet! 👌🏽
@Jack-w4t23 күн бұрын
This one video beats WSP's ENTIRE course. Definitely going to purchase the whole thing from you guys. Great video.
@financialmodeling15 күн бұрын
Thanks for watching!
@wahidalishah278525 күн бұрын
useful video
@financialmodeling25 күн бұрын
Thanks for watching!
@wahidalishah278525 күн бұрын
thanks for your detailed explanation of the M&A
@financialmodeling25 күн бұрын
Thanks for watching!
@markgonzalez8525 күн бұрын
Great content. Really well done. Balances accuracy, speed and function.
@financialmodeling25 күн бұрын
Thanks for watching!
@kevinblack672125 күн бұрын
How can the ROU asset and liability not balance? What am I missing here?
@financialmodeling25 күн бұрын
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_Economic25 күн бұрын
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.
@financialmodeling15 күн бұрын
Thanks for watching!
@xhesitase972926 күн бұрын
Great Video. Thanks Brian!
@financialmodeling26 күн бұрын
Thanks for watching!
@xhesitase972926 күн бұрын
Thanks Bryan. Love it when you post.
@financialmodeling26 күн бұрын
Thanks for watching!
@wahidalishah278527 күн бұрын
great content
@financialmodeling26 күн бұрын
Thanks for watching!
@ytube911828 күн бұрын
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!
@financialmodeling27 күн бұрын
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.
@ytube911828 күн бұрын
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
@financialmodeling28 күн бұрын
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.
@ytube911828 күн бұрын
@@financialmodeling That makes sense, thank you
@financialmodeling28 күн бұрын
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
@jesusalbertoperezdet377128 күн бұрын
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
@financialmodeling28 күн бұрын
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.
@jesusalbertoperezdet377128 күн бұрын
@@financialmodeling ok so DTA and DTL are treated as non recurring?
@financialmodeling27 күн бұрын
@@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.
@jesusalbertoperezdet377112 күн бұрын
@@financialmodeling mmm, so you just simply ignore the amounts of DTA and DTL in the BS when calculating DCF?
@financialmodeling10 күн бұрын
@@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Ай бұрын
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Ай бұрын
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Ай бұрын
Can it used in a nonprofit semi government medical organization?
@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Ай бұрын
Great teaching and video Brian
@financialmodelingАй бұрын
Thanks for watching!
@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Ай бұрын
This one is not available because it uses an old version of the model. We may eventually create a new one.
@user-gw9yk4eu2zАй бұрын
Bro, thank you for the good stuff. cheers!
@financialmodelingАй бұрын
Thanks for watching!
@JonathanHadwenАй бұрын
where can I find this Excel?
@financialmodelingАй бұрын
Click "More" or "Show More" and scroll to the links at the bottom.
@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Ай бұрын
Also, why not include mandatory principal repayments in the interest line in the P&L? Are they not treated the same?
@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Ай бұрын
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Ай бұрын
Thank you.
@financialmodelingАй бұрын
Thanks for watching!
@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Ай бұрын
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_Ай бұрын
@@financialmodeling perfect Thanks!
@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Ай бұрын
Thanks for watching!
@10xleverageАй бұрын
Do investors usually prefer to see a negative or positive change in NWC?
@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Ай бұрын
This was great, could you make more complex videos of solving and explaining interview type questions - thanks!
@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Ай бұрын
Awesome, please share a detailed video on the cash flow statement as well. Thanks
@financialmodelingАй бұрын
Thanks. We will cover the other statements soon.
@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Ай бұрын
Total Return to Equity Investors = Exit Equity Proceeds - Equity Contribution = 1484 - 500 = 984.