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.

Build the income statement

Build the income statement

From the course: Financial Modeling Foundations

Start my 1-month free trial Buy for my team

Build the income statement

“

- [Instructor] So now that we've set up the basic structure for our three-statement financial model, we're ready to go through and begin building out the income statement. I'm in the 02_04_Begin Excel file. All right, so we've built out our assumptions up top, and we've got the basic structure of our model. Now, let's go through and build this income statement. Okay, so we have the historical values for Revenue, COGS, Expenses, et cetera. We need to go through and calculate certain items that have been left out. All right, well, I've got as an example, Total Operating Expenses. What is that gonna come from? Well, it's going to be the sum of our COGS, SG&A, Research & Development, and other Unusual Expenses. Now, notice that we don't have a gross profit line in here. We could, we could have gross profit in here, we just don't have it. Certain income statements are gonna differ slightly, but I'm gonna carry these Total…

Contents