From the course: Financial Modeling Foundations

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Three-statement financial model

Three-statement financial model

From the course: Financial Modeling Foundations

Start my 1-month free trial Buy for my team

Three-statement financial model

“

- [Instructor] Alright, it's time to jump in with our three statement financial model. I'm in the 02_03_Begin Excel file. Now what you see here is we've set up our assumptions on the top. We've got our income statement down here, our balance sheet, and our statement of cash flows. And I've just kind of done some of the basics here to kind of get us started in terms of the structure. But you'll note that we have 2021 data and then we have partially filled data for other years. Now, all of this is historical. In other words, we're not making a projection about what the 2023 revenue is. That's an actual number, right? Same thing with the 2021 revenue. COGS expenses. Again, we don't have to estimate what that's going to be. We know what it was. So we are going to then go through and use this actual data to come up with certain key metrics that will then be used later on for our forecast. So in particular, we wanna…

Contents