Working Capital and the Change in Working Capital in Valuation and Financial Modeling [REVISED]

  Рет қаралды 82,311

Mergers & Inquisitions / Breaking Into Wall Street

Mergers & Inquisitions / Breaking Into Wall Street

Күн бұрын

Learn more: breakingintowallstreet.com/co...
Resources:
youtube-breakingintowallstree...
youtube-breakingintowallstree...
youtube-breakingintowallstree...
youtube-breakingintowallstree...
youtube-breakingintowallstree...
Table of Contents:
0:00 Introduction
2:45 Part 1: Why We Care About the Change in Working Capital
4:33 Part 2: What is “Working Capital”?
9:56 Part 3: The Change in Working Capital
14:47 Part 4: Working Capital for Best Buy and Zendesk
18:23 Part 5: Is Item X a Part of Working Capital?
21:40 Part 6: Wait, Why Don’t the CFS and BS Figures Match?!!
26:01 Recap and Summary
Lesson Outline:
We care about the Change in Working Capital because a company’s implied value always depends on its future cash flows, and a big component of Cash Flow is the Change in Working Capital.
Therefore, the Change in Working Capital could positively or negatively affect a company’s valuation, depending on its business model and market.
Traditionally, Working Capital is defined as Current Assets minus Current Liabilities, but that’s not how companies calculate it in their financial statements.
A better definition is Current Operational Assets minus Current Operational Liabilities, so we exclude items like Cash, Debt, and Financial Investments.
The meaning of a positive or negative Working Capital depends on why it is positive or negative.
The Change in Working Capital, as shown on the Cash Flow Statement, equals Old Working Capital - New Working Capital.
It’s the opposite of what you normally do because Working Capital is a Net Asset on the Balance Sheet, and when an Asset increases, that reduces cash flow; when an Asset decreases, that increases cash flow.
For example, imagine that a company’s Working Capital consists of a single line item: Inventory.
If the company’s Inventory increases from $200 to $300, it must have spent $100 of its cash flow to buy that additional Inventory.
Therefore, the Change in Working Capital = $200 - $300 = ($100), so it’s negative and reduces the company’s cash flow.
When the company finally sells and delivers these products to customers, Inventory will go back to $200, and the Change in Working Capital will be $0 once again.
Cash flow will increase not because of Working Capital, but because the company earns profits on the sale of these products.
If the Change in WC is negative, the company must spend in advance of its revenue growth - like a retailer ordering Inventory before it can sell and deliver its products.
If the Change in WC is positive, the company generates extra cash as a result of its growth - like a subscription software company collecting cash for a year-long subscription on day 1.
The Change in Working Capital, therefore, depends heavily on the company’s business model, such as when it collects cash from customers, when it pays suppliers, and when it pays for Inventory relative to product/service delivery.
For Best Buy and Zendesk, we look at metrics such as the Change in WC as a % of Revenue and as a % of the Change in Revenue.
Since the Change in WC as a % of Revenue is quite low for both of them (low single-digit percentages), we know that Working Capital is not that significant for either company.
As expected, though, Zendesk’s Change in WC as a % of the Change in Revenue are much more positive, averaging around 10%, because it is a subscription software company.
We receive many questions about whether various items, such as Deferred Taxes, Income Taxes Payable, and Operating Lease Assets and Liabilities should be part of Working Capital.
The short answer is that you should follow what the company does, and don’t worry that much about placement as long as the item correctly factors into Cash Flow from Operations.
The only point to watch out for is that changes in Cash, Debt, and Investments, should NOT be anywhere in Cash Flow from Operations or the Change in Working Capital. So, if the company does this, remove these items and re-classify them.
Finally, the Change in WC as calculated manually on the Balance Sheet will rarely, if ever, match the figure reported by the company on its Cash Flow Statement.
This is normal due to different groupings of items on the statements, changed accounting policies, acquisitions, divestitures, and so on.
Don’t panic about these minor mismatches - just focus on the overall Change in Working Capital relative to Revenue and the Change in Revenue and make sure it makes sense going forward.

Пікірлер: 134
@realFriedrichHayek
@realFriedrichHayek 3 жыл бұрын
You deserve 100k because this channel is amazing and is helping millions of passionate, motivated, underprivileged students.
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks!
@hwdiswbog74
@hwdiswbog74 3 жыл бұрын
For many months, I've been looking for clarification of this concept of change in working capital. THANK YOU SIR!
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@evastergiopoulou8472
@evastergiopoulou8472 3 жыл бұрын
For months I am looking for some material to clarify the working capital concept , Thank you ! Great Tutorial !
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@brianlu5651
@brianlu5651 3 жыл бұрын
This was so useful and helped me enormously with a superday--cannot thank you enough, as someone coming from a liberal arts school, for providing such high quality material for free.
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@Felipe_Ferreeira
@Felipe_Ferreeira 3 жыл бұрын
Thank you very much for the content, it was really hard to find this information!
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@deepjoybose458
@deepjoybose458 Жыл бұрын
i was so much confused untill i came across this video...cheers mate! u helped a lot here!
@financialmodeling
@financialmodeling Жыл бұрын
Thanks for watching!
@theprimonemo
@theprimonemo 2 жыл бұрын
I'm part of the silent majority, that ususally doesn't comment but man I really appreciate your guidance because I would have otherwise given up on DCF and gone back to Yolos and losing money. You're actually providing people with the opportunity for a better life. So thanks!
@financialmodeling
@financialmodeling 2 жыл бұрын
Thanks for watching!
@Sach_pa3el
@Sach_pa3el 10 ай бұрын
Amazing content, I never learn that deeply in my past. Vary valuable content.
@financialmodeling
@financialmodeling 10 ай бұрын
Thanks for watching!
@AzeemAkbar
@AzeemAkbar Жыл бұрын
Thank you for this brilliant tutorial.
@financialmodeling
@financialmodeling Жыл бұрын
Thanks for watching!
@1ricky4dias7
@1ricky4dias7 3 жыл бұрын
Know you said not to drive myself crazy over this but it's exactly what im doing. Im trying to make a DCF model for evaluating companies and with how much of a impact the change in working capital has im going crazy to find the the right way. I was trying to see my numbers vs the website seekingalpha but those seem to make no sense so that drove me even crazier! Great video btw, taught me a lot.
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks. I'm not really sure how I can answer your question (or if you're asking a specific question).
@mingji5864
@mingji5864 2 жыл бұрын
Well explanation. Thank you and appreciate that.
@financialmodeling
@financialmodeling 2 жыл бұрын
Thanks for watching!
@ValueInvesting2050
@ValueInvesting2050 Жыл бұрын
Wow. Very good explained! Great!
@financialmodeling
@financialmodeling Жыл бұрын
Thanks for watching!
@rajatsharma-hq6dc
@rajatsharma-hq6dc 2 жыл бұрын
excellent explanation. Awsome topic.
@financialmodeling
@financialmodeling 2 жыл бұрын
Thanks for watching!
@rashmipahari7762
@rashmipahari7762 3 жыл бұрын
yes, this was a great session . thank you :)
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@WhiteCarBlackWheels
@WhiteCarBlackWheels 3 жыл бұрын
wow that titanic metaphor was very dark... hahaha. i honestly really enjoy your videos bc my company really doesn't follow the norms / same terms as most others. im exiting my current role for an FP&A one next month (at a new company) and am hopeful i can use your videos to sound half-educated! thank you!
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks. Yes, dark metaphors are our specialty here.
@alexfarrugia6106
@alexfarrugia6106 3 жыл бұрын
Great content!
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@smitmehta8914
@smitmehta8914 3 жыл бұрын
Congratulations!!!!!
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks!
@abhiralpandey
@abhiralpandey 3 жыл бұрын
Well explained!
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@kevinfrancis23
@kevinfrancis23 3 жыл бұрын
I love this channel as someone who is interested in investing but did not study finance
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@aravinds9674
@aravinds9674 3 жыл бұрын
Thanks a lot for your content.. Could you probably upload a video on how an impact PE fund might approach financial modeling and how the underlying drivers could change?
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks, I'll see what we can do, but this topic is not terribly likely because impact investing is very specialized and there isn't much information on it.
@JohnSmith-si8nz
@JohnSmith-si8nz 3 жыл бұрын
Super helpful thank you very much ! I can relate to trying to match CFS and BS working cap 😂 Especially since I work in MM IB in Continental Europe a lot of private firms do not even disclose their CFS so you Need to deduct it from their BS and IS yourself 😂
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks, glad it helped!
@yogeshmmpyd5945
@yogeshmmpyd5945 2 жыл бұрын
One in million video sir Rich in content highly helpfulllll
@financialmodeling
@financialmodeling 2 жыл бұрын
Thanks for watching!
@ignaciogonzalez6179
@ignaciogonzalez6179 3 жыл бұрын
GREAT VIDEO
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@namankulshreshtha6042
@namankulshreshtha6042 3 жыл бұрын
Pit of lava filled with crocodiles?🐊 Some freaking crocodile that must be. Thanks for such an informative session btw. :)
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching! And yes, the crocodiles were highly lava-resistant.
@edupa1
@edupa1 3 жыл бұрын
Dude, I love your videos. What do you think of Damodaran's approach where he usually doesn't use WC change to get to the free cash flow to the firm, instead he uses the reinvestment rate and subtract from NOPAT? It would be so sweet if you could make a video about it. But I'd be happy just to know your opinion about this.
@financialmodeling
@financialmodeling 3 жыл бұрын
We don't like that approach because it's disconnected from the company's real financial statements. Also, finding the true "reinvestment rate" can be tricky due to inconsistencies in historical WC and CapEx levels. It's a nice idea in theory/academia, but doesn't hold up that well in real life when you're given a set of financial statements and you have 30 minutes to value the company.
@racerx1326
@racerx1326 2 жыл бұрын
Thank you for all your videos. Really really appreciate it! When calculating NWC from the CFO statement, why is it simply the sum off all the items? I thought its Current Operating Assets - Current Operating Liabilities, but when you calculating the Change from the CFO in other videos, I see you just added all the line items. In other words, in this case for Year 1 CHG NWC = [-348-156+1307+419] but I thought it would be calculated as CHG NWC=[-348-156]-[1307+419]
@financialmodeling
@financialmodeling 2 жыл бұрын
Because when companies list the Change in Working Capital on the CFS, it's already calculated as Current Operating Assets - Current Operating Liabilities or something similar. No further adjustments are required.
@jasonr3165
@jasonr3165 7 ай бұрын
I watched this video 5 times at least!
@financialmodeling
@financialmodeling 7 ай бұрын
Thanks for watching!
@MrCuddles77
@MrCuddles77 6 ай бұрын
thanks for the video and explanation. That really helps a lot. By the way, if someone jumps into a pit of lava filled with crocodiles, the crocodiles will already be toasted.
@financialmodeling
@financialmodeling 6 ай бұрын
You're assuming the crocodiles do not have lava/flame-resistant coating...
@williamchen6081
@williamchen6081 3 жыл бұрын
Congrats on 100k subs. Was just wondering can you write off accounts payable (don’t have to pay them back anymore). How would you reflect that in changes in wc, as it would not necessarily reduce CF? Would you just decrease expenses for the next period?
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks. An Accounts Payable write-off should not really show up within the Change in Working Capital section because it's a write-off, not the item going up or down naturally. It would be shown as a positive on the Income Statement (the opposite of an asset write-down), and it would be reversed on the CFS within CFO, so it would be a negative there. Expenses on the Income Statement in the next period should not decrease because AP correspond to expenses that have already been incurred but not paid in cash (at least in some cases... not true for something like Inventory being paid on credit).
@williamchen6081
@williamchen6081 3 жыл бұрын
​@@financialmodeling That makes a lot of sense. Cheers!
@Datapoint90
@Datapoint90 2 жыл бұрын
Thanks :D
@financialmodeling
@financialmodeling 2 жыл бұрын
Thanks for watching!
@suppakittungsanga3334
@suppakittungsanga3334 11 ай бұрын
Thank you for the informative video! I was just wondering the point you mentioned about how companies consider working capital items differently. In practice, does this mean that companies have different items included in their WC items for the calculation of NOPAT to FCFF? If so, do these discrepancies get adjusted when we're comparing between companies?
@financialmodeling
@financialmodeling 11 ай бұрын
Yes, companies may include slightly different items in Working Capital, but it's often justified if their business models differ. You rarely make adjustments when comparing them unless it is something major, such as one company counting a huge Deferred Revenue balance in WC and another company with the same business model not counting it at all. This is rare since you're usually comparing companies in the same industry.
@user-ds1kn4hc8f
@user-ds1kn4hc8f 5 ай бұрын
How do you typically model credit card usage into WC? For example, we use CC for some inventory payments (balance sheet), advertising expense (income statement/gross expenses), and then general expenses
@financialmodeling
@financialmodeling 4 ай бұрын
Credit cards are short-term/revolver debt, so they shouldn't really be a part of Working Capital in the first place. Nothing interest-bearing should go in there. Some companies will do this anyway and claim they're "not interest-bearing" since they are repaid each month, but if you look at the statements of large/public companies, no one lists Changes in Debt within the Change in Working Capital section.
@yusuf200620063
@yusuf200620063 Жыл бұрын
In the example @ 9:31, Comany B may be in better position as they are using their suppliers to fund their Working capital requirement, indicating it’s market strength
@financialmodeling
@financialmodeling Жыл бұрын
Maybe, but without additional information, we can't really say for sure.
@intelligentinvestor2305
@intelligentinvestor2305 3 жыл бұрын
I could be wrong but on BS, the current assets and liab is defined by time horizon (under 1 year) whereas on CF it's as you said classified by the company based on their interpretation of operating assets and liab
@financialmodeling
@financialmodeling 3 жыл бұрын
Yes, that is correct, but the issue is that companies do not spell out exactly which portions of which assets and liabilities are considered "operational," so there is always guesswork involved.
@ashankar
@ashankar 13 күн бұрын
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 5 күн бұрын
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.
@aboubacarsidikbamba181
@aboubacarsidikbamba181 3 жыл бұрын
Thanks for your video Sir. I have a question. Why the formula for Net change is : Account receivables + Inventories + Other Assets + Account Payables + Income taxes + other liabilities and not : (Account receivables + Inventories + Other Assets) - (Account Payables + Income taxes + Other liabilities) ?
@financialmodeling
@financialmodeling 3 жыл бұрын
??? What are you asking about? The formula for Working Capital is the one you suggested. You subtract Current/Operational Liabilities.
@JonesDawg
@JonesDawg 3 жыл бұрын
If short-term Deferred Tax Assets are present on the balance sheet, should they be considered operating items and included in NWC or not? Thanks!
@financialmodeling
@financialmodeling 3 жыл бұрын
Deferred Tax Assets should not be a part of Working Capital regardless of their duration.
@fatcrab33
@fatcrab33 Жыл бұрын
can i ask there could be a lot item in the balance sheet, is that u either treat it as operating or non operating, for the operating, it is included in the working capital and for other item they are included in the net debt when doing a valuation, so all item must be reflected either in the working capital or in the net debt?
@financialmodeling
@financialmodeling Жыл бұрын
This is true of many items on the Balance Sheet, but there are exceptions. For example, something like Net PP&E is clearly not in Working Capital, but it's also not part of the company's Net Debt. It's simply a long-term operational asset. The same applies to something like Goodwill. So, I wouldn't necessarily recommend learning this as a "rule" - you can generally classify items as operational vs. non-operational, but just because something is "operational" doesn't mean it's part of the Working Capital.
@charliemike89
@charliemike89 10 ай бұрын
Thanks, I was driving myself crazy by comparing the net working capital change (from balance sheet) and the NWC change in the ADBE's cash flow statement (and with other stocks too). For example, receivables doesn't match. So, it might be normal then.
@financialmodeling
@financialmodeling 10 ай бұрын
Yup, it will never match exactly. Just accept it and move on.
@JonesDawg
@JonesDawg 3 жыл бұрын
Should operating cash be part of NWC? In class, we used 5% of sales number as operating cash, and the rest i.e. excess cash as investment assets.
@financialmodeling
@financialmodeling 3 жыл бұрын
It's not a good idea to do that in financial statement analysis / modeling / valuation because the Net Change in Cash at the bottom of the CFS should track the total change in cash. You can run into issues with double-counting or forgetting part of the Cash balance if you split it up. Also, no companies show the change in operating cash in the Change in WC section of the CFS.
@rs9301
@rs9301 3 жыл бұрын
For some companies say for growth companies or companies early in their life cycle who have relatively less cash reserve than compared to the matured companies talking 5% the impact of doing that on cash flow during forecasting would be miniscule, and you can get away with that but think of doing that with company like Apple who has significant cash now apply the 5% rule the impact would be tremendous.. Also remember in finance there are lot of rules of thumb being concocted & one must always challenge them. I mean why 5% why not 2/3/8/12/14% who's making those rules? The whole idea of considering operating working capital as oppose to accounting definition of working capital is that. By excluding cash from current assets & excluding short term loans from current liabilities. Say except for cash the amount invested in say inventory/accounts receivable does not earn any rate of return so they are wasting assets while cash earn a riskless return in bank. For short term loans/debt they add up to debt while calculating cost of debt during cost of capital computation.
@onurcetinkaya9857
@onurcetinkaya9857 2 жыл бұрын
Should i include VAT while calculating change in WC
@financialmodeling
@financialmodeling 2 жыл бұрын
Follow whatever the company does on its financial statements.
@anthonyh6399
@anthonyh6399 2 жыл бұрын
Hey sir base on your explanation on change in WC (WC of last year - WC of current year), when doing FCF you are adding the change in WC right? I asked b/c from my professor we minus the change in WC when doing FCF, but the key difference is that we define change in WC as (WC current year- last year)
@financialmodeling
@financialmodeling 2 жыл бұрын
If Working Capital increases from one year to the next, it's a negative in the FCF formula. If it decreases, it's a positive.
@star5guy
@star5guy 3 жыл бұрын
Thanks, Brian for the video. Just a quick query, Let's say WC turns from +50 in year 1 to -100 in year 2 (new). So this means a positive impact on Free cash right? We would "add" 150 as the "change in WC" and this shall boost my FCFF
@financialmodeling
@financialmodeling 3 жыл бұрын
Yes.
@star5guy
@star5guy 3 жыл бұрын
@@financialmodeling a negative working capital means CA 《 CL which means a current ratio 《 1. Accountants view this as a bad thing. However, the same situation is adding to my valuation as you replied above. How should we explain this trade off Brian. Its confusing to me
@financialmodeling
@financialmodeling 3 жыл бұрын
@@star5guy Working Capital by itself does not affect valuation, only the *Change* in Working Capital does. How accountants view it is irrelevant because valuation is based on cash flows, not accounting rules. The Change in WC translates a company's position into cash flows and makes it relevant for valuations.
@benjaminli3808
@benjaminli3808 Жыл бұрын
For valuation purposes, is change in operating capital and change in NWC the same? Which is to say can I directly pull the value as change in NWC?
@financialmodeling
@financialmodeling Жыл бұрын
Yes, but be careful with how companies define "operating capital" because the definitions can be inconsistent. It's always best to use what's directly shown on the CFS.
@kidze73
@kidze73 2 жыл бұрын
hi M&A, I'm learning about how to calculate "Reinvestment" and materials out there say Change in Working Capital is part of Reinvestment, other than CAPEX. Is that true and justified? if what I want to calculate is how much the business reinvests into the business from their profit. The reinvestment rate formula I found takes: Change in Working Capital + Net CAPEX (which is CAPEX - Depreciation) all over NOPAT. My other question is: why minus Depreciation? is it because NOPAT is accrual so we need to follow accrual accounting as well? Since I believe the "actual cash" outflow is still CAPEX. So, can I calculate "reinvestment rate" by taking: (Change in working capital + CAPEX)/(NOPAT + D&A). Does that number mean what I want to find out? which is the actual cash reinvestment taken from cash profit? I hope I am clear with my question and thank you so much for your educational content!
@financialmodeling
@financialmodeling 2 жыл бұрын
We don't set up models like that, but yes, you could view the Change in WC as "reinvestment." You subtract Depreciation because it's non-cash in the period, and CapEx - Depreciation over the long term tells you how much the company needs to spend to maintain/grow itself. Can't really comment on the reinvestment rate because we never use that approach, as it's easier from a modeling perspective to work off the company's financial statements as is.
@ivanbakaev8872
@ivanbakaev8872 Жыл бұрын
Thanks for your video, it's great! However, I got lost. If I am calculating change in Acc. Payable for 2021 it is $100 and for 2020 it is $150. What number I will find in a cash flow statement: $50 or ($50)?
@financialmodeling
@financialmodeling Жыл бұрын
It should be ($50) because a Liability decreasing is a cash outflow. However, it probably won't match exactly because other items could affect this, companies group items differently, there may be acquisitions/divestitures/accounting rule changes, etc.
@jatinpopli
@jatinpopli 2 жыл бұрын
I'm new to this channel. Also, I'm currently preparing for CFA Level-1. Where do I begin to learn the concepts available on this channel? Please guide!
@financialmodeling
@financialmodeling 2 жыл бұрын
I can't really answer your question because these are "quick tips" videos about different topics and are not arranged in a structured way. We give free samples and summary lessons in this video, not structured courses.
@jatinpopli
@jatinpopli 2 жыл бұрын
@@financialmodeling okay! Thanks, anyways. I'll start exploring then. Btw, keep up the great work.💯👏
@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.
@waqarehsan
@waqarehsan 8 ай бұрын
21:17 Can someone tell me which IFRS he is reffering to?
@financialmodeling
@financialmodeling 8 ай бұрын
"IFRS" refers to the international accounting standards for financial reporting. Companies outside the U.S. use IFRS, or a local variation, to report their financial results. www.ifrs.org/supporting-implementation/supporting-materials-by-ifrs-standards/
@parammehta9920
@parammehta9920 3 жыл бұрын
Does "Other Current Assets" include Account Receivables (Debtors) ?
@financialmodeling
@financialmodeling 3 жыл бұрын
If AR is not shown as a separate line item, yes, it's often included in Other Current Assets.
@parammehta9920
@parammehta9920 3 жыл бұрын
@@financialmodeling Thanks a lot! On a side note, you are doing a great job and your channel is very informative and helpful. Thanks a ton :)
@yosephs8097
@yosephs8097 3 жыл бұрын
can you do a change in working capital of mmm of 2007? Im reading The Little Book of Valuation and I tried your method but somehow I didnt get Damodarans answer of 243 million Ive been stuck on this literally for days. Thanks so much
@financialmodeling
@financialmodeling 3 жыл бұрын
Sorry, we can't comment on other books/resources/assignments in this channel, only on the material presented in these free tutorials. I wouldn't worry if your answer is reasonably close.
@anant0089
@anant0089 Жыл бұрын
1. hi what if company does sort term cash borrowings lets say in year 1 no short term cash borrowings but in year 2 short term cash borrowing is 100 in cash ( current liabilities ) so change in working capital will be Assets (0) - Cash Liabilities (100) = -100 but cash has come inside business ? i have seen companies using this to inflate their cash balances even for long term debt. How will this go in cash flow statement ? as cash has come in but in cash flow as per formula will be -ve ? 2. in berkshire cash flow they are showing Investment (gains) losses -77B (negative ) etc year 2021 in operating activity what does that mean they bought investments or they had loss on investments ? they need to more clear what is going on, loss should be mentioned as loss and purchase should be mentioned as purchases. pls have look ty
@financialmodeling
@financialmodeling Жыл бұрын
Cash and borrowings should never part of "Working Capital," so I don't understand your first question. If a company is doing this, you should adjust by removing them. Your second question has nothing to do with this topic so I will not answer it in detail, but companies now record both realized and unrealized gains on equity investments (small stakes in other companies) on the IS and reverse unrealized gains/losses as non-cash items on the CFS.
@sonerguney3225
@sonerguney3225 2 жыл бұрын
Super
@financialmodeling
@financialmodeling 2 жыл бұрын
Thanks for watching!
@navendersandhir
@navendersandhir 2 жыл бұрын
AT 9:50, you say that the company is not collecting cash upfront, if that would have been the case wouldn't AR balance (presumed to be part of other current assets), further negatively impacting the WC? Also this is a retail business, which will have limited/nil customer receivables, so what are you implying to when you make reference to limited cash collection upfront?
@financialmodeling
@financialmodeling 2 жыл бұрын
Any time a company *delivers* a product or service without the customer paying in cash at the same time as the delivery, the AR balance increases. So I am not sure what you are asking. Working Capital itself increases when this happens because Working Capital = Current/Operational Assets - Current/Operational Liabilities, so an increase in AR increases Working Capital. It's just that the *change* in AR as defined on the Cash Flow Statement becomes more negative. Plenty of retail businesses can have receivables. Even offline/physical stores might allow for phone/internet/other remote orders where the payment is not immediate/upfront. Look at any retailer's Balance Sheet, and you'll almost always see a line item for Accounts Receivable. Yes, AR will be lower than it would be for other types of businesses, but it's still there.
@rachitsingh9473
@rachitsingh9473 3 жыл бұрын
Accounts Receivables means customer has not paid the sales price for the goods that it bought. But sales price =value of goods + sales tax. Will AR include sales price or sales price minus sales tax.
@financialmodeling
@financialmodeling 3 жыл бұрын
Depends on how the company's statements are set up, but if "Revenue" also includes sales tax, then AR should also include sales tax because the customers are responsible for paying sales tax to the company, so it counts as a receivable as well... it is completely pass-through on the statements, though, because it's recorded as revenue and then just paid out as an expense to the government.
@rachitsingh9473
@rachitsingh9473 3 жыл бұрын
@@financialmodeling so in income statement the tax rate that is used to calculate PAT will also reflect indirect taxes along with corporate tax ??
@financialmodeling
@financialmodeling 3 жыл бұрын
@@rachitsingh9473 No, just corporate taxes.
@pearlynsth
@pearlynsth 3 жыл бұрын
hello! is the excel spreadsheet avail for download?
@financialmodeling
@financialmodeling 3 жыл бұрын
Click "Show More" and click the links.
@twilliams4700
@twilliams4700 2 жыл бұрын
If "Accounts Receivable" is included in "Current Assets", then the change in WC (Old WC - New WC) explanation makes a bit less sense to me. I understand that you need to pay for the additional $100 in inventory, but how does that apply to AR (if AR went up from $200 to $300)? In that case, isn't the only outflowing cash the COGS associated with delivering that additional $100 of services that you haven't yet been paid for?
@financialmodeling
@financialmodeling 2 жыл бұрын
If AR increases from $200 to $300, it means the company recorded more revenue but did not collect it in cash. Therefore, its cash flow needs to be reduced because revenue alone is overstating how much in cash receipts the company gets. If there are COGS associated with this additional revenue, the cash flow impact depends on whether the COGS are paid for upfront in cash upon product delivery or if they're deferred and paid in cash later (i.e., part of accounts payable or accrued expenses).
@11dudekk22
@11dudekk22 3 жыл бұрын
I ve recently discocerd this channel. You are great. Thanks
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
@augustusg857
@augustusg857 2 жыл бұрын
Hey. So if the Inventory was 400 in year 1 and then 300 in year 2. Youd be adding 100 to cash flow, but isn't that telling us that the company sold last years left over inventory so it's being extra cash from selling extra inventory. And if its receivables. Year 1 400, year 2 300. Wouldn't that imply that the company collected all if its year 2 receivables plus got extra cash this year from last years unpaid receivables that it carried over into year 2?
@financialmodeling
@financialmodeling 2 жыл бұрын
Yes, but in both those examples, the company has likely cycled through its AR and Inventory several times over the course of the year. They tend to be short-term and rarely last more than a few months. But if Inventory decreases and AR decreases from one year to the next, the company's cash flow should be more positive as a result (as assets decreasing always boosts cash flow).
@augustusg857
@augustusg857 2 жыл бұрын
@@financialmodeling By cycle you mean how long it takes the comp to cash them? What I'm trying to ask is can these curent assets be held into the following year and then is yes then it makes sense why there is being extra money being added. So if a comp has a balance sheet ending Dec/25th/2022 with AR being 300 and then Dec/25/2021 ending balance sheet with 400 in AR I'd add 100 to my NI in 2022. NI for 2022 $300 AR. $100 Cash from operations $400.
@financialmodeling
@financialmodeling 2 жыл бұрын
@@augustusg857 Yes, that can happen. My point above is that AR rarely remains outstanding for an entire year, so if you want a more realistic time frame for these numbers, you should look at monthly or quarterly financial statements. In those cases, if AR increases from 300 to 400 over the span of a month because nothing has been collected but there has been one new purchase for 100 (also not collected), then the company's revenue will increase by 100 and net income will also increase as a result (less than 100 due to taxes and other expenses).
@augustusg857
@augustusg857 2 жыл бұрын
@@financialmodeling And that 100 increase in AR is a 100 decrease In cash flow since it's in credit. Ok I get it. I really do appreciate you taking time to respond.
@parammehta9920
@parammehta9920 3 жыл бұрын
Is the earlier video taken down?
@financialmodeling
@financialmodeling 3 жыл бұрын
Yes
@parammehta9920
@parammehta9920 3 жыл бұрын
@@financialmodeling Thanks for confirming mate. Cheers and happy new year!
@spencert.gallagher3815
@spencert.gallagher3815 3 жыл бұрын
Some inspirational quotes from this video: “On the titanic that doesn’t matter because most people are still going to die” and “if you try to do this you will jump off a building” Side note love the videos.
@financialmodeling
@financialmodeling 3 жыл бұрын
Thanks for watching!
US GAAP vs. IFRS in Valuation and Financial Modeling [REVISED]
25:51
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 15 М.
50 YouTubers Fight For $1,000,000
41:27
MrBeast
Рет қаралды 202 МЛН
Gym belt !! 😂😂  @kauermtt
00:10
Tibo InShape
Рет қаралды 17 МЛН
Best KFC Homemade For My Son #cooking #shorts
00:58
BANKII
Рет қаралды 64 МЛН
What is Free Cash Flow? [REVISED] Meaning, Calculations, Variations, and IFRS Differences
20:41
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 21 М.
Build a Dynamic 3 Statement Financial Model From Scratch
32:26
Kenji Explains
Рет қаралды 1 МЛН
Valuation in Four Lessons | Aswath Damodaran | Talks at Google
1:01:30
Talks at Google
Рет қаралды 1,6 МЛН
Unlevered Free Cash Flow: What Goes in It, and Why It Matters
20:31
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 48 М.
The Private Equity Case Study: The Ultimate Guide
34:31
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 57 М.
Net Working Capital - Valuation Adjustments In M&A
37:03
FinanceKid
Рет қаралды 24 М.
Net Working Capital in Plain English - Complete Guide (2021)
14:02
Financeable Training
Рет қаралды 36 М.
Financial Forecasting and Modeling 2+ Hour Course!
2:20:12
Simon Sez IT
Рет қаралды 113 М.
50 YouTubers Fight For $1,000,000
41:27
MrBeast
Рет қаралды 202 МЛН