Home » Financial Modeling Quick Lesson: Cash Flow Statement (Part 1) financial cash flow

Financial Modeling Quick Lesson: Cash Flow Statement (Part 1) financial cash flow



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.

See also  How to Bid Tender on EGP? part-2 e tender financial bid opening

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)

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

See also  Biodiversity, the trillion dollar problem plaguing leaders today | Moral Money financial times

41 thoughts on “Financial Modeling Quick Lesson: Cash Flow Statement (Part 1) financial cash flow”

  1. 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?

  2. 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…

  3. !- 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

  4. 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. 🙂

  5. 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!!

  6. 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

  7. 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.

  8. 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

  9. 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$.

Leave a Reply

Your email address will not be published.