Login
Self-Study Courses
Virtual Boot Camps
Corporate Training
On-Campus Training
Free Articles & Videos
Support/Contact Us
About Wall Street Prep
Quick Lesson: Cash Flow Statement, Part 1
Learn the building blocks of a financial model
In this video, we’ll build a cash flow statement model 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.
Before we begin … Download the free Excel template
Comments
X
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.
It was really helpful!
Good job.
Thanks for sharing, you are a smart and generous professional.
Pretty cool. Much appreciated.
Very helpful. Thank you.
Thanks for posting this. Great lesson.
Please send me the Excel document models you use in your tutorials.
Thank you.
Thank you.
Great resource, thanks for sharing your expertise 😉
Does this not double-count Depreciation? Once in the early add-back for D&A and once in accounting for Cash from Investing?