Perfect video to refresh my memory before an interview
@financialmodeling Жыл бұрын
Thanks for watching!
@nhdhruva4 жыл бұрын
Great vid! I just had a question for clarification purposes. In regards to the question where "A company issues $100 of stock and $100 of debt to purchase $100 of PP&E and $100 of Investments," the reason Equity Value is going up is because of the $100 worth of stock being issued, and Enterprise Value also goes up because PP&E (An operating asset), went up so that means Enterprise Value also changes and gets higher.
@financialmodeling4 жыл бұрын
Yes, that's correct.
@A_d_r_i_a_n_194 жыл бұрын
Mergers & Inquisitions / Breaking Into Wall Street wouldn’t the TEV change be due to debt +100? Am I missing something in EV + net debt?
@financialmodeling4 жыл бұрын
@@A_d_r_i_a_n_19 That's not the best way to think about it because Enterprise Value does not depend on the company's capital structure. These questions will be 10x easier if you think about whether or not Net Operating Assets changes to determine the change in Enterprise Value.
@alyelhalwany33694 жыл бұрын
I appreciate and respect your enthusiasm and way of explanation, I really would like also to thank you!!
@financialmodeling4 жыл бұрын
Thanks for watching!
@fitnnut901510 ай бұрын
in question 4 where you increased $ 100 of Stock and $ 100 of Debt to purchase $ 100 of PPE and $100 of Investment but the change in Enterprise value is $ 100 dollar because of the increase in PP&E but while calculating Enterprise value we also add the total debt and change in operating assets and deduct cash and cash equivalents, so if we go by that equation to calculate the change in enterprise value then it would be like this: Equity - increases by $100 Debt - increases by $100 Cash and Cash Equivalent - stays the same as cash is used to buy assets PP&E - increased by $100 Investment - increased by $100 so the Change in Equity value would be = $100(increase in equity)+$200(increase in cash)-$100(investments & pp&E) = $ 100. And Enterprise value = $100 (Equity value) - $ 100 (increase in operating Expense) + $100 (increase in Debt) = $100 Please correct me if i am wrong
@financialmodeling10 ай бұрын
You could do it that way, but it's longer and more complicated, which means there's more room for error in an interview. Also, your walkthrough is not quite correct because if you want to view it like that, you should calculate the change in *Net Assets* for Equity Value. They increase by $200 - $100, since the PP&E + Investments go up by $200 and the Debt on the L&E side goes up by $100, making it a $100 increase in Net Assets. And with the Enterprise Value formula, Equity Value is up by $100, but Cash/Investments are up by $100, and Debt is up by $100, so these changes cancel out and Enterprise Value is simply up by $100.
@sonerguney3225 Жыл бұрын
Very good. Well done
@financialmodeling Жыл бұрын
Thanks for watching!
@georgiosaxarlis13962 жыл бұрын
Great Video man thank you! Where can I get this excel sheet that you are using?
@financialmodeling2 жыл бұрын
Click Show More and open the Resource links.
@XXIIIXXXIIXАй бұрын
At 5:47, your answer to the 'why are they important' applies to Enterprise Value. Please could you explain why Equity Value is also important?
@financialmodelingАй бұрын
Equity Value is important because you always calculate it when analyzing and valuing companies. Retail investors also understand it in more detail, and company executives always think in terms of their share price and Market Cap. It's just that Equity Value is less useful for rigorous valuation purposes.
@guillaumegourgaud89683 жыл бұрын
I thank you for this video, really great! In the excel file an increase in accounts receivables leads to an increase in turnover. However, why does a decrease in accounts receivable not have an impact on turnover? Shouldn't it decrease?
@financialmodeling3 жыл бұрын
No. A decrease in AR means the company has collected cash that customers owed and that has already been recorded as revenue.
@Sidbaazi18634 жыл бұрын
That was excellent @Mergers & Inquisition. Can you please post one video on Quantitative Analyst Interview Questions like that one.....??
@financialmodeling4 жыл бұрын
Thanks. It's not really our area of expertise since we focus more on fundamental analysis, but we may add some quant-related articles this year.
@rafikhovsepyan37134 жыл бұрын
Looking forward to that too...
@jordimrc44994 жыл бұрын
Thanks for the video! I have a question regarding the impact of a PPE investment on EV. I understand that EV increases because PPE is a core asset, but from the point of view of a DCF (and assuming the NPV of that PPE investment is 0 - no arbitrage), why would EV increase? Under that assumption, the discounted free cash flows from that PPE will equal the initial investment (Capex) and the EV would stay the same, right?
@financialmodeling4 жыл бұрын
Because a PP&E investment should, in theory, increase a company's future cash flows if it is an actual productive investment. The additional discounted free cash flow from the PP&E should be higher than the PP&E value itself or there's no point in making the investment.
@jordimrc44994 жыл бұрын
@@financialmodeling Thanks, makes sense. And if a PP&E investment of 100 increases EV by 100, the implication would be that the NPV (deducting initial 100 of Capex and adding subsequent discounted cash flows) of such investment is also 100?
@financialmodeling4 жыл бұрын
@@jordimrc4499 Not necessarily because Current Enterprise Value (based on current market values) and Implied Enterprise Value (based on expected future cash flows) are different. Both should increase, but if you have very different views than the market, it won't be the same increase.
@barunrai79064 жыл бұрын
@@financialmodeling if that's the case then will the auditor (while testing impairment of the asset) not come up with a higher valuation that matches the NPV of future cashflows?
@financialmodeling4 жыл бұрын
@@barunrai7906 An auditor could always come up with a different valuation for the asset. This is why asset values are adjusted when a change of control happens. But in practice, PP&E is rarely written up in day-to-day activities (and asset write-ups outside of deals aren't even allowed under some accounting systems). We're trying to focus on the core concepts that are likely to come up in interviews here, not edge cases that auditors like to debate.
@olganasledysheva8482 Жыл бұрын
Thanks for the video! I have a question: in the portion where we add 100 of stock, 100 of debt, 100 of PPE, and 100 of Financial Investments. Equity up by 100 , Debt up by 100, Cash up by 100, then Cash down by 100 to purchase PPE, PPE up by 100 - here we get an increase in EV of 100 due to PPE and increase in EqV, that's understandable . But the part about financial investments I don't really understand: usually we subtract all non-operating items like financial investments, equity investments etc. Why in this case the increase in financial investments doesn't lead to a corresponding decrease in the EV?
@financialmodeling Жыл бұрын
It's easier to think about this one in steps: In Step 1, the company issues $100 of Stock, boosting CSE by $100, so Equity Value goes up, and it issues $100 of Debt, which does nothing yet since it leaves the proceeds in Cash for now. In total, the company now has $200 in Cash proceeds from these transactions. Now, the company takes this Cash and purchases $100 of PP&E, which boosts its Net Operating Assets by $100. Therefore, Enterprise Value increases by $100 since it has "transferred" non-operating assets to operating assets. And then it takes the remaining $100 in Cash and purchases $100 in Financial Investments. These are both non-operating assets, so nothing changes. In other words, before the purchase of these financial investments, we would have subtracted the remaining $100 in Cash in the Enterprise Value calculation... and after the purchase, we still subtract $100, but now it's in the form of the financial investments, not the cash. If the company uses Cash to change its Net Operating Assets, that will affect Enterprise Value - but if the Cash goes into some other asset, such as equity investments or financial investments, nothing happens since Net Operating Assets do not change.
@geonikhil2 ай бұрын
@@financialmodeling Since when PP&E is part of the Net Operating Assets? Operating Assets are Inventory, A/R, Prepaid Expenses, and not long-term assets like PPE. No?
@financialmodeling2 ай бұрын
@@geonikhil No. Various long-term assets count as Operational. Net PP&E and Goodwill are the two best examples. If a company cannot produce/sell/deliver the products without the asset, it is operational. Could a manufacturing company operate without the factories that its PP&E represents?
@shivampareek9873Ай бұрын
You mentioned if there are changes in operating items the EV will change, but when there are changes in equity value the EV will also change can you explain more about it..??
@financialmodelingАй бұрын
Not really sure what you're asking. The two basic rules are: 1) Does Common Shareholders’ Equity (CSE) change? If so, then Equity Value changes by this amount. 2) Do Net Operating Assets (NOA) change? If so, then Enterprise Value changes by this amount. This is all you need to know. A change could impact both of these, just one of these, or neither one. But if the change impacts *both* then it has to be some type of 2-step process, such as a company issuing Equity and using it to purchase a new factory.
@Rhea1 Жыл бұрын
Great video!! Can we get access to the excel sheet you're using in this video?
@financialmodeling Жыл бұрын
Click "Show More" and scroll down to the files.
@Rhea1 Жыл бұрын
@@financialmodeling No idea what's wrong but I cant really see any files attached :/
@jaromejordan79434 жыл бұрын
Are there courses on these that will help me better understand excel and IB modeling more comfortably?
When calculating Enterprise Value for a Listed Company - we can always have latest equity value easily BUT how do we access the market value of its debt? Listed companies only reveal debt information in their periodic earnings... For example, I want to calculate Enterprise Value of Unilever as of today, but I only have its FY19 annual report and latest share price info, how should I value the debt as of today?
@financialmodeling4 жыл бұрын
Look up the fair market value or fair value of its debt in its annual report and use that. The market value and book value and face value of debt rarely differ that much for large, healthy companies. So it's not the end of the world if they don't list it and you have to get it from the Balance Sheet instead.
@romancandlefight11442 жыл бұрын
12:40 Debt is non operating [so its change is ignored calculating Enterprise Value] It must be a dumb question.. but if debt is +100 then wouldn't you be adding that higher debt amount to get the final Enterprise Value, if approaching it from the perspective of the bridge between Equity Value and Enterprise Value (where debt is added)?
@financialmodeling2 жыл бұрын
When Debt goes up by $100, Cash also increases by $100 (until the company spends the Cash on something). Therefore, both changes offset each other in the bridge, and one part is up by $100 and one is $100 more negative, so there is no change in Enterprise Value.
@gaurav20192 жыл бұрын
Hi, in Q1, you said, eq value changes when cap structure changes and eq value is nothing but net assets. If suppose a company borrows $100 of debt, it would then as a result would receive $100 of cash. So the change in net assets would be $0 and therefore, eq value will not change though there's a change in cap structure. Isn't it right?
@financialmodeling2 жыл бұрын
If a company issues $100 of Debt and keeps the proceeds in Cash, yes, Equity Value stays the same. However, the statement made here was not "Equity Value changes when the capital structure changes." The statement here is: "If the company's capital structure changes, Equity Value MAY CHANGE but Enterprise Value SHOULD NOT CHANGE." In real life, a more accurate version of that statement is: "If the company's capital structure changes, Equity Value is likely to change by MORE and Enterprise Value is likely to change by LESS or not much at all." So... with some capital structure changes, Equity Value changes, and with others, it does not. If a company issues Debt to repurchase Stock, Equity Value changes because the Net Assets change, and common shareholders are responsible. But if a company issues Debt to buy PP&E, Equity Value does not change because Net Assets stay the same. Both sides of the Balance Sheet are up by the same amount, so even though the capital structure changes, Equity Value does not.
@gaurav20192 жыл бұрын
@@financialmodeling Got it, thanks.
@waqarali-dt9qq4 жыл бұрын
Nice dear can you elaborate about market multiple
@financialmodeling4 жыл бұрын
??? Not sure what you mean.
@dylanrocksify4 жыл бұрын
If equity value is in the formula to calculate enterprise value, how can equity value change and enterprise value not change?
@financialmodeling4 жыл бұрын
A company generates $100 in Net Income and lets it sit in Cash on its Balance Sheet. Equity Value goes up because Common Shareholders' Equity goes up by $100, but Enterprise Value does not change because Net Operating Assets have not changed. Also, in the formula, the higher Equity Value is offset by the subtraction of a higher Cash balance.
@eugene76782 жыл бұрын
@@financialmodeling Hi! 1. you didn't bring up the question of the change in EV/Equity if the company issues dividends for NCI and in general how can they be interpreted here ? So for example if we have net income that extends to NCI, how would EV/Equity change ? Or for example the company pays dividends to NCI ? Can you please explain this point? And the second point, the same thing with preferred investors Do I understand correctly that Equity value will increase if we pay a dividend to NCI? The EV will remain the same since we are not touching the core business and overall EV is neutral to structure changes? Please explain in terms of accountability and logic Let's make a real case, for example if there are two companies, one owns the other 70%, the company (which is 70% subsidiary) issues dividends, 70% of them will be intragroup turnover and the other 30% not, and if we add the two EVs and subtract the reduced NCI (by the amount of dividends and debt for example we get EqV which has increased, right?
@lavishsingla44312 жыл бұрын
Can Enterprise Value be less than Equity Value?
@financialmodeling2 жыл бұрын
Yes. It can even be negative! kzbin.info/www/bejne/fqnEp4edibVjbZI