From the course: Excel: Financial Modeling with Dynamic Arrays

Unlock this course with a free trial

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

Income statement

Income statement - Microsoft Excel Tutorial

From the course: Excel: Financial Modeling with Dynamic Arrays

Start my 1-month free trial Buy for my team

Income statement

“

- [Instructor] Now that we've finished building the schedules, we can make a start on our financial statements. And I'm going to begin with the income statement. And it is simply going to be a matter of pulling through the different components onto the income statement. And we should find that we have already calculated most of what we need in the operations, calculations, or in the schedules. So jumping back into our model, we'll go to the FinStat tab now. And again, you can see we've got our month and our indexation help a row across the top. We've also got the months already there for us, and it's just a matter of pulling through all of the pieces. So we'll start with the revenue and we should be able to find this on our Operations tab just here. And we then have our expenses down here. And we can just take our revenue less our expenses, make sure that you put the hash at the end. It would be very easy to forget that. So let's put the hash at the end there. And we can also pull…

Contents