Welcome back to the Wall Street Prep Quick Lesson Series!
In this video, we’ll build a cash flow statement given an income statement and balance sheet in Excel. 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.
Ready to Model? Before diving in to the videos below, be sure to download this lesson’s Excel model template: Cash Flow Statement template.