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.
The Cash Flow Statement, Video 1
The Cash Flow Statement, Video 2
The Wall Street Prep Quicklesson Series
7 Free Financial Modeling Lessons
Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.