Working on my M.S. in Finance and I zero background working in accounting or finance...(I work in insurance) this video is a great explanation for something that is difficult to understand from just reading the textbook
For those in need: that 384 change in accumulated other comprehensive income (AOCI) is the difference between the IS D&A and BS implied D&A; Therefore, assuming that there is no amortisation, the income statement D&A includes a non-cash adjustment that is in fact an unrealised revaluation (likely of PPE) which is reflected in AOCI. The cash-flow statement CFFO and CFFI should be modified to reflect this as follows - CFFO: D&A is 360, CFFI: Capex is -26 (calculated as sum of change in Gross PPE -410 and change in AOCI +384). You are welcome :)
Hi Kenji, I love your content as it provides exact information about finance and its working. Just wanted to ask any videos on DCF modelling from scratch ?
Thank you, appreciate your support! No unfortunately don't have those as they're very lengthy (at least to do well). The only place we have those available is in our course: learn.careerprinciples.com/courses/finance-valuation-course
It's easy to do, just the non-cash movements, like provisions, allowance for doubtful debts, depreciation, financing costs on lease liability need to be considered
What about the sale of an asset loss or gain don’t you have to adjust it in the operating activities part of the cash flow ? And the sale will be adjusted in the investing part
What if D&A is not in a separate line item in the IS? What if it is embedded in COGS or Opex? How would you calculate D&A then, in order to add it back to the CFS?
Hi Kenji, thank you for this video. May I know if SG&A and other operating expenses should be included in Cash flow under Operating activities? Should I treat them the same as depreciation and not get the difference? Thanks
I very much enjoyed your video.I am creating a month to month forecast but do not know how to treat downpayment from customers and downpayments to vendors in the statement of cash flows.Can You advise? thanks
When calculating Change in Working Capital, why calculating receivable, inventory and payables separately? what if, we first calculate the working capital of both years and takes the change of working capital?
I have a question if you start from the net income for the cash flow statement, shouldn’t you take away interests? and is not correctly taking into account the operational taxes, isn’t it?
I wanted to point out a couple of things. I might be completely wrong. Part of debt repaid is already subtracted in the income statement, so to account for that short-term debt repaid and portion of long-term debt repaid must be added back in CF from operations and subtracted back from financing activities to ensure there is no double substracting. Moreover, shouldn't the change in other assets be added/substracted from investing activities?
Hey kenji, you explain very clearly and your content is really good. I have theoretical knowledge about financial modelling and valuations (but I don't understand when it comes to practically making Models) can you suggest best Books to learn about financial modelling, Valuations(Basic to advance) and Finance (Investment Banking related).
Noticed for the movement in PPE, this doesnt seem 100% correct because the movement may be due to a revaluation of properties. So there would be a need to split out the fair valuation appreciation portion (not to be included). Right?
The gross PPE is essentially the book value and does not account for depreciation/appreciation, therefore you can use it to identify whether capital expenditure has been increased or not. Using net PPE would be incorrect if you do not add back the depreciation
Hi Kenji. I always watch your videos, thanks for explain really good. I'd like to know why you add short term debt in operating cash flow, I understood it was part of financing cash flow. Why it could be? thanks so much
have a question or confusion here, Is this the correct way to subtract the previous year's value from the current year's value? check WC heading , Accounts Receivable increased in 2021 then why would be figuring it out to be as negative change?
Hi pls help me I need to figure it out why increase in inventory in company balance sheet will go in Cash Flow only but not under purchases in Trading and P&L account and reduce net/gross profit accordingly ? Example company:
hey i was analyzing a company's cash flow statement and the changes in current assets reported on cash flow statement does not correspond to the change in current assets on the balance sheet. how to go about this thing?
Hello sir, im really confused where to account contingency fund in cash flow it is separated account from cash in assets But in ledger you cannot account it anywhere.. So where does contingency fund go with?? The capital????
do we really need cash flow statements? i mean our system has all cash movements recorded and we have income statements, expense trends, capex, BS packs which automatically tells us all movements in cash + the ending balances. please answer my question cz i am really confused. thank you in advance :)
Hi there Kenji , what could your recommend me (from your courses )… I’m civil engineer and for this 2023 year I would like to do like an investment for my company.. buying an excavator… so what could I do … like a project finance for the company trying to figure out my incomes and outcomes…? Thank you looking forward your reply
I have a question here. Depreciation that we are adding back is 744 whereas the movement in Accumulated depreciation is 360. What could be the reason of difference? How our cash flow is tallying without considering this difference?
Kenji, so do all cash flow statements show no original information? Everything in cash flow statement can be built from balance sheet and income statement?
Yeah, but what good it does if, for example, Net income is not categorised? Also, income is booked when invoice is written. Is there is income booked, it does not mean that money was received.
If someone can help with the depreciation, i'd really appreciate. The cashflow uses 744 as depreciation and amortization whereas the Balance sheet shows 4800 and 5160. Where does the 744 come from?
I think it's a mistake, since in video cash balance is taken from CFS, Balance sheet is matching. Practically Cash Balance would be physically verified and same will be considered in BS. In this scenario, Closing cash is being affected by the difference in depreciation in Balance sheet and Income statement
dont you need to concern on payment of tax in cash. You got net income after tax and interest and you didn't concern about the tax and interest payment in term of cash.
Hello sir, im really confused where to account contingency fund in cash flow it is separated account from cash in assets But in ledger you cannot account it anywhere.. So where does contingency fund go with?? The capital????
👉 Get 25% OFF Financial Edge using code KENJI25: bit.ly/3Lla95f
Antonmursid🙏🙏🙏🙏🙏✌🇲🇨🇲🇨🇲🇨🇲🇨🇲🇨✌💝👌🙏
🚨 Correction: short-term debt should not be accounted for under working capital. It should go under financing activities. Cheers!
Yes I was about to correct it but then I saw your comment
@kenji explains What about the taxes which needs to be deducted under the operating cash flows?
Great video!
I have two questions. How do we accounted for the short term lease liability? And how do we accounted for a ROU operating lease assets?
@@jeimmylorenasolerlopez1312Your question makes no sense
Explains why I only got £85 in Financing 😁 All good
I love the posibility to load the document and work with you! Thanks!
Kenji Explains, also known as every business student's best friend! 😁😃 Truly appreciate the endless value you keep providing!
Cheers Daniel thank you for watching the videos! Hope all is well man :)
Amazing. Thank you so much. I have a horrible corporate finance professor and this channel is literally how I am getting through my masters course. 🙌🏻
Happy to help!
Thank you for simplifying the Cash flow statement
Your voice forces my nerves to calm down and just listen. This was so beneficial for me. We are working on cash flow in my Finance class. Thank you
This was super helpful. Thank you Kenji!!
Hi Kenji. Its really fabulous to see this video. Request to show direct method with the same data.
You're such a king honestly. Thanks a lot
Happy to help!
AMAZING VIDEO HONESTLY I DON´T HAVE WORDS
Most helpful RUclips channel
We were deserving this type of video! Thanks professor Kenji!
Hope you enjoyed it!
dude this is amazing, thanks so much! Can you explain deferred tax situation?
Working on my M.S. in Finance and I zero background working in accounting or finance...(I work in insurance) this video is a great explanation for something that is difficult to understand from just reading the textbook
Thanks @KenjiExplains this is a very useful video on cash flow statement
For those in need: that 384 change in accumulated other comprehensive income (AOCI) is the difference between the IS D&A and BS implied D&A; Therefore, assuming that there is no amortisation, the income statement D&A includes a non-cash adjustment that is in fact an unrealised revaluation (likely of PPE) which is reflected in AOCI. The cash-flow statement CFFO and CFFI should be modified to reflect this as follows - CFFO: D&A is 360, CFFI: Capex is -26 (calculated as sum of change in Gross PPE -410 and change in AOCI +384). You are welcome :)
it was very solid good explanation thank you
Thank you very much, this helped me alot.
Congrats Kenji ! The quality of your videos is amazing !
Thanks so much for the comment Luca, really appreciate it!
VERY USEFUL CONTENT. MANY OF MY DOUBTS WERE CLEARED IN THIS VIDEO. THANK YOU.
Thanks Kenji for sharing. Your explanation is very detailed
This is good. I did my accounting class a year ago and already forgot some basics. This reminded me a lot. Thank you.
your presentation is good. Thank you
Thank you for uploading such good content
Thanks so much, Kenji
It does what it says on the tin; Kenji does, indeed, explain. 👏
kudos very well explained
Simply superb. You explained the toughest thing in a very simpler form. Hats off Sir !!
Thank you sir!!!
Thank you for the valuable content
amazing docs and video
Dear Kenji, Thank you for great lesson.
THANK YOU FROM PUERTO RICO
You have great explanation Sir, kindly guide how to create Lend and Borrow track record in appsheets app.
thanks of nice Explanation
This video is wonderful
Really easy to understand thanks!!
Glad to hear that!
I am not from Finance, but wanted to learn about DCF which requires deriving FCF, thanks.
@kenji, Is the change in other current assets be +150, because the company gained cash from selling current assets from 1,650 to 1,500?
Thank you my friend! Keep doing this interesting videos!😁
Thanks for the visit!
Hi Kenji, I love your content as it provides exact information about finance and its working. Just wanted to ask any videos on DCF modelling from scratch ?
Thank you, appreciate your support! No unfortunately don't have those as they're very lengthy (at least to do well). The only place we have those available is in our course: learn.careerprinciples.com/courses/finance-valuation-course
@@KenjiExplains how long is your course hours?
It's easy to do, just the non-cash movements, like provisions, allowance for doubtful debts, depreciation, financing costs on lease liability need to be considered
Great video! It would be great if you made one on how to restructure financial statements, don’t you think?
How do you set up the check thing at the end of the balance sheet?
Hi Kenji. Can you do a Seidman Financial Model 13 weeks cash flow tutorial?
Great video, I just can't understand why you add in the depreciation to the operating cash flow? Cheers!
This is in other to adjust for non-cash items from net income
sir where will i place cash received from compensation income
What about the sale of an asset loss or gain don’t you have to adjust it in the operating activities part of the cash flow ? And the sale will be adjusted in the investing part
What if D&A is not in a separate line item in the IS? What if it is embedded in COGS or Opex? How would you calculate D&A then, in order to add it back to the CFS?
Could you let how to match balance sheet tallying in Excel
Amazing
Another solid exercise anyone can do to prepare for finance interviews
Thanks for the help!
hi, kenji, how to make the Change in formula you make auto kinda to the right not in line the Change in Title thanks
Hi Kenji, thank you for this video. May I know if SG&A and other operating expenses should be included in Cash flow under Operating activities? Should I treat them the same as depreciation and not get the difference? Thanks
Net income takes care of the P&L aspect of cashflow. You do not need to bring in any other P&L item except for Dividend paid calculation
Hi Kenji I,m really enjoying watching ur videos, the link for the excel file is for a chart,not for building an income statment
Link updated sorry: view.flodesk.com/pages/62da585cc9d3abbafd6c44b5
I very much enjoyed your video.I am creating a month to month forecast but do not know how to treat downpayment from customers and downpayments to vendors in the statement of cash flows.Can You advise? thanks
When calculating Change in Working Capital, why calculating receivable, inventory and payables separately? what if, we first calculate the working capital of both years and takes the change of working capital?
Thank you very much for this very helpful video. I am going to save this because I know it will definitely come in handy again!
I have a question if you start from the net income for the cash flow statement, shouldn’t you take away interests? and is not correctly taking into account the operational taxes, isn’t it?
Sir if debenture is given in balance sheet how i understand that debenture or issued or redeem
I wanted to point out a couple of things. I might be completely wrong. Part of debt repaid is already subtracted in the income statement, so to account for that short-term debt repaid and portion of long-term debt repaid must be added back in CF from operations and subtracted back from financing activities to ensure there is no double substracting. Moreover, shouldn't the change in other assets be added/substracted from investing activities?
Thanks for explaining, Mr. Kenji. It makes me wanna know about you. Hope you're always fine. Can you tell me Which country do you come from?
Thanks for watching! From Spain (spanish father & japanese mother)
From where we can find the final excel file?
When you take the difference between share capital won’t be the divided paid be counted ? Why took it separately again as well ?
Hey kenji, you explain very clearly and your content is really good.
I have theoretical knowledge about financial modelling and valuations (but I don't understand when it comes to practically making Models) can you suggest best Books to learn about financial modelling, Valuations(Basic to advance) and Finance (Investment Banking related).
Jedi Master Kenji teaches another lesson in the ways of the Force.
hahah thank you!
Noticed for the movement in PPE, this doesnt seem 100% correct because the movement may be due to a revaluation of properties. So there would be a need to split out the fair valuation appreciation portion (not to be included). Right?
The gross PPE is essentially the book value and does not account for depreciation/appreciation, therefore you can use it to identify whether capital expenditure has been increased or not. Using net PPE would be incorrect if you do not add back the depreciation
Hi Kenji. I always watch your videos, thanks for explain really good. I'd like to know why you add short term debt in operating cash flow, I understood it was part of financing cash flow. Why it could be?
thanks so much
Yes you're completely right, it should not be under working capital. Sorry about that and thanks for pointing it out :)
have a question or confusion here, Is this the correct way to subtract the previous year's value from the current year's value?
check WC heading , Accounts Receivable increased in 2021 then why would be figuring it out to be as negative change?
A question: why didn't we include accumulated depr in investing activies?
Hi pls help me I need to figure it out why increase in inventory in company balance sheet will go in Cash Flow only but not under purchases in Trading and P&L account and reduce net/gross profit accordingly ?
Example company:
Sir what is the monthly salary of investment banker
hey i was analyzing a company's cash flow statement and the changes in current assets reported on cash flow statement does not correspond to the change in current assets on the balance sheet. how to go about this thing?
Why we did not deduct Interest payment $289 in our Financing ? Subscribed, Thank you!
U can do it, if u r doing it u have to add back interest in operating activities
Hello sir, im really confused where to account contingency fund in cash flow it is separated account from cash in assets
But in ledger you cannot account it anywhere..
So where does contingency fund go with??
The capital????
Question for You Kenji.... I noticed that you did not include the Net Income in your calculation for Change in Cash. Is that an error?
Short-term debt is not a working capital item, net working capital refers to non - cash and non-debt items
Yes completely right, added a correction on the comments. Thanks for pointing it out :)
do we really need cash flow statements? i mean our system has all cash movements recorded and we have income statements, expense trends, capex, BS packs which automatically tells us all movements in cash + the ending balances. please answer my question cz i am really confused. thank you in advance :)
Hi there Kenji , what could your recommend me (from your courses )… I’m civil engineer and for this 2023 year I would like to do like an investment for my company.. buying an excavator… so what could I do … like a project finance for the company trying to figure out my incomes and outcomes…? Thank you looking forward your reply
I have a question here. Depreciation that we are adding back is 744 whereas the movement in Accumulated depreciation is 360. What could be the reason of difference? How our cash flow is tallying without considering this difference?
Yes i think u r correct. BS will tally as Cash figure in CFS is taken an hit from (744-360) depreciation and Cash figure in BS is just from CFS
Did you reduce form the balance statement and income statement?
Interview? I have to build this for a job interview?
lol it would be for a final round interview yeah haha (obviously not all companies do this specific case study though)
Hello Kenji... I want to ask here... Now all business were done in online which is all transaction were paid via bank... Is it consider as cash flow?
Yes. In accounting, Cash refers to Physical or Banked cash
Kenji, so do all cash flow statements show no original information? Everything in cash flow statement can be built from balance sheet and income statement?
Yes! It shows the change which is kinda new information but the inputs are still all from BS and IS
I downloaded Free Excel file but it can not be opened . Keep showing errors. Is it still available?
Kenji, may I ask why you ignored Accounts payable, Taxes payable and Other Current liabilities?
Sorry, I missed that you did it in Cashflow from operating activities (in Working capital). Thanx for a good video!
download link doesn't work anymore :((
Yeah, but what good it does if, for example, Net income is not categorised? Also, income is booked when invoice is written. Is there is income booked, it does not mean that money was received.
If someone can help with the depreciation, i'd really appreciate. The cashflow uses 744 as depreciation and amortization whereas the Balance sheet shows 4800 and 5160. Where does the 744 come from?
It comes from the income statement. Balance sheet only shows depreciation, not amortization. Income statement shows both, that's why.
I think it's a mistake, since in video cash balance is taken from CFS, Balance sheet is matching.
Practically Cash Balance would be physically verified and same will be considered in BS.
In this scenario, Closing cash is being affected by the difference in depreciation in Balance sheet and Income statement
The excel file is not the same used in the video
view.flodesk.com/pages/62da585cc9d3abbafd6c44b5
Kenji you are great but very fast Man you need to slow down
But you're not teaching me how to make the template in the first placeT-T
short term debt is not a working capital item
Yes you're completely right, it should not be under working capital. Added a comment to correct that. Thanks for pointing it out :)
Why to derive..can't you take an example as to how you arrived correctly!!!!
First!
lol
dont you need to concern on payment of tax in cash. You got net income after tax and interest and you didn't concern about the tax and interest payment in term of cash.
The Total of Change in Cash from Cash Flow Is Wrong It is been equal to 8145
CF from investing activity is negative 1k
Your soosmart and handsome
Hello sir, im really confused where to account contingency fund in cash flow it is separated account from cash in assets
But in ledger you cannot account it anywhere..
So where does contingency fund go with??
The capital????