From the course: Excel for Finance: Building a Three-Statement Operating Model

FP&A in Excel?

- [Instructor] Have you ever been working on a financial model and realized, "My balance sheet doesn't balance, my statement of cash flows doesn't reconcile," or worse, "There's something wrong and I don't even know what it is." This is actually a far too common challenge when building financial models but thankfully it doesn't have to be. Hey, I'm Chris, and trust me, I've been there. So today I'm going to show you how to build three statement models the right way. Building financial models isn't just about Excel skills. What it's really about is building a tool to help make strategic business decisions. That's FP&A. So whether you're a season to finance pro or just someone looking to break into the industry, this course will teach you top to bottom how to build an industrial grade FP&A operating model in Excel, it's got the three statements, EBITDA, working capital, accruals, CapEx, depreciation as well as a debt schedule, cash flow sweep, and covenants. So don't learn the hard way like I did ,get it right the first time. Let's get started.

Contents