Learn the building blocks of a financial model. In this video, we’ll build a cash flow statement given an income statement and balance sheet in Excel.
To download the Excel template that goes with this video, go to
The accounting here is a simplified presentation of how the three major financial statements are inter-related and lays the foundation of financial statement models in investment banking.
Many accounting questions that we see time and again in finance interviews are designed to test the understanding explained in this exercise. .
Images related to the topic financial cash flow
Financial Modeling Quick Lesson: Cash Flow Statement (Part 1)
Search related to the topic Financial Modeling Quick Lesson: Cash Flow Statement (Part 1)
#Financial #Modeling #Quick #Lesson #Cash #Flow #Statement #Part
Financial Modeling Quick Lesson: Cash Flow Statement (Part 1)
financial cash flow
See all the latest ways to make money online: See more here
See all the latest ways to make money online: See more here
Thank you
What do you do if your first year is zero? Starting from scratch?
Never believed it was real until hackerpayfer@gmail.com surprised me with the transfer of $30,000.
so basically you using indirect method right?
You said we need a 2 periods statement to build a cash flow. What if it's the first year of the business? Does it mean you can't make a cash flow statement or does it work different?
Hi, im from Mexico, Can someone explain me all this financial terms? Im accountant too, but i want to learn how USA work in accountability. I really want to lear to increace my knoledge. I can explain some mexican accountability too.
Thanks for providing a link to the template!
Deferred taxes are shown in the balancesheet as long term item but considered in the cash flow statement under operating activities.
Can u kindly clarify.
Digf
Are financial models like the one in your video what interviewers in finance job interviews ask about?
Hi Thanks for your Video. But Please can I present cash flow with just one year's statement. No Prior year
Hey I didn’t see you record PP&E under CFI. I can understand that Capex serves the same purpose but then I saw another uploader deduct pp&e(there it’s listed as “purchase of land and equipment” which I understood as pp&e, the same item on your worksheet) directly under cfi without calculating/even mentioning Capex so I’m very very confused…there’s a difference of depreciation between Capex and gross pp&e so idk when i should use Capex and when to directly use pp&e…
Why the other current liability are not considered?
I think there is an error, cash flow should start with profit from operation with no deduction of tax expenses
Excellent explanation, learnt much
Excellent presentation!
So this is what a financial model is? Statements on an excel sheet? I am an undergrad so, sorry for ignorance.
can you give me this excel sheet?? please
Sir why havent you accounted income tax payable in cash flow statement?
Great video!
Excellent
can anyone suggest me which is the best institute to learn financial modeling
need to be so patient
😀 HOLY CRAP IT MAKES SENSE.
!- can i have CF from day 1 ? because its seems like we can have both income St and BS from day 1 but CF not because we need other data to compare its with, for example year 1 and year 2 or QTR 1 and 2, am i right?
2- if we can start from day one how can we do that? as we don’t have info ? as there is only one data of inventory for example not 2 to compare,
thanks
Awesome Explanation
Can someone who's is familiar with the matter explain to me, why "depreciation&amortization" is taken as a inflow of cash from operations? As I understand, d&a represent how much less your inventories are worth over a period of time. Thus, it does not generate cash at all, and can potentially subtract an amount.
In other words why it's positive instead of negative?
P.S: very nice and useful tutorial/walkthrough. Keep on doing good work. 🙂
I was calculating a cash flow statement and there was something called comprehensive income on the balance sheet which accounted for changes in unrealized gains on available for sale investments. If I didn't include this amount, the change in cash wouldn't tie out…but I don't get it because it's only a balance sheet item and never hits the income statement or involves a cash transaction. Help!!
why do you add depreciation & amortization instead of depreciation & amortization net of tax?
Nice job! Understood everything
why some people try to make this sort of modeling using VBA and macros
i 'm just tring to understand the idea of macros
because as i see a a fixed formula can make the task no mater if we change datas on balance sheet or income statement
can someone explain me please
Excellent presentation with clear logic behind the accounting principles and interlink between the three financial statements. Very easy to follow!!
Seems to work fine – try to refresh your page.
Video starts at 6:00
Hi Gary,
The link is active – some browsers have a problem downloading excel files directly so try to right click over the link and select "Save Target As'…that should do it, but let me know if you still have a problem.
Any chance of having an example worksheet. I used the hyperlink an it states 'page not found'. Would it be possible to send me a copy or post online? Good explanation and good tutorial. I am undertaking my MBA and this has helped immensely. Cheers Gary
to*
Thank you!
Thanks!
First-rate tutorial – You explained it infinitely better than my university lecturer
Sir,
I was so thrilled 2 c all 3 statements on a single excel sheet. That is so impressive and makes the CFS e-z 2understand. Its something i had in mind for quite some time.
A million thanks for the same.
Also, thank u 4 taking the trouble 2 prepare all this, that i would like 2use 2practice.
Also, a lot of explaining nicely&clearly done, step-by-step, in just 12 minutes.
Graćias & blessing$.